Regarding updating field on knowledge article

[Minal_Pingale]

Urgent!!

Hi , I want to update the knowledge article category and other fields of published articles. Challenge is that there are 700+ articles and values to be updated are also different. I was trying to achieve this with the transform map adding transform script in it but some how it is updating record with all the versions of the article where I only want published one to be updated how can I achieve this?

[KrishnaMohan]

Hi @Minal_Pingale 

Why you trying with transform maps, are you importing/ updating based on external data like excel,csv..? if not you can use fix script (async background server script)

Regards,
Krishnamohan

[Minal_Pingale]

Hi @KrishnaMohan.

Yes I have Excel file. It has 700+ records to update also there is a condition that only published records to be updated and if that record is already updated in between our development work then don't overwrite it

[Rafael Batistot]

Hi @Minal_Pingale 

May you try use Import Set + Transform Map

1. Export your knowledge articles (sys_id, number, category, etc.) into Excel/CSV.
2. Add columns with the new values you want (e.g., New Category, New Owner, etc.).
3. Load this file into a staging table using Import Set.
4. Build a Transform Map → target kb_knowledge table.
5. Use sys_id as the coalesce field (so it updates instead of inserting).
6. Run the transform → this will bulk update all 700+ records.

[Minal_Pingale]

Ok let me try