Create
cancel
Showing results for 
Search instead for 
Did you mean: 
Sign up Log in

Next challenges

Recent achievements

  • Global
  • Personal

Recognition

  • Give kudos
  • Received
  • Given

Leaderboard

  • Global

Trophy case

Kudos (beta program)

Kudos logo

You've been invited into the Kudos (beta program) private group. Chat with others in the program, or give feedback to Atlassian.

View group

It's not the same without you

Join the community to find out what other Atlassian users are discussing, debating and creating.

Atlassian Community Hero Image Collage

Error when importing sub tasks

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.

 

2 answers

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.

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?

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

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. 

Suggest an answer

Log in or Sign up to answer
TAGS

Community Events

Connect with like-minded Atlassian users at free events near you!

Find an event

Connect with like-minded Atlassian users at free events near you!

Unfortunately there are no Community Events near you at the moment.

Host an event

You're one step closer to meeting fellow Atlassian users at your local event. Learn more about Community Events

Events near you