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

This widget could not be displayed.

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?

This widget could not be displayed.

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.


This widget could not be displayed.
Thomas Schlegel Community Champion Oct 24, 2012

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

This widget could not be displayed.

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.

This widget could not be displayed.
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.

This widget could not be displayed.

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
Community showcase
Posted Tuesday in Jira

What modern development practices are at the heart of how your team delivers software?

Hey Community mates! Claire here from the Software Product Marketing team. We all know software development changes rapidly, and it's often tough to keep up. But from our research, we've found the h...

185 views 1 3
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