User Tools

Site Tools


siam_sharepoint

Perspectium SIAM for Sharepoint

(Importing Microsoft Sharepoint 365 Articles to ServiceNow Knowledge Articles)

since v3.18

This integration imports entire Microsoft Sharepoint 365 sites and its sub-sites, lists, and pages to create ServiceNow Knowledge Base articles. This integration allows you to continuously update your ServiceNow Knowledge base with content from Microsoft Sharepoint 365 in a scheduled manner so that articles that are created or updated will be updated in ServiceNow in an automated fashion. This allows the enterprise IT and its self service customers to search and comment on articles within the ServiceNow Knowledge Base that are created in Microsoft Sharepoint.

The following is an architectural diagram of the integration.

This integration is currently one direction from Sharepoint to ServiceNow

Supported Versions

  • ServiceNow: Geneva, Helsinki, Istanbul
  • Sharepoint 365 2013

Installation

Please request installation download links from support@perspectium.com. For more information on installing or updating the update sets, visit the first time install or updating pages.

The update sets should be requested installed in this order:

  1. Perspectium for ServiceNow
  2. Perspectium Common Knowledge
  3. Perspectium SIAM for Sharepoint

Once all three update sets have been installed the Perspectium app in the ServiceNow menu should show the Sharepoint SIAM module.

Configuration

Service Provisioning

Contact support@perspectium.com requesting provisioning of this integration. You will be asked the ServiceNow instance name for the service configuration. In return, you will be given links via email to download the required update sets.

If you have been previously provisioned for other Perspectium products please let support know at this time.

Properties

If you have previously installed Perspectium products, you would have already provisioned default properties for connectivity and can skip step 1. If you have previously provisioned Replicator previously, you should skip step 2.

  1. Sharepoint Properties
  2. Shared/Subscribe Queues (depends on service destination)
Sharepoint Properties

  • The default knowledge base is used for all newly created knowledge articles from an import. After updating the knowledge article to your knowledge base, this value will not be changed by the import on subsequent runs.
  • Next, the base URL property to your sharepoint site so that incoming articles will be updated to have absolute URLs pointing to your Sharepoint site
  • Following this are the credentials needed for a REST service login at your Sharepoint site for the integration
Shared/Subscribe Queues

You do not need to configure Shared/Subscribe Queues if your Sharepoint integration service is on the default endpoint that you have already configured. Perspectium support will let you know.

If you have been provisioned for a other Perspectium service, you may be required to create separate Share/Subscribe queues if your other services do not reside on the same endpoint. Perspectium support will be aware and provide you with the necessary credentials to create these configurations at the time of provisioning.

Follow the instructions on creating shared queues and enter the endpoint and credentials given to you, you should have an entry that is similar to the following.

Similarly, follow the instructions to create subscribe queues, and enter the credentials given to you, you should have something similar to the following.

Usage

The Sharepoint integration takes advantage of Sharepoint's “Site”, 'List“, and “Pages” hierarchy. The integration will discover and import your Sharepoint Sites, their Sub-Sites, and corresponding Lists so that you can select and activate only the Sites and Lists you wish to import from. The following is a screenshot of the installed application in ServiceNow.

The following are the steps to get your Sharepoint hierarchy imported and configured to import your knowledge articles.

  1. Configure Properties
  2. Select “Discover sites and lists” and wait for the sites to be discovered and populated (this can take up to a minute)
  3. Select “Sharepoint Sites” and drill down to specific sub-site or directly to a List
  4. Double click and activate the “Import articles” field on the list
  5. At this point you may wish to select the “Import now” UI action on the List or select the “Import articles from all active lists” UI action on the Site

Each action you select produces a Topic=siam, Type=sharepoint message in the Outbound messages table of Replicator. Responses from the integration service will appear in the Inbound messages table with the same Topic and Type. Error messages will appear in the Inbound message table as well if they occurred at the service endpoint.

Default Knowledge Base

When discovering sites, the default knowledge base set in the Properties page will be used.

By design, the default is “Sharepoint Imports” which is a new knowledge base that is installed part of the update set. Knowledge authors should look in this knowledge base to reassign to the appropriate knowledge base after an import has occurred or if a scheduled import has run.

You may also change this property to another default knowledge base if you want all new imports to be assigned to this one.

Default Knowledge Category

After a discovery of the Sharepoint site and sub-sites, site records such as the following will be created under the “Sharepoint sites” module.

The “Assign Category” field would be blank on creation. Select the category (from kb_category table) that you would want subsequent imports of this site to automatically assign the category to the articles. By default if left blank, will not overwrite any imported articles that have been manually categorized.

List Types

Perspectium Replicator for Sharepoint supports importing Sharepoint articles of type Item and FAQ. For example, on a discovered Sharepoint List entry, select the Source of FAQ if you know the list you have in Sharepoint is an FAQ list.

Inbound Maps

The Inbound Maps module actually refer to an Import Set Transform Map which describes the field mappings from common_knowledge to kb_knowledge table. The default coalesce is on topic and description fields which are mapped from the Sharepoint Site name which can contain the main site and its sub-site e.g. /mainsite/sub-site/ and the article title together.

The inbound updates will ignore updating the kb_knowledge_base and short_description fields on subsequent updates. The rest of the fields in the map will copy over unless its blank, because “Copy empty fields” option is false by default.

CSS Styles

Often times, you want to apply CSS styles from your Sharepoint site on your newly created knowledge articles. You can do so by by creating a new Content Management → Style Sheets entry and linking to it in the System UI → UI Pages → kb_view UI page.

You can download your Sharepoint style by accessing it using the following URL

https://[your tenant site].sharepoint.com/_layouts/15/1033/styles/Themable/corev15.css

Copy the content of the CSS page and create a new Style Sheet record. Next, copy the sys_id of the newly created Style Sheet entry and use it to paste the following HTML

<link href="[the sys_id of your Sharepoint Style Sheet].cssdbx" rel="stylesheet" type="text/css"/>

Paste it into the top part of the kb_view (or kb_view_customer in Knowlegde V3) UI page like this:

When you view your knowledge article next time, you will be able to see your Sharepoint styles being applied.

The Sharepoint CSS you have added this way will actually be applied to all articles, whether or not it was imported from Sharepoint.

siam_sharepoint.txt · Last modified: 2017/06/28 16:28 by dloo