Question
Accenture Federal Services
US
Last activity: 29 Oct 2021 7:13 EDT
Email Attachment through Agent with no Work Item
I am trying to fulfill a business requirement in which I need to automatically send an email (through an agent) that will send out an excel report attached to the email. I know that I can schedule reports on the report tab, but this is a custom report that does not show up with that option. I have searched through Pega Community and through the other people at my company and so far no one has been able to help me. Currently I am doing the following: Call MSOExcelDownload (This downloads the file exactly as I would expect) Page-New => AttachmentPage (class Data-EmailAttachments) Property-Set => pyData, pyName, pyRemoveXML, pyType, and pyDecode on AttachmentPage Call SendSimpleEmail (This has been heavily modified in our application to email according to business needs) As of now, the activity runs and sends out an email with an attachment, but the attachment is only the binary file for the template and contains no information. This is because I am passing the TemplateFile.pyFileSource in for pyData on the AttachmentPage. I cannot find the file source for the downloaded attachment once its been created. Any help or suggestions with this would be highly appreciated. Thanks.
Accepted Solution
Updated: 20 May 2021 10:36 EDT
Accenture Federal Services
US
Here is the solution that I came up with as the OOTB scheduled reports lack of customization on the excel file did not meet business requirements: I am running an activity through a scheduled agent. That activity call another activity whose class is Code-Pega-List and the context is the data page or page list that you want to use for the Excel's data. In this activity I added the following steps:
----------
1. > Obj-Open [TemplateFile] (Class Rule-File-Binary)
*PropertyName *PropertyValue
.pyApplicationName = Param.TemplateFileDirectory (Rule-File-Binary App Name (Directory))
.pyFileName = Param.TemplateFileName (Rule-File-Binary File Name)
.pyFileType = Param.TemplateFileExtension (Rule-File-Binary File Type (extension))
2. > Java []
String dlFileName = tools.getParamValue("DownloadFileName")+".xls";
String out = com.pegarules.generated.comp_excelfunctions_excel_functions.ExportExcelFileOutput(dlFileName);
tools.putParamValue("pyAttachStream", out);
3. > Page-New [AttachmentPage] (Class Data-EmailAttachments)
4. > Property-Set [AttachmentPage]
Here is the solution that I came up with as the OOTB scheduled reports lack of customization on the excel file did not meet business requirements: I am running an activity through a scheduled agent. That activity call another activity whose class is Code-Pega-List and the context is the data page or page list that you want to use for the Excel's data. In this activity I added the following steps:
----------
1. > Obj-Open [TemplateFile] (Class Rule-File-Binary)
*PropertyName *PropertyValue
.pyApplicationName = Param.TemplateFileDirectory (Rule-File-Binary App Name (Directory))
.pyFileName = Param.TemplateFileName (Rule-File-Binary File Name)
.pyFileType = Param.TemplateFileExtension (Rule-File-Binary File Type (extension))
2. > Java []
String dlFileName = tools.getParamValue("DownloadFileName")+".xls";
String out = com.pegarules.generated.comp_excelfunctions_excel_functions.ExportExcelFileOutput(dlFileName);
tools.putParamValue("pyAttachStream", out);
3. > Page-New [AttachmentPage] (Class Data-EmailAttachments)
4. > Property-Set [AttachmentPage]
*PropertiesName *PropertiesValue
.pyAttachments(<APPEND>).pyData = Param.pyAttachStream (the base 64 returned from the java step)
.pyAttachments(<LAST>).pyName = Param.DownloadFileName (the desired name of the file attached to your email)
.pyAttachments(<LAST>).pyType = Param.TemplateFileExtension (the excel file extention, most likely xlsx in this case)
.pyAttachments(<LAST>).pyDecode = true (decode from base 64)
.pyAttachments(<LAST>).pyRemoveXML = false (we are not generating from xml)
5. > Call SendSimpleEmail []
6. > Page-Remove [TemplateFile]
----------
Note that I had to modify the SendSimpleEmail activity to take the AttachmentPage we created here instead of the one generated in the activity (how you accomplish that is up to you). Then you can either pass in your parameter values from a calling activity or add a property-set to the start of the activity to set up your parameter values and you should be sending Excel attachments via emails without needing a work object.
Accenture Federal Services
US
I tried using the OOTB report scheduler to send out the report, and it works, except that I need to change the format of the exported excel attachment created by the scheduler. Is there a way to change the format of the excel file from the scheduler similar to the way that we can use binary files as a template to create custom excel files?
Accepted Solution
Updated: 20 May 2021 10:36 EDT
Accenture Federal Services
US
Here is the solution that I came up with as the OOTB scheduled reports lack of customization on the excel file did not meet business requirements: I am running an activity through a scheduled agent. That activity call another activity whose class is Code-Pega-List and the context is the data page or page list that you want to use for the Excel's data. In this activity I added the following steps:
----------
1. > Obj-Open [TemplateFile] (Class Rule-File-Binary)
*PropertyName *PropertyValue
.pyApplicationName = Param.TemplateFileDirectory (Rule-File-Binary App Name (Directory))
.pyFileName = Param.TemplateFileName (Rule-File-Binary File Name)
.pyFileType = Param.TemplateFileExtension (Rule-File-Binary File Type (extension))
2. > Java []
String dlFileName = tools.getParamValue("DownloadFileName")+".xls";
String out = com.pegarules.generated.comp_excelfunctions_excel_functions.ExportExcelFileOutput(dlFileName);
tools.putParamValue("pyAttachStream", out);
3. > Page-New [AttachmentPage] (Class Data-EmailAttachments)
4. > Property-Set [AttachmentPage]
Here is the solution that I came up with as the OOTB scheduled reports lack of customization on the excel file did not meet business requirements: I am running an activity through a scheduled agent. That activity call another activity whose class is Code-Pega-List and the context is the data page or page list that you want to use for the Excel's data. In this activity I added the following steps:
----------
1. > Obj-Open [TemplateFile] (Class Rule-File-Binary)
*PropertyName *PropertyValue
.pyApplicationName = Param.TemplateFileDirectory (Rule-File-Binary App Name (Directory))
.pyFileName = Param.TemplateFileName (Rule-File-Binary File Name)
.pyFileType = Param.TemplateFileExtension (Rule-File-Binary File Type (extension))
2. > Java []
String dlFileName = tools.getParamValue("DownloadFileName")+".xls";
String out = com.pegarules.generated.comp_excelfunctions_excel_functions.ExportExcelFileOutput(dlFileName);
tools.putParamValue("pyAttachStream", out);
3. > Page-New [AttachmentPage] (Class Data-EmailAttachments)
4. > Property-Set [AttachmentPage]
*PropertiesName *PropertiesValue
.pyAttachments(<APPEND>).pyData = Param.pyAttachStream (the base 64 returned from the java step)
.pyAttachments(<LAST>).pyName = Param.DownloadFileName (the desired name of the file attached to your email)
.pyAttachments(<LAST>).pyType = Param.TemplateFileExtension (the excel file extention, most likely xlsx in this case)
.pyAttachments(<LAST>).pyDecode = true (decode from base 64)
.pyAttachments(<LAST>).pyRemoveXML = false (we are not generating from xml)
5. > Call SendSimpleEmail []
6. > Page-Remove [TemplateFile]
----------
Note that I had to modify the SendSimpleEmail activity to take the AttachmentPage we created here instead of the one generated in the activity (how you accomplish that is up to you). Then you can either pass in your parameter values from a calling activity or add a property-set to the start of the activity to set up your parameter values and you should be sending Excel attachments via emails without needing a work object.
Tata Consultancy Services
AU
Please find the attached doc for the steps for an activity to send an excel generated from a RD through email