Talend community forum / Filter emails with subject and forward them

covenant13 · 2008-05-20 19:35:13

Hello,

I have 2 questions, how can I filter email with subject?
I have tPOP -->tFileInputMail-->tLogRow.
This receive all emails with attachments, but i want to receive only emails with subject: "2345345". How can i do it?

2 question is:
How can i forward received mails with attachments?

Thanks for reply.

shong · 2008-05-21 07:25:01

Hello

This receive all emails with attachments, but i want to receive only emails with subject: "2345345". How can i do it?

You can define only one column 'subject' and its mail part is "subject".

2 question is:
How can i forward received mails with attachments?

On tFileInputMail component, there is a attachment export directory.

Best regards

shong

covenant13 · 2008-05-23 17:15:43

Ok. I know this informations.

But how can I filter by subject? Is there any scheme to do this?

And about forwarding mails:
I know that scheme must be tPOP_1-->tFileInputMail_1-->tSendMail_1.

But what I should write in tSendMail in the field Subject?
If I write e.g. $tSendMail_1[1] it gives me an error.
I write in java.
Can somebody help me?

shong · 2008-05-26 04:23:06

Hello

Please see the screenshots.

Best regards

shong

Uploaded Images

covenant13 · 2008-05-26 21:29:55

Thank you shong, subject and CC is working fine, but e.g. body isn't working. It gives me error:

Exception in component tSendMail_1
java.lang.NullPointerException
at javax.mail.internet.MimeUtility.checkAscii(MimeUtility.java:1286)
at javax.mail.internet.MimeBodyPart.setText(MimeBodyPart.java:1023)
at javax.mail.internet.MimeBodyPart.setText(MimeBodyPart.java:718)
at javax.mail.internet.MimeBodyPart.setText(MimeBodyPart.java:702)
at msn.mail.mail.tPOP_1Process(mail.java:689)
at msn.mail.mail.runJobInTOS(mail.java:899)
at msn.mail.mail.main(mail.java:806)

How can I copy "body" and "attachments" to send mail?

shong · 2008-05-27 04:29:10

Hello

Exception in component tSendMail_1
java.lang.NullPointerException
at javax.mail.internet.MimeUtility.checkAscii(MimeUtility.java:1286)

I have tested the body part on TOS2.4.0RC2, I always get null value, it should a [Bugtracker, bug 3927, fixed] null value on body part.

I aslo tested it on TOS2.3.0, it works fine.

Best regards

shong

covenant13 · 2008-05-27 07:34:14

On some mails it works fine, on some i get this error. I'm working on ver 2.3.3.

shong · 2008-05-27 07:46:11

Hello

On some mails it works fine, on some i get this error. I'm working on ver 2.3.3.

If you work on TOS2.3.3, you can add a tMap component between tFileInputMail and tLogRow and deal with the null value on tMap, for example:
row1.body==null?"This is an empyt email":row1.body

Best regards

shong

Uploaded Images

covenant13 · 2008-05-27 17:09:56

Thanks.
I check this. It gives me the same error .

And what about attachments?

Last edited by covenant13 (2008-05-27 20:00:11)

Announcement

Unanswered posts

#1 2008-05-20 19:35:13

Filter emails with subject and forward them

#2 2008-05-21 07:25:01

Re: Filter emails with subject and forward them

#3 2008-05-23 17:15:43

Re: Filter emails with subject and forward them

#4 2008-05-26 04:23:06

Re: Filter emails with subject and forward them

#5 2008-05-26 21:29:55

Re: Filter emails with subject and forward them

#6 2008-05-27 04:29:10

Re: Filter emails with subject and forward them

#7 2008-05-27 07:34:14

Re: Filter emails with subject and forward them

#8 2008-05-27 07:46:11

Re: Filter emails with subject and forward them

#9 2008-05-27 17:09:56

Re: Filter emails with subject and forward them

Board footer