I am receiving this error when i use the csv importer.
i have tried several date formats. yyyy/MM/dd h:mm a, yy/MM/dd h:mm a, MM/dd/yyyy h:mm a, and MM/dd/yy h:mm a
Any help would be appreciated. Thanks.
I have exact the same problem and use exact the date mask but it's still failed.
Do you have any idea to troubleshoot?
Hi Nicole.. Thank you for getting back to me. I have done that as well. Quick question, will it be sufficient that the date displays as dd/mmm/yy h:mm am/pm or do i need to update the date itself? The custom format only changes how this is displayed rather modifying the actual data. Once i have some more guidance i can take another shot at uploading this data.
Hi I tried changing the format of the date in excel and my csv but still getting errors and incorrect dates when i do bulk uploads of issues. this is the error that I am getting.
Unable to parse datetime: 24-Feb-20 using the date format pattern: dd-MMM-yy h:mm a
Anything that I am missing here?
I've had some issues with CSVs imports failing. I fixed them by:
- changing the delimiter in the csv to comma , in stead of (originally) semicolon ; or other delimiter
- setting date in csv to dd-MM-yyyy HH:mm e.g. 03-10-2020 14:41 (October 03 2020 2:41 PM)
- setting import config to dd-MM-yyyy HH:mm as well (same as in csv)
Example of contents of this in the csv:
KEY-123,Summary goes here,03-10-2020 14:41
When CSVs are provided, the date should be noted in the file as dd-MM-yyyy, but is sometimes noted as by original poster, with / between day/month/year.
Importing also works when using the MM-dd-yyyy format, e.g. 10-03-2020 for October 03 2020.
I followed below steps:
1). In my .csv file:
-> Snapshot of my .csv file:
->Right Click on 1/3/2020 13:31 -->Format Cells -->Custom--> m/d/yyyy h:mm
Then click on ok.
--> In my .csv file, the date-time format, I have opted is:m/d/yyyy h:mm
--> Jira setting -> System -> External System Import
Kindly use date format in Jira Import: m/d/yyyy h:mm( Same one that you have used for your .csv file).
Connect with like-minded Atlassian users at free events near you!Find an event
Connect with like-minded Atlassian users at free events near you!
Unfortunately there are no Community Events near you at the moment.Host an event