File Exchange CSV fields - job abandoned with no error message

[huntfor]

@dollybeauty and @shipscript  Here's the file we're discussing.

http://s000.tinyupload.com/?file_id=00851142603746333946

Can I delete it from the server it was generated from?

Thank you!

[shipscript]

@huntfor 

This is what I see in that file:

"*Action"^"CustomLabel"^"*Category"^"StoreCategory"^"*Title"^"Subtitle"^"

Any idea why there are caret delimiters instead of comma delimiters?  Does your original look like that? Is your spreadsheet defaulting that way?

eBay will accept tab, comma, or semicolon delimiters but not the ^ symbol.

[huntfor]

I don't have carets in my csv, but I use them for my website csv's. I'll change the character.  Thanks!

Before your reply, I created a single item and uploaded it but it failed.

Can I delete that link from tiny upload now?

[shipscript]

I've got a copy of your CSV, and can share with dollybeauty if needed, so yes, go ahead a delete.

[huntfor]

Thank you! I created a single item csv with comma separator and am uploading it.

[shipscript]

Additionally, my prior testing has shown that the header row can not contain quotes. Does your spreadsheet have quotes in the header row or is that another artifact of your server.

[huntfor]

Here's a screenshot of my csv import choices. The text delimiter does show quotes. 

Is there anything else on this screenshot that should be changed, please?

Thanks!

[shipscript]

Thirdly, the downloaded file was in UTF8 format. Again, don't know if that is a server artifact, but eBay's File Exchange does not accept UTF8 (despite remarks to the contrary in the manual). My prior experimentation with UTF8 was that File Exchange choked on the leading three bytes designating UTF8, rejecting the job.

[huntfor]

What settings should I use, please?

[shipscript · Accepted solution]

The settings look ok, but UTF8 should be changed to western ISO-8859-1

[huntfor]

Changing it now. Thanks.

[huntfor]

Are quotes ok in the Text Delimiter field?

[huntfor]

@shipscript I made the import changes but the file still failed.  I'll try to do a single item. 

[shipscript]

Those are your import settings. They should create a correct CSV when exported or saved, but I don't have a modern spreadsheet to verify export settings.

Be sure to save or export as Windows CSV and not Mac CSV.

[huntfor]

I only have Mac hardware. To counteract that with what I have to use for my website, I use LibreOffice. 

Any ideas, please?