Can we update existing Article's fields using Import Set

crizler
Tera Contributor

I'm adding criteria to " Can Read " and " Cannot Read " fields. So I was planning to load a xlsx file into kb_knowledge because :

  • the volume of articles that needs to be updated are high
  •  some articles are need to be created 

 

Issue :

  • When I tried to load the records(in my PDI), It just creating new article instead of updating the existing articles.(cosindering KB number as Coalesce)
  • Can Read & Cannot Read - outcome value are being cutted like it has a character limit, then it resulted as creating new criteria when one record has been cutted 

 

Outcome:

crizler_3-1699360180180.png

Loaded File:

crizler_1-1699360047395.png

 

 

 

 

Question:

  1. Is it possible to update exisiting record in kb_knowledge using import set? or it will always create a new record.
  2. is it possible to break the character limit in the glide list record field during import set ?

 

1 REPLY 1

Aniket Bhanse
Tera Guru

@crizler 

For your first question,

You can create a new Column in your Excel sheet (which you are importing via import set) and consider that as the Unique identifier (Coalesce). And create a field on the knowledge record which will be a free text field and populate the value in that field. So when you will import your data, rather than checking on the knowledge Number field, check for Coalesce on the free text field which you have newly created. 

This should work.

 

Let me know if this helps you.