Posted: 12 Feb 2016 16:43 EST Last activity: 18 Feb 2016 17:02 EST
How Can We Upload And Attach A Excel File
I have an requirement where I need to read an excel file. Hence, I have given the user the Work-.pyFilePath control where user will get the browse button where he can browse and select a file.
The pxRequestor.pyFileUpload (Code-Pega-Requestor) will be holding the file name.
I am using the OOTB activity @baseclass.MSOParseExcelFile to parse the excel sheet and read the data into my pega properties. I have uploaded a template for the same.
Now business requests to attach the same file to the work object.
So, when I analyze, I am not able to user any OOTB activities which will be used to attach a file to the work object because all these activities users Data-WorkAttach-XXX page on the UI to hold the attachment.
But my UI has the pyFilePath on pyWorkPage.
So how can I attach a file and at the same time reads the content, parse the data using the binary file template and map the data to my pega properties?
Please help me in this.
Share this page
Moderation Team has archived post,
This thread is closed to future replies. Content and links will no longer be updated. If you have the same/similar Question, please write a new Question.
Posted: 5 years ago
Posted: 17 Feb 2016 10:16 EST
Santanu Bhattacherjee (Santanu)
Senior Manager - Sales Automation
I am able to do this by using the OOTB activity SaveAllAttachments activity. After the MSOParseExcelFile activity call, I set all the required properties on the Data-WorkAttach-File page and called SaveAllAttachments on the same page.