topic Re: Unable to send mail for file not exists in Talend Studio

Unable to send mail for file not exists

Anonymous — Sat, 16 Nov 2024 08:14:07 GMT

Hi Guys

I am new to Talend.Please help me out to solve my issue

I have multiple files in FTP server(xlsx).

Now i need to send a mail if file not exists. if file is present i need to run my job.

i used two if conditions, but that is working in opposite direction

xlsx file exists(FTP)- it is sending mail

csv file not exists(FTP) - it is sending mail.

tftpfileexist_1 ----if (order:1) !((Boolean)globalMap.get("tFTPFileExist_1_EXISTS")) --sendmail

tftpfileexist_1 ----if (order:2) ((Boolean)globalMap.get("tFTPFileExist_1_EXISTS")) ---job has to run

Re: Unable to send mail for file not exists

manodwhb — Wed, 23 May 2018 07:12:43 GMT

@Lakshmi2411,i have tested below one is working as expected.use below way.

((Boolean)globalMap.get("tFileExist_1_EXISTS"))==true

((Boolean)globalMap.get("tFileExist_1_EXISTS"))==false

Re: Unable to send mail for file not exists

manodwhb — Wed, 23 May 2018 07:34:02 GMT

@Lakshmi2411,still are you facing the issue?

Re: Unable to send mail for file not exists

Anonymous — Wed, 23 May 2018 08:40:52 GMT

Hi
Plese help me out.
Even Though file exists is is send mail..
Here I am using File list,so that it can retrieve multiple files with xlsx exists or not .

MultipleFileslist.PNG

Re: Unable to send mail for file not exists

manodwhb — Wed, 23 May 2018 08:43:11 GMT

@Lakshmi2411,since you can use tFilelist,but you need to iterate the flow.check the below way.

Re: Unable to send mail for file not exists

Anonymous — Wed, 23 May 2018 08:51:09 GMT

-Finaally i have to achieve if files with xlsx it has run the job
if files are not present with xlsx it has send mail.
-can't we achieve my scenario with this condition.
-((Integer)globalMap.get("tFTPFileList_1_NB_FILE"))==0

Re: Unable to send mail for file not exists

manodwhb — Wed, 23 May 2018 09:22:44 GMT

@Lakshmi2411,

you can do the below way that

((Boolean)globalMap.get("tFileExist_1_EXISTS"))==true && ((Integer)globalMap.get("tFTPFileList_1_NB_FILE"))>0

Re: Unable to send mail for file not exists

manodwhb — Wed, 23 May 2018 10:25:33 GMT

@Lakshmi2411,still do you have issue?

Re: Unable to send mail for file not exists

Anonymous — Wed, 23 May 2018 11:55:42 GMT

Got it.Tnks.

I wrote ((Integer)globalMap.get("tFileList_1_NB_FILE"))<0

it got worked.

Re: Unable to send mail for file not exists

manodwhb — Wed, 23 May 2018 11:58:29 GMT

@Lakshmi2411,you were wellcome.Please provide Kudos also.