Office 365 Services

enaio® 11.0 »

The 'office365-client' and 'office365-dashlet' Office services can be used to integrate Office 365 as a dashlet in enaio® client, enaio® webclient, and enaio® webclient as a desktop application to enable collaborative work with Word, Excel, and PowerPoint documents.

You must have a OPTIMAL SYSTEMS license and one of the following Microsoft licenses: Microsoft 365 Business Standard or higher, Microsoft 365 Apps for Business, Microsoft 365 Apps for Enterprise, Office 365 E3 or Office 365 E5, and the corresponding Microsoft accounts for the users.

The Office versions require Office files in XML format. If previous file formats are to be edited, then conversion is offered and the converted files are created as variants.

The Office services are installed via enaio® service-manager and require the 'dms' service.

File Sizes

A timeout of 60 seconds as well as a size limit for file transfers are predefined for displaying and editing files.

Application Mode Size limit Comment
Word View - The only limit in terms of the file size is imposed by the timeout.
Word Edit 100 MB  
Excel View 25 MB  
Excel Edit 25 MB  
PowerPoint View - The only limit in terms of the file size is imposed by the timeout.
PowerPoint Edit 300 MB There is an additional size limit of typically 100 MB for files embedded in PowerPoint files. The size limit for embedded '.wav' files is 100 KB.

Configuration

You need the following data from OPTIMAL SYSTEMS GmbH for the configuration: OPTIMAL SYSTEMS tenant ID and OPTIMAL SYSTEMS tenant secret. This data will be provided at your request.

Special characters are not allowed for tenant IDs.

Follow these steps to configure the integration of Office 365:

  • Services configuration via the configuration files application-prod.yml of enaio® gateway and office365-prod.yml of enaio® service-manager.

  • Dashlet configuration for enaio® client in enaio® enterprise-manager.

Services Configuration

The configuration file application-prod.yml of enaio® gateway is expanded to include the endpoints of the Office services:

proxy:
  services:
    endpoints:
      - endpoint:
          name: office365
          url: 'http://localhost:8099'
      - endpoint:
          name: dashlet365
          url: 'http://localhost:8091'

The configuration file office365-prod.yml of enaio® service-manager is populated with the OPTIMAL SYSTEMS tenant data you received from OPTIMAL SYSTEMS GmbH on request and a path to a working directory:

tenant:
  id: OS-Tenant-ID
  secret: OS-Tenant-Secret
  provider-url: https://provider.prod.enaio.io/
  host-url: https://host.prod.enaio.io/
  working-dir: C:\\data\\office
  recovery:
    enable: true

Encryption of Configuration Values

The configuration values in the office365-prod.yml file located in the \config\ directory of enaio® service-manager can be encrypted:

  • Open the command prompt as the administrator and change to the \service-manager\tools\encryption\ directory.

  • Run the following command: encode.bat "value" -W.

    The encrypted value is displayed in round brackets with 'ENC' before it: ENC(encryptedvalue).

  • Copy the encrypted value with the leading 'ENC' and with the round brackets and enter it into the configuration file.

  • Save the configuration and restart the service, if necessary.

If the value to be encrypted contains quotation marks or ends with a backslash, these characters must be preceded by the backslash.
Example: encode.bat "passwordwith\"quotation\"marks" -W

Dashlet Configuration

The dashlet configuration for enaio® client takes places via enaio® enterprise-manager:

Application server > Server > Settings > Server properties > Category: Services > Dashletn:

  • Home URL:

    Copy
    http://<gateway-IP>/dashlet365/?id={OBJECTIDENT}&allowedExtensions=&locale={localename}&sessionguid={sessionguid}

    Copy the URL and enter it with the enaio® gateway address of your installation.

  • Title: Office 365

    You can enter any title for the dashlet.

    Dashlet titles cane by localized using enaio® administrator: Setup > Dashlet name

  • Load at start

    No, the dashlet should not be loaded at startup.

Office 365 in enaio® webclient and enaio® webclient as a desktop application

enaio® webclient and enaio® webclient as a desktop application automatically integrate Office 365 if Office services are installed.

Dashlets are not yet available at this time in enaio® mobile and, in general, are also not available on mobile devices; including enaio® webclient on mobile devices.

Health Check

The 'office365-client' service offers a health check. The health check can be performed via the Home button of the Details view of the service in enaio® services-admin or via the following address: https://<service-manager-admin-IP>:<port>. Default port of the 'office365-client' service: 8099.

The page shows an overview of the configuration.

You can perform the health check using the Start system health check button.

The result will be displayed. It can be saved using the Download TXT report button.