How can i merge (or at least manage) users between jira and confluence

We have been using confluence and jira for a while now but it has recently been decided that users should be managed from a central place (eg jira as a user provider, or crowd). The problem is: someone had the bright idea to allocate usernames in the format "John Smith" in confluence and "j.smith" in jira.

Now when we try to use jira as the provider john gets 2 user accounts in confluence. He could just start using the new j.smith account, but then his personal space and posts nolonger belong to him. How can i get around this problem?

I have also just installed a trial version of crowd to see if this sorts out my problems (it would also offer SSO). But at first look this seems to cause the same problems.

2 answers

1 accepted

This widget could not be displayed.

Hi Yakobe,

Changing usernames in the system is currently not supported. We do have some workarounds for this though. Please first perform this in a test environment to make sure that your production data does not get corrupted.

The following page explains how to rename users in Confluence: https://confluence.atlassian.com/display/DOC/Changing+Usernames

Based through some SQL queries.

An additional option would be to generate a XML backup of your system. Then unzip the generated zip file and open the "entities.xml" file in a text editor.

Perform a search on the username. You will find entries like these:

<![CDATA[bas-test]]>

In this case I want to rename the user "bas-test" to "admin".
I performed a replace on all entries which have bas-test and renamed this to admin.

Once done re-zip all the files and perform a xml import. Now the usernames should be changed.
Both options (SQL and XML) require a lot of manual actions and will be time consuming.

As a side note I need to point out that these changes are not supported by Atlassian support.

The xml solutions actually sounds like it could be one of the easier solutions. Just to check that i have understood: Do I only have to change the one entities.xml file? And do i just perform a search and replace on every username that i want to change in the file or only the values within those CDATA entries?

This widget could not be displayed.

You need to rename one of the sets of users.

Both JIRA and Confluence don't support it officially but there are SQL scripts etc.. around (search for rename JIra and Confluence users)

Alternatively, in JIRA, try out the groovy script runner plugin. It has the ability to rename users in JIRA.

Once you have both Confluence and JIRA users matching by name, then you can direct Confluence to use JIRA as its source for users and you should be ok.

Also, should mention Yakobe, that we at AppFusions have various SQL scripts for both JIRA and Confluence that may work for you if you want to contact us direct. We don't have every variant but depending on your product version and DBMS we might have some tested ones that would work

hi colin. Thanks for your answer. Are these SQL scripts you mention freely available or paid solutions?

Yakobe -

No they are not freely available since not really plug and go, given environment deltas/specifics at a minimum among other complexities in a merge effort. At least we have not productized yet - its tricky.

Colin's been working on these as part of a very large and hairy merge effort of 2 JIRAs and 2 Confluences, as the result of a corporate acquisition (client company)

If interested in some help, shoot us a mail at info@appfusions.com and we can help you -

System merges are not for the feign of heart, for sure. Tricky business!

Suggest an answer

Log in or Sign up to answer
Community showcase
Posted Monday in Confluence

Why start from scratch? Introducing four new templates for Confluence Cloud

Hi my Community friends!  For those who don't know me, I'm a product marketer on the Confluence Cloud team - nice to meet you! For those of you who do, you know that I've been all up in your Co...

466 views 6 6
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