KB categories importing by using Transform map

[Arun91]

Hi Team,

  We are trying to load the knowledge base category in servicenow by using transform map. Record is getting created in ServiceNow but the parent id is empty. Could anyone please help me resolve the issue.

[incrypto]

Hi Arun91, I unfortunately don't have an answer for you, but am leaving this reply because I'm having the same issue. The new kb_category records are getting created, but all of the parent id's are empty.

[Di Zhang]

Hi Arun91 , you should load the parent id and parent table in same time. 

Firstly load the 1st tier of kb_categrory.   parent id is kb sys_id and table is Knowledge Base [kb_knowledge_base]. After 1st tier completed, then use the sys_id of 1st tier kb_categrory as parent id and parent table is Knowledge Category [kb_category].

...

[TejaSriPaP]

Hello Arun91 did you find the solution?

[ICaTonyBalde]

Hello,
Your Excel file should include two columns:

• Parent ID: Fill this with the sys_id of the Knowledge Base (or parent category) you want the category assigned to.

• Parent Table: Fill this with the table name, such as kb_knowledge_base (for linking to a knowledge base) or kb_category (for linking to another category).

Both fields are required because the Parent ID in the kb_category table is a Document ID type, which needs both the table name and the sys_id to establish the relationship.
If you only provide the sys_id without the table name, the parent relationship will not be set and the field will remain empty

Example:

 

Label	Parent Table	Parent ID (sys_id)
Subcategory 1	kb_knowledge_base	sys_id_of_knowledge_base
Subcategory 2	kb_category	sys_id_of_parent_category

Make sure your transform map is set up to map both columns to the corresponding fields in the kb_category table.