dates on csv import

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.

6 answers

1 accepted

This widget could not be displayed.

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

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

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

No luck Dj.. getting the same error.

Hi Julian- what exactly did you try? i mean what changes you made in the excel csv format. what date format did you choose

Dear sir, 
I have exact the same problem and use exact the date mask but it's still failed. 

Do you have any idea to troubleshoot? 

https://answers.atlassian.com/questions/41478834/import-error-please-enter-the-date-in-the-format-dmmmyy-eg.-14sep16

 

This widget could not be displayed.

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.

This widget could not be displayed.

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.

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

This widget could not be displayed.

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.

This widget could not be displayed.

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.

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

This widget could not be displayed.

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*

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

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. 

Suggest an answer

Log in or Sign up to answer
Atlassian Summit 2018

Meet the community IRL

Atlassian Summit is an excellent opportunity for in-person support, training, and networking.

Learn more
Community showcase
Posted yesterday in New to Jira

Are you planning to trial, or are currently trialling Jira Software? - We want to talk to you!

Hello! I'm Rayen, a product manager at Atlassian. My team and I are working hard to improve the trial experience for Jira Software Cloud. We are interested in   talking to 20 people planning t...

52 views 1 0
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