FileMask query in tFTPFileList component.

[cejones]

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

[Rahul_Kale · Accepted solution]

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. 

[JulianAlho]

Hi Claire,
Some FTP sites are case-sensitive. Check that the folder names match exactly.
The other job that you have...is it using the same downloadFolder?

[cejones]

Thanks for your response.  The file folder names match exactly on the ftp sit and my job.  The other job I have is for a different ftp site so different ftp details and folder paths/names.

[cejones]

Hi there, 

Thanks for your reply, very useful and I have amended a couple of the jobs with the suggestions you have made.  Unfortunately the files are not downloading to my specified folder.  Plus I need to move these files to an archive folder on the ftp site, I am using a tFTPRename component.  

The whole job runs and I can see that it has found the files and looks like it is downloading, but it doesn't actually do anything. 

I will continue to look at the job and check each component.
Thanks

Claire