Hi everybody

When I import data using a .csv file, a time field is automatically converted into the Date/Time type, resulting the values remain empty...

Example:

In CSV:
Zeit
09:45

In PSM:
Zeit
empty (really empty, not the word "empty")

PSM version: 7.0.5

The CSV is built as follows:

Name Vorname Adresse Datum Zeit
Hans Muster Musterweg 1 01.11.2010 09:45

The entrys are tab-separated. When importing, the type of the date and time values are changed to "Date/Time". As this works for "Datum", "Zeit" remains empty.

Anybody any ideas...?

Regards
Sawwas

That's interesting, apparently those types of values are not supported. We will have to document this.

I would suggest adding quotes: "09:45". You only need to do this for one of the values in the column, the first one will do. The driver should then no longer interpret them as date/time.

Hi Sander

Great, your workaround works fine. I'll pass this info to our customer, thank you, also for your very fast reply.