search

simonv3 / quick-survey

A tool for quick surveys, try it out. (No longer maintained).
https://apps.sandstorm.io/app/wupmzqk4872vgsye9t9x5dmrdw17mad97dk21jvcm2ph4jataze0
MIT License
116 stars 49 forks source link

CSV export is inconsistent / produces too many cells #54

Open neynah opened 7 years ago

neynah commented 7 years ago

Unfortunately I can't share a screenshot of the data (for privacy reasons) but I have 11 responses in the survey, however, the CSV export produces 18 rows of responses.

What appears to be happening is some of the long answers are being split into multiple cells. One respondent typed up a list of 6 apps they're using and each word was placed in its own cell. I have a feeling that commas are the issue.

simonv3 commented 7 years ago

Agh, yeah, that seems likely. The content of each value should probably be escaped and put in an encapsulating string. Though that seems like it would cause multiple columns, not rows. Do the results have newlines in them maybe?

neynah commented 7 years ago

The result is that data that would normally only take up 1 cell (in a column) now take up multiple cells. So the answer for Question 1 may show up under the the Question 1 column as well as the Question 2 column, etc. For a given row, once each cell in each column is taken up, new row is created to accommodate for the additional cells (produced by this error).

john5601 commented 7 years ago

I have encountered the same problem as @neynah, some of my responses will separate into multiple cells!

Sohalt commented 5 years ago

This is fixed by https://github.com/simonv3/quick-survey/pull/72 but there has not been a new release since.