Errors Importing Knowledge Articles XLSX

TStark · ‎05-30-2024

I'm running into some issues while importing (Easy Import) articles into a knowledge base.

The scenario: I have about 2k articles that I need to import into one instance from another instance. Right now cloning isn't an option. I made sure to download the import template from my source instance's kb knowledge table list view to capture all the articles I need for the import. When I start the import (on the target instance) the source instance's xlsx file I receive the following errors. I've tried both Insert and Update.

- Sys ID (unique record identifier) is invalid. The row will be skipped unless the value is corrected.

- Multiple records for Category exists in

TStark · ‎06-03-2024

I was able to import the articles into the target instance by exporting the articles via XML in tranches from the source instance. My initial attempt was importing all 2k articles as one XML export which was over 1GB and increasing the XML import size limit didn't work as expected. This is why I tried the Easy Import of an XLSX file. which produced the errors as described in my original post.

View solution in original post

AJ63 · ‎05-30-2024

Hi @TStark

This might be because of same SYSID in your current instance v/s what you are importing, if at all you are importing SYSID as well.

Pls help with more details in case i missed.

Thanks!--AJ

TStark · ‎05-30-2024

I tried removing the sysID column from the xlsx file. That's when I received the "Multiple records for Category exists in " error.

AJ63 · ‎05-30-2024

@TStark is there BR or Data Policy which might be causing this to check and throw an error?

TStark · ‎05-30-2024

We have no BRs or Policies, other than what's OOB, related to importing or KBs/articles.