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

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

Import sub-task from CSV file

Hi There. 

I'm trying to import data of sub-task form CSV. I'm getting good "how to" information form this page: https://support.atlassian.com/jira-cloud-administration/docs/import-data-from-a-csv-file/

However I still have some road blocks:

1. I can't see an option to map 'Issue Key' field. When I'm trying to search for it to map it to my CSV input I don't see matching Jira field

2. The issue type that I'm trying to upload is a subtask but I can't map the 'Issue Type' filed (similar to the above)

Any suggestions?

Thanks, 

1 comment

Welcome to the community!

I'm afraid I only have clarification questions:

1.  Are you creating new issues, or trying to update existing ones?

2.  Do you have at least one sub-task issue type in the project you are trying to import into?

Thanks for the feedback even though those are only clarification questions....

1. I'm trying both - updating existing issues (sub-tasks, actually) as well as creating new one 

2. I do have few sub-tasks - those that I'm trying to update

Ok, I would separate this into two pieces, the create and the edit, simplifying each part.

When you are creating issues, you do not give it an issue key, Jira creates new issues in sequence in the project they are being added to.  

If you are just doing edits, then you do need the issue key to tell Jira what issues to update - last time I looked, that maps to just "key", not issue key.

Thanks

What about the other part?

I'm interested in creating (or updating) not just an 'issue' but a sub-task. I couldn't understand how to do the mapping so that the issue type will be sub-task.

Refer to 'Creating sub-tasks' paragraph in this article : https://support.atlassian.com/jira-cloud-administration/docs/import-data-from-a-csv-file/ 

The "other part" is the create or edit that you are not currently looking at.

If you are creating an issue, you do not give it an issue key.  

If you are creating sub-tasks, you need to give them a pointer to the parent issue they belong to

When updating an issue, you have to give it the key of the subtask you are trying to update.

Okay, I'll handle one objective at a time

Starting with editing existing issues - I Have the issue key as a column in my CSV file but when I'm trying to map it to Jira field I can't find 'key' field

I found 'issue id' (which is also in my CSV file) and tried to use that but it didn't work - the lines from my CSV file have been created as new issues (instead of updating the existing issues that have the same 'issue id')

Please advise  

Ok, I was thinking of the server import when I said "key".  

When you are mapping your columns, it does not matter what they are called in your CSV, but for updating issues, map the column with the existing issue keys (ABC-123) to be updated on to the "issue key" that is offered in mapping.

I understand that it doesn't matter how the column is called in the file.... what I meant is that I couldn't find neither 'issue key' nor 'key' offered in mapping (... to be mapped to my column)

It will vanish from the offer if you have mapped it already.  Have you tried starting from scratch with a very simple import file?

Yes.

My field (in the 'CSV Fields' column in the 'Map Fields' step of the upload procedure) name is 'Issue Key' and as we've established that is not important

I'm typing 'K' in the 'Jira Fields' column and immediately getting 'No Matches' response

Another comment coming up to my mind just now, I'm not sure if it's event relevant but just to cover all bases - the platform I'm working on is 'Jira Service Desk' (as I said - if it's even mater....)

One more comment - 

The only fields that are offered for mapping are my custom fields that are included in my project, Jira fields: Labels and Summary only and Links and Sub-Tasks fields: issue ID and parent ID only. No other field is being offered at all

Okay, another piece of information - 

I added 'Issue Type' system field to my screens and now i ca see this field also offered for mapping under Jira Fields along with Summary and Labels. I tried to look for 'Key' in order to do the same but I didn't see it anywhere

Comment

Log in or Sign up to comment
TAGS
Community showcase
Published in Jira Service Management

Atlympic Event: Jira Service Managemnt

Hello Community!  Quick disclaimer: We are running a contest on Community (The Atlympics!) from July 23rd - August 8th of 2021. If you are interested in participating in this contest (prizes! ...

177 views 0 3
Read article

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