Skip to main content

Build and Map Information Base Categories from CWM(board-Type-SubType-Item

Summary​

This script will create information base categories (ticket categories) for every imported manage board.

Time Saved by Automation: 60 Minutes

Sample Run​

Sample Run

Dependencies​

The CW Manage Plugin Setup and Service Board import must be completed.

User Parameters​

NameExampleRequiredDescription
I have backed up the dbYESTrueConfirm MySQL DB backup has been done

Process​

The script executes several SQL queries.

  1. Generates a list of the insert statements based on the CW Service boards & Type / Subtype / Items.
  2. Executes the insert statements to create new Information Base Categories.
  3. Maps those new info base categories in the CW Manage plugin tables.

Output​

There is no script output. Please reload the cache and view the info base categories in the system dashboard. Review the CW Manage plugin Ticket category area.

Changelog​

2025-04-10​

  • Initial version of the document