.csv date import

[forums-5]

Hi i have a .csv file that i need to import.

I have a couple of fields in the .csv seperated with ;
The import succeeds but the 'date created' and 'date modified' dont get imported right.

for some issues i get a complete wrong date, and for some the current :S
i tried all possible options. dd/MM/yyyy , dd/mm/yy, etc.

what can i do?
i use JIRA 4 and dont get any errors during the import.
--
Post by Damir - online at:
http://forums.atlassian.com/thread.jspa?forumID=46&threadID=38875
_______________________________________________
Jira-user mailing list
Jira-user@...
To unsubscribe or change your options visit this page:
http://lists.atlassian.com/mailman/listinfo/jira-user

[forums-5]

To import valid CSV, you must be using the same field separator throughout (you can't use a , for some fields and a ; for others).  

The same goes for dates - you can pick one format when setting up the import, and Jira will try that on all date fields.  If a date field is in a different format from the one selected, Jira can't import it, becasue the mask will be wrong.  Are all your dates in the same format in the CSV?  (Bear in mind that a lot of spreadsheet programs see dates as formatted output and actually write something different into the plain text CSV)
--
Post by broughn2 - online at:
http://forums.atlassian.com/thread.jspa?forumID=46&threadID=38875
_______________________________________________
Jira-user mailing list
Jira-user@...
To unsubscribe or change your options visit this page:
http://lists.atlassian.com/mailman/listinfo/jira-user

[forums-5]

Thanks! I will go through the file again.
--
Post by Damir - online at:
http://forums.atlassian.com/thread.jspa?forumID=46&threadID=38875
_______________________________________________
Jira-user mailing list
Jira-user@...
To unsubscribe or change your options visit this page:
http://lists.atlassian.com/mailman/listinfo/jira-user