You are not logged in.

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

nilesh
Member

How To Send Mail?

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


Thanks In Advance ,
       Nilesh R

Offline

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

shong
Talend Team

Re: How To Send Mail?

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

Best regards
Shong


Email:shong@talend.com
Choose Talend, Enjoy Talend!
New & Event: Talend Help Center
Talend-->the leader of open source data management and application integration solutions!

Offline

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

nilesh
Member

Re: How To Send Mail?

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


Thanks In Advance ,
       Nilesh R

Offline

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

nilesh
Member

Re: How To Send Mail?

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)


Thanks In Advance ,
       Nilesh R

Offline

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

shong
Talend Team

Re: How To Send Mail?

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


Email:shong@talend.com
Choose Talend, Enjoy Talend!
New & Event: Talend Help Center
Talend-->the leader of open source data management and application integration solutions!

Offline

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

nilesh
Member

Re: How To Send Mail?

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


Thanks In Advance ,
       Nilesh R

Offline

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

shong
Talend Team

Re: How To Send Mail?

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


Email:shong@talend.com
Choose Talend, Enjoy Talend!
New & Event: Talend Help Center
Talend-->the leader of open source data management and application integration solutions!

Offline

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

nilesh
Member

Re: How To Send Mail?

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 ?


Thanks In Advance ,
       Nilesh R

Offline

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

nilesh
Member

Re: How To Send Mail?

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 ?


Thanks In Advance ,
       Nilesh R

Offline

Board footer