You are here:  » Feed Import Error

Support Forum



Feed Import Error

Submitted by Biff on Sun, 2009-01-04 11:41 in

I'm getting the following error when importing a feed. The Trial Import works fine, but when doing a full import the error occurs a couple of minutes into the import.

"CGI Error
The specified CGI application misbehaved by not returning a complete set of HTTP headers."

Any ideas on how to rectify it? I'm hosting the script on a Windows server running PHP 4.7.

Submitted by support on Mon, 2009-01-05 09:29

Hi Biff,

This is almost certainly because your web server has timed out waiting for a response from PHP. I'll email you an alternative version of admin/feeds_import.php that generates a constant output during the import process which should help...

Cheers,
David.

Submitted by Biff on Tue, 2009-01-06 11:07

Hi David, I've just replied to your email but thought I would post it here too in case it helps anyone else.

Thanks for the new file. It works okay with XML feeds but still times out when importing CSV feeds. The XML feeds also import much faster. As the script is running it displays the number of products imported but on all my tests it stalls somewhere after 20,000 products.

The autodetect when importing the CSV says csv|44|1|0 but I select "Quoted Text - Header Row - Comma Separated" from the dropdown as otherwise I get quotes show up around the links which renders them useless. It is a comma separated csv with a header row so I assume this isn't the problem?

Also, the feed contains 27,000+ products but the site is only showing around 10,400. The new script, which gives a count of the number of items imported goes up to 27,800 but for some reason only 10,400 appear on the site. Could this be a problem with the database?

Submitted by Rocket32 on Fri, 2009-01-09 05:23

Hi David,

I need a copy of the new admin/feeds_import.php file also. My feed has 70,000 products and times out. It does not show how many in the admin secton, but when you browse to the merchant on the site it shows around 10,000 products.

Thanks,

Roy

Submitted by support on Fri, 2009-01-09 09:16

Hello Roy,

I will email you the output generating feeds_import.php and also the faster CSV version of the parser...

Cheers,
David.