How to get filenames generated by tfilelist and trowgenerator in the tsendmail component

[Anonymous]

Hi Team,

I need to get the file names from the server and add it to tsendmail component so that the mail component notifies the names of the files present in server. I am using tFTPFilelist and tRowgenerator components to fetch the names of the files from the server. But I am unable to add those in the tsendmail component. 

Please let me know how to solve this.

Thanks

Puspanjali

[manodwhb]

@Puspanjali12,you can use the global variables of tFilelist,which is ((String)globalMap.get("tFileList_3_CURRENT_FILE")).

[Anonymous]

I have used ((String)globalMap.get("tFileList_3_CURRENT_FILE")) in trowgenerator and i have fetched the filenames. Now, how can i add it to tsendmail component which will send all the file names fetched from trowgenertor?

[Anonymous]

Hello,

Could you please let us know if this related topic helps?

https://community.talend.com/t5/Design-and-Development/resolved-Sending-the-content-of-tfileoutputde...

Best regards

Sabrina

[manodwhb]

@Puspanjali12,one way is to send a mail for each file,you just use the ((String)globalMap.get("tFileList_3_CURRENT_FILE")) in the subject and body that you need to set as you required by iterate from tFileList to tSendmail.

[Anonymous]

Thanks sabrina for the reply.

Can we achieve the same without using tfileoutdelimited or any external tables?

Thanks

Puspanjali

[Anonymous]

Thanks Manohar for the reply.

There is a strict requirement that a single mail should be sent with all the file names.

Thanks

Puspanjali

[manodwhb]

@Puspanjali12,then you create a file with and populate all the filename ,which are listed in tfilelsit and read tha same file and concatenate the records using tJavarow by using contexts and use the context in tsendmail. 

[manodwhb]

@Puspanjali12,still do you have issue?