Hi, I'm back again, already, with another problem! Sorry if this has been covered already - I searched the forums for a solution, but to no avail.
When creating my google base data feed I keep encountering the same problem - carriage returns being present in the store description field that then break the tab delimited csv feed, meaning hundreds of products do not parse correctly and thus don't show up on google base.
I recently issued guidelines to anyone who adds products to NS not to copy and paste out of MS Office to keep nasty MS office code and carriage returns out, and went through our one thousand or so products cleaning the carraige returns out of the description field using notepad++.
Today, I go to submit the googlebase feed again, and there are 405 errors relating to the carriage returns. The funny thing is, that of these, a significant number are present in products that I cleaned of issues just last week, and haven't since been edited, so fewer products have parsed correctly than last week, in spite of more items being added to the csv!
My questions are:
1) Where have these CRLF's at the end of each description appeared from - I removed them all last week? My mistake, these are a product of tab delimited feeds I think.
2) Is this creating the issue in my googlebase feed? (I know for a fact that CRFLs in the description create a new line in the csv, but does the one that seems to insert itself at the end of the description do this too?)
3) Can I stop NS adding these?
IGNORE THESE, I'm an idiot!
4) Is there a better way to remove the carriage returns from the description field then manually? Manually editing products on a weekly/monthly basis to ensure the googlebase feed works correctly does not appeal to me!
Could do with knowing this though!