SDM 12.9 Change Export Button File Extension Default From .xls To .xml

[STUART MATTHEWS]

Hello,

We have moved from Excel 2013 to Excel Office 365.

When exporting a search result in CA Service Desk Manager 12.9, the file extension is .xls, but its actually an .xml file.

Excel Office 365 throws an error trying to open the exports if they don't have the .xml file extension.

Does anyone know how to change the export button file extension default to .xml in SDM 12.9 ?

Thanks
Stuart

[Paul Coccimiglio]

Stuart..........

As we have discussed previously, SDM 12.9 is quite dated and has been EOS for some time.

There have been many improvements made to the export functionality since SDM 12.9.

One option you can try is the look at the WEB.XML file at NX_ROOT\bopcfg\www\CATALINA_BASE\webapps\CAisd\WEB-INF

------------------------------
Paul Coccimiglio
Principal Support Engineer
Broadcom Inc.
------------------------------

[STUART MATTHEWS]

This is happening in 17.1 too

[Michael Mueller]

Hi Stuart .

I tried the following on 17.3 and it seems to work( meaning the browser downloads excel.xml instead of excel.xsl ).

• pdm_extract usp_exlist_format > usp_exlist_format.dat
• changed line 
    { "0" ,"xls" ,"1001" ,"text/xml" ,"Excel file" ,"" ,"excel.xsl" }
  to
    { "0" ,"xml" ,"1001" ,"text/xml" ,"Excel file" ,"" ,"excel.xml" }
• loaded data with pdm_load -v -f usp_exlist_format.dat
• copied file $NX_ROOT/bopcfg/xslt/excel.xsl to $NX_ROOT/site/mods/xslt/excel.xml

Note, even if this works, this is completely out of support I assume.
Kind regards
...Michael