Question
700 Applications
SA
Last activity: 30 Sep 2022 10:46 EDT
How to parse Excel attached to the case from queue processor / How to pass file path of a excel attached to the case
Hi all,
I have a requirement to parse excel which is attached to the case from backend processor (i.e. queue processor). I know that we can use OOTB activity 'pxParseExcelFile' to parse excel, this activity requires file path to execute its functionality. How to get file path of attached excel ? or do we have any alternative approaches to fulfill my requirement.
Note: 1) We need to parse 30,000+ records at a time, & save records to DB, That's why we planned to parse in backend instead of inside the case. 2) File listener we don't want to use for our requirement.
***Edited by Moderator Marije to change type from Pega Academy to Product***
Accepted Solution
Updated: 30 Sep 2022 10:46 EDT
700 Applications
SA
Thanks @Nadimuthu T @JoeH9464 for responding. We followed another approach to collect data from excel and store it in the DB table.
Our approach: Delegated table to required user & customized flow in a manner that the user can upload excel file in 'CSV' format and save data directly to table. (i.e. OOTB export functionality available for data types)
TATA Consultancy Services
IN
@DineshBhargav.V Export or download the file to service export directory and That activity take the file from service export directory. Please make sure the file name should be unique.
700 Applications
SA
@Nadimuthu T We followed another approach to fulfill our requirement. Thanks for responding :)
Capgemini
GB
You can follow the approach in this thread.
https://support.pega.com/question/how-parse-excel-using-pyattachstream
Use OOTB Pega activity pxCreateFile to take the case attachment from the database and save it as a file into the tempory service export directory, then using the file path you can call pxParseExcelFile.
Accepted Solution
Updated: 30 Sep 2022 10:46 EDT
700 Applications
SA
Thanks @Nadimuthu T @JoeH9464 for responding. We followed another approach to collect data from excel and store it in the DB table.
Our approach: Delegated table to required user & customized flow in a manner that the user can upload excel file in 'CSV' format and save data directly to table. (i.e. OOTB export functionality available for data types)