topic Unable to copy files with TFTPGet from a remote server into subdirectories in Talend Studio

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

MNhar1612877754 — Fri, 15 Nov 2024 22:32:19 GMT

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

Example:

/home/admin/

rep1/test1.csv

rep2/test2.csv

.....

with the following setting on tFTPFileList_2:

I get the following error message:

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

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

Anonymous — Thu, 22 Sep 2022 03:58:58 GMT

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

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

MNhar1612877754 — Thu, 22 Sep 2022 08:03:47 GMT

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?

Regards

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

Anonymous — Thu, 22 Sep 2022 09:16:00 GMT

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

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

MNhar1612877754 — Thu, 22 Sep 2022 09:51:38 GMT

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

Regards

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

Anonymous — Fri, 23 Sep 2022 03:37:36 GMT

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

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

MNhar1612877754 — Fri, 23 Sep 2022 09:21:58 GMT

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