EasyPopulate 4.0 Support Thread

mc12345678:

To ensure a full understanding, could you please identify the version of EP4 installed and then possibly the configuration settings (don't need to know anything about the path used for the upload/download folder)? Please be specific about identifying the version by its reported value.

Additionally, have you been successful with updating other records that are language based but not Metatag related?

I just tested with a record using the v_products_name_1 and the v_metatags_keywords_1 fields. The v_products_name_1 updated correctly, and the v_metatags_keywords_1 did not update (field was blank to begin with).

We are currently on version:
Easy Populate 4.0.37.13 - 05-03-2021
Zen Cart 1.5.7d
PHP 7.4.30 (Zend: 3.4.0)

Screenshots of configs are attached.

DanMickle:

I just tested with a record using the v_products_name_1 and the v_metatags_keywords_1 fields. The v_products_name_1 updated correctly, and the v_metatags_keywords_1 did not update (field was blank to begin with).

We are currently on version:
Easy Populate 4.0.37.13 - 05-03-2021
Zen Cart 1.5.7d
PHP 7.4.30 (Zend: 3.4.0)

Screenshots of configs are attached.

Found the issue. Looks like additional effort to support independent update of each Metatag field hadn't been applied. E.g. on the call to minimize the number of columns in an import file or to support update of just one column, this set of data had been overlooked.

In the current code at least the title must be present, but, if all three Metatag fields are not provided, then the missing field(s) will be made blank.

In the interim to that being modified, suggestion is to include the title, description and keywords in the import file. For those that use software to read the content of this forum, the second image above showed an image of the file headers and one example of the attempted content. The headers were: v_products_model, v_products_name_1, and v_metatags_keywords_1.

In the course of this discussion, there has not been a statement that all three were attempted within a single file, so I can only assume that such had not been attempted and that the above is the issue. I have not yet run tests specific to that version and issue with a file that has all three fields that update the database. My response is based on reviewing the code while away from a computer.

mc12345678:

Found the issue. Looks like additional effort to support independent update of each Metatag field hadn't been applied. E.g. on the call to minimize the number of columns in an import file or to support update of just one column, this set of data had been overlooked.

In the current code at least the title must be present, but, if all three Metatag fields are not provided, then the missing field(s) will be made blank.

In the interim to that being modified, suggestion is to include the title, description and keywords in the import file. For those that use software to read the content of this forum, the second image above showed an image of the file headers and one example of the attempted content. The headers were: v_products_model, v_products_name_1, and v_metatags_keywords_1.

In the course of this discussion, there has not been a statement that all three were attempted within a single file, so I can only assume that such had not been attempted and that the above is the issue. I have not yet run tests specific to that version and issue with a file that has all three fields that update the database. My response is based on reviewing the code while away from a computer.

That worked like a charm! Thank you firstly for helping and secondly for having me dig deeper before just handing me the answer. The historical info I went over gave me a better picture of how the module (and ZC) works, and that will obviously help in the future. I appreciate all your time and help.

v1.5.7d easypopulate 4.0

I am trying to use easypopulate to bulk delete products but am having issues. The process I have used is;
downloaded Model/Price/Qty file
opened the file in open office (OpenCalc)
changed v_status for products showing 0 to 9 (assumption being 9 means delete product)
a) saved file as .odt and uploaded with no result (products did not delete) and no warnings
then
b) saved file as .csv and uploaded with no result (products did not delete) with warning problem with delimiters (??) - in saving as .csv the delimiters selected were comma (,) and double quotes (")

There are no error logs

Have I gone about this the right way or is there a better way to delete products in bulk?

cheers, Mike

shags38:

v1.5.7d easypopulate 4.0

I am trying to use easypopulate to bulk delete products but am having issues. The process I have used is;
downloaded Model/Price/Qty file
opened the file in open office (OpenCalc)
changed v_status for products showing 0 to 9 (assumption being 9 means delete product)
a) saved file as .odt and uploaded with no result (products did not delete) and no warnings
then
b) saved file as .csv and uploaded with no result (products did not delete) with warning problem with delimiters (??) - in saving as .csv the delimiters selected were comma (,) and double quotes (")

There are no error logs

Have I gone about this the right way or is there a better way to delete products in bulk?

cheers, Mike

update ... as soon as a file is exported it shows up as 'CSV Unknown Delimiter' in the table as an import error in admin/tools/EP4 ... see image ... any ideas as to why?

shags38:

update ... as soon as a file is exported it shows up as 'CSV Unknown Delimiter' in the table as an import error in admin/tools/EP4 ... see image ... any ideas as to why?

If I had my guess correctly, because when I added the file location protection to the code, I made a mistake about handling files stored in the catalog side of the store and then subsequently the patch provided in this forum was not applied.

This is further described at this post and the link within the quote of that post: https://www.zen-cart.com/showthread.php?190417-EasyPopulate-4-0-Support-Thread&p=1385422#post1385422

To be clear, your previous post does or does not still apply? There are other reasons for what may have been seen or described there.

mc12345678:

If I had my guess correctly, because when I added the file location protection to the code, I made a mistake about handling files stored in the catalog side of the store and then subsequently the patch provided in this forum was not applied.

This is further described at this post and the link within the quote of that post: https://www.zen-cart.com/showthread.php?190417-EasyPopulate-4-0-Support-Thread&p=1385422#post1385422

To be clear, your previous post does or does not still apply? There are other reasons for what may have been seen or described there.

Thanks for your response mc ... I updated admin/easypopulate_4.php with the code from github (using the above and below codes for verification my line numbers varied from that shown in the github but the code snippet was placed ti the correct sequence) .... but there is no change, i.e.
a) file when exported immediately shows in table as per figure previously posted with comment under 'import' tab "CSV Unknown Delimiter", and
b) upon uploading the file with data changes, clicking save in current format (v_status changed from '0' to '9' for about 100 products) this message appears in green across the top of the page "File uploaded Successfully: PriceBreaks-EP2022Aug05-104531.csv Issues with the CSV file delimiter(s)" - the exact same thing occurs in uploading an unmodified file, which would indicate that the exported file is the issue, not anything to do with modifying and reuploading?
c) products are not deleting ... ** the assumption here is that if the file was valid it would automativcally update the database (yes/no?)

downloaded files are opened in Open Office (OpenOffic Calc) and data changed in v_status column only then saved and upoladed. Because I need to change only v_status I have used only these file format requests Model/Price/Qty (with Specials) and Model/Price/Breaks (the latter to determine if the former file request was the issue)

The version installed is the LATEST downloaded from the EP4 plugin page - this is the configuration

Configuration Settings
Upload Directory: admin/temp/
Primary Key: products_model
Import Language Override: EASYPOPULATE_4_CONFIG_IMPORT_OVERRIDE
Verbose Feedback: TRUE
Split Records: 2000
Execution Time: 60
Convert Curly Quotes: No Change
Convert Char 0x92: Basic
Enable Products Metatags: 1
Enable Products Music: 0

Custom Products Fields
Product Short Descriptions: FALSE
Product Unit of Measure: FALSE
Product UPC Code: FALSE
Google Product Category: FALSE
Manufacturer's Suggested Retail Price: FALSE
Manufacturer's Advertised Price: FALSE
Group Pricing Per Item: FALSE
Exclusive Products Mod: FALSE
Stock By Attributes Mod: FALSE
CEON URI Rewriter Mod: TRUE
Dual Pricing Mod: TRUE

User Defined Products Fields:

Installed Languages
1-en: English
Default Language: 1-English
Internal Character Encoding: UTF-8
DB Collation: utf8mb4

Database Field Lengths
categories_name:64
manufacturers_name:32
products_model:32
products_name:64
products_url:255
artists_name:32
record_company_name:32
music_genre_name:32

shags38:

Thanks for your response mc ... I updated admin/easypopulate_4.php with the code from github (using the above and below codes for verification my line numbers varied from that shown in the github but the code snippet was placed ti the correct sequence) .... but there is no change, i.e.
a) file when exported immediately shows in table as per figure previously posted with comment under 'import' tab "CSV Unknown Delimiter", and
b) upon uploading the file with data changes, clicking save in current format (v_status changed from '0' to '9' for about 100 products) this message appears in green across the top of the page "File uploaded Successfully: PriceBreaks-EP2022Aug05-104531.csv Issues with the CSV file delimiter(s)" - the exact same thing occurs in uploading an unmodified file, which would indicate that the exported file is the issue, not anything to do with modifying and reuploading?
c) products are not deleting ... ** the assumption here is that if the file was valid it would automativcally update the database (yes/no?)

downloaded files are opened in Open Office (OpenOffic Calc) and data changed in v_status column only then saved and upoladed. Because I need to change only v_status I have used only these file format requests Model/Price/Qty (with Specials) and Model/Price/Breaks (the latter to determine if the former file request was the issue)

The version installed is the LATEST downloaded from the EP4 plugin page - this is the configuration

Configuration Settings
Upload Directory: admin/temp/
Primary Key: products_model
Import Language Override: EASYPOPULATE_4_CONFIG_IMPORT_OVERRIDE
Verbose Feedback: TRUE
Split Records: 2000
Execution Time: 60
Convert Curly Quotes: No Change
Convert Char 0x92: Basic
Enable Products Metatags: 1
Enable Products Music: 0

Custom Products Fields
Product Short Descriptions: FALSE
Product Unit of Measure: FALSE
Product UPC Code: FALSE
Google Product Category: FALSE
Manufacturer's Suggested Retail Price: FALSE
Manufacturer's Advertised Price: FALSE
Group Pricing Per Item: FALSE
Exclusive Products Mod: FALSE
Stock By Attributes Mod: FALSE
CEON URI Rewriter Mod: TRUE
Dual Pricing Mod: TRUE

User Defined Products Fields:

Installed Languages
1-en: English
Default Language: 1-English
Internal Character Encoding: UTF-8
DB Collation: utf8mb4

Database Field Lengths
categories_name:64
manufacturers_name:32
products_model:32
products_name:64
products_url:255
artists_name:32
record_company_name:32
music_genre_name:32

The latest file may be present but the updates to that version have not been executed. Obvious because of this line:
Import Language Override: EASYPOPULATE_4_CONFIG_IMPORT_OVERRIDE

In the upper right corner of that screen there should be a link offering to update the installation. After that is done then can talk about other aspects of operation.

mc12345678:

The latest file may be present but the updates to that version have not been executed. Obvious because of this line:
Import Language Override: EASYPOPULATE_4_CONFIG_IMPORT_OVERRIDE

In the upper right corner of that screen there should be a link offering to update the installation. After that is done then can talk about other aspects of operation.

So mc - updating the EP4 Database did the trick - for the life of me I didn't see that in any of the readme documents, must have missed it - live and learn I guess.

Again - many thanks for your help.

cheers, Mike

Hi Everyone,
I have a fresh softaculous install of zencart 1.58 and cannot get easypopulate to install. When I click under Admin/Tools I get a whitescreen and nothing happens.
Please let me know if there is anything that I can do?

merlin57:

Hi Everyone,
I have a fresh softaculous install of zencart 1.58 and cannot get easypopulate to install. When I click under Admin/Tools I get a whitescreen and nothing happens.
Please let me know if there is anything that I can do?

While auto installers typically introduce their own issues, I am not so sure that the softaculous installation is the cause. That said, I haven't yet tested any version of EP4 with zen Cart 1.5.8. That also said, other information would be helpful such as the php version involved, the origin of the version of EP4 installed and what the logs say related to the failed operation. Caution: before posting the log content, be sure to obscure data to remain private such as the admin folder name and anything else considered not appropriate to let the internet community see.

v1.5.5f with latest version Easy Populate 4.0.37.13 - 05-03-2021

I am trying to import a products file, CSV, which imports, i.e. the file shows on the Admin Easy Populate page and then after clicking the import box I get the green success statement / tick at the top of the page (successfully imported) however none of the data imports - see this error message;

Import Results

Filename: Products+to+add+to+cliponNETAU.csv
ERROR: Import file does not exist:/home/admin/cliponearrings.net.au/admin/temp/Products+to+add+to+cliponNETAU.csv

Finished Processing Import File

Updated records: 0
New Imported records: 0
Errors Detected: 0
Warnings Detected: 0
Memory Usage: 1247320
Memory Peak: 2422568
Execution Time: 0 seconds.

The file does actually exist in cliponearrings.net.au/admin/temp/Products+to+add+to+cliponNETAU.csv

I am getting a bunch of myDebug-admin errors that all seem to be related to the plugin_support.php - below is an example - the variation between then seems to be the 'line' number

[03-Nov-2022 10:11:16 Australia/Sydney] PHP Notice:  CURL error checking plugin versions:  in /home/admin/cliponearrings.net.au/includes/functions/plugin_support.php on line 41
[03-Nov-2022 10:11:16 Australia/Sydney] Request URI: /admin/easypopulate_4.php, IP address: 14.201.62.177
#1  trigger_error() called at [/home/admin/cliponearrings.net.au/includes/functions/plugin_support.php:41]
#2  plugin_version_check_for_updates() called at [/home/admin/cliponearrings.net.au/admin/easypopulate_4.php:374]

So needless to say I am stumped
cheers, Mike

shags38:

v1.5.5f with latest version Easy Populate 4.0.37.13 - 05-03-2021

I am trying to import a products file, CSV, which imports, i.e. the file shows on the Admin Easy Populate page and then after clicking the import box I get the green success statement / tick at the top of the page (successfully imported) however none of the data imports - see this error message;

Import Results

Filename: Products+to+add+to+cliponNETAU.csv
ERROR: Import file does not exist:/home/admin/cliponearrings.net.au/admin/temp/Products+to+add+to+cliponNETAU.csv

Finished Processing Import File

Updated records: 0
New Imported records: 0
Errors Detected: 0
Warnings Detected: 0
Memory Usage: 1247320
Memory Peak: 2422568
Execution Time: 0 seconds.

> 
> The file does actually exist in cliponearrings.net.au/admin/temp/Products+to+add+to+cliponNETAU.csv
> 
> I am getting a bunch of myDebug-admin errors that all seem to be related to the plugin_support.php - below is an example - the variation between then seems to be the 'line' number
> ```
[03-Nov-2022 10:11:16 Australia/Sydney] PHP Notice:  CURL error checking plugin versions:  in /home/admin/cliponearrings.net.au/includes/functions/plugin_support.php on line 41
[03-Nov-2022 10:11:16 Australia/Sydney] Request URI: /admin/easypopulate_4.php, IP address: 14.201.62.177
#1  trigger_error() called at [/home/admin/cliponearrings.net.au/includes/functions/plugin_support.php:41]
#2  plugin_version_check_for_updates() called at [/home/admin/cliponearrings.net.au/admin/easypopulate_4.php:374]

So needless to say I am stumped
cheers, Mike

Change the spaces in the filename to... well non-spaces. E.g, underscore, dash, squashed together, whatever... no extra effort was made to handle filenames with spaces.

shags38:

v1.5.5f with latest version Easy Populate 4.0.37.13 - 05-03-2021

I am trying to import a products file, CSV, which imports, i.e. the file shows on the Admin Easy Populate page and then after clicking the import box I get the green success statement / tick at the top of the page (successfully imported) however none of the data imports - see this error message;

Import Results

Filename: Products+to+add+to+cliponNETAU.csv
ERROR: Import file does not exist:/home/admin/cliponearrings.net.au/admin/temp/Products+to+add+to+cliponNETAU.csv

Finished Processing Import File

Updated records: 0
New Imported records: 0
Errors Detected: 0
Warnings Detected: 0
Memory Usage: 1247320
Memory Peak: 2422568
Execution Time: 0 seconds.

> 
> The file does actually exist in cliponearrings.net.au/admin/temp/Products+to+add+to+cliponNETAU.csv
> 
> I am getting a bunch of myDebug-admin errors that all seem to be related to the plugin_support.php - below is an example - the variation between then seems to be the 'line' number
> ```
[03-Nov-2022 10:11:16 Australia/Sydney] PHP Notice:  CURL error checking plugin versions:  in /home/admin/cliponearrings.net.au/includes/functions/plugin_support.php on line 41
[03-Nov-2022 10:11:16 Australia/Sydney] Request URI: /admin/easypopulate_4.php, IP address: 14.201.62.177
#1  trigger_error() called at [/home/admin/cliponearrings.net.au/includes/functions/plugin_support.php:41]
#2  plugin_version_check_for_updates() called at [/home/admin/cliponearrings.net.au/admin/easypopulate_4.php:374]

So needless to say I am stumped
cheers, Mike

Sorry for not addressing the other issue. For whatever reason the Zen Cart team changed the server name to support plugin version checks. A part exists in here from recent history about it. Also a future version of this plugin will perform the check only once per user while logged in. Hadn't been incorporated yet.

I, too, am getting a blank page with Easy Populate with 1.5.8. The error message I get is as follows:

--> PHP Fatal error: Uncaught Error: Cannot access private property queryFactory::$link in /home/public_html/test/admin/includes/functions/extra_functions/easypopulate_4_functions.php:625

Thanks for any help.

JNR345:

I, too, am getting a blank page with Easy Populate with 1.5.8. The error message I get is as follows:

--> PHP Fatal error: Uncaught Error: Cannot access private property queryFactory::$link in /home/public_html/test/admin/includes/functions/extra_functions/easypopulate_4_functions.php:625

Thanks for any help.

Yeah basically in the class declaration for asking the database to do something, one of the variables has been made private and no helper function has been provided for the variable declared at the following link.

https://github.com/zencart/zencart/blob/9910e3d1aa80466f9d59afb53ae494849a2bda8c/includes/classes/db/mysql/query_factory.php#L22

Could possibly apply the following untested change:

From

    private $link; // mysqli object

To

    public $link; // mysqli object

That again is to modify the catalog file: includes/classes/db/mysql/query_factory.php

Will generate a github issue after further evaluation of the situation. Obviously there are other ways to interface with the Zen Cart code which could include development or copying of the same class file for use with EP4, rewrite of EP4 code, additional code in the Zen Cart core code or perhaps the above change.

Thank you! That did the trick. Easy Populate works great now. I really appreciate the quick response.

JNR345:

Thank you! That did the trick. Easy Populate works great now. I really appreciate the quick response.

The log data helped. Before posting my proposed solution I looked through the history of that change and it almost looks like it was at to private or rather remained private because no core code accessed that class member from outside the class. Glad that it resolved that issue though.

mc12345678:

Change the spaces in the filename to... well non-spaces. E.g, underscore, dash, squashed together, whatever... no extra effort was made to handle filenames with spaces.

many thanks MC ... with filename change I get the file to upload and import but with error 'no category provided for this new item' - the category name column is complete for all entries - there are 194 products in the file, 36 are products that already exist on the site, 158 are 'new products' - the anomoly here is 'new products' - see the summary below. (new products data copied from another file from another site and added to this file - all columns are complete).

Not sure why it is not adding the new products??

Finished Processing Import File

Updated records: 36
New Imported records: 0
Errors Detected: 158
Warnings Detected: 0
Memory Usage: 1318792
Memory Peak: 1728704
Execution Time: 0 seconds.

shags38:

many thanks MC ... with filename change I get the file to upload and import but with error 'no category provided for this new item' - the category name column is complete for all entries - there are 194 products in the file, 36 are products that already exist on the site, 158 are 'new products' - the anomoly here is 'new products' - see the summary below. (new products data copied from another file from another site and added to this file - all columns are complete).

Not sure why it is not adding the new products??

Finished Processing Import File

Updated records: 36
New Imported records: 0
Errors Detected: 158
Warnings Detected: 0
Memory Usage: 1318792
Memory Peak: 1728704
Execution Time: 0 seconds.

I have guesses, but need more info. Just about anything will help, but first thing that comes to mind is the settings in configuration for the module, then there is a list of the headers of your import file, and then an example of one of these existent field's data.