In FileNet Workplace XT .csv files open as a text file instead of using MS Excel
The .csv file was created through WorkplaceXT and it only can be opened as the text file instead of the Excel file, and the mime type is text/csv, not application/vnd.ms-excel. However, when creating the same .csv document through ACCE, the mime Type is "application/vnd.ms-excel" shown under the Properties tab and Content Element tab.
1.Workplace XT uses the following order of precedence to determine a document's MIME type:
a. Uses the document's extension to check mime-mapping entries in the WorkplaceXT's web.xml file. b. Uses the MIME type sent by the browser, if the MIME type is not application/octet-stream. c. Uses the document's extension to check the JVM MIME type mappings. d. If it has not detected the MIME type, Workplace sets the type to null and the Content Engine resolves the mime type.
2.It seems XT 1.1.5.2 IF001 does not resolve the csv file correctly, to resolve this issue, please follow the tech note below to resolve your problem:
http://www-01.ibm.com/support/docview.wss?uid=swg21972681
I also list the detailed steps what I did on my environment, please refer to it below:
a. Stop the XT's WAS JVM.
b. Edit the web.xml file under the following two locations:
C:\IBM\WebSphere\AppServer\profiles\AppSrvAPP\installedApps\Win2k8AIONode02Cell\WorkplaceXT.ear\web_client.war\WEB-INF
C:\IBM\WebSphere\AppServer\profiles\AppSrvAPP\config\cells\Win2k8AIONode02Cell\applications\WorkplaceXT.ear\deployments\WorkplaceXT\web_client.war\WEB-INF
NOTE: Please make sure to backup the web.xml before you change it.
You need to add the following lines:
csv application/vnd.ms-excel
You can add it at the end of the last mime-mapping section.
c. After that, clean the XT temp directory on following location:
C:\IBM\WebSphere\AppServer\profiles\AppSrvAPP\temp\Win2k8AIONode02\server1
d. Finally, recycle your XT WAS JVM, then verify this issue again.