Description

".XLSB" extension is not working in attachment control. I have tried with ".XLSM" and It is working fine. If I try to upload ".XLSB" file manually in SAP, It gets uploaded but does not work composer/Studio.

Error in Studio "The database type XLSB is not valid. Please specify a valid database type."

Applies To

11x;12x

Solution/Immediate Workaround

On the Studio side that is Local Machine perform below steps.

• Open the ShuttleRule.xml file (in C:\Program Files\Winshuttle\STUDIO or in C:\Program Files (x86)\Winshuttle\STUDIO).
• Enter the MIME type for the document type that you want to add.

  For Example for Excel you will already have entry for XLSX for XLSB just add the below entry.

     <MimeTypes>
      <TypeEntry MimeType="application/vnd.ms-excel">
        <Extension>XLS</Extension>
        <Extension>XLSX</Extension>
        <Extension>XLSB</Extension>

For Composer add the below entries On the SAP IS server

1) Login to Server - Go to C:\Program Files\Winshuttle\Server\Worker\ShuttleRule.xml
2) Add the below entry and perform IIS Reset.
<MimeTypes>
      <TypeEntry MimeType="application/vnd.ms-excel">
        <Extension>XLS</Extension>
        <Extension>XLSX</Extension>
        <Extension>XLSB</Extension>

Attached sample example of attachment control created in 12.1 version.