2 Replies Latest reply: Apr 28, 2014 7:55 AM by will_in_KC RSS

    Custom Report .csv export problem

    will_in_KC Community Member
    will_in_KC Apr 26, 2014 7:46 PM

      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?

        • 1. Re: Custom Report .csv export problem
          will_in_KC Community Member
          will_in_KC Apr 26, 2014 7:55 PM (in response to will_in_KC)

          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.

          • 2. Re: Custom Report .csv export problem
            will_in_KC Community Member
            will_in_KC Apr 28, 2014 7:55 AM (in response to will_in_KC)

            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.