The DSM Reporter provides an option to export the report results in various formats such as CSV, odbc, html, etc. For results exported in the CSV format, the default data format is set to UNICODE. How to change the data format to ANSI?
This document provides a step by step guide to change the data format of results exported in CSV for both manual and scheduled reports.
1. To export an already existing report result:
a. Navigate to the report results and select the report result you want to export
b. Click on File -> Export List as CSV...
c. Select the appropriate format (ANSI/UNICODE) as per the requirement.
2. To export scheduled report results:
a. The Comstore parameter 'CSVExportDataFormat' controls the report export behavior.
b. Check the present value of the parameter, using the following command:
ccnfcmda -cmd getparametervalue -ps /itrm/adminconsole -pn csvexportdataformat
c. Change the value of parameter ‘CSVExportDataFormat’ using the command:
ccnfcmda -cmd setparametervalue -ps /itrm/adminconsole -pn csvexportdataformat -v Ansi/Unicode
1. In the last command, pass the value as per requirement, either ANSI or Unicode.
2. To alter comstore parameter, please ensure that user have required rights.