topic Re: Attachments in tSendMail in Talend Studio

Attachments in tSendMail

Nicolas661 — Fri, 05 Jul 2013 15:30:51 GMT

Hi,
I try to make a job:
Read Directory----Iterate---> Send a mail with attachments (all docs read in directory)

I try with:
tFileList-->tSendMail with the value " ((String)globalMap.get("tFileList_1_CURRENT_FILEPATH"))" in attachment
The result is: X files send X mails with attachment.
All documents are not in only 1 mail

Nicolas
PS: I'm beginner in Talend DI
Nicolas

Re: Attachments in tSendMail

Loneliness — Fri, 05 Jul 2013 16:42:12 GMT

It's normal because an Iterate" connection between the 2 components means that tSendMail will be triggered once for each file in that folder.
The first solution i can suggest is to use a tFileArchive component to zip your files, connect it to tSendMail component with the OnSubjobOk trigger and in the Attachment section, you will type: ((String)globalMap.get("tFileArchive_1_ARCHIVE_FILEPATH")) as the attached file.
This way you will send only one email with all your files.
Regards
AH.

Re: Attachments in tSendMail

alevy — Sun, 07 Jul 2013 13:59:26 GMT

I believe you can just use a filemask in tSendMail i.e. you don't need tFileList at all.

Re: Attachments in tSendMail

Nicolas661 — Mon, 08 Jul 2013 08:07:10 GMT

The 2 solutions are avalaible:
The first (with TfileArchive): Connect the tfileArchive to tSendMail
In the attachment file: ((String)globalMap.get("tFileArchive_2_ARCHIVE_FILEPATH"))
The second:Just add the directory of files in the attachments
Thank you alevy & cheaito

Re: Attachments in tSendMail

Anonymous — Mon, 08 Jul 2013 08:32:44 GMT

Hi,
Actually, so far tsendmail only support for file mask with a directory without filter on file type. That means "D:/folder2/" is OK not "D:/folder2/*.txt".
Best regards
Sabrina

Re: Attachments in tSendMail

Anonymous — Fri, 15 Nov 2013 16:53:53 GMT

Could we have an inline attachment in message body instead of attachment section using tsendmail component ?

Re: Attachments in tSendMail

Anonymous — Mon, 18 Nov 2013 03:27:02 GMT

Hi,

Could we have an inline attachment in message body instead of attachment section using tsendmail component ?

For the inline attachment in message body, could you give more information and elaborate your case with an example to us?
Best regards
Sabrina

Re: Attachments in tSendMail

Anonymous — Mon, 18 Nov 2013 03:50:04 GMT

Well example could be as simple as any .tsv / .csv report that is generated with header and data already available in some location and we would like to have them displayed in the body instead of as an attachment.

Re: Attachments in tSendMail

Anonymous — Mon, 18 Nov 2013 06:27:20 GMT

Hi,

Well example could be as simple as any .tsv / .csv report that is generated with header and data already available in some location and we would like to have them displayed in the body instead of as an attachment.

It seems you want to put the .tsv / .csv file/file path in Message Body of tsendmail?
Best regards
Sabrina

Re: Attachments in tSendMail

Anonymous — Mon, 18 Nov 2013 06:33:23 GMT

Yes , with the content (not just the file name / path ) . If it's not something supported i would really appreciate work arounds ?

Re: Attachments in tSendMail

Anonymous — Mon, 18 Nov 2013 07:09:19 GMT

Hi,
Actually, the message body can accept "String" type.
You can paste attachment content into message body, however, it cannot be marked as "attachment" auto instead being a part of message.
Is there any trouble of "Attachment" section in tSendMail for you?
Best regards
Sabrina

Re: Attachments in tSendMail

Anonymous — Sat, 10 Sep 2016 05:20:35 GMT

Hi Team,
How i can send attached mail in zip format.
Thanks
shrihdar

Re: Attachments in tSendMail

Anonymous — Wed, 08 Mar 2017 20:06:22 GMT

How do i give the file path here for tsendmail? its giving me error

Re: Attachments in tSendMail

vapukov — Wed, 08 Mar 2017 20:21:36 GMT

415061/mini_blob_20170308-1205.png
How do i give the file path here for tsendmail? its giving me error

"/" at the end of filename wrong

Re: Attachments in tSendMail

Anonymous — Wed, 08 Mar 2017 20:46:22 GMT

that is resolved. But its sending an empty file when it has to suppose send the data. Please see my job below:

Re: Attachments in tSendMail

vapukov — Thu, 09 Mar 2017 04:03:28 GMT

delete row9(main) and connect tSENDMail with DataLoad (source) by OnSubJobOk