topic Re: Attach multiple documents using tsendmail in Talend Studio

Attach multiple documents using tsendmail

sbhadra — Sat, 16 Nov 2024 02:24:22 GMT

Hi All,

I have a query which will pull in some physical paths which is present in a database table. Along with that I need to replace the filename as well. Let say for eg:-

The path is

/data/media/10000234.csv

The original name of the file is hello.csv. I need to replace this 10000234 with hello. Secondly there can be additional paths which would be pulled in from the query and they would have some different filenames.

So, in this scenario I would like to get all the files which may be present in various locations replaced with their filenames and attach to a single email.

Please suggest

Re: Attach multiple documents using tsendmail

TRF — Tue, 19 May 2020 09:40:30 GMT

I strongly suggest you to move all required files into a temporary folder, then attach the folder to email (instead of attaching all single files).

Re: Attach multiple documents using tsendmail

sbhadra — Wed, 20 May 2020 09:11:10 GMT

Hi TRF,

Please suggest if we attach a folder will it send a single email or it will send multiple emails?

Re: Attach multiple documents using tsendmail

TRF — Wed, 20 May 2020 10:01:01 GMT

1 email with multiple attachments

Re: Attach multiple documents using tsendmail

Anonymous — Wed, 20 May 2020 10:49:41 GMT

Did you click the plus button to add as many lines as needed where you can put filemask or path to the file to be sent along with the mail? Is there any error when option "Die if the attachement file doesn't exist" is checked out? mcdvoice login

Re: Attach multiple documents using tsendmail

TRF — Wed, 20 May 2020 22:25:57 GMT

@Lawson, this works only if you can predict which files will be there for attachement.
Else you need to attach a folder if you want 1 email with multiple attachements.

Re: Attach multiple documents using tsendmail

TRF — Sat, 23 May 2020 10:08:41 GMT

Did this help? If so, thanks to mark your case as solved (Kudo also accepted)

Re: Attach multiple documents using tsendmail

aminegac — Fri, 04 Dec 2020 15:47:16 GMT

@Fred Trebuchet HI great solution , i already thougth about moving specific files to temporary folder to avoid main folder uneccessary files , but is it possible like Lawson said to write a mask inside tsendMail component?? because i only see mask in tFileList for exemple but in tmailSend there is no place to write the mask in it .so how can we mention the mask ??