topic Re: Can I use tMap to filter folders from a FTP server? in Talend Studio

Can I use tMap to filter folders from a FTP server?

Anonymous — Fri, 03 Aug 2018 04:48:36 GMT

I wanted to copy certain folders from a FTP server to my local computer.

Here is the Talend components I used:

1. tFTPConnection

2. tFTPFileList -- with the filemask in tFTPFileList, I was able exclude some unwanted folders. In order to exclude all the unwanted files, I used another 2 components:

3. tIterateToFlow:

filename: ((String)globalMap.get("tFTPFileList_4_CURRENT_FILE")) -- in this case, the filename is the folder name

filepath: ((String)globalMap.get("tFTPFileList_4_CURRENT_FILEPATH"))

4. tMap:

use a filter to exclude unwanted file: !row9.filename.equals("here is the unwanted folder name")

Now if I link tMap's output to tLogRow, I can see the unwanted filenames (folder names) are all gone.

But my question is, how to copy the correct foldes after tMap? Can I just connect tMap to tFTPGet? What should I do now?

Thanks!

Re: Can I use tMap to filter folders from a FTP server?

manodwhb — Fri, 03 Aug 2018 05:50:07 GMT

@Moe,from tMap,wirite it it file ,tHashOutput or DB and again read that file and iterate the values and in tFTPGet call that global variable form iterated value as file-mask.

Re: Can I use tMap to filter folders from a FTP server?

Anonymous — Fri, 03 Aug 2018 07:09:42 GMT

link tMap to a tFlowToIiterate to iterate each folder, eg:
...tMap--tflowToIterate--iterate--tFTPGet.

Re: Can I use tMap to filter folders from a FTP server?

Anonymous — Tue, 07 Aug 2018 15:09:16 GMT

Thank you shong! It worked.