We defined a server task periodically exporting a DMI report (it works very fine) to CSV file.
Are there some properties file or other configuration to change the format used (add / remove comments, change the csv separator, ...) ?
It is possible to change the separator/delimitor
For that, in the CAS go to atscon and then, in the interface "General propertie editor" change the parameter "EXPORT_PRINT_DELIMITER" with the character you want
But this new separator will be used for your schedulded task but also for manual export in the CAS report
it is possible to change the decimal separator?
when i export data of a report in the browser, the info of metrics that i get is similar to this 1,123456, the problem is when i define a scheduler task, the report appears on the defined route like this 1.222. i need to send daily information using comma as decimal separator so, i did some changes on the regional configuration on the server to try solve the problem and i changed the parameter USER_LOCALE_DECIMAL_SEPARATOR (, instead .) also changed the browser config and still appearing dot instead comma . i need some help about.
there are some others parameters that i am not considering?
If you go to: http://<YOUR_CAS>/sqlreports and execute:
select * from userproperties where username = 'adminuser' and propertyname like 'USER_LOCALE_%'
select * from userproperties where username = 'superuser' and propertyname like 'USER_LOCALE_%'
SQL queries, what is the output?
These are the request of querys:
I hope you can help me the ASAP.