topic Re: how to use tFTPList with tFileInputDelimited in Talend Studio

how to use tFTPList with tFileInputDelimited

_AnonymousUser — Sat, 16 Nov 2024 14:17:59 GMT

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

Re: how to use tFTPList with tFileInputDelimited

Anonymous — Mon, 14 Jul 2008 08:58:14 GMT

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.

Re: how to use tFTPList with tFileInputDelimited

Anonymous — Tue, 05 Aug 2008 19:34:57 GMT

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???

Re: how to use tFTPList with tFileInputDelimited

Anonymous — Mon, 22 Sep 2008 20:59:46 GMT

4746
4745

Re: how to use tFTPList with tFileInputDelimited

Anonymous — Thu, 17 Jan 2019 15:31:46 GMT

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 !

Re: how to use tFTPList with tFileInputDelimited

dipanjan93 — Thu, 17 Jan 2019 17:28:44 GMT

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