HTML text in Knowledge Article Bulk Import

[Alex Ng]

Hi all,

I am currently doing a bulk import of knowledge articles in HTML format via the Import functionality on record list view. I noticed that it can import with a breeze. However, since my text are in HTML format, I have to go into every single imported article, cut the text out and then click on the <<Source code>> button and paste back my text into it in order for my HTML text to take format.

Else, my articles will all be shown with plain text with HTML tags.

Does anyone has a workaround for this?

Thank you.

[ganapatihegde]

Hello All,

I have the similar requirement. I need to load around 700 articles. And the formatting of the "Text" is very important for me.

I have multiple lines in all knowledge Text.

Example:

-go to here...

-click on something...

it will be a space

-download from the site.

So above is just an example. When i load with csv file it take it just as a simple paragraph...Could one of you please let me know how I can achieve this so that articles will be loaded exactly as it is in the excel file.

This is very crucial for me

Your response would be much appreciated..

Regards

Ganapati

[Rohit Kumar]

Convert excel file into the html format.

Now using Transform maps import the html content into the html field of the articles.

Thanks

Rohit

[Mike Moody]

Hi Alex,

I wrote a bulk KB import console application in C# .Net that will recursively import all .docx files in a targeted local directory structure into the ServiceNow KB Submissions table. It uses the save as HTML file mechanism built into Microsoft Word to convert to HTML, cleans up styling, and uploads images as well. It's not perfect, but it's pretty effective. Feel free to try it out: GitHub - mmoody1977/BulkSNKB

Requires Windows OS and Microsoft Word. It does leave a dedicated images folder and the converted HTML file behind in the targeted directory for each document.

Usage Information:

C:\ >BulkKBUpload.exe /? Bulk uploads all .docx Word documents in a targeted folder, as an HTML based KB Article, to the kb_submission table on a Service Now instance.

BulkKBUpload folderpath [/U:username] [/P:password] [/I:instance]

folderpath The complete path to the folder containing the documents to convert and upload. /U:username The Service Now username that has permissions to create kb_submission records. /P:password The password for the supplied username. /I:instance The Service Now instance hostname. Example: myinstance.service-now.com

Example usage: BulkKBUpload "C:\Docs" /U:mmoody /P:p@ssw0rd! /I:moodydev.service-now.com