Good evening!
Does anyone know how to import email attachments through Pentaho Data Integration (Spoon)?
I can read all the fields of the email and characteristics of the Annex, but the attachment can not import.
I need to read the subject of the email and record the attachment if you have.
Thanks.
Import email attachments with p.d.i (spoon)
- dr_gori
- Moderador
- Posts: 5024
- Joined: Mon, 03 May 2004 3:08 pm
- Location: Portland, OR USA
- Contact:
Thomas F. G
Você já respondeu a dúvida de alguém hoje?
https://glufke.net/oracle/search.php?search_id=unanswered
Você já respondeu a dúvida de alguém hoje?
https://glufke.net/oracle/search.php?search_id=unanswered
I do not know the PDI right, but I read something that the input email can not download the attachment.
You have to use the Entry Get Mails Job (POP3 / IMAP) for this and then Transformation.
You have to use the Entry Get Mails Job (POP3 / IMAP) for this and then Transformation.
Good afternoon.
After I opened the topic here, I saw that it should be through Job.
Well, I did the job and now you're doing a part of what I need, that is, you're reading the emails, download the attachments and I'm moving emails read to another folder inside Outlook.
The next step I need is to get this email title and record in a table, along with your appropriate attachments. Then you curled the business ...
Attachment I put the routine I created. Anyone who wants to collaborate with tests just import the Spoon, configure the e-mail server, user password and name of Outlook folders.
Thanks.
After I opened the topic here, I saw that it should be through Job.
Well, I did the job and now you're doing a part of what I need, that is, you're reading the emails, download the attachments and I'm moving emails read to another folder inside Outlook.
The next step I need is to get this email title and record in a table, along with your appropriate attachments. Then you curled the business ...
Attachment I put the routine I created. Anyone who wants to collaborate with tests just import the Spoon, configure the e-mail server, user password and name of Outlook folders.
Thanks.
- Attachments
-
- GeraArquivoAssuntoEmail.xml
- (19.82 KiB) Downloaded 551 times
- dr_gori
- Moderador
- Posts: 5024
- Joined: Mon, 03 May 2004 3:08 pm
- Location: Portland, OR USA
- Contact:
Thomas F. G
Você já respondeu a dúvida de alguém hoje?
https://glufke.net/oracle/search.php?search_id=unanswered
Você já respondeu a dúvida de alguém hoje?
https://glufke.net/oracle/search.php?search_id=unanswered
It cost.
If you can do, send us the solution here.
Unfortunately I do not have Spoon to test here.
If you can do, send us the solution here.
Unfortunately I do not have Spoon to test here.
In fact at the PDI installation itself has many examples (..Data-Integration \ Samples \ ...) and I am looking for all the steps I need.
In any case, when you have completed and reach my goal, I place the solution here.
Thanks
In any case, when you have completed and reach my goal, I place the solution here.
Thanks
Good Morning!
I was able to achieve my goal that was to read email and record registration on a database with the subject of the email and attachment if you have.
Attachment are the transformation files and the job.
Whoever is used for testing, must review the Database Fields (Host, Bank, Schema, User, Table) and also the mailbox data, e-mail server name, user password.
Note: An important detail in my process was to define that you should read 1 email at a time. This can be configured in the fields that refer to e-mail (Message Input and Get Mails) on the "Retrieve The First Email" property in IMAP Settings.
Job runs once every minute.
Thanks for the support.
I was able to achieve my goal that was to read email and record registration on a database with the subject of the email and attachment if you have.
Attachment are the transformation files and the job.
Whoever is used for testing, must review the Database Fields (Host, Bank, Schema, User, Table) and also the mailbox data, e-mail server name, user password.
Note: An important detail in my process was to define that you should read 1 email at a time. This can be configured in the fields that refer to e-mail (Message Input and Get Mails) on the "Retrieve The First Email" property in IMAP Settings.
Job runs once every minute.
Thanks for the support.
- Attachments
-
- LerGravarEmail.zip
- GravarTabela
- (8.69 KiB) Downloaded 607 times
-
- Information
-
Who is online
Users browsing this forum: No registered users and 10 guests