OC 5.4.0 4 Important knowledge

Owned by Tobias Thornfeldt Wolters
Last updated: Sept 21, 2020
3 min read

On this page, you can find things to be aware of with the Digizuiteā„¢ Office ConnectorĀ (from now on OC).

Mac limitation

TheĀ OC has the following limitation for Mac users:

  • A Mac user must always save an Office document as a new asset in theĀ DC the first time it is saved in a session. After this initial save, the document can be replaced in the same session.

A session is started when theĀ OC is opened, and a session is stopped when theĀ OC or the Office application is closed.

The following use-case describes this limitation in more detail:

  1. Find an existing Office document inĀ MM (e.g. a Word document).
  2. Open the existing document.
  3. OpenĀ OC in the local Office application (e.g. Word), which has just been opened.
  4. Make changes to the document.
  5. Save the document with theĀ OC -Ā on Mac, the existing document in theĀ DCĀ canĀ not be replaced but only saved as a new asset.

Upload/save functionality

A user must have theĀ MediaPortal_UploaderĀ role to be able to upload anything from theĀ OC.Ā 

Furthermore, the following roles are used for controlling uploads from theĀ OC:

  • Office_Can_Upload_New:Ā Allows the user to save an Office document from theĀ OC as a new asset in theĀ DC.
  • Office_Can_Replace: Allows the user to replace an Office document,Ā which already exists in theĀ DC,Ā from theĀ OC.

These roles are assigned to the following user groups out of the box:

  • Superadministrator
  • Administrator
  • Content Creator

The following user groups are thus not able to save anything from the OC out of the box:

  • Light user
  • Guest

It is possible to disable uploads from theĀ OC completely from the ConfigManager with the configuration option "Disable Office Connector uploads".

Templates

When opening an Office template from throughĀ Ā Digizuiteā„¢Ā Media Manager 5Ā orĀ OC,Ā the following behavior is expected:

  • Word templates (".dotx"): The document can only be saved as a new plain Word document (".docx").
  • PowerPoint templates (".potx"): The document can only be saved as a new plain PowerPoint document (".pptx").
  • Excel templates (".xltx"): The template itself can be overridden, or a new template can be saved. Note that it is not possible to save a plain new Excel document (".xlsx") with theĀ OCĀ in this case.

It isĀ not possible to save PowerPoint templates (".potx") with the OC. Thus, if theĀ OC is opened when working on a PowerPoint template (".potx"), and the document is saved with theĀ OC, it will be saved as a regular PowerPoint document (".pptx"). The templates will be saved for Word and Excel.

Document titles

Remember that the following characters can't be used in titles of Office documents:

"*:<>?/\|

It might not be possible to open certain documents if their titles are too long. The maximum allowed length of a title depends on the length of the base URL for the installedĀ OC.

Opening existing documents

When trying to open existing documents fromĀ Digizuiteā„¢Ā Media Manager 5 or OC,Ā a popup might occur in the Office application, stating that the file format and the file extension don't match.

Choosing the option "Yes" ignores this and opens the document.

Please ensure that you areĀ notĀ actively editing a cell in Excel while opening theĀ OC.

Office Online

The following Office Online applications are supported:

  • Word Online
  • PowerPoint Online
  • Outlook Online

It is not possible to insert images with theĀ OC in Excel Online.

Existing documents from Digizuiteā„¢Ā Media Manager 5Ā can only be opened inĀ local Office applications.

When saving a document from an online Office application, the filename of the online document at the time the Office Connector was opened is used. Changing the title of the document in the online application while the Office Connector is open therefore doesn't have any effect.Ā Ā 

Debugging

To check if you have an issue with your manifest file, please try validating it with the following tool:Ā https://github.com/OfficeDev/Office-Addin-Scripts/tree/master/packages/office-addin-manifest

If you have issues loading the Office Connector when using localhost, please try following the documentation at:Ā https://docs.microsoft.com/en-us/office/troubleshoot/error-messages/cannot-open-add-in-from-localhost

If you have updated theĀ OC and you are encountering an infinite loading spinner or the styling has become weird, please attach a debugger by following the documentation at:Ā https://docs.microsoft.com/en-us/office/dev/add-ins/testing/debug-add-ins-using-f12-developer-tools-on-windows-10#debug-using-microsoft-edge-devtools.Ā When the debugger has been attached to the OC sideloaded in an Office application,Ā run the command "location.reload(true)" from the console. Alternatively, you might be able to reach the debugger (and thus avoid downloading the developer tools) by opening Edge and navigating to theĀ OC site.Ā