plomino/Plomino — Issue #66: Importing timestamps from CSV
Author: glimmung
Created: 2012-03-07 12:58:26+00:00
State: open

Hi,

I'm defining a CSV file from which to import updated data into my Plomino database, and I've used the CSV export functionality to create the initial template.

However, I'm getting an error as follows: -

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

...against the following test data: -

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

...which I don't understand, because the import seems to think that there is a "T" between the date and time, but in the file it is a space.

Can someone clue me in as to what I'm doing wrong, or how to work around this, please? Ta!

(I'm sure it's something simple, as I've had - and solved! - this problem before!)

--

Cheers,

PhilK