Import issues from CSV - Parent link

Sari Kachorovsky December 14, 2023

Hello, I'm trying to import tasks from CSV files, when we create manually tasks, the Parent field (which was till lately Epic Link) is a must. I'm getting the following error: Unable to retrieve issue key for parent : BP-14257 To open sprints for Q1 24

what is the correct format of this Parent field? I've tried:

1. Only the number - 14257

2. with the prefix - BP-14257

3. With the name of the Epic too - BP-14257 To open sprints for Q1 24

in all of them I'm getting the error.

My CSV file looks like this 

image.pngMy mapping looks like this:

image.png

Any idea what I need to do?

Thanks

Sari

4 answers

0 votes
Rick Nahrstadt March 27, 2024

I too am having the same problems.  Now perhaps it works on their machine.....but out here in production I cannot get the Parent field to work.   The import process is broken.   I too am getting the Unable to retrieve issue key for parent error message.   I have tried a multitude of data to make this work.  But it seems that their Product Owners do not care that they have a sub-standard product.   Now here is why this import feature is important and NOW,   Have you heard of Artificial Intelligence and GPT technology?   Ya, I can spin up Epics and Stories and Tasks and Bugs pretty quick and need the ability to import this data into my tool set.

Jack Brickey
Community Leader
Community Leader
Community Leaders are connectors, ambassadors, and mentors. On the online community, they serve as thought leaders, product experts, and moderators.
March 28, 2024

hi @Rick Nahrstadt , you might want to open a support ticket with Atlassian Support.

Imdad Kottapparamban March 28, 2024

Hi @ric

I was getting the same error fixed with following method. Please share your CSV I can help you to fix.

https://community.atlassian.com/t5/Jira-Software-articles/Create-Update-Parent-Child-linking-using-CSV-Import/ba-p/2651594

Rick Nahrstadt March 28, 2024

Issue Type,Issue ID,Parent,Summary,Description
Epic,1,,User Engagement Platform,"This epic covers all features related to user engagement, including account creation, profile management, member connections, posting updates, engaging with posts, and notifications."
Story,2,1,User Registration,Allow visitors to create new accounts and access member-only features
Subtask,3,2,Design registration form UI,"Design the user interface for the registration form, including input fields, layout, and branding."
Subtask,4,2,Implement registration backend logic,"Develop the server-side logic to handle user registration, including data validation, email verification, and account creation."
Subtask,5,2,Create automated welcome email for new registrations,Set up an automated email system to send a welcome email to new users upon successful registration.
Story,6,1,User Profile Management,Enable members to update their profile information and preferences
Subtask,7,6,Design profile management UI,"Design the user interface for managing user profiles, including sections for personal information, interests, and preferences."
Subtask,8,6,Implement profile update functionality,"Develop the functionality to allow users to update their profile details, including personal information, interests, and preferences."
Subtask,9,6,Integrate profile picture upload feature,Implement the ability for users to upload and change their profile picture.

Rick Nahrstadt March 28, 2024

Importing: Issues
2024-03-28 18:28:48,564 INFO - ------------------------------
2024-03-28 18:28:48,564 INFO - Only new items will be imported
2024-03-28 18:28:48,677 INFO - Importing issue: [externalId='1', summary='User Engagement Platform']
2024-03-28 18:28:49,427 INFO - Importing issue: [externalId='2', summary='User Registration']
2024-03-28 18:28:49,439 WARN - Cannot add value [ [AAP-380] ] to CustomField Parent Link in Issue with summary 'User Registration'. Probably value was in incorrect format
2024-03-28 18:28:49,843 INFO - Importing issue: [externalId='6', summary='User Profile Management']
2024-03-28 18:28:49,845 WARN - Cannot add value [ [AAP-380] ] to CustomField Parent Link in Issue with summary 'User Profile Management'. Probably value was in incorrect format
2024-03-28 18:28:50,310 INFO - Importing issue: [externalId='3', summary='Design registration form UI']
2024-03-28 18:28:50,770 INFO - Importing issue: [externalId='4', summary='Implement registration backend logic']
2024-03-28 18:28:51,156 INFO - Importing issue: [externalId='5', summary='Create automated welcome email for new registrations']
2024-03-28 18:28:51,535 INFO - Importing issue: [externalId='7', summary='Design profile management UI']
2024-03-28 18:28:51,941 INFO - Importing issue: [externalId='8', summary='Implement profile update functionality']
2024-03-28 18:28:52,396 INFO - Importing issue: [externalId='9', summary='Integrate profile picture upload feature']
2024-03-28 18:28:52,785 INFO - 9 issues successfully created
2024-03-28 18:28:52,788 INFO - ------------------------------
2024-03-28 18:28:52,788 INFO - Finished Importing : Issues

 

Rick Nahrstadt March 28, 2024

Screenshot 2024-03-28 113053.png

Rick Nahrstadt March 28, 2024

In the log it states it cannot map the issue to the Custom Field Parent Link.  When I am doing the mapping I am mapping to Parent.  The importer logic is broken.

 

Bryan Cool
I'm New Here
I'm New Here
Those new to the Atlassian Community have posted less than three times. Give them a warm welcome!
April 18, 2024

@Rick Nahrstadtare you importing via System -> External system Import? I run into the same problems as you if I import there, but it seems to work fine if I import via Create -> Import Issues.

Does Create -> Import Issues let you import correctly?

Bryan Cool
I'm New Here
I'm New Here
Those new to the Atlassian Community have posted less than three times. Give them a warm welcome!
April 19, 2024

I just talked to Atlassian support and it looks like setting Parent is not currently supported for External System Import for team-managed projects. Apparently it works fine for company-managed projects, though.

Relevant issue here

Like Jose Galvez likes this
0 votes
Imdad Kottapparamban March 25, 2024

I have written an article with my successful import

https://community.atlassian.com/t5/Jira-Software-articles/Create-Update-Parent-Child-linking-using-CSV-Import/ba-p/2651594

 

issue key, issue type, summary, issue id, parent
ABC-123, Epic, I am an Epic, 1
ABC-256, Story, I am a story, , 1
ABC-894, Bug, I am a bug, , 1



123.png

This should result in ABC-256 and ABC-894 being put inside Epic ABC-123

0 votes
Jack Brickey
Community Leader
Community Leader
Community Leaders are connectors, ambassadors, and mentors. On the online community, they serve as thought leaders, product experts, and moderators.
December 14, 2023

Hi @Sari Kachorovsky , that is interesting for sure. I have not yet tried with the new parent field. However, I would expect it to be your number 2. Certainly not #1 or #3.

I wonder if you could try to simplify your import as a test. For example, what if we were to try to modify an existing issue and simply add the Parent to that issue. So your CSV would only have a few fields - issuekey, summary, parent.

Sari Kachorovsky December 14, 2023

@Jack Brickey Hey, Thanks for your reply, I can't add only parent because all my issues include Parents, it's a must field in the creation of Story/Task (they must be linked to an Epic)

Jack Brickey
Community Leader
Community Leader
Community Leaders are connectors, ambassadors, and mentors. On the online community, they serve as thought leaders, product experts, and moderators.
December 28, 2023

Hi @Sari Kachorovsky , I'm trying to reset my brain here so bear with me. If I understand correctly, you are attempting to create a number of stories using CSV import. More over you wish to associate all of those stories to an epic. Is this correct? Assuming so, could you please share a sample CSV Image? I have not attempted this since the recent changes of epic link migration to parent. I would hope that it would still work but I will need to try that. I await your response I will try a simple test on my side.

Jack Brickey
Community Leader
Community Leader
Community Leaders are connectors, ambassadors, and mentors. On the online community, they serve as thought leaders, product experts, and moderators.
December 28, 2023

@Sari Kachorovsky , here is what worked for me...

Here is my CSV file...

2023-12-28_10-21-36.jpg

Here is my mapping...

2023-12-28_10-24-03.jpg

Here is a JQL search illustrating the successful creation of the new stories associated to an existing Epic...

2023-12-28_10-26-21.jpg

Like Kristin Davis likes this
Kristin Davis December 28, 2023

This worked for me. But, before I left for the holiday break (and after they'd implemented the Epic Link to Parent change), Epic Link wasn't an option anymore. So, in the last couple weeks, they've added that back to the list... It's not logical, since they got rid of the Epic Link field, but if it works for now, it's what I'll use.

Like Jack Brickey likes this
Sari Kachorovsky January 1, 2024

@Jack Brickey much appreciate your help, strangely now I'm not getting the option to map the issue type at all, any idea why? unfortunately I can't try your suggestion since I'm stuck with the issue type (it worked in the past see my screen shot in my original Q above). Added also my CSV. Thanks!image.pngimage.png

Jack Brickey
Community Leader
Community Leader
Community Leaders are connectors, ambassadors, and mentors. On the online community, they serve as thought leaders, product experts, and moderators.
January 1, 2024

Unsure...

try entering "type"

Sari Kachorovsky January 1, 2024

Tried, Not finding.

Jack Brickey
Community Leader
Community Leader
Community Leaders are connectors, ambassadors, and mentors. On the online community, they serve as thought leaders, product experts, and moderators.
January 1, 2024

Unsure why. I cannot reproduce. Maybe step back and try a simple import to create a test issue...

type - summary - description 

otherwise contact support to have a look

Sari Kachorovsky January 17, 2024

@Jack Brickey updating that I've succeeded to find the Issue type, it works only from system->external system Import , and not via Create > Import Issues.

Jack Brickey
Community Leader
Community Leader
Community Leaders are connectors, ambassadors, and mentors. On the online community, they serve as thought leaders, product experts, and moderators.
January 17, 2024

@Sari Kachorovsky , I have never attempted create > import issues. It is relatively new and as such I have not spent any time playing with it. Generally speaking my workflow would not lead me in that direction. Thanks for sharing your findings.

Like Sari Kachorovsky likes this
0 votes
Sebastian Krzewiński
Community Leader
Community Leader
Community Leaders are connectors, ambassadors, and mentors. On the online community, they serve as thought leaders, product experts, and moderators.
December 14, 2023

Hi @Sari Kachorovsky 

 

Based on your screen you put epic link name not a parent id.

Please take a look here - https://confluence.atlassian.com/jirakb/csv-import-parent-child-mapping-1096095688.html

You need to modify your parent column.


Regards,

Seba

Sari Kachorovsky December 14, 2023

Hi @Sebastian Krzewiński  Thanks for you reply, I actually tried to work according to the link you sent but I'mm still stuck, I don't have the option to choose Parent Id, only Parent. WDYT?image.png

Sari Kachorovsky December 20, 2023

@Sebastian Krzewiński Did you had a chance to check this for me? I can't import. Thanks

Sari Kachorovsky December 28, 2023

@Jack Brickey @Sebastian Krzewiński Hi, do you know who can help me with this? I'm still struggling with this issue. 

Kristin Davis December 28, 2023

I can't provide any help yet, but we're having the same issue. Ever since the change from Epic Link/Parent Link to just Parent, I've been getting "Unable to retrieve issue key for parent" whenever I try to do a CSV import. So, I'm 99% sure it's tied to that change.

Like you, we require a parent, so I can't test updating using the import function. I guess I could temporarily turn that off or just try to change the parent on an existing issue... But, I'm guessing it would give the same result. At first, our support partner suggested it was a hierarchy issue, but that's not the case. Then they said something about the external ID that I tried to get clarity on but wasn't successful.

If we get this figured out, I'll come back and share the solution!

Like Adam_Sterrie likes this
Sari Kachorovsky January 18, 2024

@Kristin Davis finally I've succeeded - the headers of the CSV in my case are:

Pay attention that Assignee and reporter should be email or alias (and not the user name as it is, I didn't knew that). The Epic link should be the Parent issue key (for example BP-1234). And in mapping I've mapped Epic Link to Epic Link (and it put it in the Patent field). So the new Story that this import created opened it as a child of the Epic.

Issue type, Summary, Team, Assignee, Reporter, Epic Link

Adam_Sterrie February 14, 2024

@SebastianKrzewinski 

The article you linked to was last updated in 2021, before the change to Parent and the deprecation of Epic Link so is no longer of any use.

Can you simply tell us which field from the parent to put in the CSV for the stories/children and to which field it should be mapped to, to create the parent child link?

Sari Kachorovsky February 14, 2024

@Adam_Sterrie see my answer above ^

Sebastian Krzewiński
Community Leader
Community Leader
Community Leaders are connectors, ambassadors, and mentors. On the online community, they serve as thought leaders, product experts, and moderators.
February 14, 2024

@Adam_Sterrie @Sari Kachorovsky Please use Parent field. Check my sample config below:

Sample input:

sample_input.png

Mapping:

import_mapping.png

Results:

epic1_result.pngepic2_result.png

 

Helpful doc - https://confluence.atlassian.com/jirakb/csv-import-parent-child-mapping-1096095688.html

Like Jack Brickey likes this
Imdad Kottapparamban March 25, 2024

This method not working:
Getting error: Unable to retrieve issue key for parent : 12345

Paul G
I'm New Here
I'm New Here
Those new to the Atlassian Community have posted less than three times. Give them a warm welcome!
May 22, 2024

@Imdad Kottapparamban - I'm experiencing the same problem. Did you resolve the issue?

Goran Dermeta
I'm New Here
I'm New Here
Those new to the Atlassian Community have posted less than three times. Give them a warm welcome!
June 6, 2024

Same here, 

only CSV import with issue key mapped to Epic link field works. Parent seems broken, sadly.


EDIT: found the fix, you just set the issue ID for parent issues arbitrarily like

1 - epic 1
2 - epic 2

And then use those IDs in the parent column. 

I just managed to import 3 levels of issues in one file.

Suggest an answer

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

Atlassian Community Events