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

Import: How do I map 'Issue Key', 'Status', and 'Resolution' in CSV to Jira?

haisamido

I have the below CSV in a file, and I want to preserve the values of 'Issue Key', 'Status' and 'Resolution' when I import. How do I do that? I can't find a way to map 'Issue Key', 'Status' or 'Resolution' into JIRA without JIRA automatically assigning a new 'Issue Key', 'Status' is 'TO DO', and 'Resolution' to 'Unresolved'. I'm using 'atlassian-jira-software-7.3.1-standalone'

Issue Key,Component,Fix Versions,Layer,Summary,Description,Assignee,Reporter,Issue Type,Priority,Status,Resolution
ABC-135,appserver,201701,Data,foo,foo,user1,user1,Enhancement,High,Done,Rejected
ABC-140,aws,201701,Presentation,foobar,foobar,user1,user1,Discrepancy,Medium,In Progress,Unresolved
ABC-139,web portal,201701,Logic,bar,bar,user1,user1,Requirement,Low,Done,Completed

It's this problem https://confluence.atlassian.com/jirakb/missing-fields-to-map-during-import-issues-to-csv-operation-720420577.html and the 'Solution' doesn't work

Accepted answers

All comments

Nic Brough -Adaptavist-

Status and resolution must exist in JIRA for you to be able to map them.

Have you got Rejected and Completed resolutions in Admin -> Resolutions? And the three status under admin -> status?

For status, the status must also be used by workflows for the issue types you have mapped for the issues

Key will not be imported, it is generated by JIRA according to the project you are importing it into. If you specifiy and map a key in an import, then the import is treated as an update to an existing issue.

haisamido

Yes they all exist. I think you misunderstood my question.

My question is about the lack of ability to map (via the dropdown) from my CSV's 'Issue Key', 'Status', and 'Resolution'. to JIRA's 'Issue Key', 'Status', and 'Resolution'.

Nic Brough -Adaptavist-

Sorry, I guess I don't understand what you mean by "map".

I can import CSV using the fields just fine.

Tarun Sapra

Hi @Haisam Ido,

There are two ways to import CSV in JIRA

1) Under the issues section - "Import issues from CSV"

2) Under external system import (requires admin rights)

If you use the second option(admin rights) you will see fields like Status, Assignee, Resolution etc which are not available if you try to import via the first option.

Similar question here - https://answers.atlassian.com/questions/9866203

Alec.Puype

I have same problem. I would like to update existing Jira tickets with values in a CSV file, but it is not possible to map the Issue Key (though in the atlassian documentation, it is mentioned it is possible: https://confluence.atlassian.com/adminjiraserver071/importing-data-from-csv-802592885.html).