topic Re: how to send mail for tmap rejects in Talend Studio

how to send mail for tmap rejects

Anonymous — Wed, 19 Apr 2017 05:47:12 GMT

i am using tlogrow to capture tmap rejects. i want to send these rejected records through mail using tsendmail .

can you please suggest how this can be achived

Re: how to send mail for tmap rejects

TRF — Wed, 19 Apr 2017 06:02:37 GMT

Hi,
I suggest you not to send 1 email per reject.
Collect all rejects into a file then (onSubjobOk or at the end of the job using a tPostJob) send then email with the reject file as an attachment.
With this method you'll improve performance (1 email to send), you can design the reject file schema as you want and if necessary you can aggregate rejects from different steps of the job into the same file.
Hope this helps.

Re: how to send mail for tmap rejects

Anonymous — Wed, 19 Apr 2017 18:56:10 GMT

To add to above, you may create a global variable to monitor the reject row count , after storing the error in file add a runif condition for counter>0 to to send the email

Re: how to send mail for tmap rejects

Anonymous — Thu, 18 May 2017 06:44:32 GMT

Hi thanks for that, can u please show how the flow would be

Re: how to send mail for tmap rejects

Anonymous — Sat, 07 Apr 2018 20:07:18 GMT

waoo...please show us how with screenshoot