import existing user and issues from Excel CSV file

JIRA creates in every case new user, when i try to import existing user and issues from an Excel CSV file. There is a column "assignee" with in JIRA existing user id s, but the import tool ignores this id s and creates new user.

6 answers

Which version of JIRA are you using? It cannot create two users with the same username. Can you paste a screenshot of the users list as an example?

here the required information:

Jira Version 5.0.6

Jira Build-Nummer 733 -

Standardsprache Deutsch (Deutschland) - Standardeinstellungen

Java-Version 1.6.0_26

Database driver MySQL-AB JDBC Driver mysql-connector-java-5.1.10


The Jira importer creates a new user account based on the Jira id awill, which was provided in the csv file:

CSV utf8 coded:

issue key,Assignee,typ, ....


and in the attached screen , you can see, that it was named: <strong> comes from the import wizard, but where he gets the full lastname "Brandt"? This is really confusing.

0 vote
Thomas Schlegel Community Champion Oct 24, 2012

Maybe you have a column "reporter" with the other name ?

here is the original header. It s german. The translation is below.



issue typ, short description, description,create date, comment, assignee, status, priority, due date,solution text, version, solution

Reporter is not listet.

0 vote
Thomas Schlegel Community Champion Oct 24, 2012

maybe there' something wrong with the Setup Field Mappings ? Check, which csv-Columns are mapped to user-fields.

ok, i found the problem. the first import was done with the users full name and jira created these strange new id s. ok, this was a user error. as we found out, that we have to use the jira internal user id s to import stuff from the csv file, we didn t delete these old crap id s. this was the reason, that jira didn t import the correct id format later on.

Suggest an answer

Log in or Join to answer
Community showcase
Sarah Schuster
Posted Jan 29, 2018 in Jira

What are common themes you've seen across successful & failed Jira Software implementations?

Hey everyone! My name is Sarah Schuster, and I'm a Customer Success Manager in Atlassian specializing in Jira Software Cloud. Over the next few weeks I will be posting discussion topics (8 total) to ...

3,308 views 14 20
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
Atlassian Team Tour

Join us on the Team Tour

We're bringing product updates and pro tips on teamwork to ten cities around the world.

Save your spot