Filters

  • 16 Feb

    How to move to different destination based on day of week

    How to move to different destination based on day of week

    Q: I was wondering if you have an easy way to determine the day of week based on the filename and move to different locations:

    example:
    ” file_20040218_1″  that is Sunday so it go to folder1
    ” file_20040221_1″  that is Wednesday so it go to folder2
    ” file_20040222_1″  that is thursday so it go to folder2 also
    • In our example we used a Windows folder as Source:

    limagito file mover windows folder as source

    • Next, please open our “Pascal Script” option:

    limagito file mover pascal script option

    • Enable and add the following ‘On Destinations’ Pascal Script: link
      • This script will strip the filename into parts using “_” as delimiter. The second part (= Index [1] of our list),  which is the datepart, will be converted to a TDateTime var. Next we’ll use the DayOfTheWeek function to determine the day mentioned in the filename. The result of the function will be used to set the correct destination folder to our psVSA variable (= %VSA as parameter). We added ctFolder1 and ctFolder2 as Const.

    limagito fil emover pascal script option

    • In our example files from Monday to Friday will go to folder 1 and files from Saturday and Sunday will go to folder 2. This can be easily adjusted.

    limagito file mover pascal script option

    • As Destination we are using [WIN] and the Directory is set to:  %VSA\
      • This %VSA is set by the previous “On Destinations” Pascal Script

    limagito file mover destination setup

    • RunTime Log Result:

    limagito file mover runtime log result

    This is is just an example of what is possible. If you need any help with this ‘destination based on day of week’, please let us know.

    Best Regards,

    Limagito Team

    #managedfiletransfer #filetransfer #filemanagement

  • 27 Jan

    How to keep the most recent files regardless of the creation date?

    Q: Is it possible to create a rule of type: keep the 100 most recent files (regardless of the creation date)?

    A: In version v2024.1.27.0 we added this option for WIN as Source

    • Important, this new option is only available when using our [WIN] as Source (= Windows Folder or Network Share) option:

    limagito file mover windows folder as source

    • Next , select ‘Schedule’ button > ‘Advanced’ Tab:

    The new Skip option is available when the ‘Sort Order’ <> ‘OS Sort Order’

    • Skip none (default) = handle all sorted files found during scan of source folder(s)
    • Skip first x entries in file list = handle all except first x sorted files found during scan of source folder(s)
    • Skip last x entries in file list= handle all except last x sorted files found during scan of source folder(s)

    In the following setup we’ll scan the source folder(s) for files and afterwards we’ll sort them using the last write date (= modified date) from Old to New. When this is done we’ll skip the last 100 entries of this list. The result is that we’ll keep the 100 most recent files in the Source and will not handle (= copy/move/delete) them.

    limagito file mover keep the most recent files

    #managedfiletransfer #filetransfer #filemanagement

    If you need any help with this ‘keep the most recent files’ question, please let us know.

    Best Regards,

    Limagito Team

    By Limagito-Team Filters WIN ,
  • 11 Jan

    How to monitor if a file doesn’t make it to a directory

    Q: I’m looking for a way to monitor if a file doesn’t make I to a directory.  The filename of the files have the date in it.  “Importer_WXII_mm-dd-yyyy-#0.xml”.  example for today would be “Importer_WXII_01-09-2024-#.xml”  The date in the filename will not match the modified or created time stamp of the file.  I’m looking for a way to monitor the directory send a failure email if the file name is not present within a certain time span of the date.  Example would be

    If “Importer_WXII_01-11-2024-#0.xml” file exists and the current computer date is 01-10-2024 then nothing happens the file needed exists so no issues.  On the other hand.

    If “Importer_WXII_01-11-2024-#0.xml” file does not exist and the current computer date is 01-10-2024 and its 12hours before 01-11-2024 then email is sent.

    limagito file mover monitor if a file does not make it to a directory

    A: We did a test and added the following screenshots to get you started.

    • We used a Windows folder as Source:

    limagito file mover windows folder as source

     

    • We added the following Filename Include Filter. This filter will check if the xml you need is available.
    Importer_WXII_%TCD:[IncDay+1]MM-DD-YYYY:-#0.xml

    limagito file mover filename filter

    • Important, do not forget to enable ‘Allow parameters in File Name Filter’:

    limagito file mover file filter

    • Set Function to Copy, don’t worry we are not going to do anything with the xml files.

    limagito file mover function setup

    • We added a dummy ‘Pascal Script’ as Destination:
    Begin
    psExitCode:= 1;
    // ... add your code here
    psLogWrite(1, '', 'We found file: ' + psFilePath + psFileName);
    End.

    limagito fil emover pascal script as destination

    • Next, Rule Events setup:

    limagito file mover rule events option

    • Select and enable the ‘On No File Found’ event. We are going to send an email when the xml file is not available.
      • Enable and setup ‘Mail Event’:

    limagito file mover rule events setup

      • Enable and setup ‘Pascal Script’. This will add some info into the log window.
    Begin
    psExitCode:= 1;
    // ... add your code here
    psLogWrite(1, '', 'xml file not available');
    End.

    limagito file mover rule events setup

    • Schedule setup:
      • Disable Timer:

    limagito file mover timer setup

      • Add a Schedule when you would like to check for this xml file.

    limagito file mover scheduler setup

    • You can add multiple Schedules if you want.

    limagito file mover scheduler setup

    #managedfiletransfer #filetransfer #filemanagement

    If you need any help with this ‘monitor if a file doesn’t make it to a directory’ question, please let us know.

    Best Regards,

    Limagito Team

    By Limagito-Team Events Filters
1 2 3 4 5 6 7 9
SEARCH