How to bulk update KB article valid to dates to specific dates

[Khalnayak]

HI there,

I have been tasked to update the valid to date of over 1000 KBs.

I have a spreadsheet containing the columns of current valid to date and new valid to date.

What script do I need to run to update each KB with it's unique new valid to date.

As each KB will have different valid to date,  I can't simply set the same date for all of them.

Please help.

[Ankur Bawiskar · Accepted solution]

Hi Usmaan,

Please create data source and transform map for this on knowledge table

Map the new valid to date from excel to the target field of Valid to date.

Create a transform map

Data sources

Regards
Ankur

[Alberto Consonn]

Hi Usmaan,

please use the script of the solution below:

https://community.servicenow.com/community?id=community_question&sys_id=bff387e5dbd8dbc01dcaf3231f96...

If I have answered your question, please mark my response as correct and/or helpful.

Thank you very much

Cheers
Alberto

[Khalnayak]

Hi Alberto, the script in the link is not the solution to my problem.

I came across that link before and it was not suitable for me.

thank you though.

[Ankur Bawiskar]

Hi Usmaan,

please use the data source and transform map approach.

Links for help are already shared above

Regards
Ankur