I downloaded TalendOpenStudio 2.2.2 to evaluate if it can satisfy some of our business use cases.
I have a use case to pull emails from a pop3 server and insert them in a database table (table which has columns to store separate fields of emails such as "to email", "from email", content, header, subject etc). I found some samples which indicate that I can do this by using tPop node, which will dump the email in a file, and then I read email from file in a tFileInputMail node, which can then be connected to a tMssqlOutput node.
My use can also requires me to insert additional records in database, when an email is received (these records may not contain any data of the email received, but some other data).
However, I am a bit confused about how to map emails fields to database columns. Has anyone tried this before?
In addition to this, is there a way by which I can move email directly from tPop into one of databases, without storing the email in a file?
Any help is highly appreciated
Hi everyone,
I'm trying to use tPOP to extract the attachments from the latest email that was sent to me. When I ticked the box in tPOP settings "newer email first" and set the number of emails to retrieve to one, I expected to get the job done. However, Talend starts to read only with the second email from the top in this case. What should I do? Can someone help me out?
The mail box is on Microsoft office 365, I'm using imap protocol.
Thanks in advance,
Stanislav
