How to update Sub-tasks via JIRA importer

hi

I am using External System Import feature to update an existing Sub-task. My goal i sto update a Sub-task w.r.t it's Parent Id. 

Before: A sub-task SAM-1 has a parent story PAR-1

After Import : SAM-1 has parent story as PAR-2

My csv looks like this  :

Issue Id, issue type, Summary, Parent Id

SAM-1 , Sub-task , "hello world", PAR-2

When I import the CSV, I get the following message : "1 of 1 issues have been skipped because they already exist in destination projects."

I also tried mapping Issue Id to issue Key during the import column mapping, but I dont see the update happening. 

Please help.

1 answer

0 votes

This sounds like it is wrong, and I think you need to re-explain the problem more clearly

You say 

> Before: A sub-task SAM-1 has a parent story PAR-1

No.  No it does not.  SAM-1 cannot possibly have a parent story of PAR-1.  Subtasks belong to the same project as their parent and are always higher numbered.  So SAM-2 could be a child of SAM-1, but if your JIRA really does have what you describe, then you've broken it, and badly.  You need to forget CSV updates for now and repair that before you can do anything else.

I'm hoping what you've actually done is just written this question with bad data though.  If that is correct, could you explain what you have really got and what the actual parent/child ids are and what is in your CSV

hi Nic,

Thanks for your reply. Yes, my data is incorrect. Let me give you the valid data:

Before: Sub-task ST-17 has a parent story ST-8

After Import : ST-17 should have a parent story ST-6

My CSV looks like this:

Issue Id, issue type, Summary, Parent Id

ST-17 , Sub-task , "hello world", ST-6

I have tried importing this CSV using the following column mapping (2 different import trials)

Trial 1 Mapping : Issue id -> Issue Id

Trial 2 Mapping : issue id -> Issue Key

But with neither trials, I am seeing the parent Id getting updated to ST-6.

Please note that ST-17, ST-8, ST-6 etc are already existing issues in JIRA. 

Thanks.

Ah, that makes more sense. Problem is that the CSV importer can not change the parent issue of a subtask.

is it possible to drop a link between 2 issues from JIRA UI ?

Totally off-topic, but yes, click delete.

Suggest an answer

Log in or Join to answer
Community showcase
Sarah Schuster
Posted Jan 29, 2018 in Jira

What are common themes you've seen across successful & failed Jira Software implementations?

Hey everyone! My name is Sarah Schuster, and I'm a Customer Success Manager in Atlassian specializing in Jira Software Cloud. Over the next few weeks I will be posting discussion topics (8 total) to ...

2,772 views 11 18
Join discussion

Atlassian User Groups

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

Find a group

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

Find my local user group

Unfortunately there are no AUG chapters near you at the moment.

Start an AUG

You're one step closer to meeting fellow Atlassian users at your local meet up. Learn more about AUGs

Groups near you
Atlassian Team Tour

Join us on the Team Tour

We're bringing product updates and pro tips on teamwork to ten cities around the world.

Save your spot