File Mover Blog

  • 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
  • 09 Jan

    How to search for a string and replace it with a CRLF

    How to search for a string and replace it with a CRLF

    Q: Is it possible to search for a string and replace it with a CRLF (as we say in windows) [Return]

    The main issue is to replace <br/> with a carriage return Line feed

    A: Yes this is possible by adding the following script:

    • We used a Windows folder as Source:

    limagito file mover Windows folder as source

    • Because we only want to process text files, we added the following include filename filter:

    limagito file mover file filter setup

    • As Destination we added our Pascal Script option, do not forget to adjust the ctOutputPath const:
      • Please add the following script: link
      • This script will replace all <br/> entries by #13#10 (CRLF)

    limagito file mover destination setup

     

    #fileconversion #managedfiletransfer #filetransfer #filemanagement

    If you need any help with this question, please let us know.

    Best Regards,

    Limagito Team

     

  • 07 Jan

    Replacement Parameter File Created Date for Source File

    Replacement Parameter File Created Date for Source File

    Q: I see options in the Replacement Parameters for the Source, File Modified Date but I would also like the option for the Source, File Created Date. Is that something that can be added?

    limagito file mover parameters

    A: We added this option in version v2024.1.7.0

    • Parameters, Added %SFA Source File last Acces time
    • Parameters, Added %SFB Source File Birth (= creation) time

    As a test we added the new parameters in our WIN as Destination setup. These new parameters will be used to create a subdirectory:

    Reminder: What are the Date & Time parameters that we can use?

    limagito file mover Replacement Parameter File Created Date

    • RunTime Log Result:

    limagito file mover runtime log result

    • Output Result:

    limagito file mover Replacement Parameter File Created Date output

    • We also added some extra Pascal Script DateTime var linked to Source File Last Access, Creation and Modified Times:
      • psFileADateTime variable = Last Access Time
      • psFileCDateTime variable = Creation Time
      • psFileMDateTime variable = Modfied Time

    An example of using these new Var in our Pascal Script as Destination option:

    limagito file mover pascal script as destination

    #managedfiletransfer #filetransfer #filemanagement

    If you need any help with this ‘Replacement Parameter File Created Date’ question, please let us know.

    Best Regards,

    Limagito Team

1 15 16 17 18 19 20 21 145
SEARCH