I’m trying to parse an Excel file in Constellation using the pxParseExcelFile activity in Pega. This activity requires a filepath parameter, but I noticed that it’s not available in pxRequestor. I’m currently using the Community Edition of Pega.
I’ve gone through several support articles and community discussions where repositories are mentioned as part of the solution. However, I couldn’t find any clear screenshots or documentation detailing the exact parameters that need to be set.
Could someone guide me on how to properly configure this in Constellation? Any examples or screenshots would be greatly appreciated.
Assuming you want to use a case attachment, you have to create a mechanism to find the location of the case attachment and set the filepath parameter and push that into the OOTB activity pxParseExcelFile. Best is to make a generic Activity that can be reused for any attachment you want to use to parse excel into a pagelist. If you are interested i can share an example of a reusable flow where you can add your attachment reference and your excel template to parse the excel sheets into pagelists. See attached an example of an activity that prepares the filepath parameter and calls the pxParseExcelFile activity. In this example I am taking the repository filename (step 3) and combining it with the path of the default store (where my attachments are stored).
