topic Re: tFTPGet Fails to retrieve Files in Talend Studio

tFTPGet Fails to retrieve Files

Anonymous — Mon, 06 Mar 2017 22:08:22 GMT

Hi All,
I'm new to all of this and think I may be missing something basic. I am trying to retrieve a file from an FTP server and have attempted several configurations unsuccessfully. I can connect and transfer without any issues via winSCP.
Workflow:
tFTPConnection_1 (per IT, using port 10021, passive).
tFTPFileList_1
tFTPGet_1
Results:
[statistics] connecting to socket on port 3384
[statistics] connected
[statistics] disconnected
To troubleshoot, I added a tJava component to output the file name. Now when I run, I receive the following:
[statistics] connecting to socket on port 3384
[statistics] connected
/S2662BAL//-CR-------FTP B S2662BAL 113113 403408 Mar 06 15:42 apfmcpospay.txt
[statistics] disconnected
Job DEV_ ended at 13:43 06/03/2017. [exit code=0]
Please see Job and Components.

Per other forum suggestions, I have tried to modify setups in the following ways:
Use tFTPFileList_1_CURRENT_FILEPATH (as the tFTPGet Filemask component)

Thank you in advance for any suggestions!

Re: tFTPGet Fails to retrieve Files

Anonymous — Mon, 06 Mar 2017 22:47:50 GMT

List of components.

Re: tFTPGet Fails to retrieve Files

vapukov — Mon, 06 Mar 2017 22:59:33 GMT

check - what in Your tFTPGet

must work if all proper

Re: tFTPGet Fails to retrieve Files

Anonymous — Tue, 07 Mar 2017 23:51:15 GMT

Ran a tJava component to capture the output of tFTPGet - shows Null for all possible values. I'm not sure why it won't pass the file name properly for retrieval.
I'll run a .bat script to call a WinSCP call and add that into the routine with a tsystem component instead. It looks like that works.
Thanks!

Re: tFTPGet Fails to retrieve Files

vapukov — Wed, 08 Mar 2017 01:06:07 GMT

jet98012@ wrote:
Ran a tJava component to capture the output of tFTPGet - shows Null for all possible values. I'm not sure why it won't pass the file name properly for retrieval.
I'll run a .bat script to call a WinSCP call and add that into the routine with a tsystem component instead. It looks like that works.
Thanks!

if You check it again with fresh eyes (drink a coffee)
You will see - You are use different variables for tJava and tFTPGet

tFTPFileList_1_CURRENT_FILEPATH - for tJava

and

tFTPFileList_1_CURRENT_FILE - for tFTPGet

that all I think

If You want use just filename without path - click on checkbox "Move to current directory"