Knowledge article map and creation of connected contents

[Apaul]

I have a requirement

Excel sheet consists of knowledge article number short description, taxonomy topics

Knowledge articles are already present in kb_knoledge table

Need to create connected contents for each and every knowledge article who are in published state so that they can be visible on employee center portal. Short descriptions of those articles should be updated based on excel sheet.

[tiagomacul]

HI @Apaul 

I haven’t worked on this exact requirement before, but here’s the approach I’d take:

---

🔹 Scenario

• Excel contains → Article Number, Short Description, Taxonomy Topics

• Knowledge Articles already exist in kb_knowledge (published state)

• Requirement →

  1. Update Short Descriptions based on Excel

  2. Create taxonomy mappings so the articles show up in Employee Center

---

🔹 Step 1: Load the Excel Data

• Create a Data Source from the Excel file.

• Build a Transform Map to either:

  • Directly target kb_knowledge, or

  • Load into a staging table first (recommended for more control/validation).

👉 Key mapping: match Excel Article Number → kb_knowledge.number.

---

🔹 Step 2: Update Short Descriptions

Use a Transform Script to update the short_description:

(function transformEntry(source, target, map, log, isUpdate) { if (isUpdate && source.u_short_description) { target.short_description = source.u_short_description; } })(source, target, map, log, action);

⚠️ If you have multiple language versions, update the appropriate localized field (e.g., kb_knowledge.language).

---

✅ This way, articles keep their updated descriptions, and the taxonomy connections drive visibility in Employee Center.

✅ Best Practices

• Run this first in sub-production with a sample Excel before importing all records.

• Keep a backup/export of kb_knowledge in case you need to revert.

• If the Excel is updated regularly, consider a Scheduled Data Import instead of one-off loads.

Loading::. CMDB Computers: Carregando Computadores na CMDB do ServiceNow

[kaushal_snow]

Hi @Apaul ,

To complete your requirement of updating short descriptions and creating connected content for published knowledge articles in ServiceNow based on an Excel sheet, follow these steps:

1. Prepare the Excel Sheet

Ensure your Excel sheet includes the following columns:

Knowledge Article Number: The unique identifier for each article.

Short Description: The updated short description for each article.

Taxonomy Topics: The topics to which the article should be connected.

2. Update Short Descriptions

To update the short descriptions for published knowledge articles:

Navigate to: Knowledge > Articles > All.

Filter: Set the filter to display only published articles.

>> Import Data:

Right click on the list header and select Import....Click on Create Excel Template to generate a template.

Populate the template with the data from your Excel sheet.

Upload the populated template back into ServiceNow and complete the import process....This method allows for bulk updating of short descriptions.

3. Create Connected Content

To associate knowledge articles with taxonomy topics:

Navigate to: Content Taxonomy > Connected Content.

Create New Records:

For each article, create a new connected content record.

Set the Content Type to Knowledge Article.

Select the appropriate Knowledge Article and Taxonomy Topic.

This process links each article to the specified topics, making them visible on the Employee Center portal.

If you found my response helpful, please mark it as ‘Accept as Solution’ and ‘Helpful’. This helps other community members find the right answer more easily and supports the community.

[kaushal_snow]

Hi @Apaul ,

To complete your requirement of updating short descriptions and creating connected content for published knowledge articles in ServiceNow based on an Excel sheet, follow these steps:

1. Prepare the Excel Sheet

Ensure your Excel sheet includes the following columns:

Knowledge Article Number: The unique identifier for each article.

Short Description: The updated short description for each article.

Taxonomy Topics: The topics to which the article should be connected.

2. Update Short Descriptions

To update the short descriptions for published knowledge articles:

Navigate to: Knowledge > Articles > All.

Filter: Set the filter to display only published articles.

>> Import Data:

Right click on the list header and select Import....Click on Create Excel Template to generate a template.

Populate the template with the data from your Excel sheet.

Upload the populated template back into ServiceNow and complete the import process....This method allows for bulk updating of short descriptions.

3. Create Connected Content

To associate knowledge articles with taxonomy topics:

Navigate to: Content Taxonomy > Connected Content.

Create New Records:

For each article, create a new connected content record.

Set the Content Type to Knowledge Article.

Select the appropriate Knowledge Article and Taxonomy Topic.

This process links each article to the specified topics, making them visible on the Employee Center portal.

If you found my response helpful, please mark it as ‘Accept as Solution’ and ‘Helpful’. This helps other community members find the right answer more easily and supports the community.

[Apaul]

Hi @evveryone

Sorry I posted the wrong requirement, i misinterpreted it.. 🙂

But thanks for your reply and help.