Forums

Articles
Create
cancel
Showing results for 
Search instead for 
Did you mean: 

CSV Import/Export projects with custom issue hierarchy

Rajat Saxena
October 30, 2023

Hello experts,

I'm new to JIRA so might be missing something obvious.

Business use case:

I need to generate a CSV containing a list of issues (similar to the export of "Base Project 3") which will then be sent to various teams and they would create + run projects using those issues. I need a template for the CSV which can be imported with minimal configuration, and eventually I will create an automated process to generate that CSV (outside of JIRA).

My idea was to create a sample project with the necessary issue types and parent links, export that to a CSV and import that CSV back into a new project. This way I can then work on generating the CSV in the required format.

Background:

I have a project called "Base Project 3" which defines a custom issue hierarchy above the epic. For reference, the issue hierarchy is "Deliverable 1" -> "Deliverable 2" -> "Deliverable 3".

Screenshot 2023-10-31 at 12.11.57 PM.png

I have added some issues in the project and configured the parents as applicable. The issues are named to indicate their issue type. Here's how the base project looks like in Advanced Roadmaps:

Screenshot 2023-10-31 at 12.10.23 PM.png

 

I exported this project to CSV with some selected fields, and it looks like this:

Screenshot 2023-10-31 at 12.27.29 PM.png

Problem:

I want to import the CSV exported above into a new project, called "Imported Project 2". I first created the project, and configured it to use the same issue type scheme. When I went ahead and imported it, I could not map the "Custom Field (Parent Link)" and "Issue Key" fields for some reason.

Screenshot 2023-10-31 at 12.15.47 PM.png

All the issues get imported with the correct issue types, but the parents are not set correctly. Instead, the issues map their parent issues to "Base Project 3".

Screenshot 2023-10-31 at 12.17.55 PM.png

 

Screenshot 2023-10-31 at 12.18.39 PM.png

How do I resolve this? Is admin access required for achieving the above (even though I have admin access)?

I am using a premium license and creating company-managed projects. I would prefer not to use any plugins to support this since that does not align with my organization's plans at the moment.

Thanks,

Rajat.

0 answers

Suggest an answer

Log in or Sign up to answer