Bulk importing of data for custom fields on an issue

Question

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 · Answer

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

Jon_4n6t23 · Answer

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?

Jon_4n6t23 · Answer

hi Ravi,

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