CSV Export Formatting Issue

  • Resolved jbelzman

    (@jbelzman)


    5 years, 11 months ago

    Downloaded CSVs of results aren’t formatting correctly. Some headers are missing, fields contain strange entries such as pieces of the quiz name, no results, etc. Is this because we haven’t installed the Results Light plugin?

    In HD Quiz Results I see this:

    View post on imgur.com

    But the exported CSV looks like this:

    View post on imgur.com

    • This topic was modified 5 years, 11 months ago by jbelzman.
Viewing 1 replies (of 1 total)
  • Plugin Author Harmonic Design

    (@harmonic_design)

    5 years, 11 months ago

    Hi jbelzman,
    this is an easy mistake to make.

    CSV stands for Comma Separated Values. This means that each field (in our case quiz name, date, score, user) needs is separated with a comma ,.

    The problem you have here is that your quiz name is Gander Quiz: Test, Test, Test which includes two commas, which causes your CSV to contain two erroneous extra columns.

    Based on your quiz name, I assume that this was just a test, so probably won’t be an issue for you moving forward. However, something you can do is open the CSV file using a text editor, then do a search/find for the text Test, Test, Test and replace it with something else such as Test Test Test.

    Hope this makes sense!

    (Also, I’ll try and detect this issue in a future update for HD Quiz Save Results Light and try and clean out commas in quiz names before exporting as CSV)

Viewing 1 replies (of 1 total)

The topic ‘CSV Export Formatting Issue’ is closed to new replies.

Tags