EasyPopulate 4.0 Support Thread

[mc12345678]

EasyPopulate V4 - Version: 4.0.36.ZC with zen-cart-v1.5.6c

Import error:

MySQLi error 1364: Field 'categories_description' doesn't have a default valueWhen executing:
INSERT INTO categories_description SET 
                                        categories_id   = 2,
                                        language_id     = 1,
                                        categories_name = '1/12 SCALE FURNITURE'
MySQLi error 1366: Incorrect integer value: '' for column 'products_sort_order' at row 1
When executing:
INSERT INTO products SET
                            products_model                    = 'J0844MH',
                            products_type                     = 1,
                            products_price                    = '108.19', products_image            = 'J0844MH.jpg',
                            products_weight                    = 0.6,
                            products_discount_type          = 0,
                            products_discount_type_from     = 0,
                            product_is_call                 = 0,
                            products_sort_order             = '',
                            products_quantity_order_min     = 0,
                            products_quantity_order_units   = 0,
                            products_priced_by_attribute    = 0,
                            product_is_always_free_shipping    = 0,
                            products_tax_class_id            = 0,
                            products_date_available            = NULL, 
                            products_date_added                = '1970-01-01 10:00:00',
                            products_last_modified            = CURRENT_TIMESTAMP,
                            products_quantity                = 7,
                            master_categories_id            = 2,
                            manufacturers_id                = 1,
                            products_status                    = 0,
                            metatags_title_status            = 0,
                            metatags_products_name_status    = 0,
                            metatags_model_status            = 0,
                            metatags_price_status            = 0,
                            metatags_title_tagline_status    = 0

I tried this code from this patch https://github.com/mc12345678/EasyPo...n_import_patch
but import page did not load
I probably did not edit easypopulate_4_import.php correctly, the patch is different to the full file (not a full file)
maybe someone can edit code for easypopulate_4_import.php and send me link (attached file)

Import file:

v_products_model
v_products_image
v_products_name_1
v_products_description_1
v_products_url_1
v_specials_price
v_specials_last_modified
v_specials_expires_date
v_products_price
v_products_weight
v_last_modified
v_date_added
v_products_quantity
v_manufacturers_name
v_categories_name_1
v_categories_name_2
v_categories_name_3
v_categories_name_4
v_categories_name_5
v_products_type

J0844MH
J0844MH.jpg
George Washington Double End Desk - mahogany- 1:12 scale
<p>The George Washington  Double ended desk knee hole ,called a partners Desk hole desk has 3 drawers  on each side with a single long drawer in the centre. There are 3 faux  drawers on either end. The 8 legs are fluted and the drawers are decorated with  a ######## bead molding around all sides. the top of the desk has a shelf at both  ends. The desk measures 3 inches high x 6 inches wide x 2 and is available in  a mahogany finish.</p>
108.19
0.6
########
########
7
JBM Miniatures
1/12 SCALE FURNITURE
All 1/12 SCALE FURNITURE

1

J0844MH
J0844MH.jpg
George Washington Double End Desk - mahogany- 1:12 scale
<p>The George Washington  Double ended desk knee hole ,called a partners Desk hole desk has 3 drawers  on each side with a single long drawer in the centre. There are 3 faux  drawers on either end. The 8 legs are fluted and the drawers are decorated with  a ######## bead molding around all sides. the top of the desk has a shelf at both  ends. The desk measures 3 inches high x 6 inches wide x 2 and is available in  a mahogany finish.</p>
108.19
0.6
########
########
7
JBM Miniatures
1/12 SCALE FURNITURE
1/12 SCALE FURNITURE BY ROOMS
STUDIES


1

When following that link, on the right side of the screen are three dots. At least in Microsoft edge when clicking on the three dots a dropdown menu is presented which includes to view the file. That takes you to: https://github.com/mc12345678/EasyPo...e_4_import.php

From there you can get the "Raw" file which is just the text of the file that can then be copied and pasted as appropriate. That location is: https://raw.githubusercontent.com/mc...e_4_import.php

And there is a short explanation of navigating GitHub. :)

But understand that any other changes/tweaks that may have been applied and are not in the file at that point/location will be overwritten if this file is used in its entirety instead of just incorporating the changes that were shown in the original link.