I want to change all confluence users email address from our old company name to new company name?
Is there a way we can replace each users email with the new email address and have that account maintain their documents and content?
It depends on what type of user directory you are using and your username format.
Is it the internal Confluence directory? Is the user name format a simple "login" and not their email (e.g. when logging in, I'd enter "nic" in the username box, not "email@example.com")
Ok, good. There's several ways to do this, but it's better to look at what needs doing before talking methods.
The change you need to make is relatively simple. There is a table in the database called cwd_user. This holds (amongst other stuff), the login id, the data that connects a user to a thing in Jira, and an email address. As you only want to change the email address, there's no problem with losing connections to other things - the email has nothing to do with how users are linked to pages/spaces/permissions/etc
I would personally do it the safer way - whack in script runner and write a little bit of one-off code to go through the user directory and replace addresses as appropriate.
But SQL is probably quicker and cheaper. If, for example, you have an email format of firstname.lastname@example.org and the update is as simple as changing it to email@example.com, then a simple search and replace through the two email columns will do it. Make sure Confluence is offline before doing this otherwise it might cache some of the old emails.
@Bryan Thomas have you checked that the users email address is does not update when the user logs into the application?
With our Single Sign-on add-on attributes are updated automatically when the user logs in.
The user mark.miller has an email address firstname.lastname@example.org in JIRA and in Okta.
His email address is then changed to email@example.com in Okta.
The next time he logs into JIRA his email address is automatically changed to firstname.lastname@example.org
A requirement for this is (obviously) that the email address is sent as a attribute statement (Name: email, Value user.email)
Lars, Kantega Single Sign-on
Do you use templates with Confluence? Take part in a remote 1-hr workshop. You'll receive USD $100 for your time! We're looking for people to participate in a remote 1-hr workshop...
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!
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