Filters Archives - Page 3 of 10 - File transfer tool from Limagito

03 Sep
How to exclude files if the date falls on a Sunday or Monday
How to exclude files if the date falls on a Sunday or Monday
Q: I have a task where I’m using change notify to check when a new folder is added. I’m filtering the folder by using %TCD:mmdd:, but the problem is I want to exclude the folders if the date falls on a Sunday or Monday. Is there a filter that would allow me to do that?
A: This is possible using our Pascal Script option.
Open our Pascal Script setup:
Please enable and add the following ‘On RuleBegin’ Pascal Script:
Begin psExitCode:= 1; // ... add your code here IF DayOfTheWeek(Now) in [1,7] Then psExitCode := 0; (* The DayOfTheWeek function returns an index number for the day of the week : 1 = Monday 2 = Tuesday 3 = Wednesday 4 = Thursday 5 = Friday 6 = Saturday 7 = Sunday *) End.
If you need any help with this ‘exclude files if the date’ request, please let us know.
Best Regards,
Limagito Team
#managedfiletransfer #filetransfer #filemanagement
By Limagito-Team Filters Pascal Script check date, exclude, exclude date
30 Jun
How to move files to different destinations based on the file extension
How to move files to different destinations based on the file extension
Q: Since we are dealing with Pharma equipment where we are pulling data off. We would like to be able to split the data into ‘readable’ (ie Txt, excel) and permanent (ie PDF, Image) and place the file types in different subdirectories on the target. At this time, my only solution would be to create two separate rules to accomplish this. Given that there are so many features hidden in your tool that I keep learning about, I was wondering if that was a feature that is in the Mover that I have not found.
A: Yes this is possible using our Script option.
We used a Windows Folder as Source:
We added the following Filename Include Filters. These are the file extensions we want to split to different destinations.
In this example we added 4 destinations. Each Destination has a unique ID:
ID1
ID2
ID3
ID4
We’ll use this Destination ID in our script.
Next, please open our Pascal Script option:
Enable and add the following ‘On Destinations’ Pascal Script:
Var tmpFileExt: String; Begin psExitCode:= -1; // ... add your code here tmpFileExt := ExtractFileExt(psFilename); // psLogWrite(1, '', 'Check File Extension ' + tmpFileExt + ' from ' + psFilename); // Check If Destination ID is ID1 AND do we have a .txt file? If (psDestinationID = 'ID1') Then If SameText(tmpFileExt, '.txt') Then psExitCode := 1; // Check If Destination ID is ID2 AND do we have .xls/.xlsx files? If (psDestinationID = 'ID2') Then If SameText(tmpFileExt, '.xls') OR SameText(tmpFileExt, '.xlsx') Then psExitCode := 1; // Check If Destination ID is ID3 AND do we have a .pdf file? If (psDestinationID = 'ID3') Then If SameText(tmpFileExt, '.pdf') Then psExitCode := 1; // Check If Destination ID is ID4 AND do we have .png/.jpg/.bmp files? If (psDestinationID = 'ID4') Then If SameText(tmpFileExt, '.png') OR SameText(tmpFileExt, '.jpg') OR SameText(tmpFileExt, '.bmp') Then psExitCode := 1; End.
RunTime Log Result:
This is is just an example of what is possible. If you need any help with this ‘different destinations based on the file extension’, please let us know.
Best Regards,
Limagito Team
#managedfiletransfer #filetransfer #filemanagement
By Limagito-Team Filters Pascal Script different destinations, file extension
17 Mar
How to move files to different ftp folders under the same root
How to move files to different ftp folders under the same root on the same server
Q: Conditional destination request. We are looking for an easy way (one channel) to move files to different ftp folders (more than 100 folders) under the same root on the same server, where filename prefix (3 char) is the key to which folder. Prefix and folder name are different.
A few examples:
BBL > folder1
ABB > folder2
BYR > folder4
BYP > folder5
DAT > folder6
I have been looking at your blog post without finding anything like it. The list of prefixes and folders could be a text table in the script or in a csv file. Do you have a script for this?
A: Yes this is possible, please have a look at the following screenshots. This setup can be used with other Sources and Destinations too.
– We used a Windows folder as Source:
– Open our Pascal Script option
Please enable and add the following ‘On Destination’ Pascal Script:
Please add the following script: link
The script strips the first 3 characters from the filename by using ‘copy(psFilename, 1, 3)’
The stripped part is compared with ‘BBL’, ‘ABB’ .. ‘DAT’
Depending on the result of the compare, a folder name is added to our variable psVSA ( pascal script Var String A )
This psVSA variable will be used in the Destination setup as parameter (%VSA, which contains data from psVSA)
You’ll need to adjust the folder names and add more prefixes if needed
– In the FTP as Destination Setup, please adjust the ‘Create Subdir’ option to: %VSA\%SFS
Here we used the %VSA parameter, set in the Pascal Script, which contains the desired subdirectory name
– Feedback customer:
That looks easy. Thank you very much.
If you need any help with this new option, please let us know.
Best Regards,
Limagito Team
#ftp #sftp #managedfiletransfer #filetransfer #filemanagement
By Limagito-Team Filters FTP Pascal Script SFTP Conditional, different folders