File Mover Blog

  • 17 Feb

    Problem import data from CSV to MSSQL

    Problem import data from CSV to MSSQL

    Q: When I try to import CSV to MSSQL, I have the error because it recognizes the Field “DatabaseId” as a “Date” type. But it must be a String… How can I change this ?

    I also uncheck the checkbox “Include Metadata” in the “Bacth Move” tab. Doesn’t change anything…

    limagito file mover sql as destination

    **************

    2/16/2026 10:57:30 AM Field[43] Name: BranchName, Type: String, Size: 21

    2/16/2026 10:57:30 AM BatchMove Fail Error: [FireDAC][Comp][DM]-607. Bad text value [139173-01] format for mapping item [DatabaseId]. ‘139173-01’ is not a valid date

    2/16/2026 10:57:30 AM Batch Move Exception: [FireDAC][Comp][DM]-607. Bad text value [139173-01] format for mapping item [DatabaseId]. ‘139173-01’ is not a valid date

    2/16/2026 10:57:30 AM Total Files Redo, Count: 1 & Size: 924008

    ***********

    limagito file mover Problem import data from CSV

    A: Open your SQL as Destination setup. Default we have an automatic ‘GuessFormat’ option. You can override this, hover over the STRING field to get information.

    limagito file mover Problem import data from CSV

    • Feedback customer

    It works now. Thanks for your support !

    If you need any help about this ‘Problem import data from CSV’ question, please let us know.

    Best Regards,

    Thomas

    #csv #sql #managedfiletransfer #filetransfer #filemanagement

  • 16 Feb

    Custom logging feature to feed a Zabbix monitoring system

    Q: We are using LimagiTO File Mover’s custom logging feature to feed a Zabbix monitoring system. We currently use the following log format:

    %{DATETIME}|%{LEVEL}|%{LEVELINT}|%{THREADID}|%{HOSTNAME}|%{RULEID}|%{RULENAME}|%{MESSAGE}
    We are trying to determine whether a complete rule execution succeeded or failed by parsing the log. The challenge we face is that we have no reliable way to group all log lines belonging to the same execution run of a rule:
    • THREADID changes between runs, which is useful, but we observed that a single rule execution can sometimes involve multiple threads (different THREADIDs writing log entries for the same run).
    • DATETIME can span several seconds or minutes for a single execution, so timestamp alone is not sufficient.
    • There is no unique execution/run identifier in the available logging tags.
    Could a %{RUNID} tag (or equivalent) be added that would assign a unique identifier to each rule execution cycle? This would allow us to reliably group all log entries from the same run and determine whether that run completed with or without errors.
    As a secondary question: is the multi-thread behavior for a single rule execution expected? Under what circumstances does a rule execution produce log entries with different THREADIDs?
    Thank you for considering this.
    A: In version v2026.2.16.0 we added the %{RUNID} tag

    limagito file mover C:\Data\Foto\2026\feed a Zabbix monitoring system\feed a Zabbix monitoring system

    Tags:

    ********************************************************************************
    ***                  Information about the Limagito File Mover Logging Tag(s)                   ***
    ********************************************************************************

    The following predefined variables can be used to produce a custom message output format:

    APPNAME : Customizable variable (by default set as filename without extension)

    APPVERSION : Application file version

    APPPATH : Application run path

    CPUCORES : Number of CPU cores

    DATETIME : Date & time log item occurs

    ENVIRONMENT : Customizable variable (normally Production, Test, etc)

    DATE : Date log item occurs

    HOSTNAME : Computer name

    LEVEL : Level or Eventype

    LEVELINT : Level as numeric

    LOGSOURCE : Description of log source

    MESSAGE : Message sent to logger

    OSVERSION : OS version

    PLATFORM : Customizable variable (normally Desktop, Mobile, etc)

    RULEID : RuleID number

    RULENAME : RuleName

    RUNID : Unique identifier to each rule execution cycle

    THREADID : Thread ID log item set

    TIME : Time log item occurs

    USERNAME : Logged user name

     

    If you need any help about this ‘feed a Zabbix monitoring system’ question, please let us know.

    Best Regards,

    Limagito Team

    #zabbix #managedfiletransfer #filetransfer #filemanagement

  • 10 Feb

    How to use azure AD RBAC authentication instead of storage keys

    Q: Does Filemover support authentication to Azure Storage using Azure AD with RBAC roles (for example “Storage Blob Data Contributor” or “Storage Blob Data Reader”), instead of using storage account keys or SAS tokens? If this is not currently supported, is it something that is planned for a future release? For security reasons, we are looking to avoid the use of storage account keys and would prefer to rely on role-based access control where possible.

    A: This option was added for Azure Block Blobs in v2026.2.9.0

    • In our example we used Azure as Source:

    limagito filemover azure as source

    • The new Authentication option “Service-to-service Access Token request” is only available for Block Blobs:

    limagito file mover azure AD RBAC authentication

    • Next we selected our Azure Storage Container

    limagito file mover azure container setup

    limagito file mover azure AD RBAC authentication

    Assign Role via Azure Portal:

    1. Go to your Storage Account
    2. Click on Access Control (IAM)
    3. Click Add role assignment
    4. Select role: Storage Blob Data Contributor
    5. Assign access to: User, group, or service principal
    6. Select members: Search for your Service Principal (Application name)
    7. Click Review + assign

    limagito file mover azure storage account iam setup

    Required Azure RBAC roles for Block Blobs:

    To use Block Blobs with OAuth, your Service Principal must have one of these roles:

    RolePermissionsUse Case
    Storage Blob Data ReaderRead, ListRead/download only
    Storage Blob Data ContributorRead, Write, DeleteUpload + Download

    Storage Blob Data Contributor:

    Limagito7 was added using Azure ‘App registrations’

    limagito filemover azure app registrations

    limagito file mover azure app registrations

    Here you can find:

    • Application (Client) ID needed in OAuth2 setup
    • Directory (Tenant) ID needed in OAuth2 setup

    limagito filemover application client ID

    We added a ‘Client secret’ which Value field is used as Client Secret in the OAuth2 setup of our filemover.

    limagito filemover azure client secrets

     

    There is also an alternative, using a ‘Certificate’ instead of a ‘Client secret’, you can add this under ‘Certificates & secrets’ > Certificates > Upload certificate (public part of the key)

    limagito file mover azure certificates and secrets

    In this case the OAuth2 does not need a Client Secret, this is replaced by the Private Key file.

    limagito file mover azure oauth2 setup

    Select Auth Options:

    limagito file mover private key authentication

    If you need any help about this new ‘azure AD RBAC authentication’ option, please let us know.

    Best Regards,

    Limagito Team

    #azure #managedfiletransfer #filetransfer #filemanagement

    By Limagito-Team Azure , ,
1 2 3 4 5 6 168
SEARCH