Create
cancel
Showing results for 
Search instead for 
Did you mean: 
Sign up Log in

Next challenges

Recent achievements

  • Global
  • Personal

Recognition

  • Give kudos
  • Received
  • Given

Leaderboard

  • Global

Trophy case

Kudos (beta program)

Kudos logo

You've been invited into the Kudos (beta program) private group. Chat with others in the program, or give feedback to Atlassian.

View group

It's not the same without you

Join the community to find out what other Atlassian users are discussing, debating and creating.

Atlassian Community Hero Image Collage

Importing Epics and stories using csv and external system import option Edited

I've seen several posting about this, but none ever seem to have a definitive 'this is the way to do it', so I apologize for asking again.

I have an existing project and I have a csv of issues from another project(created from xml export on other system) that I want to import into this project. I have 2 questions:

1) how to I need to set up my columns to import epics and the stories that belong to them. They both will reside in the csv, they are not already in the project i'm importing into. I have tried 3 different ways based on other posts, and neither work:

a) I tried mapping my issue id column in the csv to issue id in jira and then putting the Epic's issue id in the epic link column of the stories belong to that epic

ID  summary Epic Name Epic Link

1    parent     MyEpic

2    story1                            1

3    story2                            1

b) I tried using Epic name as the link vs the id

ID  summary Epic Name Epic Link

1    parent     MyEpic

2    story1                            MyEpic

3    story2                            MyEpic

 

c) Also tried using issue key name

Issue key  ID  summary Epic Name Epic Link

    ISSUE-1 1    parent     MyEpic

    ISSUE-2 2    story1                            ISSUE-1

    ISSUE-3 3    story2                            ISSUE-1

Can someone help me out in clarifying how you do this?

 

2) My csv will have issue ids in it. Since I have existing issues in my project, do I run the risk of messing up issue ids of existing issues, or does jira assign new ones to issues being imported. What about when I'm using issue id to connect task/subtask or epic/story, could I link to the wrong issue if the id already exists on another issue?

 

Thanks for any help!

Jay

 

3 answers

2 accepted

0 votes
Answer accepted

Hi Jay,

You can import Epics from CSV and then provide values using Epic Name. Then in Stories later in the CSV use an Epic Link column with the name of the Epic that the Story should be part of.

Check out the following Community post that gives a breakdown and example on how to do this:

Let me know if you have any additional questions.

Regards,
Earl

0 votes
Answer accepted

Hi Earl,

I found my problem yesterday I believe. It seems that the ordering of the rows in the csv is crucial, I needed to have the epic before any of its members(my csv had different ordering than what i had in my post. I also found the mention of duplicate story names and cleaned that up as well. I can now import epics and stories all in one csv file.

Thanks!

Hi Jay, 

Thanks for the update and Good catch.

To shed some additional light on why this is occuring, the CSV is doing a sequential line by line issue creation during the import.  The Epic link is linking the child story to the parent Epic when the child issue is created so the parent must exist for the child issue to know what issue it is linking to otherwise it would be attempting to insert a NULL value to the epic link field and error out.

Regards,
Earl

Like peter.casey likes this

Hi

 

On this note, can you have the same Epic Name in different CSV files, I am uploading several CSV files into the same Project.

 

Regards

 

Jeanette

Suggest an answer

Log in or Sign up to answer
TAGS

Community Events

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

Find an event

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

Unfortunately there are no Community Events near you at the moment.

Host an event

You're one step closer to meeting fellow Atlassian users at your local event. Learn more about Community Events

Events near you