File Mover Blog

  • 04 Feb

    How-to use Gmail to send emails from LimagitoX File Mover

    We’ve added some screenhots to get you started using the GMail SMTP server.

    • Server Setup

    LimagitoX-SMTP-GMail-Setup

    • Security Setup

    LimagitoX-SMTP-GMail-Security-Setup

    • We are using OAuth2 authentication so we also need to fill in this setup

    LimagitoX-SMTP-GMail-OAuth2-Setup

    • Test email Setup (using the Rule Events)

    • Trigger email, result Successful

    If you need any help, please let us know.

    Best Regards,

    Limagito Team

    By Limagito-Team SMTP , ,
  • 02 Feb

    SQL Batch Move option, part 3

    In this example we are going to read records from a csv file and putting them into a SQL Server using our SQL as destination option.

    The Source setup is a Windows directory searching for *.csv file using our File Filter Setup.

    Filename include filter was added, only *.csv files.

    Added SQL as Destination.

    SQL Setup, Set ‘QRY Type’ to ‘Batch Move of Data’.

    Setup the Database Vendor information needed to connect.

    First part of the ‘Batch Move’ Setup. Default ‘Mode’ is ‘Always Insert’.

    Second part of the ‘Batch Move’ Setup. Below the content of our Demo csv file.

    We had to change the ‘Short Date and Time Format’ otherwise the automatic field analyses would not work. It uses the local regional settings of our system and this was different then the one used in the csv file.

    Third part of the ‘Batch Move’ Setup. We switched the ‘Data’ option to SQL Reader/Writer and added ‘Read and Write SQL’.

    :DOC_NO, :FILENAME, :TEXT, :ADDED are the fields found in the header of the CSV file.

    Database Demo Table Setup:

    Result after single scan:

    If you need any help, please let us know.

    Regards,

    Limagito Team

    By Limagito-Team SQL ,
  • 21 Jan

    How-to use Office365 to send files from LimagitoX File Mover

    How-to use Office365 SMTP to send files. Some screenshots to get you started.

    In this example we use a Rule specific SMTP setup. This is, of course, not a must. You can use the settings also for SMTP as Destination.

    Test SMTP successful.

    Setup Host, Username, Password and Port (587).

    LimagitoX-SMTP-Office365-Setup

    Set the security as shown in the screenshot below.

    LimagitoX-SMTP-Office365-Security-Setup

    If you need any help, please let us know.

    Regards,

    Limagito Team

    By Limagito-Team SMTP , ,
1 89 90 91 92 93 94 95 134
SEARCH