topic Re: Send file with dynamic file name though tSendmail in Talend Studio

Send file with dynamic file name though tSendmail

Anonymous — Wed, 20 Jun 2018 21:00:04 GMT

Hi,

Can someone advise me below? Thank you so much!

I am trying to use tSendmail component to send file with current date. I put below in tsendmail file attachment -

"C:/Users/....../E106_Error_report_"+TalendDate.formatDate("yyyyMMddHHmmss",TalendDate.getCurrentDate())+".US.DWLOGN"

and I got below error -

Re: Send file with dynamic file name though tSendmail

TRF — Wed, 20 Jun 2018 21:40:18 GMT

Are you sure the file exists before you try to send it? Can you share your job design?

Re: Send file with dynamic file name though tSendmail

Anonymous — Wed, 20 Jun 2018 21:47:15 GMT

Hi,

Please see below. I successfully run the report but not good through tsendmail component

Re: Send file with dynamic file name though tSendmail

Anonymous — Thu, 21 Jun 2018 02:10:51 GMT

The E106_US is the file you are attempting to send via email correct? IF so. Connect the tsendmail to the E106_US file Use a OnSub or ONComp to connect.

Re: Send file with dynamic file name though tSendmail

TRF — Thu, 21 Jun 2018 08:26:02 GMT

Regarding the job design, it should looks like this to be clearer:

Now, why it doesn't work, this is the question.

In your 1rst post you said you use TalendDate.formatDate("yyyyMMddHHmmss",TalendDate.getCurrentDate()) to construct the filename in tSendMail.

As "ss" changes every second (!!!) you probably have a different filename between tFileOutputDelimited and tSendMail.

To avoid this kind of mistake, I suggest you to use a global or context variable to define the filename and filepath.

Re: Send file with dynamic file name though tSendmail

Anonymous — Fri, 22 Jun 2018 14:46:08 GMT

Thanks! Your advice is very helpful! - after I delete "ss" and tsendmail worked.

I am also learning on creating global variable/context variable. Can you please educate me what global variable means? can't find explanation and not know how to do

Re: Send file with dynamic file name though tSendmail

TRF — Fri, 22 Jun 2018 14:53:56 GMT

https://help.talend.com/reader/JdTBzKszzXoWvjpEJD3EBA/rpFV93Uc4LKksvXQFtSdWg