topic Re: tFTPFileList : how to know an entry is a directory in Talend Studio

tFTPFileList : how to know an entry is a directory

jmd — Wed, 13 Mar 2013 10:46:40 GMT

Hi,
I use a tFTPFileList to get files from a FTP server
But there is a subdirectory in the directory listed
=> this subdirectory is considered as a file and generates an error when the job tries to work with this folder as if it was a file
Do you know how to test the type of the element brought by the tFTPFile List ?
Thanks in advance

Re: tFTPFileList : how to know an entry is a directory

Anonymous — Wed, 13 Mar 2013 20:03:06 GMT

Hi,
To avoid this problem, I propose you to add a mask like "*.gz" for example in your tFTPFileList file mask area

Best regards,
Stéphane

Re: tFTPFileList : how to know an entry is a directory

jmd — Thu, 14 Mar 2013 10:22:09 GMT

Thanks but it's not possible as the files to list don't have any extension

Re: tFTPFileList : how to know an entry is a directory

Anonymous — Thu, 14 Mar 2013 22:09:49 GMT

I used the component tFTPFileList with the mask "*.*" and it worked for me : the component lists all files with extension, but no directory.
Best Regards,
Stéphane
Edit : Sorry, my files have extension, but not yours! This post didn't answer correctly to your question!

Re: tFTPFileList : how to know an entry is a directory

Anonymous — Fri, 15 Mar 2013 04:00:36 GMT

Hi jmd,
Uncheck the option 'File details', it will not list the directories, but only files. For more information, please read the component online manual
https://help.talend.com/search/all?query=tFTPFileList]tFTPFileList&content-lang=en
Best regards
Sabrina

Re: tFTPFileList : how to know an entry is a directory

jmd — Sat, 16 Mar 2013 09:38:09 GMT

I tried that but "File details" option completely changed the values returned in the ((String)globalMap.get("tFTPFileList_1_CURRENT_FILE")) variable returned by the component and it can't be treated correctly (date & time of the file is added in the name of the file)

Re: tFTPFileList : how to know an entry is a directory

Anonymous — Sat, 16 Mar 2013 10:11:32 GMT

I tried that but "File details" option completely changed the values returned in the ((String)globalMap.get("tFTPFileList_1_CURRENT_FILE")) variable returned by the component and it can't be treated correctly (date & time of the file is added in the name of the file)

Sabrina meant to unselect the 'File details' option.
Shong

Re: tFTPFileList : how to know an entry is a directory

jmd — Sat, 16 Mar 2013 12:40:17 GMT

it's unchecked by default and it still returns directory entries

Re: tFTPFileList : how to know an entry is a directory

Anonymous — Mon, 18 Mar 2013 02:20:20 GMT

Hi
Which version are you using? I tested this issue on v5.2.1 and it don't returns directory entries.
Shong

Re: tFTPFileList : how to know an entry is a directory

jmd — Mon, 18 Mar 2013 08:04:33 GMT

5.2.0
I don't think there is a difference in 5.2.1

Re: tFTPFileList : how to know an entry is a directory

Anonymous — Mon, 25 Mar 2013 06:20:02 GMT

Hi jmd
I can't reproduce the problem on v5.2.0, if i uncheck the 'file details' option, it will only list the files, do not list directories. Please see my screenshots.
Shong

Re: tFTPFileList : how to know an entry is a directory

jmd — Mon, 25 Mar 2013 09:10:44 GMT

But in your example, you don't have files WITHOUT EXTENSION
Try that
One other detail : the FTP server is on a Windows server

Re: tFTPFileList : how to know an entry is a directory

Anonymous — Mon, 25 Mar 2013 10:05:47 GMT

Hi
What's type of your file? It is possible for you email me an example file for testing?
Shong

Re: tFTPFileList : how to know an entry is a directory

jmd — Mon, 25 Mar 2013 11:14:40 GMT

It's a text file, no matter what's inside, but it doesn't have an extension

Re: tFTPFileList : how to know an entry is a directory

Anonymous — Mon, 25 Mar 2013 12:08:46 GMT

It's a text file, no matter what's inside, but it doesn't have an extension

I also tested the files without extension, and it works. jmd, you are using Talend Enterprise product, can you please report a ticket on our support portal, our colleague from support team will assist you further, schedule a webex meeting and investigate the problem together if needed.
Shong

Re: tFTPFileList : how to know an entry is a directory

jmd — Mon, 25 Mar 2013 12:49:46 GMT

Hi,
I have different customers, someone use the enterprise product, and in this case, I wouldn't spend my time on the forum, I would have sent a case to the support
But for this problem, the customer use the open version, so I can't use the support ...

Re: tFTPFileList : how to know an entry is a directory

Anonymous — Fri, 12 Apr 2013 09:30:45 GMT

It seems that if i check "SFTP support" and check "File Details", TOS_DI 5.2.2(r99271) does not show the details of the file. I have used Shong's scheme:
tFTPFilelist ----> tJava
I have tried without SFTP support and it works normally.
Any help?
Thanks in advance

Re: tFTPFileList : how to know an entry is a directory

Anonymous — Wed, 12 Sep 2018 15:49:49 GMT

Hi Sabrina,

I am using Talend7.0.1, and it seems it doesn't matter whether "File detail" was selected or not, the tFTPFileList would only list the directories, not the files.

Is there a way to list the files or file paths? I need to list the file paths and then only select certain files to copy to local (using tFTPGet).

Really need help, thanks!

Re: tFTPFileList : how to know an entry is a directory

Anonymous — Thu, 13 Sep 2018 03:45:30 GMT

Hello @Moe,

What's type of your file? What does your file mask look like in your tFTPFileList?

Best regards

Sabrina