ITCM Report when opened with Excel is not correctly displayed

book

Article ID: 33244

calendar_today

Updated On:

Products

CA Automation Suite for Data Centers - Configuration Automation CA Client Automation - Asset Management CA Client Automation - IT Client Manager CA Client Automation CA Client Automation - Remote Control CA Client Automation - Asset Intelligence CA Client Automation - Desktop Migration Manager CA Client Automation - Patch Manager

Issue/Introduction

Problem:

When opening the report with excel, the column are not organized.

 

Cause:

When requesting itcm report to be opened with excel the result is not displayed by columns

 

Steps used causing the issue:

open the ITCM reporter, go to the results to export, right click on the results and select "open with / Excel desktop (CSV file)"

here next the screenshot with the results, only one column with all the entries is displayed at the left side

<Please see attached file for image>

Report_unicode_CSV.jpg

 

 

Resolution:

With the ITCM r12.9 and 14.0 a new entry is provided in the policy, go to 

configuration policy / <Your Default Computer Policy> / DSM / Administration console

 

here there is a new entry "CSV Export Data Format", by default it is set to "Unicode"

Unseal the policy and change it to "ANSI", seal the policy and verify that the manager have been updated with the changes.

you can issue the next command to verify the results it will be "unicode" or "ANSI"

 

ccnfcmda -cmd getparametervalue -ps /itrm/adminconsole -pn csvexportdataformat 

 

Close and open the Report Explorer and proceed again with the same steps:

right click on the results and select "open with / Excel desktop (CSV files) "

now the excel is displayed with the results by column, here next the screenshot with the results

 

<Please see attached file for image>

Report_ANSI_CSV.jpg

Environment

Release: UASIT.99000-12.9-Asset Intelligence
Component:

Attachments

1558698969753000033244_sktwi1f5rjvs16oic.jpeg get_app
1558698967846000033244_sktwi1f5rjvs16oib.jpeg get_app