Hi,
I have created a custom report showing the backup job summary and defined a custom date format for the starttime.
But when the report is exported/saved to CSV the date format aren’t used. it uses US date format
How to fix this ?
Hi,
I have created a custom report showing the backup job summary and defined a custom date format for the starttime.
But when the report is exported/saved to CSV the date format aren’t used. it uses US date format
How to fix this ?
Best answer by Stuart Painter
I see a resolution was provided in your support case:
1. On the Commserve, open registry and navigate to
HKEY_LOCAL_MACHINE\SOFTWARE\CommVault Systems\Galaxy\Instance001\CustomReportsEngine
2. In CustomReportsEngine, add the 2 values:
Name: csvDateTimeFormat
Type: String
Value: yyyy-dd-MM HH:mm:ss
Name: csvDateFormat
Type: String
Value: yyyy-dd-MM
3. After adding the entries, restart CommServe services using the Process Manager.
These settings will of course affect all reports generated, but it would be preferable to have date format selected on report generation, as required.
Development have reached out to explain this situation and what is being done behind the scenes.
When a report is requested with specific formatting, some processing needs to happen to present the data in the requested format.
CSV processing is performed in the backend to enable processing of larger datasets.
PDF and HTML processing is performed at the front end, but datasets are limited to avoid browser crash - which is why you see a difference in behaviour.
The registry keys above govern CSV backend processing formats, but on a system-wide level.
I am pleased to say Development are already working on a new design for processing report data to resolve these issues, which will be introduced in a future release.
Thanks,
Stuart
Enter your E-mail address. We'll send you an e-mail with instructions to reset your password.