How we can edit Space Categories in Confluence?

[Avdhesh Chauhan]

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.

[NotTheRealStephenSifersNOPENOPENOPENOPE · Accepted solution]

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]

[Avdhesh Chauhan]

thanks Stephen!!

[Martin Gregory]

What about cloud instances?

[Leticia]

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.

1. Know that there are TWO edit buttons (crazy, I know)
2. The main edit button will NOT do what you what
3. You need the edit button that is next to the category name. Click that one.
4. 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.
5. Add your new label/category by typing the name of it into the box and clicking Add.
6. Remove the previous label/category by clicking the little (x) next to it under labels
7. Voila! You're done.

Hopefully this helps you! :)

[Martin Gregory]

OMG!   Labels are space categories.     And you create a new one by editing an existing space.  

Who'd have thunk?

Thanks!

[Chris Shaffer]

This is no longer accurate. Labels and categories are distinctly separate. And there doesn't seem to be a way to add categories in Confluence cloud.

[zaphnet]

Also not available in Confluence REST API?

[Manu Dewan]

I guess there's no way to do a mass change to labels/ categories in Confluence cloud?

[Martin Gregory]

(nice if there was a delete answer here eh?)

[Avdhesh Chauhan]

thanks stephen!!