topic Re: How to get file name from tfilelist in Talend Studio

How to get file name from tfilelist

Anonymous — Mon, 21 May 2018 10:34:22 GMT

How to get file names, size, row count and send it to email by using Java components or can we achieve without java components

Re: How to get file name from tfilelist

Anonymous — Mon, 21 May 2018 11:09:04 GMT

You can use the tFileProperties for everything but number of rows. For number of rows you will need to read the files and count them.

Re: How to get file name from tfilelist

Anonymous — Mon, 21 May 2018 11:40:58 GMT

Actually my requirement is I have some set of different files in one (reject files)folder. I have to sent an email like filename, filesize and no.of records in file. Can you help me with this requirement.

Re: How to get file name from tfilelist

vaibs_parab — Mon, 21 May 2018 11:45:23 GMT

Use 'tFileProperties' component to get the file name, size, permission, etc.

And to get the number of rows from file use 'tFileRowCount' component and link this using onSubJobOk to tJava/ tJavaRowcomponent. In tJava/ tJavaRow component use below expression to get the row count and store it into a context variable.

context.FILES_RECORDS = ((Integer)globalMap.get("tFileRowCount_1_COUNT"));

Re: How to get file name from tfilelist

Anonymous — Mon, 21 May 2018 12:23:40 GMT

How to dispaly the properties from tfileproperties.

Re: How to get file name from tfilelist

vaibs_parab — Mon, 21 May 2018 13:27:32 GMT

Here I'm trying to replicate the solutions. Below is the screenshot of the Job Design.

At tFileRowCount:

At tJava_2:

At tFileProperties:

At tJavaRow:

At tSendMail:

Try this and let me know if this will work for you.

Also, Give kudos if this work for you.

Re: How to get file name from tfilelist

Anonymous — Mon, 21 May 2018 14:20:55 GMT

It is listing only latest file, but I want all the files.

Re: How to get file name from tfilelist

Anonymous — Mon, 21 May 2018 14:41:26 GMT

You can use the method shown, but will have to use some basic Java String manipulation to build up the details you want for each file (the email message) and append to that for each file. You should be able to do that in the tJavaRow quite easily.

Re: How to get file name from tfilelist

Anonymous — Mon, 21 May 2018 17:18:32 GMT

I have to list all the file names in single email can you help me with that.

Re: How to get file name from tfilelist

Anonymous — Mon, 21 May 2018 17:25:25 GMT

Something like this (you will have to experiment with this and tweak it yourself).....

context.Message = context.Message+"File: "+input_row.basename+"\r\n"+ 
"File Path: "+input_row.abs_path+"\r\n"+
"File Size: "+input_row.size+"\r\n\r\n";

You then just use the context.Message in your send mail component.

Re: How to get file name from tfilelist

Anonymous — Tue, 22 May 2018 04:55:12 GMT

I want to append all the files and need to send email

Re: How to get file name from tfilelist

Anonymous — Tue, 22 May 2018 05:47:31 GMT

I want to append all the files and need to send email

Re: How to get file name from tfilelist

Anonymous — Tue, 22 May 2018 10:05:13 GMT

Have you tried reproducing the job that @vaibsVB suggested? If not, do that first. If so, replace the tJavaRow code with mine (after configuring a new context variable for Message) and see what you get.

Re: How to get file name from tfilelist

Anonymous — Tue, 22 May 2018 11:00:53 GMT

I got the solution thanks for support

Re: How to get file name from tfilelist

Anonymous — Tue, 22 May 2018 11:06:56 GMT

Can you tell us what you did so that others can benefit from this question in the future?

Re: How to get file name from tfilelist

Anonymous — Tue, 22 May 2018 17:17:50 GMT

I have followed the above one @vaibsVB's model and gave your context.email(message) in tjavarow it is working

Re: How to get file name from tfilelist

vaibs_parab — Thu, 07 Jun 2018 16:22:09 GMT

Sorry for reaching late.

@im_arod Glad part of my solution work for you.

@rhall Thanks for giving inputs.

In order to get all files from the folder, I tried another approach try this if it works for you.

And also suggest improvements also.

tFileList_3 and tFileProperties_2 settings are same as previous example.

At tIterateToFlow_1 here are the settings:

At tDenormalize_1 here are the settings:

Make note, in above Delimiter setting I purposefully kept the ", ".

And you will get desired output i.e. FileNames from the folder in list format. You can store this filename list into context and use in Mail Component.

Regards.

Re: How to get file name from tfilelist

Anonymous — Thu, 13 Jun 2019 19:42:52 GMT

Hi I tried the same but while compiling the job found errors in file row count it specified that string is undefined

Re: How to get file name from tfilelist

Anonymous — Thu, 13 Jun 2019 20:13:21 GMT

Hi I tried the same but it showing error as undefined string in tFilerowcount and tjavarow

Re: How to get file name from tfilelist

Anonymous — Fri, 14 Jun 2019 12:18:10 GMT

Hi i tried the same design but got below error could some one help me i am new to this tool. Attaching the screen shots