topic Re: Fetch data using Iterate and send logs by mail in Talend Studio

Fetch data using Iterate and send logs by mail

Anonymous — Tue, 30 Oct 2018 11:16:06 GMT

Using below Job Oracle Input-->Iterate ---> Sending Mail to multiple mail ids , now i need to send logs of all the users to whom mail has been sent in single mail .Can you help me how can same be achieved .

something like below

Oracle Input-----Iterate----SEndng Mail---Log----Sendmail(log file with all details as attachment)

Re: Fetch data using Iterate and send logs by mail

Anonymous — Tue, 30 Oct 2018 13:09:27 GMT

one easy way to accomplish this is to copy and paste your original query/send mail part and simply remove the iterate to gather all rows into a single email message.

Re: Fetch data using Iterate and send logs by mail

Anonymous — Wed, 31 Oct 2018 08:14:32 GMT

JGM i can do that , but then 1 by 1 mail wont' go to user .

Overall first i need to fetch records 1 by 1 and send mail using iterate and then i need to send all those records by mail to users for there information that mail to all these users has been sent .

Re: Fetch data using Iterate and send logs by mail

Anonymous — Sat, 17 Nov 2018 06:23:14 GMT

can any one guide me on this

Re: Fetch data using Iterate and send logs by mail

Anonymous — Sat, 17 Nov 2018 11:34:43 GMT

Hi,

Could you please try below way?

Since we are using On component ok, it will allow the trowgenerator to push records to target file each time. Please fix 1 record in trowgenerator and select append option in the delimited file.

I have added a tSleep to make sure that we will give some 10 to 20 seconds delay to complete writing the last record to file.

You can use tSendmail to publish the file which will have details of all the records for whom mail was sent.

If the answer has helped you, could you please mark the topic as resolved? Kudos are also welcome 🙂

Warm Regards,

Nikhil Thampi

Re: Fetch data using Iterate and send logs by mail

Anonymous — Mon, 19 Nov 2018 05:25:29 GMT

Nikhil thats great but can you give me how can i populate field using trowgenerator ,eg. i have 1 value as emailid coming in frm DB and getting passed to sendmail how can i capture same in trowgenerator and then to outputdelimited . Thanks for your response and guidance

Re: Fetch data using Iterate and send logs by mail

Anonymous — Mon, 19 Nov 2018 05:35:16 GMT

Hi,

Could you please try to add the column value from tflowtoiterate? Also set the number of records in trowgenerator as 1.

Hope it will help you to resolve your use case 🙂

Warm Regards,

Nikhil Thampi

Re: Fetch data using Iterate and send logs by mail

Anonymous — Mon, 19 Nov 2018 06:37:04 GMT

Kudos Nikhil Work like a Charm