Can the Epic>Story>Sub-task relationship be successfully imported into Greenhopper with a CSV file?

Hi,

I am trying to import an Excel spreadsheet of requirements into Greenhopper.

The import process runs successfully but when I check the scrum board, the Stories aren't linked with their Epics. Instead I see a field in Story called 'Epic/Theme' with the parent Epic name as a label.

Can the Epic > Story > Sub-task relationship be successufully imported into Greenhopper/Jira with a CSV file?

Here's the CSV file content:

Description,Summary,Issue Id,Parent Id,IssueType,Story Points,Epic,Component,Component,Component,Component,Component,Component,FixVersion,FixVersion,FixVersion,OriginalEstimate (s),Reporter
Description1,Epic1,,,Epic,,,component1,component2,component3,,,,0.1,,,,reporterName
Description2,Story1 for Epic1,101,,Story,1,Epic1,component1,component2,component3,,,,0.1,,,,reporterName
Description3,Sub-task1 for story1,,101,Sub-task,,Epic1,component1,component2,,,,,0.1,,,14400,reporterName
Description4,Sub-task2 for story1,,101,Sub-task,,Epic1,,,component3,,,,0.1,,,28800,reporterName
Description5,Sub-task3 for story1,,101,Sub-task,,Epic1,component1,component2,component3,,,,0.1,,,14400,reporterName

3 answers

1 accepted

Epic story relation is using something called as system link (it's a normal issue link, but hidden). I am not sure if you can import it via CSV. The Epic/Theme field is used by Classic modes and not used by the new boards of GH.

You have some alternatives to use REST to create issues and also link to stories. You need to be comfortable with a bit of scripting though

https://answers.atlassian.com/questions/115733/how-to-attribute-issue-to-epic-via-api

Support has answered this:

Hi David,

Sorry mate for taking some time investigating this.

In order to link the stories to their Epics, you will need to link the Epic value to Epic Link field which is going yo map the links from the Story-->Epic.

However, this is not possible, because Epic Link field is not available under CSV importer fields mapping which makes it impossible to have this link via CSV import.

I have raised this feature request to enable this feature. In the mean time, the only way is to manually drag and drop these stories to the parent Epic.

Please let us know if you have any other questions.

Cheers,
Omar

FYI -- it is now possible to import the EPIC LINK using the ISSUE KEY (ISSUE-234) of the EPIC in JIRA's CSV Import.

Hi, Can you please provide some details on how to do it. I am quite new to Jira and need to add Users Stories to Existing Epics in Jira.

Yes, it is possible. Please see an example on how to do it below:

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

Suggest an answer

Log in or Sign up to answer
Atlassian Community Anniversary

Happy Anniversary, Atlassian Community!

This community is celebrating its one-year anniversary and Atlassian co-founder Mike Cannon-Brookes has all the feels.

Read more
Community showcase
Posted 7 hours ago in Jira

We want to know what Jira Service Desk apps you're using!

Hi Community! My name is Amir and I’m on the Jira Service Desk product marketing team at Atlassian. Our team would love to understand how you’re leveraging our ecosystem for Jira Service Desk. Wha...

25 views 0 4
Join discussion

Atlassian User Groups

Connect with like-minded Atlassian users at free events near you!

Find a group

Connect with like-minded Atlassian users at free events near you!

Find my local user group

Unfortunately there are no AUG chapters near you at the moment.

Start an AUG

You're one step closer to meeting fellow Atlassian users at your local meet up. Learn more about AUGs

Groups near you