CSV import

[Stephan Gruzinski]

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.

  

[Ivan Lima]

Hi @Stephan Gruzinski, you should be using something like dd/MMM/yy. Have a look at Dates are not properly imported from CSV file, and make sure to use a plain text file and not excel to work on your file.

[Stephan Gruzinski]

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?

[Ivan Lima]

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.

[Stephan Gruzinski]

Thanks for the Help

[Stephan Gruzinski]

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

[Ivan Lima]

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.