You're on your way to the next level! Join the Kudos program to earn points and save your progress.
Level 1: Seed
25 / 150 points
1 badge earned
Challenges come and go, but your rewards stay with you. Do more to earn more!
What goes around comes around! Share the love by gifting kudos to your peers.
Keep earning points to reach the top of the leaderboard. It resets every quarter so you always have a chance!
Join now to unlock these features and more
I have tried to import a CSV file i created from MS Project task list and keep running into an issue with dates.
I was originally having issue with the date format until i looked at the text version of csv. The format in the CSV file dd-MMM-YYYY
Once i was able to clear the errors form the import. I looked at the task and the dates are not correct.
I mapped the Submitted dated date to Date Created and Due Date to Due Date.
I did not use Custom Fields.
Here is an image of date section in the task, it is making everything 27/DEC/20 and screen shot of the dates from the csv file. I know the dates are in the past but it is putting the same date for all even the ones in the future.
The format in in that I see in excel is dd-MMM-YY. When i click on a cell it shows the format of mm/dd/yyyy
I opened up the .csv file in notepad and see this format dd-MMM-YY
Do i need to edit each entry in the plain text file to dd/MMM/yy?
Or is there a better way to edit all of the entries or does Jira take a different format since you can edit it during the import process?
Make sure you choose the right date format that matches exactly what you have in your CSV in the setup screen. What I normally do is using excel for the bulk of work and final edit it using VSCode with some plugins, but any text editor works. My suggestion is to use it with 2 or 3 simple lines, a text editor, the date format I mentioned, so you have better control over that. You can easily see it working and the changes you had to put in place to make it work.
I have been performing my test in a sandbox version my company has setup.
Everything seemed to work and the dates looked good.
I made sure I was importing into the Issue field and not custom field.
I then proceed to import into our production environment of Jira with the same file and got the following error with all dates.
here is a snip it from the excel file
here is a snip it from the text file
here are the first few lines from the error log
2021-08-31 13:28:04,000 WARN - Unable to parse created date: 29/Jun/21 0:00 a
2021-08-31 13:28:04,002 WARN - Unable to parse date: 12/Jul/21 0:00 a
2021-08-31 13:28:04,004 WARN - Unable to parse created date: 14/Jul/21 0:00 a
2021-08-31 13:28:04,004 WARN - Unable to parse date: 23/Jul/21 0:00 a
2021-08-31 13:28:04,004 WARN - Unable to parse created date: 26/Jul/21 0:00 a
2021-08-31 13:28:04,004 WARN - Unable to parse date: 10/Sep/21 0:00 a
2021-08-31 13:28:04,004 WARN - Unable to parse created date: 26/Jul/21
Hi @Stephan Gruzinski, your file shows "29/Jun/21 0:00 a", and it should be something like "29/Jun/21 0:00 AM". That's the reason why you're getting the parse error. In the CSV import screen, If your date format is dd/MMM/yy h:mm a, your date should have the following format "23/Jul/21 0:00 AM". You will find the valid syntaxes and formats at SimpleDateFormat.