Preview .xlsm files within IBM Connections

connections cnx

IBM Docs and the IBM File Viewer are supporting .xlsm (macro enabled Excel sheets) files since version 2.0 CR1. This feature was available for third-party integrations only. With the latest IBM Connections release (5.5 CR2) it is now also supported within IBM Connections itself.

After upgrading IBM Docs and IBM Connections to the latest versions .xlsm file editing worked out of the box. To get the preview (IBM File Viewer) working I had to customize the viewer-config.json as described below.

Customize mime-types section:

"mime-types": {
"application/vnd.openxmlformats-officedocument.presentationml.presentation": "pres",
"application/vnd.ms-powerpoint": "pres",
"application/vnd.oasis.opendocument.presentation": "pres",
"application/vnd.ms-excel.sheet.macroenabled.12": "sheet",
"application/vnd.ms-excel": "sheet",
"application/vnd.openxmlformats-officedocument.wordprocessingml.document": "text",
"application/vnd.oasis.opendocument.text": "text",
"application/vnd.openxmlformats-officedocument.spreadsheetml.sheet": "sheet",
"application/vnd.oasis.opendocument.spreadsheet": "sheet",
"application/pdf": "pdf",
"application/msword": "text"
}

Customize file_size_threshold section:

"file_size_threshold": {
"application/vnd.openxmlformats-officedocument.presentationml.presentation": "0",
"application/vnd.oasis.opendocument.spreadsheet": "0",
"application/vnd.ms-powerpoint": "0",
"application/vnd.openxmlformats-officedocument.spreadsheetml.sheet": "0",
"application/vnd.oasis.opendocument.presentation": "0",
"application/vnd.ms-excel.sheet.macroenabled.12": "0",
"application/vnd.openxmlformats-officedocument.wordprocessingml.document": "0",
"application/vnd.ms-excel": "0",
"application/vnd.oasis.opendocument.text": "0",
"application/pdf": "0",
"application/msword": "0"
}

Preview template files (.dot, .pot, .xlt, …) are still only supported in third-party integrations (more information).

2 thoughts on “Preview .xlsm files within IBM Connections”

  1. Great! Works for me, thanks for sharing.

    To also include support for XLSM thumbnails in Files you can follow the steps from this guide..

    http://www-01.ibm.com/support/docview.wss?uid=swg21699516

    1. Go to /opt/IBM/WebSphere/AppServer/profiles/{$profileName}/installedApps/{$cellName}/Files.ear/config

    2. In the file com.ibm.lconn.share.platform.bootstrap.properties, find the following line:

    external.thumbnailGeneration.fileExtensions=.doc,.docx,.ppt,.pptx,.xls,.xlsx,.odt,.ods,.odp,.pdf

    & add the .xlsm extension so it becomes.

    external.thumbnailGeneration.fileExtensions=.doc,.docx,.ppt,.pptx,.xls,.xlsx,.odt,.ods,.odp,.pdf,.xlsm

    It is a bit of hack/workaround as an iFix for Files will overwrite this change – but it works.

Leave a Reply

Your email address will not be published. Required fields are marked *