CSV import and due date problem

Hi guys,

I try to import issue form csv into JIRA project.
The csv file in a simple text editor looks like

summary,description,dueDate
MySummary,MyDesc,02/Feb/12

and I use the date format "d/MMM/yy" in CSV import wizard.
Screenshot_2.png

The following image is the system date picker format in JIRA.
Screenshot_1.png

After the validation progress in import wizard, I will get the message "The validation process has found 1 warning/s Unable to parse date: 02/Feb/12".

I can not import due date successfully.

My JIRA version is v6.4.2.

Do you have any idea?
Thanks for your suggestions.

1 answer

0 votes
Ignacio Pulgar Community Champion Dec 20, 2017

May you try changing the value of the date format from "d/MMM/yy" to "dd/MMM/yy"?

Hi Ignacio,
I change the format to "dd/MMM/yy", but I still can't import due date successfully. So I change format to "Look and Feel" format like "yyyy/MM/dd" and upgrade the version of jira-importers-plugin from 6.3 to 7.1.8, it works for me now. Thank you!

Ada

Suggest an answer

Log in or Join to answer
Community showcase
Sarah Schuster
Posted Jan 29, 2018 in Jira

What are common themes you've seen across successful & failed Jira Software implementations?

Hey everyone! My name is Sarah Schuster, and I'm a Customer Success Manager in Atlassian specializing in Jira Software Cloud. Over the next few weeks I will be posting discussion topics (8 total) to ...

2,982 views 12 18
Join discussion

Atlassian User Groups

Connect with like-minded Atlassian users at free events near you!

Find a group

Connect with like-minded Atlassian users at free events near you!

Find my local user group

Unfortunately there are no AUG chapters near you at the moment.

Start an AUG

You're one step closer to meeting fellow Atlassian users at your local meet up. Learn more about AUGs

Groups near you
Atlassian Team Tour

Join us on the Team Tour

We're bringing product updates and pro tips on teamwork to ten cities around the world.

Save your spot