plomino/Plomino — Issue #68: Date Import from CSV
Author: glimmung
Created: 2012-03-08 10:17:54+00:00
State: open

Hi,

I'm importing data from a CSV as follows: -

importTimestamp,qualNo,unitNo,unitGroupDesc,unitGroupNo,mandatory
"2012-03-07 00:00:00","qno","uno","ogdesc","ugno","True"

...but the import errors on the datetime field as follows: -

ValueError: time data '2012-03-07T00:00:00' does not match format '%Y-%m-%d %H:%M:%S'

...which has me baffled, as the character between the date and time is a space, not a "T" as suggested by the error message.

Can anyone clue me in or suggest a workaround, please?

Am sure I've seen and solved this before, but cannot for the life of me recall how!

--

Cheers,

PhilK