search

tubackkhoa / gbif-dataportal

Automatically exported from code.google.com/p/gbif-dataportal
0 stars 1 forks source link

Erroneous downloads #91

Closed GoogleCodeExporter closed 8 years ago

GoogleCodeExporter commented 8 years ago 
When a locality has " in them such as occurrence ID 62229402: 

Disturned cloud forest at "Monte Rey", above Boquete

The CSV export does not work as the fields don't align.

http://data.gbif.org/occurrences/downloadSpreadsheet.htm?c[0].s=20&c[0].p=0&c[0]
.o=13728449&c[1].s=24&c[1].p=0&c[1].o=621 is an example that fails

When producing CSV or TAB files, all ",\t\n etc need to be handled 
appropriately.  

\t \n can become a space, " can become ' and , can be removed if needed.

I suggest reviewing all fields and applying the same rules to each field that 
is a varchar

Original issue reported on code.google.com by timrobertson100 on 2 Aug 2010 at 3:08

GoogleCodeExporter commented 8 years ago

Original comment by daniel.amariles88 on 2 Aug 2010 at 3:13

GoogleCodeExporter commented 8 years ago 
the characters were handled as you mentioned in revision r184

Before this change the , case was handled enclosed the string with " and seems 
to align well, so we can choose to rollback to handle the , case as it was or 
leave with the change.

Original comment by daniel.amariles88 on 2 Aug 2010 at 8:47