Forums

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

How to populate newly added custom fields in JIRA tickets from a CSV file?

Abhishek Singh(PgM)
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!
December 29, 2021

My team is currently using a JIRA project to manage requests that we receive from various teams in the organization. We are then transporting this information for every ticket to a google spreadsheet and adding more information in the spreadsheet for every ticket. We realized that all of this information can be easily captured in the JIRA ticket itself. So we added additional fields to the JIRA project so all our existing tickets have these newly added fields but there is no information in these tickets against these new fields because this information exists in a google spreadsheet. Is there a way to bulk upload this information to the existing tickets in JIRA?

Just to explain it further,

I have a JIRA ticket, # XYZ1 that has 6 fields when the ticket was created. I added 10 new fields to the project XYZ so ticket #XYZ1 now has 16 fields. But the data for these newly added fields exist in a google spreadsheet that has 16 columns, 6 from the original ticket and 10 manually added columns. The names of 10 additional fields are the same as the 10 column headers in the google spreadsheet. Can I get the values of these newly added fields migrated to ticket #XYZ1 from the google spreadsheet without having to manually updated the ticket?

3 answers

3 accepted

0 votes
Answer accepted
Alan Stephenson
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.
December 29, 2021

If you created the additional fields in your JIRA instance and they are part of the XYZ project (i.e you have them defined on a screen, the context of the fields are either Global or defined to the XYZ project) you can upload the data with no issues. 

If they are text fields you should be good. If they are drop down, single select field I would recommend to populate the field first before you do the import.

0 votes
Answer accepted
Florian PEREZ [Valiantys Administrator]
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.
December 29, 2021

Hello,

Using csv import you can add the ID of the issue and jira will consolidate missing data. You'll need to give all the old datas of the issue (so jira doesnt empty the field)

Hope this help

0 votes
Answer accepted
Joe Pitt
Community Champion
December 29, 2021

You can import from a spreadsheet (csv). You need to have the issue number as part of the row you're importing and only the new information is needed 

Abhishek Singh(PgM)
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!
December 30, 2021

Thanks Joe

I tried but not getting the option to map to exact issue key. Just for an example my issue key is PM-32 and I have this as a row in my csv file but while performing the upload operation I can't map to the same issue key of JIRA project.

Suggest an answer

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

Atlassian Community Events