topic Send Email with Attachment in Talend Studio

Send Email with Attachment

Jennifer_siders — Fri, 15 Nov 2024 23:59:15 GMT

Hello All,

We have a simple requirement to pick a file from a folder and send it as an email attachment. Once the email with the attachment is sent, then we would like to move the file to a different location using 'tFileCopy' . My problem, is I only get emails without an attachment first, and later on, on an intermittent basis receive one more email with an attachment.

tFIleList ---> tSendEMail

If condition to trigger email only when there is a file ((Integer)globalMap.get("tFileList_2_NB_FILE"))!=0

tSendEmail:

tFileCopy:

Re: Send Email with Attachment

gjeremy1617088143 — Fri, 02 Jul 2021 07:31:18 GMT

Hi,

TfileList-->iterate link -->tJava with this code: globalMap.put("filePath",(String)globalMap.get("tFileList_2_CURRENT_FILEPATH"));

followed by two trigger links

after the tjava one for send mail an other for file copy with this condition (String)globalMap.get("filePath") != null

and you use (String)globalMap.get("filePath") in the two components.

Maybe you don't need an itermediary variable (here filePath) and you can use (String)globalMap.get("tFileList_2_CURRENT_FILEPATH") everywhere.

Send me Love and Kudos

Re: Send Email with Attachment

Anonymous — Fri, 02 Jul 2021 07:33:32 GMT

Make sure the file is sent as attachment before it is removed, I would suggest you to move tFileCopy after tSendMail component, eg:

tFileList-iterate--tSendMail--oncomponentok--tFileCopy.

Re: Send Email with Attachment

Jennifer_siders — Fri, 02 Jul 2021 12:33:06 GMT

Hi @Shicong Hong Thanks it worked as a charm.

Re: Send Email with Attachment

Jennifer_siders — Fri, 02 Jul 2021 12:34:15 GMT

Thanks @guenneguez jeremy for the response. I couldn't try your solution, but has helped me for implementing a other requirement 🙂