You are here:  » Import problem [resolved]


Import problem [resolved]

Submitted by arthuc01 on Thu, 2006-02-09 16:03 in

Hi

For some reason i can't seem to get the system to import a feed through the admin panel, i had thought it was a time out issue but I don't get any error message and admin_import appears to execute (or at least it goes to the end without an error message the redirects with the header("Location: index.php");

I've tried it on my hosts lamp and on my EasyPHP WAMP but neither seem to want to import.

I've tried two different feeds, one quite large so i would have expected a time out error if anything, and tghe second only about 20 items but both still fail.

Thanks in advance for any suggestions

Chris

Submitted by support on Thu, 2006-02-09 16:07

Hi Chris,

Just to confirm - have you just been importing using the command line version scripts/import.php until now?

Thanks,
David.

Submitted by arthuc01 on Thu, 2006-02-09 16:19

Hi Dave, I don't have telnet access so have only tried via feed_import.php
C

Submitted by support on Thu, 2006-02-09 16:22

Ah ok - so you've not yet been able to import any products at all?

Submitted by arthuc01 on Thu, 2006-02-09 16:32

PHPInfo...
http://now3k.co.uk/phpinfo.php

As i've saind in another post i currently have Safe mode off - so that I can set_time_limit and register globals off set through htaccess

database connection is fine in that in that setup has been able to populate the tables initially

Submitted by searley on Thu, 2006-02-09 16:35

I see you have the novatech feed, did you get that from AW?? if so it is broken!! i can not import it either!!

there are a couple more aw feeds that dont work aswell!!

Submitted by support on Thu, 2006-02-09 16:36

searley - what's broken about it?

Submitted by arthuc01 on Thu, 2006-02-09 16:38

Yes it is from AW, and the other feed i've tested is the Hush Homeware one which is very small
C

Submitted by arthuc01 on Thu, 2006-02-09 16:40

Dave if you want to see it its at...
http://now3k.co.uk/feeds/xmloutput61408957.xml
Beware its about 9Mb...its the big one I've been testing

The smaller one is
http://now3k.co.uk/feeds/hush.xml
Which is 34k

Submitted by searley on Thu, 2006-02-09 16:41

If you take a look at:

http://shoppingchanneluk.com/feeds/awnovatech.txt
http://shoppingchanneluk.com/feeds/awappliancewarehouse.txt

you will see colum 4 master category breaks to a new line, when i download the file to my pc and open the file in notepad the is a funny symbol looks like a square

this seemd to prevent the import

Submitted by arthuc01 on Thu, 2006-02-09 16:42

hush feed validates at
http://www.hcrc.ed.ac.uk/~richard/xml-check.html

Submitted by support on Thu, 2006-02-09 16:43

Novatech just went on to my test site OK. I'm having a look at the code now, Chris, to see if I can figure why nothing's happening on your server! Database update is obviously working because the registration process created the feed record, and the Parser must be OK otherwise you wouldn't have been able to register the feed; so it's a strange one...

I'm on the case..

Submitted by searley on Thu, 2006-02-09 16:49

actually you will find you have only imported 5000 novatech items from the 7500 this is probably because not every line in the nova feed is corruptd

but the appliance feed i showed you above, only 1 product imported!!

Submitted by support on Thu, 2006-02-09 16:50

Chris - one thing to check - make sure that you are selecting "PRODUCTNAME" and not just "PRODUCT" as the Product Name field when using Affiliate Window XML feeds...

Submitted by arthuc01 on Thu, 2006-02-09 17:00

Cheers for that - I think i was boll*cksing up by choosing "PRODUCT" instead of "PRODUCTNAME" - novatach and hush have now both imported fine

Submitted by support on Thu, 2006-02-09 17:02

Looks good - although I notice that you are missing the semi-colon off the end of &pound - check your $config_currenyHTML...you should have:

$config_currencyHTML = "£";

Submitted by arthuc01 on Thu, 2006-02-09 17:09

Maybe not quite all fixed - as Searly says on the import - in the admin section it says I have imprted 7500ish products but on the http://now3k.co.uk/merchant/Novatech/ it only lists 5653 ?

fixed the pound things, well spotted :-)

Submitted by support on Thu, 2006-02-09 17:12

The import process does a sanity check on each record and if the required fields are empty (which is quite possible in a broken feed) then the record is skipped.

Unfortunately, in the Novatech feed there are several hundred records dropped during the import process because one of more of the required fields are missing.

There is nothing you can really do about this i'm afraid. There is a project going on at A4UForum that I think is going to try and establish some quality guidelines regarding product feeds; but for the time being i'm afraid this is a fact of product feed life!

Submitted by arthuc01 on Thu, 2006-02-09 17:15

Cheers for that Dave, I'm glad theres a sensible answer and its not something else i've done wrong :-)