Export XML file not opening in Microsoft Excel with Web Viewer 14.0

Products

• Output Management Web Viewer

Issue/Introduction

When exporting report from Web Viewer v14.0, XML document opens in Word Pad, instead of Microsoft Excel as seen v12.1.  Besides having all users associated their XML file type to Microsoft Excel or open the exported file from the local download folder, is there other solution?  The latter one is based on Office XML Handler being associated to XML file type. 

Environment

Release : 14.0

Component : CA Output Management Web Viewer
Microsoft Excel

Cause

Reviewed format of exported .xml file and it appeared to be properly set up to open in EXCEL.  Registry settings also appear to be correct. Desktop team would need to troubleshoot this problem. This is outside Web Viewer's control.  The .xml file is delivered correctly.

Resolution

Recommended using OOXML format.  Set EXPORT_FORMAT to XML in the ConfigFile.cfg file.  However when specifying this it crashes.

Before you can use export format OOXML you need to verify the following: 

• You are at least 14.0.20 or higher (in other words SO13705 must be applied.
• In your environment variables (CAHVCENV) you must set java.io.tmpdir to a directory that exists and the acid of the server has read/write access.  For example (from the CAHVCENV file)

o   IJO="$IJO -Djava.io.tmpdir=${CATALINA_BASE}/temp"

 It’s a global setting so the format selected will be used for all exports for that server.

• The ID of the started task (CAWEBVWR) needs write permission to the TEMP directory because the OOXML file is compressed and needs the TEMP directory to uncompress the file. Web Viewer creates a directory under there and then creates files under there.

Office Open XML (OOXML)
Provides greater compatibility and ease of use. OOXML is the default format for exported reports. OOXML filenames appear as <filename>.xlsx. The OOXML format creates an .xlsx format file which is much more likely to open with EXCEL.