EasyPopulate 4.0 Support Thread

mc12345678:

Are you able to tell when you downloaded the software? The above content visually looks right. I'm wondering if there was a logic error in the version obtained where the error was displayed for a file that met the conditions and not when it didn't.

I tried 2 nights ago with a fresh download and compared it to an 11-2018 download with same results.

I posted back in April 2018 with the same problem. I fixed it by using an older version I had. The Zencart version was on 1.5.5, either e or f .
I no longer have that older version so I cannot revert to that one.

Is there a specific PHP version this has to run on?

I just tested the current zip on github with a clean install of 1.5.6a and it still shows the same import error.

Luckily, I found the older version that works is still available in the plugin section of the forum.

This one still works fine and works with 1.5.6a.
EasyPopulate V4 - Version: 4.0.36.ZC

The version on GIT HUB Easy Populate 4.0.37.6 - 02-08-2017 does not work and has the import error.
If you have time maybe you can look into this issue and find what is the problem.

In the meantime the solution for anyone with the same problem is to use the version listed above.

wtfbbq:

Luckily, I found the older version that works is still available in the plugin section of the forum.

This one still works fine and works with 1.5.6a.
EasyPopulate V4 - Version: 4.0.36.ZC

The version on GIT HUB Easy Populate 4.0.37.6 - 02-08-2017 does not work and has the import error.
If you have time maybe you can look into this issue and find what is the problem.

In the meantime the solution for anyone with the same problem is to use the version listed above.

I do have a number of updates to push to the github version, and as I said, I believe that there was at one point a reverse logic applied to the file check. I've added two significant features that I need to be sure to test before posting the full change to the ZC site. One is using the admin sanitization during import of the file data, another is the use of identifying a language by its two letter designation instead of using its languages_id, while maintaining the possibility of the old method. Ie. Once again expanding on the capability to maximize existing processes.

Not sure if I purposefully left that issue as the current load or not. Wouldn't put it past me to do that so that the use of the incomplete code wouldn't bungle someone's database. I can take the heat for there being software that doesn't "do" anything better than it knowingly messing up someone's database.

In the last week, there have been at least two posts about difficulty with importing files. The message import error appears where the import button typically is. In both cases the files to be imported have had a space in the filename.

It is recommended that filenames not include spaces. I intend to see what it would take to support a filename having a space, even if that is a method to rename the file.

I have v 1.5.5D we will be upgrading to 1.5.6 soon. what I want to do is change shipping weights on items in bulk for different product types, will this mod able me to do that? Also, I see that a lot of people are saying that the new version doesn't work right, so I should download EasyPopulate V4 - Version: 4.0.36.ZC is this correct?Thank you =)

WiccanWitch420:

I have v 1.5.5D we will be upgrading to 1.5.6 soon. what I want to do is change shipping weights on items in bulk for different product types, will this mod able me to do that? Also, I see that a lot of people are saying that the new version doesn't work right, so I should download EasyPopulate V4 - Version: 4.0.36.ZC is this correct?Thank you =)
It would be possible to use this to make bulk edit of shipping weight by product type (need to filter on product type and then make the desired change(s)). I'm not sure I follow with the versioning issues. This plugin EasyPopulate Version 4 is currently offered as version 4.0.36.ZC. There is an update being worked on on github, which is to be released shortly after a little more testing is done. There also is a patch for the current EP4 version which is discussed within the last few posts.

mc12345678:

It would be possible to use this to make bulk edit of shipping weight by product type (need to filter on product type and then make the desired change(s))

You can use this to easily update the weight of products. It's one of the columns in the csv, so download, edit the values and import.

Zen Cart 1.5.6 & Easy Populate 4.0.36.ZC bug uploading non latin UTF-8 characters

Multilingual with English and Hebrew characters:

1. I am able to download a CSV file in which characters in both languages appear correctly
2. On the upload of the CSV file, the English characters are correctly updated and added to the database , HOWEVER with Hebrew, text strings are cut short after the following two characters: "ג" (Gimmel) and "ע" (Ayn). The Hebrew language is RTL or written right to left.

If I have a product name "עגביות מספר 1" (tomato number 1), all of the text to the left of the character "ע" is omitted once uploaded. The same applies to category names.

I have been looking at the code easypopulate_4_import.php, and it contains reference to the mb_split function, however it isn't clear why only categories names to mention that the problem I am having persists on category names as well. Could the utf-8 conversion of smart-quotes, em-dash, and ellipsis be interfering in some manner?

I have contributed the Hebrew language packages a while ago that I intend to update shortly.

Thanks in advance,

Eran Ariel

Been trying to think about this. Need to look at the language pack to see its settings as relates to the database along with the returned data associated with the plugin. Note that generally speaking, as written mb_split and the other mb_ functions only really comes into play when utf8 is involved.

Would need to trace down execution about what happens to the imported text to see what operation is truncating it. I have seen that Russian also has had a similar issue.

Does the same problem occur in the product description or is it only in the product and category names?

The problem occurs in both, the product and category names. Here is some code from the easy populate import file:

foreach ($langcode as $lang) {
if (!function_exists('mb_split')) {
// iso-8859-1
$categories_names_array[$lang['id']] = explode($categories_delimiter,$items[$filelayout['v_categories_name_'.$lang['id']]]);
} else {
// utf-8
$categories_names_array[$lang['id']] = mb_split(preg_quote($categories_delimiter), $items[$filelayout['v_categories_name_' . $lang['id']]]);
}

eranariel:

The problem occurs in both, the product and category names. Here is some code from the easy populate import file:

foreach ($langcode as $lang) {
if (!function_exists('mb_split')) {
// iso-8859-1
$categories_names_array[$lang['id']] = explode($categories_delimiter,$items[$filelayout['v_categories_name_'.$lang['id']]]);
} else {
// utf-8
$categories_names_array[$lang['id']] = mb_split(preg_quote($categories_delimiter), $items[$filelayout['v_categories_name_' . $lang['id']]]);
}
The question also asked about other fields such as products_description, is that field also affected?

Since you already have the language installed and having this issue, perhaps you could run a few tests for me.

Could you modify a portion of the above code to the following:

            } else {
            // utf-8
              $categories_names_array[$lang['id']] = mb_split(preg_quote($categories_delimiter), $items[$filelayout['v_categories_name_' . $lang['id']]]);
trigger_error('category: ' . $items[$filelayout['v_categories_name_' . $lang['id']]] . ' category array: ' . print_r($categories_names_array[$lang['id']], true), E_USER_WARNING);
            }

Then import at least one line of product information that contain the character(s) involved.
After import check the logs directory for a myDebug-adm-xxxx file generated at about the time of attempting to import.
Post the contents of the file, but omit or rename the admin directory (can use admin as the folder name).

Expectation if all is correct on the server is information related to the category name. If nothing is generated, then that too is a piece of useful information and will have to work backwards a little.
Note when posting the contents, please use ```
[CODE][/CODE]

Yes, I will try...and thank you

And yes, the question relates to all fields, however this is the only reference in the respective file that relates to the mb_split function.

OK, I tested with the edited code on one product, which didn't upload to its respective category. Below is the log file:

[19-Feb-2019 21:20:10 America/Chicago] Request URI: /admin/easypopulate_4.php, IP address: 67.86.152.229
#1  fgetcsv() called at [public_html/admin/easypopulate_4_import.php:44]
#2  include_once(/public_html/admin/easypopulate_4_import.php) called at [/public_html/admin/easypopulate_4.php:289]
--> PHP Warning: fgetcsv() expects parameter 1 to be resource, null given in /public_html/admin/easypopulate_4_import.php on line 44.

eranariel:

OK, I tested with the edited code on one product, which didn't upload to its respective category. Below is the log file:

[19-Feb-2019 21:20:10 America/Chicago] Request URI: /admin/easypopulate_4.php, IP address: 67.86.152.229
#1 fgetcsv() called at [public_html/admin/easypopulate_4_import.php:44]
#2 include_once(/public_html/admin/easypopulate_4_import.php) called at [/public_html/admin/easypopulate_4.php:289]
--> PHP Warning: fgetcsv() expects parameter 1 to be resource, null given in /public_html/admin/easypopulate_4_import.php on line 44.

That appears to be caused by a an issue with the file. Specifically that is expected to be the case if the file is considered not there, specifically can occur with 4.0.36.ZC if the filename would be sanitized by strict sanitization by the ZC software because the appropriate sanitizer code has not yet been incorporated to the distribution.

So, I recommend using a filename that is very similar to what was provided on export, no spaces, no special characters. Afterall, this issue just reported appears different than what we are trying to work.

v1.5.5f php 7.1

I have the same products on different sites (.com and ccTLD) - the only difference is the description varies for each site, all else is the same (part number, image file etc.).

Question: can I do a full EP export from the master site, then delete all columns except for part number, quantity and status (in stock/out of stock) and then import that modified file into a second site such that it modifies/updates ONLY the Quantity and Status of a Part Number and maintains everything else in the database as it is/was?

cheers, Mike

shags38:

v1.5.5f php 7.1

I have the same products on different sites (.com and ccTLD) - the only difference is the description varies for each site, all else is the same (part number, image file etc.).

Question: can I do a full EP export from the master site, then delete all columns except for part number, quantity and status (in stock/out of stock) and then import that modified file into a second site such that it modifies/updates ONLY the Quantity and Status of a Part Number and maintains everything else in the database as it is/was?

cheers, Mike
If by part number you mean products_model or products_id where whichever is used is unique (different for every product) then yes.

Where two rows of data have the same master key (products_model or products_id by default), the last one that is discovered will become the current information for all product that have that same master key.

mc12345678:

If by part number you mean products_model or products_id where whichever is used is unique (different for every product) then yes.

Where two rows of data have the same master key (products_model or products_id by default), the last one that is discovered will become the current information for all product that have that same master key.

Many thanks MC

Good

I appended all categories and would like to add categories to csv, but when I added the file and do import, give me the error described below:

SKIPPED! - Category ID: 1,"","Adapter","","Adaptadores","","","","","","","","0" - Not Found!

And the csv file contains what is described below:

v_categories_id,v_categories_image,v_categories_name_1,v_categories_description_1,v_categories_name_3,v_categories_description_3,v_metatags_title_1,v_metatags_keywords_1,v_metatags_description_1,v_metatags_title_3,v_metatags_keywords_3,v_metatags_description_3,v_sort_order
1,"","Adapter","","Adaptadores","","","","","","","","0"

I would like a help, thanks.