Home
SQL File Import online help Prev Page Prev Page
Introduction
About SQL File Import
Version history
Contact us
Supported database engines
Using SQL File Import
Home page
Task Wizard
Select source data
Files as source data
CSV source data files
Excel source data files
Enter file search patterns
Connect to database
Conecting to databases directly without client libraries installed
Connecting to an Oracle database
Database scripts
Select table to upload into
Map data to table columns
Review script results
Transaction options
Logging options
Finalise
Run task
Scheduling a task
Options
Scripting
Global variables
OnBeforeUpload function
OnAfterUpload function
Support functions
Data functions
Log functions
String functions
Date and time functions
Date-Time format strings
File functions

Options

The Options page is where you set up the email and log settings.

options01  

Email settings are used by SQL File Import when you want to send logs via emails to users. You can test if your email settings are working correctly by clicking on the Test email settings
button. A page will appear where you will need to enter the recipient to send the test email to. SQL File Import will then attempt to send the email and log its progress.

options02  
 
SQL File Import creates a log for each process that it runs. You can specify where these logs should be stored, and how long they should be kept.

options03