Community
Q&A
Confluence
Questions
How we can edit Space Categories in Confluence?

How we can edit Space Categories in Confluence?

Hi All,

We are having lots of spcaes created in confluence, and we have categories so each space in to some category for our convenience, Now we want to edit a particular Space Category , can anybody please let us know how we can Edit the Confluence Category becouse removing the existing one and adding the new one is very painful as we have assosiated 100+ spaces with that category.

is there any simple way to do this.

5 answers

1 accepted

Comments for this post are closed

Community moderators have prevented the ability to post new answers.

0 votes

Answer accepted

Your labels for your space(s) are stored within your database. A simple method would be to change the display names within the labels. This will only work if you are on premisis with confluence.

Prior to doing anything within the database ensure you have a good backup. Please do the follow with caution. If you dont have a full understanding of what you are doing then do not proceed.

Run the following within SQL will display all of your used labels.

SELECT *
  FROM [YOURDB].[dbo].[LABEL]

To adjust the names just run a SQL replace to adjust all labels to the new name you wish to give them. Once the names have been replaced restart confluence.

SQL Replace usage:
http://msdn.microsoft.com/en-us/library/ms186862.aspx

SELECT REPLACE (NAME, 'OldName', 'NewName')
FROM [YOURDB].[dbo].[LABEL]

You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.

Comment

thanks Stephen!!

You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.

Comment

What about cloud instances?

You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.

Comment

3 votes

I came here looking for the same answer as Martin. The reason is because the Atlassian help files seem to be getting progressively more out of date, and, therefore, less useful.

If you came here looking for how to edit categories in a cloud instance, here's what to do.

Know that there are TWO edit buttons (crazy, I know)
The main edit button will NOT do what you what
You need the edit button that is next to the category name. Click that one.
You'll get to a screen that asks you to add a label (I know, the terminology is awful). But in Confluence, a label and a category are the same thing.
Add your new label/category by typing the name of it into the box and clicking Add.
Remove the previous label/category by clicking the little (x) next to it under labels
Voila! You're done.

Hopefully this helps you! :)