EasyPopulate 4.0 Support Thread

renamed. Thanks for the heads-up

FoodSourceDirect:

Hi MC:

Something you said gave me a tip. I changed the beginning of the name of my csv file from FULL to Full and pre-pended the custom product field names in my csv file I created with "v_", redid the upload and it worked... Thanks

Welcome, though the thanks should go to Chadderuski as it is has been his suggestion to export first to see how things look and respond before trying to upload. Also to back up back up, back up before making changes to the database. :)

Can a product be moved from one category to a newly desired category and subcategory using "FUll-EP_" import?

Example:
Move from: Products^T-Shirts
To: Clearance^T-Shirts

I did this by changing the v_categories_name_1 column from Products^T-Shirts to Clearance^T-Shirts. By doing this it retained the "Product Master Category" and created a linked product.

Furthermore even though it says it has created a linked product, the linked product can NOT be found in the cart. When the product model is searched in the cart, it only shows up in the master category.

The idea was to bulk move products from one category to another!

Kevin205:

Can a product be moved from one category to a newly desired category and subcategory using "FUll-EP_" import?

Example:
Move from: Products^T-Shirts
To: Clearance^T-Shirts

I did this by changing the v_categories_name_1 column from Products^T-Shirts to Clearance^T-Shirts. By doing this it retained the "Product Master Category" and created a linked product.

Furthermore even though it says it has created a linked product, the linked product can NOT be found in the cart. When the product model is searched in the cart, it only shows up in the master category.

The idea was to bulk move products from one category to another!
My thought on this would be to delete the product (status of 9) and then re-upload the product with the desired category. I believe that because assigning the product to more than one category that this creates (or is supposed to create) a linked product and that the statement has been made that EP4 doesn't play well with linked products that the method used will not work.

The problem with what I suggest above is that the existing product(s) will lose their original product I'd and therefore may cause some other issues.

Orriginally I thought that perhaps the category import/export would be the right way to go, but perusing the code I didn't see that it was mandatory or would do anything extra/different. :/

mc12345678:

My thought on this would be to delete the product (status of 9) and then re-upload the product with the desired category. I believe that because assigning the product to more than one category that this creates (or is supposed to create) a linked product and that the statement has been made that EP4 doesn't play well with linked products that the method used will not work.

The problem with what I suggest above is that the existing product(s) will lose their original product I'd and therefore may cause some other issues.

Orriginally I thought that perhaps the category import/export would be the right way to go, but perusing the code I didn't see that it was mandatory or would do anything extra/different. :/

If EP4 can't do this task, then to retain products_id; products have to be moved manually, one by one through Zen Cart's move function.

Thanks for the reply. :no: :yes:

For the lack of time to browse 163 pages, I will post my issue:

I am trying to import a list of categories from a CSV file.

I have the following columns:

v_categories_name_1, v_metatags_keywords_1

I tried before with those two and including the v_categories_id column to specify my own category ID but I took it out. Even after taking it out I still got the same errors.

Every time I try to import, I get nothing but 'No model field in record. This line was not imported' errors for every row.

All I want to do is import categories with no products yet.

Can someone help me please? I have opened the CSV file in Notepad and verified it is comma-delimited (no tabs, blank spaces at end, etc).

Thank you!

I have installed ZC 1.5.3.
Installed EP 4.0
Added 13 custom product fields to the products table.They are all in TEXT format.
Installed TPP 1.10
I plan to install Image Handler 4.

I need TPP to be able to pull content / data from custom fields so that the custom data is displayed in tabs in the product information page of my store.

I read Crazy_Chris' post that was submitted in 2007 which seems to be the easiest to follow instructions so far. But. I am not sure if there have been changes in ZC since 2007, or if the TPP 1.10 Global Tabs instructions are sufficient to pull the data. Or do I need to make the changes that Crazy_Chris outlines and the TPP Global Instructions. I'm not a programmer; but, I am good at following instructions, provided they are clearly written.
I have looked at Numinix 3.0 but most of the custom field names are different than the ones I have created and it modifies ZC 1.5.3 core files.

AJ

jokkah:

For the lack of time to browse 163 pages, I will post my issue:

I am trying to import a list of categories from a CSV file.

I have the following columns:

v_categories_name_1, v_metatags_keywords_1

I tried before with those two and including the v_categories_id column to specify my own category ID but I took it out. Even after taking it out I still got the same errors.

Every time I try to import, I get nothing but 'No model field in record. This line was not imported' errors for every row.

All I want to do is import categories with no products yet.

Can someone help me please? I have opened the CSV file in Notepad and verified it is comma-delimited (no tabs, blank spaces at end, etc).

Thank you!

I believe it is in the first page and in the limited provided documenatation, but may I recommend that you first export the two category options, review the produced file, remove data that is not applicable for what you are going to upload, for the most part leave the fields intact at the top of the file, add the desired data, upload, and then import the file. The category file you will want to use is one without a products model field in it. The filenme can be modified upon save as so that the date/time information is different. Otherwise the filename is both case sensitive and character sensitive.

FoodSourceDirect:

I have installed ZC 1.5.3.
Installed EP 4.0
Added 13 custom product fields to the products table.They are all in TEXT format.
Installed TPP 1.10
I plan to install Image Handler 4.

I need TPP to be able to pull content / data from custom fields so that the custom data is displayed in tabs in the product information page of my store.

I read Crazy_Chris' post that was submitted in 2007 which seems to be the easiest to follow instructions so far. But. I am not sure if there have been changes in ZC since 2007, or if the TPP 1.10 Global Tabs instructions are sufficient to pull the data. Or do I need to make the changes that Crazy_Chris outlines and the TPP Global Instructions. I'm not a programmer; but, I am good at following instructions, provided they are clearly written.
I have looked at Numinix 3.0 but most of the custom field names are different than the ones I have created and it modifies ZC 1.5.3 core files.

AJ

While this appears like a "fun" problem to attempt to correct, I'm afraid that it is not specific to EP4. As well, since you have been able to successfully use EP4 to populate this portion of your tables, I would suggest that you begin a new thread with all of the details above plus a link to the 2007 thread you are referrring to. That way you will receive assistance that is more applicable to your issue. If you like, please post a link here to the new thread so that those interested may follow up with your issue. Regarding various software and versions, it is suggested that you ensure the software you are using is applicable to the version of ZC that you have installed, so it may be necessary to use the version 3.0 if the existing version is not considered compatible with 1.5.3.

Wish you good luck though.

Kevin205:

If EP4 can't do this task, then to retain products_id; products have to be moved manually, one by one through Zen Cart's move function.

Thanks for the reply. :no: :yes:

It maybe time to incorporate a status marker to perform the same move functionality that is performed in ZC. Ideally chadderruski and I can finish our documentation of the existing program first then conquer other aspects of functionality.

jokkah:

For the lack of time to browse 163 pages, I will post my issue:

I am trying to import a list of categories from a CSV file.

I have the following columns:

v_categories_name_1, v_metatags_keywords_1

I tried before with those two and including the v_categories_id column to specify my own category ID but I took it out. Even after taking it out I still got the same errors.

Every time I try to import, I get nothing but 'No model field in record. This line was not imported' errors for every row.

All I want to do is import categories with no products yet.

Can someone help me please? I have opened the CSV file in Notepad and verified it is comma-delimited (no tabs, blank spaces at end, etc).

Thank you!

Jokkah,

The Category import/export does is not used to create the category tree, it is only used to UPDATE the category info like if you want to add descriptions, images, etc.

The categories are only created automatically using the FULL import sheet. You would need at least 1 product in each category, but you could trim out much of the sheet columns to make it simple.

-chadd

mc12345678:

It maybe time to incorporate a status marker to perform the same move functionality that is performed in ZC. Ideally chadderruski and I can finish our documentation of the existing program first then conquer other aspects of functionality.

To add a move feature would not be hard, but would by necessity be a new sheet design.

In the past (and with older version of EP) the "move" was accomplished by first deleting the item with "status = 9" and then
having the same product listed in it's new category with "status = 1"

NOTE: WHEN YOU USE THIS TECHNIQUE, IT WILL ALSO DELETE THE PRODUCT IMAGE! So you will have to reupload them.

Yes, this does create a new products_id in the table.

To add a "move" she is quite possible, but we really need to get this documented and submitted before make more changes/additions.
No ETA on that yet either, sorry.

-chadd

chadderuski:

To add a move feature would not be hard, but would by necessity be a new sheet design.

In the past (and with older version of EP) the "move" was accomplished by first deleting the item with "status = 9" and then
having the same product listed in it's new category with "status = 1"

NOTE: WHEN YOU USE THIS TECHNIQUE, IT WILL ALSO DELETE THE PRODUCT IMAGE! So you will have to reupload them.

Yes, this does create a new products_id in the table.

To add a "move" she is quite possible, but we really need to get this documented and submitted before make more changes/additions.
No ETA on that yet either, sorry.

-chadd

Agree, significant design changes should wait for the documentation. I've started working on the SBA portion of the instructions, but just about that much of it... Started...

Btw, thank you for clarifying the category discussion above I almost can't remember what I was doing at the timme I unsuccessfully tried to help with that one.

Not so certain that a new sheet would be necessary, but that's for future development speak, and perhaps the community would have a weigh-in.

Just wanted to thank to Chad and MC for all they have done.

Kevin205:

Just wanted to thank to Chad and MC for all they have done.

I second the motion i.e. DITTO

AJ

Hi Guys

I am unable to import 3 columns from the Detailed Attributes file. Once I click on the import hyperlink the page it goes to a blank page with this url in the address bar
http://www.books.com/zencart/admin/easypopulate_4.php?import=Attrib-Detailed-EP2014.csv

These are the columns that wont import ,with some data.

v_products_attributes_filename /Books/Chapter1/HarryPottere.pdf
v_products_attributes_maxdays 7
v_products_attributes_maxcount 10

I use the same format as the exports from easypopulate, Full/Basic/Detailed

Is there an error log or something that can help me understand why its not importing

Thanks Paul

Hasher:

Hi Guys

I am unable to import 3 columns from the Detailed Attributes file. Once I click on the import hyperlink the page it goes to a blank page with this url in the address bar
http://www.books.com/zencart/admin/easypopulate_4.php?import=Attrib-Detailed-EP2014.csv

These are the columns that wont import ,with some data.

v_products_attributes_filename /Books/Chapter1/HarryPottere.pdf
v_products_attributes_maxdays 7
v_products_attributes_maxcount 10

I use the same format as the exports from easypopulate, Full/Basic/Detailed

Is there an error log or something that can help me understand why its not importing

Thanks Paul

So, EP4 does provide some error logging with the log file stored in the directory used for your import/export files; however, a blank screen error will typicallybe logged into the ZC error log file which for ZC versions <=1.5.0 is in the stores cache directory and versions >= 1.5.1 is in the logs folder.

Btw, ion a mobile device so I was redirected when I attempted to follow that link, but hopefully that is not a true/valid path to the software. If it is, the admin folder should be renamed. (Possible to have an admin folder named admin in earlier versions of ZC and the version being used was not identified.)

Hasher:

Hi Guys

I am unable to import 3 columns from the Detailed Attributes file. Once I click on the import hyperlink the page it goes to a blank page with this url in the address bar
http://www.books.com/zencart/admin/easypopulate_4.php?import=Attrib-Detailed-EP2014.csv

These are the columns that wont import ,with some data.

v_products_attributes_filename /Books/Chapter1/HarryPottere.pdf
v_products_attributes_maxdays 7
v_products_attributes_maxcount 10

I use the same format as the exports from easypopulate, Full/Basic/Detailed

Is there an error log or something that can help me understand why its not importing

Thanks Paul

mc12345678:

So, EP4 does provide some error logging with the log file stored in the directory used for your import/export files; however, a blank screen error will typicallybe logged into the ZC error log file which for ZC versions <=1.5.0 is in the stores cache directory and versions >= 1.5.1 is in the logs folder.

Btw, I am on a mobile device so I was redirected when I attempted to follow that link, but hopefully that is not a true/valid path to the software. If it is, the admin folder should be renamed. (Possible to have an admin folder named admin in earlier versions of ZC and the version being used was not identified.)

Just attempted first an export from a database, no modifications made, and then an import of the same file that had a name of Attrib-Detailed-EP as a prefix. No white screen result.

Also then went in and modified one value in those three, uploaded, and the value was shown as changed.

Hopefully the issue with the "local" machine can be rectified.

Perhaps I am missing something, but I just added products via Easy Populate 4 and assumed that the new lines in my product descriptions would be converted to <br /> once uploaded. This was not the case. Now I have to manually go into each product to re-format all my descriptions. Is this normal behaviour?

In Admin my settings for Smart Tags Replacement of Newlines and Advanced Smart Tags are both set to True.

k1ra:

Perhaps I am missing something, but I just added products via Easy Populate 4 and assumed that the new lines in my product descriptions would be converted to <br /> once uploaded. This was not the case. Now I have to manually go into each product to re-format all my descriptions. Is this normal behaviour?

In Admin my settings for Smart Tags Replacement of Newlines and Advanced Smart Tags are both set to True.

Also, when adding <br /> tags in EP4, they do not stick when uploaded. However, <br / > tags that were generated when creating products via Admin, do export into EP4.