EasyPopulate 4.0 Support Thread

[mc12345678]

I am doing a clean install of 2.0.0 and my old 1.5.7c (thought it was d but that is wrong lol). I have the following KEYS listed in the database. Do I need to remove these before upgrading? I would rather get this all working right and just installing a new EP after.

Thought I had responded to this, but it is obvious I did not. Not sure how just throw two keys remained in the database. I would have expected that an uninstall at the version that added them or beyond would have also removed them. Further without reviewing the installation steps, I'm not sure if or what issues might occur (e.g., other settings get loaded but to a different configuration menu, log generated because of attempted duplicate).

I do see though that you've reported performing a clean install, so this serves more of an acknowledgement to the question. I would have removed those two additional remnants before attempting a (re)install and investigated why they remained or were present.

Oh, and your database may have been 1.5.7d because issue of that version didn't actually update the version designation. File comparison would have been best to validate.

[g2ktcf]

Thought I had responded to this, but it is obvious I did not. Not sure how just throw two keys remained in the database. I would have expected that an uninstall at the version that added them or beyond would have also removed them. Further without reviewing the installation steps, I'm not sure if or what issues might occur (e.g., other settings get loaded but to a different configuration menu, log generated because of attempted duplicate).

I do see though that you've reported performing a clean install, so this serves more of an acknowledgement to the question. I would have removed those two additional remnants before attempting a (re)install and investigated why they remained or were present.

Oh, and your database may have been 1.5.7d because issue of that version didn't actually update the version designation. File comparison would have been best to validate.

I did a database only upgrade on a test site at my host this morning. So, I have a native 2.0.1 install without all the old files. After installing Mod List I worked to find all the outdated configuration keys and pages. I found WAY more than those 2 for some odd reason this time. Mod List now shows only what is installed so I am making progress.

Thanks!

[Pingfah]

Zen Cart 1.5.6
Easy Populate 4.0.36.ZC
PHP versions tried 5.6, 7.1, 7.3
MySQL 8.0.37

Having a very strange problem, when I upload my products file, EP says it has been imported successfully, it spits out all the products in green in the list at the bottom and says they have all been created correctly, but in reality I only have one product visible on the website, it contains the Product Model, Image, Price & Min Order Quantity, from the product in the first row of the CSV, and the rest of the details (Name & Description) are populated from the product in the final row of the CSV file. The product has been added to every category that is listed in the Category column, so if I have 100 products across 20 categories, I am ending up with one product visible in 20 categories.

If I actually look in the MySQL database at the Products table, all the products are there. If I look at the Product Description table, the products are absent with the exception of the one product from the final row that it puilled the description from. The product ID is the product ID from the product that was in the first row of the CSV file.

Importantly, if I export the existing products on the site using EP, delete them all using EP, and then reupload the file I exported, it works properly and imports all the products correctly.

I have tried every version of UTF I can think of, using Notepad++ to convert to UTF8, nothing has worked so far. I have also tried uploading the file with double quotes around every value (matching how the EP export files look), but this does not work either.

I have not touched the site or EP version in a few years, this has started happening recently seemingly spontaneously. I know the host has upgraded the MySQL to version 8 recently. The PHP version changes sometimes, but I have tried reverting to multiple older versions with no luck. I have also tried uploading last year's data file, which worked last year, but this presents with the same problems.

[g2ktcf]

So I started a new clean install of ZC 2.0.1

I have removed all the legacy configurations from the database and installed EP 4.0

I am getting the warning about opening the log file. However, the configuration EAYPOPULATE_4_CONFIG_TEMP_DIR does not exist. AND, there is no Easy Populate in the configuration menu. I have verified that all the files from Github did copy over.

If I try and load the Easy Populate Tools, I get a 500 error. Thoughts?

[g2ktcf]

So I started a new clean install of ZC 2.0.1

I have removed all the legacy configurations from the database and installed EP 4.0

I am getting the warning about opening the log file. However, the configuration EAYPOPULATE_4_CONFIG_TEMP_DIR does not exist. AND, there is no Easy Populate in the configuration menu. I have verified that all the files from Github did copy over.

If I try and load the Easy Populate Tools, I get a 500 error. Thoughts?

I have found zero logs for this. I have looked through ZC's logs and the only thing there is the debug log related to not finding the temp directory. The server error logs show ZERO errors.

ZC 2.0.1 Database only upgrade
Mod List
Image Handler
Bootstrap
Clone a Template
OPC

this is hosted on a sandbox server where the site address is site.host.com if that makes any difference. This is my last full test before going live.

[Pingfah]

Zen Cart 1.5.6
Easy Populate 4.0.36.ZC
PHP versions tried 5.6, 7.1, 7.3
MySQL 8.0.37

Having a very strange problem, when I upload my products file, EP says it has been imported successfully, it spits out all the products in green in the list at the bottom and says they have all been created correctly, but in reality I only have one product visible on the website, it contains the Product Model, Image, Price & Min Order Quantity, from the product in the first row of the CSV, and the rest of the details (Name & Description) are populated from the product in the final row of the CSV file. The product has been added to every category that is listed in the Category column, so if I have 100 products across 20 categories, I am ending up with one product visible in 20 categories.

If I actually look in the MySQL database at the Products table, all the products are there. If I look at the Product Description table, the products are absent with the exception of the one product from the final row that it puilled the description from. The product ID is the product ID from the product that was in the first row of the CSV file.

Importantly, if I export the existing products on the site using EP, delete them all using EP, and then reupload the file I exported, it works properly and imports all the products correctly.

I have tried every version of UTF I can think of, using Notepad++ to convert to UTF8, nothing has worked so far. I have also tried uploading the file with double quotes around every value (matching how the EP export files look), but this does not work either.

I have not touched the site or EP version in a few years, this has started happening recently seemingly spontaneously. I know the host has upgraded the MySQL to version 8 recently. The PHP version changes sometimes, but I have tried reverting to multiple older versions with no luck. I have also tried uploading last year's data file, which worked last year, but this presents with the same problems.

I am unable to edit the post now, but I should add that if I switch to Product ID as the primary key, all these problems go away.

All CSV files have been created in Open Office with recommended settings.

[mc12345678]

I am unable to edit the post now, but I should add that if I switch to Product ID as the primary key, all these problems go away.

All CSV files have been created in Open Office with recommended settings.

Well, a couple of things.

First, apologies that 4.0.36 did not include some of the "error" checking that would likely have helped identify that using the products_id as a primary key may have been necessary (as compared to desired?).

There have been newer versions generated to address/correct the lack of the primary key value/data being present along with some other notifications so that do not have a false positive of success.

One thing that I didn't ask for was, what field headers were present in the file having an issue as compared to one that didn't. Then another was if the new file had unescaped special characters that possibly could have affected the import evaluation.

That it seems that no changes what-so-ever were made in the underlying code or the import file (meaning same ZC version, same EP4 version, same previous import file) seems to mean that either MySQL version and/or PHP version changed to a value affecting the code operation. Suggestion might be to compare two CSV files, the working and not working one(s) to see what other differences might exist causing the issue of basically the product table data getting imported to the correct area(s), but the products description table seems to only take the description (and therefore things like products_name) only were imported basically against the last product. To me, that aligns more with the issue of missing data associated with the chosen primary key or that all those affected have the same primary_key value.

Glad though that it seems a fix was found. As far as a log, generally, if EP4 logging is turned on, then a log that might get generated assuming a loggable event occurred would be in the debug log in the EP4 import/export file directory or added to it if it already existed.