I am trying to bulk update parents(EPIC's) for JIRA issues, i am mapping the fields Work item key, Work item id, Parent, Summary, Work type.
For some reason i am still getting error : "Unable to retrieve issue key for parent : XXXX-0001"
Hi @keerthi_guntupalli What is the work type hierarchy following in Jira ?? And to which child work item you would like to add parent.
Hello @keerthi_guntupalli
There have been open bugs related to setting the Parent field through a CSV Import.
I saw that a fix was deployed for this for importing to Team-managed projects. Into what type of project are you trying to import these changes?
Company managed projects
is there any other alternative or workaround to get the task done for time being
Here are the issue related to this for Company Managed projects.
https://jira.atlassian.com/browse/JRACLOUD-96848
https://jira.atlassian.com/browse/JRACLOUD-92272
You could use the REST API as an alternative.
You could use the Bulk Change feature to update subsets of issues that all need to be changed to the same parent Epic.
Hey @keerthi_guntupalli
Good day!
Could you please share a screenshot of a few columns from your CSV file? You may trim any sensitive data since this is a public platform. I'd like to review the work item ID and parent columns (as in how are you relating them in your CSV).
Please ensure that the CSV file structure should be as described in this article: https://support.atlassian.com/jira/kb/keep-issue-parent-child-mapping-during-csv-import-to-jira-cloud/
I think it would be better to raise a support ticket for this, since the query requires a review of the file you're using, field mapping etc.
Regards,
Karan
Hello Karan,
Here are columns that i am using to upload
still getting the same error :
Parent hirearchy - 1 & Child hirerachy -0
@keerthi_guntupalli In the child hierarchy work item add parent and epic link columns to create screen and map CSV parent column to Jira parent while uploading. It will work.
@M Chandra Shekar , i didn't quite get it, can you please eloborate, i am trying to update the parents (epics) for the existing child items.
Hi @keerthi_guntupalli ,
updating parents in bulk is one of the cases where I would be extra careful with CSV import. A small mapping mistake can move many work items under the wrong parent.
I would test this in a very small batch first:1. include the existing Work Item Key for every child item,2. include the new Parent value,3. avoid including unrelated fields,4. verify the result on 2–3 items before running the full file.
Also make sure the new parent is valid for the child’s work type and project hierarchy. The importer can map the value, but it will not fix an invalid hierarchy model.
Full disclosure: I built Excel Backlog Importer for Jira. One of the reasons was to make these repeated Excel-to-Jira updates less risky: upload XLSX, map only the fields you want to change, validate rows, preview updates, and then apply them. It will not bypass Jira permissions, but it can reduce the chance of damaging hierarchy through a blind CSV update.
It looks like you're new here. Sign in or register to get started.
