CSV Import of Multiple Epics with associate stories

Rhodnia Johnson

Good Day,  Can someone assist with how I would be able to do a csv import of multiple epics with related stories?  Is there a template I can use and where would I go in JIRA to do this?  Any help you can provide would be awesome.  I have a number of epics (and stories) to input and doing it manually will be tedious.

 

Trudy P Claspill

Hello @Rhodnia Johnson 

Welcome to the community.

There are no templates in Jira for assisting you in creating your CSV file for importing data. You have to create that yourself.

There are documents that describe how to create CSV files. Here is one such document with links to others:

https://support.atlassian.com/jira-cloud-administration/docs/import-data-from-a-csv-file/

Here is a very short explanation regarding importing Epics and child issues using just one file.

You would need to structure you file so that an Epic is listed before any of its child issues.

You use a generic Issue ID field to number the Epics and issues within your CSV file.

In your child issues you place the Issue ID value for the parent Epic into the Epic Link field for the child issue. Jira knows to look at that number and look back through the same import session to find the issue it created associated with that number.

Here's an example:

IssueID, Issue Type, Summary, Epic Link

1,Epic,Summary for Epic 1,

2,Story,Summary for Story 1 under Epic 1,1

3,Story,Summary for Story 2 under Epic 1,1

4,Epic,Summary for Epic 2,

5,Story,Summary for Story 1 under Epic 2,4

6,Story,Summary for Story 2 under Epic 2,4

 

When executing the import process you would map the IssueID field to the Issue ID field in Jira.

This is not a complete example. Other fields are required to be included in your CSV data depending on the type of issues you are importing and customization you may have made to Jira.

Note that the above applies when importing issues to a Company Managed project. Team Managed projects manage the link between Epics and their child issues differently.