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

Version history

Version 2.7 (May 17 - June 3 2021)

· Added the option to search folders recursively.  
· Binary files can now be loaded into text fields.  


Version 2.6 (20 March - April 4 2019)

· CSV and XLS file names can now include wildcards (* or ?). SQL File Import will use the entered file name to search for files, sort them in alphabetical order, and use the first file in the list.  
· Added column delimiters for MySQL and SQL Server column names to support non-standard characters.  
· Fixed issue with duplicate Access tables in the tables listing.  
· Fixed issue with Access table names using the '`' delmiter.  
· Fixed issue with not deleting source files when task is ran in the wizard.  


Version 2.5 (1 November 2018)

· Improved the file upload function so that if the destination field is a text-type field, SQL File Import does not convert the file into its hexadecimal values. This is useful when uploading base64 encoded files.  


Version 2.4 (28 April 2018)

· Added a new function - GetFileContentAsText  


Version 2.3 (21 November 2017)

· Fixed a bug with assigining blob fields when updating rows.  


Version 2.2 (30 June 2017 - 7 July 2017)

· Added option to specify csv file encoding.  
· Improved support for tab delimited files.  
· Added new function to replace strings - StringReplace  
· Added option to use tabs as delimiters for CSV files.  
· Improved UTF-8 automatic file detection.  
· Fixed bug with loading of saved projects renaming columns in the mapping editor.  
· Fixed intermittent bug when selecting a transformation.  


Version 2.1 (5 April 2016)

· Added template to compress file when uploading from folders.  
· Show progress bar during upload process.  
· Fixed syntax highlighter for consolidated script.  
· Improved display of progress messages.  


Version 2.0 (23 October 2015)

· Fixed bug where csv and xls import definition files remained locked after the upload process.  
· Fixed bug where source window was always selected when selecting a target column.  


Version 2.0 (20 May 2014)

· Added support for Access databases.  
· Fixed ODBC import option.  
· Miscellanous GUI fixes and improvements.  


Version 1.2 (24 April 2013)

· Added option to delay deletion and moving of files.  
· Added option to delete source CSV/Excel file after upload has completed.  
· Fixed bug with deletion and moving of files in design mode.  
· Fixed bug with compression using passwords.  
· Miscellanous GUI fixes and improvements.  


Version 1.1 (10 April 2013)

· Fixed bug with scheduling tasks.  
· Fixed bug with displaying empty rows for non-existent files in the 'Recently ran tasks' window.  
· Fixed bug with application settings not getting saved to disk.  


Version 1.0 (15 March 2013)

· First release of SQL File Import.