Talend community forum / Save and Rename mail attachments

ponzio · 2012-01-27 14:57:10

Hi.
I need to download and rename mail attachments.
I'm daily receiving an email whose subjects contain the date while the attachment name is always the same.
I need to save the attachment and RENAME it with the mail subject.

Please help.

Many thanks, in advance,
Andrea

pedro · 2012-01-29 04:47:48

Hi Andrea

You can use tPOP component to fetch mail, use tFileInputMail to export attachments.
Then use tFileCopy to rename attachments.

Best regards,
Pedro

ponzio · 2012-01-30 08:52:26

Hi Pedro.
Thanks for your answer ....

Just a couple of questions:

1) using the tInputMail I've the problem that it overwrites the attachments file if I'm gettingm ore than one un-read email ...
a possibile workaround is to extract only one email anceh then using a LOOP to downaload all the emails...any other ideas ?

2) using the tFileCopy, how can I pass to it the email subject to compose the new attachment name ? (sorry but I'm very new using Talend)

Thanks,
Andrea

pedro · 2012-01-30 09:21:35

Hi Andrea

1)
You can set "Attachment export directory" of tFileInputMail like this to avoid overwriting.

Code:

"E:/Attachment/"+context.sequence+"/"                   //context.sequence will be increased by tJava(context.sequence++)

Export each attachment into an unique directory.
2) You can set "Mail parts" of tFileInputMail as follows. Then extract this field into a variable.

Code:

Column   Mail part
Object     "Subject"

Regards,
Pedro

ponzio · 2012-01-30 10:05:13

1) You can set "Attachment export directory" of tFileInputMail like this to avoid overwriting.

Code:

"E:/Attachment/"+context.sequence+"/"                   //context.sequence will be increased by tJava(context.sequence++)

Ok, I'm going to try this ... but I'll nedd a way to give the exact name (related to the subject) to the proper directory attachment ...

2) You can set "Mail parts" of tFileInputMail as follows. Then extract this field into a variable.

Code:

Column   Mail part
Object     "Subject"

I did it .. I'm writing a csv file with the sender and subject of the downloaded emails ...
My problem is to pass the subject to che tCOPY.

Thanks,
Andrea

pedro · 2012-01-30 10:10:55

Hi Andrea

To pass the subject to tCopy.
You can create job as the following images with the csv file.

Regards,
Pedro

Uploaded Images

ponzio · 2012-01-30 10:44:20

It works !

Many many thanks

ponzio · 2012-01-30 14:26:28

Just another question ... is it possible to get the attachment name ?

Andrea

pedro · 2012-01-31 02:29:57

Hi

No. It's impossible to get the attachment name directly now.

Regards,
Pedro

st_germain · 2012-05-04 14:47:48

Hi, can you please explain exactly, how I can detach the attachments with tInputMail?
The original filename is in my case in the subject ...

pedro · 2012-05-07 04:30:19

Hi St_germain

tFileInputMail can detach attachments automatically if you offer correct path for "Attachment export directory".

Regards,
Pedro

Announcement

Unanswered posts

#1 2012-01-27 14:57:10

Save and Rename mail attachments

#2 2012-01-29 04:47:48

Re: Save and Rename mail attachments

#3 2012-01-30 08:52:26

Re: Save and Rename mail attachments

#4 2012-01-30 09:21:35

Re: Save and Rename mail attachments

Code:

Code:

#5 2012-01-30 10:05:13

Re: Save and Rename mail attachments

Code:

Code:

#6 2012-01-30 10:10:55

Re: Save and Rename mail attachments

#7 2012-01-30 10:44:20

Re: Save and Rename mail attachments

#8 2012-01-30 14:26:28

Re: Save and Rename mail attachments

#9 2012-01-31 02:29:57

Re: Save and Rename mail attachments

#10 2012-05-04 14:47:48

Re: Save and Rename mail attachments

#11 2012-05-07 04:30:19

Re: Save and Rename mail attachments

Board footer