Hi Everybody I need to to create multiple subtasks under a certain epic and am testing with the following Parent idIssue idIssue TypeSummaryStart dateEnd dateOriginal EstimateLabelAssignee118 Sub-taskFirst test bulk creation1/25/20222/25/20223600MVP2Email associated with my account I was able to map everything, validate is successful but subtask does not get created, I get the following error 2022-01-25 17:40:17,246 ERROR - Fatal error during import java.lang.IllegalArgumentException: Sub-Task Issue cannot be null. I am unable to put in a picture of the mapping Issue Type -> Issue Type. What am I doing wrong ? Please advice

Sub-task imports in Jira are complex (I really want to type "unnecessarily" in front of "complex" in that sentence, but I have not yet worked out a way to improve it) I want to be completely clear about what you are trying to import and how you are trying to do it to begin with, so I'm going to try to ask some simple "narrow it down" questions: * Are you using import into project as a non-admin user, or import CSV under Admin -> import? * Do you have Epics, Issues and sub-tasks defined in this project? (At least one of each?) * Are you trying to create sub-tasks on the Epic, or under issues within the Epic? (you can do both, but it might be important at which layer you are aiming for)

nav[aria-label="Primary Navigation"] { padding: 0; & ul { list-style: none; width: 100%; display: flex; flex-direction: row; justify-content: start; align-items: start; gap: 30px; padding: 0; & li { margin: 0; } & ul li { list-style: none; } } }

Subtask creation via CSV

auj012

Hi Everybody

I need to to create multiple subtasks under a certain epic and am testing with the following

Parent id	Issue id	Issue Type	Summary	Start date	End date	Original Estimate	Label	Assignee
118		Sub-task	First test bulk creation	1/25/2022	2/25/2022	3600	MVP2	Email associated with my account

I was able to map everything, validate is successful but subtask does not get created, I get the following error

2022-01-25 17:40:17,246 ERROR - Fatal error during import
java.lang.IllegalArgumentException: Sub-Task Issue cannot be null.

I am unable to put in a picture of the mapping Issue Type -> Issue Type.

What am I doing wrong ? Please advice

Accepted answers

Dave Theodore [Coyote Creek Consulting]

The "parent id" column needs to contain a valid, existing Jira issue number.

Joseph Chung Yin

@auj012 -

Welcome to the community. I agreed with @Dave Theodore [Coyote Creek Consulting] statement. If your EPIC issue is already created in your project, then you will need to add the Epic issue key in the Parent ID column.

Example -

However, if you are creating the parent/child issues in a CSV file at the same time, then you can just provide the parent ID and not the issue key.

Example -

Hope this helps.

Best, Joseph Chung Yin

Jira/JSM Functional Lead, Global Infrastructure Applications Team

Viasat Inc.

Nic Brough -Adaptavist-

Sub-task imports in Jira are complex (I really want to type "unnecessarily" in front of "complex" in that sentence, but I have not yet worked out a way to improve it)

I want to be completely clear about what you are trying to import and how you are trying to do it to begin with, so I'm going to try to ask some simple "narrow it down" questions:

Are you using import into project as a non-admin user, or import CSV under Admin -> import?
Do you have Epics, Issues and sub-tasks defined in this project? (At least one of each?)
Are you trying to create sub-tasks on the Epic, or under issues within the Epic? (you can do both, but it might be important at which layer you are aiming for)

Joseph Chung Yin

@auj012 -

Great. I am glad you got it fixed + letting us know by confirming that your parent ID (in your screenshots) was edited so to hide the necessary information.

Please click on everyone's suggested answer by "Accept Answer" when you have a chance. So, other community members for the similar asks will be benefited from all of our suggestions

Best, Joseph

All comments

Dave Theodore [Coyote Creek Consulting]

The "parent id" column needs to contain a valid, existing Jira issue number.

Joseph Chung Yin

@auj012 -

Example -

However, if you are creating the parent/child issues in a CSV file at the same time, then you can just provide the parent ID and not the issue key.

Example -

Hope this helps.

Best, Joseph Chung Yin

Jira/JSM Functional Lead, Global Infrastructure Applications Team

Viasat Inc.

auj012

Hi Joseph

I did , please notice the first column.

This is the mapping of the columns

auj012

Hi Dave

It does have a valid number since this is a public post and this is for workd I just edited it.

Thanks

Joseph Chung Yin

@auj012 -

However 118 in your CSV screen doesn't seems to be a valid issue key. It is missing the projectkey.

Forgot to mention in your original ask - "I am unable to put in a picture of the mapping Issue Type -> Issue Type. " Do you have issue type "Sub-task" included in your target project's issue type scheme?

Best, Joseph

Nic Brough -Adaptavist-

Sub-task imports in Jira are complex (I really want to type "unnecessarily" in front of "complex" in that sentence, but I have not yet worked out a way to improve it)

I want to be completely clear about what you are trying to import and how you are trying to do it to begin with, so I'm going to try to ask some simple "narrow it down" questions:

Are you using import into project as a non-admin user, or import CSV under Admin -> import?
Do you have Epics, Issues and sub-tasks defined in this project? (At least one of each?)
Are you trying to create sub-tasks on the Epic, or under issues within the Epic? (you can do both, but it might be important at which layer you are aiming for)

auj012

Nic

1. Yes I do have admin privileges but will check again.

2.Yes we do please see attached.

3. I am trying to create a task/subtask -- under a Initiative. After checking the above I noticed that "Sub-Task" is not a option, so I changed it to "Task" but now validate itself fails

I noticed that "Sub-task" is not a option here, so I checked it to Task and now validation fails with this

Issue 'First test bulk creation' doesn't have Subtask Issue Type, its Parent Id mapping will be ignored.

auj012

These are the types that are supported in my system Joseph. I had to show 118 since I am working on a confidential project. But in the sheet the fill key is there.

Dave Theodore [Coyote Creek Consulting]

Correct. You cannot create a sub-task that way. Since it needs to be associated with a parent, you can only create the sub-task from within the parent. With CSV import, the parent you want the sub-task to be a child of must already exist when you perform the sub-task association. A sub-task cannot stand alone.

auj012

That is what I thought as well but when I change the Issue type to a Epic or Task, to be created under the parent that I am interested in I get this

Issue 'First test bulk creation' doesn't have Subtask Issue Type, its Parent Id mapping will be ignored.

The detailed log is this

2022-01-26 18:18:10,018 INFO - Importer started!
2022-01-26 18:18:10,021 INFO - Engine is running in Validation-only mode
2022-01-26 18:18:10,023 INFO - All issues will be imported to project: xxxxxxxxxxxxxxxxxxxxxxxxxxx
2022-01-26 18:18:10,024 WARN - Issue 'First test bulk creation' doesn't have Subtask Issue Type, its Parent Id mapping will be ignored.
2022-01-26 18:18:10,024 INFO - Creating issue: [externalId='autoid-7661170984644918240', summary='First test bulk creation']
2022-01-26 18:18:10,074 INFO - No problems found with issue 'First test bulk creation'

auj012

Hi everybody

I was able to make this work, the issue was "Components" the way Jira was setup, this was a mandatory field. Once I populated that I was able to create it.

Thanks for every bodies help

Joseph Chung Yin

@auj012 -

Great. I am glad you got it fixed + letting us know by confirming that your parent ID (in your screenshots) was edited so to hide the necessary information.

Please click on everyone's suggested answer by "Accept Answer" when you have a chance. So, other community members for the similar asks will be benefited from all of our suggestions

Best, Joseph

Welcome!

It looks like you're new here. Sign in or register to get started.

Quick Links

Find more posts tagged with

csv

jira-service-desk-server

import

sub-task

jira-service-management

jira-service-management-server