import existing user and issues from Excel CSV file

Deleted user Oct 24, 2012

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?

0 votes
Deleted user Oct 24, 2012

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 votes
Thomas Schlegel Community Champion Oct 24, 2012

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

0 votes
Deleted user Oct 24, 2012

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 votes
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.

0 votes
Deleted user Oct 24, 2012

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
Published Nov 27, 2018 in Portfolio for Jira

Introducing a new planning experience in Portfolio for Jira (Server/DC)

In the past, Portfolio for Jira required a high degree of detail–foresight that was unrealistic for many businesses to   have–in   order to produce a reliable long-term roadmap. We're tur...

2,947 views 19 22
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