how to use tFTPList with tFileInputDelimited

[_AnonymousUser]

Hi,
I'm a new user w/ TOS
I'm trying to read all the csv file from a ftp directory using a tFTPList---tFileInputDelimited--tMap---tMSSqlOutput
in the tFTPList i put my directory context.ftp_repertory , in the tFileInputDelimited i put ((String)globalMap.get("tFTPList_CURRENT_FILEPATH"))
if i execute i have this error:
Exception in component tFileInputDelimited
java.lang.NullPointerException
at java.io.FileInputStream.<init>(FileInputStream.java:103)
at java.io.FileInputStream.<init>(FileInputStream.java:66)
at sigadem.Job_0_1.tFtpList.tFTPList_17Process(tFtpList.java:2312)
at sigadem.Job_1.tFtpList.runJobInTOS(tFtpList.java:3683)
at sigadem.Job_1.tFtpList.main(tFtpList.java:3578)

can someone help?
thank you

[Anonymous]

I would suggest you download the file first (one additional step with tFileFetch) before opening it with tFileInputDelimited. I think tFileInputDelimited does not support remote addresses.

[Anonymous]

Whoaaaa, where are you seeing tFTPList? Because I'm looking for a component like that right now, and can't find it
All I see in the Components list ( http://www.talendforge.org/components/) under Internet/FTP are:
tFTPDelete
tFTPGet
tFTPPut
tFTPRename

Ooooh, its in the Ecosystem...
tFTPList: http://www.talendforge.org/ext/extension_view.php?eid=54
tFTPGetFile: http://www.talendforge.org/ext/extension_view.php?eid=55
When will that be pushed out to TOS and TIS 2.4.1???

[Anonymous]

4746
4745

[Anonymous]

Hi,

I'm trying to retrieve several files on a remote server by using a text file which contains the list of files to retrieve.

So I've put tFileInputDelimited and tFTPGet components in my job.

My tFileInputDelimited component contains a single column named filename.

Then I've set the filemask property of tFTPGet component with the following value : row4.filename (row4 is the name of the link between my 2 components)

Unfortunately, it does not work, I always have a "java.lang.NullPointerException" error and no information about where is the problem ?

Which value must I set in filemask ?

Any suggestion ?

Thx !

[dipanjan93]

It is because tFileInputDelimited would search for the particular file in the job server. So for that use tFileList to list down all the files fetched from the FTP server. Your job flow should be as below -

tFTPList (iterate)-------> tFTPGet

OnSubjobOk

tFileList (iterate)------->tFileInputDelimited (Use Global Variable of tFileList)---->tIteratetoFlow---->tLogRow