topic configuring the email component in Talend Studio

configuring the email component

sushantk19 — Sat, 16 Nov 2024 01:34:41 GMT

Hello All,

I have to configure tSendMail email component. I have to check if value is changing in one of the reference tables.

if yes, then send email to customer.

how to configure

tSendMail component for the 1st time? what values do i give in SMTP port, SMTP host, username and password?

I am using this component for the 1st time, Can someone please guide me?

Re: configuring the email component

Anonymous — Fri, 28 Aug 2020 08:51:38 GMT

Hello,

Here is online component reference about: TalendHelpCenter: tSendMail

Let us know if it helps.

Best regards

Sabrina

Re: configuring the email component

sushantk19 — Fri, 28 Aug 2020 12:10:07 GMT

@Xiaodi Shi : thanks for your input. But, can you tell me what should i put for below SMTP configurations:

SMTP Host:

SMTP Port: should it be 25?

Username:

Password:

I need this information to create an email task for DW project.

Re: configuring the email component

root — Fri, 28 Aug 2020 14:18:41 GMT

These are standard properties that the relevant team can provide.

You need to work with your Email provider/ IT team for these details. HTH

Re: configuring the email component

Anonymous — Mon, 31 Aug 2020 07:25:48 GMT

Hello,

SMTP Port must be 25 which is commonly used and host will be your official mail server's IP or host name.

What's your mail server? Gmail or Outlook?

Best regards

Sabrina

Re: configuring the email component

sushantk19 — Mon, 31 Aug 2020 08:54:51 GMT

it is Outlook.

Re: configuring the email component

Anonymous — Tue, 01 Sep 2020 09:17:46 GMT

Hello,

Here are the parameters settings I am using tSendMail to connect with office365.

Re: configuring the email component

sushantk19 — Fri, 04 Sep 2020 11:09:56 GMT

Hello All,

Thanks for your response. the email functionality is working fine now.

However, need a small input. I want to send only 1 email for all my error records. Presently if there are 500 error records in my file, the job sends 500 emails :(. but it should send just 1 email with 500 records as Attachement( Attachement is working fine in existing job). is there a option/setting for this in email job?

Re: configuring the email component

Anonymous — Mon, 07 Sep 2020 08:31:34 GMT

Hello,

Could you please upload your job design screenshots on community? Are you using tsendmail component as a subjob with OnSubjobOK connector?

Best regards

Sabrina

Re: configuring the email component

sushantk19 — Wed, 09 Sep 2020 11:56:09 GMT

I have attached my job screenshot. Yes I am using tsendmail component in my job. No, its not with OnSubjobOK connector. I just connected my input file with this tsendmail component. please suggest how to control the no of emails. it is flooding my inbox.

Re: configuring the email component

Anonymous — Thu, 10 Sep 2020 08:00:08 GMT

Hello,

You need use onsubjobok connector to trigger your email when your job is successful.

Create job as follow.

input(get/read error records ) --> tFileOutputxxx(save 500 error records)

OnSubjobOk

tSendMail

Here is online documentation about: TalendHelpCenter: Connection Type

Hope it will be helpful for your further job.

Best regards

Sabrina

Re: configuring the email component

sushantk19 — Thu, 10 Sep 2020 12:06:08 GMT

@Xiaodi Shi : Thanks for your inputs. It is working fine now.

Re: configuring the email component

sushantk19 — Tue, 29 Sep 2020 08:27:21 GMT

Yes, now there is a requirement that it should send an email only when it has some data. Presently, my file is generated just with the header as "SKU". I have read about handling this using " Run If" option in trigger. What should i give in If condition? my requirement is that the email should be sent only when there is some value in file except for the header.