topic Re: tfileinputmail attachments with same filenames in Talend Studio

tfileinputmail attachments with same filenames

AndreK — Sat, 21 Mar 2020 14:59:17 GMT

Dear experts,

I have to download the mail(imap) and extract the attachments: tpop --(iterate)-> tfilelist--(iterate)>tfileInputMail it is working.

But now I have an issue, if the mail includs multiple attachments with the same filename (123.pdf and 123.pdf).

By downloading last file overwrite the first file.

How can I resolve this issue ?

Re: tfileinputmail attachments with same filenames

manodwhb — Sun, 22 Mar 2020 07:37:29 GMT

Yes it will override, so you need to rename the file after tfileinput mail component use tfilecopy component.

Re: tfileinputmail attachments with same filenames

AndreK — Sun, 22 Mar 2020 11:33:49 GMT

Thank you for your quick reply.
But unfortunately if I'm using:
tFileInputMail--Main-->tFileList --> then it would be already overwirte
tFileInputMail--On Component Ok-->tFileList --> then it would be already overwirte
tFileInputMail--Iterate->tFileList --> then it would be already overwirte and it doesn't trigger the next component

How can I trigger next component after the download of the first attachment ?

Re: tfileinputmail attachments with same filenames

manodwhb — Mon, 23 Mar 2020 03:15:14 GMT

After tfileinputmail ,can you connect tfilecopy and try to rename,check that is that working.

Re: tfileinputmail attachments with same filenames

AndreK — Mon, 23 Mar 2020 07:55:40 GMT

which filename I can use in this case ?

If I connect tfileinputmail -->tFileList-->tfilecopy then the file will be overwritten.

tFileInputMail.jpg

Re: tfileinputmail attachments with same filenames

manodwhb — Mon, 23 Mar 2020 12:31:14 GMT

Check the file name which you're downloading as a global variable in the tfileiputmail.

Re: tfileinputmail attachments with same filenames

AndreK — Tue, 24 Mar 2020 22:23:48 GMT

how or where I can do this ?

Re: tfileinputmail attachments with same filenames

AndreK — Thu, 26 Mar 2020 08:06:28 GMT

Does anyone have a solution ?

Re: tfileinputmail attachments with same filenames

Anonymous — Thu, 26 Mar 2020 08:14:45 GMT

Unless you modify the source code of tFileInputMail, I am afraid there is no other solution.

Regards
Shong

Re: tfileinputmail attachments with same filenames

AndreK — Thu, 26 Mar 2020 09:42:18 GMT

does talend have other components that can be used to extract the attachment ?

Re: tfileinputmail attachments with same filenames

Anonymous — Fri, 27 Mar 2020 18:25:31 GMT

@Andre, no other component can export attachment from an email, I am not sure if this situation can be consider as a bug or not, you can open a jira issue on our bugtracker to our R&D team, or modify the source code of component if you are a Java developer.

Regards
Shong

Re: tfileinputmail attachments with same filenames

AndreK — Mon, 30 Mar 2020 16:01:56 GMT

ok, thank you for your reply.

I have opened a new jira bugtracker for this issue.

Re: tfileinputmail attachments with same filenames

pyzhou — Wed, 01 Apr 2020 15:09:54 GMT

I think there a way to solve this by storing attachments in separate folders.
By set the flow variable ((String)globalMap.get("tFileList_1_CURRENT_FILE")) as part of attachment export folder.

Re: tfileinputmail attachments with same filenames

Anonymous — Wed, 01 Apr 2020 17:54:49 GMT

@pyzhou, the problem is the mail has two attachments or more with the same name, not that different mails have attachment with the same name.

Re: tfileinputmail attachments with same filenames

AndreK — Wed, 01 Apr 2020 19:38:05 GMT

@pyzhouIn your case each attachment of one mail will be saved in the folder.

In my case I have one mail with two attachments with same name. By downloading the last attachment will overwrite the first one.