plomino/Plomino — Issue #69: CSV Import - Final column issue
Author: glimmung
Created: 2012-03-08 15:27:07+00:00
State: open

Hi,

I've been working on a batch of CSV imports, and have found that the final column has not imported. On a hunch, I experimented with terminating the lines with a comma, like so: -

importTimestamp,unitCreditValue,unitGuideLrnHrs,unitLevel,unitMandAssessReq,unitNo,unitOptAssess,unitOptAssessReq,unitQCFUnit,unitTitle,
"2012-03-08 00:00:00 GMT","2","30","2","0","ABC123","0","0","True","Underwater Basket Weaving",

...and found that this works.

Is this the intended behaviour?

I'd rather not ask the upstream provider of these files to do something non-standard, and indeed the RFC (http://tools.ietf.org/html/rfc4180) does suggest that "The last field in the record must not be followed by a comma", although I appreciate that there is not a definitive spec for CSV files.

--

Cheers,

PhilK