File Mover Blog

  • 12 Nov

    How to verify that the checksum of destination files remain unchanged

    How to verify that the checksum of destination files remain unchanged

    Q: Is it possible to verify that a file’s encryption (SHA) in the source folder remains unchanged when it is transferred to the destination folder? Additionally, send an email if anything has changed.

    We want to know when a change is made to the file after it has been moved to the destination folder. Additionally, get an email notification if there is a change. Another software should pull the file, we ask to check that no changes were made to the file until it transferred from the destination folder .

    A: We needed two Rules to achieve this.

    • Rule 1: Will search for the Source files to move. When a file is found, it will add some information (filename, checksum, date) about this file to a separate data text file.
    • Rule 2: Will check the Destination folder of the first Rule. It will search for moved files and if a file is found (not yet picked up), it will compare its checksum with the information found in the data text file. If there is a difference, Rule 2 will return an error which will trigger an email event.

    limagito file mover checksum of destination files

    1. First Rule: ‘OPC Move’

    Source must be a Windows folder or share:

    limagito file mover windows folder as source

    Function Setup, we enabled ‘Exit Cyclus on Error’ as Destination option:

    limagito file mover function setup

    Destination Setup, we added two Destinations:

    1. Pascal Script as Destination
    2. WIN (Windows Folder or Share) as Destination

    limagito file mover destination setup

    First Destination: Pascal Script:

    Do not forget to adjust the ctChecksumFile const. This is the data file where we keep checksum information about the files we moved.

    Important:

    • The path of this file should already exist, we’ll create the file.
    • This path should be a local path on the system where Limagito File Mover is running.
    • It should NOT be the same as the Source or Destination Path, use a folder that is only used for this purpose.

    You can download the script: here

    limagito file mover pascal script as destination

    Second Destination, is the actual Destination folder of the Source files. This is where the other software will pull the files from. Destination must be a Windows folder or share.

    limagito file mover windows folder as destination

    2. Second Rule: ‘OPC Checksum Check’

    The Source of this second Rule is the Destination of the First ‘Move’ Rule, this is important. This Second Rule will search for moved files and if a file is found (not yet picked up), it will compare its checksum with the information found in the data text file. If there is a difference, Rule 2 will return an error which will trigger an email event.

    limagito file mover Windows folder as destination

    As Schedule we used a timer and set it to every 5 seconds:

    limagito file mover schedule setup

    Function Setup: set ‘Rule Function’ to copy. We will not copy any files but this needed by the internal process.

    limagito file mover function setup

    As Destination, we added a ‘Pascal Script’. This script will compare the checksum of the files found with the information in the data text file. If there is a difference it will return an error which will trigger an email event.

    limagito filemover destination setup

    Destination: Pascal Script:

    Do not forget to adjust the ctChecksumFile const. This is the data file where checksum information about the moved files by the first ‘Move’ Rule is kept.

    Important: Use exactly the same file as you did in the Pascal Script of the first ‘Move’ Rule.

    You can download the script: here

    limagito file mover checksum of destination files

    Open our Rule events option:

    limagito file mover rule events option

    limagito filemover rule events setup

    With ‘On Error’ selected > Options Tab > Enable ‘File Error event memory’. This way you only get one email per filename.

    limagito file mover rule events setup

    Email Setup:

    limagito file mover rule events email setup

    RunTime Log Result:

    limagito file mover runtime log result

    #managedfiletransfer #filetransfer #filemanagement

    If you need any help with this ‘checksum of destination files’ request, please let us know.

    Best Regards,

    Limagito Team

    By Limagito-Team How-to WIN
  • 12 Nov

    How to merge and add filenames to csv datafiles

    How to merge and add filenames to csv datafiles

    Q: I have a new daily job where I will receive 3 CSV files. I need to merge these together and also add a new field to the data that contains the original filename as I need to split them later on in the process and use the original filename to send back to the client. Also, I may not always get all 3 files so the rule needs to work for receiving 1,2, or all 3 files.

    We will run the rule at 18:00 for example and process however many files have been uploaded, then run the rule every 1 hour after to pick up any files that the client has uploaded late. The ideal scenario would be for all 3 files to be uploaded by the client by the scan time, but they want us to be able to pick up any files they may upload late.

    The data does not contain headers either. I’m sure I have asked this before but I can’t find the solution if I have, I have found similar and have tried to amend it to suit but failed miserably.

    A: We asked and received the following example files:

    • BTW_Invites_20231023_1.csv
    • BTW_Reminders_20231023_1.csv
    • BTW_Results_20231023_1.csv

    We used a Windows folder as Source:

    limagito file mover windows folder as source

    We added the following ‘Include Filename’ Filter because we want to be sure to only process .csv files:

    limagito file mover filename filter setup

    As Destination we add our ‘Pascal Script’ option:

    limagito file mover destination setup

    Destination Pascal Script, do not forget to adjust the ctOutputPath const (Path must end with a \ ).

    The script will add the filename of the source csv file to the end of each entry of the merged csv file. The Destination merged csv file is determined by stripping parts of the source filename. In our example it will be: ‘BTW_Merged_20231023_1.csv’.

    This script is just an example and it can be adjusted so it fits your needs, just let us know.

    You can download the script: here

    limagito file mover merge and add filenames script

    RunTime Log Result:

    limagito file mover runtime log result

    #csv #filetransfer #filemanagement

    If you need any help with this ‘merge and add filenames’ option, please let us know.

    Best Regards,

    Limagito Team

  • 12 Nov

    How to skip a path in http as source method 2

    How to skip a path in http as source method 2

    Q: There are times when downloads are no longer needed for a couple months, is there something I can place in front of the URL to that they are skipped? I tried a semicolon and that did not work 🙂

    A: Option added in version v2023.11.10.0

    When the URL starts with a ! (exclamation mark) then it will be skipped, example: !https://limagito.com/helpxfm/IntroXFM.pdf
    limagito file mover skip a path in http

    #filetransfer #filemanagement

    If you need any help with this ‘skip a path in http’ option, please let us know.

    Best Regards,

    Limagito Team

    By Limagito-Team HTTP
1 19 20 21 22 23 24 25 145
SEARCH