EasyPopulate 4.0 Support Thread

I'm having troubles importing a Detailed Products Attributes file. We're trying to update from one site (wholesale) to another (retail).

I export a Detailed Attributes from wholesale, remove all but one product (to simplify testing) and remove all columns but those listed below. I assumed (this is probably the problem) the v_products_model would be used as the primary field. The model number is consistent between both sites while the v_products_attributes_id and v_products_id are not, which is why I removed those columns.

When importing the Detailed Attributes file, can the v_products_model be used as the key?

The file I imported had the following columns:
v_products_model, v_options_id, v_products_options_name, v_products_options_type, v_options_values_id, v_products_options_values_name, v_products_options_sort_order

and the result was SKIPPED! - Attribute Entry on : - Not Found! for each attribute in the file (five of them).

jeking:

I'm having troubles importing a Detailed Products Attributes file. We're trying to update from one site (wholesale) to another (retail).

I export a Detailed Attributes from wholesale, remove all but one product (to simplify testing) and remove all columns but those listed below. I assumed (this is probably the problem) the v_products_model would be used as the primary field. The model number is consistent between both sites while the v_products_attributes_id and v_products_id are not, which is why I removed those columns.

When importing the Detailed Attributes file, can the v_products_model be used as the key?

The file I imported had the following columns:
v_products_model, v_options_id, v_products_options_name, v_products_options_type, v_options_values_id, v_products_options_values_name, v_products_options_sort_order

and the result was SKIPPED! - Attribute Entry on : - Not Found! for each attribute in the file (five of them).
Yeah, that is/was the problem. For the detailed attributes, the attributes themselves are the important part which are so defined for the software by use of the applicable option/attribute related _id. There is the process at the following post that I provided not too long ago that worked for the individual asking to do the very same thing: https://www.zen-cart.com/showthread.php?190417-EasyPopulate-4-0-Support-Thread&p=1312443#post1312443

mc12345678:

Yeah, that is/was the problem. For the detailed attributes, the attributes themselves are the important part which are so defined for the software by use of the applicable option/attribute related _id. There is the process at the following post that I provided not too long ago that worked for the individual asking to do the very same thing: https://www.zen-cart.com/showthread.php?190417-EasyPopulate-4-0-Support-Thread&p=1312443#post1312443

Thanks for the reference to the post. That was a workable solution.

jeking:

Thanks for the reference to the post. That was a workable solution.

Glad that worked out.

i am using zencart 1.5.5a and have installed the latest version of EP 4,file was uploaded sucessfully,but the bad thing is when i click import,it reminds me ERROR: Import file does not exist:....I am sure the file is indeed there,i also try to upload the file to temp folder..Also one more strange thing,when i click delete file,the file still there and i could not delete,would be appreciate if anyone could help me,thanks

e-standard:

i am using zencart 1.5.5a and have installed the latest version of EP 4,file was uploaded sucessfully,but the bad thing is when i click import,it reminds me ERROR: Import file does not exist:....I am sure the file is indeed there,i also try to upload the file to temp folder..Also one more strange thing,when i click delete file,the file still there and i could not delete,would be appreciate if anyone could help me,thanks
Well that's completely new and unusual.

It does seem like it would stem from the designation of the path as entered in the configuration panel for the file location.

For starters and without possibly posting your actual admin directory path if it is included, what do you have for the path of the temp directory and what is the setting regarding whether in admin or catalog side? (if your admin directory is included in that path, just use the folder admin or some other obscured entry like XXX.)

mc12345678:

Well that's completely new and unusual.

It does seem like it would stem from the designation of the path as entered in the configuration panel for the file location.

For starters and without possibly posting your actual admin directory path if it is included, what do you have for the path of the temp directory and what is the setting regarding whether in admin or catalog side? (if your admin directory is included in that path, just use the folder admin or some other obscured entry like XXX.)

Thanks very much for your eply,here is my settting in catalog

Here is the error i got when i import:
ERROR: Import file does not exist:/home/estanda1/public_html/xxx/temp/AASHTO+2014+CSV.csv

The file also could not be deleted..

I find something wired,the file name is AASHTO 2014 CSV.csv,when i change to AASHTO.csv everything works fine,can not not add any bank or other words after it,it should have something with the software itself,what should i do now to solve the problem?

e-standard:

I find something wired,the file name is AASHTO 2014 CSV.csv,when i change to AASHTO.csv everything works fine,can not not add any bank or other words after it,it should have something with the software itself,what should i do now to solve the problem?

Umm, so almost every reference in this forum to saving a file to the server is to not include a space in the filename. Also, it is generally suggested that filenames be all lowercase. The filenames generated by EP4 use either underscores or dashes for "space". If you are able to ftp to your site you could either rename or delete the file(s) or ask your host. Be advised though that depending on the type of import/export file the first part of the filename is important to the program and should not be renamed. The first part typically includes everything up to and including '-ep'.

mc12345678:

Umm, so almost every reference in this forum to saving a file to the server is to not include a space in the filename. Also, it is generally suggested that filenames be all lowercase. The filenames generated by EP4 use either underscores or dashes for "space". If you are able to ftp to your site you could either rename or delete the file(s) or ask your host. Be advised though that depending on the type of import/export file the first part of the filename is important to the program and should not be renamed. The first part typically includes everything up to and including '-ep'.

Thank you very much for your help,but i did not find this problem when i am using ZC 1.3.9 and EP 4.0::blink:

e-standard:

Thank you very much for your help,but i did not find this problem when i am using ZC 1.3.9 and EP 4.0::blink:

What version of EP 4 was being used when "this problem" didn't exist? The current version (4.0.35.ZC) continues to work on ZC 1.3.9 also. The significant difference in regards to the file handling of this version to some of the older is the use of $_POST more so than previous versions instead of putting the information on the url using a $_GET.

This may be the first sanitization issue to come across related to the patches that are expected to be applied to all ZC 1.5.x but come mostly standard to ZC 1.5.5.a. Since that filename format is not one that I would typically use nor suggest, no testing was applied to it.

mc12345678:

What version of EP 4 was being used when "this problem" didn't exist? The current version (4.0.35.ZC) continues to work on ZC 1.3.9 also. The significant difference in regards to the file handling of this version to some of the older is the use of $_POST more so than previous versions instead of putting the information on the url using a $_GET.

This may be the first sanitization issue to come across related to the patches that are expected to be applied to all ZC 1.5.x but come mostly standard to ZC 1.5.5.a. Since that filename format is not one that I would typically use nor suggest, no testing was applied to it.

The version i used for old zencart 1.3.9 is Easy Populate 4.0.19 - Beta 1-28-2012,everything works fine.

Expecting updating to solve the problem for zencat 1.5.5a,thank you very much.

Hi There,

I am using ZC 1.5.5a for my store. Someone may have had the same problem or may have posted for help but I have gone through this post and can't find anything.

I am trying to get my Attribute file on EP to work but I keep on getting the word SKIPPED every time I upload it to my store. Any help how to fix this would be a great help. You can see an image of what getting below.

LittleAngell52:

Hi There,

I am using ZC 1.5.5a for my store. Someone may have had the same problem or may have posted for help but I have gone through this post and can't find anything.

I am trying to get my Attribute file on EP to work but I keep on getting the word SKIPPED every time I upload it to my store. Any help how to fix this would be a great help. You can see an image of what getting below.

If notice, not all records are skipped, just some of them. While the error reporting does not appear very helpful as is, the statement indicates that there is something wrong with the assignment/existence of applicable option values to the product in question. Has a basic attribute file been used to apply the option name/value pairs to all of the products?

BTW, while not text searchable, the admin folder of the site appears to be presented in the image. Recommendation is to rename the admin directory and not posting it again in the future. :)

mc12345678:

If notice, not all records are skipped, just some of them. While the error reporting does not appear very helpful as is, the statement indicates that there is something wrong with the assignment/existence of applicable option values to the product in question. Has a basic attribute file been used to apply the option name/value pairs to all of the products?

BTW, while not text searchable, the admin folder of the site appears to be presented in the image. Recommendation is to rename the admin directory and not posting it again in the future. :)

It's the new download files that get skipped and can't work out how to add them via ep.

LittleAngell52:

It's the new download files that get skipped and can't work out how to add them via ep.

The error is related to not being able to find an existing record to be updated. With the detailed attributes file, it is primarily setup to first export the file of known attributes, then to update the individual records (fields) of it and import those changes.

This is based on the following sql: ```
SELECT * FROM ' . TABLE_PRODUCTS_ATTRIBUTES . '
WHERE (
products_attributes_id = :products_attributes_id: AND
products_id = :products_id: AND
options_id = :options_id: AND
options_values_id = :options_values_id:
) LIMIT 1;

If that sql comes back with no results then the error in the above image is provided.

mc12345678:

The error is related to not being able to find an existing record to be updated. With the detailed attributes file, it is primarily setup to first export the file of known attributes, then to update the individual records (fields) of it and import those changes.

This is based on the following sql: ```
SELECT * FROM ' . TABLE_PRODUCTS_ATTRIBUTES . '
WHERE (
products_attributes_id = :products_attributes_id: AND
products_id = :products_id: AND
options_id = :options_id: AND
options_values_id = :options_values_id:
) LIMIT 1;

> 
> If that sql comes back with no results then the error in the above image is provided.

Right so how do I add or can I add my downloadable files via EP? I always add the products to the store first and upload all my downloadable files.

LittleAngell52:

Right so how do I add or can I add my downloadable files via EP? I always add the products to the store first and upload all my downloadable files.
Next would be to assign the attribute to the product using the attribute basic type file, and then the attributes detailed (current file that is only partially working) to provide refined information for the individual product.

mc12345678:

Next would be to assign the attribute to the product using the attribute basic type file, and then the attributes detailed (current file that is only partially working) to provide refined information for the individual product.

Right, I will give that a try today and let you know if it has worked or not. If it doesn't then I will scream. LOL

mc12345678:

Next would be to assign the attribute to the product using the attribute basic type file, and then the attributes detailed (current file that is only partially working) to provide refined information for the individual product.

Aww, it worked and thank you so much for your help mc12345678. :hug:I don't know what I would do without this forum as been so helpful to get things done in my store.