Preserve issue numbers from data migration?

I am doing some investigation on data migration and do not see what happens when a project's data has been imported. The CSV file contains a column with existing IDs for the issues. Do those IDs get preserved in JIRA, or do they get mapped to another number. If so, how do I know what the new numbers are? I would like to then go back and import attachments and comments associated with these issues in a second third pass. If I only have the original numbers, how can I do this?


4 answers


Most of answers here do not take into consideration newest features available as of JIRA Importers Plugin (JIM) version 4.3.

1. Preserving issue key. JIM can create for you while importing from CVS an issue with the exact issue key you specified in CSV. Just define which column from your CSV file is mapped to Issue Key.

2. JIM can update already existing issues (if an issue pointed to by the mapped Issue Key column already exists) and thus you can easily add comments and attachments to existing issues in multiple passes.



Very good point, the more recent versions of the importer are a lot more flexible, if you are on a Jira that supportes them.

0 votes

If you use project restore, those ids will be preserved. This will wipe out all existing data in the project though.

If you import from CSV, they won't. And there won't be any mapping to the previous ids.

this isn't good. I have an unknown number of attachments and comments for a given issue. I have to put them in along with the rest of the issue information because I can't map the ids (old to new JIRA id number)? This is going to be extremely difficult!

Migrations aren't fun :(. If you do some scripting with the JIRA Command Line Interface you can create issues in order. If there is a gap in the issue key number, create a dummy issue and delete it. It makes it easy to handle attachments and perserver commit messages. Here is my Migration story.

0 votes

For CSV, Jira will create issues with IDs as though a user had typed them in one at a time. e.g. if your project has ABC-123 as the latest issue, and you import items from CSV, line 1 will be ABC-124, line 2 will be ABC-125 and so-on. The id in the file can be imported like any other custom field, but won't be used as the Jira key. If you plan carefully, you can set up the project so that it starts at the right number and then use dummy padding lines in the file, as Bob says.

Suggest an answer

Log in or Sign up to answer
Community showcase
Posted yesterday in Canada

Happy New Year - First AUG of the year - great success

Hi Everyone, Hope everyone had a great holiday season and is ready for an exciting 2019.  We had our first AUG last night featuring Tempo Timesheets.  A great presentation and lots of int...

21 views 0 2
View post

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