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?

Document ID : KB000019093
Last Modified Date : 14/02/2018
Show Technical Document Details

Description:

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.

Solution:

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.

    [Before]
    <PDM_MACRO name=lsCol hdr="Projected <br> Violation" attr=mintime>
    [After]
    <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.