Create
cancel
Showing results for 
Search instead for 
Did you mean: 
Sign up Log in
Celebration

Earn badges and make progress

You're on your way to the next level! Join the Kudos program to earn points and save your progress.

Deleted user Avatar
Deleted user

Level 1: Seed

25 / 150 points

Next: Root

Avatar

1 badge earned

Collect

Participate in fun challenges

Challenges come and go, but your rewards stay with you. Do more to earn more!

Challenges
Coins

Gift kudos to your peers

What goes around comes around! Share the love by gifting kudos to your peers.

Recognition
Ribbon

Rise up in the ranks

Keep earning points to reach the top of the leaderboard. It resets every quarter so you always have a chance!

Leaderboard

Come for the products,
stay for the community

The Atlassian Community can help you and your team get more value out of Atlassian products and practices.

Atlassian Community about banner
4,555,759
Community Members
 
Community Events
184
Community Groups

Importing CSV data without updating the summary on tickets

I want to do a bulk update to a custom field for a set of approx 900 tickets in JIRA service desk (server).

I have two columns in my CSV - "Issue Key" and the custom field.

I attempted to import but it seems I must include "Summary". I put a value in this field for each ticket (just some random text) but this overwrote the summary for each of my tickets.  In order to get this to work I have to export the tickets from JIRA into excel first, including the Summary, add the custom field values and then import, so the summary value being updated was the same as the value already on the ticket.

Is there a way of importing where I can have the summary field not updated?

I'm sure there is a simple way to do this but I couldn't seem to find it.

3 answers

1 accepted

This is a known limitation and a suggestion has been logged about it in the support system:

https://jira.atlassian.com/browse/JRASERVER-69222.

As mentioned in one of the comments, the trick is to include an empty "Summary" column in your CSV and map it to the Summary field. 

That way, the import will succeed, the Summary will remain unchanged on your issues but the other fields included in your CSV will get updated, giving the desired result.

I love the trick!  Thank you

Like François Dumas likes this
0 votes
Roman Kersky
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.
Jul 29, 2019

HI, Sorry but .... may be create script and update the fields using the REST API

image.png

This actually does not work for me. I'm using Jira Cloud...

See screenshots below.

First I tried without mapping the summary. I'm warned the summary field is required. Ok, let's adding an empty summary field. See next screenshot.

CleanShot 2023-01-11 at 13.23.34.png

 

I went back to the CSV file and added a new column called Empty Summary. Notice the Issue ID is also set. Also notice the other fields I'm mapping...

CleanShot 2023-01-11 at 13.21.45.png


Upon running the validator, an error is thrown saying the Summary field can't be empty. What gives?

CleanShot 2023-01-11 at 13.19.30.png


If I map the regular summary column (which has the original summary value from export), upon importing I get duplicate issues, even though I'm providing the issue-id and summary fields. The update is not happening. There must be another require or reason for this.

 

Any help would be appreciated.

0 votes
Tomas Gustavsson
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.
Jul 29, 2019

If ju have a plugin called jira suite util or perhaps scriptrunner,  this should be an eaay task.

then you should get something looking as below

image.png

thanks for the feedback - but I want to try and accomplish this through the native JIRA CSV import.  I want to understand if just not updating the "Summary" field during import is possible?

Suggest an answer

Log in or Sign up to answer