nav[aria-label="Primary Navigation"] { padding: 0; & ul { list-style: none; width: 100%; display: flex; flex-direction: row; justify-content: start; align-items: start; gap: 30px; padding: 0; & li { margin: 0; } & ul li { list-style: none; } } }

How to import stories linked to epics in jira

Matthew Cowling1

We have an externally supplied set of user stories, grouped as Epics, which we wish to import into JIRA (CSV). I can easily import the stories, but how can we import both simultaneously so that the stories are automatically linked to the various EPIC. I do not want to have to create the EPICs first, we would like to import all at once.

Accepted answers

pborkowski

That shouldn't be a problem when using JIRA CSV Importer. Simply specify Epic Link mapping in your stories example:

Issue Type,Epic Name,Summary        ,Epic Link
Epic      ,  my-epic,Build a car    ,
Story     ,         ,Build an engine,  my-epic
Story     ,         ,Buy some tires ,  my-epic

The example above will create an epic and link stories to that epic.

All comments

pborkowski

That shouldn't be a problem when using JIRA CSV Importer. Simply specify Epic Link mapping in your stories example:

Issue Type,Epic Name,Summary        ,Epic Link
Epic      ,  my-epic,Build a car    ,
Story     ,         ,Build an engine,  my-epic
Story     ,         ,Buy some tires ,  my-epic

The example above will create an epic and link stories to that epic.

Matthew Cowling1

Thanks, greatly appreciated. (your user documentation is not so clear on this!)

Gil Groman

What is the REST parameters needed to set this 'Epic Link' field? is it a custom field in JIRA? what's is value?

Michael Green7

Hi,

I tried this and its not working. My CSV data looks like this :

ERROR LOG SHOWS :

16-05-25 16:40:33,544 INFO - Reindexing took 41 ms.
2016-05-25 16:40:33,544 INFO - Importing issue: [externalId='autoid-4020395359902999763', summary='DT Go Live|Additional Feeds|ACT Spatial|']
2016-05-25 16:40:33,554 WARN - Cannot add value [ [Additional Feeds] ] to CustomField Epic Link in Issue with summary 'DT Go Live|Additional Feeds|ACT Spatial|'. Exception Message: null
java.lang.NullPointerException
	at com.atlassian.jira.issue.search.parameters.lucene.DefaultPermissionQueryFactory.collectProjectTerms(DefaultPermissionQueryFactory.java:133)
	at com.atlassian.jira.issue.search.parameters.lucene.DefaultPermissionQueryFactory.getQuery(DefaultPermissionQueryFactory.java:63)
	at com.atlassian.jira.issue.search.parameters.lucene.PermissionsFilterGeneratorImpl.getQuery(PermissionsFilterGeneratorImpl.java:28)
	at com.atlassian.jira.issue.search.providers.LuceneSearchProvider.getPermissionsFilter(LuceneSearchProvider.java:373)
	at com.atlassian.jira.issue.search.providers.LuceneSearchProvider.getHits(LuceneSearchProvider.java:185)
	at com.atlassian.jira.issue.search.providers.LuceneSearchProvider.search(LuceneSearchProvider.java:279)
	at com.atlassian.jira.issue.search.providers.LuceneSearchProvider.search(LuceneSearchProvider.java:91)
	at com.atlassian.jira.issue.search.providers.LuceneSearchProvider.search(LuceneSearchProvider.java:87)
	at com.atlassian.jira.issue.search.providers.DualSearchProvider.lambda$search$0(DualSearchProvider.java:78)
	at com.atlassian.jira.issue.search.providers.DualSearchProvider.performSearch(DualSearchProvider.java:140)
	at com.atlassian.jira.issue.search.providers.DualSearchProvider.search(DualSearchProvider.java:78)
	at sun.reflect.GeneratedMethodAccessor485.invoke(Unknown Source)
	at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:43)
	at java.lang.reflect.Method.invoke(Method.java:498)
	at com.atlassian.plugin.util.ContextClassLoaderSettingInvocationHandler.invoke(ContextClassLoaderSettingInvocationHandler.java:26)
	at com.sun.proxy.$Proxy98.search(Unknown Source)
	at sun.reflect.GeneratedMethodAccessor485.invoke(Unknown Source)
	at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:43)
	at java.lang.reflect.Method.invoke(Method.java:498)
	at org.springframework.aop.support.AopUtils.invokeJoinpointUsingReflection(AopUtils.java:317)
	at org.eclipse.gemini.blueprint.service.importer.support.internal.aop.ServiceInvoker.doInvoke(ServiceInvoker.java:56)
	at org.eclipse.gemini.blueprint.service.importer.support.internal.aop.ServiceInvoker.invoke(ServiceInvoker.java:60)
	at org.springframework.aop.framework.ReflectiveMethodInvocation.proceed(ReflectiveMethodInvocation.java:179)
	at org.springframework.aop.support.DelegatingIntroductionInterceptor.doProceed(DelegatingIntroductionInterceptor.java:133)
	at org.springframework.aop.support.DelegatingIntroductionInterceptor.invoke(DelegatingIntroductionInterceptor.java:121)
	at org.springframework.aop.framework.ReflectiveMethodInvocation.proceed(ReflectiveMethodInvocation.java:179)
	at org.eclipse.gemini.blueprint.service.util.internal.aop.ServiceTCCLInterceptor.invokeUnprivileged(ServiceTCCLInterceptor.java:70)
	at org.eclipse.gemini.blueprint.service.util.internal.aop.ServiceTCCLInterceptor.invoke(ServiceTCCLInterceptor.java:53)
	at org.springframework.aop.framework.ReflectiveMethodInvocation.proceed(ReflectiveMethodInvocation.java:179)
	at org.eclipse.gemini.blueprint.service.importer.support.LocalBundleContextAdvice.invoke(LocalBundleContextAdvice.java:57)
	at org.springframework.aop.framework.ReflectiveMethodInvocation.proceed(ReflectiveMethodInvocation.java:179)
	at org.springframework.aop.support.DelegatingIntroductionInterceptor.doProceed(DelegatingIntroductionInterceptor.java:133)
	at org.springframework.aop.support.DelegatingIntroductionInterceptor.invoke(DelegatingIntroductionInterceptor.java:121)
	at org.springframework.aop.framework.ReflectiveMethodInvocation.proceed(ReflectiveMethodInvocation.java:179)
	at org.springframework.aop.framework.JdkDynamicAopProxy.invoke(JdkDynamicAopProxy.java:207)
	at com.sun.proxy.$Proxy1202.search(Unknown Source)
	at com.atlassian.jira.plugins.importer.imports.importer.impl.customfields.CFValueHandlerEpicLink.findSingleIssueOrNull(CFValueHandlerEpicLink.java:112)
	at com.atlassian.jira.plugins.importer.imports.importer.impl.customfields.CFValueHandlerEpicLink.prepareCustomFieldValue(CFValueHandlerEpicLink.java:54)
	at com.atlassian.jira.plugins.importer.imports.importer.impl.customfields.CustomFieldValueFactory.prepareRawValueForCustomField(CustomFieldValueFactory.java:69)
	at com.atlassian.jira.plugins.importer.imports.importer.impl.customfields.CustomFieldValueFactory.prepareValueForCustomField(CustomFieldValueFactory.java:53)
	at com.atlassian.jira.plugins.importer.imports.importer.impl.customfields.CustomFieldsUtil.setCustomFieldValueForIssue(CustomFieldsUtil.java:202)
	at com.atlassian.jira.plugins.importer.imports.importer.impl.DefaultJiraDataImporter.importExternalCustomFields(DefaultJiraDataImporter.java:1305)
	at com.atlassian.jira.plugins.importer.imports.importer.impl.DefaultJiraDataImporter.createIssue(DefaultJiraDataImporter.java:922)
	at com.atlassian.jira.plugins.importer.imports.importer.impl.DefaultJiraDataImporter.importIssues(DefaultJiraDataImporter.java:798)
	at com.atlassian.jira.plugins.importer.imports.importer.impl.DefaultJiraDataImporter.doImport(DefaultJiraDataImporter.java:414)
	at com.atlassian.jira.plugins.importer.imports.importer.impl.ImporterCallable.call(ImporterCallable.java:26)
	at com.atlassian.jira.plugins.importer.imports.importer.impl.ImporterCallable.call(ImporterCallable.java:15)
	at com.atlassian.jira.task.TaskManagerImpl$TaskCallableDecorator.call(TaskManagerImpl.java:453)
	at com.atlassian.jira.task.TaskManagerImpl$TaskCallableDecorator.call(TaskManagerImpl.java:421)
	at java.util.concurrent.FutureTask.run(FutureTask.java:266)
	at java.util.concurrent.Executors$RunnableAdapter.call(Executors.java:511)
	at java.util.concurrent.FutureTask.run(FutureTask.java:266)
	at com.atlassian.jira.task.ForkedThreadExecutor$ForkedRunnableDecorator.run(ForkedThreadExecutor.java:216)
	at java.lang.Thread.run(Thread.java:745)
2016-05-25 16:40:33,736 INFO - Importing issue: [externalId='autoid-3986760313411359137', summary='DT Go Live|Additional Feeds|ACT UCV|']

Vitaliy Zapolsk

what works for me:

Issue Type,Key      ,Epic Name,Summary        ,Epic Link

Epic      ,<span>AAA-1    ,</span>  my-epic,Build a car    ,

Story&nbsp;&nbsp;&nbsp;&nbsp; ,AAA-2<span>&nbsp; &nbsp; ,</span>&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; ,Build an engine, &nbsp;<span>AAA-1</span>

Story&nbsp;&nbsp;&nbsp;&nbsp; ,AAA-3<span>&nbsp; &nbsp; ,</span>&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; ,Buy some tires , &nbsp;<span>AAA-1</span>

Appears that Epics import routine is kind of smart, see the last comment here:

https://ecosystem.atlassian.net/browse/JIM-1269

Perhaps topic starter's troubles were related to https://confluence.atlassian.com/jirakb/cannot-import-epic-link-from-csv-due-to-incorrect-format-829030416.html

Filip Pokorny

That is interesting, your example doesn't work anymore. Instead of the issue id (Key field in your example), Epic Name must be present like this:

Epic&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; ,<span>AAA-1 &nbsp; &nbsp;,</span>&nbsp; my-epic,Build a car&nbsp;&nbsp;&nbsp; ,<br>Story&nbsp;&nbsp;&nbsp;&nbsp; ,AAA-2<span>&nbsp; &nbsp; ,</span>&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; ,Build an engine, &nbsp;my-epic<span><br></span>Story&nbsp;&nbsp;&nbsp;&nbsp; ,AAA-3<span>&nbsp; &nbsp; ,</span>&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; ,Buy some tires , &nbsp;my-epicIssue Type,Key &nbsp; &nbsp; &nbsp;,Epic Name,Summary&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; ,Epic Link<br>

I'll have to search and replace all epic ID's linked to epic names linked by every story in the exported CSV. It's time for some regular expressions I guess.

Heath Dutton

Did this work? I have 3k issues that got imported without links to epics and need a solution.

Filip Pokorny

my version worked for me

mark hardwick_8ahvh3

the above doesn't work for me.
The epics are created, the stories are created, but the stories are not associated with the epics.

Filip Pokorny

What Jira version do you use and what importer? There are 2 (one for global admin, one for project admin)

Ruediger Beck

Jira Server v7.13.2

For me it just has worked in the way, that I've used in the Epic-link column of the User Story the exact 'summary' content of the Epic.

James G.

I'm working in Next Gen now, but previously worked in the older version. The process I used to use to import and link issues to an epic no longer works. The cards are created, but are not linked to the specified epic.

I have tried using the steps listed in the post dated May 31, 2018, but they imported issues were not linked to an epic. I"m also not seeing "epic link" as an option in the import tool's mapping page. Any advice?

Christine Meli

I am experiencing same issue. I have been unsuccessful trying to import stories into an existing epic.

unknown

I'm having the same issues as well. Exceptionally frustrating.

RossH

Epic Link is not an option in the importer for me.

Edit: Fixed - Wasn't in the screen config.

peter.casey

Using Jira Cloud with Nex Gen project also seems to have no mapping to do this.

Trying to use the 'Parent ID' field to import issues with Type = Story throws error (see WARN in bold)

2020-01-09 01:10:55,915 INFO - Importer started!
2020-01-09 01:10:55,927 INFO - Engine is running in Import mode
2020-01-09 01:10:56,137 INFO - All issues will be imported to project: Viz One Upgrade 2019 (VOU)
2020-01-09 01:10:56,166 WARN - Issue 'Build an engine' doesn't have Subtask Issue Type, its Parent Id mapping will be ignored.
2020-01-09 01:10:56,174 INFO - Creating issue: [externalId='autoid--4590135095131978080', summary='Build an engine']
2020-01-09 01:10:56,523 INFO - Issue created successfully with Key [VOU-59], [externalId='autoid--4590135095131978080', summary='Build an engine']
2020-01-09 01:10:56,531 WARN - Issue 'Buy some tires' doesn't have Subtask Issue Type, its Parent Id mapping will be ignored.
2020-01-09 01:10:56,538 INFO - Creating issue: [externalId='autoid--178713755243894322', summary='Buy some tires']
2020-01-09 01:10:56,730 INFO - Issue created successfully with Key [VOU-60], [externalId='autoid--178713755243894322', summary='Buy some tires']

mfabris

This seems to be pretty actual still in 2020, especially with the new functionalities of cloud and the next-gen projects.

We had the same problem with next-gen projects on JIRA and found a solution that seems to work.

The step by step solution would be:

1. Export the data in CSV from the project you want to export (choose "all fields")

2. Open the CSV and add two columns; call the columns "Epic Name" and "Epic Link"

3. Optional: if your stories have sub tasks, filter by the column "Issue Type" and deselect all the sub-tasks in your CSV file.

4. Copy the values for the entire column "Issue Id" into the column "Epic Name"

5. Copy the values for the "Parent Id" column into the column "Epic Link"

6. Save your CSV. Have a look at which separator you have (if it is "," or ";" for example)

7. Start the import. Make sure you choose the right separator. Map all relevant fields. Important: map "Issue Type" field to itself. Make sure you map "Epic Link" and "Epic Name" to themselves.

I hope this helps somebody, let us know if you find any flaw!

Brant Witzel

I just wanted to add a couple of details to Mirco's answer for those using JIRA Cloud:

1.) Ensure your Epics are listed before anything that links to them in the CSV file... i.e, put them at the top of the file (under the field names).

2.) Ensure the target project was set up as a Classic project (not a Next-Gen). As of 1/31/2020, Next-Gen projects do not import Epics correctly in my experience.

3) The values in "Epic Name" should be the same as the values from "Summary" for your Epics. Epic Name values are only valid for Epics. Your Tasks should have blank Epic Name values.

4) For all of your Tasks that should be linked to an Epic, put the value of the linked Epic's Epic Name in the Task's Epic Link column.

Example CSV file (spaces added for visual alignment only):

Issue Type,Summary        ,Epic Link  ,Epic Name
Epic      ,Build a car    ,           ,Build a car
Story     ,Build an engine,Build a car,
Story     ,Buy some tires ,Build a car,

The end result of your import will look like this (in a Kanban board):

Annotation 2020-01-31 143600.png

Claus Schneider (eficode)

I have seen this issue with "permissions" and "null" on Server 7.3.4 and json importer. Snippet from above

2016-05-25 16:40:33,554 WARN - Cannot add value [ [Additional Feeds] ] to CustomField Epic Link in Issue with summary 'DT Go Live|Additional Feeds|ACT Spatial|'. Exception Message: null
java.lang.NullPointerException
 at com.atlassian.jira.issue.search.parameters.lucene.DefaultPermissionQueryFactory.collectProjectTerms(DefaultPermissionQueryFactory.java:133)
 at

The root cause was this issue:
https://confluence.atlassian.com/jirakb/blank-page-displayed-when-loading-permission-scheme-configuration-in-jira-server-297670208.html

The project permission scheme was "None" for some reason.

I tried to "save" it but the first option, but did not succeed. I could delete the project as it was test imports, so it was easy to fix that way. Not forced to go for second option of manipulating the database.

Benoit_6lqhxf

Because Parent ID work only for Subtask type.

mladen_miljic

Same here: next gen project, importing Stories/ Tasks does not support linking them to an EPIC. I have to do it manually? Really?

On top of that, adding a Task to an EPIC is a click-nightmare it itself. One need to change the dialog for that, means it loads another page.

Crazy....

Roland Di Gregorio_mi8k0g

The import functionality works properly only for Classic Projects and not for Next Gen-Projects.

my workaround:
1.) import to classic projects

---example with link Tasks to Epic and Sub-Tasks to Tasks----

issue type;epic name;epic link;issue ID;parent id;summary;description;assignee;due date;status;reporter
epic;Holiday;;1;;Holiday;;test@mail.ch;26.11.2020;to do;test@mail.ch
Task;;Holiday;2;;Organize fly;;test@mail.ch;21.11.2020;to do;test@mail.ch
Task;;Holiday;3;;Packing;;test@mail.ch;22.11.2020;to do;test@mail.ch
sub-task;;;4;2;Check rates;go to website ;test@mail.ch;23.11.2020;to do;test@mail.ch
sub-task;;;5;2;Book;confirm;test@mail.ch;24.11.2020;in progress;test@mail.ch
-----

2.) convert (with multiple selection) all issues to Next Gen-project

peter.casey

Yeah; I figured this out eventually.

Found a workaround of importing as Tasks or Stories, then selecting and demoting (move) all imported to sub-tasks. At this point Jira Nexgen asks what parent you'd like and you can choose the relevant Story.

Benoit_6lqhxf

This is what I use: import Excel example.png Very convenient. I create a template where a lots of numbering is done automatically. I can give that to the product owner to plan his projet. Soon I will integrate standard components to allow synchronisation across multiple project for specific department.

Benoit_6lqhxf

As you can notice, I do have advanced roadmap. Very useful when you want to plan at business level.

Rosa M Fossi

Hi @Roland Di Gregorio Do you map all the fields? Epic Name and Epic Link

Screen Shot 2020-11-01 at 7.59.49 PM.png

Vladimir Abramov

Hi @Roland Di Gregorio Thank you for the help. I realised that my file was pipe separated due to a local system setting.

I am now having an issue in loading the hierarchy of EPIC - Feature - Story - Task. I required for them all to be linked to each other. Is there a a basic structure you can recommend to bulk load the hierarchy?

I currently use the Epic Link for Features and Issue ID and Parent ID for Stories and Tasks and structure to link tem all together but received error on validation that Issue/Parent ID is only for sub tasks.

How do I create a linked hierarchy above. This is what it looks like below:

Current Epic,Feature,Story,Task link Structure.PNG

Benoit_6lqhxf

You can look at my reply done on the Oct 19 2020.

You have your answer there.

Parent ID is used only for Sub-task

Rosa M Fossi

Hi Vlad, glad Roland was able to assist with the delimiter issue, were you able to sort out what Benoit referenced? If it helps, here's a screenshot (I colored the cells for this example so you can see the relationship)

Michael Thaney

Can you link a bug to user story during the import?

Benoit_6lqhxf

link are supported. use the same link name.

Ranjit Nair

This import mechanism continues to work only for Classic projects and not for Next-Gen projects in Jira Cloud. However there is a workaround for that.

Create a temporary classic project and import using the CSV template described by Mirco.
Create a next-gen project.
Use the "Bulk change" action under Filters --> Advanced issue search. You'll find the action when you click on the three dots on the top right part of the page.
Run through the wizard to map the issue types and move the Epics and Stories to the Next-Gen project.
Delete the temporary Classic project.

It's convoluted but it works.

J L_qt5wl9

For anyone still struggling with this in 2021, it has to be a 'company managed project' not a 'team managed project'.

Vishal Vashishta_qmrg9w

Where we define or select what type of project we are going to create, Next Gen or Classic.

I do not find any such prompt

Vineela Sharma

I used below format and it works. Custom field (Epic Name) and Epic Link play main role here.

Go to your Jira --> Issues --> Import Issues from CSV --> Choose your CSV Source file --> Choose 'Import to Project' --> Map fields as shown below --> Proceed for Next

NOTE: Before creating Epics/Stories always safe to 'Validate Import' to avoid rework if the issues are created in error.

Hope this helps

Welcome!

It looks like you're new here. Sign in or register to get started.

Quick Links

Find more posts tagged with

csv

jira

import

task

issue-link

epic

sub-task

story