Jira import from CSV, can't get Resolved date to fill.

[Jonathan Smith]

Morning everyone.

I am attempting to bulk import a bunch of open and completed items into a demo project, but resolved items are not showing a resolution date. 

• I've mapped to date resolved field, but that didn't fill out the system resolution. 
• Resolution = Done works, but there is no resolution date after import; These closed items just have created and updated dates.
• I thought it had to map to resolved but that looks to be a custom field...

What am I missing here?

[Jonathan Smith · Accepted solution]

• I just deleted the custom field resolved.
• Here is the mapping. 

[Jonathan Smith]

Thought maybe there was a conflict with the resolution date if updated date is today.

Attempted to import Updated Date (10/18/23) and match it with Resolution Date (10/18/23), but this was not successful. 

[Jonathan Smith]

Per Atlassian, the date format should be set to "dd/MMM/yy h:mm a". After attempting the import, the resolution dates populated accordingly.

Since my CSV had multiple types of date fields, I had to do two imports (initial import and one to fix the resolution date).

[Davide Bortolotti (Jira Admin)]

Dear @Jonathan Smith, I followed your suggestion setting up the resolution date in the formats dd/MM/yyyy, dd/MM/yyyy HH:mm and dd/MMM/yyyy h:mm a, but in each case the importer didn't update the resolution date without reporting any error.

I followed even @Marc - Devoteam suggestion below, exporting existing issues and I seen that the format is dd/MM/yyyy.

I'm using the old version of the importer.

I'm wondering if there is a bug or a my mistake, in the log there is a row for each issue with the statement "Updating issue: [externalId='autoid--..." and, at the end "595 issues successfully updated".

[Marc - Devoteam]

Hi @Jonathan Smith

I think there is an issue on the date notification in the CSV file.

What I usually do is, JQL some issues with the required. fields you want to use for a csv import.

Export this result, and use a simple editor like notepad, sublime text or other to open the export file. Check the date notation.

Adjust you import CSV to match the date notation, now the import should be fine.