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

Announcements
Qlik GA: Multivariate Time Series in Qlik Predict: Get Details
cancel
Showing results for 
Search instead for 
Did you mean: 
Anonymous
Not applicable

Extract excel attachments from email

Hello,
I am new to talend and building job to extract excel attachments from email body. below are screen shots of what I am doing. 
Job working fine but it is extracting .mail files from email and missing attachment. Any idea what wrong I am doing here.
Appreciate any help.0683p000009MGWA.png0683p000009MH1N.png0683p000009MGug.png0683p000009MH4a.png

Labels (2)
5 Replies
Anonymous
Not applicable
Author

Hi,
Could you please check your .mail files to see if these attachments are fetched from your email box? How did you set "file name" in tFileInputMail component?
Best regards
Sabrina
Anonymous
Not applicable
Author

Hi Sabrina,
I checked .mail files. I think it is extracting excel file in code format not as excel file. please refer attached image.
For testing I did manual file name setup for tFileInputMail component. I am giving .mail file as input to this component.
thanks
Ravi
Anonymous
Not applicable
Author

Hi,
Have you tried to use "Attachment" or "Content-disposition" in Mail part?
What's the build version you are using?
Best regards
Sabrina
Anonymous
Not applicable
Author

Hi,
I am using attachment in mail part, i tried using document, object in type none of those options working. I am using 6.0.1 version.
Anonymous
Not applicable
Author

Hi,
Not sure that your excle attachment is broken when retrieving them from Email Inbox. Would you mind sending a .mail file to us for a testing? I made a testing on .csv attachment, it works.
Best regards
Sabrina