Question
Accenture
IN
Last activity: 17 Jun 2016 7:25 EDT
Show an uploaded excel sheet in attachments
In our application, we are uploading an excel sheet and parsing the data into our clipboard page. How can we show the same uploaded excel sheet in attachments so that user can download it from the attachments tab?
Accepted Solution
Pegasystems Inc.
IN
I'd let someone well versed in attachments answer this but for starters you may try the following -
- Create an instance of Data-WorkAttach-File with your excel stream as pyFileSource and some other mandatory properties like pyNote (the name of file when it's downloaded, pyCategory, pxAttachKey (Current datetime), etc) - Look at Work-.AttachFile activity to see what all defaults to set
- Call pxLinkAttachmentToCase with relevant parameters.
I think there is no straightforward way to do this but let someone else answer.
If your file were Rule-File-Binary, it'd be a lot easier and you'd need to call only pxAttachFile activity.
Updated: 17 Jun 2016 4:49 EDT
Process 360
IN
If the pxRequestor.pyFileUpload is still pointing to the uploaded file then you call Work-.AttachFile by passing parameters as
PageName--pyWorkPage
InsHandle - PyWorkPage.pzInsKey
pyCategory--File
Accenture
IN
Thanks Bhanu Prakash! I will try and let you know!
Pegasystems Inc.
GB
Hi Chranjeet - take a look at this discussion here as well : How to create ZIP archive and attach to case?
The customer in this case was creating a ZIP file (not an EXCEL file - but shouldn't matter that much) - they posted their solution to how to attach their resultant ZIP to a PRPC Work Item.
Cheers
John