Task Coach

Other pb with import

Asked by Patrick

Hi everybody
Just to say i've another pb with csv import.
When i import such a csv file : ( 5 lines content below )

Sujet,Description,Catégories,Date de début,Date dûe
Cours UML2,Analyse et conception UML 2,Formation en journee,31/08/2011 09:00,31/08/2011 17:00
Cours UML2,Analyse et conception UML 2,Formation en journee,01/09/2011 09:00,01/09/2011 17:00
Cours UML2,Analyse et conception UML 2,Formation en journee,02/09/2011 09:00,02/09/2011 15:30
examen de certification,Examen cours UML2,Examen,02/09/2011 16:00,02/09/2011 19:00

(all dates are in French format JJ-MM-YY)
it seems there is a problem with dates. Indeed, August dates are finely importes, but September dates are wrongly imported in TaskCoach. They become January 9th, February 2th and so on.
Maybe a pb with dates format or conversion ?

Many thanks for your great job.

Windows Ver 1.2.26

Question information

Language:
English Edit question
Status:
Answered
For:
Task Coach Edit question
Assignee:
No assignee Edit question
Last query:
Last reply:
Revision history for this message
Frank Niessink (frank-niessink) said : 		#1

The date parser guesses the date format (DD-MM-YYYY, MM-DD-YYYY, YYYY-MM-DD, unfortunately there are so many possibilities) and apparently (it's a third party module, we didn't write it) it is guessing for each date separately. If you control where the data is coming from (Excel?) you can maybe force that program to write dates in the ISO format (YYYY-MM-DD) as a work around. I'll see whether I can create a real fix in the mean time.

Revision history for this message
Frank Niessink (frank-niessink) said : 		#2

I've committed a fix for the next release.

Can you help with this problem?

Provide an answer of your own, or ask Patrick for more information if necessary.

To post a message you must log in.