Discussion

3
Replies
1964
Views
 Junjar Singh Bhati (JunjarSinghB)
Virtusa

Virtusa
IN
JunjarSinghB Member since 2014 1 post
Virtusa
Posted: September 21, 2015
Last activity: December 6, 2015
Posted: 21 Sep 2015 14:11 EDT
Last activity: 6 Dec 2015 2:26 EST
Closed

Send mail with excel attached without WO

Hi,

      My requirement is to run reportdefinition and get content and convert content to excel and send this excel to mail as attachment.

My approach :

          got content and created HTML of that and set to property using property-set-HTML and now i need to convert this into excel then into byte code(base64) and send to sendnotificationwithallattachment.

Problem: can't use exportToExcel it will generate excel file and will ask to save it and this file can't be sent to mail. Is there any Pega method like HTMLToPdf for excel so that i can convert to into byte array and send to mail as attachment

Case Management
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 Discussion, please write a new Discussion.
Posted: 5 years ago
Posted: 1 Oct 2015 1:35 EDT
Murali Kakarla (Muralik7)
Infosys

Infosys
AU

Hi Junjar,


 


While using Property-Set-HTML, if you use Rule-Obj-Report-Definition.pzListViewExcelData HTML stream content is set in Excel format.


 


This is the HTML stream used in 'export to excel' feature on Report Definition results window. I think once this is done you can use this property (set with data in excel format) to attach this as a file for email notification.


 


Hope this helps you.


 


Murali...
Posted: 5 years ago
Posted: 1 Oct 2015 10:08 EDT
Sunny Mahato (SunnyMahato)
PEGA
Principal Solutions Consultant
Pegasystems
US

Am i missing something here ? If you already have a report, you can click on the "gear" icon on the right to schedule the report. It allows you to process the output as Excel and send notifications in email automatically.
Posted: 5 years ago
Posted: 6 Dec 2015 2:26 EST
Padmanabhan Kasiraj (PadmanabhanK)
Accenture

Accenture
IN

Hi SunnyMahato,


Do you have idea Which agent will process that scheduled report and how its Processing that? even i have a requirement similar to that, but in different scenario i need to get the list of results and Send in Email Attachment.


@JunjarSinghB, did you get the activity. Can you please share how you done that requirement?


Thanks,