IBM Support

In FileNet Workplace XT .csv files open as a text file instead of using MS Excel

Troubleshooting


Problem

The .csv file was created through WorkplaceXT and it only can be opened as the text file instead of the Excel file

Symptom

The .csv file can be opened as the Excel from ACCE and outside of WorkplaceXT but not from inside of the WorkplaceXT

Cause

Mime Type was not set correctly when creating the .csv documents via WorkplaceXT

Diagnosing The Problem

  • When creating a .csv document through ACCE, the mime Type is "application/vnd.ms-excel" shown under the Properties tab and Content Element tab.
  • When adding a .csv document through WorkplaceXT, the mime Type shows "text/csv" from the Properties tab and Content Element tab in ACCE.
  • Verify if the .csv document with the mime Type "application/vnd.ms-excel" is opened as Excel file in WorkplaceXT

Resolving The Problem

Add a section to Web.xml mapping the extension to the mime type:


    <mime-mapping>
    <extension>csv</extension>
    <mime-type>application/vnd.ms-excel</mime-type>
    </mime-mapping>

[{"Product":{"code":"SSNVNV","label":"FileNet Content Manager"},"Business Unit":{"code":"BU004","label":"Hybrid Cloud"},"Component":"Workplace XT","Platform":[{"code":"PF002","label":"AIX"},{"code":"PF010","label":"HP-UX"},{"code":"PF016","label":"Linux"},{"code":"PF027","label":"Solaris"},{"code":"PF033","label":"Windows"}],"Version":"5.0;5.1.0;5.2.0;5.2.1","Edition":""}]

Document Information

Modified date:
17 June 2018

UID

swg21972681