Encoding excel file to send email
Hello,
I have an activity which pulls the data from report definition.I copied the data into AttachmentPage of class Data-EmailAttachments. Now i need to use base64encode function to encode it. Before this, i need to generate HTML file or use java code to encode it right? At the end I will be using SendEmailNotification activity to send the email. Say the data from report definition is saved onto Test.pxResults. How do i proceed from here? Please let me know if anyone worked on this before.
Thanks,
Nikhil
Anthem
US
To be more precise, here are the steps that i created. Getting error at step 3.
1. Calling Report definition (pxRetrieveReportData) and saving data on ReportData page.
2. Page-Copy: from ReportDate to AttachmentPage of Data-EmailAttachments class.
3. Property-Set: Local.datatoattach =@Base64Encode(AttachmentPage)
4. Java Step: from one of the PDN articles
To be more precise, here are the steps that i created. Getting error at step 3.
1. Calling Report definition (pxRetrieveReportData) and saving data on ReportData page.
2. Page-Copy: from ReportDate to AttachmentPage of Data-EmailAttachments class.
3. Property-Set: Local.datatoattach =@Base64Encode(AttachmentPage)
4. Java Step: from one of the PDN articles
ClipboardPage page_EmbedAttachment = null,
page_AttachmentPage = tools.findPage("AttachmentPage");
ClipboardProperty prop_pyAttachment = null;
try {
prop_pyAttachment = page_AttachmentPage.getProperty(".pyAttachments(<append>)");
page_EmbedAttachment = prop_pyAttachment.getPageValue();
page_EmbedAttachment.putString(".pyData",datatoattach);
page_EmbedAttachment.putString(".pyName","XYZ.xls");
page_EmbedAttachment.putString(".pyDecode","true");
page_EmbedAttachment.putString(".pyRemoveXML","false");
} catch (Exception e) {
tools.getPrimaryPage().addMessage( e.getMessage() );
}
5. Obj-Open: opening email account
6. Calling SendEmailNotification activity with AttachementPage as parameter.
PEG
PL
the function Base64Encode takes string as input.
I think step 9 of the OOTB activity "ConvertAttachmentToPDF" will help you to fulfill your request. Just you can see the whole activity and tweak to fulfill your need.
Anthem
US
To be more precise, here are the steps that i created. Getting error at step 3.
1. Calling Report definition (pxRetrieveReportData) and saving data on ReportData page.
2. Page-Copy: from ReportDate to AttachmentPage of Data-EmailAttachments class.
3. Property-Set: Local.datatoattach =@Base64Encode(AttachmentPage)
4. Java Step: from one of the PDN articles
To be more precise, here are the steps that i created. Getting error at step 3.
1. Calling Report definition (pxRetrieveReportData) and saving data on ReportData page.
2. Page-Copy: from ReportDate to AttachmentPage of Data-EmailAttachments class.
3. Property-Set: Local.datatoattach =@Base64Encode(AttachmentPage)
4. Java Step: from one of the PDN articles
ClipboardPage page_EmbedAttachment = null,
page_AttachmentPage = tools.findPage("AttachmentPage");
ClipboardProperty prop_pyAttachment = null;
try {
prop_pyAttachment = page_AttachmentPage.getProperty(".pyAttachments(<append>)");
page_EmbedAttachment = prop_pyAttachment.getPageValue();
page_EmbedAttachment.putString(".pyData",datatoattach);
page_EmbedAttachment.putString(".pyName","XYZ.xls");
page_EmbedAttachment.putString(".pyDecode","true");
page_EmbedAttachment.putString(".pyRemoveXML","false");
} catch (Exception e) {
tools.getPrimaryPage().addMessage( e.getMessage() );
}
5. Obj-Open: opening email account
6. Calling SendEmailNotification activity with AttachementPage as parameter.