Hi David,
I know you have previously mentioned that if the register function finds a blank field it will stop.
With Affilliate future their feeds often have blank fields which will cause problems when doing automated imports. Can this be changed?
Simon
Ok, but when doing an initial "register" some .txt files are only showing the first 4 or 5 records. I have to edit the file in excel and delete the empty fields before it will work.
Any suggestions?
Hi Simon,
Can you describe in what way it doesn't work... When registering through the admin interface is the format autodetected correctly? You should then be able to register the feed against the contents of the first record, and the blank records will be dropped when you import it.
I'm not completely sure what you mean by "only showing the first 4 or 5 records"...
Cheers,
David.
Hi David,
This example is one im busy with at the moment.
This is what is shown after the initial "register a feed"
FIELD1 14385685
FIELD2 Airgun World
FIELD3 "" " Airgun World is filled with articles and editorial by top gun experts: Britain'...
The next field is the "buy URL" which it just doesn't get too.
Could it be the apostrophe after "Britain" that is causing the problem?
Ah - I see what you mean now.
What format string is the autodetection coming up with? For Affiliate Future the "correct" format string is "csv|9|1|0". Try overwriting the autodetected format string with that and see if it helps - something is obviously messing it up...
That is beacuase the feed you are using is tab seperated
about 30% of the AF feeds differ in this way
if you select Quoted Text - No Header Row - Tab Seperated then those feeds will work!!
its nothing to do with empty fields
Hi David,
It seems to have incorrectly autodetected it. Was solved by manually choosing a "quoted" format.
Thanks for you fanatical support yet again!
Hi David,
I seem to be having issue with the AF feeds as well. I've downloaded the xml feed directly from AF.
When going through the initial feed registration, the initial autodetect is "xml|PRODUCTS/" but none of the fields are detected.
I had a look at the xml file and it has the follow xml elements (below), but i'm not sure how i should structure the autodect.
Also the data within the elements contain i.e.
<Product><id><![CDATA[1]]></id>
<merchantSiteId><![CDATA[191]]></merchantSiteId>Does this affect the detection process?
regards
Rod
Hi Rod,
Try changing the format string in the text box on Feed Registration (Step 1) to:
xml|PRODUCTS/MERCH/PROD/That should do it..
Cheers,
David.
Hi David,
unfortunately that didn't work either.
below is the feed i'm having issues with
{link saved}
regards
Rod
Hello Rod,
Were it to be valid, that feed is actually in the old format, which requires the Format String:
xml|PRODUCTS/PRODUCT/...however the file appears to be corrupt with records terminating prematurely; with the closing <product> tag cropped or missing.
I would obtain a fresh URL for this merchant using the Datafeed (Old) link from the menu. I use the following core URL for Affiliate Window merchants:
http://datafeeds.productserve.com/datafeed_products.php?user=USERID&password=996b526b722ed6e66d9b20b1ad668f87&mid=MERCHANTID&format=XML(replace USERID and MERCHANTID as required)
Cheers,
David.
The import process only checks for the required fields:
If any of those are missing the record is dropped. For a record to be dropped if any other field is blank you would need to configure a Drop Record filter, so there shouldn't be any problems...