Skip to main content
Announcements
NEW: Seamless Public Data Sharing with Qlik's New Anonymous Access Capability: TELL ME MORE!
cancel
Showing results for 
Search instead for 
Did you mean: 
Anonymous
Not applicable

how to get file names from remote linux server using tFileList

Hi All,
I am facing a problem which i can't solve out that's why looking for a suggestion. Any Suggestion would be appreciable.
Requirement--->>> Copy a List of files from remote server to local machine.
Scenario----->>> I have created a connection using tSCP_Get and then i am using tFileList to retrieve a set of file names using
"cd /my path/ *.tsv"
and then in tSCPGET component i am using ((String)globalMap.get("tSCPFileList_1_CURRENT_LINE")) to fetch the name of file and copy it to my local machine
PROBLEM-->> when i run this job
Starting job copy_files at 14:51 20/06/2013.

connecting to socket on port 3657
connected
Execution of cd is not allowed
Please log in and run the command interactively
disconnected
Job copy_files ended at 14:51 20/06/2013.
Labels (2)
2 Replies
Anonymous
Not applicable
Author

Hi,
Please see the component reference tSCPGet with a scenario "Getting files from a remote SCP server".
Best regards
Sabrina
Anonymous
Not applicable
Author

In order to get files you need to use
                                                      tSCPFileList >>> tSCPGet
1) tSCPFileList_1 -> In the FileList  setting use something like "ls /home/username/*.tsv"
2) connect tSCPFileList_1 "iterate" to your tSCPGet_1
3) tSCPGet_1 -> a) local directory: is where you want the files to go into on your local machine
                       b) Filelist:  ((String)globalMap.get("tSCPFileList_1_CURRENT_LINE"))