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: 
MNhar1612877754
Contributor
Contributor

Unable to copy files with TFTPGet from a remote server into subdirectories

Hi, I want to copy files from subdirectories in remote server with SFTP.

Example:

/home/admin/

rep1/test1.csv

rep2/test2.csv

.....

0695b00000WtSaPAAV.png

with the following setting on tFTPFileList_2:

0695b00000WtSaZAAV.png

et

0695b00000WtSaeAAF.png

I get the following error message:

0695b00000WtSatAAF.png

however the *.csv files are in the subfolders.

Do you have any idea how to retrieve files in the subdirectories of a remote server?

Thanks

Labels (2)
6 Replies
Anonymous
Not applicable

Hello,

You can use a tFTPRename component and select the Move to the current directory checkbox to move files to your root directories.

After that, please use tFtpGet component to download *.csv files and reupload them into your remote server Via tFTPPut component.

Feel free to let me know if it helps.

Best regards

Sabrina

MNhar1612877754
Contributor
Contributor
Author

Hello,

Thank you Sabrina,

I did what you suggested, there was no error but I can't find the files in the current directory and the remote files are not moved. Where can I find the current directory please?

 

0695b00000WtZ9BAAV.pngRegards

Anonymous
Not applicable

Hello,

Why did you use two tFTPFileList components in your workflow? Any specific requirment?

By using tFtpConnection-->tFTPRename-->tFtpGet, you are able to set a filter with *.csv in tFTPGet component.

Best regards

Sabrina

 

MNhar1612877754
Contributor
Contributor
Author

Hello, because I want to copy only the *.csv files that are in the remote server subdirectories to a local directory.

 

Regards

 

Anonymous
Not applicable

Hello,

By using tFtpConnection-->tFTPRename( move your files from subdirectories to your root directory)-->tFtpGet(download all *.csv files to local disk), you are able to set a filter with *.csv in tFTPGet component.

Best regards

Sabrina

MNhar1612877754
Contributor
Contributor
Author

Sorry, that doesn't work.

you can test yourself. Create multiple subfolders on a remote server like:

/home/Folder --> parent folder

/home/Folder/Folder1/file1.csv

/home/Folder/Folder2/file2.csv

/home/Folder/Folder3/file3.csv

....

....

/home/Folder/Folder9/file9.csv

 

Using tFtpConnection-->tFTPRename, nothing happens

 

Regards