Question

3
Replies
1070
Views
 Ponnusamy Sowmya (Sowmya07)
Cts

Cts
US
Sowmya07 Member since 2010 21 posts
Cts
Posted: May 6, 2020
Last activity: May 8, 2020
Posted: 6 May 2020 5:55 EDT
Last activity: 8 May 2020 2:29 EDT
Closed

How to send a generated csv file as an email attachment

In agent we are generating a csv file using out of the box pxConvertResultsToCSV activity and we are trying to attach the generated file in the SendEmailNotifcation activity.

But we are not able to pass the filename in the SendEmailNotification activity as it holds only the AttachmentPage as the parameter.

Any suggestions on how to attach the generated csv file to the email?

Thank you..

Pega Platform 7.4 Project Delivery
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: 1 year ago
Posted: 7 May 2020 2:54 EDT
Shyju Valappil (Shyju)
PEGA
Sr. System Architect
Pegasystems Inc.
IN

Hi,

You can do below approach in activity,

1. Encode the file content to Base 64 string using Java code.

2. Create a new page ExcelAttachment of type Embed-EmailAttachment.

3. Set pyName with some file name, pyDecode to true and pyData to Base 64 string for ExcelAttachment page.

4. Do a Page-Copy from ExcelAttachment to AttachmentPage.pyAttachments(<APPEND>). Now you can send this AttachmentPage as param to SendEmailNotifcation.

For testing quickly, you can get base 64 of some test file using some tools and try from step 3 before implementing step 1.