search cancel

If I modify a Service Desk list form (list_xx.htmpl) to display column headings over 2 lines and do an Export from that list, why is the second line of the column heading truncated in the exported file?


Article ID: 19093


Updated On:


CA IT Asset Manager CA Software Asset Manager (CA SAM) ASSET PORTFOLIO MGMT- SERVER SUPPORT AUTOMATION- SERVER CA Service Desk Manager - Unified Self Service CA Service Desk Manager CA Service Management - Asset Portfolio Management CA Service Management - Service Desk Manager



This document outlines how to modify a Service Desk list form (e.g. list_in.htmpl) to display column headings, such as "Projected Violation", over 2 lines,and then export the list to a MS Excel file so that both lines of the headings are displayed in the exported file.


In order to display the column heading over 2 lines in the exported MS Excel file, we need to modify the list form per below.

e.g. "Projected Violation" attribute in list_in.htmpl.

  1. Copy the list_in.htmpl file from \bopcfg\www\htmpl\web\analyst to NX_ROOT\site\mods\www\htmpl\web\analyst

  2. Make the following change in NX_ROOT\site\mods\www\htmpl\web\analyst\list_in.htmpl.

    <PDM_MACRO name=lsCol hdr="Projected <br> Violation" attr=mintime>
    <PDM_MACRO name=lsCol hdr="Projected <br> Violation" attr=mintime exporthdr="Projected \\n Violation">

  3. Save the file and run a 'pdm_webcache -H' on the server and then clear your browser cache.

Now test the export and verify that the header value is correctly exported.


Component: ARGIS