File mover software: move, copy, delete your files with our filemover | Blog | ORDER NOW

Contact Us Now

[contact-form-7 id="1125" title="Contact form 1"]

File Mover Blog

  • 17 Aug

    SQL Batch Move option

    Dear Users

    On our todo list, for this new SQL destination, is to add a ‘Batch Move’ option. This option will handle a csv text data file and will insert the data content to a database.

    In version v2019.8.17.0 a first relase of this ‘Batch Move’ option was added to SQL as Source and Destination. It is the first release so many features still need to be added to this option.

    At the moment:

    SQL as Source: Batch Move will get the data from the selected database and will output this to csv file. We  automatically recognize the data source format but also will add an options later for a manual setup.

    SQL as Destination: Batch Move will take the data from the source (csv) file and will insert this data into the Database.

    You can choose between SQLite, Microsoft SQL, PostgreSQL, MySQL and MariaDB as Database. Don’t forget to set the Table Name in the Batch Move tab.

     

    Feedback would be much appreciated.

    Regards,
    Limagito Team

    By Limagito-Team SQL ,
  • 17 Aug

    Connecting to a MySQL / MariaDB Database

    Dear Users,

    MySQL: The world’s most popular open source database.

    MariaDB: One of the most popular database servers. Made by the original developers of MySQL. Guaranteed to stay open source.

    We’ve added MySQL / MariaDB as Database Connection option. This connection option is now available for:

    – Database Logging option (added in version v2019.8.17.0)
    – SQL as Source option (added in version v2019.8.17.0)
    – SQL as Destination option (added in version v2019.8.17.0)

    We are using a database framework called FireDAC. When connecting to a database the framework needs a client library (driver) suited for the type of database it is trying to connect. This client library needs to be installed by the user of our File Mover, we don’t deliver any database client drivers. The database client library for x86 or x64 are not the same so be sure to check which version of LimagitoX you are using (x86 or x64).

    If the framework doesn’t find the library files then it will popup a message like:

    The message gives you an indication that some dll could not be found. In the MySQL / MariaDB connection error above it could no locate libmysql.dll. As previously mentioned, the dll’s you need are different for x86 and x64.

    >This is what we did in order to connect successfully to a MySQL / MariaDB database in the x86 version of LimagitoX:

    1. We downloaded the zipped Binaries of version 10 (mariadb-10.4.7-win32.zip) @ https://downloads.mariadb.org/mariadb/10.4.7/#os_group=windows
    2. Unzipped the following file from the mariadb-10.4.7-win32\lib subfolder: libmariadb.dll
    3. Renamed it to libmysql.dll and moved the file to the 32 bit program folder of LimagitoX File Mover: C:\Program Files (x86)\LimagitoX File Mover

    >This is what we did in order to connect successfully to a PostgreSQL database in the x64 version of LimagitoX:

    1. We downloaded the zipped Binaries of version 10 (mariadb-10.4.7-winx64.zip) @ https://downloads.mariadb.org/mariadb/10.4.7/#os_group=windows
    2. Unzipped the following files from the mariadb-10.4.7-winx64\lib subfolder: libmariadb.dll
    3. Renamed it to libmysql.dll and  moved the file to the 64bit program folder of LimagitoX File Mover: C:\Program Files\LimagitoX File Mover

    Microsoft SQL Server vs. MySQL

    Regards,

    Limagito Team

    By Limagito-Team SQL ,
  • 13 Aug

    Connecting to a PostgreSQL Database

    Dear Users,

    PostgreSQL: The World’s Most Advanced Open Source Relational Database

    We got a request to add PostgreSQL in the new SQL as Destination option. We decided to add this PostgreSQL connection option to:

    – Database Logging option (added in version v2019.8.12.0)
    – SQL as Source option (added in version v2019.8.15.0)
    – SQL as Destination option (added in version v2019.8.15.0)

    We are using a database framework called FireDAC. When connecting to a database the framework needs a client library (driver) suited for the type of database it is trying to connect. This client library needs to be installed by the user of our File Mover, we don’t deliver any database client drivers. The database client library for x86 or x64 are not the same so be sure to check which version of LimagitoX you are using (x86 or x64).

    If the framework doesn’t find the library files then it will popup a message like:

    The message gives you an indication that some dll could not be found. In the PostgreSQL connection error above it could no locate libpq.dll. We found out that you need a couple of dll’s in order to connect to a PostgreSQL database. As previously mentioned, the dll’s you need are different for x86 and x64.

    >This is what we did in order to connect successfully to a PostgreSQL database in the x86 version of LimagitoX:

    1. We downloaded the zipped Binaries of version 10 (Win x86-32) @ https://www.enterprisedb.com/download-postgresql-binaries
    2. Unzipped the following files from the pgslq\bin subfolder:
      1. libcrypto-1_1.dll
      2. libiconv-2.dll
      3. libintl-8.dll
      4. libpq.dll
      5. libssl-1_1.dll
    3. Moved these files to the 32 bit program folder of LimagitoX File Mover: C:\Program Files (x86)\LimagitoX File Mover

     

    >This is what we did in order to connect successfully to a PostgreSQL database in the x64 version of LimagitoX:

    1. We downloaded the zipped Binaries of version 10 (Win x86-64) @ https://www.enterprisedb.com/download-postgresql-binaries
    2. Unzipped the following files from the pgslq\bin subfolder:
      1. libcrypto-1_1-x64.dll
      2. libiconv-2.dll
      3. libintl-8.dll
      4. libpq.dll
      5. libssl-1_1-x64.dll
    3. Moved these files to the 64bit program folder of LimagitoX File Mover: C:\Program Files\LimagitoX File Mover

    Microsoft SQL Server vs. PostgreSQL

    Regards,

    Limagito Team

    By Limagito-Team SQL
1 … 96 97 98 99 100 101 102 … 135
SEARCH
CATEGORIES
ARCHIVES
TAGS
365 api code command csv date delete drive Eldos email error feature filename filter ftp HL7 install License limagito limagitox log monitor multiple oauth OAuth2 parameter parameters Pascal pdf Remote rename Script service SFTP SharePoint sign SMTP SQL SSH unzip vendor week xls Xml zip

Limagito filemover is an automated file mover solution handling everything from moving, deleting to copying files.

Please don’t hesitate to contact us if you have any questions about our product and services.

DISCOVER OUR SITE
How to use 7z compression in Pascal Script
March 30, 2024 no responses
How to authenticode sign an executable exe or dll
March 24, 2024 no responses
How to map a network drive in limagito filemover
March 21, 2024 no responses
© 2007-2024 IT services & software development by CPsoft // Webdesign & webhosting by Siteplan