EasyPopulate 4.0 Support Thread

[groovypockets]

I think you might be onto something actually with the UTF8 thing. The product descriptions are full of special character issues after I upgraded to 1.5.5a. The client does use MS Excel even though I've advised them not to. However, in the older version of EP we were able to work out a workflow that allowed them to use MS Excel.

Anyhow when creating the copy of the db I accepted the defaults for encoding and coalition. I'm not even sure what the system defaults are for either. I'm going to try an upgrade explicitly defining these before importing the db and executing the upgrade. I'll post back here when I get there with my findings. Good to know it's expected to work in 1.5.5a. Thanks for the quick response!

[mc12345678]

I think you might be onto something actually with the UTF8 thing. The product descriptions are full of special character issues after I upgraded to 1.5.5a. The client does use MS Excel even though I've advised them not to. However, in the older version of EP we were able to work out a workflow that allowed them to use MS Excel.

Anyhow when creating the copy of the db I accepted the defaults for encoding and coalition. I'm not even sure what the system defaults are for either. I'm going to try an upgrade explicitly defining these before importing the db and executing the upgrade. I'll post back here when I get there with my findings. Good to know it's expected to work in 1.5.5a. Thanks for the quick response!

There are some filters included/incorporated here as well. There are some Internet instructions about how to "truly" export a csv file from Excel which involves several steps when I last looked at it. Otherwise from report by others it can be done from Excel. When I was doing some testing a long while back the biggest heartache was the date format and converting/setting it to the php format of YYYY-MM-DD (which BTW, is a great sequence to support sorting by date). Anyways, Excel tends to offer date/time in a more "convenient" format for example xx Mon YY or Mon xx, YY.

I do plan to add the ability to switch to tab delimitation from within the admin in the near future, but in the mean time you could modify the variable at the top of admin/easypopulate_4.php to use "\t" instead of ","

A lot of different options, just some things have been left in the background instead of adding all types of "features"

[keith z]

Using Easy Populate 4.0.28 - Beta 01-03-2015. I have over 25K items in my inventory. While attempting to download my complete inventory file I get the error message

[an error occurred while processing this directive]

Refresh the screen with same result. When I go back I find 2 files of different file sizes - 10885815 and 10370426. When looking at these files some of my newly added items with Easy Populate are missing. To get those I must use the filters when downloading. When I download those smaller files everything works ok.

I also cannot use the search to find these newly added items. The wesbsite search for customers works fine. If I want to make a change to the listing I must pick pages and go up or down to find the item.

[mc12345678]

Using Easy Populate 4.0.28 - Beta 01-03-2015. I have over 25K items in my inventory. While attempting to download my complete inventory file I get the error message

[an error occurred while processing this directive]

Refresh the screen with same result. When I go back I find 2 files of different file sizes - 10885815 and 10370426. When looking at these files some of my newly added items with Easy Populate are missing. To get those I must use the filters when downloading. When I download those smaller files everything works ok.

I also cannot use the search to find these newly added items. The wesbsite search for customers works fine. If I want to make a change to the listing I must pick pages and go up or down to find the item.

What is the characterset for your database, in your includes/configure.php, in your includes/languages, etc?

EP4 uses UTF-8, using/having Latin-xxxx or other such character sets may cause the search issue identified.

The "error" is related to processing time. There is a setting in the configuration window for this as well I believe ZC has a similar setting (overrides or attempts to override the php.ini assignment). Because the category is smaller than the entire catalog this is why such "individual" downloads are successful. And yes, a "second" download tends to be created with a separate time stamp in the filename. The missing "newly" uploaded EP4 items from the download is because the new items have a higher products_id than the point at which the timeout occurs and therefore not included in the large single file download.

Another factor of consideration was the extent of content upload.

[keith z]

What is the characterset for your database, in your includes/configure.php, in your includes/languages, etc?

EP4 uses UTF-8, using/having Latin-xxxx or other such character sets may cause the search issue identified.

The "error" is related to processing time. There is a setting in the configuration window for this as well I believe ZC has a similar setting (overrides or attempts to override the php.ini assignment). Because the category is smaller than the entire catalog this is why such "individual" downloads are successful. And yes, a "second" download tends to be created with a separate time stamp in the filename. The missing "newly" uploaded EP4 items from the download is because the new items have a higher products_id than the point at which the timeout occurs and therefore not included in the large single file download. From the configuration/Easy Populate 4 screen.

Another factor of consideration was the extent of content upload.

From the easy populate screen - Internal Character Encoding: ISO-8859-1 DB Collation: latin1. From the file includes/configure.php - define('DB_CHARSET', 'latin1'). From includes/languages, etc. I cannot help because you file not give a file name and I do not know where to look for etc.

I have changed the Script Execution Time to 100000 seconds. No change as the error screen still comes up when downloading the complete inventory file.

[mc12345678]

The other language file would be either:
Includes/languages/YOUR_LANGUAGE/YOUR_TEMPLATE/locale.php
Or
Includes/languages/YOUR_LANGUAGE/locale.php
Or English in place of YOUR_LANGUAGE in the above order of precedence.

Have you considered converting your database to utf-8 using the plugin db2utf8? Is this something your business target could support or is latin1 required to support operation?

[keith z]

The other language file would be either:
Includes/languages/YOUR_LANGUAGE/YOUR_TEMPLATE/locale.php
Or
Includes/languages/YOUR_LANGUAGE/locale.php
Or English in place of YOUR_LANGUAGE in the above order of precedence.

Have you considered converting your database to utf-8 using the plugin db2utf8? Is this something your business target could support or is latin1 required to support operation?

Includes/languages/YOUR_LANGUAGE/YOUR_TEMPLATE/locale.php - not found
Includes/languages/YOUR_LANGUAGE/locale.php - not found

Have you considered converting your database to utf-8 using the plugin db2utf8? Is this something your business target could support or is latin1 required to support operation? - I do not know how to do that.

Here is another post https://www.zen-cart.com/showthread....e-NOT-in-Admin

This is were I first noticed the problem. Thank you!

[mc12345678]

Another place to try to set the timer for ZC is in configuration->My Store->Admin Set max_execution_time for processes (default is 60).