Error when importing sub tasks

[Gina Preoteasa]

I can't import sub-tasks and I wonder if it's from the configuration file.

Sample file:

IssueType, Summary, Labels, Original Estimate, Due Date, Sequence, My parent
Story,"Define Technical Vision", "Activity", , , 1,
Sub-task,"Describe the System Context","Task" , ,2,1
Sub-task,"Develop Technical Vision","Task", , 3,1
Story,"Business Objective Understanding", ,4,
Sub-task,"Build Software Engineering and Product Management Knowledge" , , 5,4
Sub-task,"Define Software Quality Management Measures", , 6,4
Sub-task,"Assess Skill/training gap", , 7,4

Config file:

{
"config.version" : "2.0",
"config.project.from.csv" : "false",
"config.encoding" : "UTF-8",
"config.email.suffix" : "@",
"config.field.mappings" : {
"IssueType" : {
"jira.field" : "issuetype"
},
"My parent" : {
"jira.field" : "subtask-parent-id"
},
"Summary" : {
"jira.field" : "summary"
},
"Labels" : {
"jira.field" : "labels"
},
"Sequence" : {
"jira.field" : "issue-id"
},
"Original Estimate" : {
"jira.field" : "timeoriginalestimate"
},
"Due Date" : {
"jira.field" : "duedate"
}
},
"config.value.mappings" : { },
"config.delimiter" : ",",
"config.project" : {
"project.type" : null,
"project.key" : "MW",
"project.description" : null,
"project.url" : null,
"project.name" : "Methods Workspace",
"project.lead" : "gina.boca@ro.ibm.com"
},
"config.date.format" : "dd/MMM/yy h:mm a"
}

How should I map Sequence and My Parent ?  I linked Sequence with Issue Id from Category Links & Sub-tasks and My Parent with Parent ID from the same category. However the import of  sub tasks is unsuccessful.

• Subtask 'Describe the System Context' doesn't have a valid Parent Id selection. Issue will not be created.
• Subtask 'Develop Technical Vision' doesn't have a valid Parent Id selection. Issue will not be created.
• Subtask 'Build Software Engineering and Product Management Knowledge' doesn't have a valid Parent Id selection. Issue will not be created.
• Subtask 'Define Software Quality Management Measures' doesn't have a valid Parent Id selection. Issue will not be created.
• Subtask 'Assess Skill/training gap' doesn't have a valid Parent Id selection. Issue will not be created.

Thank you for your guidance.

[Niranjan]

Hi @Gina Preoteasa ,

This is explained here - https://confluence.atlassian.com/adminjiraserver/importing-data-from-csv-938847533.html

The fourth issue will be sub-task of the second issue upon import, assuming you match the 'Issue ID' and 'Parent ID' fields in your CSV file to the Issue Id and Parent Id Jira fields. Issue ID can be any unique number, but that should be mentioned in the parent ID against the sub-task column.

[Gina Preoteasa]

Thank you, but it doesn't work.

Can you please share directly a sample csv and configuration file , please, so I can customize it afterwards to my needs?

[Niranjan]

@Gina Preoteasa - The attached screenshot is a simple csv file. You can create one with those columns and try the import.

[Sufi]

Use the JIRA ID for parent ID like ABC-123 (the ones in the URL). Putting this out here since I found it today. Other places it mentions that you have to use the parentId which is not correct.