Problems displaying CSV Files on Tomcat Server

[ehmd]

Problem

When Ebase is running on a Tomcat server and you attempt to display a .csv file in a pop up window ( e.g. FPL display 'http://localhost:3030/ufs/myfiles.csv' ), the file is displayed as a plain text file by the browser. Therefore you don't get the option to save the file or open it in the default application associated with csv files.


Solution

Tomcat by default does not have a mime type associated with .csv files, so you need to add it to the configuration.

Amend the file Ufs/UfsServer/Tomcat/Conf/web.xml to add a new mime-mapping entry:-

Code: Select all

    <mime-mapping>
        <extension>csv</extension>
        <mime-type>text/csv</mime-type>
    </mime-mapping>	

then restart the Tomcat server.

[ehmd]

An alternative option is to use the Mime Type for Excel, as individual users PC's may not open the Text/CSV Mime Type correctly.

Code: Select all

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