Skip to main content

This content is closed to future replies and is no longer being maintained or updated.
Links may no longer function. If you have a similar request, please write a new post.

Question

11
Replies
10262
Views
ArtemP19 Member since 2014 1 post
Luxoft
Posted: Oct 6, 2015
Last activity: Oct 4, 2018
Closed
Solved

how to attach excel file to mail?

Hi everyone.

I need to do the following action:

1. We have page list with data and generated Excel file with these data
3. Need to send  email with this Excel File.


We are doing it out of WO. How to attach Excel file to mail?

I see many topics about the same issue on PDN, but still can't find  any solution for it.

Thanks in advance for your help


**Moderation Team has archived post**


This post has been archived for educational purposes. Contents and links will no longer be updated. If you have the same/similar question, please write a new post.

To see attachments, please log in.
Data Integration
Reporting

Accepted Solution

Posted: 9 years ago
Updated: 9 years ago

Hi all, going to provide a simple case of my task.
Pre-condition:

- Page List with the data below. TempPage(code-pega-list). TempPage.pxResults() - q-w-e-r-t-y class

TempPage.pxResults(1).Test1 = "X1";

TempPage.pxResults(2).Test1 ="X2";

TempPage.pxResults(3).Test1 ="X3".


===================================================

My solution:
1. To create a new activity AttachExcelToMail.
2 To create HTML rule GenerateExcelStructure with the content below:

===========================================================

<html>
<body>

<table border="1">
<tr>
<th>Test1</th>

</tr>

<pega:forEach name="TempPage.pxResults">
<pega:withEmbedded name="$THIS">
<tr>
<%


  String Test1= tools.getStepPage().getString("Test1");
  tools.appendString("<td wrap>" + Test1+ "</td>");
 
%>
</tr>
</pega:withEmbedded>

</pega:forEach>
</table>
</body>
</html>

========================================================

Show More

Hi all, going to provide a simple case of my task.
Pre-condition:

- Page List with the data below. TempPage(code-pega-list). TempPage.pxResults() - q-w-e-r-t-y class

TempPage.pxResults(1).Test1 = "X1";

TempPage.pxResults(2).Test1 ="X2";

TempPage.pxResults(3).Test1 ="X3".


===================================================

My solution:
1. To create a new activity AttachExcelToMail.
2 To create HTML rule GenerateExcelStructure with the content below:

===========================================================

<html>
<body>

<table border="1">
<tr>
<th>Test1</th>

</tr>

<pega:forEach name="TempPage.pxResults">
<pega:withEmbedded name="$THIS">
<tr>
<%


  String Test1= tools.getStepPage().getString("Test1");
  tools.appendString("<td wrap>" + Test1+ "</td>");
 
%>
</tr>
</pega:withEmbedded>

</pega:forEach>
</table>
</body>
</html>

========================================================

Activity  AttachExcelToMail.

1. Property-set-HTLM.

param.pyFileData = "GenerateExcelStructure"

2. Java

String strFileData =  getParameterValue("pyFileData");//getPrimaryPage().getValue("pySrc");

Page objHeadersPage = getProperty("pxRequestor.pyHTTPResponseHeaders").getAsPage();
if (objHeadersPage.isBound())
{
  objHeadersPage.setValue("contentType" ,"application/vnd.ms-excel");
  sendData("", strFileData);
}
else
{
  sendData("","Error. Can't get \"pxRequestor.pyHTTPResponseHeaders\" page");
}

3. Page-New
AttachmentLinksOpened page (code-pega-list)


4. Property-Set
- AttachmentLinksOpened.pxResults(<APPEND>).pxObjClass = 'Data-WorkAttach-File'

- AttachmentLinksOpened.pxResults(<LAST>).pyAttachStream = PegaFunction Base64Encode(param.strFileData).

5. Page-New AttachmentPage ( Data-EmailAttachments)

6. Property-Set

- AttachmentPage.pyAttachment(<APPEND>).pyDecode == True

- AttachmentPage.pyAttachment(<APPEND>).pyName == "ExportReport.xls"

- AttachmentPage.pyAttachment(<APPEND>).pyReference == AttachmentLinksOpened.pxResults(1).pyAttachStream

- AttachmentPage.pyAttachment(<APPEND>).pyRemoveXML == False



If you have any comments please let me know.


Hope this article help you.


Thanks.


Show Less
To see attachments, please log in.
Posted: 9 years ago

Santanu, thanks for the help.

One more question.
I have the following content of my Excel file.

=====================================================================

<html>

<body>

<table border="1">

<tr>

<th>test1</th>

</tr>

<tr>

<td wrap>value1</td><td wrap>value1</td><td wrap>value1</td><td wrap>value1</td>


</tr>

</table>

</body>

</html>

=====================================================================

How can i put this value in pyReference property?

Thanks in advance.

To see attachments, please log in.
Posted: 9 years ago

Hi all,

Half of the issue is solved.
1) I created AttachmentLinksOpened page (code-pega-list).

2) Set AttachmentLinksOpened.pxResults(<APPEND>).pxObjClass = 'Data-WorkAttach-File' and AttachmentLinksOpened.pxResults(<LAST>).pyAttachStream = "content of my Excel file".

3) Set pyReference as AttachmentLinksOpened.pxResults(1).pyAttachStream


Now I can send email with Excel file, but Excel file has incorrect data (some strange characters)

Any ideas?

Thanks in advance for the help

To see attachments, please log in.

Accepted Solution

Posted: 9 years ago
Updated: 9 years ago

Hi all, going to provide a simple case of my task.
Pre-condition:

- Page List with the data below. TempPage(code-pega-list). TempPage.pxResults() - q-w-e-r-t-y class

TempPage.pxResults(1).Test1 = "X1";

TempPage.pxResults(2).Test1 ="X2";

TempPage.pxResults(3).Test1 ="X3".


===================================================

My solution:
1. To create a new activity AttachExcelToMail.
2 To create HTML rule GenerateExcelStructure with the content below:

===========================================================

<html>
<body>

<table border="1">
<tr>
<th>Test1</th>

</tr>

<pega:forEach name="TempPage.pxResults">
<pega:withEmbedded name="$THIS">
<tr>
<%


  String Test1= tools.getStepPage().getString("Test1");
  tools.appendString("<td wrap>" + Test1+ "</td>");
 
%>
</tr>
</pega:withEmbedded>

</pega:forEach>
</table>
</body>
</html>

========================================================

Show More

Hi all, going to provide a simple case of my task.
Pre-condition:

- Page List with the data below. TempPage(code-pega-list). TempPage.pxResults() - q-w-e-r-t-y class

TempPage.pxResults(1).Test1 = "X1";

TempPage.pxResults(2).Test1 ="X2";

TempPage.pxResults(3).Test1 ="X3".


===================================================

My solution:
1. To create a new activity AttachExcelToMail.
2 To create HTML rule GenerateExcelStructure with the content below:

===========================================================

<html>
<body>

<table border="1">
<tr>
<th>Test1</th>

</tr>

<pega:forEach name="TempPage.pxResults">
<pega:withEmbedded name="$THIS">
<tr>
<%


  String Test1= tools.getStepPage().getString("Test1");
  tools.appendString("<td wrap>" + Test1+ "</td>");
 
%>
</tr>
</pega:withEmbedded>

</pega:forEach>
</table>
</body>
</html>

========================================================

Activity  AttachExcelToMail.

1. Property-set-HTLM.

param.pyFileData = "GenerateExcelStructure"

2. Java

String strFileData =  getParameterValue("pyFileData");//getPrimaryPage().getValue("pySrc");

Page objHeadersPage = getProperty("pxRequestor.pyHTTPResponseHeaders").getAsPage();
if (objHeadersPage.isBound())
{
  objHeadersPage.setValue("contentType" ,"application/vnd.ms-excel");
  sendData("", strFileData);
}
else
{
  sendData("","Error. Can't get \"pxRequestor.pyHTTPResponseHeaders\" page");
}

3. Page-New
AttachmentLinksOpened page (code-pega-list)


4. Property-Set
- AttachmentLinksOpened.pxResults(<APPEND>).pxObjClass = 'Data-WorkAttach-File'

- AttachmentLinksOpened.pxResults(<LAST>).pyAttachStream = PegaFunction Base64Encode(param.strFileData).

5. Page-New AttachmentPage ( Data-EmailAttachments)

6. Property-Set

- AttachmentPage.pyAttachment(<APPEND>).pyDecode == True

- AttachmentPage.pyAttachment(<APPEND>).pyName == "ExportReport.xls"

- AttachmentPage.pyAttachment(<APPEND>).pyReference == AttachmentLinksOpened.pxResults(1).pyAttachStream

- AttachmentPage.pyAttachment(<APPEND>).pyRemoveXML == False



If you have any comments please let me know.


Hope this article help you.


Thanks.


Show Less
To see attachments, please log in.
Posted: 9 years ago
Updated: 9 years ago

Hi Artem Prokopenko


Thanks for this post.


I did some changes to make it work for me.

AttachmentPage.pyAttachments(<APPEND>).pyDecode == True

- AttachmentPage.pyAttachments(<LAST>).pyName == "ExportReport.xls"

- AttachmentPage.pyAttachments(<LAST>).pyReference == "AttachmentLinksOpened.pxResults(1).pyAttachStream"   {Reference in double quotes}

- AttachmentPage.pyAttachments(<LAST>).pyRemoveXML == False

No need to call Java  step. Directly put pyFileData as reference
AttachmentLinksOpened.pxResults(<LAST>).pyAttachStream = PegaFunction Base64Encode(param.pyFileData).

!Thanks
Ajay

To see attachments, please log in.
Posted: 9 years ago

What would be next step after populating AttachmentPage.pyAttachements?

I called SendEmailWithAttachments  after setting pyreference and supplied the required parameters. I did get the email but without attachment.

Can you please elaborate what steps did you add after it?

To see attachments, please log in.
Posted: 8 years ago

Hi Ajay,

It worked for me when I called the OOTB function SendEmail with the parameter as AttachmentPage.

Calling OOTB Activity SendEmailWithAttachments is not working in this case.

Thanks for your input.

Regards,

Arjun Kumar Shaw

To see attachments, please log in.

We'd prefer it if you saw us at our best.

Pega Collaboration Center has detected you are using a browser which may prevent you from experiencing the site as intended. To improve your experience, please update your browser.

Close Deprecation Notice