getodk / getodk

Wiki and Issues (copied from https://code.google.com/p/opendatakit/)
https://getodk.org/
Apache License 2.0
122 stars 70 forks source link

Suggestions for Briefcase CSV #218

Closed mitchellsundt closed 7 years ago

mitchellsundt commented 9 years ago

Migrated to opendatakit/briefcase#2 by spacetelescope/github-issues-import

Originally reported on Google Code with ID 217

From Manna Energy

null fields show in the briefcase csv as nothing so you end up with a bunch of commas
in a row when there is a null value from an optional field that was skipped. This,
combined with the fact all the other fields with values have quotation marks, makes
it difficuilt to parse the csv via delimiters. Cant use commas because those can be
in the strings as well, but you cant use "," either because the null fields are lacking
quotes. We had to resort to some craftyness to properly delimit the csv. 

Reported by wbrunette on 2011-05-20 22:13:03

mitchellsundt commented 9 years ago

Migrated to opendatakit/briefcase#2 (comment) by spacetelescope/github-issues-import

There's actually an RFC describing CSV file formats.  
The complaints are a critique of the CSV file format, which Briefcase adheres to:

http://tools.ietf.org/html/rfc4180

Changing to documentation.

Reported by mitchellsundt on 2012-01-30 22:04:05