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 vote

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 Sign up to answer
Atlassian Community Anniversary

Happy Anniversary, Atlassian Community!

This community is celebrating its one-year anniversary and Atlassian co-founder Mike Cannon-Brookes has all the feels.

Read more
Community showcase
Julia Dillon
Posted Tuesday in Jira

Tell us how your team runs on Jira!

Hey Atlassian Community! Today we are launching a bunch of customer stories about the amazing work teams, like Dropbox and Twilio, are doing with Jira. You can check out the stories here. The thi...

244 views 1 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