Zen Cart Logo
Forums / Addon Admin Tools / EasyPopulate 4.0 Support Thread

EasyPopulate 4.0 Support Thread

Sticky

Views: 733,330

Results 3,261 to 3,280 of 3,671
14 May 2021, 5:02 PM
#3261
delia avatar

delia

Totally Zenned

Join Date:
May 2006
Location:
Gardiner, Maine
Posts:
2,383
Plugin Contributions:
7

EasyPopulate 4.0 Support Thread

I've just gotten the file ready to import about 40 products. It uploads fine and says it imported okay - no specifics. But the products are not importing. It has been a while since I've done this but what in the world could I be missing? All have product module numbers. I got all fields etc.

14 May 2021, 5:59 PM
#3262
mc12345678 avatar

mc12345678

Totally Zenned

Join Date:
Jul 2012
Posts:
16,908
Plugin Contributions:
2

Re: EasyPopulate 4.0 Support Thread

delia:

I've just gotten the file ready to import about 40 products. It uploads fine and says it imported okay - no specifics. But the products are not importing. It has been a while since I've done this but what in the world could I be missing? All have product module numbers. I got all fields etc.
Let's revisit some basics and also get some info...
Version of EP4, is it the latest as published to this forum or from github and what is the reported version for that?
What is the filename for the file?
If looking at the file list for import, is there a reported problem for the delimiter or is the csv delimiter reported as expected? (likely a comma)
What is the setting in the configuration for the import language override.
What "ending" is used for the header of fields that are language dependent such as the v_products_name or v_categories_name?

14 May 2021, 7:46 PM
#3263
delia avatar

delia

Totally Zenned

Join Date:
May 2006
Location:
Gardiner, Maine
Posts:
2,383
Plugin Contributions:
7

Re: EasyPopulate 4.0 Support Thread

version 4.0.37.13 - I downloaded from github but this appears to be what is in zc plugins. It does say there's a new version so I'm confused on this point.
updated_products-2021-05-10.csv
excel file - taken from exported original file. It has been majorly changed however
no reported problem
settings are default - no changes

and yes fields have the 1 on it

14 May 2021, 8:57 PM
#3264
mc12345678 avatar

mc12345678

Totally Zenned

Join Date:
Jul 2012
Posts:
16,908
Plugin Contributions:
2

Re: EasyPopulate 4.0 Support Thread

delia:

version 4.0.37.13 - I downloaded from github but this appears to be what is in zc plugins. It does say there's a new version so I'm confused on this point.
updated_products-2021-05-10.csv
excel file - taken from exported original file. It has been majorly changed however
no reported problem
settings are default - no changes

and yes fields have the 1 on it
If default new install, then in the configuration options change the import override to something other than language_code_only...

As to the version response issue, I did not update the internal version to be 4.0.37.ZC so the ZC site's 4.0.37.ZC is "newer" than 4.0.37.13 based on the method used to compare. I have some more updates to push and will get this right in that submission.

15 May 2021, 2:29 PM
#3265
delia avatar

delia

Totally Zenned

Join Date:
May 2006
Location:
Gardiner, Maine
Posts:
2,383
Plugin Contributions:
7

Re: EasyPopulate 4.0 Support Thread

making that change means the import worked. Thank you but why have a default that won't work?

15 May 2021, 3:00 PM
#3266
mc12345678 avatar

mc12345678

Totally Zenned

Join Date:
Jul 2012
Posts:
16,908
Plugin Contributions:
2

Re: EasyPopulate 4.0 Support Thread

delia:

making that change means the import worked. Thank you but why have a default that won't work?
Ahem.. It does work... When language dependent fields contain the appropriate information.

There are now four options in that list: language_id, language_code, language_id_only, and language_code_only.

Choosing either of the first two offers a preference... The preference is whatever is selected, but if it doesn't exist then the other is used. The two options ending in only will pull information from the import file only from the language dependent fields that have that identifier.

So.. It is now possible that an import file could have for example v_categories_name_1 and v_categories_name_en or it could contain either of these. But, the question becomes, when importing the file, which field should be used? Ideally, they would both contain the same information, but we all know that is not going to happen consistently. We also know that former users of this plugin have become accustomed to the _1 style. For those that have upgraded from a previous installation (say 4.0.36 where this feature was first initiated), the default was language_code even though that was not fully implemented throughout. Again, the idea was if _en existed then it would use that field, but if not, then it would attempt to use _1.

What really should have happened is that some level of notification be made about the situation. I thought that I had something for this situation, but based on the above report that does not appear to be true. Even after the extensive testing that I did, it seems I missed a portion of user response. Further it looks like I set the default export to use the 'id' so that leads to the issue you (and likely others experienced).

I previously had the import default to language_code so that if a file happened to use _en then it would offer preference to that field. Then in my testing, I realized that if one chose to delete the _1 column and had language_id set, it would still try to populate with the content of the field ending in _en.... Had some options... 1. Only "choose" between the two fields when both fields are present and ignore the other field if only one is present, 2) add a second set of options where data is populated only from the field type designated and to allow the preference with fallback option to continue/exist or 3) leave it alone and advise people to delete all occurrences of a field if it is not to be updated (I obviously didn't like this option because I didn't keep it that way).

For long time users, I expected that the configuration information and guidance would be helpful enough to change that setting as necessary, it was my goal for new users to be exposed to the language_code (though keeping/making the default export as language_id doesn't do that in the least).

So, like said a little before, need to provide another update, good feedback on the issue thank you.

Although not yet set in stone, my initial thought for this is to modify the default export to the language_code and keep the default import as language_code_only... Feedback/input?

15 May 2021, 3:05 PM
#3267
delia avatar

delia

Totally Zenned

Join Date:
May 2006
Location:
Gardiner, Maine
Posts:
2,383
Plugin Contributions:
7

Re: EasyPopulate 4.0 Support Thread

I prefer default to simply work out of the box with a default cart. I appreciate the addition of languages but I have had only one client in 20 years who used more than just English and the one I did have ended up getting rid of it due to changes years ago. I don't know what the best situation is but the simpler the better always.

16 May 2021, 11:27 AM
#3268
swguy avatar

swguy

Administrator

Join Date:
Feb 2006
Location:
Tampa Bay, Florida
Posts:
10,683
Plugin Contributions:
56

Re: EasyPopulate 4.0 Support Thread

Fresh install of current latest version of EP says "NOTE: A NEW VERSION OF THIS PLUGIN IS AVAILABLE". I couldn't get the LOG_PLUGIN_VERSIONCHECK_FAILURES setting to work and I didn't have time to look at it further. The only thing I did notice is that the comment in easypopulate_4.php on line 102 references an old version number, but obviously this is not the root cause of the issue.

16 May 2021, 5:35 PM
#3269
mc12345678 avatar

mc12345678

Totally Zenned

Join Date:
Jul 2012
Posts:
16,908
Plugin Contributions:
2

Re: EasyPopulate 4.0 Support Thread

swguy:

Fresh install of current latest version of EP says "NOTE: A NEW VERSION OF THIS PLUGIN IS AVAILABLE". I couldn't get the LOG_PLUGIN_VERSIONCHECK_FAILURES setting to work and I didn't have time to look at it further. The only thing I did notice is that the comment in easypopulate_4.php on line 102 references an old version number, but obviously this is not the root cause of the issue.
Cause of this is the discrepancy between the Zen Cart plugins reporting: 4.0.37.ZC
and the internal software (admin/includes/modules/easypopulate_4_version.php) reporting: 4.0.37.13

4.0.37.ZC > 4.0.37.13 and therefore there is a "new" version, though it is the same software between the two.

24 May 2021, 6:56 PM
#3270
jeking avatar

jeking

Totally Zenned

Join Date:
Oct 2005
Location:
Chicago, IL USA
Posts:
1,592
Plugin Contributions:
0

Re: EasyPopulate 4.0 Support Thread

Maybe I'm missing something, but I think there's a problem with version 4.0.37.13.

I cannot upload a 6MB file. The local php.ini is set to 16MB as shown: https://prnt.sc/13d0r6k

I don't know where the 2MB limit is coming from. This site had the previous version and we were able to upload files over 2MB.

24 May 2021, 7:54 PM
#3271
mc12345678 avatar

mc12345678

Totally Zenned

Join Date:
Jul 2012
Posts:
16,908
Plugin Contributions:
2

Re: EasyPopulate 4.0 Support Thread

jeking:

Maybe I'm missing something, but I think there's a problem with version 4.0.37.13.

I cannot upload a 6MB file. The local php.ini is set to 16MB as shown: https://prnt.sc/13d0r6k

I don't know where the 2MB limit is coming from. This site had the previous version and we were able to upload files over 2MB.
The new version now takes into account the maximum file upload size of configuration->maximum settings: MAX_FILE_UPLOAD_SIZE

24 May 2021, 9:10 PM
#3272
jeking avatar

jeking

Totally Zenned

Join Date:
Oct 2005
Location:
Chicago, IL USA
Posts:
1,592
Plugin Contributions:
0

Re: EasyPopulate 4.0 Support Thread

mc12345678:

The new version now takes into account the maximum file upload size of configuration->maximum settings: MAX_FILE_UPLOAD_SIZE

Well, there I have it. Thanks for pointing that out.

8 Jun 2021, 8:55 AM
#3273
webmanstudios avatar

webmanstudios

New Zenner

Join Date:
Dec 2013
Location:
Adelaide, South Australia
Posts:
29
Plugin Contributions:
0

Re: EasyPopulate 4.0 Support Thread

Hi Guys,

Just installed the latest EP4 from GITHUB on ZC v1.5.7b.

I checked the log files and found this warning.
I have searched the threads but couldn't find anything that directly relates.
Can you advise on how to fix the issue.
Many Thanks. :)

[08-Jun-2021 18:38:27 Australia/Melbourne] Request URI: //index.php?cmd=easypopulate_4, IP address: ***
#1 require(/home/
///easypopulate_4.php) called at [/////index.php:11]
--> PHP Warning: Use of undefined constant EASYPOPULATE_4_CONFIG_IMPORT_OVERRIDE - assumed 'EASYPOPULATE_4_CONFIG_IMPORT_OVERRIDE' (this will throw an Error in a future version of PHP) in /////easypopulate_4.php on line 686.

8 Jun 2021, 10:10 AM
#3274
mc12345678 avatar

mc12345678

Totally Zenned

Join Date:
Jul 2012
Posts:
16,908
Plugin Contributions:
2

Re: EasyPopulate 4.0 Support Thread

webmanstudios:

Hi Guys,

Just installed the latest EP4 from GITHUB on ZC v1.5.7b.

I checked the log files and found this warning.
I have searched the threads but couldn't find anything that directly relates.
Can you advise on how to fix the issue.
Many Thanks. :)

[08-Jun-2021 18:38:27 Australia/Melbourne] Request URI: //index.php?cmd=easypopulate_4, IP address: ***
#1 require(/home/
///easypopulate_4.php) called at [/////index.php:11]
--> PHP Warning: Use of undefined constant EASYPOPULATE_4_CONFIG_IMPORT_OVERRIDE - assumed 'EASYPOPULATE_4_CONFIG_IMPORT_OVERRIDE' (this will throw an Error in a future version of PHP) in /////easypopulate_4.php on line 686.

When say that "installed" the latest update, please elaborate.

While I recognie that it appears that the above will occur upon initial software placement and before the install is complete (something I need to address), that issue should go away after the software is fully installed. Meaning that the log will not be generated any more.
8 Jun 2021, 12:17 PM
#3275
webmanstudios avatar

webmanstudios

New Zenner

Join Date:
Dec 2013
Location:
Adelaide, South Australia
Posts:
29
Plugin Contributions:
0

Re: EasyPopulate 4.0 Support Thread

hi mc12345678, :)

I just checked the log folder and yes the errors have stopped.

Thank you for your reply. :)

8 Jun 2021, 12:45 PM
#3276
keith_z avatar

keith_z

New Zenner

Join Date:
Jul 2014
Location:
Arkansas
Posts:
40
Plugin Contributions:
0

Re: EasyPopulate 4.0 Support Thread

I use product IDs that are a mix of letters and numbers. Totally not consecutive and have never run into a problem.

8 Jun 2021, 3:34 PM
#3277
lilleypadgifts avatar

lilleypadgifts

Totally Zenned

Join Date:
Jan 2007
Location:
Southern California
Posts:
550
Plugin Contributions:
0

Re: EasyPopulate 4.0 Support Thread

I'm sorry if this is mentioned somewhere in this post, but I can't find it.
I want to use EP to upload products to multiple SUB-categories.
So for example ... a comic book...same book needs to go into two sub categories...

The book: Marvel Comics - Captain America

By Publisher (Main top level Category)
Marvel (Sub-Category)

By Title (Main top level Category)
C (Sub Category)

I can't figure out how to do this, or IF it can be done, using the columns in the exported file.

Thanks in advance.

8 Jun 2021, 6:09 PM
#3278
mc12345678 avatar

mc12345678

Totally Zenned

Join Date:
Jul 2012
Posts:
16,908
Plugin Contributions:
2

Re: EasyPopulate 4.0 Support Thread

LilleyPadGifts:

I'm sorry if this is mentioned somewhere in this post, but I can't find it.
I want to use EP to upload products to multiple SUB-categories.
So for example ... a comic book...same book needs to go into two sub categories...

The book: Marvel Comics - Captain America

By Publisher (Main top level Category)
Marvel (Sub-Category)

By Title (Main top level Category)
C (Sub Category)

I can't figure out how to do this, or IF it can be done, using the columns in the exported file.

Thanks in advance.
Each row of data will be placed in the category to which that row is assigned. A category is made of the root category followed by each sub-category of the previous category separated by a carat (^). So primary category of Marvel with a sub-category of Captain America would be represented by Marvel^Captain America. The category is placed in the column for your language identifier. A default install would use v_categories_name_1 or v_categories_name_en depending on your settings.

To place a product in multiple categories, copy the row that is to contain the information about the product to a row below the previous and change the category name. Note, the last row that applies to the product will contain the data that will be inserted/updated associated to that product.

8 Jun 2021, 6:18 PM
#3279
mc12345678 avatar

mc12345678

Totally Zenned

Join Date:
Jul 2012
Posts:
16,908
Plugin Contributions:
2

Re: EasyPopulate 4.0 Support Thread

keith z:

I use product IDs that are a mix of letters and numbers. Totally not consecutive and have never run into a problem.
Something is not correct about the above statement or the system to which this is applied has been modified as compared to a default install of a standard Zen Cart installation.

In a default Zen Cart installation, a product id is identified in many tables as an integer with up to 11 numbers.

My thought is that the term products ID in the above paragraph is in reference to a product model which is defined as a text (character) string and DOES support a mix of numbers and letters.

If I'm wrong, please let me know.

8 Jun 2021, 6:36 PM
#3280
lilleypadgifts avatar

lilleypadgifts

Totally Zenned

Join Date:
Jan 2007
Location:
Southern California
Posts:
550
Plugin Contributions:
0

Re: EasyPopulate 4.0 Support Thread

Thank you so much!
I edited my little test file and it tells me it imported ... but nothing is there.
I haven't worked on a zen site in so long... but its coming back to me S L O W L Y lol
Here is the sheet file ...
https://docs.google.com/spreadsheets/d/1KsApQWnu-wwFwC-kemmx1bwuShsT7pvrSVbHavXfMqY/edit?usp=sharing