We're trying to import a project from Trac to JIRA.

In the guide it says the following:


  • Usernames— If you don't specify mapping, the importer will automatically map Trac usernames to JIRA usernames (lowercase).
    (info)Regardless of whether you specify mapping, JIRA will automatically create usernames for missing users.

However, there is no opportunity for me to ever make such a mapping? Is the documentation incorrect or am I missing something?

I definantly don't want these duplicate users in JIRA that I cannot delete... Since you cannot change the user that made a comment like you can for assignee. Which in turn makes it impossible to delete these duplicate users without deleting all the comments.

2 answers

I solved this myself, not by using any JIRA features. But instead I used this script: https://trac-hacks.org/wiki/RenameUsersScriptand ran it on the trac SQLite database file to rename the users to the JIRA ones.

This then worked great when importing the Trac project in JIRA.

Just make sure you backup your Trac database before running the script.

Good find on the RenameUsersScript!

I wrote another PHP script that will update your trac.db ticket_change records replacing the trac-style changeset repository links to a format acceptable by JIRA. Our user story and sample SQL commands to rename users prior to import is also included at the bottom of the script in comments.



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

2,777 views 11 18
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