Question
Evonsys
IN
Last activity: 21 May 2021 7:08 EDT
pyData for pxGenerateExcelFile
using pxGenerateExcelFile i can able generate the file from RD . when we click Run Button the file getting downloaded. when i use this generated file to attach in Email i am getting empty message without any attachments . For OOTB MsoGenerateExcelFile we use the Param.Exceldata as the value for pyAttachements.pyData column .
having doubt in what value should be passed as the parameter for pyAttachements.pyData when we use pxGenerateExcelFile .OOTB.
How to attach the file in pyAttachemets using pxGenerateExcelFile
Capgemini
IN
If you have used pxGenerateExcelFile/MsoGenerateExcelFile and checked param to download , then pega will not hold the file in service export path it will download to your local machine , If param is unchecked then file will be available in service export path.
Once you have the file in service export path in temp directory you can read the file and convert it into base64 encoded data , we have 2 ways to do it
1) property-set , Param.testencodeddata= @uplaodfile()
output will have Filepath="dfdf",FileNmae="efds", FileExtension="xlsx" , Filedata="sdfdfsdfds+sdfdsgfhw545s4..."
File data is base64 encoded info which we can use (Note: there will be dificulty only extracting file data as it is huge string and pega whatcomesafter and before functions cannot work)
2) use OOTB pyUploadFile and pass param hiddenfilename="filename.xlsx" , after MsoGenerateExcelFile .
This OOTB will look into service export path and search for file name mentioned in hiddenfilename and generate attachment page details.
I had used this page to save attachment into case from backend automatically , so i had called SaveAllAttachments OOTB
You can explore more on this for email attachments , also you can check OOTB in pega for email listner which reads mails and creates case and attaches mail to case