Do not input private or sensitive data. View Qlik Privacy & Cookie Policy.
Skip to main content

Announcements
Data Works for AI is here - Join the discussion and enter to win a pair of Qlik kicks: Join the Conversation!
cancel
Showing results for 
Search instead for 
Did you mean: 
cejones
Contributor
Contributor

FileMask query in tFTPFileList component.

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

Labels (5)
2 Replies
Rahul_Kale
Support
Support

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

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?