Copying categories in Redmine

It looks that many people want to see the option to copy to categories of parent project into sub project. So far, it is not a default feature of Redmine. If you have so many projects and categories to write them manually, you can write once and use the SQL command below to copy them.

The table issue_categories in Redmine keeps the records of categories of the projects, you just need to copy one project to new project.

INSERT INTO
  issue_categories(
    project_id,
    name,
    description)
  SELECT
    71,
    name,
    description
  FROM
    issue_categories
  WHERE
    project_id = 61;

Here 61 is the ID of the projects that I copy from and 71 is the new project that I want to copy categories to.

Advertisements
This entry was posted in Redmine and tagged , , . Bookmark the permalink.

Leave a Reply

Fill in your details below or click an icon to log in:

WordPress.com Logo

You are commenting using your WordPress.com account. Log Out / Change )

Twitter picture

You are commenting using your Twitter account. Log Out / Change )

Facebook photo

You are commenting using your Facebook account. Log Out / Change )

Google+ photo

You are commenting using your Google+ account. Log Out / Change )

Connecting to %s