EasyPopulate 4.0 Support Thread

[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.

[chadderuski]

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.

Your Zencart settings are fine.

Check your php.ini file. Look for these:

max_execution_time = 300
max_input_time = 300
memory_limit = 64M

Those numbers are from my VPS server. If you are in a shared hosting environment, start by increasing them moderately. Post your numbers.

What kind of hosting are you using? Which browser?

Oh, also make sure there aren't any extra "//" in your url except after http://www.....

-chadd

[vwaltz]

Your Zencart settings are fine.

Check your php.ini file. Look for these:

max_execution_time = 300
max_input_time = 300
memory_limit = 64M

Those numbers are from my VPS server. If you are in a shared hosting environment, start by increasing them moderately. Post your numbers.

What kind of hosting are you using? Which browser?

Oh, also make sure there aren't any extra "//" in your url except after http://www.....

-chadd

Hello,
I had a failure with the new settings also. I'm using IE browser. Hosting is linix.

Previous settings:
memory_limit - 48M
max_input_time - 60
max_execution_time - 30

New settings:
max_execution_time = 300
max_input_time = 300
memory_limit = 64M

I don't know if this means anything. If I export the Model/Category option from the Full Export Options, the import I do also fails.

Thanks.

[chadderuski]

Hello,
I had a failure with the new settings also. I'm using IE browser. Hosting is linix.

Previous settings:
memory_limit - 48M
max_input_time - 60
max_execution_time - 30

New settings:
max_execution_time = 300
max_input_time = 300
memory_limit = 64M

I don't know if this means anything. If I export the Model/Category option from the Full Export Options, the import I do also fails.

Thanks.

I don't see anything wrong with your original settings for PHP.

If you do a full Export, then do a direct Import (not file upload), you are also getting a 500 Server Error? If so, then you need to contact your hosting as it must be a server related issue.

How many products in your store? A a decent server, 50,000 records can process in about 3 minutes. WHO IS YOUR WEB HOST?

From within your Admin, click the Version... scroll down to see if your php settings are accepted. Some hosting over ride this.

[Cydonian]

Hi Zenners,

How can I use a Cron job to auto import a daily uploaded CSV file using easy populate 4 in Zen Cart 1.5.5f ?
Thanks in advance,

Cyd