How to parse Excel attached to the case from queue processor / How to pass file path of a excel attached to the case

User Experience
, , , , , , , ,
1

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.

2

@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.

3

@DineshBhargav.V

You can follow the approach in this thread.

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.

4

@JoeH9464 We followed another approach to fulfill our requirement. Thanks for responding :slight_smile:

5

@Nadimuthu T We followed another approach to fulfill our requirement. Thanks for responding :slight_smile:

6

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)