|
Introduction |
|
Using SQL File Import |
|
|
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)
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
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.
|
|
·
|
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.
|
|