How to mass update knowledge base categories in SNow?

VarunArulmani
Mega Expert

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.

1 ACCEPTED SOLUTION

Chuck Tomasi
Tera Patron

Hi Varun,



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



Editing Lists - ServiceNow Wiki


View solution in original post

5 REPLIES 5

ericcrawford
ServiceNow Employee
ServiceNow Employee

The only way that they can mass edit these would be using the list view “Update Selected” or "Update All" list feature that would allow them to change multiple articles at once without republishing.  The category is marked read only on the record view so you would need to check out and republish the articles in order to change the category. The Update All/Update Selected feature will allow this update to happen without republishing.