Knowledge article upload via import set

[Rajshekhar Pau1]

We need to upload knowledge articles via import set and transform map. The category field on a KA has different parent and child sub-category. However, same sub-category may be valid within different parent categories e.g. "Infrastructure — Database" and "Security — Database".

Now, the thing is, when I am uploading the data through import set from a spreadsheet by transform map, how will I define this category column in the spreadsheet to exactly map the child category to its parent category for respective articles?

This is a sample spreadsheet example:

Any help would be grateful.

saruppaul, ctomasi- I would humbly request your kind suggestions or advice on this

Thank you.

[Chuck Tomasi]

Hi,

I'm afraid I don't understand the question. The process of mapping fields is pretty straight forward in the transform map. If you have "Database" under Topic Software and also under Infrastructure on the instance already, the transform map is just going to take what is in the spreadsheet and import it. If the names match, the values in the choice list, then it's matched. No big deal. Have you tried this yet on a small subset of records?

[Rajshekhar Pau1]

Hi Chuck,

Thanks for your kind reply.

I have tried with a small number of records in our sand box instance but didn't work out.

The thing is, a same sub-category may be valid within different main categories e.g. "Infrastructure — Database" and "Security — Database".

The question is, how we will feed in a sub category in the Excel Template Column CATEGORY to address that.

E.g. what value will be filled in our template column "CATEGORY" for below example sub-category: "SharePoint"?

I have to insist in this especially because we cannot ignore that the same sub-category may be valid within different main categories e.g. "Infrastructure — Database" and "Security — Database"

How do we need to express that in the Excel template?

Kind Regards,

Rajshekhar Paul

[Chuck Tomasi]

Somewhere in Excel, you need to define the parent category. The system cannot magically map the Database subcategory to one of the parent categories without direction.

[Rajshekhar Pau1]

Hi Chuck,

This is where I am stumbling over. I am not getting a way around to define that parent categories in the excel sheet and map it on the knowledge table.

Not to confuse, as the Category on Knowledge table is a field from kb_category table and as also the Parent ID belong to the kb_category table, I am not finding a solution to map it from the excel file to the Knowledge table via transform map.

Would you mind, if I ask for a suggestion on defining the parent category in the excel sheet and how to map the same into the knowledge table?