Pascal Script Archives - Page 3 of 30 - 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
01 Sep
Count the number of occurrences of an xml field
Q: We would like to count the number of occurrences of point X in a xml file and update the file name with that value. Kindly refer the code and validate with sample file attached . Let us know if any details required from us.
Input file Name: 12345678.3959-2024.04.25-08.20.30-WIT-signed.xml
Generated Output file Name : 12345678.3959-2024.04.25-08.20.30-WIT-signed.79.xml
Content example xml file:
$limagito file mover C:\Users\coene\Downloads\Count the number of occurrences\count the number of occurrences$
A: Please have a look at the following screenshots:
We added the floowing WIN as Source:
Please open our Pascal Script option:
Enable and Add the following On Destination Pascal Script:
Link to Script, we are using the psVIA (Pascal Script Variable Integer A, = %VIA parameter):
Destination Setup, we added an Windows Folder as Destination:
Destination File Rename Setup:
As replacement parameter we’ll use the value of %VIA (= psVIA which we obtained previously in our Pascal Script):
RegEx: (.*)\.(.*)
Replacement: \1.%VIA.\2
– RunTime Log Result:
If you need any help with this ‘count the number of occurrences of a xml field’ request, please let us know.
Best Regards,
Limagito Team
#xml #managedfiletransfer #filetransfer #filemanagement
By Limagito-Team Pascal Script XML count occurrences, Xml
20 Jul
How to halt moving too many files and send an alert
How to halt moving too many files and send an alert
Q: I have a job that moves files from an external S3 bucket into our local storage. The other day a vendor hiccupped and sent 8000 files. Limagito did it’s job and moved them over, which ended up gumming up our systems. Is there any way to limit transfers? I’ve been looking through Help and haven’t seen anything yet.
For instance…I know this vendor normally sends around 10 a month. Anything over 50 would obviously be abnormal and It would be great to throttle them, even better to send an alert and let us know, so we can correct the issue.
Any help would be greatly appreciated.
A: Please have a look at the following setup. So we’ll allow only a maximum of files per month.
We used a Windows folder as Source:
– Function Setup > set Destination Options to ‘Destination Memory & Exit Cyclus on Error’
– Destination Setup:
First Destination: Pascal Script
This script will check the month and the amount of files it successfully moved
You can adjust the “ctMaxFilesAllowed” Const value to allow more or less files per month
Second Destination: your output, can be any Destination type.
Third Destination: Pascal Script
Will increase the internal counter (VIA) if a file is successfully moved
Link to both scripts, for the first and third Destination.
First Destination (Pascal Script):
Third Destination (Pascal Script):
– Open Our Rule Events option:
– Select and enable ‘On Pascal Script Error’ event. Enable ‘Enable Mail’ and adjust the mail setup. There is a test button available.
Enable the ‘Error event memory’ because otherwise you’ll get too many emails in case the maximum of files is reached.
FYI: When you would test this setup and max files are reached we added a way to reset the internal counter (max files allowed per month).
Right click on the Counter value below and select ‘Reset Counter’.
This is is just an example of what is possible. If you need any help with this ‘halt moving too many files’ setup, please let us know.
Best Regards,
Limagito Team
#managedfiletransfer #filetransfer #filemanagement
By Limagito-Team Events How-to Pascal Script halt moving, too many files