EasyPopulate 4.0 Support Thread

[kernheimer]

you are totaly cute! i can speak and read fluendly german and even grew up there a big time of my childhod, but I really am very Dutch
thanks so much, Danke sehr herzlichen dank.

Macht nichts. Sie sollten der Software von: https://github.com/mc12345678/EasyPopulate-4.0 benutzen. Es gibt ein versionnen autocheck, Sie deaktivieren muessten. Normalerweisse, hat webchills information daran.

[mc12345678]

you are totaly cute! i can speak and read fluendly german and even grew up there a big time of my childhod, but I really am very Dutch
thanks so much, Danke sehr herzlichen dank.

Thank you for your understanding.

I guessed that German might be understood. I should have asked, but wanted to help quickly.

If you have translations for the plugin, please feel free to add on github.

[kernheimer]

I would love to try to translate to Dutch, ( we don't have a good 1.5.7. version yet, i'm working on it also) but i need to understand what you meen with the version check beeing disabled. I have no idea where to look for that.

Thank you for your understanding.

I guessed that German might be understood. I should have asked, but wanted to help quickly.

If you have translations for the plugin, please feel free to add on github.

[mc12345678]

I would love to try to translate to Dutch, ( we don't have a good 1.5.7. version yet, i'm working on it also) but i need to understand what you meen with the version check beeing disabled. I have no idea where to look for that.

The statement was made based on using the German provided version of Zen Cart. In the German provided Zen Cart the version check option is disabled/removed.

With the removal of the version check software in the German Zen Cart, older versions oF EasyPopulate V4 would generate errors because it does try to check the US/Canada Zen Cart site for newer versions.

I know I wanted to make EP4 easier for use when installed. I need to look to see if I did anything to make it easier. Otherwise, I know I have seen some discussion in the following forum group about how to use this version of EP4 with the ZC provided by webchills: https://www.zen-cart-pro.at/forum/fo...-Easy-Populate

So, question is does it work now or are there still problems?

[denniskle]

The store admin accidentally deleted a complete product category and asked me to fix this. The latest database backup available is three weeks old, so instead of restoring the complete database, I figured I could use EasyPopulate to
1) Export the category after restoring the backup. I intend to do this on a local copy of the website (xampp) that I currently have runnin because of a recent upgrade after years of not working with Zen Cart.
2) Import the export file into the live site.

I never worked with EP before so I tested it first on the locally running site by
1) Creating an export of a product category. This seems to work.
2) Deleting said product category. This obviously works.
3) Importing the export. This does not work. The bar at the top displays "File Import Completed," but the import report at the bottom says

Import Results

Filename: Full-EP2021-02-14-093948.csv

Finished Processing Import File

Updated records: 0
New Imported records: 0
Errors Detected: 0
Warnings Detected: 0
Memory Usage: 5638888
Memory Peak: 6571048
Execution Time: 0 seconds.

To make things simpler, I created a new category of 1 level with only one product. I exported this category, then deleted the product (but kept the category), then tried to import with the same result. The export file looks like this:

v_products_model,v_products_type,v_products_image,v_products_name_2,v_products_description_2,v_products_url_2,v_products_name_8,v_products_description_8,v_products_url_8,v_specials_price,v_specials_date_avail,v_specials_expires_date,v_products_price,v_products_weight,v_product_is_call,v_products_sort_order,v_products_quantity_order_min,v_products_quantity_order_units,v_products_priced_by_attribute,v_product_is_always_free_shipping,v_date_avail,v_date_added,v_products_quantity,v_manufacturers_name,v_categories_name_2,v_categories_name_8,v_tax_class_title,v_status,v_metatags_products_name_status,v_metatags_title_status,v_metatags_model_status,v_metatags_price_status,v_metatags_title_tagline_status,v_metatags_title_2,v_metatags_keywords_2,v_metatags_description_2,v_metatags_title_8,v_metatags_keywords_8,v_metatags_description_8
"","1","","test","beschrijving","","test","description","","","","","9.92","0","0","0","1","1","0","0","","2021-02-14 09:39:04","0","Anemoontje","pakketjes","pakketjes","19","1","0","0","0","0","0","","","","","",""

I use ZC version 1.5.7b and the latest EP from the github link from the plugins page.

Thanks in advance for any help!

[mc12345678]

So first thing is that the product (at least as shown in this one record) does not have a products_model assigned to it. Not a requirement in all situations, but in a default install, products_model is the primary key. Blank means don't do anything with it. Appears would be good to have notification of that situation/issue.

So... what can be done to at least restore the product? Go back to the original state of the database and as far as EP4 is concerned, adjust the configuration settings to use the primary key of products_id. Then export the product within that category to use that data for recreation of the product to have the exact same products_id that it previously had. *NOTE* this is one place where care and understanding about the condition and status of the destination database must be taken and known. You don't want to *also* mess up a product that already exists.

Now, as to the true "recreation" of the category (which appears to be the original intent), will also need to export category files in addition to the product files provided above.

The process followed so far is expected to simply create the place holder for the category. But the category will have nothing really in it. No category description for example. Further, because there are at least two languages involved, will want to be sure that the appropriate information is carried in each of the languages within the category...

[denniskle]

Thank you for your quick reply! Setting the primary key to product_id makes everything work as expected. I will have to check whether problems arise with existing product_ids. Not sure whether ID's are recycled, but if not there should not be a problem because the source DB is a backup of the destination DB. I will continue on this tomorrow.

Thank you for the tip about recreation of the categories too. I didn't figure that would be necessary.