topic Re: Extract excel attachments from email in Talend Studio

Extract excel attachments from email

Anonymous — Wed, 13 Jan 2016 22:02:30 GMT

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.

Re: Extract excel attachments from email

Anonymous — Thu, 14 Jan 2016 08:20:22 GMT

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

Re: Extract excel attachments from email

Anonymous — Thu, 14 Jan 2016 17:32:18 GMT

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

Re: Extract excel attachments from email

Anonymous — Fri, 15 Jan 2016 07:13:12 GMT

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

Re: Extract excel attachments from email

Anonymous — Fri, 15 Jan 2016 17:23:35 GMT

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.

Re: Extract excel attachments from email

Anonymous — Mon, 18 Jan 2016 06:54:17 GMT

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