We are trying to export the data table which has DateTime property. So that users can add data to it, but when its being exported the yyyyMMddThhmmss.000GMT. This is not that much understandable by business, is there a way to format it into a more user friendly format so that the export to excel (csv) will have the text in the required format.
***Updated by Moderator: Vidyaranjan. Removed user added #helpme tag. Apologies for confusion, shouldn't have been an end-user option***
Its the pega OOTB export feature which we are using for the data tables export. We didn't see any rule which we can override to set the export format out. Little bit more information would be very helpful. Thank you!
You can modify the list view DataTableClassEditor and include Date Related Control under Export Format of that particular column. this list view will be there in your data table class.
When user exports the data to excel, this control will kick in and shows the user friendly format. User can enter the data in the same format. When user enter a date, this might be automatically converted to date timestamp when saving the data to data table (better to check the clipboard to verify the format of the value). if any issues are encountered during saving of user entered date, then you may need to specalize the OOTB rule which is called while saving this data to your data table in your data table class.
Making changes to the DataTableClassEditor did not solve the issue. Still the values are exported in are exported in the yyyyMMddThhmmss.000GMT. When we tried looking into the issue, we noticed that all the rules are final. Starting from pzDownloadDataRecordsAsCSV.
The activity pxConvertResultsToCSV is the one which is generating the CSV file. Is there a way to apply styles or enable the activity to make use of the readonly format for the datetime property instead of the pyStringType = DateTime.
Mention the Date control in the Report definition of the data type. Each column in report defn will have a settings icon at last in that we can configure the control/format, so upon exporting the data, it will display approapriately.