Talend community forum / How To Send Mail?

nilesh · 2011-08-24 12:47:44

Tags: [context, CSV file, delimited file, development, error, error management, positional file, schema]

Hello ,

Is it possible to get a mail_id inside "tsendmail" stage in "To" column from any other files like excel and to send a mail for the same id.

Thanks In Advance
Nilesh R

shong · 2011-08-24 13:42:18

Hi
Sorry, I don't understand you well, mail_id?

Best regards
Shong

nilesh · 2011-08-24 13:51:45

email....
example:-nilesh@gmail.com

nilesh · 2011-08-25 08:15:06

im getting 'email' address in excel file . from that excel file i need to load the 'email' as parameter in "tsendmail" stage to automate my process.

is it possible to get 'email' as parameter?
email - nilesh@gmail.com(for example)

shong · 2011-08-25 08:18:49

Hi
Yes, it is possible. For example:
tFileInputExcel--row1--tFlowToIterate--ierate--tSendMail

In the 'to' field of tSendMail, set:
row1.email

email is one of column name, String type.

Best regards
Shong

nilesh · 2011-09-08 07:50:51

Hello ,
I have checked with email as parameter from the previous file but now im trying to attach the file using "tsetglobalvar" stage

Is it possible to Set the email as parameter with attachement?

my job seems like :

tFileInputExcel--row1--tFlowToIterate--ierate--tjava--if--tsetglobalvar--row2--tsendmail .

In the 'to' field of tSendMail, i have set:
row1.email .

Thanks In Advance
Nilesh R

shong · 2011-09-08 08:00:14

Hi
I don't understand you use the tSetglobalvar to attach the file, this component is used to set/define a global variable. You can set the file path of attachment with a context var or a global var.

Please let me know what you pull from the excel file? 'to' and file path of attachment? What are you doing on tJava component?

Best regards
Shong

nilesh · 2011-09-08 08:26:07

my job looks like :

tFileInputExcel--row1--tFlowToIterate--ierate--tsetglobalvar--row2--tsendmail .

(*) in tfileinputexcel i have 3 columns :Email , SMTP_Server , Portal

now i need to get a email as a parameter in "to" field in "tsendmail" stage with attachment .

(*) In tsetglobalvar--basic settings--variables--under that

Key | value
file | D:\TALEND\sample.xls(for example)

(*) In tsendmail under attachment field i have set "(String)globalMap.get("file")"

Is this the way to set the "to" field as parameter from "row1" .if i did this it showing error like row1 cannot be resolved but its working without attachment .

can u assist me for this issue ?

nilesh · 2011-09-08 10:34:30

my job looks like :

tFileInputExcel--row1--tFlowToIterate--ierate--tsetglobalvar--row2--tsendmail .

(*) in tfileinputexcel i have 3 columns :Email , SMTP_Server , Portal

now i need to get a email as a parameter in "to" field in "tsendmail" stage with attachment .

(*) In tsetglobalvar--basic settings--variables--under that

Key | value
file | D:\TALEND\sample.xls(for example)

(*) In tsendmail under attachment field i have set "(String)globalMap.get("file")"

Is this the way to set the "to" field as parameter from "row1" .if i did this it showing error like row1 cannot be resolved but its working without attachment .

can u assist me for this issue ?

Announcement

Unanswered posts

#1 2011-08-24 12:47:44

How To Send Mail?

#2 2011-08-24 13:42:18

Re: How To Send Mail?

#3 2011-08-24 13:51:45

Re: How To Send Mail?

#4 2011-08-25 08:15:06

Re: How To Send Mail?

#5 2011-08-25 08:18:49

Re: How To Send Mail?

#6 2011-09-08 07:50:51

Re: How To Send Mail?

#7 2011-09-08 08:00:14

Re: How To Send Mail?

#8 2011-09-08 08:26:07

Re: How To Send Mail?

#9 2011-09-08 10:34:30

Re: How To Send Mail?

Board footer