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

Earn badges and make progress

You're on your way to the next level! Join the Kudos program to earn points and save your progress.

Deleted user Avatar
Deleted user

Level 1: Seed

25 / 150 points

Next: Root

Avatar

1 badge earned

Collect

Participate in fun challenges

Challenges come and go, but your rewards stay with you. Do more to earn more!

Challenges
Coins

Gift kudos to your peers

What goes around comes around! Share the love by gifting kudos to your peers.

Recognition
Ribbon

Rise up in the ranks

Keep earning points to reach the top of the leaderboard. It resets every quarter so you always have a chance!

Leaderboard

Come for the products,
stay for the community

The Atlassian Community can help you and your team get more value out of Atlassian products and practices.

Atlassian Community about banner
4,463,681
Community Members
 
Community Events
176
Community Groups

Unable to load sub-tasks from CSV file

Edited

Hi Experts,

I am trying to import sub-tasks from a CSV file, and link it to the tasks already existing in the system.

I took an export of the existing Tasks to get the Issue ID, which I am using as the Parent ID for the sub-tasks that I want to import.

However, while validating the load I am getting the error - 

"Subtask 'Sub Task 1' doesn't have a valid Parent Id selection. Issue will not be created. "

 

Please help me resolve this issue.

3 answers

I know this one is a bit older and the explanation is Correct, but also confusing and not complete.

You can import Sub-tasks on their own with no problem BUT, you MUST include the original task parents AS WELL

Wait what!? you said I don't have to create them at the same time.

You do NOT have to re-create the issues but the csv needs to know they are THERE are the time when it parses the csv.

When you add "issue id", and that already exists in Jira, it will try to EDIT that issue. This is important to understand how this works when adding sub-tasks to existing tasks/stories etc.,

Ex.

TEST-123 exists in Jira already, that is OK

.csv

Issue Type, Issue Id, Parent Id, Summary, Description,...
Task, TEST-123, , , <-- leave the Summary blank it will fail to UPDATE the original issue 
Sub-task, ,TEST-123, I like dogs, description why,,, <-- sub-task can now be linked properly

Notes:

- Failed to update the original issue will still create the new sub-tasks correctly

- Adding "Issue Id" will try to UPDATE the existing issue,  otherwise it will try to make a new issue with that EXACT key.

- You must include the original key and original story/task or the subtask cant find it during parsing

 

I hope this helps!

CJ

0 votes

Check the Importing Data From CSV doc and scroll down to the "Creating Sub-tasks" section. It describes the format.

For example, if you want your sub-task to be associated with ABC-123, your CSV format will look something like this:

Summary,Issue ID, Parent ID
"my issue summary",ABC-123,,
"my sub-task summary",,ABC-123

 Note the "Parent ID" column has no value for the parent issue, and there is no "Issue ID" for the sub-task, since we didn't choose to manually give it an issue number. In this case, the sub-task will become the next issue # in sequence. 

Thank you Dave for the response.

I have followed the Importing Data From CSV doc while creating the sub-tasks

PFB the sub-tasks in CSV format that I want to import and link them to a task already existing in the system - 

Area ( Testing )*,Sub-Area ( Testing )*,Issue ID*,Parent ID*,Issue Type*,Summary*
Setup,Tenant Readiness Check,,11537,Test Case,Verify that all requested test user accounts are ready - As Compensation Admin - NA

 

Task with the Issue ID -11537 already exists in the system and I want to import the sub-task ( Issue Type - Test Case ) of it. While validating the import , I am getting the following error - 

Subtask 'Verify that all requested test user accounts are ready - As Compensation Admin - NA' doesn't have a valid Parent Id selection. Issue will not be created. 

I am getting this error while trying to validate the import of any sub-tasks to my project. Do I need to configure any project setting , as despite a valid parent id I am continuously getting this error.

NOTE : Earlier the import of sub-tasks was happening without such errors. All of a sudden , I am getting this error.

 

Please let me know I am committing any mistake. Please help me resolve this issue. 

Are you mapping the "Issue type" column values to the desired ones? You need to tick the checkbox on the right in order to map them. The "Parent ID" value in each row is a full valid issue# right? LIke ABC-123 rather than just 123.

It may also be worth opening an Atlassian support ticket to have them look at the logs for more detailed info.

Like Guillermo likes this

Yes, the issue type is right and the value has been mapped also by the checkbox on the right. The only issue is JIRA is stating that the Parent ID select is not valid, while it is a valid one.

I have the same problem. Issue IDs are valid but Jira is not importing them. So, I tried using the Parent Key instead. About 1/4 of those imported. Wish I was making this up.

Same issue here - doing everything in exactly the same manner as the export file - no love!

Subtask '4. Sign Off Complete' doesn't have a valid Parent Id selection. Issue will not be create

Same issue for me.
try both with parent issue key and parent issue id.

Suggest an answer

Log in or Sign up to answer
DEPLOYMENT TYPE
CLOUD
PRODUCT PLAN
FREE
PERMISSIONS LEVEL
Site Admin
TAGS

Atlassian Community Events