Query on bulk upload CSV to update Parents

[keerthi_guntupalli]

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"

[Mangali Chandrashekar]

Hi @keerthi_guntupalli What is the work type hierarchy following in Jira ?? And to which child work item you would like to add parent.

[keerthi_guntupalli]

Parent hirearchy - 1 & Child hirerachy -0

[Mangali Chandrashekar]

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

[keerthi_guntupalli]

@Mangali Chandrashekar , i didn't quite get it, can you please eloborate, i am trying to update the parents (epics) for the existing child items.

[Mangali Chandrashekar]

@keerthi_guntupalli  What I am saying that add parent field and epic link field to child work item create screen. And then when you are bulk uploading parent epic for child right map csv parent field to Jira parent field.

[Mangali Chandrashekar]

@keerthi_guntupalli  ++ please use Jira epic work key in parent column

[Karan Sachdev]

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

[keerthi_guntupalli]

Hello Karan,

Here are columns that i am using to upload

[keerthi_guntupalli]

still getting the same error :

• Unable to retrieve issue key for parent : 326789

[Trudy Claspill]

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?

[keerthi_guntupalli]

Company managed projects

[keerthi_guntupalli]

is there any other alternative or workaround  to get the task done for time being

[Trudy Claspill]

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.