Import sub-task from CSV file

[Yehuda Maor]

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, 

[Nic Brough -Adaptavist-]

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?

[Yehuda Maor]

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

[Nic Brough -Adaptavist-]

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.

[Yehuda Maor]

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/ 

[Nic Brough -Adaptavist-]

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.

[Yehuda Maor]

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  

[Nic Brough -Adaptavist-]

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.

[Yehuda Maor]

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)

[Nic Brough -Adaptavist-]

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

[Yehuda Maor]

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....)

[Yehuda Maor]

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

[Yehuda Maor]

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