EasyPopulate 4.0 Support Thread

[chadderuski]

Hello,
I opened this file in notepad for copynpaste here.

"v_products_model" "v_categories_name_1"
"M4683G/A" "Toner-MONO^APPLE"
"M2473G/A" "Toner-MONO^APPLE"
"M2473G/A Extended" "Toner-MONO^APPLE"
"C3900A" "Toner-MONO^APPLE"
"DR400" "Toner-MONO^BROTHER"
"DR350" "Toner-MONO^BROTHER"


The above gave me the following when I imported the .csv file created with save as from open office:

Import Results


Filename: Category-EP2012Mar27-174859.csv

No model field in record. This line was not imported
No model field in record. This line was not imported
No model field in record. This line was not imported
No model field in record. This line was not imported

That's not a CSV file "Comma Separated Values". You probably selected TAB as the delimiter and is why it's failing.

-chadd

[vwaltz]

That's not a CSV file "Comma Separated Values". You probably selected TAB as the delimiter and is why it's failing.

-chadd

Hello, when using the sample file below I get a 500 error. website cannot display the page after trying to import the csv file.

"v_products_model","v_products_name_1","v_products_price","v_manufacturers_name" ,"v_categories_name_1"
"M4683G/A","M4683G/A",57.2,"Apple","Toner-MONO^APPLE"
"M2473G/A","M2473G/A",33.15,"Apple","Toner-MONO^APPLE"
"M2473G/A Extended","Extended",41.6,"Apple","Toner-MONO^APPLE"
"C3900A","C3900A",50.7,"Apple","Toner-MONO^APPLE"
"DR400","DR400",45.5,"Brother","Toner-MONO^BROTHER"

[itshoptrader]

Hi,
I'm start using EP4 with zencart 1.3.9a. Is working perfect, the only problem i have is to update with the new csv. I'm using a csv file from my supplier but they do not have included the primary categories (only subcategories which are too many). I used to populate first time my zencart and then from administration i moved all the products in categories and subcategories. Now, the problem is, if i want to update the products and prices how i have to do that without changing the categories already created. Or is there any option to update automatically the csv file in excel from the master csv supplied? There are too many products to do it manually.
Thanks.

Please check:
www.itshoptrader.co.uk

[chadderuski]

Hi,
I'm start using EP4 with zencart 1.3.9a. Is working perfect, the only problem i have is to update with the new csv. I'm using a csv file from my supplier but they do not have included the primary categories (only subcategories which are too many). I used to populate first time my zencart and then from administration i moved all the products in categories and subcategories. Now, the problem is, if i want to update the products and prices how i have to do that without changing the categories already created. Or is there any option to update automatically the csv file in excel from the master csv supplied? There are too many products to do it manually.
Thanks.

Please check:
www.itshoptrader.co.uk

For existing products, you can use the Model/Price/Qty sheet format... you wont need categories since they are already defined.

For new products, you could create a non-active category and import to there first. This is hard to know for certain without seeing your sheet. If you want, you can PM me and I can take a look at it.

chadd

[itshoptrader]

For existing products, you can use the Model/Price/Qty sheet format... you wont need categories since they are already defined.

For new products, you could create a non-active category and import to there first. This is hard to know for certain without seeing your sheet. If you want, you can PM me and I can take a look at it.

chadd

Thanks.
I also want to know if is possible to do an automatic update with ftp. Do you want to see the original csv from my supplier?

[chadderuski]

Thanks.
I also want to know if is possible to do an automatic update with ftp. Do you want to see the original csv from my supplier?

This would be CRON support. I don't have direct CRON support added at this time.

Send me a PM and I'll look at your supplier file.

-chadd

[chadderuski]

Hello, when using the sample file below I get a 500 error. website cannot display the page after trying to import the csv file.

"v_products_model","v_products_name_1","v_products_price","v_manufacturers_name" ,"v_categories_name_1"
"M4683G/A","M4683G/A",57.2,"Apple","Toner-MONO^APPLE"
"M2473G/A","M2473G/A",33.15,"Apple","Toner-MONO^APPLE"
"M2473G/A Extended","Extended",41.6,"Apple","Toner-MONO^APPLE"
"C3900A","C3900A",50.7,"Apple","Toner-MONO^APPLE"
"DR400","DR400",45.5,"Brother","Toner-MONO^BROTHER"

Hi Waltz,

How large is your file? This is more about your server settings timing out when you upload the file with http. Are you on shared hosting? With who?

If you have a very large CSV file, you could first ftp it to your admin directory, then run the Split function should importing generate 500 errors. There are a number of settings you can change depending on your hosting, but that is beyond this thread.

[vwaltz]

Hi Waltz,

How large is your file? This is more about your server settings timing out when you upload the file with http. Are you on shared hosting? With who?

If you have a very large CSV file, you could first ftp it to your admin directory, then run the Split function should importing generate 500 errors. There are a number of settings you can change depending on your hosting, but that is beyond this thread.

Can't understand why this isn't working. Can you post a copy of what a line is supposed to look like? I tried to load the info below. as you can see it isn't very big. I got the web site can't display page error with it.

"v_products_model","v_products_name_1","v_products_price","v_manufacturers_name" ,"v_categories_name_1"
"M4683G/A","M4683G/A",57.2,"Apple","Toner-MONO^APPLE"
"M2473G/A","M2473G/A",33.15,"Apple","Toner-MONO^APPLE"
"M2473G/A Extended","Extended",41.6,"Apple","Toner-MONO^APPLE"
"C3900A","C3900A",50.7,"Apple","Toner-MONO^APPLE"
"DR400","DR400",45.5,"Brother","Toner-MONO^BROTHER"
"DR350","DR350",55.9,"Brother","Toner-MONO^BROTHER"
"TN360","TN360",35.75,"Brother","Toner-MONO^BROTHER"
"TN330","TN330",31.2,"Brother","Toner-MONO^BROTHER"
"DR360","DR360",53.3,"Brother","Toner-MONO^BROTHER"

[chadderuski]

Hi Waltz,

What is your setting for "Script Execution Time" under Configuration -> Easy Populate 4

and

"Admin Set max_execution_time for processes" under Configuration -> My Store

and

"Maximum File Upload Size" under Configuration -> Max Values

Do you have access to your php.ini file in the root of our site? Or does your host prevent that?

Answer these and we'll see where that takes us.

-chadd

[vwaltz]

Hi Waltz,

What is your setting for "Script Execution Time" under Configuration -> Easy Populate 4

and

"Admin Set max_execution_time for processes" under Configuration -> My Store

and

"Maximum File Upload Size" under Configuration -> Max Values

Do you have access to your php.ini file in the root of our site? Or does your host prevent that?

Answer these and we'll see where that takes us.

-chadd

Hello,
Configuration->Script Executation Time is 60
Admin Set max_execution is 60
Max File Upload Size is 2048000
I can access php.ini file

Thanks.