Skip to main content

This content is closed to future replies and is no longer being maintained or updated.
Links may no longer function. If you have a similar request, please write a new post.

Question

 Surya Mokka (SuryaMokka)
Apple Inc

Apple Inc
US
SuryaMokka Member since 2018 16 posts
Apple Inc
Posted: Mar 2, 2020
Last activity: Mar 2, 2020
Posted: 2 Mar 2020 19:39 EST
Last activity: 2 Mar 2020 20:02 EST
Closed

Export and Import data to Excel

I have the following matrix inside Pega:

Column 1 Column 2 Column 3
ABC 123

09/06/1987
DEF 456

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

To see attachments, please log in.
Pega Platform 8.3
Case Management
Other Industry
Senior System Architect

Related content:

Related content has not currently been identified for this post.

We'd prefer it if you saw us at our best.

Pega Collaboration Center has detected you are using a browser which may prevent you from experiencing the site as intended. To improve your experience, please update your browser.

Close Deprecation Notice