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?

Products

• 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

Issue/Introduction

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.

Environment

Release:
Component: ARGIS