Bulk move many topics from one category to another

[tobiaseigen]

Is there a query to bulk move many topics from one category to another? I want to consolidate many categories into one category and would like to make the move quickly and all at once, and also not bump the topics.

Bonus: also want to tag topics first with a category-equivalent tag before moving them.

Grateful for any queries or recipes. Many thanks! I’d even write it up as a howto topic if it’s good.

[tshenry (Taylor)]

I’ve gone ahead and cleaned up this topic and have added the current best options for solving the questions in the OP. If there’s anything missing or if you notice and issues, please feel free to respond.

Take backup before you make major bulk changes just in case…

Bulk tag/move topics through the UI:

For small categories, or subsets of topics, the bulk selection tool may be enough (see note at the end of this posts on notifications).

Move all topics from one category to another

First enter your site’s container:

cd /var/discourse
./launcher enter app

@tshenry

Find the category IDs with the following rake task:

rake categories:list

The first value should be the starting category ID. The second value should be the destination category ID.

rake categories:move_topics[15,6]

---

Bulk Tag All Topics Within a Category:

First enter your site’s container:

cd /var/discourse
./launcher enter app

@tshenry

Template: rake tags:bulk_tag_category["<tag>|<tag>",<category_id>]
This would be particularly useful when trying to convert a category to a tag.

First, use the following rake task to find the relevant category ID.

rake categories:list

Tag all topics of the category you specify. In this example, you would be tagging all topics in the category with an ID of 6 with the “support” tag. this will remove all other tags from each topic.

rake tags:bulk_tag_category["support",6]

Append all topics of the category you specify. In this example, you would be adding the “support” tag to all topics in the category with an ID of 6, while keeping existing tags.

rake tags:bulk_tag_category["support",6,true]

---

I’m not 100% sure what types of notifications if any these methods trigger, but if you are concerned and want to be absolutely sure that notifications aren’t sent out, I would recommend checking the following settings while working on this:

• disable_category_edit_notifications
• disable_tags_edit_notifications

[Thien_Nguyen_Ngoc]

@tshenry you just saved my day! Thank you so muchhhh