EasyPopulate 4.0 Support Thread

[mc12345678]

Thanks mc, that worked. I updated the EP database, exported Stock of items with attributes including SBA, corrected quantities, uploaded, imported, and all stock with attributes updated correctly. All files were identified as csv by EP. Thanks for all your work on zen cart, it is very much appreciated.

No problem, glad that it worked... Wondering what needs to be done to "better" identify the need to do that update... The link is normally not present and only shows under specific conditions... I suspect it could be more "flashy" but also is something that should be executed after uploading updated files... :/

[eavinu]

I am having an issue with ZC 1.5.7c and EP 4.0.37.13.
I have tried to import categories from 1.3.9h in several languages and got the result "File uploaded Successfully: CategoryMeta-EP2021-08-24-121946.csv Issues with the CSV file delimiter(s)"
Lower in the EP page in the table it says "CSV Unknown Delimiter" and "Import Error".
So I tried to remove all the languages from the categories CSV and left only the main language which is EN and again tried to upload and I get the same result.
Have checked the file in OO and also in Notepad++ to make sure of the delimiter etc'.

Both ZC and EP are latest versions and on SG hosting.
Any ideas?

[mc12345678]

I am having an issue with ZC 1.5.7c and EP 4.0.37.13.
I have tried to import categories from 1.3.9h in several languages and got the result "File uploaded Successfully: CategoryMeta-EP2021-08-24-121946.csv Issues with the CSV file delimiter(s)"
Lower in the EP page in the table it says "CSV Unknown Delimiter" and "Import Error".
So I tried to remove all the languages from the categories CSV and left only the main language which is EN and again tried to upload and I get the same result.
Have checked the file in OO and also in Notepad++ to make sure of the delimiter etc'.

Both ZC and EP are latest versions and on SG hosting.
Any ideas?

Is there a link in the upper right hand corner of the EP4 screen indicating to update/upgrade or just the remove/uninstall link? If update/upgrade is available select that first then review the condition of reporting about the CSV delimiter.

To help narrow down the issue(s), may I suggest the following test(s):
Create a file using one of the "export" options: Does the CSV Unknown Delimiter issue occur? If so, then it is a problem with the EP4 software.
The CSV file that has been generated, mentioned that using Open Office or similiar, is the file being stored (saved as and following additional action to ensure that the encoding is UTF-8) as a UTF-8 format file (not having a BOM)?
When viewing the CSV file, what are the first 4 lines of text? (These are used to evaluate the likelihood that the CSV delimiter has been properly applied/used.

[eavinu]

Is there a link in the upper right hand corner of the EP4 screen indicating to update/upgrade or just the remove/uninstall link? If update/upgrade is available select that first then review the condition of reporting about the CSV delimiter.

To help narrow down the issue(s), may I suggest the following test(s):
Create a file using one of the "export" options: Does the CSV Unknown Delimiter issue occur? If so, then it is a problem with the EP4 software.
The CSV file that has been generated, mentioned that using Open Office or similiar, is the file being stored (saved as and following additional action to ensure that the encoding is UTF-8) as a UTF-8 format file (not having a BOM)?
When viewing the CSV file, what are the first 4 lines of text? (These are used to evaluate the likelihood that the CSV delimiter has been properly applied/used.

I tried several versions of export and the same error occurs.
There is no update/upgrade, only uninstall.

First 4 rows look fine, the exported files are UTF-8 without BOM...

[mc12345678]

I tried several versions of export and the same error occurs.
There is no update/upgrade, only uninstall.

First 4 rows look fine, the exported files are UTF-8 without BOM...

To confirm, when say tried several versions of export and to be sure that we are each talking about the same thing (no assumptions) please identify what was done to perform the export(s). I know it sounds silly, but sometimes the difference/solution is in the communication.

So, what delimiter is identified in your configuration settings and what delimiter is being used? I have seen some systems where the export file includes a delimiter that was unexpected/unrequested. Also hate to say this, but the question was what do the first four rows include, as in please provide the first four rows for an independent review. While it may appear correct by one individual's review, extra eyes help find the issue.

Furthermore I'm not able to repeat the issue with 1.5.7 nor 1.5.8, though both are on the same server/host, one with php 7.4 the other 8.0.

[eavinu]

To confirm, when say tried several versions of export and to be sure that we are each talking about the same thing (no assumptions) please identify what was done to perform the export(s). I know it sounds silly, but sometimes the difference/solution is in the communication.

So, what delimiter is identified in your configuration settings and what delimiter is being used? I have seen some systems where the export file includes a delimiter that was unexpected/unrequested. Also hate to say this, but the question was what do the first four rows include, as in please provide the first four rows for an independent review. While it may appear correct by one individual's review, extra eyes help find the issue.

Furthermore I'm not able to repeat the issue with 1.5.7 nor 1.5.8, though both are on the same server/host, one with php 7.4 the other 8.0.

I failed to say that the DB is actually an import from 1.3.9h that is on Godaddy hosting (10 years old) and the installation is fresh 1.5.7c files and I did DB upgrade with zc_install of course.
I then saw an issue with the encoding for Hebrew, it was showing gibberish both in the DB and in the storefront while in the old website it showed gibberish in the DB but showed Hebrew in the storefront.
Then I started trying to resolve by only exporting and importing the categories_description table to see it it helps and still had gibberish instead of Hebrew.
I asked for assistance from Eran Ariel (eranariel) The Zenner that published the Hebrew UTF-8 ZC language pack and he suggested to try going with latest version of EP and then I installed EP4 on both installations.
After exporting from the old one and importing to the new one I realized this error.
I went over all the parameters and also inspected the exported categories file and everything looked okay.
Then I decided to check what happens if I export a file from the new website and try to import it back to the new website, I get the same error.
The error in the table shows after exporting and not only when importing.

To answer your questions, under "Category Export/Import Options" I chose Model/Category at first, later I also tried Categry with Meta Tags.
I also tried full export under Filterable Exports.
First 4 rows of category file:

v_products_model,v_categories_name_2,v_categories_name_3,v_categories_name_4,v_c ategories_name_5,v_categories_name_6,v_categories_name_7,v_categories_name_9,v_c ategories_name_10,v_categories_name_11,v_categories_name_12,v_categories_name_13 ,v_categories_name_1
"MG02","Round Herb Grinders^Metal grinders","Round Herb Grinders^Metal grinders","Round Herb Grinders^Grinders de metálico","Round Herb Grinders^Metal grinders","Round Herb Grinders^Metal grinders","Round Herb Grinders^Metal grinders","Round Herb Grinders^Metal grinders","Round Herb Grinders^Metal grinders","Round Herb Grinders^Metal grinders","Round Herb Grinders^Metal grinders","Round Herb Grinders^Metallmühlen","Round Herb Grinders^Metal grinders"
"MG08","Round Herb Grinders^Metal grinders","Round Herb Grinders^Metal grinders","Round Herb Grinders^Grinders de metálico","Round Herb Grinders^Metal grinders","Round Herb Grinders^Metal grinders","Round Herb Grinders^Metal grinders","Round Herb Grinders^Metal grinders","Round Herb Grinders^Metal grinders","Round Herb Grinders^Metal grinders","Round Herb Grinders^Metal grinders","Round Herb Grinders^Metallmühlen","Round Herb Grinders^Metal grinders"
"MG05","Round Herb Grinders^Metal grinders","Round Herb Grinders^Metal grinders","Round Herb Grinders^Grinders de metálico","Round Herb Grinders^Metal grinders","Round Herb Grinders^Metal grinders","Round Herb Grinders^Metal grinders","Round Herb Grinders^Metal grinders","Round Herb Grinders^Metal grinders","Round Herb Grinders^Metal grinders","Round Herb Grinders^Metal grinders","Round Herb Grinders^Metallmühlen","Round Herb Grinders^Metal grinders"

I just clicked now to export the file and I also have a new line added to the table below in the EP4 page that has this export file name and says CSV Unknown Delimiter and Import Error, I didn't try to upload and import this file...

[mc12345678]

That's the useful information that helps...

So a couple of things. One it would appear that probably need to convert the database to utf8/utf8mb4, though that may may/not correct the issue in total. Other things of "interest" would be the collation on the admin/catalog side as identified for the language being used at least on the admin side. E.g., is English being used for the admin or one of the other "foreign" languages? Another thing, is that as I recall (need to search a little more) I thought that with Hebrew, there was possibly some alternate effort needed. Not quite the same as Japanese or Russian, but similar... There is some guidance about what needed to be done differently within EP4 and/or one's server possibly 20 pages back? It was "recently" discussed and by recent in this case I mean within the last year...

It was discussed by an individual that has been busy updating/modifying code to support Japan so even looking up the Japanese language pack may find the individual and from there look at their posting history to see when/where posted to EP4 (or perhaps they are happily in receipt of this message and can pop in to provide some assistance though there is a "process" by which they may/may not see the message(s) right now.)

To me, what is curious though is that basically all languages use the "same" category names... I would have thought that there would have been more of a translation.

So, short summary, good to know that the database was "upgraded" using zc_install (hopefully did not run into issues that stopped updating of the configuration table which can be tested by attempting to update a configuration option of any setting, if there is a sql error then there is likely some additional "work" to be done/redone).
Next has to do with character encoding of the database and system. Then there is possibly some additional action to address languages; however, there is the discussion that creating a new CSV file has also exhibited a CSV delimiter issue... Again as an assumption, I believe the above provided data is from the CSV that was generated by EP4. The next thing to consider is if there is a "system" issue by generating a new CSV file directly (one line of data would be suggested in a single language) and attempting upload and import... Would suggest again posting the contents of that file here; however, this time please use the [CODE][/CODE] tags generated by pressing the # button in the message box while generating the post.

[eavinu]

So I am happy to say that finally the Unknown CSV Delimiter issue was solved.
I don't know why I didn't try this before...
At first, since this was an upgraded website and had previous versions of EP (1.2....), there was a temp folder in the root and I left it there, changed in the EP4 configuration to false under Uploads directory Admin/Catalog.
Now I decided to move it to the Admin folder and changed the configuration to True and the Unknown CSV Delimiter indication turned to a "CSV ," indication.

So now I only need to deal with the other issue that I discovered today, going through checkout timesout... doesn't matter which shipping method or payment method is being chosen.
Hope to find the correct thread to get help with that LOL

Thanks a lot mc12345678 for your efforts.
Regards,
Eran

[eavinu]

To me, what is curious though is that basically all languages use the "same" category names... I would have thought that there would have been more of a translation.

So actually they have a lot of products and categories and many of them are not fully translated to all languages, this is actually why they decided to drop a few languages now so making my job a bit easier :)

[eavinu]

So now I only need to deal with the other issue that I discovered today, going through checkout timesout... doesn't matter which shipping method or payment method is being chosen.
Hope to find the correct thread to get help with that LOL
Eran

So I can now report that I found the error for that one as well (checked Debug logs), the issue was sending emails so I cancelled the email sending options for now since there is no point in trying to configure that while still in SG staging area and not under the correct domain...