We’ve developed some resources to help you work effectively from home during COVID-19 Click to learn more

Setup - Office365 Cloud Office document Integration

In this article

    To start using the Office365 Integration, the setup consists of 2 articles:

    1) How to setup Office365 to integrate into CRM Online

    2) How to configure the integration for use (set up document handling) is documented in this article.

    Read more about the Office365 Integration in this article. 

    This article will help you set up the Microsoft Office365 part of the integration between Microsoft Office365 and SuperOffice CRM Online:

    How to set up the integration between Office365 SharePoint and CRM Online

    - there are 4 sections to set up the integration:

    • Check if your SuperOffice CRM Online tenant is ready 
    • Configure the integration in your Office365 SharePoint
    • Enable the integration for your CRM Online site
    • Configure your templates in SuperOffice Admin (in this article)

     

    Index:

    Prerequisites

    Preparations

    1 – Create a document library in your Office365 SharePoint library

    2 – Setting up Document Content types in Office365 SharePoint

    3 – Adding the SuperOffice Integrator App in Office365 Sharepoint

    4 - Enabling the SuperOffice integration

     

    Prerequisites

    • Your SuperOffice Online tenant must use SuperID with IDP for authentication - see this article for more information

    To be able to use the integration by users:

    The following components will be required to use the integration after setup:
    • A SuperOffice Online paid subscription (This app is available for all SuperOffice user plans)
    • A Microsoft Office365 Business plan subscription (All users of the SuperOffice Online tenant must have and use a Microsoft Office365 user account)
            • All O365 users need minimum read access to Root of the SharePoint site
    • In O365: Azure Active Directory (used for authentication) (It is usually called: “Active Directory Integration”)

    To be able to set up the integration:

    The following components will be required to complete this configuration process:
    • Sign up for Office 365 Integration in the SuperOffic App Store
    • Administrator access to SuperOffice Online tenant with administrator/User-level 0 type access.
    • An Microsoft Office365 Admin account in the domain with Admin rights. This includes admin access to the "SharePoint admin center", to configure and authorize SuperOffice to access data stored in your Office 365 cloud during the set-up.
    • In O365: Activate "allow user to run custom scripts"  < 24 h. before setup (see 'Preparations' below)

    Preparations

    1. During Integration setup steps - some details about your setup must be collected. These details will be used as parameters for setting the new configurations for your SuperOffice CRM Online site.

      Note 1:
      Your SuperOffice Online customer-specific URL, Cust Id (found in the browser URL while logged into SuperOffice Online), for instance, http://online.superoffice.com/cust8123/

      Write down the number of the "cust"-part of the URL as “Cust ID”
    2. To create new content types (see step 2), you need the SharePoint settings to "allow user to run custom scripts" activated < 24 h. before setup. You may perform the other steps in the meantime / create new content types at a later time.

    Integration setup

    1 - Create a document library in your Office365 SharePoint library

    NOTE! The "SuperOffice Archive" folder needs to be a 'document library', and this document library needs to be located on the Root of the SharePoint site, and not as a sub-site or a virtual site. See "Troubleshooting tips" for more information.

    1. Open Office365 log in as an admin user, go to O365 “Admin” 


    2. Go to Sharepoint under “Admin centers” 

    3. Open the Root area properties – by clicking the address https://[your_domain_name].sharepoint.com from the “Sharepoint Admin centers” menu list


      NOTE 2:
      Write down this URL as “SharePoint domain name URL=”

      Example: “SharePoint domain name URL=https://[your_domain_name].sharepoint.com"


    4. In the “site collection properties”: Open the Root area – by clicking the link https://[your_domain_name].sharepoint.com from the “site collection properties” 

    5. Open "Site contents" from the menu
    6. Create a 'document library' (used for SuperOffice documents) in the Root area: Click “New” and choose “Document library”. 

      Enter a name for your document library. 
      Example: SuperOffice_Archive   
      NOTE 3:
      Write down this name as “SO Archive Document Library Name=”

      This is the name of the document library.
      This will be the relative path of your document library to the root folder, ie.: https://[your_domain_name].sharepoint.com /SuperOffice_Archive/

      Example: “SO Archive Document Library Name=/SuperOffice_Archive/"

      Make sure the document library exists on Root of SharePoint, and have correct access rights (minimum "Edit" ) for your users before continuing.


    7. Create a 'template' folder (used for SuperOffice templates) in the SuperOffice Document library: Click “New” and choose “Folder”.

      Enter a name for your template folder. 
      Example: Template 

      NOTE 4:
      Write down this name as “Template Folder Name=” 

      Folder for templates, created inside the SuperOffice Document library

      For example: Template Folder Name=Template

      Make sure the folder exists, and have correct access rights for your users before continuing. 


    2 – Setting up Document Content types in Office365 SharePoint

    For creating new blank documents, spreadsheets, and presentations in SuperOffice CRM Admin (from a SharePoint template), we need to define several content types in SharePoint.

    To create new content types, you need the SharePoint settings to "allow user to run custom scripts" activated < 24 h. before setup. You may perform the next steps in the meantime / create content types at a later time if you prefer.

    This selection will fail if SuperOffice 'content types' are not set up in SharePoint:

    1. Open Office 365 log in as an admin user, go to O365 “Administrator” 
    2. Go to Sharepoint under “Admin centers” 
    3. Open the Root area – by opening the link https://[your_domain_name].sharepoint.com from the “Sharepoint admin centers” menu – to open the “site collection properties” 
      In the “site collection properties”: Open the Root area – by clicking the link https://[your_domain_name].sharepoint.com from the “site collection properties” 
    4. Click “Home” in the menu if you are not in the Grup Area. 
    5. Click the settings wheel-> Site Settings -> Site Content Types.
       
    6. Click Create
    7. • Enter 'SuperOffice Blank Document' as name 
      • Choose “Documents Content Types” / “Content types for documents” under 'Select parent content type from:'
      • Choose “Document” under 'Parent Content Type'
      • Enter SuperOffice as Group (Create the group if it's non-existing). 

    8. Click OK 
    9. Navigate the list to your newly created content type and open it. Click Advanced settings
       
    10. Select 'Upload a new document template:'. Choose a blank document from your computer. (Either download a pre-created blank .docx document
      or create a blank document from Office and stored locally) 
    11. Click OK 
    12. Repeat step 6 - 13 for 
    • SuperOffice Blank Spreadsheet (.xlsx) 
    • SuperOffice Blank Presentation (.pptx) 

    Note:
    If you get an access error – please read: 
    https://social.technet.microsoft.com/wiki/contents/articles/37533.sharepoint-online-how-to-enable-custom-script.aspx 

    Please go to SharePoint admin center > settings tab > Custom Script section >
    confirm whether the settings are configured to "Allow users from running custom script".

    Set them to "Allow users to run custom script" to see the outcome. The SharePoint settings "Allow user to run custom scripts" can take < 24 h. before activated. You may perform the other steps in the meantime / create the content types at a later time.

     



    3 – Adding the SuperOffice Integrator App in Office365 Sharepoint

    Since we’re not in Office Store – we have to add/upload the app manually:

    1. In “SharePoint admin center” - click “apps” from the menu 
    2. Open “App Catalog” from the “apps” page
      Example:
      Title: Custom apps
      Web Site Address: https://[ your_domain_name].sharepoint.com/sites/apps/
      Administrator: [any admin/currently logged in user]
      Server Resource Quota: 20

      The App Catalog is now being created – and available to be used within about 5 minutes
    3. Download the SuperOffice SharePoint App “SuperOffice.Office365.Integrator.app” locally
    4. Choose “Apps form SharePoint” in the menu. 

    5. Click upload and choose the local file “SuperOffice.Office365.Integrator.app”
    6. Click ok. The App is now Uploaded – and available to be used on your SharePoint site within about 10 minutes.

     
    To use the App on your SharePoint site - Add the App to the site: 

    1. Go back to Grup Area: 
      Open the Root area – by opening the link https://[your_domain_name].sharepoint.com from the “Sharepoint admin centre” menu – to open the “site collections properties” 
      In the “site collections properties”: Open the Root area – by clicking the link https://[your_domain_name].sharepoint.com from the “site collection properties” 
      Click “Site contents” in the menu:
       
    2. Click “New” from the dropdown inside the Grup Area, and choose “App” 

      Inside “Your Apps” – Apps you can add – you should now see “SuperOffice Online Integration” (if it is not in the list yet - it might take a few minutes before it is available. Try again in a few minutes)
    3. Click on it to add it, by clicking approve you trust it.

      (if you are not able to add it yet - it might take a few minutes before it is available to add. Try again in a few minutes)

      Once added - the SuperOffice Integration app should now be in the Group Area.
    4. SharePoint users who will use this app for logging in to CRM Online will need "read" access to the root folder of SharePoint (see 'Troubleshooting tips' for more information and options on how to enable it)

    4 – Notify SuperOffice to activate O365 document integration

    To turn on the O365 SharePoint integration for your CRMOnline tenant, submit the following details: 

    • "Cust ID"
    • “SharePoint domain name URL” 
    • “SO Archive Document Library Name” 
    • “SO Template Folder Name” 
    • Date and time you prefer to turn on the O365 SharePoint integration for your CRMOnline tenant
      NOTE!
      The form needs to be submitted to us a minimum of 1 working day before activation, and the date of activation needs to be on a regular workday/non-holiday.

    Note:
    Your site must be ‘recycled’ to get the new configurations! All users on this site will be logged out when this happens.
    Have this in mind when setting the date and time you prefer to turn on the O365 SharePoint integration for your CRMOnline tenant

    Use this form for submitting the details to us.

    You will get a notification from SuperOffice R&D Services when the O365 SharePoint integration is activated.
    When it is activated, you may continue to set up the templates, to make use of the O365 SharePoint integration (in this article)