I am receiving this error when i use the csv importer. * Unable to parse created date: 1/1/12 7:16 * Unable to parse created date: 1/1/12 7:28 * Unable to parse created date: 1/1/12 7:35 * Unable to parse created date: 1/1/12 7:38 * Unable to parse created date: 1/10/11 10:19 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.

nav[aria-label="Primary Navigation"] { padding: 0; & ul { list-style: none; width: 100%; display: flex; flex-direction: row; justify-content: start; align-items: start; gap: 30px; padding: 0; & li { margin: 0; } & ul li { list-style: none; } } }

dates on csv import

julian bankston

I am receiving this error when i use the csv importer.

Unable to parse created date: 1/1/12 7:16
Unable to parse created date: 1/1/12 7:28
Unable to parse created date: 1/1/12 7:35
Unable to parse created date: 1/1/12 7:38
Unable to parse created date: 1/10/11 10:19

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.

Accepted answers

Nic Brough -Adaptavist-

Have you tried the dates in full format with matching masks (your dates and masks as posted don't match at all)?

e.g. 30/02/2012 10:19 with a date mask of dd/MM/yyyy hh:mm

All comments

julian bankston

My workflows involves exporting the query results from workbench adn importing into excel to correct NULL values and bad description field entries. I save it from excel and import into Jira.

Nic Brough -Adaptavist-

Have you tried the dates in full format with matching masks (your dates and masks as posted don't match at all)?

e.g. 30/02/2012 10:19 with a date mask of dd/MM/yyyy hh:mm

julian bankston

Nic, thanks for pointing that out. Excel was messing with the format of my dates. All is well now. thanks!

Arpita Argulwar1

Hello Julian,

What exact chnages you have done in csv file. I have set the custom format as mentioned by Nic and upload it again. However I am getting the same warning.

Regards,

Arpita

Dhananjay Kale

I have tried this (dd/MMM/yy hh:mm:ss a) format and its working without any error.

Arpita - Can you please try to change the format in excel and import the issues.

Arpita Argulwar1

No luck Dj.. getting the same error.

Sateesh Chandra5

Arpita,

Can you let me know the date format configured in your Jira. Make sure you make the changes to Excel dates similar to it.

Arpita Argulwar1

dd/MMM/yy h:mm a

Dhananjay Kale

Hi Arpita,

Please check the date format that has been configured in the System Info section and use the same. Also per Sateesh, make the same date format changes to CSV before importing. Hope it helps.

Atul Shakti

Hi Dhananjay, can you tell where exactly in the system infor section date format is mentioned.

Azfar Masut

Ensure your data format in CSV is tally with your JIRA date format ( System > Look & Feel > Scroll to the bottom ) before importing. As Excel usually messed with your date format.

By default it should be as below:

*dd/MMM/yy h:mm a*

Mayur Ingale_j3jhdd

In CSV we can't edit the date format. To edit that open the CSV fiel in notepad++ & do the changes.

Corinna Führing

YYYY-MM-dd HH:mm this is in my look and feel so i must use the same ?

Matthew Leach

Also Excel doesn't offer the date format of *dd/MMM/yy h:mm a* so whey wont' JIRA accept a standard format like mm/dd/yyyy h:mm a* ? So you're required to create your own custom format and apply it. Seems like a lot of overhead to import.

Nicole Downes_yyei04

When importing, and your Jira format is: dd/MMM/yy h:mm a

from an excel csv file, use custom format: dd/mmm/yy h:mm AM/PM

This works for

Date Created
Date Modified
Due Date

Robin Mathew_r9ktc7

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?

Nicole Downes_yyei04

In your excel file, make sure you format the date field using use custom format: dd/mmm/yy h:mm AM/PM

Robin Mathew_r9ktc7

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.

Nicole Downes_yyei04

That should be sufficient. It works for me if you save the csv with that format for your date columns.

preethy sekar_zf81ve

Hi Robin,

Even i got the same error
did you find any fix for it

Thanks

Sriram Venkatakrishnan

In the CSV file, set the Custom format of the date column to "dd/MMM/yy h:mm AM/PM" and try importing it. It worked for me.

Jennifer Hubble

This worked for me; thank you!

mittal.g

Hi Sriram, Setting the custom format as stated works

unknown

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:

Issue key,Summary,Created

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.

Nishant Kumar_sj19yh

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).

Jasmine Lee_srqp9o

THIS WORKED FOR ME! Thank you! A succinct and clear answer. I just wanted to upvote this comment so hopefully it gets more visibility.

Oren Zehavi

Worked thank you!

prashantgera

I have also faced the same issue but I am unable to import the .csv file.

Steps i have done to fix this:

1. Export Excel CSV (all fields)

2. I have filed "Due Date" is some of the Issue types. Select the whole Due date column . Format Cell==>Custom==>Type: dd/mmm/yy h:mm AM/PM and click OK

3. Save the file as CSV UTF-8

4. Go to new Project ==> Import the .csv file

5. Put date format as : 02/004/21 6:42 a

It throws error: Issue can't be created due to the error/s [ Due date is required. ]

Where I am wrong ?

Welcome!

It looks like you're new here. Sign in or register to get started.

Quick Links

Find more posts tagged with

csv

jira

import

date