Need to rename group

I October 18, 2012

We need to rename groups. We need the workaround to do this whether it be a plugin or the SQL statements to perform this as some of these groups have 100+ users. Recreating these are not an option due to the large user memberships involved.

4 answers

1 accepted

1 vote
Answer accepted
I November 4, 2012

You must do this via SQL as it cannot be accomplished within Confluence.

First, backup your SQL database. Then run this simple modification to the cwd_group.

Just modify the group_name field to whatever you would like the group named

The SQL statement to run is as follows:

Update cwd_group set group_name='<new_group_name>', lower_group_name='<new_group_name>' where lower_group_name='<old_group_name>';

Andreas
Rising Star
Rising Star
Rising Stars are recognized for providing high-quality answers to other users. Rising Stars receive a certificate of achievement and are on the path to becoming Community Leaders.
May 10, 2017

Be aware that this only renames the group itself. 

Membership does not get transferd this way. The group will be empty.

Like Jose Carmona likes this
3 votes
SimonS
Rising Star
Rising Star
Rising Stars are recognized for providing high-quality answers to other users. Rising Stars receive a certificate of achievement and are on the path to becoming Community Leaders.
October 18, 2012

Hey there,

There are some workarounds described in the "rename groups" feature request:

https://jira.atlassian.com/browse/JRA-1391

Be sure to back up your data before you try any script or database workaround.

Please vote for and comment on the feature request as well so we can get this thing prioritized.

-Simon

1 vote
Deleted user January 22, 2015

I have a groovy (Script Runner) script that will accomplish this, with a little manual intervention. Please see comment dated January 22 at https://jira.atlassian.com/browse/JRA-1391 and attached files.

Lacey McDonnell March 17, 2017

I might be stupid but how on earth do I get this to work??

0 votes
Mark Ziesemer November 30, 2015

Not sure what product this was submitted for. JIRA is mentioned below with an associated ticket (JRA-1391). Confluence is being tracked at https://jira.atlassian.com/browse/CONF-13571 .

Suggest an answer

Log in or Sign up to answer