topic Re: tsendmail send same mail manytimes in Talend Studio

tsendmail send same mail manytimes

Anonymous — Thu, 31 Jan 2019 11:07:48 GMT

I'm trying to join two tables and send the result of the join filtered in a tsendmail, Job below :

What I want to do is to send the rows collected in the same mail

My problems is that it's sending the same row many times.

Can you help solving this problem ?

Re: tsendmail send same mail manytimes

vapukov — Thu, 31 Jan 2019 11:29:52 GMT

the simplest way - store all in csv file and run tsendmail as separate subjob connected by OnSubjobOk trigger with attachments

Re: tsendmail send same mail manytimes

Anonymous — Thu, 31 Jan 2019 11:46:41 GMT

Is it possible to clean the csv file each time the email is sent so we can send new rows after each execution ?

Re: tsendmail send same mail manytimes

vapukov — Thu, 31 Jan 2019 11:47:57 GMT

of course, just add after tSendMail -> OnSubJobOk -> tFileDelete

Re: tsendmail send same mail manytimes

Anonymous — Thu, 31 Jan 2019 13:06:16 GMT

Hi,

You can use tjavaflex just before tSendmail and save you rows from table in array and then using global variable you can print in under "Message box" in tSendmail component.

Regards,

Rahul

Re: tsendmail send same mail manytimes

Anonymous — Thu, 31 Jan 2019 13:32:43 GMT

@rahuljan I'm using TjavaRow to read the output that I'm injecting in an HTML Code and then using the global variable to send the email.

Can I declare the array in the same place and using it afterward or I need to move the code to the tjavaflex

Re: tsendmail send same mail manytimes

Anonymous — Thu, 31 Jan 2019 13:34:20 GMT

@vapukov I'm a bit confused, can you walk me through your suggestion?

Re: tsendmail send same mail manytimes

vapukov — Thu, 31 Jan 2019 13:38:50 GMT

@SwanGhazi wrote:

@vapukov I'm a bit confused, can you walk me through your suggestion?

what do you mean?

create file tFileOutputDelimited

send file - tSendMail

delete file - tFileDelete

Re: tsendmail send same mail manytimes

Anonymous — Thu, 31 Jan 2019 14:22:16 GMT

Yes you to save everything in array before.

Re: tsendmail send same mail manytimes

Anonymous — Thu, 31 Jan 2019 15:03:23 GMT

@vapukov I should create that file before tjavaRow right ?

Re: tsendmail send same mail manytimes

vapukov — Thu, 31 Jan 2019 20:53:36 GMT

@SwanGhazi wrote:

@vapukov I should create that file before tjavaRow right ?

"
- Doctor, could you recommend for me a best medication to prevent a baby?
- glass of water
- wow!!! should I use it before sex or after?
- instead of!
"

🙂

btw, I don't know - what are you doing in tJavaRow, but tFileOutputDelimited - must be the last in subjob, it and create the file and populate it with data

1 st subjob (group of components in Talend terms) - preparing data and store it in file or variable (if not too big)

2nd subjob - send it

3rd - cleanup (delete file)

Re: tsendmail send same mail manytimes

Anonymous — Fri, 01 Feb 2019 17:46:08 GMT

@vapukov I've mentioned in a previous comment that I'm using TjavaRow to embed the output of the tmap in an HTML code and put the result in a global variable that I call in my tsendmail

Re: tsendmail send same mail manytimes

vapukov — Sat, 02 Feb 2019 00:23:08 GMT

it is simple, it is just separate and independent processes:

prepare csv file, nothing about HTML - read from DB all what must be sent, save it to file
send eMail, here - prepare text (in your case tJava)
cleanup - delete csv file after sending

cheers

Re: tsendmail send same mail manytimes

Anonymous — Tue, 05 Feb 2019 11:13:41 GMT

@vapukov can you assist me here to use the tFileOutputDelimited to put the date in my tjava ?

Re: tsendmail send same mail manytimes

vapukov — Tue, 05 Feb 2019 11:38:17 GMT

you can not use file in tJava (only file name)

in tJava you can use prepared variable (globalMap)

prepare file nd variables:

send email with prepared text and attachments:

Re: tsendmail send same mail manytimes

Anonymous — Tue, 05 Feb 2019 12:15:39 GMT

@vapukov I've just understood what you meant by the file

I'm so sorry took a lot of time to get you! I'm just having a problem that the mail is sent many time how can i prevent that ?