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

Announcements
Qlik Open Lakehouse is Now Generally Available! Discover the key highlights and partner resources here.
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"