EasyPopulate 4.0 Support Thread

[mc12345678]

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]

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.

[mc12345678]

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.

[chadderuski]

Hiya MC12345678!!!

Fresh install of EP4 on clean install of Zen 1.5.8 and php 8.1:

First issue I had was the blank page... made the private to public change noted above in query factory but it did not fix blank page.
Checked error logs and there is some issue with ep4 error logging folder...

So I un-commented line 97 of easypopulate_4.php:

 $ep_debug_logging_all = false; // do not comment out.. make false instead This is now controlled from admin.

and was able to run the EP4 installer.

I created a couple directories and test products with sub-categories manually.
Exported a FULL EP4 file, and turned around and was able to import and all "updated" correctly.

I then manually deleted these products and categories from the admin and re-ran the import and received this:

SKIPPED! - v_products_model: TEST_Model - No category provided for this new product
SKIPPED! - v_products_model: TEST_Model_2 - No category provided for this new product

Haven't looked any deeper yet. I'm going to have to sweep the cobwebs out of my brain and look at the code again. Been quite a few years since you adopted EP4! Glad to see you are still taking good care of it!

Almost 3500 posts! Holy Cow!

[dbltoe]

Almost 3500 posts! Holy Cow!

Yep, it's popular and complicated. The best way to help at this point (moving into 1.5.8) is to post in github witht the following in mind:

**Describe the bug**A clear and concise description of what the bug is.
Be sure to explain the business problem that this bug is affecting.


**Version**
Zen Cart version:
PHP version:
MySQL version:
Plugins that may be related:
What older/newer versions were also tested?


**To Reproduce**
Steps to reproduce/demonstrate the behavior:
1. Go to '...'
2. Click on '....'
3. Scroll down to '....'
4. See such-and-such


**Expected behavior**
A clear and concise description of what the bug is preventing from happening correctly.
It's helpful also to explain why what you expected to happen is important. (eg: is this a "software bug" or a "this bugs me" situation?)


**Screenshots**
If applicable, add screenshots to help explain.


**Debug/Error Logs**
Include debug logs containing PHP and/or MySQL error details. These are often found in your /logs/ directory as myDebug-xxxxx.log files.

**Devices (please complete the following information):**
- Operating System: [e.g. Windows, Mac, Android, iOS]
- Browser [e.g. chrome, firefox] and version number


**Additional context**
Add any other context about the problem here.

[mc12345678]

Hiya MC12345678!!!

Fresh install of EP4 on clean install of Zen 1.5.8 and php 8.1:

First issue I had was the blank page... made the private to public change noted above in query factory but it did not fix blank page.
Checked error logs and there is some issue with ep4 error logging folder...

So I un-commented line 97 of easypopulate_4.php:

 $ep_debug_logging_all = false; // do not comment out.. make false instead This is now controlled from admin.

and was able to run the EP4 installer.

I created a couple directories and test products with sub-categories manually.
Exported a FULL EP4 file, and turned around and was able to import and all "updated" correctly.

I then manually deleted these products and categories from the admin and re-ran the import and received this:

SKIPPED! - v_products_model: TEST_Model - No category provided for this new product
SKIPPED! - v_products_model: TEST_Model_2 - No category provided for this new product

Haven't looked any deeper yet. I'm going to have to sweep the cobwebs out of my brain and look at the code again. Been quite a few years since you adopted EP4! Glad to see you are still taking good care of it!

Almost 3500 posts! Holy Cow!

Yeah, bad assembly of a distribution package.

I was going to make all language based fields default to using the language code (en, es, de, etc.) Then realized how much trouble that would cause existing users, so went back in the code to default to language id (1, 2, 3, etc), but the sql install has already been set to default to language code basically.

Essentially, ensure alignment with language import configuration settings with what you have or want to have in your import file. There is also an export setting about how the fields will be titled (code, id, or both). It's been made versatile, but has a known initial installation problem to be fixed on the next update.

[mc12345678]

Yep, it's popular and complicated. The best way to help at this point (moving into 1.5.8) is to post in github witht the following in mind:

The quoted text of the above message is absolutely appropriate to report the associated issue; however, one could claim that the design of this module is why it is an issue and something I expect response to indicate that the module should either be revamped or dismissed. The central issue though is that the Zen Cart 1.5.8 redesign prohibits the use of any mysqli_xxx code that requires the mysql object of the database using the associated database. Based on the writeup by the individual that submitted the PR, reason and consideration as to why any of those features might be considered necessary or concerns of making the member public as compared to offering an access method to the member.

[RoboPhung]

Hello,

I'm running ZC 1.5.7d and php 7.4. Everything about EASYPOPULATE looks like it works correctly, except I cannot seem to successfully import the edited changes to the "v_products_name_1" column, which are the product titles.

The import message shows no errors - everything imports, but the product titles don't reflect the edits made to the CSV.

Has anyone else encountered this problem or can suggest where to start looking to resolve this?

Thanks in advance!

[kernheimer]

ZC 1.5.8
is our beloved plugin ready for this? i can't seem to get it to work under ZC 1.5.8 and php8.1

[mc12345678]

ZC 1.5.8
is our beloved plugin ready for this? i can't seem to get it to work under ZC 1.5.8 and php8.1

There are two known issues with the software grouping. One has been heavily discussed (but not truly publicly corrected because a new version hasn't been issued) the other as a result of how EP4, for previously described reasons, still uses base php/mysqli query calls instead of solely using $db methods.

For the 1.5.8 issue, see the file change(s) of Pull Request 5486, this was described/discussed in this post and that change is expected remain a part of ZC 1.5.8x to first appear in 1.5.8a. For the other (only an issue in upgrading EP4 to the version current as of today), perhaps one way to understand the situation is through this post or this post, though there are (multiple) others over the last year or so that direct the same action with a different explanation.