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

Date Mapping

Shankar Subramaniam_dvp7bu

Hello,

We are migrating from ASANA to JIRA using csv import. We are able to correctly map the Task Create Date but other dates are not working e.g. Task Close / Done dates are not working.

Regards

Shankar.S

Accepted answers

Walter Buggenhout

Hi @Shankar Subramaniam,

I suppose they are process dates generated by the system. Did you try mapping to the Date Resolved field? That's the corresponding system field in Jira.

All comments

Walter Buggenhout

Hi @Shankar Subramaniam,

I suppose they are process dates generated by the system. Did you try mapping to the Date Resolved field? That's the corresponding system field in Jira.

Shankar Subramaniam_dvp7bu

Hello Walter,

Yes we tried that but it is not working.

Also when we change the state to "Done", it strikes off the ticket id in Jira. But this is not happening on the task that was migrated with status "Done".

Regards

Shankar

Walter Buggenhout

> See my previous answer ...

Walter Buggenhout

Yes we tried that but it is not working.
Also when we change the state to "Done", it strikes off the ticket id in Jira. But this is not happening on the task that was migrated with status "Done".

Aha, I know the reason for the strike off thing and to why your import is failing: Date Resolved is linked to setting the value of the resolution field.

Resolution and status are 2 different things. And when distinguishing between Open and Closed issues, this is based on resolution, not status. So is the strikethrough of the issue key.

What you'll need to do is specify a value for resolution in your csv file for tasks having the Done/Closed status. "Done" will most likely be the best option. In your import, map that column to the resolution field and you should be fine.

Shankar Subramaniam_dvp7bu

Hello Walter,

Thanks that worked.

Also is it possible to see the "Resolved / Done" date. We have mapped this value to "Date Resolved" during mapping. But we are not able to see the Closed Date / Resolved date after migration.

Regards

Shankar.S

Walter Buggenhout

Also is it possible to see the "Resolved / Done" date. We have mapped this value to "Date Resolved" during mapping. But we are not able to see the Closed Date / Resolved date after migration.

I just noticed that the resolved field is indeed not visible on the new issue view in Jira Cloud. There's a couple of ways to make it visible, but I guess the most effective to check your migration results is through a search.

Navigate to Filters > Advanced Search
Switch the search option to advanced and enter the following JQL:

Project = XX AND Resolution != Unresolved

Project should be the name of the project you imported, obviously. This will show all issues that have a value for resolution.

Then make sure you add the Resolution column to your results view (search and select under columns:

Screenshot 2020-11-04 at 14.42.12.png

That should give you an overview of all imported resolution dates.

Shankar Subramaniam_dvp7bu

Hi Walter,

Thanks, we are able to see the Resolved date from Filters > Advanced Search

Thanks

Shankar.S

Welcome!

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

Quick Links

Find more posts tagged with

cloud

jira-software

jira-software-cloud