topic Re: Jasper report outputs as email attachments (tJasperReportExec) in Talend Studio

Jasper report outputs as email attachments (tJasperReportExec)

Anonymous — Thu, 14 Jun 2018 11:04:05 GMT

Hi ,

I want send jasper report outputs as email attachments

I am using tjasperReportExec. The job looks as shown below. If I have to send the report output as an attachment to multiple email addresses, how do I do it? As of now it stores the output in a directory. Also, if I have 10 different email and the report output differs for each email, how do I pick the relevant attachment and send it in tsendmail component?

Also what is the difference between tjasperoutputexec, tjasperreportexec and tjasperoutput?

Any ideas on this will be of great help

Thanks

Rathi

Re: Jasper report outputs as email attachments (tJasperReportExec)

aashish_21nov — Thu, 14 Jun 2018 11:18:33 GMT

for multiple Email you can use semicolon( as a separator. Also to send different to differ user user you can use Trigger then runif strategy.

Re: Jasper report outputs as email attachments (tJasperReportExec)

fdenis — Thu, 14 Jun 2018 11:22:27 GMT

to send multiple reports, generate multiple report name using globalMap value of the tflowtoiterate.

Re: Jasper report outputs as email attachments (tJasperReportExec)

Anonymous — Thu, 14 Jun 2018 11:23:39 GMT

Hi Aashish,

I want it to loop, so I have used the tflowtoiterate. I want the report generated 10 times, each one containing the data specific for the email ID.

So, the relevant attachment needs to go to the correct email ID

My requirement is exactly the same as the solution in the video https://community.jaspersoft.com/blog/report-bursting-jasperreports-server

I read in a couple of articles that tjasperserverexec is not to be used as it is not updated regularly, hence using tjasperreportexec

Thanks

Rathi

Re: Jasper report outputs as email attachments (tJasperReportExec)

Anonymous — Thu, 14 Jun 2018 11:25:06 GMT

Hi fdenis,

Thanks, but, how do I attach it in the tsendmail? And how do I pick what is the relevant one for the specific email ID?

Re: Jasper report outputs as email attachments (tJasperReportExec)

fdenis — Thu, 14 Jun 2018 13:31:53 GMT

when you attache the document just add the output name of the report.

Define it unchecking "Use Default Output Name"

Fill Output name using distinct globalMap value as an email_id

Re: Jasper report outputs as email attachments (tJasperReportExec)

Anonymous — Thu, 14 Jun 2018 14:00:37 GMT

Hi fdenis,

In the attachment section of the tsendmail, I have used the code "C:/Users//report_out"+"_"+ ((Long)globalMap.get("row1.id"))+".xls"

And the tjasperreportexec has outputted these files already in the location mentioned above, report_out_1.xls, report_out_2.xls etc.

But I get the java.io.FileNotFoundException: error.

I don't understand where is the error?

Re: Jasper report outputs as email attachments (tJasperReportExec)

fdenis — Thu, 14 Jun 2018 14:13:29 GMT

Users//report --> Users/report

Re: Jasper report outputs as email attachments (tJasperReportExec)

Anonymous — Thu, 14 Jun 2018 14:26:33 GMT

Apologies, that was a typing error. The code used is Users/report and I get the file not found exception

Re: Jasper report outputs as email attachments (tJasperReportExec)

fdenis — Thu, 14 Jun 2018 14:34:10 GMT

did you want one report by mail or multiple reports by mail?
You can try using a fix file first?

Re: Jasper report outputs as email attachments (tJasperReportExec)

Anonymous — Thu, 14 Jun 2018 14:41:10 GMT

Okay the requirement is this. I have 4 email ids, abc@xxx.com, def@xxx.com, ghi@xxx.com and jkl@xxx.com

And the files outputted by tjasperreportexec is report_abc.xls, report_def.xls,report_ghi.xls, report_jkl.xls

So, for abc@xxx.com I must pick report_abc.xls , for def@xxx.com I must pick report_def.xls etc

Re: Jasper report outputs as email attachments (tJasperReportExec)

fdenis — Thu, 14 Jun 2018 14:42:55 GMT

dose it work with a fix file

Re: Jasper report outputs as email attachments (tJasperReportExec)

Anonymous — Thu, 14 Jun 2018 14:44:47 GMT

Yes, it works for a fix file

Re: Jasper report outputs as email attachments (tJasperReportExec)

fdenis — Thu, 14 Jun 2018 14:46:59 GMT

try with a copy of your reports and dynamic file name

Re: Jasper report outputs as email attachments (tJasperReportExec)

Anonymous — Thu, 14 Jun 2018 14:50:13 GMT

ahh.. I did not get you. Can you please elaborate?

Re: Jasper report outputs as email attachments (tJasperReportExec)

fdenis — Thu, 14 Jun 2018 14:53:36 GMT

dynamics name as attachment:
C:/Copy_Of_Users/report_out_"+ ((Long)globalMap.get("row1.id"))+".xls"

Re: Jasper report outputs as email attachments (tJasperReportExec)

Anonymous — Thu, 14 Jun 2018 15:01:21 GMT

fdenis, I have used this code "C:/Users/report_out_"+ ((Long)globalMap.get("row1.id"))+".xls" and its still the same error

Re: Jasper report outputs as email attachments (tJasperReportExec)

fdenis — Thu, 14 Jun 2018 15:05:51 GMT

add tlog on row1 (check name of file générated)

I'm not on your desk!

Re: Jasper report outputs as email attachments (tJasperReportExec)

Anonymous — Thu, 14 Jun 2018 15:13:11 GMT

fdenis, apologies for your time on a simple issue

I have checked and the file name that is generated is correct and the file is present at the location mentioned

C:/Users/report_out_4.xls. This is the file name generated

Re: Jasper report outputs as email attachments (tJasperReportExec)

fdenis — Thu, 14 Jun 2018 15:20:10 GMT

try crate report first and to iterate a second time after a onSubjodOk to send emails