Do not input private or sensitive data. View Qlik Privacy & Cookie Policy.
Skip to main content

Announcements
Qlik Connect 2026! Turn data into bold moves, April 13 -15: Learn More!
cancel
Showing results for 
Search instead for 
Did you mean: 
Anonymous
Not applicable

tFTPGet Fails to retrieve Files

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!
0683p000009MGLp.png
0683p000009MGLu.png

0683p000009MGHV.png

0683p000009MGLz.png

0683p000009MGGC.png

Labels (2)
4 Replies
Anonymous
Not applicable
Author

List of components.
vapukov
Master II
Master II

check - what in Your tFTPGet

must work if all proper
Anonymous
Not applicable
Author

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!
vapukov
Master II
Master II

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 0683p000009MACn.png (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"