We’ve added some screenhots to get you started using the GMail SMTP server.
If you need any help, please let us know.
Best Regards,
Limagito Team
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
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).
Set the security as shown in the screenshot below.
If you need any help, please let us know.
Regards,
Limagito Team
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.