Adobe Community: Message List - Custom Report .csv export problem

Re: Custom Report .csv export problem

forums_noreply@adobe.com — Mon, 28 Apr 2014 14:55:49 GMT

Tried this on a PC... I can't see the control characters when I open the csv in Excel on a PC (Excel 2007), BUT I still have to erase and retype the first column heading (Name) for the csv file to be usable.

Re: Custom Report .csv export problem

forums_noreply@adobe.com — Sun, 27 Apr 2014 02:52:50 GMT

additional details: I can only see the control characters if I open the file in Excel. If I open the csv in a text editor they do not show. However, even though not visible in a text editor, unless I retype "Name" for example, the file fails to import into another application, in this case ShipStation.com. I've also found that, strangely, I can only seem to fix the problem in Excel - trying to fix the file in a text editor by deleting "Name" and retyping it doesn't work.

Also, I am on a Mac if that makes a difference.

Custom Report .csv export problem

forums_noreply@adobe.com — Sun, 27 Apr 2014 02:46:17 GMT

I have set up a custom report so I can download a csv file with all orders starting 4/1/2014. It is working well except for one small hiccup. Whatever is in the very first position in the first row (the first column header) has a few weird control characters in it that hang things up when importing the file elsewhere. When I download the csv I have to open the csv, fix the first header by retyping it, and resave the file before I can import it into another application.

For example, if the first header is Company Type, the csv includes it as

ï»¿"Company Type"

If the first header is Name, it is in the CSV as

ï»¿"Name"

Any idea why this is happening?