Do not input private or sensitive data. View Qlik Privacy & Cookie Policy.
Skip to main content

Announcements
Qlik Open Lakehouse is Now Generally Available! Discover the key highlights and partner resources here.
cancel
Showing results for 
Search instead for 
Did you mean: 
Anonymous
Not applicable

component for extracting excel or text attachments from email

hello there,
newbie here! I would like to know how to extract attachments from an email.
I managed to establish a connection with the tPop component and fetch the emails to a folder on my computer. Does this downloaded email contain the attachment too? Or does it have only the email sender, receiver info and the body of the email?
I would like to know how to extract email attachments specifically text and excel (.csv) files. please help.
Thanks,
Hema
Labels (2)
10 Replies
Anonymous
Not applicable
Author

Hi,
You can use tPOP component to fetch mail and tFileInputMail to export attachments.
Best regards
Sabrina
Anonymous
Not applicable
Author

Hi 
    Can you explain step by step procedure to extract email attachment using tpop and tFileInputMail components. I couldn't find any information in the respective tpop or tFileInputMail pages
Thanks,
Sarotham
Anonymous
Not applicable
Author

Hi Sarotham,
We have replied to your another topic: https://community.talend.com/t5/Design-and-Development/Email-attachment-extract-into-FTP-server/td-p...
Could you please take a look at it?
Best regards
Sabrina
Anonymous
Not applicable
Author

Hi 
   I will be getting monthly email attachment files from same standard email id  with the same subject line .  Is there any option available to filter only unread files in TPOP
Anonymous
Not applicable
Author

Hi,
So far, tPOP component just specify mail folder, such as "INBOX", "SEND" but not the messages that have not already been marked as "Read".
Are your "Unread" messages saved in a separate folder?
Best regards
Sabrina
Anonymous
Not applicable
Author

Thank you. 
  I can able to process email attachment. I have some other problem with tpop.
   In My case, I get weekly files from specific email id and subject line. But I should only read latest files. Is there option available in tpop to mark file as read. So I can read only unread files. I didn't find any such option in tpop advance setting.
Is there any other to integrate tpop advance setting to do read and unread functionality ?
Any other option available to send all read files to other Folder in email , like INBOX to ARCHIE (custom folder created to drop all old files)?
Anonymous
Not applicable
Author

I can read monthly files to update DW. I should read only latest month file. But, with the same subject line and  From email ID as filter condition, It can read other old files too.
Is there any way I can read only latest  files using tpop any other talend component without accessing previous month files? 
Anonymous
Not applicable
Author

How to extract 10 email id's attachement using tpop at the same time
I specified "X@gmail.com;Y@gmail.com" which doesn't work. Is there any other way  to extract .mail file from INBOX with 10 different email ID and same subject line ?
Anonymous
Not applicable
Author

Hi,
Do you want to retrieve emails from serveral user's Inboxs? 
So far, the tPOP component is just used to connect to a specific email server.
Feel free to create a workitem/ new feature jira issue on Talend Bug Tracker.
Best regards
Sabrina