Filters Archives - Page 7 of 9 - File transfer tool from Limagito

29 Jan
Download only certain date specific files
Q: Download only certain date specific files from FTP
I have an ftp account that has a file for each day of the month in it. I need to download a file each day for that particular Monday – Sunday. This will go into a rename job so for example file 01162023 (for Monday, January 16, 2023) would be renamed to SLMON. File 01172023 would rename to SLTUE, 01182023 SLWED, and so on until 01222023 for SLSUN.
So once more, I would need to set a download each night to pull a file with that dates name and have it rename. So tonight would download file 01212023 and rename it to SLSAT. Then Sunday would pull a single file for that date. Is that doable?
A: Yes this is possible, so you would trigger it every evening and it would pick up the file for tomorrow and rename it. This will also work for other source types than FTP.
1. Please open the File Filter Setup
– Enable ‘Allow parameters in File Name filter’ in the Advanced Tab:
– Set the Filename Include Filter to:
%TCD:[IncDay+1]mmddyyyy:.pdf
In my example I’m looking for .pdf files but it could also be like (every type of file):
%TCD:[IncDay+1]mmddyyyy:.*
Notice the [IncDay+1] so it looks for the next day.

2. Open the Destination setup

– Rename Tab > Enable Rename Files > Setup Renaming:

– Add the following renaming expression:
RegEx: (.*)\.(.*)
Replacement: SL%TCD:[IncDay+1]ddd:.\2
– Customer: Great thanks. What would I do if I pulled it at say 1am for the same day?
– Limagito: Remove the [IncDay+1] in the File Filter AND the Renaming setup
#FileTransfer #FTP #SFTP
If you need any info about this post, please let us know.
Best regards,
Limagito Team
By Limagito-Team Filters FTP date specific
09 Jul
List of filename parts to move in a text file with Limagito File Mover
Q: Is it possible to have a list of filename parts in a text file and use this to move any files whose name matches the whole filename or part file name in a directory? I’ve had a look on the blog but I think that is only for 1 file using a part filename.
A: In version v2021.7.9.0 we added a new option to achieve this. We added some screenshots to get you started.
1. Windows Folder as Source. This folder will contain all files. We’ll filter them using information from a seperate text file.
Our Source folder contains 244 files:
2.Next, please open the Rule Parameters option of this Rule.
Select the text file containing the filename parts we’ll use to filter the files we want to copy. We selected ‘On Rule Begin’ as Load File Mode, so the content of this text will will be reloaded on each Rule Begin. We also enabled ‘Reload only when file content changes’ to prevent unnecessary loading of this file.
Content of the text file we’ll use to filter the files we want to copy, it contains parts of filenames.
3. Open the File Filter setup and select ‘File Contents > Include’ Tab. Enable the new option called ‘Add wildcards to File Content Entries in search’.
When enabled wildcards will be added to each entry of the file content (in memory) during the search.
i.e.
Suppose file name found in source folder would be: test.pdf
And the include FileContent would contain: test
With this option enabled the file would be picked up because we will check test.pdf with *test*
4. As Destination we also added a Windows Folder:
5. RunTime Log Result. Of the original 244 files in the Source folder, 216 were copied due to the File Content Filter.
#FileTransfer
If you need any info about this new ‘List of Filename parts’ option, please let us know.
Best regards,
Limagito Team
By Limagito-Team Filters content, filter, parts
04 Apr
Exclude some subfolders and the subfolders of the excluded subfolder
Q: Exclude subfolders and the subfolders of the excluded subfolder. I’m connecting to a FTP site, looking through the folders for any files older than 28 days but I want to exclude some sub-folders and the sub-folders of the excluded folder.
My current ‘Directory Filter’ setup doesn’t seem to work:
My current ‘Dir Name’ Exclude filter:
I also changed the Directory Filter Setup – Advanced – Exclude Complete Invalid SubDirs hoping it would skip the sub folders of the GRAPHICS PURGE folder.
Limagito Team: “Reason, SubDir Search Mode (WIN) is for WIN as source only”
But in the log file we see the ‘GRAPHICS PURGE’ folder and its subfolder BUL are not being excluded.

Limagito Team:
It is possible to achieve this but you’ll need to add some extra ‘Dir Name Exclude’ Filters, leave the ones you already had.
GRAPHICS PURGE
*/GRAPHICS PURGE/*
Ads
*/Ads/*
PDF
*/PDF/*
#FileTransfer
If you need any help with this ‘Exclude some subfolders’ request, please let us know.
Best Regards,
Limagito Team
By Limagito-Team Filters exclude, subfolders