Is it possible to update the values ​​of a custom field in bulk?

Lucas Darlim Rodrigues Silva July 9, 2024

 

 

Hello, I need help with a JIRA feature, I would like to know if it is possible to import several values ​​from a custom field in bulk, for example, I need to update several school names in the "Schools" field and I would like to do this in bulk, is it possible? I thank you for your attention!

1 answer

1 vote
Fernando Eugênio da Silva
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 9, 2024

@Lucas Darlim Rodrigues Silva , Welcome to the Atlassian Community!

 

You can operate this making an import csv to Jira.

Basically what you need is to do the following:

  • Create an issue dump in Jira to use to import the values ​​in bulk
  • Create a CSV file with the following columns:
    • Issue Key > Use the Key from your created issue dump
    • Issue Summary > Summary of your created issue
    • Field name > 'Schools'

For each value in the Schools field you will map the same Issue Key and Issue Summary from your issue dump. The only thing that will change in the rows is the value of the 'Schools' field. See example

Screenshot_184.png

After that, simply import the CSV file into Jira mapping each column to its respective field.

Issue Key Column > Issue Key Field
Summary Column > Summary Field
Schools Column > Schools Field

For each issue line, even if repeated, Jira will run a field update event. With each execution, the new value found will be automatically defined as a field list option

Hope this helps you :)

Kind regards,

Fernando

Lucas Darlim Rodrigues Silva July 10, 2024

Hello @Fernando Eugênio da Silva, thank you very much for responding.

Can you tell me the way to do this procedure?

After mapping the updated values ​​of the school field, will the old values ​​be replaced?

 

Campo Escola JIRA.JPG

I tried to do the mapping but got this result, can you help me with this process?

Fernando Eugênio da Silva
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 10, 2024

@Lucas Darlim Rodrigues Silva ,

This process only works to add new values in a select choice field. The current values will not be affected.

 

Regarding your error, could you share some details like:

Which type is the field you want to update?

Some sample values of your new values to be updated in the field.

Lucas Darlim Rodrigues Silva July 11, 2024

@Fernando Eugênio da Silva

The custom field I'm editing is of the select list type (single choice), which has several names of registered schools, basically, I need to add a satisfaction classifier from A to D at the end of each name, for example, Test School A, but as there are many names, I'm looking for a way to import all the names already with the classified ones and replace the old names, You can?

Campo Escola JIRA 2.JPGCampo Escola JIRA 1.JPG

Fernando Eugênio da Silva
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 11, 2024

@Lucas Darlim Rodrigues Silva , Got it!

To update existing values, import CSV will not really work. It only works to create new values ​​in bulk.

If you want to update multiple values ​​in series, you might want to use the Jira API to operate this along with your CSV support. However, this will require a little knowledge about the API. The format to be used would be this: The Jira Cloud platform REST API (atlassian.com)

CSV Import didn't work to update existing values in select fields, just to create new values.

Suggest an answer

Log in or Sign up to answer
DEPLOYMENT TYPE
CLOUD
PRODUCT PLAN
STANDARD
TAGS
AUG Leaders

Atlassian Community Events