Question
Infosys Ltd
IN
Last activity: 18 Sep 2018 23:45 EDT
We are generating Excel file using activity 'MSOGenerateExcelFile'. We have used binary-file. Now we need to attach generated excel file to Workobject automatically. Kindly help
In activity we are putting the data on one pagelist and passing that data to activity 'MSOGenerateExcelFile'. So excel file is successfully getting generated.
Now we need to attach this generated file to work object automatically.So we have followed the below steps after calling 'MSOGenerateExcelFile'
1) Step6- call activity Call pzInitAttachContent
2) Step7- Setting important properties on page 'dragDropFileUpload' of class 'Code-Pega-List'. We are setting properties like pyNote, pyFileName, pyCategory, pyFileType, pyPageName and pyFileSource
3) Step8 - property set on page 'pyWorkAttach' for property .pxAttachName = "SurveyResponse.xlsx"
4) We are calling the activity Call Work-.pzSaveAttachments
Now the main challenge is which value we need to set in 'pyFileSource' property. I think we need to provide Base 64 encoded string here. Does anyone has idea about this?
Pegasystems Inc.
IN
Did you check this article : https://community.pega.com/how-attach-binary-file-work-object
Infosys Ltd
IN
Hi Santanu,
I am generating Excel file at run time and it also contains some data from work object. Now I need to attach this newly generated file to the work object. I have read the given article. Here they have directly opened the binary file rule and used 'pyFileSource' value in 'pyAttachStream'. So in article they have refer static file. In my case i am generating file at run time with some values from workobject so how can we get 'pyAttachStream' value for such files (which are generating at run time).
Regards,
Abhi
Pegasystems Inc.
IN
Consider sending a email via an utility in your flow. The moment you send the email, it gets attached as an attachment .
May be you can run tracer to capture the sequence of event associated with that and see how emails are getting attached at runtime and then explore the same algorithm to address your requirement.
Zensar Technologies
US
The file generated through MSOGenerateexcelfile will be in ServiceExportPath, you can upload file from that path and save that to attachments. Follow these steps after MSOGenerateExcelFile step,
Call pzInitAttachContent (creates attachment page 'pyAttachmentPage')
Property-Set 'Param.hiddenFileName' with your file name
Call pyUploadFile (uploadsloads the file from serviceexportpath) --> make sure to check pass parameter page
Call SaveAllAttachments (Saves attachment to workobject) --> Pass 'pyAttachmentPage' name as parameter