Question

83
Views
SuryaMokka Member since 2018 16 posts
Apple Inc
Posted: 6 months ago
Last activity: 6 months 2 weeks ago

Export and Import data to Excel

I have the following matrix inside Pega:

Column 1Column 2Column 3
ABC123

09/06/1987

DEF456

09/05/198

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.

Issue:

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?

 

Thanks

Pega Platform 8.3 Case Management Other Industry Senior System Architect
Share this page LinkedIn