EasyPopulate 4.0 Support Thread

i am having a hard time getting the product urls for google data feed.

i use the 'v_products_url_1' column to assign URL for upload/import.
the uri mapping evidently does not use the url i assign. e.g., 6.5" is converted to '6.5-' instead of '6.5in-' i assigned in the upload file. (not to mention for each and every product to have uri mapping, i have to go to catalog/product and preview/save?)

when i export and download, i get exactly what i uploaded, which are not the working urls.
so how do i get the product urls?

w2e:

i am having a hard time getting the product urls for google data feed.

i use the 'v_products_url_1' column to assign URL for upload/import.
the uri mapping evidently does not use the url i assign. e.g., 6.5" is converted to '6.5-' instead of '6.5in-' i assigned in the upload file. (not to mention for each and every product to have uri mapping, i have to go to catalog/product and preview/save?)

when i export and download, i get exactly what i uploaded, which are not the working urls.
so how do i get the product urls?

A lot going on in that statement... I'll take a stab at what I understand, but please, more clarification is necessary...

v_products_url_1 is a field that is truly products_uri in I think the products_description table of the database. That field is language specific. It is a field available at the bottom of a standard ZC installation where it says: products_url typically with a flag adjacent to it. There are admin options to display that field on the product information page of the store...

So, now comes the use of that field in EP4...

if you are entering 6.5" as part of your text in Open Office, Open office will not convert that into inches or anything else.. And in fact, it may cause a problem, because it is not escaped (6.5"). The version of EP4 that is discussed/provided in this forum does not do URI remapping... A version of EP4 exists that does, but that's about as much as I'm allowed to state here..

If you want to obtain the URI that one sees from the store, there has been a feature implemented (I forget which version somewhere between 4.0.24 and 4.0.28 (most current), that will add an additional field to the end of the product export field list which uses the ZC code of creating the store side URI. I think the field created is v_uri, but I could be wrong as it's been a while since I added that feature... The option to export such a URI is provided in the configuration settings after said version (or more recent) has been installed. Because the change affects the configuration menu, the program is to be uninstalled and reinstalled via database action only (top right corner of the tools->EP4 window, followed by the install option in the middle of the same window) This action will reset the configuration settings back to their default, so take note of them before uninstalling... (ie. folder for file storage/retrieval as well as the other settings).

the version i use is 4.0.24 which was just downloaded/installed a few days ago.
i exported/downloaded complete products/specific category/active, but i only see 'v_products_url_1' right after the description column.

so i have to reinstall newer version of EP4?

w2e:

the version i use is 4.0.24 which was just downloaded/installed a few days ago.
i exported/downloaded complete products/specific category/active, but i only see 'v_products_url_1' right after the description column.

so i have to reinstall newer version of EP4?

Yes, the github repository that is referenced at the beginning of this thread (and identified at least once on the previous page) has been updated (I think it was yesterday) to the current version of 4.0.28 which is also ZC 1.5.4 compatible. That version includes the export feature as well as other features discussed over the past couple of pages. Assuming there has been no personalized modifications the file reinstall will simply be an overwrite of the existing core files (no need to reupload the 1.5.x special file) as well as the additional files that are present (folder structure is as necessary), then uninstall/reinstall as provided in my previous post. Previous ZC compatibility and functionality remains the same, the code now supports additional features.

PS, the version was 4.0.27 as discussed a couple pages back: http://www.zen-cart.com/showthread.php?190417-EasyPopulate-4-0-Support-Thread&p=1267699#post1267699

BTW, a correction, the field generated is: v_html_uri

After export, that field name can be renamed to whatever is necessary for subsequent upload to whatever utility/tool, but remember that if it will match an existing field, that other "non-desired" field/column needs to be renamed/removed...

how do i keep admin panel logged in?
i set it in config to be 86400 sec, but it still keeps logging me out some every 10-20 minutes?

w2e:

how do i keep admin panel logged in?
i set it in config to be 86400 sec, but it still keeps logging me out some every 10-20 minutes?

And in further effort to potentially make the site unsecure, turned off the pci timeout requirements that became available in ZC1.5.4 under configuration->my store?

I've downloaded a cvs sheet and added an additional category column v_categories_name_2
I tried uploading the test product with Easy Populate 4.0.22 - Beta 6-10-2012. but the second category is not showing up on the listing.
I've tested it a couple different ways with no success.
Am I configuring the column correctly?

mc12345678:

Thank you for the detail. A quick sidenote, the various versions of update that all happened on one day is a result of a database upgrade (expected output); however, the timing doesn't seem right with the rest of the description. I don't think though that the fact that they passed on a previously built database is the cause of your current issue.

Would you be able to provide at least two rows of data (plus headers), where at least one row is successful and at least one row is not with regards to the description_1 field? My guess is that there are special characters included in the unsuccessful row that are not properly escaped before saving the file.

Here are a few lines that did not work

BBBLGOD Goddess leather w/ latch Bound in hand-stitched, green dyed leather, this book displays two images of the Goddess, portraying her as both the nurturing mother of life and the vengeful destroyer. Contains 280 unlined pages. 5" x 7" 11 1.1 39.95
BBBLGRI45 Griffins leather w/ latch Hand tooled blank leather journal with embossed Griffins. Border & rear cover embossing may vary. Sizes vary slightly. Leather, handmade paper. 220 pages, latch closure. 4 1/2ﾔ x 5ﾔ 15 0.55 18.95
BBBLGRIXL Fighting Griffin leather w/ latch Leather bound, this blank book seems fit for a library of ancient codex with finely tooled scrollwork and the image of a rearing Griffin on its cover. This makes a fantastic setting for your Book of Shadows, diary, or journal. Contains 240 unlined pages. 10" x 13". 5 2.5 50

Here are a couple that did work

BBBLEPO45 Epona leather w/ latch Hand tooled blank leather journal with Celtic horses circling on the front. Border & rear embossing may vary. Sizes vary slightly. Leather, handmade paper. 240 pages, latch closure. 4 1/2ﾔ x 5ﾔ 5 0.55 18.95
BBBLF448 Fairy leather w/ latch Hand tooled blank leather journal with a fairy picking flowers on the front. Border & rear embossing may vary. Sizes vary slightly. Leather, handmade paper. 240 pages, latch closure. 6ﾔ x 8ﾔ 36 1.2 34.95
BBBLF710 Fairy leather w/ latch Hand tooled lined leather journal with embossed fairy. Border & backside embossing may vary. Size may vary slightly. Leather, handmade paper. 240 pages, latch closure. 7ﾔ x 10ﾔ 6 1.6 28.95
BBBLFLO Flower leather w/ latch Hand tooled blank leather journal with varied floral embossing. Border embossing may vary. Size may vary slightly. Leather, handmade paper. 240 pages, latch closure. 3 1/4ﾔﾔ x 4ﾔ 36 0.4 12
BBBLFOX Fox leather w/ latch Hand tooled blank leather journal with heavily embossed covers showing foxes, leaves and knot work. Art by Jen Delyth. Sizes vary slightly. Leather, handmade paper. 272 pages, latch closure. 5ﾔ x 7ﾔ 24 1.21 39.95

Third Eye:

Here are a few lines that did not work

BBBLGOD Goddess leather w/ latch Bound in hand-stitched, green dyed leather, this book displays two images of the Goddess, portraying her as both the nurturing mother of life and the vengeful destroyer. Contains 280 unlined pages. 5" x 7" 11 1.1 39.95
BBBLGRI45 Griffins leather w/ latch Hand tooled blank leather journal with embossed Griffins. Border & rear cover embossing may vary. Sizes vary slightly. Leather, handmade paper. 220 pages, latch closure. 4 1/2ﾔ x 5ﾔ 15 0.55 18.95
BBBLGRIXL Fighting Griffin leather w/ latch Leather bound, this blank book seems fit for a library of ancient codex with finely tooled scrollwork and the image of a rearing Griffin on its cover. This makes a fantastic setting for your Book of Shadows, diary, or journal. Contains 240 unlined pages. 10" x 13". 5 2.5 50

Here are a couple that did work

BBBLEPO45 Epona leather w/ latch Hand tooled blank leather journal with Celtic horses circling on the front. Border & rear embossing may vary. Sizes vary slightly. Leather, handmade paper. 240 pages, latch closure. 4 1/2ﾔ x 5ﾔ 5 0.55 18.95
BBBLF448 Fairy leather w/ latch Hand tooled blank leather journal with a fairy picking flowers on the front. Border & rear embossing may vary. Sizes vary slightly. Leather, handmade paper. 240 pages, latch closure. 6ﾔ x 8ﾔ 36 1.2 34.95
BBBLF710 Fairy leather w/ latch Hand tooled lined leather journal with embossed fairy. Border & backside embossing may vary. Size may vary slightly. Leather, handmade paper. 240 pages, latch closure. 7ﾔ x 10ﾔ 6 1.6 28.95
BBBLFLO Flower leather w/ latch Hand tooled blank leather journal with varied floral embossing. Border embossing may vary. Size may vary slightly. Leather, handmade paper. 240 pages, latch closure. 3 1/4ﾔﾔ x 4ﾔ 36 0.4 12
BBBLFOX Fox leather w/ latch Hand tooled blank leather journal with heavily embossed covers showing foxes, leaves and knot work. Art by Jen Delyth. Sizes vary slightly. Leather, handmade paper. 272 pages, latch closure. 5ﾔ x 7ﾔ 24 1.21 39.95

As suspected,characters are included in the ones that don't work that need to be escaped while the content is still in OpenOffice or whatever spreadsheet/text editor is being used. For example:
10" x 13"
Should be:
10" x 13"

When viewed in the editor. This way when the content is read in, the quotes aren't treated as other characters...

Now I'm not sure why the ones that do work look so odd in this forum, but they are obviously not straight characters for lack of correct terminology.

Another question asked about this program earlier:

14all41:

I've downloaded a cvs sheet and added an additional category column v_categories_name_2
I tried uploading the test product with Easy Populate 4.0.22 - Beta 6-10-2012. but the second category is not showing up on the listing.
I've tested it a couple different ways with no success.
Am I configuring the column correctly?

Besides being rather significantly old/missing additional features and still compatible with the existing software, as described several times in this forum (even as recently as the previous page), the number at the end of a field name represents the language to which that field is associated... So, if you have a second language that has a language id of 2, then upload of that information would populate that language's version of that field...

Perhaps you could 1) explain what it is you are trying to do, or 2) export your current database, perform the action you want to see happen to/for a product, then export the database again and compare the records applicable to the change(s), then duplicate those actions/changes to the data that is to be uploaded...

mc12345678:

As suspected,characters are included in the ones that don't work that need to be escaped while the content is still in OpenOffice or whatever spreadsheet/text editor is being used. For example:
10" x 13"
Should be:
10" x 13"

When viewed in the editor. This way when the content is read in, the quotes aren't treated as other characters...

Now I'm not sure why the ones that do work look so odd in this forum, but they are obviously not straight characters for lack of correct terminology.

I just uploaded and imported this in open office, I had no errors and everything indicated that it updated properly, but the description still did not update. any other ideas?

v_products_model v_products_name v_products_description_1 v_products_quantity v_products_weight v_products_price
BBBLG229 Greenman leather w/ latch Hand tooled blank leather journal with a large Greenman on the front. Border & rear embossing may vary. Sizes vary slightly. Leather, handmade paper. 240 pages, latch closure. 6\” x 8\” 6 1.2 34.95
BBBLGOD Goddess leather w/ latch Bound in hand-stitched, green dyed leather, this book displays two images of the Goddess, portraying her as both the nurturing mother of life and the vengeful destroyer. Contains 280 unlined pages. 5" x 7" 11 1.1 39.95
BBBLGRI45 Griffins leather w/ latch Hand tooled blank leather journal with embossed Griffins. Border & rear cover embossing may vary. Sizes vary slightly. Leather, handmade paper. 220 pages, latch closure. 4 1/2\” x 5\” 15 0.55 18.95
BBBLGRIXL Fighting Griffin leather w/ latch Leather bound, this blank book seems fit for a library of ancient codex with finely tooled scrollwork and the image of a rearing Griffin on its cover. This makes a fantastic setting for your Book of Shadows, diary, or journal. Contains 240 unlined pages. 10" x 13". 5 2.5 50
BBBLHEA Hearts leather w/ latch Hand tooled lined leather journal with heavy, medieval styled embossing, may vary. Size may vary slightly. Leather, handmade paper. 240 pages, Latch closure. 5 1/2\” x 8 1/4\” 8 1.3 39.95
BBBLOWL Owl leather w/ latch Hand tooled blank leather journal showing an Owl & Lady connected by knot work. Art by Jen Delyth. Size may vary slightly. Leather, handmade paper. 272 pages, latch closure. 5\” x 7\” 33 1.1 39.95
BBBLP284 Pentagram leather w/ latch Hand tooled blank leather journal with embossed, interwoven pentacle & flower. Border embossing may vary. Sizes vary slightly. Leather, handmade paper. 240 pages, latch closure. 7\” x 10\” 24 2.2 49.95

So, I was wrong about how to resolve this issue. It is clear that generally speaking the upload works as some descriptions get uploaded, but some do not. Therefore there is something "wrong" with the ones that do not upload. Fom what can be seen of the records pasted into the forum there is a difference in symbols used after numbers intended to represent dimensions.

I have asked via PM to be forwarded a copy of a file containing records that don't work and a few that do to try to resolve locally duplicating the conditions identified above. I will post my findings upon resolution. Thank you for your understanding, it seemed like the escape code would work, but again, I was wrong as it didn't.

mc12345678:

Another question asked about this program earlier:

Besides being rather significantly old/missing additional features and still compatible with the existing software, as described several times in this forum (even as recently as the previous page), the number at the end of a field name represents the language to which that field is associated... So, if you have a second language that has a language id of 2, then upload of that information would populate that language's version of that field...

Perhaps you could 1) explain what it is you are trying to do, or 2) export your current database, perform the action you want to see happen to/for a product, then export the database again and compare the records applicable to the change(s), then duplicate those actions/changes to the data that is to be uploaded...

Now I'll admit that I don't spend time reading this thread, but that would be because I haven't had any issues with this old version of EP. It still works great. I'm just trying something different than what I've done in the past.
Let me add the searching the forum has not answered my question either.
It is good to know that there have been many improvements to EP. Thank you for sharing that.
I do plan to upgrade to EP the latest version. Perhaps you could briefly describe
how to layout the cvs sheet columns for (EP 4) to have an item display in a sub category and then also display in the parent category (if possible).

14all41:

Now I'll admit that I don't spend time reading this thread, but that would be because I haven't had any issues with this old version of EP. It still works great. I'm just trying something different than what I've done in the past.
Let me add the searching the forum has not answered my question either.
It is good to know that there have been many improvements to EP. Thank you for sharing that.
I do plan to upgrade to EP the latest version. Perhaps you could briefly describe
how to layout the cvs sheet columns for (EP 4) to have an item display in a sub category and then also display in the parent category (if possible).

No disagreement there that even the older version(s) work well. It's one reason I stuck with using it and doing what I could to keep it functional.

As for searching? Yeah I believe there are some things in the site left to be desired, but it works.

So, regarding the question at hand. Please correct me if I misunderstood, but it seems as if you would like to have a product listed in a category that has subcategories. If that is the case, ZC doesn't support that. Perhaps though you are asking for a product to be linked?

Explanation: categories either contain products or sub-categories, not both

mc12345678:

No disagreement there that even the older version(s) work well. It's one reason I stuck with using it and doing what I could to keep it functional.

As for searching? Yeah I believe there are some things in the site left to be desired, but it works.

So, regarding the question at hand. Please correct me if I misunderstood, but it seems as if you would like to have a product listed in a category that has subcategories. If that is the case, ZC doesn't support that. Perhaps though you are asking for a product to be linked?

Explanation: categories either contain products or sub-categories, not both

Yes you understood correctly and i agree zen cart does not support that. Which I did not realize until today, never tried it before.
Is there a way to list the product in a two different subcategories at the same time?
IE list in, category: apple, subcategory: iphone4. Also list the product in category: apple, subcategory: all apple
What would that look like on the cvs sheet?

14all41:

Is there a way to list the product in a two different subcategories at the same time?
Yes. In the database, the extra subcategories would be reflected as additional records in the products_to_categories table.

DrByte:

Yes. In the database, the extra subcategories would be reflected as additional records in the products_to_categories table.

I get 4.0 installed and try that out. Thank you.

14all41:

Yes you understood correctly and i agree zen cart does not support that. Which I did not realize until today, never tried it before.
Is there a way to list the product in a two different subcategories at the same time?
IE list in, category: apple, subcategory: iphone4. Also list the product in category: apple, subcategory: all apple
What would that look like on the cvs sheet?

Been a little while since I have looked at how/if linked products are supported (properly), but may need to include the mastercategories field may be necessary, but when creating a product, the categories are populated with the main/top category followed by the sub-category of that category with a single carat (^) between the two. I thought that if you added a new row with all of the same information, and thenmodified the categories structure then that product would be populated in that subcategory as well... The problem comes in if on export, both "products" are provided, and a change made to the first "product". The second occurrence of the same product will overwrite the original change with a new change when the file is uploaded with both rows still in the database.

So, in answer to the question if not mistaken, to create a linked product, export the database, change the category information for the product to be linked, import the database/or changed line, and now the product appears in two sub-categories.

Third Eye:

I just uploaded and imported this in open office, I had no errors and everything indicated that it updated properly, but the description still did not update. any other ideas?

v_products_model v_products_name v_products_description_1 v_products_quantity v_products_weight v_products_price
BBBLG229 Greenman leather w/ latch Hand tooled blank leather journal with a large Greenman on the front. Border & rear embossing may vary. Sizes vary slightly. Leather, handmade paper. 240 pages, latch closure. 6\” x 8\” 6 1.2 34.95
BBBLGOD Goddess leather w/ latch Bound in hand-stitched, green dyed leather, this book displays two images of the Goddess, portraying her as both the nurturing mother of life and the vengeful destroyer. Contains 280 unlined pages. 5" x 7" 11 1.1 39.95
BBBLGRI45 Griffins leather w/ latch Hand tooled blank leather journal with embossed Griffins. Border & rear cover embossing may vary. Sizes vary slightly. Leather, handmade paper. 220 pages, latch closure. 4 1/2\” x 5\” 15 0.55 18.95
BBBLGRIXL Fighting Griffin leather w/ latch Leather bound, this blank book seems fit for a library of ancient codex with finely tooled scrollwork and the image of a rearing Griffin on its cover. This makes a fantastic setting for your Book of Shadows, diary, or journal. Contains 240 unlined pages. 10" x 13". 5 2.5 50
BBBLHEA Hearts leather w/ latch Hand tooled lined leather journal with heavy, medieval styled embossing, may vary. Size may vary slightly. Leather, handmade paper. 240 pages, Latch closure. 5 1/2\” x 8 1/4\” 8 1.3 39.95
BBBLOWL Owl leather w/ latch Hand tooled blank leather journal showing an Owl & Lady connected by knot work. Art by Jen Delyth. Size may vary slightly. Leather, handmade paper. 272 pages, latch closure. 5\” x 7\” 33 1.1 39.95
BBBLP284 Pentagram leather w/ latch Hand tooled blank leather journal with embossed, interwoven pentacle & flower. Border embossing may vary. Sizes vary slightly. Leather, handmade paper. 240 pages, latch closure. 7\” x 10\” 24 2.2 49.95

mc12345678:

So, I was wrong about how to resolve this issue. It is clear that generally speaking the upload works as some descriptions get uploaded, but some do not. Therefore there is something "wrong" with the ones that do not upload. Fom what can be seen of the records pasted into the forum there is a difference in symbols used after numbers intended to represent dimensions.

I have asked via PM to be forwarded a copy of a file containing records that don't work and a few that do to try to resolve locally duplicating the conditions identified above. I will post my findings upon resolution. Thank you for your understanding, it seemed like the escape code would work, but again, I was wrong as it didn't.

Ugh.. So, it should have been obvious to other users of this module, but it appears that the majority of the issues have been addressed regarding the above partial list of records. Sometimes when thinking the data is working or not, it's possible to overlook other aspects of the file. For example, the column heading for product_name looks correct; however, after further consideration, that data field is a language dependent field. In EP4, language dependent fields are to include a language identifier. Currently that identifier is a number that corresponds with the number adjacent to the language in the admin panel.

So, in this case, with v_product_name renamed to v_product_name_1, the issue was resolved... Ideally

This type of problem is avoidable by exporting a file to obtain the headers before making changes to be uploaded.