nav[aria-label="Primary Navigation"] { padding: 0; & ul { list-style: none; width: 100%; display: flex; flex-direction: row; justify-content: start; align-items: start; gap: 30px; padding: 0; & li { margin: 0; } & ul li { list-style: none; } } }

send eMail notifications: BIRT RCP 4.3.1

shir

Hi, 
 
I am using BIRT RCP 4.3.1. 
 
I have a report; which shows the status of various files which we receive from up-stream systems. 
 
If suppose any particular file is still pending, i need to send a mail notification to the respective up-stream system.
 
attached is a sample view of the report

Find more posts tagged with

Comments

kclark

The only way I can think of to do this off hand is to write a PHP script that sits on your server, then call that PHP script with some JavaScript depending on the status, this should be able to be done in a text item. Or you can write a Java class that handles the email, then include this in a text item and take the same approach
 
pseudocode
<pre class="_prettyXprint _lang-">
if(data["ROW"] == "Pending") {
eml = new com.someclass.Email();
eml.sendEmail("contents");
}
</pre>

shir

Thanks Kristopher,
 
However i am still at a loss, as from where to begin the report.
 
If its not too much can you give an example ?

shir

bumping the thread!!

Clement Wong

As far as your requirements, I'm a little confused as whether you would like:
 
[A] Report that for all records that in Pending status, email out to the upstream systems.
 Report with buttons that the end user can manually click the mail icon to take action to email to upstream system.
 
If it's [A], then within BIRT, you may want to look at this DevShare and tweak the logic to just email for Pending status:
<a data-ipb='nomediaparse' href='http://developer.actuate.com/community/forum/index.php?/files/file/482-mailing-birt-reports-as-body-of-email'>http://developer.actuate.com/community/forum/index.php?/files/file/482-mailing-birt-reports-as-body-of-email</a>
 
If it's , then outside of BIRT, the target of the button would be an utility/app such as a servlet. As a example, the servlet would take in various parameters from your row detail and email out to the corresponding person/group. The logic of parsing the parameters, populating the body of the email and sending out of the mail would be handled in the servlet itself.

shir

Hi Clement,
 
I am looking to implement option ,
 
 Report with buttons that the end user can manually click the mail icon to take action to email to upstream system.
 
if this has to be a servlet, is there any way to implement it with BIRT RCP, 4.3.1.
 
If Not then what options do i have to take this forward

shir

I have been tinkering around with some HTML , and mailto tag seems to do the job.
 
I put in a text element of type HTML, and put the below text/HTML code:
 
<div><a href="mailto:<VALUE-OF>row["DataSet_Feed_DL::DL_DETAIL"]</VALUE-OF>?subject=Files to VOLKER Pending&body=Hi%20Team,%0A%0AThe%20file%20<VALUE-OF>row["DataSet_FOFeed_AMEROLA::DataSet_FOFeed_AMER::FEED_NAME"]</VALUE-OF>%20has%20not%20been%20received%20for%20date%20<VALUE-OF>row["DataSet_FOFeed_AMEROLA::DataSet_FOFeed_AMER::BUS_DATE"]</VALUE-OF>.%0A%0APlease%20provide%20us%20with%20the%20ETA%20to%20send%20the%20file.%0A%0A-%20MOTIF team"></div>
<div> send mail</div>
<div></a></div>
<div> </div>
<div>This actually does the job, i am looking for

</div>
<div> </div>
<div>Thanks again for all the help.</div>

shir

Hi All,
 
Coming back to the option [A], i.e. send mail at the click of a button.
 
Step 1: Users run the report
Step 2: Users pass parameters
Step 3: Report is displayed (this is hosted on a tomcat server)
Step 4: User clicks a button, and the report (web page) being displayed is sent across as a mail to recipients
I have referred to the post <a data-ipb='nomediaparse' href='http://developer.actuate.com/community/forum/index.php?/files/file/482-mailing-birt-reports-as-body-of-email/'>http://developer.actuate.com/community/forum/index.php?/files/file/482-mailing-birt-reports-as-body-of-email/</a>, 
however i was not able to connect the dots as how should we incorporate the .java code to our .rptdesign report.
I am assuming that the the code needs to be placed somewhere during the report initialization.
Upon the button click; some background logic will access to a particular method in the java code, pass parameters and finally send email with the report content.
 
Any pointers folks, so that i can try tinkering with my report?

Clement Wong

For your requirements, in Step 4, when a user clicks on a button, the action of the button will need to take place on the server side.
 
This would mean that it would need to re-execute the same report. However, you'll add similar code from the DevShare you referenced would be in your report design. You would also add a hidden boolean report parameter, "sendEmail", for example, with a default of false.
 
In the button of your report when it re-executes the report, you'll pass in the same parameters, and "sendEmail" to true.
 
You won't be able to send the entire report client side using that DevShare example.