Office 365 Services
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:
Copyhttp://<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.