Exporting Format Errors

  • Resolved rossbrunson

    (@rossbrunson)


    6 years, 10 months ago

    Hi all,

    Anyone else having an issue exporting to csv/tsv/xml?

    When I export ANYTHING from ANY table, in ALL my browsers, all I get is a page that seems to be an appropriate output, but instead of having the data like this:

    “ID”,”last_counter”,”engine”,”host”,”words”,”visitor”
    “1”,”2016-04-23″,”google”,”www.google.com”,””,”7″
    “2”,”2016-04-28″,”google”,”www.google.com”,””,”29″
    “3”,”2016-04-28″,”google”,”www.google.com”,””,”76″

    The data is all one long string like this:

    “ID”,”last_counter”,”engine”,”host”,”words”,”visitor” “1”,”2016-04-23″,”google”,”www.google.com”,””,”7″ “2”,”2016-04-28″,”google”,”www.google.com”,””,”29″ “3”,”2016-04-28″,”google”,”www.google.com”,””,”76″

    I have tried pasting this into various spreadsheet apps, using bbedit to find any control strings in it, to no avail.

    I’m frankly stumped, and it doesn’t seem to matter what browser or what table, the CR/LF are not there to make it actionable data.

    Thanks for any help.

    Ross

Viewing 1 replies (of 1 total)
  • Thread Starter rossbrunson

    (@rossbrunson)

    Well, what do you know, I fixed the issue!

    The page that shows your output is just showing the data in a browser container, so doing “view source” in your browser shows the actual CSV/TSV/XML data in that window, which I then did the following with:

    1. Show Source
    2. Copy and paste source into text editor
    3. Save file as something.csv
    4. run “sort something.csv | uniq > something_else.csv”
    5. Import into spreadsheet, and it works!

    The sort is to get all blank lines in a group, and then uniq removes all non-unique data lines from the file, mine had about as many blank lines as data lines.

    Hope this helps everyone.

    Ross

Viewing 1 replies (of 1 total)
  • The topic ‘Exporting Format Errors’ is closed to new replies.

Tags