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

EasyPopulate 4.0 Support Thread

Sticky

Views: 733,328

Results 3,281 to 3,300 of 3,671
8 Jun 2021, 7:04 PM
#3281
lilleypadgifts avatar

lilleypadgifts

Totally Zenned

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

EasyPopulate 4.0 Support Thread

mc12345678:

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.
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...it?usp=sharing

8 Jun 2021, 8:16 PM
#3282
lilleypadgifts avatar

lilleypadgifts

Totally Zenned

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

Re: EasyPopulate 4.0 Support Thread

I have done everything I can think to do.... I still get the errors below. I have categories set and created some that didn't exist. Still get the same error.

SKIPPED! - v_products_model: 2064 - No category provided for this new product
SKIPPED! - v_products_model: 2064 - No category provided for this new product
SKIPPED! - v_products_model: 1697 - No category provided for this new product
SKIPPED! - v_products_model: 1695 - No category provided for this new product
SKIPPED! - v_products_model: 0147 - No category provided for this new product

8 Jun 2021, 9:28 PM
#3283
mc12345678 avatar

mc12345678

Totally Zenned

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

Re: EasyPopulate 4.0 Support Thread

LilleyPadGifts:

I have done everything I can think to do.... I still get the errors below. I have categories set and created some that didn't exist. Still get the same error.

SKIPPED! - v_products_model: 2064 - No category provided for this new product
SKIPPED! - v_products_model: 2064 - No category provided for this new product
SKIPPED! - v_products_model: 1697 - No category provided for this new product
SKIPPED! - v_products_model: 1695 - No category provided for this new product
SKIPPED! - v_products_model: 0147 - No category provided for this new product

Please see this post: https://www.zen-cart.com/showthread.php?190417-EasyPopulate-4-0-Support-Thread&p=1380718#post1380718

I made a mistake when setting the "new" defaults for this new version. I had good intentions, but...

8 Jun 2021, 9:43 PM
#3284
lilleypadgifts avatar

lilleypadgifts

Totally Zenned

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

Re: EasyPopulate 4.0 Support Thread

mc12345678:

Please see this post: https://www.zen-cart.com/showthread.php?190417-EasyPopulate-4-0-Support-Thread&p=1380718#post1380718

I made a mistake when setting the "new" defaults for this new version. I had good intentions, but...

I have read and re-read that post a million times just in the past few hours. I don’t understand where in the thread it tells us what to do for this issue when we have everything set as it should be. :(

I have read over every thread that has this error mentioned. I hate that they make us put our questions all in one thread … it’s too hard to follow answers and important information.
the only thing I saw with a “fix” was a issue from years ago where they belittled the guy for asking for help and not reading. I AM reading and still don’t understand what the fix is.

8 Jun 2021, 9:57 PM
#3285
mc12345678 avatar

mc12345678

Totally Zenned

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

Re: EasyPopulate 4.0 Support Thread

LilleyPadGifts:

I have read and re-read that post a million times just in the past few hours. I don’t understand where in the thread it tells us what to do for this issue when we have everything set as it should be. :(

I have read over every thread that has this error mentioned. I hate that they make us put our questions all in one thread … it’s too hard to follow answers and important information.
the only thing I saw with a “fix” was a issue from years ago where they belittled the guy for asking for help and not reading. I AM reading and still don’t understand what the fix is.
Understand the frustration.

So, because I know that an issue was introduced in the latest version, lets try to be sure that we are both on the same page. Could you ppost the settings for configuration->easy Populate 4. Obscure whatever you feel necessary. Its not important at the moment to know if you store your files in the admin or not, for example.

Then could you also include the headeing designation(s) for at least your category(ies) column(s) of the file being imported.

8 Jun 2021, 10:05 PM
#3286
mc12345678 avatar

mc12345678

Totally Zenned

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

Re: EasyPopulate 4.0 Support Thread

LilleyPadGifts:

I have read and re-read that post a million times just in the past few hours. I don’t understand where in the thread it tells us what to do for this issue when we have everything set as it should be. :(

I have read over every thread that has this error mentioned. I hate that they make us put our questions all in one thread … it’s too hard to follow answers and important information.
the only thing I saw with a “fix” was a issue from years ago where they belittled the guy for asking for help and not reading. I AM reading and still don’t understand what the fix is.

To also address the "belittlement", if it was myself, that usually includes a statement indicating some level of past or related history with the individual and in part to encourage growth... e.g., have previously worked with someone where they asked several questions that were explicitly written out in instructions of other modules. Once pointed out they say something like: ohhh! I didn't even think to look there.... and then the same "style" of issue occurs here with this plugin... so... yes, sometimes have to have "tough love" to help one through. We're already past that when I described the category separation. Because of the way it was asked, I had no qualms with offering the info that is/was in the instructions. :)

8 Jun 2021, 11:20 PM
#3287
lilleypadgifts avatar

lilleypadgifts

Totally Zenned

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

Re: EasyPopulate 4.0 Support Thread

mc12345678:

Understand the frustration.

So, because I know that an issue was introduced in the latest version, lets try to be sure that we are both on the same page. Could you ppost the settings for configuration->easy Populate 4. Obscure whatever you feel necessary. Its not important at the moment to know if you store your files in the admin or not, for example.

Then could you also include the headeing designation(s) for at least your category(ies) column(s) of the file being imported.

I'm not sure if this is what you're asking for... but here is the link to my Google Sheet. The one I'm using is the tab that starts with COPY OF FULL....
https://docs.google.com/spreadsheets/d/1KsApQWnu-wwFwC-kemmx1bwuShsT7pvrSVbHavXfMqY/edit?usp=sharing

As far as the other part of my comment ... I must have deleted part of it. I don't know who it was that responded to the person, but they told him that the reason he was getting that error is because he left the category column blank. That isn't the case for the issue I'm having. I have the categories filled in.

8 Jun 2021, 11:58 PM
#3288
mc12345678 avatar

mc12345678

Totally Zenned

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

Re: EasyPopulate 4.0 Support Thread

LilleyPadGifts:

I'm not sure if this is what you're asking for... but here is the link to my Google Sheet. The one I'm using is the tab that starts with COPY OF FULL....
https://docs.google.com/spreadsheets/d/1KsApQWnu-wwFwC-kemmx1bwuShsT7pvrSVbHavXfMqY/edit?usp=sharing

As far as the other part of my comment ... I must have deleted part of it. I don't know who it was that responded to the person, but they told him that the reason he was getting that error is because he left the category column blank. That isn't the case for the issue I'm having. I have the categories filled in.
Access to that file is behind some sort of "permissions" based system. Reading it would only provide half of the picture. The other half is in the settings requested above.

9 Jun 2021, 12:08 AM
#3289
lilleypadgifts avatar

lilleypadgifts

Totally Zenned

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

Re: EasyPopulate 4.0 Support Thread

mc12345678:

Access to that file is behind some sort of "permissions" based system. Reading it would only provide half of the picture. The other half is in the settings requested above.

Try again please ... thought I had changed setting but guess I didn't give it time to save.

9 Jun 2021, 2:42 AM
#3290
mc12345678 avatar

mc12345678

Totally Zenned

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

Re: EasyPopulate 4.0 Support Thread

LilleyPadGifts:

Try again please ... thought I had changed setting but guess I didn't give it time to save.
So I've looked at the file. Nothing particularly "stands out"... Even with it formatted as it is.

For the third and final time, though. Please provide the settings that are in the admin under configuration->Easy Populate 4. I can not help you if you don't help to make it possible to help you. If not providing that information, please explain why or what is not understood. Again, with the same comment.

9 Jun 2021, 2:58 AM
#3291
lilleypadgifts avatar

lilleypadgifts

Totally Zenned

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

Re: EasyPopulate 4.0 Support Thread

mc12345678:

So I've looked at the file. Nothing particularly "stands out"... Even with it formatted as it is.

For the third and final time, though. Please provide the settings that are in the admin under configuration->Easy Populate 4. I can not help you if you don't help to make it possible to help you. If not providing that information, please explain why or what is not understood. Again, with the same comment.

Wow...Forgive me for not automatically knowing what you were talking about ....I thought I was giving you the info you asked for when I gave you access to the google sheets link... and I only saw it mentioned once.
I have images of what the settings are in Admin/Config/Easy Populate. If this isn't what you are asking for please let me know. Obviously, I'm not PURPOSELY withholding information to get the help I need and am asking for.
Attachment 19617Attachment 19618

9 Jun 2021, 3:28 AM
#3292
mc12345678 avatar

mc12345678

Totally Zenned

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

Re: EasyPopulate 4.0 Support Thread

mc12345678:

Please see this post: https://www.zen-cart.com/showthread.php?190417-EasyPopulate-4-0-Support-Thread&p=1380718#post1380718

I made a mistake when setting the "new" defaults for this new version. I had good intentions, but...
Perhaps also read the ever more detailed description at the post a little further down from that: https://www.zen-cart.com/showthread.php?190417-EasyPopulate-4-0-Support-Thread&p=1380738#post1380738

LilleyPadGifts:

Wow...Forgive me for not automatically knowing what you were talking about ....I thought I was giving you the info you asked for when I gave you access to the google sheets link... and I only saw it mentioned once.
I have images of what the settings are in Admin/Config/Easy Populate. If this isn't what you are asking for please let me know. Obviously, I'm not PURPOSELY withholding information to get the help I need and am asking for.
Attachment 19617Attachment 19618
That is exactly what was needed to close the loop.

As previously (perhaps confusingly?) described (or attempted) in the above linked post, but reworded here:

In the list of configuration settings, starting from the top of the settings, please see the fourth option down that has the Title of: Import Language Override... For the file that was made available to peruse... Literally, change the setting to ANYTHING other than the current setting of language_code_only.

The file shows language related fields to be using the XXXXX_1 style...

If you click on that admin->configuration->Easy Populate 4 setting and look on the "right side" of the screen (bottom if using a mobile device): _1 references using the language_id whereas if it ended with the two letter abbreviation for the associated language (_en, _es, _de, etc...) then it would be fine.

But, by this particular setting being set to language_code_only, then the only language related fields that are recognized are formatted like v_products_name_en, v_categories_name_en, etc... (for english)... Again, I have apologized now at least twice already for my mistake and will again as necessary, but to resolve the problem occurring where a "categories name" can not be found (right now it is searching for v_categories_name_en), either the file must have a column with v_categories_name_en (or whatever language is being imported) or change the setting of the above to literally anything else...

11 Jun 2021, 2:09 AM
#3293
lilleypadgifts avatar

lilleypadgifts

Totally Zenned

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

Re: EasyPopulate 4.0 Support Thread

Does this version allow for custom fields to be added?

11 Jun 2021, 3:27 AM
#3294
mc12345678 avatar

mc12345678

Totally Zenned

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

Re: EasyPopulate 4.0 Support Thread

LilleyPadGifts:

Does this version allow for custom fields to be added?
As is/built, yes it still supports custom fields that are part of the products table. Haven't yet added the ability to cross reference fields within other tables. Additional code could be added (notifiers are used) to address other desired options.

11 Jun 2021, 4:36 AM
#3295
lilleypadgifts avatar

lilleypadgifts

Totally Zenned

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

Re: EasyPopulate 4.0 Support Thread

mc12345678:

As is/built, yes it still supports custom fields that are part of the products table. Haven't yet added the ability to cross reference fields within other tables. Additional code could be added (notifiers are used) to address other desired options.

ok thanks.

I made the change in admin like you mentioned, uploaded the same file and it created the categories and sub cats but nothing the actually products. Didn’t create the page for them or anything.
Going to attack it again in the morning with a fresh brain but wanted to get this out here incase it’s something I’m just missing with a easy fix …. Please please please oh please :(:unsure:

11 Jun 2021, 11:24 AM
#3296
lilleypadgifts avatar

lilleypadgifts

Totally Zenned

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

Re: EasyPopulate 4.0 Support Thread

LilleyPadGifts:

ok thanks.

I made the change in admin like you mentioned, uploaded the same file and it created the categories and sub cats but nothing the actually products. Didn’t create the page for them or anything.
Going to attack it again in the morning with a fresh brain but wanted to get this out here incase it’s something I’m just missing with a easy fix …. Please please please oh please :(:unsure:

Figured it out .... Status column ... nothing tells us what should be there. I read a post that said Enable/Disable. So I put Enable in that column :blush: ... its supposed to be a 1 to turn on that status.

Is there a link to exactly how the custom fields work? Not sure if I'm going to need them at the moment, but I need the option for the other stores.
Thanks for your help!

11 Jun 2021, 11:49 AM
#3297
mc12345678 avatar

mc12345678

Totally Zenned

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

Re: EasyPopulate 4.0 Support Thread

LilleyPadGifts:

Figured it out .... Status column ... nothing tells us what should be there. I read a post that said Enable/Disable. So I put Enable in that column :blush: ... its supposed to be a 1 to turn on that status.

Is there a link to exactly how the custom fields work? Not sure if I'm going to need them at the moment, but I need the option for the other stores.
Thanks for your help!
I am going to make reference to a "previous" discussion. The instructions suggest exporting a file of the type that is desired to be used for import... Why? This way one can see what is already in the database. Knowing what the output is like and having some level of familiarity of the item(s) in the store, one should be able to see or through some level of testing identify the effect of the various fields...

Mind you, I was going to ask how the issue was being evaluated... When saying that the page wasn't created, it helps to understand what "page" was being expected... I will note in relation to the latest post that the status field does not allow/prevent a product from appearing in the admin's products/categories listing... It does in general prevent the product from appearing on the catalog side (which, based on the above conversation, is likely what was being reviewed).

Now, as for the custom fields, access to the data stored and the ability to modify that data is what is provided. EP4 doesn't know what that data is, how it is used, or what basic value(s) it should contain. The instructions both in the plugin fileset as well as on the admin configuration page do indicate/suggest that when populating the configuration settings that the fieldname should be used, not v_fieldname. With the custom field information populated, exporting information associated with products should show that field name in the header of the file and (where information is provided for the field) it should appear in the resulting csv file. Again, how it is then used, populated, etc... that is up to the needs/expectations of the field and code that processes that field.

Put another way, EP4 provides (direct) access to data in the database. In some cases, the Zen Cart standard database field handling is incorporated (products_id is an integer, products_name is text, etc...) but there are also things that are not enforced on purpose so that the tool can be used in various configurations with minimal modification. For example, EP4 doesn't prevent a product being added to a category that has sub-categories... While that is a situation normally discouraged because of some of the still current core code design, it is not a requirement for store operation and further can be made possible.

Anyways, hope at least some of the above helps.

BTW, to what setting was the configuration option (language_code_only) changed?

12 Jun 2021, 4:31 PM
#3298
reviresco avatar

reviresco

New Zenner

Join Date:
Jul 2017
Location:
United States
Posts:
10
Plugin Contributions:
0

Re: EasyPopulate 4.0 Support Thread

Zen Cart 1.5.7
Easy Populate 4.0.37.13 - 05-03-2021
PHP 7.4 FastCGI

Exported a Complete Products download type file of one of my categories; used it for the template of a new CSV file.

I've tried importing both the original file that I exported, and the new CSV file that I made. The files are uploaded, but when I click the Import button, I'm taken to the Admin main page; no messages are displayed. Nothing is imported and there are no errors in the logs.

The temp directory (in Admin) has the two files in it.

I double checked that all the EasyPopulate files were uploaded.

What might I be doing wrong?

12 Jun 2021, 5:35 PM
#3299
mc12345678 avatar

mc12345678

Totally Zenned

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

Re: EasyPopulate 4.0 Support Thread

Reviresco:

Zen Cart 1.5.7
Easy Populate 4.0.37.13 - 05-03-2021
PHP 7.4 FastCGI

Exported a Complete Products download type file of one of my categories; used it for the template of a new CSV file.

I've tried importing both the original file that I exported, and the new CSV file that I made. The files are uploaded, but when I click the Import button, I'm taken to the Admin main page; no messages are displayed. Nothing is imported and there are no errors in the logs.

The temp directory (in Admin) has the two files in it.

I double checked that all the EasyPopulate files were uploaded.

What might I be doing wrong?
A review of recent posts may have revealed the direction provided here: https://www.zen-cart.com/showthread.php?190417-EasyPopulate-4-0-Support-Thread&p=1381452#post1381452

Again, the problem is/was (most likely) the default settings were set incorrectly. I have two improvements to make and then I will be uploading an updated copy that won't start off that way.

27 Jun 2021, 12:40 PM
#3300
g2ktcf avatar

g2ktcf

Totally Zenned

Join Date:
Feb 2011
Location:
Lumberton, TX
Posts:
636
Plugin Contributions:
0

Re: EasyPopulate 4.0 Support Thread

I just installed Easy Populate 4.0.37.13. I was able to download the products file and open it in OpenOffice. But, I am getting all kinds of warnings in the log files. Many of these warnings are related to the image below where undefined constants show up and "no supported file types." I created a new folder in Admin /temp. I copied the .htaccess file into that newly created (empty?) folder. Just wondering if I did anything wrong.

Also, I noticed a few folks having issues in previous posts about things not uploading. Is this still an ongoing issue? I need to upload about 150 products before the end of the day! :O

Attachment 19656