vandiermen:
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/EasyPopulate-4.0/compare/mc12345678:v4.0.36.ZC...v4.0.36-categories_description_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:
> ```
[TABLE="width: 1280"]
[TR]
[TD="width: 64"]v_products_model[/TD]
[TD="width: 64"]v_products_image[/TD]
[TD="width: 64"]v_products_name_1[/TD]
[TD="width: 64"]v_products_description_1[/TD]
[TD="width: 64"]v_products_url_1[/TD]
[TD="width: 64"]v_specials_price[/TD]
[TD="width: 64"]v_specials_last_modified[/TD]
[TD="width: 64"]v_specials_expires_date[/TD]
[TD="width: 64"]v_products_price[/TD]
[TD="width: 64"]v_products_weight[/TD]
[TD="width: 64"]v_last_modified[/TD]
[TD="width: 64"]v_date_added[/TD]
[TD="width: 64"]v_products_quantity[/TD]
[TD="width: 64"]v_manufacturers_name[/TD]
[TD="width: 64"]v_categories_name_1[/TD]
[TD="width: 64"]v_categories_name_2[/TD]
[TD="width: 64"]v_categories_name_3[/TD]
[TD="width: 64"]v_categories_name_4[/TD]
[TD="width: 64"]v_categories_name_5[/TD]
[TD="width: 64"]v_products_type[/TD]
[/TR]
[TR]
[TD]J0844MH[/TD]
[TD]J0844MH.jpg[/TD]
[TD]George Washington Double End Desk - mahogany- 1:12 scale[/TD]
[TD="colspan: 5"]<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>[/TD]
[TD="align: right"]108.19[/TD]
[TD="align: right"]0.6[/TD]
[TD="class: xl63, align: center"]########[/TD]
[TD="class: xl63, align: center"]########[/TD]
[TD="align: right"]7[/TD]
[TD]JBM Miniatures[/TD]
[TD]1/12 SCALE FURNITURE[/TD]
[TD="colspan: 3"]All 1/12 SCALE FURNITURE[/TD]
[TD][/TD]
[TD="align: right"]1[/TD]
[/TR]
[TR]
[TD]J0844MH[/TD]
[TD]J0844MH.jpg[/TD]
[TD]George Washington Double End Desk - mahogany- 1:12 scale[/TD]
[TD="colspan: 5"]<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>[/TD]
[TD="align: right"]108.19[/TD]
[TD="align: right"]0.6[/TD]
[TD="class: xl63, align: center"]########[/TD]
[TD="class: xl63, align: center"]########[/TD]
[TD="align: right"]7[/TD]
[TD]JBM Miniatures[/TD]
[TD]1/12 SCALE FURNITURE[/TD]
[TD]1/12 SCALE FURNITURE BY ROOMS[/TD]
[TD]STUDIES[/TD]
[TD][/TD]
[TD][/TD]
[TD="align: right"]1[/TD]
[/TR]
[/TABLE]
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/EasyPopulate-4.0/blob/5b71a7e75ea7fe4a0aa175f124785e7507e28797/admin/easypopulate_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/mc12345678/EasyPopulate-4.0/5b71a7e75ea7fe4a0aa175f124785e7507e28797/admin/easypopulate_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.
