How to change the existing data from Lower Case to Upper Case by Bulk update in Jira?

Mitch Mijares
I'm New Here
I'm New Here
Those new to the Atlassian Community have posted less than three times. Give them a warm welcome!
July 30, 2018

I have alot of data inside the customer field and want to change all from lower case to upper case using Bulk update. Please advise

3 answers

1 vote
Alexey Matveev
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.
July 31, 2018

Hello, 

You can do it with the Power Scripts add-on.

Your script would look like this:

string [] keys = selectIssues("yourcustomfield is not Empty");
for(string k in keys) {
   %k%.yourcustomfield = toUpper(%k%.yourcustomfield)
}

1 vote
Steven F Behnke
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.
July 31, 2018

Bulk update can only 'set' field values. You'll not find an Upper Case or Lower Case method. The only option would be to use a scripting addon or use the REST API to read out the values, manipulate them, and put them back.

Gezim Shehu [Communardo]
Community Leader
Community Leader
Community Leaders are connectors, ambassadors, and mentors. On the online community, they serve as thought leaders, product experts, and moderators.
July 31, 2018

My vote also goes for a scripting add-on. You do not need to purchase one, but highly suggested.

Simple script would do.

Steven F Behnke
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.
July 31, 2018

Agreed -- This level of work would be difficult without either a plugin or a good knowledge of CURL to send API commands.

Mitch Mijares
I'm New Here
I'm New Here
Those new to the Atlassian Community have posted less than three times. Give them a warm welcome!
July 31, 2018

Yes, that is what I thought. Alot of data is already loaded in the system via Bulk, then they realized now that some of the items are in lower case.

 

How about exporting the data > delete>modify >upload? I am new to Jira, so I am not sure if there is an export custom fields functions and mass delete. 

Steven F Behnke
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.
July 31, 2018

You can use the CSV Export to export to a spreadsheet. You can manipulate this in any program, and then Jira Administrators can use the CSV Import to overwrite existing issues.

0 votes
Tom Vannostrand
I'm New Here
I'm New Here
Those new to the Atlassian Community have posted less than three times. Give them a warm welcome!
November 1, 2024

I just had to do this and it works great:

  1. Search for labels = blah OR labels = BLAH
  2. You then can bulk edit to add a label called updatingallblahlabels or whatever so you don't lose the ability to find all your stories.
  3. Then search for labels = updatingallblahlabels  and bulk edit those to remove the labels blah and BLAH from all those. (This will actually delete both of those labels entirely which is nice because users won't see the "wrong" version of that label to pick from any more.)
  4. then search for labels = updatingallblahlabels  and bulk edit those to add the label Blah  

Customize as needed.

Suggest an answer

Log in or Sign up to answer