topic Re: extract email attachments from mail in Talend Studio

extract email attachments from mail

Anonymous — Sat, 16 Nov 2024 13:28:12 GMT

i normally receive excel based email attachments from a predefine email. how do i extract the attachments only and store them in a folder. i can connect to the email server using talend and can download the emails. but i only want to extract the excel attachments.

Re: extract email attachments from mail

Anonymous — Thu, 08 Apr 2010 16:15:22 GMT

Hi;
You'll see an example of a Job wich POP the email on a local location and then iterate on it to extract the Attached document (Excel files).
Then if you need to parse each Excel files, use another SubJob and tFileList on the Excel files location and iterate on the tFileInputExcel component.
Best regards;

Re: extract email attachments from mail

_AnonymousUser — Tue, 03 May 2011 20:20:27 GMT

Hi
I was unable to even retrieve the emails Can some one please help me with this.
Thanks
Anji

Re: extract email attachments from mail

Anonymous — Wed, 04 May 2011 16:41:35 GMT

what error did you get? Does it specify anything is wrong with your connection settings?

Re: extract email attachments from mail

Anonymous — Mon, 23 May 2011 22:48:37 GMT

I am using the same logic to retrieve all attachments from my email server. I can see the emails are getting downloaded but only one attachments is getting extracted (oldest date attachment is getting extracted), and that too, the extracted file is empty!! I am connecting to gmail server and my aim is to download all attachments from emails on a local drive. I am using imap protocol with 993 port and SSL included.
I am getting below error but the emails are getting fetched too! without all attachments.
Exception in component tFileInputMail_1
java.io.IOException: Error in encoded stream: needed 4 valid base64 characters but only got 2 before EOF, the 10 most recent characters were: "AAAAPgADAP"
at com.sun.mail.util.BASE64DecoderStream.decode(BASE64DecoderStream.java:237)
at com.sun.mail.util.BASE64DecoderStream.read(BASE64DecoderStream.java:135)
at java.io.BufferedInputStream.fill(Unknown Source)
at java.io.BufferedInputStream.read(Unknown Source)
at talenddemosjava.readthroughemail_0_1.ReadThroughEmail.tFileList_1Process(ReadThroughEmail.java:809)
at talenddemosjava.readthroughemail_0_1.ReadThroughEmail.tPOP_1Process(ReadThroughEmail.java:390)
at talenddemosjava.readthroughemail_0_1.ReadThroughEmail.runJobInTOS(ReadThroughEmail.java:1061)
Ignore the part text/html; charset=ISO-8859-1
Ignore the part text/html; charset=ISO-8859-1
at talenddemosjava.readthroughemail_0_1.ReadThroughEmail.main(ReadThroughEmail.java:932)
disconnected
Below are the properties of my intputFileEmail component:
filename: ((String)globalMap.get("tFileList_1_CURRENT_FILEPATH"))
Mail Parts: I have included 2 fields- "name" and "body"
Attachment path: correctly given
Appreciate help from anyone!

Re: extract email attachments from mail

Anonymous — Tue, 14 Aug 2012 08:08:46 GMT

Why not download the files just manually? This is just a 1-time download I would say..

Re: extract email attachments from mail

_AnonymousUser — Tue, 25 Sep 2012 12:04:19 GMT

from here you can get solution to extract the attachments from emails. i am using the product to backup my attachments in emails and it works amazingly. The owner also provide free support so you can discuss your problem as well, if not resolving. take a trial.

Re: extract email attachments from mail

jagadish_dasari — Thu, 09 Jan 2014 12:32:24 GMT

xanworld,
Please check the mail parts you have included.
I don't think there is any "name" in the mail part.
If you are looking for sender use "From", receiver use "Received"
Thanks,
Jagadish.

Re: extract email attachments from mail

Anonymous — Sat, 06 Dec 2014 23:45:17 GMT

Hello there,
I am facing a similar issue. I need to connect to an outlook mail server and download email attachments on a daily basis. Does the tPop component support this?
Can you please share how you managed to extract email attachments and moved it to a local folder?
Thanks,
Hema

Re: extract email attachments from mail

Anonymous — Mon, 08 Dec 2014 03:49:40 GMT

Hi Hema,
Here is a response in your another topic: https://community.talend.com/t5/Design-and-Development/component-for-extracting-excel-or-text-attachments-from-email/td-p/71793. Could you please take a look at it?
Best regards
Sabrina

Re: extract email attachments from mail

Anonymous — Sat, 03 Jan 2015 21:33:00 GMT

Hello Sabrina,
Can you please share some examples of how tFileInputMail is used to extract attachment?
Thanks,
Hema

Re: extract email attachments from mail

Anonymous — Sun, 04 Jan 2015 09:21:48 GMT

Hi,
You can set basic settings of tFileInputMail as:
Collumn Mail part
SUBJECT SUBJECT
ATTACHMENT ATTACHMENT to extract email attachment.
The work flow should be:tPop --> tFileInputMail
Let us know if it is OK with you.
Best regards
Sabrina

Re: extract email attachments from mail

Anonymous — Fri, 04 Mar 2016 16:46:45 GMT

Hi,
Can some body explain step by step procedure to extract attachment. I need to extract email attachment monthly and put in FTP server for reference.

Re: extract email attachments from mail

_AnonymousUser — Thu, 28 Apr 2016 19:55:54 GMT

Hi
requirement: Need to track email sent whether email is opened or not with some other parameter data
email Id, sent date , open date, subject line
What is the best procedure to capture email tracking count data.
I found something online "{img src="..."/.}" . Can I add HTML code in tsendMail component. Is there any other way to capture email tracking count ?

Re: extract email attachments from mail

Anonymous — Mon, 13 Jun 2016 14:39:51 GMT

How can I pass the email names from the Tpop component to the Tfileinputmail ??

Re: extract email attachments from mail

Anonymous — Tue, 14 Jun 2016 10:23:20 GMT

Hi,
You can set basic settings of tFileInputMail as:
Collumn Mail part
SUBJECT SUBJECT
to read email subject in tifileinputmail.
Here is the component reference:TalendHelpCenter:tFileInputMail
Best regards
Sabrina