How to mass update knowledge base categories in SNow?

[VarunArulmani]

Hi All,

We have recently moved all our knowledge base documents from a shared drive to ServiceNow Knowledge base. We created separate knowledge bases for each of the teams. Initially we had no categories for the individual teams. But now, all the teams have come up with categories and sub-categories.

For example, DBA Team have come up with Categories 1) Oracle 2) Sybase 2) Microsoft SQL

And each of the Categories will have sub categories 1) Daily procedures 2) BCP documents 3) Server restarts

There are over 1400 documents and we cannot go and update the categories for each of the document. Is there a way to mass upload the category-> sub-category names for all the documents if i have the details in a csv file.

I tried to create a transform map and matched the kb_number to automatically update the category and sub-category. But, the category field is referenced from knowledge_category table. So, i am not able to reference the category with a transform map.

Any help is greatly appreciated.

[Pradeep Sharma]

Hi Varun,

Refer "Choice action" to handle choice related fields.

http://wiki.servicenow.com/index.php?title=Creating_New_Transform_Maps#gsc.tab=0

[VarunArulmani]

Thanks Pradeep.

[Chuck Tomasi · Accepted solution]

Hi Varun,

Have you tried list editing? You can click-select (drag) to highlight and change multiple records at once.

Editing Lists - ServiceNow Wiki

[VarunArulmani]

Thanks Chuck.