File Mover Blog

  • 09 Jul

    List of filename parts to move in a text file with Limagito File Mover

    Q: Is it possible to have a list of filename parts in a text file and use this to move any files whose name matches the whole filename or part file name in a directory? I’ve had a look on the blog but I think that is only for 1 file using a part filename.

    A: In version v2021.7.9.0 we added a new option to achieve this. We added some screenshots to get you started.

    1. Windows Folder as Source. This folder will contain all files. We’ll filter them using information from a seperate text file.

    Limagito File Mover Source Setup

    Our Source folder contains 244 files:

    Limagito File Mover Source Files

    2.Next, please open the Rule Parameters option of this Rule.

    Limagito File Mover Rule Parameters

    Select the text file containing the filename parts we’ll use to filter the files we want to copy. We selected ‘On Rule Begin’ as Load File Mode, so the content of this text will will be reloaded on each Rule Begin. We also enabled ‘Reload only when file content changes’ to prevent unnecessary loading of this file.

    Limagito File Mover File Content Setup

    Content of the text file we’ll use to filter the files we want to copy, it contains parts of filenames.

    Limagito File Mover File Parts as Content Filter

    3. Open the File Filter setup and select ‘File Contents > Include’ Tab. Enable the new option called ‘Add wildcards to File Content Entries in search’.

    When enabled wildcards will be added to each entry of the file content (in memory) during the search.
    i.e.
    Suppose file name found in source folder would be: test.pdf
    And the include FileContent would contain: test
    With this option enabled the file would be picked up because we will check test.pdf with *test*

    Limagito File Mover File Filter Setup

    4. As Destination we also added a Windows Folder:

    Limagito File Mover Destination Setup

    5. RunTime Log Result. Of  the original 244 files in the Source folder, 216 were copied due to the File Content Filter.

    Limagito File Mover RunTime Log Result

    #FileTransfer

    If you need any info about this new ‘List of Filename parts’ option, please let us know.

    Best regards,

    Limagito Team

    By Limagito-Team Filters , ,
  • 24 May

    Limagito FTPS Server released in version v2021.5.24.0

    In version v2021.5.24.0 we released our Limagito FTPS Server. This FTPS server is a part of Limagito File Mover and available for all +Plus users (Free Lite+, Single+, Site+ and Corporate+).

    • FTPS Server Setup:

    We added the possibility to choose between ‘SFTP’ or ‘FTPS’ vs ‘SFTP & FTPS’. Each much use their own port.

      • Implicit FTPS: default 990 (TLS encryption up to v1.3)
      • Explicit FTPS: default 21 (TLS encryption up to v1.3)
      • Plain FTP: default 21 (No encrypton)

    Limagito File Mover FTP Server Setup

    • FTPS Server User Accounts Setup:

    An account can be used for ‘SFTP’ or ‘FTPS’ vs ‘SFTP & FTPS’.

    Limagito File Mover FTP Server Accounts Setup

    • FTPS Server Guard Setup:

    The Guard protection will work for SFTP and FTPS.

    Limagito File Mover FTP Server Guard Setup

    • FTPS Server Additional Setup:

    We divided some of the SFTP options so they can have different values for FTPS.

    Important if you want the FTPS server to support unicode characters then you must set the ‘FTPS Character Set’ option to ‘utf-8’.

    Limagito File Mover FTP Server Additional Setup

    • IMPORTANT: When testing the FTPS Server using our Limagito File Mover you’ll need to select the Second API Vendor – CK.

    Limagito FTP Server Client Setup

    #FileTransfer

    If you need any info about this new feature, please let us know.

    Best regards,

    Limagito Team

    By Limagito-Team FTP ,
  • 24 May

    SSL Security Error on SQL-Source for MSSQL in Limagito File Mover

    User: It seems that we started to receive a connection error by SQL-source which should connect to a Microsoft SQL Server recently.

    This is the error message:

    TFDPhysMSSQLConnection DB SQL Exception: [FireDAC][Phys][ODBC][Microsoft][ODBC SQL Server Driver][DBNETLIB]SSL Security error

    Open Database Exception [FireDAC][Phys][ODBC][Microsoft][ODBC SQL Server Driver][DBNETLIB]SSL Security error

    I googled a little and found out that it might have something to do with the fact that SQL Server now uses TLS 1.2 as standard

    A: We adviced the user to switch from MSSQL to ODBC as ‘Database Vendor’

    Limagito File Mover SSL Security Error ODBC

    .. and asked them to check the following link:

    ssl-security-error-for-microsoft-sql-driver

    Limagito File Mover SSL Security Error

     

    We received the following feedback:

    • Installed recent ODBC Driver for MSSQL 17 to the Server where Limagito File Mover is running.
    • Created System-DSN for specific Database with that newest ODBC-Driver.
    • Switched settings in Limagito Rules to ODBC.
    • >> Seems to work!

    #FileTransfer

    If you need any info about this error, please let us know.

    Best regards,

    Limagito Team

1 61 62 63 64 65 66 67 136
SEARCH