EasyPopulate 4.0 Support Thread

mc12345678:

Sorry for the significant delay.

Obtain latest copy from: GitHub - mc12345678/EasyPopulate-4.0 at CSV-delimiter-catalog-message-correct

The direct zip file download link is: https://github.com/mc12345678/EasyPopulate-4.0/archive/refs/heads/CSV-delimiter-catalog-message-correct.zip

Then load files, Access menu and perform install.
Then, go to configuration->EasyPopulate 4
Change setting for "Import Language Override" - language_code_only

to any other value.
Ok,Thank you very much .
And the code maybe too naughty，i upload a data file,and import 268 items,then display error:
SKIPPED! - v_products_model: 20230710269 - No category provided for this new product importing with: language_code_only
SKIPPED! - v_products_model: 20230710270 - No category provided for this new product importing with: language_code_only
........

sure i have tried to check the data in file,sure it right,and there imported more items with same category,but it stop and display this error now.
and i sure i have try to fix any data file,and it always display this error,and i sure i have checked the category and it in my shop.
maybe have quantitative restriction in code?:D

For your first problem:

mc12345678:

Then, go to configuration->EasyPopulate 4
Change setting for "Import Language Override" - language_code_only

to any other value.

For example, change "Import Language Override" from language_code_only to language_id_only

targetmarts:

Ok,Thank you very much .
And the code maybe too naughty，i upload a data file,and import 268 items,then display error:
SKIPPED! - v_products_model: 20230710269 - No category provided for this new product importing with: language_code_only
SKIPPED! - v_products_model: 20230710270 - No category provided for this new product importing with: language_code_only
........

sure i have tried to check the data in file,sure it right,and there imported more items with same category,but it stop and display this error now.
and i sure i have try to fix any data file,and it always display this error,and i sure i have checked the category and it in my shop.
maybe have quantitative restriction in code?:D

For second problem: Please identify the fields in your import file. The fields are the first row of the file. For example: v_products_model

It is possible that the file is too large to import all at once. There is a split option to allow making multiple smaller files from a single large file. I do not believe the file size is the problem. I received a copy of your debug log. When I know the field names, I expect I can determine a solution.

mc12345678:

For your first problem:

For example, change "Import Language Override" from language_code_only to language_id_only

For second problem: Please identify the fields in your import file. The fields are the first row of the file. For example: v_products_model

It is possible that the file is too large to import all at once. There is a split option to allow making multiple smaller files from a single large file. I do not believe the file size is the problem. I received a copy of your debug log. When I know the field names, I expect I can determine a solution.

yes,i have do all as you said,and update one row file also show error.

targetmarts:

yes,i have do all as you said,and update one row file also show error.

Your upload file. Please post the first row.

Also, please post the configuration settings of EP4.

mc12345678:

Your upload file. Please post the first row.

Also, please post the configuration settings of EP4.

sorry to reply so later.

Easy Populate 4
Title Value Action
Uploads Directory temp/
Uploads Directory Admin/Catalog true Info
Import/Export Primary Key products_model Info
Import Language Override language_code_only Info
Import/Export CSV Delimiter , Info
Export Language Identifier id Info
Export Price Decimals 2 Info
Upload File Date Format m-d-y Info
Default Raw Time 09:00:00 Info
Export Filename Date Y-m-d Info
Upload/Download Prices Include Tax false Info
Update Check 1 Info
Verbose Feedback true Info
Show all EP4 Filetypes with Files true Info
Replace Blank Image false Info
Activate Blank Featured true Info
Remove Blank Specials negative Info
Make Zero Qty Products Inactive false Info
Smart Tags Replacement of Newlines true Info
Advanced Smart Tags false Info
Auto-extend fields false Info
Debug Logging true Info
Maximum Quantity Discounts 0 Info
Split On Number of Records 2000 Info
Script Execution Time 60 Info
Convert Curly Quotes, etc. 0 Info
Convert Character 0x92 1 Info
Enable Products Meta Data 1 Info
Enable Products Music Data 0 Info
User Defined Products Fields Info
Export URI with Prod and or Cat 0 Info

Here is the first line of data in the file ：
v_products_model v_products_type v_products_image v_products_name_1 v_products_description_1 v_products_url_1 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_1 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_1 v_metatags_keywords_1 v_metatags_description_1

targetmarts:

sorry to reply so later.

Easy Populate 4
Title Value Action
Uploads Directory temp/
Uploads Directory Admin/Catalog true Info
Import/Export Primary Key products_model Info
Import Language Override language_code_only Info
Import/Export CSV Delimiter , Info
Export Language Identifier id Info
Export Price Decimals 2 Info
Upload File Date Format m-d-y Info
Default Raw Time 09:00:00 Info
Export Filename Date Y-m-d Info
Upload/Download Prices Include Tax false Info
Update Check 1 Info
Verbose Feedback true Info
Show all EP4 Filetypes with Files true Info
Replace Blank Image false Info
Activate Blank Featured true Info
Remove Blank Specials negative Info
Make Zero Qty Products Inactive false Info
Smart Tags Replacement of Newlines true Info
Advanced Smart Tags false Info
Auto-extend fields false Info
Debug Logging true Info
Maximum Quantity Discounts 0 Info
Split On Number of Records 2000 Info
Script Execution Time 60 Info
Convert Curly Quotes, etc. 0 Info
Convert Character 0x92 1 Info
Enable Products Meta Data 1 Info
Enable Products Music Data 0 Info
User Defined Products Fields Info
Export URI with Prod and or Cat 0 Info

Here is the first line of data in the file ：
v_products_model v_products_type v_products_image v_products_name_1 v_products_description_1 v_products_url_1 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_1 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_1 v_metatags_keywords_1 v_metatags_description_1

Change: Import Language Override language_codeonly Info
To: Import Language Override languageid_only Info

Or any other value.

I will use the provided information to solve the other problem.

mc12345678:

Change: Import Language Override language_codeonly Info
To: Import Language Override languageid_only Info

Or any other value.

I will use the provided information to solve the other problem.

Thank you,and i have inserted it.great help

mc12345678:

Change: Import Language Override language_codeonly Info
To: Import Language Override languageid_only Info

Or any other value.

I will use the provided information to solve the other problem.

Another question: How to set up support for special characters? Because when there are special characters or Chinese characters in the data, the plugin automatically truncates the following characters. For example, if the title is "fashion clothing wear 《freeshipping》", the plugin will generate the product title for" fashion clothing wear".
Thanks,hope your help again.

New again user...
Got ZC installed, EP4 installed..no hiccups.

Formatted my CSV file from source data from a Shopify workflow, and ready to imports...cant:

Filename: ZC1.csv

SKIPPED! - v_products_model: 000-043-010-00 - No category provided for this new product
SKIPPED! - v_products_model: 000-043-204-94 - No category provided for this new product
SKIPPED! - v_products_model: 000-043-306-04 - No category provided for this new product
SKIPPED! - v_products_model: 000-044-000-04 - No category provided for this new product

Man..it LOOKS good..ive used OpenOffice to save this file as well as Excel, same issue in both worlds.

The noted category does in fact exist, I sense no issues, yet..there is an issue.

Im at the end of "learning" in the thread and in google for the moment..been a few hrs digging away at it.

TY for your time.

gemohler:

New again user...
Got ZC installed, EP4 installed..no hiccups.

Formatted my CSV file from source data from a Shopify workflow, and ready to imports...cant:

Filename: ZC1.csv

SKIPPED! - v_products_model: 000-043-010-00 - No category provided for this new product
SKIPPED! - v_products_model: 000-043-204-94 - No category provided for this new product
SKIPPED! - v_products_model: 000-043-306-04 - No category provided for this new product
SKIPPED! - v_products_model: 000-044-000-04 - No category provided for this new product

Man..it LOOKS good..ive used OpenOffice to save this file as well as Excel, same issue in both worlds.

The noted category does in fact exist, I sense no issues, yet..there is an issue.

Im at the end of "learning" in the thread and in google for the moment..been a few hrs digging away at it.

TY for your time.

Do your settings look something like: https://www.zen-cart.com/showthread.php?190417-EasyPopulate-4-0-Support-Thread&p=1396195#post1396195 ?
Does the issue go away when the direction of three part that followed is performed? (https://www.zen-cart.com/showthread.php?190417-EasyPopulate-4-0-Support-Thread&p=1396197#post1396197)

The values are the same except for #Records that I increased. (Ill be doing massive uploads and I have bare metal and resources)

I just made the change to "language_id_only"

And THAT works. :)

And yup, those 5 worked..and a test of 5600 more just fine.

TY

Duplicate. :(

And then this happens.

Saved from open office, no changes other than a few 100k things added to the spreadsheet.

In this example, row 1 works.
Row 2 does not work.

They are functionally identical.

General EP question.

While doing a large import, apache is taking a lot of resources...

What is the WWW server doing during an import that makes IT so busy?

gemohler:

General EP question.

While doing a large import, apache is taking a lot of resources...

What is the WWW server doing during an import that makes IT so busy?

One thing that is happening while importing is that basically empty characters are being sent to the browser to keep the connection alive. The historical suggestion was to split large files into snake chunks. As development of the software continued, this alternative was implemented. The quantity or load may possibly be reduced. Though to date I believe this is the first such feedback received.

I'm not sure yet what characteristic would be best to monitor to reduce that traffic, whether a time, number of iterations or start value from either would be "ideal". Of course other ideas are welcome.

mc12345678:

One thing that is happening while importing is that basically empty characters are being sent to the browser to keep the connection alive. The historical suggestion was to split large files into snake chunks. As development of the software continued, this alternative was implemented. The quantity or load may possibly be reduced. Though to date I believe this is the first such feedback received.

I'm not sure yet what characteristic would be best to monitor to reduce that traffic, whether a time, number of iterations or start value from either would be "ideal". Of course other ideas are welcome.

Ya..I mean, it doesnt break anything, but 75% of a CPU for apache2 is...busy.

On the lookout for things I need to know as I relearn the ZC environment.

Im doing EP4 imports, and I have a log file getting hammered with this (attached)

gemohler:

And then this happens.

Saved from open office, no changes other than a few 100k things added to the spreadsheet.

In this example, row 1 works.
Row 2 does not work.

They are functionally identical.

Is there a mistake in the above writing? The image suggests that the first does not work and the second does. As far as the csv file, I usually ensure each field's content is surrounded by double quotes when saving the csv file from the workbook. While I was able to open that CSV file in a workbook to have the data in what looks like the appropriate fields, nothing specifically stands out visually as a problem.

When I get an opportunity I'll try running that file, but may be a bit.

mc12345678:

Is there a mistake in the above writing? The image suggests that the first does not work and the second does. As far as the csv file, I usually ensure each field's content is surrounded by double quotes when saving the csv file from the workbook. While I was able to open that CSV file in a workbook to have the data in what looks like the appropriate fields, nothing specifically stands out visually as a problem.

When I get an opportunity I'll try running that file, but may be a bit.

I may have got the text backwards, but the excel file is in the order of the import results.