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; } } }

Unable to parse multiple date formats during import.

Raj Vora

While importing a number of issues, the import of the created date field is unsuccessful for these date formats:

2018-02-13 12:43:49,545 WARN - Unable to parse created date: 31/Dec/17
2018-02-13 12:43:49,561 WARN - Unable to parse created date: 31-Dec-17
2018-02-13 12:43:49,562 WARN - Unable to parse created date: Dec/31/17
2018-02-13 12:43:49,563 WARN - Unable to parse created date: 31/Dec/17 13:02
2018-02-13 12:43:49,563 WARN - Unable to parse created date: 2017-Dec-31
2018-02-13 12:43:49,564 WARN - Unable to parse created date: 12/31/17
2018-02-13 12:43:49,564 WARN - Unable to parse created date: 31 Dec 2017
2018-02-13 12:43:49,565 WARN - Unable to parse created date: 2017-12-31
2018-02-13 12:43:49,565 WARN - Unable to parse created date: 31 December 2017

What format does it need to be in? Does the time (e.g. 13:02) have to be included or can it be omitted? If it is omitted, what default time does importer use?

I looked at multiple help forums but could not locate the answer. However one of them discussed the date/time formats screen. Ours is pretty much the same (see attached) EXCEPT that I noticed there was no instance of date picker format and date time picker format. Is this a problem? If so, how do you fix it?

I am using JIRA Server Edition v7.5.2

Date-Time Format.png

Accepted answers

All comments

Nic Brough -Adaptavist-

You have to provide import dates in the same format consistently. Pick one single format and make sure all your import data uses it.

Raj Vora

Well I did that first when trying to import 3 issues, all using 31/Dec/17 as the format. It did not work. What are some troubleshooting tips?

After unsuccessfully trying 31/Dec/17 as the format for three issues, that's when I experimented with multiple date formats as described in the details section.

Nic Brough -Adaptavist-

Excellent test. How are you doing the import and what are you telling it the date format is?

Raj Vora

I'll have to touch basis with my JIRA administrator (I don't have privileges to do the import but I'm helping design our CSV import files and working with him to test out the process). So I can get you the proper responses to your questions:

1. How are you doing the import?

Is what you want to know the step-by-step procedures/tools we are using to do the import?

2. What are you telling it the date format is?

What specifically are you referring to? When sitting down with my JIRA admin during our test imports, I don't really recall ever being able to specify the date format, unless I am missing something. Can you point me to a screen snapshot of what you are referring to.

Thanks!

unknown

Should be exactly as 10/JUL/19 10:00 AM. You can not change such data format in Excel, have to be done in TEXT++, TEXT MATE program etc.
JIRA really should update their backend to accept more flexible date format.

Welcome!

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

Quick Links

Find more posts tagged with

server

jira

import

date

time