Forums

Articles
Create
cancel
Showing results for 
Search instead for 
Did you mean: 

How can to update issues using csv importer (not system External System Import)

Danielle Green
Rising Star
Rising Star
Rising Stars are recognized for providing high-quality answers to other users. Rising Stars receive a certificate of achievement and are on the path to becoming Community Leaders.
February 17, 2021

Our project admins use the csv importer on Jira Cloud (under Filters>Advanced issue search). We do not want to grant them Jira admin rights and access to the system controls just for csv imports. They have bulk update permissions enabled.

Why can't they update their issues through the csv importer? There is no way to map Issue Key, though the documentation says It also allows you to create your own CSV file to perform bulk issue creation and updates. https://support.atlassian.com/jira-software-cloud/docs/create-issues-using-the-csv-importer/

I've seen an answer which states that the csv importer will only map fields which appear on the create screen, but I am unable to put the issue key field on the create screen.

How can they update issues through the csv importer?

1 answer

1 vote
John Funk
Community Champion
February 17, 2021

Hi Dani,

See this post as it might provide a little more clarity.

https://community.atlassian.com/t5/Jira-questions/How-to-import-a-csv-file-without-the-JIRA-administrator-global/qaq-p/711740

The best comment in that post to me is probably the one that says the importer is designed to be a support function and not a daily use function. Therefore it makes sense to me that only Administrators would perform that function. 

As to your other question about the Key - for an update, you simply include a column in your CSV labeled Key. Then map the key in your CSV to the 'Issue Key' JIRA field. Don't worry about it not being on the Create screen because you are doing an update and not a Create.

Trudy Claspill
Community Champion
February 17, 2021

@John Funk 

I believe the point that @Danielle Green  is making is that when you use the Import function from the Advanced Issue Search screen, then in the Mapping screen the "issue Key" field is not selectable at all. You cannot map an issue ID column in the CSV to the Issue Key field, and therefore cannot change existing issues through the Import function available under Advanced Search.

I am a full JIRA Admin and use the External System Import process frequently. There I can map input data to the Issue Key field. When I use the Import function under Advanced Search, Issue Key is not available.

Screen Shot 2021-02-17 at 11.48.32 AM.png

Danielle Green
Rising Star
Rising Star
Rising Stars are recognized for providing high-quality answers to other users. Rising Stars receive a certificate of achievement and are on the path to becoming Community Leaders.
February 22, 2021

It's as @Trudy Claspill says - Issue Key is not available in the Import function under Advanced Search. So I cannot see a way for users to bulk update issues with csv without granting them all Jira admin permissions.

John Funk
Community Champion
February 23, 2021

You should create a support ticket with Atlassian:

https://support.atlassian.com/contact/#/

Suggest an answer

Log in or Sign up to answer
DEPLOYMENT TYPE
CLOUD
PERMISSIONS LEVEL
Product Admin
TAGS
AUG Leaders

Atlassian Community Events