topic Re: tFileList -> tFileDelimited -> tLogRow in Talend Studio

tFileList -> tFileDelimited -> tLogRow

valkmeister — Wed, 05 Aug 2020 16:39:33 GMT

Hi,

I'm trying to get the csv files that I need from a directory, but when I run the job the expected result does not appear.

I've tried many configurations and options, but still not working. Eventually, I'm felling that something is missing. So I decided to reproduce the example on the Talend Documentation and other Youtube videos. Tried also on two different operating systems (Windows and Linux) same result.

So right now my test job is this:

It should show the simple data inside the csv, but nothing happening.

On tFileDelimited I'm using: ((String)globalMap.get("tFileList_1_CURRENT_FILEPATH"))

Re: tFileList -> tFileDelimited -> tLogRow

Talend_ent — Wed, 05 Aug 2020 17:22:36 GMT

attach tfilelist configuration pic.

Re: tFileList -> tFileDelimited -> tLogRow

valkmeister — Wed, 05 Aug 2020 17:42:54 GMT

Re: tFileList -> tFileDelimited -> tLogRow

vikramk — Wed, 05 Aug 2020 18:05:28 GMT

could you try running the job without "\\" from the filemask and please try to print the context variable in tjava and check whether the path given is correct or not

Re: tFileList -> tFileDelimited -> tLogRow

Anonymous — Thu, 06 Aug 2020 07:12:43 GMT

Hello,

Please select"Generate Error if no file found" check box in tfilelist component to see if your job will generate an error message if no files or directories are found. If so, you need to check the path of given directory.

Best regards

Sabrina

Re: tFileList -> tFileDelimited -> tLogRow

valkmeister — Thu, 06 Aug 2020 07:33:32 GMT

Hi Sabrina,

Thank you for the kind suggestion. Indeed tFileList wasn't finding the files!

Re: tFileList -> tFileDelimited -> tLogRow

valkmeister — Thu, 06 Aug 2020 07:35:55 GMT

Hi vikramk,

Thank you, it worked! I don't know why, but yesterday I was getting an error when only using "*.csv", and the only way to solve it was by adding the "//". I will now test this on the other job.

Regards!

Re: tFileList -> tFileDelimited -> tLogRow

manodwhb — Thu, 06 Aug 2020 07:36:50 GMT

@Vikram Kumar , I do not understand why you are using "\\*.csv" as a file mask, you need to get the csv files in given folder right then use "*.csv" as file mask in tFilelist.

Thanks,

Manohar

Re: tFileList -> tFileDelimited -> tLogRow

valkmeister — Thu, 06 Aug 2020 08:48:54 GMT

Hi Manohar,

Because without them I get this error:

Re: tFileList -> tFileDelimited -> tLogRow

Anonymous — Fri, 07 Aug 2020 03:45:59 GMT

Hello,

Please recheck "Use Glob Expressions as Filemask " option which filters the results using a Global Expression (Glob Expressions).

Best regards

Sabrina

Re: tFileList -> tFileDelimited -> tLogRow

manodwhb — Fri, 07 Aug 2020 06:37:07 GMT

Yes You need to check "Use Glob Expressions as Filemask " option in tFileList Component ,have you used?