Posted: 2 Mar 2020 19:39 EST Last activity: 2 Mar 2020 20:02 EST
Export and Import data to Excel
I have the following matrix inside Pega:
I am able to export the above data to Excel using "pxConvertResultsToCSV" activity. Also, able to import the data from Excel to Pega using "pxUploadCSVResults" flow action.
Here the Column A type is Text, Column B type is Integer and Column C type is Date. After the excel export, user can modify the data and import back to pega. User's are updating the excel with invalid data and importing back to pega which is causing so many issues.
Work Around - We need to add validations for each column field.
Is there anyway we can add some restrictions to the column data while exporting to excel?