• 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:

    limagito file mover pascal script option

    • 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.

    limagito file mover exclude files if the date

    If you need any help with this ‘exclude files if the date’ request, please let us know.

    Best Regards,

    Limagito Team

    #managedfiletransfer #filetransfer #filemanagement

  • 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:

    limagito file mover windows folder as source

    • Please open our Pascal Script option:

    limagito file mover 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):

    limagito file mover count the number of occurrences

    • Destination Setup, we added an Windows Folder as Destination:

    limagito file mover destination setup

    • Destination File Rename Setup:

    limagito file mover 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
    limagito file mover file renaming setup
    – RunTime Log Result:
    limagito file mover 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

1 2 3 4
SEARCH