how to import published knowledge articles

himabindu_b02
Kilo Contributor

I am trying to import knowledge articles from excel sheet which are in published state. When I import through transform map or direct import method, the articles are imported in to "Draft" state. Any different approach or idea in order to import published articles. Thanks in advance.

1 ACCEPTED SOLUTION

madanm7786
Mega Guru

There is an OOB Business rule which will set the state to "Draft" during insertion.


Please un check Run Business rule check box in your transform map and load the data.



Thanks,


Madan


View solution in original post

3 REPLIES 3

Community Alums
Not applicable

Hi Minabindu,



have wrote any script in transform map while updating the State ? If not just try to do with script. and also try to put logs to track errors or warning if you are gettign any. And also check is there any business rule in Knowledge table making default state values as default. And let me know if you are getting any errors or warnings.


madanm7786
Mega Guru

There is an OOB Business rule which will set the state to "Draft" during insertion.


Please un check Run Business rule check box in your transform map and load the data.



Thanks,


Madan


Bruno De Graeve
ServiceNow Employee
ServiceNow Employee

You can add a field map on the Target Field "Workflow";


In my case, articles had to published if they belonged to a certain category:



answer = (function transformEntry(source) {


// Add your code here


if (source.u_category == "website" || source.u_category == "solution"){


return "published"; // return the value to be put into the target field


}


})(source);



In case you have a system with multiple UI langauges, specify the langage field or your articles will not be searchable.


Bruno De Graeve,
Principal Platform Architect, Customer Success, ServiceNow