Need to add XLSM file type to Collaboration

Murali_Natarajan

 Hello all,

 

We are using Collaboration 7.2 and want to add the file type support for XLSM files (Microsoft Excel Macro-Enabled Workbook), which is an Excel 2007 file.

 

Now we see that by default the 'mimetypes.xml' file which is in the root folder of Collaboration, contains mappings for DOCX, PPTX, XLSX, PPTM files.

 

For example, the XLSX mapping is as follows:

 

<mimetype>
    <type name="application"/>
    <subtype name="vnd.openxmlformats-officedocument.spreadsheetml.sheet"/>
    <description>Microsoft Excel document 2007</description>
    <icon_str>ExcelDocument</icon_str>
    <file_extension>.xlsx</file_extension>
    <indexable_content>true</indexable_content>
</mimetype>

 

and for PPTM files it is this:

 

<mimetype>
    <type name="application"/>
    <subtype name="vnd.ms-powerpoint.presentation.macroenabled.12"/>
    <description>Microsoft PowerPoint document</description>
    <icon_str>PowerPointDocument</icon_str>
    <file_extension>.pptm</file_extension>
    <indexable_content>true</indexable_content>
</mimetype>

 

 

When we upload an XLSM file to Collaboration, it shows the default blank icon and the tooltip as 'Generic Binary Stream'. The mimetype recognized by Collaboration is 'application/vnd.ms-excel.sheet.macroEnabled.12'.

 

So on the similar terms we created a new entry in 'mimetypes.xml' like this:

 

<mimetype>
    <type name="application"/>
    <subtype name="vnd.ms-excel.sheet.macroEnabled.12"/>
    <description>Microsoft Excel Macro-Enabled Workbook</description>
    <icon_str>ExcelDocument</icon_str>
    <file_extension>.xlsm</file_extension>
    <indexable_content>true</indexable_content>
</mimetype>

 

We restarted the Collaboration services and then uploaded another XLSM file.

Unfortunately, it still showed up with same Default Blank icon and 'Generic Binary Stream' tooltip.

 

Are we missing something here? Is there anything else we need to do?

 

Please anyone clarify the same.

Christopher_Parratt

After you change your configuration to:

<mimetype>
      <type name="application"/>
      <subtype name="vnd.ms-excel.sheet.macroenabled.12"/>
      <description>Microsoft Excel document 2007</description>
      <icon_str>ExcelDocument</icon_str>
      <file_extension>.xlsm</file_extension>
      <indexable_content>true</indexable_content>
</mimetype>

Basically  the subtype line should not contain any capital letters. When you restart collab, then add a
new xlsm file to a folder and see if the Icon now indicates an excel file. Then check if the edit works.

<Collab_Root>\mimetypes.xml is where icon to file type mappings are configured. KB 17529088

Can you go to the "Edit Properties" screen of <your report>.xlsm, please could you verify that the mimetype is set to application/vnd.ms-excel.sheet.macroEnabled.12? If the document's mimetype is not application/vnd.ms-excel.sheet.macroEnabled.12, please  make the  change, and verify whether the issue persists.