Importing knowledge article through excel sheet.
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
‎05-08-2023 11:48 PM
How we can attach doc, pdf, csv in excel sheet for importing Knowledge article?
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
‎05-09-2023 08:41 AM
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
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
‎05-11-2023 12:31 AM
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?
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
‎05-11-2023 04:15 AM
Hi @Pradeepa Boopat ,
Sure, here are the steps you can follow to import Knowledge Articles from BMC Remedy to ServiceNow:
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.
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.
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.
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.
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:
-->> Click on "Create Excel Template" button:
-->>Click on download button
Thanks,
Ratnakar