Import content into Pega Knowledge from an external source such as a legacy content system or a translation services vendor by using a pre-defined CSV file template. You can also update existing content using this file template.

Note the following restrictions about the import process:

• You can only import content using the standard CSV file format.
• You cannot import file attachments. If an article has attachments, manually add the attachments after the import.
• You cannot import embedded images in articles. If the image is a link to an external repository, the link will be imported.

To import or update content, download the CSV file template from the Knowledge portal, populate the file by mapping the data columns in the file to your Pega Knowledge content structure, and then import the file.

This section contains the following topics:

• Downloading the CSV file
• Populating the CSV file
• Adding additional data attributes to the CSV file
• Importing the CSV file
• Viewing the import results

Download the CSV file from the Pega Knowledge portal and populate it with information about the content that you want to import or update.

1. Log in to Pega Knowledge portal.
2. In the left navigation pane, click Knowledge > Content.
3. Click the Import Content tab, and then click Import.
4. In the Import content window, click Download Template.

The CSV file template contains columns that represent the data that you map to your Pega Knowledge content data structure. Each row and column represents an article. If the data columns do not match your existing data structure, you can update the template by adding additional data columns. For more information, see Adding additional data attributes to the CSV file later in this section.

The following figure shows an example of the CSV file template:

Pega Knowledge uses the Content ID column to import or update content, based on the following rules:

• When importing content, if you do not provide the content ID in the CSV file, Pega Knowledge creates a new content ID for the article.
• When updating content, if you provide the content ID in the CSV file, the new content replaces the existing content that matches that ID.

The following table lists and describes the data columns in the CSV file, and indicates whether that data is required when updating or importing content in Pega Knowledge.

If the CSV file has data columns that do not match your existing data structure, you can add data attributes to the CSV file that represent your existing data structure.

1. Define the additional attributes that you want to add to the CSV file as properties of the PegaFW-KM-Data-ImportContent class.
2. Map the newly created properties to the existing properties of the PegaFW-KM-Work-Content class or hierarchy:
   • If you are importing new content, map the properties using the PrepareImportedContentWorkPage data transform.
   • If you are updating existing content, map the properties using the KMUpdateContent activity.
3. Add the new properties you created as column names in the CSV file.
4. Upload the updated CSV file in the KMImportContentDetails binary file rule.
5. To set the updated CSV file as the new pre-defined template, edit the KMImportContentDetails binary file rule, and then upload the updated CSV file in the rule. Pega Knowledge users can now download the updated file template.

After populating the CSV file, perform the following steps to import the file. This process imports the new content or updates the existing content in the Pega Knowledge portal.

1. Log in to the Pega Knowledge portal.
2. In the left navigation pane, click Knowledge > Content.
3. Click the Import Content tab, and then click Import. The Import content window appears.
4. Click Choose file, and then select the CSV file to import.
5. Click Import.
6. On the Web Options dialog box, click the Encoding tab.
7. In the Save this document as: field, select Unicode (UTF-8).
8. Click OK.
   The imported content moves to the Knowledge Content - Imported workbasket. Pega Knowledge generates a Content ID for each new article.

   Only successful imports are moved to the Knowledge Content - Imported Workbasket. If errors occur while importing the CSV file, error messages that describe the failure are displayed on the resulting Import page.

After importing content, you can view the results of the import process in the Import content tab. This page shows successful and failed imports, and includes the row numbers, generated IDs, and comments (error messages) of the imported rows. The following example shows the result of the import process.

You can open an article by clicking the ID number or navigating to the Knowledge Content – Imported workbasket. The content displayed in this workbasket is in the New-Draft stage, which allows you to continue editing, approving, and publishing the content according to the standard Pega Knowledge authoring flow.

Note the following:

• When updating content, the ContentID that you provided in the CSV file is automatically populated in the Knowledge Content - Imported workbasket with the Pending- Publish status. You can navigate to the workbasket and edit the content as needed.
• You cannot update content that has a KC-xx ID and a status of Withdrawn, Archived or Rejected.