Importing knowledge article through excel sheet.

Pradeepa Boopat
Tera Contributor

How we can attach doc, pdf, csv in excel sheet for importing Knowledge article?

3 REPLIES 3

Ratnakar7
Mega Sage
Mega Sage

Hi @Pradeepa Boopat ,

 

To import Knowledge articles with attachments from an Excel sheet, you need to use ServiceNow's Import Set Table functionality

 

Please refer similar community thread : https://www.servicenow.com/community/now-platform-forum/knowledge-article-excel-bulk-import-template...

 

Thanks,

Ratnakar

Pradeepa Boopat
Tera Contributor

Hi @Ratnakar7 ,

Can you please help me on, How to import Knowledge article from Remedy to ServiceNow?

What are the details I need to ask with Clients?

Client having 3000Knowledge Articles, I need to import KA through Excel sheet.

In Excel sheet, How to capture Article body?

Can you please help me with steps?

Hi @Pradeepa Boopat ,

 

Sure, here are the steps you can follow to import Knowledge Articles from BMC Remedy to ServiceNow:

  1. Export the Knowledge Articles from BMC Remedy: You will need to work with the client to obtain an export of their Knowledge Articles from BMC Remedy. This may involve coordinating with their BMC Remedy administrator or support team to generate an export file in a compatible format.

  2. Prepare the import data in an Excel sheet: Create a new Excel sheet and prepare the import data for ServiceNow. You will need to ensure that the columns in your sheet match the fields in the ServiceNow Knowledge Article table.

  3. Map the fields from BMC Remedy to ServiceNow: You will need to work with the client to understand the mapping of fields from BMC Remedy to ServiceNow. This may involve identifying equivalent fields in ServiceNow or creating custom fields in ServiceNow to accommodate data that is not currently captured.

  4. Import the Knowledge Articles: Once you have prepared the import data and mapped the fields, you can import the Knowledge Articles into ServiceNow. You can use the ServiceNow Import Sets feature to load data from Excel files into ServiceNow tables.

Regarding capturing the article body in the Excel sheet, you can use a "text" field to capture the article body. However, if the body contains special characters or formatting, you may need to handle these in a specific way to ensure they are properly imported into ServiceNow.

Ratnakar7_0-1683802207832.png

 

 You can download Excel Template with below steps:

-->> Navigate to kb_knowledge list view (Knowledge -> All) and right click on column header, then select "Import" option:

Ratnakar7_2-1683803427825.png

-->> Click on "Create Excel Template" button:

 

Ratnakar7_4-1683803659156.png

-->>Click on download button

Ratnakar7_5-1683803695063.png

 

Thanks,

Ratnakar