Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hi there, I am trying to download some files from a ftp site, I have made the connection but the file name/file path I am having some issues with.
The file name is 1234_YYYMMDD_CustomExport.csv
The file path is Exports/Custom Export/
So in the tFTPFileList component I have got the following contexts:
FIleMask:"*_CustomExport*.csv"
downloadFolder: "./Exports/Custom Export/archive/" (the folder on the ftp site called Custom Export does have a space inbetween.
I am unsure what I am doing incorrectly, as there is another job that I have got with the FileMask and download folder populated with no issues.
When I run this in Talend Studio, it is saying no files found, when I look into the ftp site in Filezilla, there are files there.
Any help is gratefully received.
Thanks
Claire
Hello @cejones,
Thank you for reaching out to the Qlik community.
A couple of things to check:
Remote Directory vs Download Folder:- tFTPFileList uses the remote directory to find files on the FTP server.
If the files are in:
Exports/Custom Export/
Then set the Remote directory exactly to:
/Exports/Custom Export/ (or whatever the absolute path is on the FTP server).
File Mask:-
Your filename format is: 1234_YYYYMMDD_CustomExport.csv
You can try: *_CustomExport.csv instead of: *_CustomExport*.csv
Talend supports wildcard masks (*) for file filtering.
Archive Folder:- If the archive is a local folder, it should be configured in tFTPGet (Local directory), not as the FTP listing directory. tFTPFileList should point to the folder where the files currently exist, not the archive folder.