• 14 Jul

    SFTP Allowed Algorithms in Limagito File Mover

    SFTP Set Allowed Algorithms in Limagito File Mover

    14th of July 2024

    By default, Limagito File Mover orders algorithms according to best practices, and pays attention to vulnerabilities such as the “Terrapin Attack”.

    The following algorithms are supported by Limagito File Mover when our second API Vendor – CK is selected:

    Hostkey:
    ssh-ed25519
    rsa-sha2-256
    rsa-sha2-512
    ecdsa-sha2-nistp256
    ecdsa-sha2-nistp384
    ecdsa-sha2-nistp521
    ssh-rsa
    ssh-dss
    Key Exchange:
    curve25519-sha256
    curve25519-sha256@libssh.org
    ecdh-sha2-nistp256
    ecdh-sha2-nistp384
    ecdh-sha2-nistp521
    diffie-hellman-group14-sha256
    diffie-hellman-group1-sha1
    diffie-hellman-group14-sha1
    diffie-hellman-group16-sha512
    diffie-hellman-group18-sha512
    diffie-hellman-group-exchange-sha256
    diffie-hellman-group-exchange-sha1

    Ciphers:
    aes128-ctr
    aes256-ctr
    aes192-ctr
    aes128-cbc
    aes256-cbc
    aes192-cbc
    aes128-gcm@openssh.com
    aes256-gcm@openssh.com
    twofish256-cbc
    twofish128-cbc
    blowfish-cbc
    (also chacha20-poly1305@openssh.com if explicitly allowed by the application)

    MAC Algorithms:
    hmac-sha2-256
    hmac-sha2-512
    hmac-sha1
    hmac-ripemd160
    hmac-sha1-96
    hmac-md5
    (also the following etm algorithms if explicitly allowed)
    hmac-sha1-etm@openssh.com
    hmac-sha2-256-etm@openssh.com
    hmac-sha2-512-etm@openssh.com

     

    Best Regards,

    Limagito Team

    #SFTP #managedfiletransfer #filetransfer #filemanagement

    By Limagito-Team SFTP
  • 30 Jun

    How to move files to different destinations based on the file extension

    How to move files to different destinations based on the file extension

    Q: Since we are dealing with Pharma equipment where we are pulling data off. We would like to be able to split the data into ‘readable’ (ie Txt, excel) and permanent (ie PDF, Image) and place the file types in different subdirectories on the target. At this time, my only solution would be to create two separate rules to accomplish this. Given that there are so many features hidden in your tool that I keep learning about, I was wondering if that was a feature that is in the Mover that I have not found.

    A: Yes this is possible using our Script option.

    • We used a Windows Folder as Source:

    limagito file mover windows folder as source

    • We added the following Filename Include Filters. These are the file extensions we want to split to different destinations.

    limagito file mover filename filter

    • In this example we added 4 destinations. Each Destination has a unique ID:
      • ID1
      • ID2
      • ID3
      • ID4

    We’ll use this Destination ID in our script.

    limagito file mover destination setup

    • Next, please open our Pascal Script option:

    limagito file mover pascal script option

    • Enable and add the following ‘On Destinations’ Pascal Script:
    Var
      tmpFileExt: String;
    Begin
      psExitCode:= -1;
      // ... add your code here
      tmpFileExt := ExtractFileExt(psFilename);
      // psLogWrite(1, '', 'Check File Extension ' + tmpFileExt + ' from ' + psFilename);
      // Check If Destination ID is ID1 AND do we have a .txt file?
      If (psDestinationID = 'ID1') Then 
        If SameText(tmpFileExt, '.txt') Then
          psExitCode := 1; 
      // Check If Destination ID is ID2 AND do we have .xls/.xlsx files?
      If (psDestinationID = 'ID2') Then
        If SameText(tmpFileExt, '.xls') OR SameText(tmpFileExt, '.xlsx') Then
          psExitCode := 1; 
      // Check If Destination ID is ID3 AND do we have a .pdf file?
      If (psDestinationID = 'ID3') Then 
        If SameText(tmpFileExt, '.pdf') Then
          psExitCode := 1;  
      // Check If Destination ID is ID4 AND do we have .png/.jpg/.bmp files?
      If (psDestinationID = 'ID4') Then
        If SameText(tmpFileExt, '.png') OR SameText(tmpFileExt, '.jpg') OR SameText(tmpFileExt, '.bmp') Then
          psExitCode := 1;       
    End.

    limagito file mover different destinations based on the file extension

    • RunTime Log Result:

    limagito file mover runtime log

    This is is just an example of what is possible. If you need any help with this ‘different destinations based on the file extension’, please let us know.

    Best Regards,

    Limagito Team

    #managedfiletransfer #filetransfer #filemanagement

  • 21 Apr

    How to import data into a SQL table where a primary key as guid is needed

    How to import data into a SQL table where a primary key as guid is needed

    Q: I have a question about importing data into a SQL table where a primary key (guid/uniqueidentifier) needs to be generated. In a SQL command like the below, NEWID() will create the required id. Can this be achieved in Limagito?

    limagito file mover sql primary key as guid

    INSERT INTO dbo.testtable(intconID, caseID)

    VALUES (NEWID(), 1)

    Error received:

    8/04/2024 12:37:55 PM TFDPhysMSSQLCommand DB SQL Exception: [FireDAC][Phys][ODBC][Microsoft][ODBC SQL Server Driver][SQL Server]Cannot insert the value NULL into column ‘intconID’, table ‘dbo.TestTable’; column does not allow nulls. INSERT fails.

    8/04/2024 12:37:55 PM Batch Move Exception: [FireDAC][Phys][ODBC][Microsoft][ODBC SQL Server Driver][SQL Server]Cannot insert the value NULL into column ‘intconID’, table ‘ dbo.TestTable ‘; column does not allow nulls. INSERT fails.

    A: We added a new feature in version v2024.4.9.0 which replaces the NEWID() in the WriteSQL by a GUID when the Rule is triggered.

    If you need any help with this ‘primary key as guid’ request, please let us know.

    Best Regards,

    Limagito Team

    #sql #managedfiletransfer #FileManagement #filetransfer

    By Limagito-Team SQL , , ,
1 2 3 4 10
SEARCH