Come for the products,
stay for the community

The Atlassian Community can help you and your team get more value out of Atlassian products and practices.

Get started Tell me more

4,551,796

Community Members

Community Events

184

Community Groups

Community
Products
Jira
Jira Software
Questions
Issue Bulk Importing, how do I import the epic Link?

Issue Bulk Importing, how do I import the epic Link?

I have a csv file that I am using to bulk import issues. All of the columns/data are translating without issue except for the "Epic Link" Field.

I have an Epic with the Epic Link "Test Epic". I have a column in my csv file called "Epic Link" and the relevant rows have the value "Test Epic".

When I bulk import my issues this value is not populated and it doesn't generate an error. I have tried with and without quotes. Any ideas?

Thanks

4 answers

1 vote

Are you importing the issues to a Company Managed project or a Team Managed project?

For a Team Managed project it is currently not possible to use the CSV import to link stories to Epics.

For a Company Managed project, if the Epic already exists in Jira and you know its Issue Key (i.e. ABC-123), add that key to a column in your CSV for each child issue, and link that column to the Epic Link field when mapping fields for your import.

If you are trying to create the Epic in the same CSV import process as the child issue, then you have to do something like this:

Type,Issue ID, Summary, Epic Link
Epic, 1, Epic Summary,
Story, 2, Story 2 Summary, 1
Story, 3, Story 3 Summary, 1
Story, 4, Story 4 summary, 1

Create an Issue ID field in your CSV. Assign unique numbers in that column to each issue. For the child issues, put the Issue ID value of the parent Epic in the Epic Link column for those child issues. When importing the data, again map that Epic Link column to the Epic Link field.

You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.

Comment

Thanks,

This is for a company managed project. The epic does already exist within Jira.

So in the current epic link column I have, I can just replace the name "Test Epic" name I currently have with the issue key of the epic and that will work?

You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.

Comment

Yes, it should.

You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.

Comment

0 votes

Hi @Trudy Claspill would you please review what I have and point me in the right direction?

I'm trying to follow these directions of yours:

"If you are trying to create the Epic in the same CSV import process as the child issue, then you have to do something like this:

Type,Issue ID, Summary, Epic Link
Epic, 1, Epic Summary,
Story, 2, Story 2 Summary, 1
Story, 3, Story 3 Summary, 1
Story, 4, Story 4 summary, 1

Did I misunderstand something?

You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.

Comment

Hello @Sierra

Are you a Jira Administrator?

Are you working with Jira Cloud or Jira Server/Data Center?

How did you access the CSV import functionality? There are multiple ways to get to it.

- from the Advanced Issue Search screen

- from the Create Issue dialog

- for a Jira Administrator, from the gear icon / System / External System Import

You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.

Comment

@Trudy Claspill yes I am. Jira Cloud. I accessed it by clicking "Import issues from CSV" within the software project on the Issues tab.

You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.

Comment

Try the Jira Administrator path:

from the gear icon / System / External System Import / CSV

You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.

Comment

I went through that path this morning, the same outcome as in none of the Tasks are linked to their Epic. When looking in the project these were imported into, everything else imported accurately and as intended.

You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.

Comment

It appears that the functionality has changed.

I am 100% positive that it used to work using a unique number for Issue Key and putting that into the Epic Link column of the child issues. That is not working for me at this time.

However, if you put the Epic Name value into the Epic Link field of the child issues, and the Epics come before the child issues in the CSV, then the import works. And the unique number Issue Key is not needed in that case.

You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.

Comment

This morning I put the Epic Name values into the Epic Link field of the child issues, removed the Issue ID column. Same result, everything imports correctly over expect the issues aren't affiliated with the Epics. I just found another post with this issue Solved: Errorperforming CSV import: Cannot add value to Ep... (atlassian.com) , that you happened to of commented on. I notice we have one thing in common, I do have existing Epics in the project with the same Summary name...this was because the ask is to have several of the same boards created to jump in-between for a specific type of work. I suppose I'm going to try to get them to give different Epic Names for each board...