Bulk importing of data for custom fields on an issue

[Jon]

i have all these subtasks that are part of a parent issue  and many of the fields of the shared values but one field in particular is all unique and consists of random characters (nubmers and letters). I usually can get this data in a spreadsheet or in some type of list but how could i import them to populate by each subtask? 

For example, i have a parent issue. it has 40 subtasks. The field im trying to populate is called "Load Number". the load numbers are BO1234 through BO1273. How can i add them without having to do one at a time. 

[Ravi Varma]

Hi @Jon,

Get the 40 sub tasks data as CSV file with two fields (IssueKey, LoadNumber)

Refer the below image:

Import the CSV file into JIRA. Refer the Atlassian documentation - https://confluence.atlassian.com/adminjiracloud/importing-data-from-csv-776636762.html

Once, the CSV file is imported, all the 40 sub tasks will have the Load Number field value updated, based  on the data provided in the CSV file

Regards,

Ravi Varma

[Jon]

hi Ravi, 

Since im importing so many fields is there any way to get around having to use the issuekey and/or summary key? 

[Jon]

hi ravi, another question on this. 

im trying to import the data to subtasks only  but when I try to put the summary or issuekey on the cvs it populates on the parent issue too. then I saw this comment. 

Sub-tasks

To import issues as sub-tasks define the column mapping for: Issue Id, Parent Id and Issue Type

How would I change my CSV file to accommodate this? Then same question as above, do I need to have the Summary and IssueKey on the CVS when doing this? 

[Ravi Varma]

Hi @Jon,

• Once the issues are created, you can specify the Issue->Sub task relationship between them using the IssueId and ParentId and import the CSV file.
• The issues and sub tasks are identified by IssueKey. In a single CSV file, you can add all those 40 sub tasks and their custom fields with appropriate values. When we import the CSV file, all the issues/sub tasks mentioned in the CSV file will be updated in a single stretch.

Regards,

Ravi Varma