Optimizely Connect for SharePoint
Describes Optimizely Connect for SharePoint, which provides a transparent connection between Optimizely Content Management System (CMS) and Microsoft SharePoint.
The connector copies documents, blocks, or other items from SharePoint document libraries and lists these automatically.
Updates can be scheduled or managed manually, and are available in CMS as media or blocks. Additionally, developers can manipulate documents or blocks as they are being transferred, to customize applications to specific requirements in CMS.
Requirements
- Contact customer support to request a license
- A SharePoint license
- SharePoint versions 2013, 2016, 2019, or SharePoint Online
- An Optimizely Content Management System (CMS) installation
- See Add-ons platform compatibility for package and version information
- See User guide: Optimizely Connect for Sharepoint
Install
- Versions 7.5 and higher are installed through NuGet
- Lower versions are available as zip files for download
About the installation
The Optimizely Sharepoint connector is installed as a NuGet package.
When you install the SharePoint NuGet package, a third-party dependency adds the following entry in web.config, but because the entry is already in web.config, it causes a duplicate name error. You can fix the duplicate name error by changing the name of ExtensionlessUrlHandler-Integrated-4.0 to something else.
<add name="ExtensionlessUrlHandler-Integrated-4.0"
path="."
verb=""
type="System.Web.Handlers.TransferRequestHandler"
preCondition="integratedMode,runtimeVersionv4.0" />
About ISharepointProcessor
The ISharePointProcessor interface lets you implement a class to override or enhance the way that Optimizely processes SharePoint objects. For example, you want to add a prefix to filenames as you copy the SharePoint files to the Optimizely CMS, or filter specific file types from being copied to the Optimizely CMS, or you want to notify a user after the files are copied.
ISharePointProcessor interface
The ISharePointProcessor interface has the following methods:
- AddDocument – Adds a document to the data store.
- AddFolder – Adds a folder to the data store.
- DeleteDocument – Deletes a document from the data store.
- DeleteFolder – Deletes a folder from the data store.
- UpdateDocument – Updates (overwrites) a document in the data store.
- UpdateFolder – Updates (overwrites) a folder in the data store.
Install the SharePointProcessor example
The SharePointProcessor example code consists of two classes:
- InitializeModule.cs. Implements the
PackageInitializer
class, which registers the demo processing module. - DemoProcessor.cs.
DemoProcessor
is for demonstration purposes only. The sampleDemoProcessor
implementation calls the default behavior of the existing SharePoint processor and describes how to override the default behavior to extend or enhance it. You can create your own class that inheritsISharePointProcessor
so that when you initialize it, it overrides the default SharePoint processor.
Note
You can have only one overriding processing service.
To install the SharePointProcessor example code:
- Create a project in Visual Studio.
- Copy the DLL that contains your processor implementation into the bin folder of your solution.
- Restart the web server.
Register your processor
Register your SharePoint processor using the service locator in Optimizely, as shown in the following example:
private void InitializationEngine_InitComplete(object sender, EventArgs e)
{ _serviceLocator.Buildup(_processor); // Register our processor }
Demo Processor
The demo processor class implements the ISharePointProcessor
interface. The default implementation of each method is to call the default processor. For example:
public void AddFolder(SPListItem item)
{
// Do some custom processing
// Optionally call the default processor
defaultProcessor.AddFolder(item);
}
Note
The demo processor reads only the metadata for a specific document in SharePoint and sends the metadata to the plugin processor methods. The demo processor and the
AddDocument
method show how to retrieve the data use the default SharePoint processor by calling the default processor’sgetFileStream(item)
method, as shown in the following code samples.
InitializeModule.cs
using EPiServer.ConnectForSharePoint.Messaging;
using EPiServer.Framework;
using EPiServer.Framework.Initialization;
using EPiServer.Packaging;
using EPiServer.ServiceLocation;
using System;
using System.Threading;
namespace DemoSharepointProcessor
{
/// <summary>
/// Episerver Module initializer for this plugin.
/// </summary>
[InitializableModule]
[ModuleDependency(typeof(EPiServer.Web.InitializationModule))]
public class InitializeModule : PackageInitializer
{
IServiceLocator _serviceLocator;
ISharePointProcessor _processor;
public InitializeModule()
{
// Get the service locator from the environment
_serviceLocator = ServiceLocator.Current;
_processor = new DemoProcessor();
}
/// <summary>
/// For unit testing
/// </summary>
/// <param name="serviceLocator"></param>
internal InitializeModule(IServiceLocator serviceLocator, ISharePointProcessor processor)
{
// Use the Mocked service locator passed in
_serviceLocator = serviceLocator;
_processor = processor;
}
public override void Initialize(InitializationEngine context)
{
context.InitComplete += InitializationEngine_InitComplete;
}
private void InitializationEngine_InitComplete(object sender, EventArgs e)
{
_serviceLocator.Buildup(_processor); // Register our processor
}
public override void AfterInstall()
{
}
public override void AfterUpdate()
{
}
public override void BeforeUninstall()
{
}
}
}
DemoProcessor.cs
As an example, you can add a prefix to filenames that you bring into media from SharePoint.
- Add
item.File.Name = "EPi" + item.FIle.Name;
in the AddDocument section, just after the codevar data = defaultProcessor.getFileStream(item);
. - Build
DemoProcessor.cs
. - Run the SharePoint connector to upload the Sample.txt sample file. The custom
DemoProcessor
changes the name of the file and passes the name to the default processor, which copies Sample.txt to EPiSample.txt in the media store.
using EPiServer.ConnectForSharePoint.Messaging;
using EPiServer.ConnectForSharePoint.Models;
using EPiServer.ServiceLocation;
using EPiServer.ConnectForSharePoint.Helpers;
namespace DemoSharepointProcessor
{
[ServiceConfiguration(ServiceType = typeof(ISharePointProcessor))]
public class DemoProcessor : ISharePointProcessor
{
private SharePointProcessor dp;
// Default processor that adds documents and folders to EPiServer (optional)
private SharePointProcessor defaultProcessor {
get
{
if(dp == null)
dp = new SharePointProcessor();
return dp;
}
}
public void AddDocument(SPListItem item)
{
// Do some custom processing
// The splistitem does not contain the data stream associated with the file.
// The following line is an example of how to get the data associated with the SPListItem
SharePointProcessorHelper helper = new SharePointProcessorHelper();
var rawdata = helper.GetDocumentStream(item);
// Optionally call the default processor - note that the default processor
// also gets the data stream so that the data can be inserted into EPiServer
defaultProcessor.AddDocument(item);
}
public void AddFolder(SPListItem item)
{
// Do some custom processing
// Optionally call the default processor
defaultProcessor.AddFolder(item);
}
public void AddListItem(SPListItem item)
{
// Do some custom processing
SharePointProcessorHelper helper = new SharePointProcessorHelper();
var rawdata = helper.GetRawListItemData(item);
var dictionary = helper.GetMetaData(item.ParentList);
var fields = helper.ParseRawListItemData(dictionary, rawdata);
// Optionally call the default processor
defaultProcessor.AddListItem(item);
}
public void DeleteDocument(SPListItem item)
{
// Do some custom processing
// Optionally call the default processor
defaultProcessor.DeleteDocument(item);
}
public void DeleteFolder(SPListItem item)
{
// Do some custom processing
// Optionally call the default processor
defaultProcessor.DeleteFolder(item);
}
public void DeleteListItem(SPListItem item)
{
// Do some custom processing
// Optionally call the default processor
defaultProcessor.DeleteListItem(item);
}
public void UpdateDocument(SPListItem item)
{
// Do some custom processing
// Optionally call the default processor
defaultProcessor.UpdateDocument(item);
}
public void UpdateFolder(SPListItem item)
{
// Do some custom processing
// Optionally call the default processor
defaultProcessor.UpdateFolder(item);
}
public void UpdateListItem(SPListItem item)
{
// Do some custom processing
// Optionally call the default processor
defaultProcessor.UpdateListItem(item);
}
}
}
Register the Connect for SharePoint app
-
Log on to the Azure portal (https://portal.azure.com/) using your global admin user account.
-
Go to Azure Active Directory.
-
In the navigation pane, click App registrations. The App registrations page appears.
-
Click New registration. The Register an application screen appears.
-
In the Name box, enter a name for the app.
-
Under Supported account types, select Accounts in this organizational directory only (tenant_prefix - Single tenant).
-
Click Register.
Important
Copy and paste the following values in a document that you can access later. You will enter these values in the Optimizely software when you complete the Office 365 guided setup.
Application ID
Directory ID -
In the navigation pane, click API permissions.
-
Click Add a permission.
-
Click Microsoft Graph and complete the following steps:
a. Click Application permissions.
b. Select the User.Read permission.
-
Click Add permissions.
-
Click Grant admin consent for tenant_name.
-
Click Yes.
-
In the navigation pane, click Certificates & secrets. The Certificates & secrets page appears.
-
Click New client secret. The Add a client secret dialog box appears.
-
Enter a description, and then optionally select Never expire.
-
Click Add.
-
Copy and paste the client secret value in a document that you can access later. You will enter this value when you complete the Office 365 guided setup.
-
To assign full permissions to the tenant to back up SharePoint sites, in your browser, go to the tenant URL. For example, go to https://<office_365_tenant_URL>/_layouts/15/appinv.aspx. The SharePoint admin center page appears.
-
In the App ID box, enter the application ID that you recorded earlier, and then click Lookup. In the Title box, the name of the application appears.
-
In the App Domain box, type tenantname.onmicrosoft.com. To get the correct domain name, go to the Microsoft Azure website, Custom domain names.
-
In the App's Permission Request XML box, type the following XML string:
<AppPermissionRequests AllowAppOnlyPolicy="true"> <AppPermissionRequest Scope="http://sharepoint/content/tenant" Right="FullControl" /> <AppPermissionRequest Scope="http://sharepoint/social/tenant" Right="Read" /> </AppPermissionRequests>
-
Click Create.
-
Click Trust It.
Updated 13 days ago