topic Re: Trigger mail only if Attachment is not empty in Talend Studio

Trigger mail only if Attachment is not empty

joe86 — Mon, 03 Dec 2018 05:37:10 GMT

Hi All,

I need to send a mail only when the attachment is having values. If the attachment is empty, i should skip sending mail. I checked advance setting of tSendMail and found no options to do so. one option that comes to my mind is to load the output to a table and take count of the table and do a workaround.

is there any other option in talend??

Re: Trigger mail only if Attachment is not empty

manodwhb — Mon, 03 Dec 2018 05:53:14 GMT

@joe86,first read the file size by using tFileproperties and load the file size column into global map and connect to tFilesiproperties to tsendmail by trigger run if then check the file size of global map value.

Re: Trigger mail only if Attachment is not empty

joe86 — Mon, 03 Dec 2018 06:09:08 GMT

@manodwhb
can you please show me the flow??
tFilesiproperties -->tsetGlobalVariable-->tSendMail??
where should i give the "run if" trigger and where will i set the set the file size??

Re: Trigger mail only if Attachment is not empty

manodwhb — Mon, 03 Dec 2018 06:15:20 GMT

tFilesiproperties -->tsetGlobalVariable--> tigger run if-->tSendMail

Re: Trigger mail only if Attachment is not empty

joe86 — Mon, 03 Dec 2018 06:22:31 GMT

can you please confirm if below is correct?? any anything to be given inside the tSendMail component??

is the "key" and "value" been correctly declared??

Re: Trigger mail only if Attachment is not empty

Anonymous — Mon, 03 Dec 2018 06:27:40 GMT

@joe86

Could you please show the content of your if clause? Click on that if condition and you can see the condition in the component tab.

If you have not added, that's the place you need to add the details.

Warm Regards,

Nikhil Thampi

Re: Trigger mail only if Attachment is not empty

manodwhb — Mon, 03 Dec 2018 06:31:59 GMT

@joe86,that is correct you need to know that if you do not have the data in file what was the and if you have minimum data in a file what was the size and based on that you need to give the if condition in the run if.

Re: Trigger mail only if Attachment is not empty

manodwhb — Mon, 03 Dec 2018 06:33:32 GMT

@joe86,in the value of global ma you should specify the row2.size .

Re: Trigger mail only if Attachment is not empty

joe86 — Mon, 03 Dec 2018 06:43:58 GMT

@nikhilthampi @manodwhb

i couldnt open the "if" condition.

when i click on the "if" line connected to tSendMail, i dont get option to give the condition.

below is what happens when i double click.

Re: Trigger mail only if Attachment is not empty

Anonymous — Mon, 03 Dec 2018 06:54:05 GMT

@joe86

Please check the below screenshot.

Warm Regards,

Nikhil Thampi

Re: Trigger mail only if Attachment is not empty

joe86 — Mon, 03 Dec 2018 06:54:29 GMT

got the "if" condition component tab.

is the code correct?? or any java like code should be given here??

Re: Trigger mail only if Attachment is not empty

joe86 — Mon, 03 Dec 2018 06:55:17 GMT

jsut now saw that and then ur post

Re: Trigger mail only if Attachment is not empty

Anonymous — Mon, 03 Dec 2018 07:00:26 GMT

You can check the if based on the global variable. It will be more appropriate.

Warm Regards,

Nikhil Thampi

Re: Trigger mail only if Attachment is not empty

joe86 — Mon, 03 Dec 2018 07:28:55 GMT

@nthampi & @manodwhb

thanks a lot to both of you. All ideas of yours are working. but problem in my side is,

the file size is not getting low if the data is available or not.

Actually, if the output is zero, only the "headers" will be available in the output file and size is 4kb.

If 4 rows are returned, then too the the size is 4kb. Only when 5 rows are returned, then i get size as 5kb.

I tried below option:

Select "Don't generate empty file" in the output file and

Select "Die if attachment file does not exist" in tSendMail.

Since i am using tLogCatcher, I will not be able to use above two options either.

any other options you both have other than checking file size or any ways??

Re: Trigger mail only if Attachment is not empty

manodwhb — Mon, 03 Dec 2018 07:31:09 GMT

@joe86,better to go with .txt or .csv file,so you can easily,identify the file size.

Re: Trigger mail only if Attachment is not empty

joe86 — Mon, 03 Dec 2018 10:09:57 GMT

@nthampi & @manodwhb

as told, i took another output as ".csv" file (just to check the size of my output file) and gave the flow as below:

and in tSetGlobalVar, i gave Key as "K1" and value as "row2.size". And in the "if" component I gave as "globalMap.get("K1") > 0".

But i got error as below:

"The operator > is undefined for the argument type(s) Object,int"

can you please help me on this fix??

Note: The tLogRow jobs are given just to check if the tSetGlobalVar produces output as required.

Re: Trigger mail only if Attachment is not empty

manodwhb — Mon, 03 Dec 2018 10:16:21 GMT

@joe86,use this.

((Integer)globalMap.get("K1")) > 0

Re: Trigger mail only if Attachment is not empty

joe86 — Mon, 03 Dec 2018 10:24:09 GMT

got below error:

below is the value given in tSetGlobalVar:

is this correct? Not sure, where am i making wrong.

Re: Trigger mail only if Attachment is not empty

joe86 — Mon, 03 Dec 2018 11:58:00 GMT

@nthampi @manodwhb

after giving the "if" condition as ((int)globalMap.get("K1"))>0, i am getting below error.

java.lang.ClassCastException: java.lang.String cannot be cast to java.lang.Integer

any idea about this??

Re: Trigger mail only if Attachment is not empty

manodwhb — Mon, 03 Dec 2018 12:09:25 GMT

@joe86,row2.size not needed in single or double quotes.