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, ....
TR-33,awill,bug,...

*********************************************************

and in the attached screen , you can see, that it was named: <strong>awillbrandt@example.com.

Example.com 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.

Typ,Kategorie,Zusammenfassung,Beschreibung,Erstellt,Kommentare,Bearbeiter,Status,priorität,

Fälligkeitsdatum,Lösungstext,VERSION,Lösung

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 Sign up to answer
How to earn badges on the Atlassian Community

How to earn badges on the Atlassian Community

Badges are a great way to show off community activity, whether you’re a newbie or a Champion.

Learn more
Community showcase
Published yesterday in Jira

Mission-critical battery manufacturer fulfills FAA software requirements with Commit Policy Plugin

EaglePicher Technologies is a leading manufacturer of battery systems for diverse industries like defense, aviation, space or medical. As they operate in highly regulated industries, keeping a clear ...

131 views 0 2
Read article

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