• 12 Oct

    SFTP Fingerprint option added to Limagito file mover

    Q: I have a question related to SFTP fingerprints. When I create a new rule and add new Source -> SFTP, where can I configure the fingerprints of the Source host’s fingerprint? I would like to be sure that the server is valid.

    A: We allow the fingerprint of the sftp server you added as source automatically. At this moment there is no option to add fingerprints of the host manually.

    Q: Thanks for the very quick answer. Hopefully it will be possible on the next version. There is a possibility for MiTM attack.

    A: In version v2024.10.12.0 we added the Fingerprint option for SFTP as Source and Destination.

    The goal of the fingerprint is to verify the authenticity and integrity of the SFTP server you’re connecting to. This is a short, unique representation (a hash) of the server’s public key. The purpose of this fingerprint is to help you confirm that you’re connecting to the correct server and not a malicious or imposter server. This is optional and by default we allow any fingerprint.

    E.g.

    The default Hash Algorithm is MD5

    68:ff:d1:4e:6c:ff:d7:b0:d6:58:73:85:07:bc:2e:d5

    Please add one if the following prefixes to adjust the default Hash Algorithm:

    SHA256:
    SHA384:
    SHA512:
    SHA1:
    SHA3-224:
    SHA3-256:
    SHA3-384:
    SHA3-512:

    limagito file mover sftp fingerprint option

    • In case you receive an error message regarding the Fingerprint Compare, please increase the RunTime Log Level to ‘Debug’:

    Limagito file mover Logging option

    limagito file mover runtime log setup

    • RunTime Log example:
      • If the the fingerprint in your SFTP setup is not correct, the following error message will appear
      • Increasing the log level of the RunTime log will show you the Fingerprint the SFTP server is sending
      • You can compare this to the one in your setup, in the example below we used the SHA256 hash algorithm

    limagito file mover runtime log sftp fingerprint

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

    Best Regards,

    Limagito Team

    #sftp #managedfiletransfer #filetransfer #filemanagement

    By Limagito-Team SFTP ,
  • 11 Oct

    How to move two linked files at the same time

    How to move two linked files at the same time

    Q: I have a particular issue and maybe you have an answer? I need to build in a delay in the moving of files. Each time it involves 2 linked files that must be moved at the same time, the next move of 2 files may only occur when the schedule is triggered again. It is about O and R in filename files. It happens that several are created in 1 minute. However, I want 1 set of O and R files per running move rule to be moved. Do you have a magnificent solution for this that I can implement in the rule?

    limagito filemover move two linked files

     

    A: This should be possible using our Pascal Script option. Please have a look at the following blog article.

    • We used a Windows folder as Source:

    limagito file mover windows folder as source

    • Since we should copy only one set of files (linked O and R files) during each scan, we adjusted the ‘Max. Files processed in One Scan’ to 2.

    limagito file mover maximum files processed in one scan

    • Open our Pascal Script option:

    limagito file mover pascal script option

    • Enable and Add the following ‘On Rule Begin’ Pascal Script:
      • The scripts are available at the following link

    limagito file mover pascal script setup

    • Enable and Add the following ‘On Rule Begin’ Pascal Script:

    limagito file mover move two linked files pascal script

    • The Function is set to ‘Move’:

    limagito file mover function setup

    • As Destination we also used a Windows folder:

    limagito file mover destination setup

    limagito file mover windows folder as destination

     

    If you need any help with this ‘move two linked files’ question, please let us know.

    Best Regards,

    Limagito Team

    #managedfiletransfer #filetransfer #filemanagement

  • 10 Oct

    File Copy with Destination path and name lookup

    File Copy with Destination path and name lookup

    Q: I have a source folder that has a ton of subfolders and files with a guid type filename. I have the translation from the source path\filename to the new desired path\filename. Is there a way to do this in Limagito?  I can put the list in any file format (delimited file, json, xml) or from a sql lookup. Is it possible to only copy files that it finds?

    A: Should be possible using a csv file with a | (pipe) between source and destination files. I’ve added some screenshots to get you started.

    – We used a Windows folder as Source:

    limagito file mover windows folder as source– Open our Pascal Script option:
    limagito file mover pascal script option

    • Enable and Add the following Pascal Script:
      • Do not forget to adjust the ctCSVFile Const value
      • We’ll use this file to determine the Destination Path and File. Content example file we used (csv.txt):
        limagito file mover name lookup
      • Be sure to use a | (pipe) as separator
    Var
      tmpName, tmpValue: String;
      iList: Integer;
      tmpList: TStringList;
    Const
      ctCSVFile = 'C:\Test\Csv\csv.txt';
    Begin
      psExitCode:= 0;
      psVSA := '';
      psVSB := '';
      // ... add your code here
      tmpList := TStringList.Create;
      Try
        tmpList.NameValueSeparator := '|';
        Try
          tmpList.LoadFromFile(ctCSVFile);
          // Iterate
          For iList := 0 to (tmpList.Count-1) Do
          Begin
            tmpName := tmpList.Names[iList];
            tmpValue := tmpList.ValueFromIndex[iList];
            If SameText(psFilePath+psFileName, tmpName) Then
            Begin
              psVSA := ExtractFilePath(tmpValue); // FilePath
              psCreatePath(psVSA);
              psVSB := ExtractFileName(tmpValue); // FileName
              // Set Result
              psExitCode := 1;
              // Break
              Break;
            End;
          End;
        Except
          psLogWrite(1, '', 'Error loading CSV: ' + ctCSVFile);
        End;
      Finally
        tmpList.Free;
      End;
    End.

    limagito file mover pascal script setup– Destination Setup:
    limagito file mover destination setup

    • We used a Windows folder as Destination:
      • Please use %VSA as Directory
      • The parameter %VSA will contain data from the previous Pascal Script

    limagito file mover windows folder as destination

    • File Renaming Setup:

    limagito file mover destination file renaming setup

    • RegEx:  (.*)
    • Replacement:  %VSB
      • Parameter %VSB will contain data from the previous Pascal Script

    limagito file mover file renaming setup– RunTime Log Result:
    limagito file mover runtime log result
    If you need any help with this ‘name lookup’ question, please let us know.

    Best Regards,

    Limagito Team

    #managedfiletransfer #filetransfer #filemanagement

    By Limagito-Team Filters WIN
1 2 3 4
SEARCH