HI David,
I have uploaded CSV formatted datafeeds, however two things have occured:-
Images are not being displayed. The data feed seems to be correct. (Not for all merchants, just one or two). Its appending the sites URL to the image source.
The Product click thru URL is being appended with this ,,,,. Not sure why?
The data in the database is correct i.e. crrect image URL and correct affiliate link.
See example here:- {link saved}
Tim
Hello Tim,
The Image URL in the feed doesn't actually contain http:// so the browser is attempting to load it from your server (which is the correct behavior if an image URL does not begin with a protocol string). This can be easily fixed using a Text Before filter. In your /compare/admin/ folder, click Filters alongside the feed, and then add a new Text Before filter to the Image URL field. In the text box on the configuration page enter "http://" (without the quotes) and then save the filter.
Regarding the Buy URL containing ,,,, on the end; this appears to be an error in the feed. Since the feed format is pipe separated values, the parser has to assume that ,,,, which is appearing on the end of every row of the feed is part of the last field (which happens to be the Buy URL)! This can be fixed with a Search and Replace filter. Again, click Filters alongside the feed from /compare/admin/ and add a new Search and Replace filter to the Buy URL field. In the Search box on the configuration page for the filter enter ",,,," (without the quotes) and leave the Replace box blank. This should correct the field.
Filters are only applied at import time, so after making changes don't forget to re-import the feed and that should do the trick...
You may have also noticed ? characters appearing at the end of each of the description fields from this feed. This again is corrupt data in the feed - and looks to me like UTF-8 BOM (byte order marker) binary data which should certainly not be there! I can point you towards a fix for this. It will require a new filter - Search and Replace Hex which is described in the following post:
http://www.pricetapestry.com/node/2767#comment-15869
With the new filter added, this time add a new Search and Replace Hex filter to the Description field, and in the Search box, enter
"2EEFBFBD"
...(without the quotes) and leave the Replace box blank.
If you're not sure about making the changes drop me an email and I'll add the code for you.
Cheers,
David.
--
PriceTapestry.com