Visual Importer ETL Standard- History Of Changes


5.4.4.1

+ Improved: Slight performance improvement

5.4.4.0

+ Improved: Third party components update

5.4.3.33

- Fixed: Issues with loading data into Varchar(MAX) fields (SQL Server)

5.4.3.32

+ Improved: Third party components update

5.4.3.30

- Fixed: Addressed issues with loading data into XML,Image and Identity fields (SQL Server)

5.4.3.29

+ Improved: Up to two times faster loading data into sql server
- Added: Support for TLS 1.2 SQL Server connections

5.4.3.28

- Fixed: Issues with exporting data into csv and tab files from grids

5.4.3.27

+ Added: GetWindowsTemporaryDirectory,GetTemporaryFile,GetTemporaryFileInDirectory,GetTemporaryDirectory transformation language functions
+ Added: Get File Content Dynamic transformation function
+ Improved: Third party components update

5.4.3.26

+ Improved: Google Spreadsheet import
- Fixed: Salesforce Bulk API load issues

5.4.3.22

- Fixed: Round Function issues
- Fixed: Issues with exporting very large grids into excel files

5.4.3.21

- Fixed: Salesforce Bulk API load issues

5.4.3.20

- Fixed : Issues with Google spreadsheet import
- Fixed : Issues with SFTP keys storage
+ Added: Ansi Driver checkbox to odbc connections

5.4.3.19

+ Added: Support For MongoDB

5.4.3.18

+ Improved: Third party components update (Data Grid)
+ Improved: Empty Data Grids shows message

5.4.3.17

+ Improved: Third party components update (Excel)
+ Improved: Changed logic fro processing excel files: if software is unable to open file import is aborted

5.4.3.15

- Fixed : Issues with QVX Files reading

5.4.3.14

- Fixed : Issues with loading version info

5.4.3.13

- Fixed : Fixed QVD reading issues

5.4.3.12

+ Improved: Setup procedure

5.4.3.11

- Fixed : Issues with loading version info

5.4.3.10

+ Improved: Maximum ODBC Connection String is 4K now

5.4.3.9

+ Improved: Updated Salesforce API to v38

5.4.3.7

+ Improved: Query Builder components update
+ Improved: SSL components update

5.4.3.6

- Fixed : Issues with updating data via table browser

5.4.3.5

+ Added : Added displayName,distinguisedName,initials,mailNickname,publicDelegates,sAMAccountType,scriptPath,showInAddressBook,sn,pager,extensionAttribute1-extensionAttribute15 fields to ActiveDirectory extract
+ Improved : Third party componets update
+ Improved : Table generation

5.4.3.4

+ Added : Table generation option to import grid PopUp menu
- Fixed : Issues with reading data from SalesForce

5.4.3.3

+ Added : Option to disable record count
+ Improved : Once deleted packages are disabled in the scheduler
- Fixed : Fixed issues with reading XML files

5.4.3.2

+ Improved: Up to 10 percent performance increase while loading data into date/time fields

5.4.3.1

+ Improved: Support for JSON as data source

5.4.3.0

+ Added: Support for JSON as data source

5.4.2.9

- Fixed : BDE Datasource issues
+ Improved : MySQL Error handling
+ Improved : Date Format list

5.4.2.8

- Fixed : Problems with reading delimited text files when delimiter is more than one character log

5.4.2.7

- Fixed : Problems with reading data from Salesforce

5.4.2.6

- Fixed : Problems with refreshing list of Oracle Tables

5.4.2.5

- Fixed : Problems with AM/PM Date conversion

5.4.2.4

+ Improved : JDBC Processing
- Fixed : Problems with data preview dialogue

5.4.2.3

+ Improved : JDBC Errors Handling

5.4.2.2

- Fixed : Problems with aborting import were resolved

5.4.2.1

- Fixed : Problems with reading data from unicode files

5.4.2.0

+ Third party components update
+ Support for the new functions introduced in the Excel 2016 January Update
+ Improved compatibility with thid party xlsx files
+ Improved compatibility with invalid xls and xlsx files
+ Improved : Excel 2010 equations are now preserved in xlsx
+ New : Support for opening xls versions from 2 to 4
- Fixed order of records specific for Excel 2010 to workaround a bug in Excel 2010.
- Some very complex files could raise an error when opened in Excel 2010, even when they were correct by the xlsx spec.
- Fixed : Xlsx files with 0 bytes xml files inside could throw an "Invalid XML file" error.
- Fixed : Data validations entered manually in xls files could fail to work when opened in Excel

5.4.1.5

- Addressed Salesforce data update issues

5.4.1.4

- Addressed Salesforce data update issues

5.4.1.3

+ Improved support for RSS feeds

5.4.1.1

+ Support for latest tableau api was introduced

5.4.1.0

+ New datasource file system was introduced

5.4.0.7

- Date fields processing bugs fixes

5.4.0.6

- SalesForce data processing fixes

5.4.0.5

- Addressed DTD is prohibited issues

5.4.0.4

+ Improved support for very large QVD files

5.4.0.3

- Addressed Date conversion problems

5.4.0.2

+ SSL Libraries update
+ Third party components update
+ SalesForce connection uses TLS 1.1 now

5.4.0.1

+ Uses tableau API 9.2 now

5.4.0.0

+ 64 Bit version release
- Added support for MRU Lists

5.3.8.8

- Addressed issues with getting stored procedures parameters

5.3.8.7

+ Added ability to extract 'List of groups the user(s) belongs to' from Active Directory
+ Added ability to extract 'List of group(s) members' from Active Directory

5.3.8.6

+ Faster QVD files processing
- Addressed issues with reading very large QVD files

5.3.8.3

+ Added RUNHIDDEN command line option

5.3.8.2

+ Third party components update
+ Reduced memory usage for QVD files processing

5.3.8.1

- Addressed issues with loading data into time fields

5.3.8.0

+ Added support for Active Directory as data source
- Addressed issues with filtering date
- Addressed issues with exporting data into excel files

5.3.7.8

- Addressed issues with loading empty date fields into MySQL

5.3.7.4

+ Smaller Executable
+ Updated regular exression Engine

5.3.7.3

+ Added UTC To Local Date and Local Date to UTC script functions

5.3.7.2

- Addressed issues with Slemma Import

5.3.7.1

+ Added support for Clarion

5.3.7.0

+ Added support for Slemma
+ All documentation is in wiki format now

5.3.6.27

+ Excel Import and export from data grids is much faster now
- Addressed issues with exporting data as excel from data grids
- Addressed issues with deleting records from data grids

5.3.6.25

- Addressed issues with loading null values into salesforce

5.3.6.24

- Addressed issues with loading data from SQL Server CE

5.3.6.23

- Addressed issues with loading data from delimited files

5.3.6.22

+ Documentation update
+ Added GetExcelCellValue calculation function

5.3.6.21

- Addressed issues with retrieving information about Primary keys

5.3.6.20

+ Documentation update
- Addressed issues with processing of delimited files
- Addressed issues with date formats

5.3.6.18

+ Up to 2 times faster data extraction from Sql Server
+ Up to 2 times faster data extraction from ODBC sources
+ Up to 2 times faster loading data into SQL Server
+ Up to 2 times faster loading data into ODBC
- Various bugs fixes and improvements

5.3.6.17

+ Up to 2 times faster data extraction from Sql Server
+ Up to 2 times faster data extraction from ODBC sources
+ Up to 40 percent faster loading data into SQL Server
+ Up to 40 percent faster loading data into ODBC
+ Up to 10 percent faster loading data into PostgreSQL
- Various bugs fixes and improvements

5.3.6.16

+ Up to 3 times faster reading data from QVD files
- Various bugs fixes and improvements

5.3.6.15

- Various bugs fixes and improvements

5.3.6.14

- Addressed issues with processing end of line characters inside delimited files

5.3.6.13

- Addressed issues with salesforce data processing
- Various bug fixes and improvements
- Addressed issues with running ODBC Manager from application

5.3.6.12

+ SSL libraries update
- Various bug fixes and improvements

5.3.6.11

+ Up to 10 percent faster data loading

5.3.6.9

+ Support for MS SQL server 2014 was extended

5.3.6.8

- Addressed issues with theme management
- Loads recent history of changes by default now
(Full history is to big and slows down the application)

5.3.6.7

+ Added Vertical Grid
+ Third party components update

5.3.6.6

+ Thrid party components update

5.3.6.5

+ Query builder update
+ Added support for subqueries
+ Added incremental search to Query builder
+ Third party components update

5.3.6.4

+ Setup and executable are digitally signed now
- Minor bugs fixes

5.3.6.3

- Addressed issues with XML encoding

5.3.6.2

+ Incremental search was added to field's list
+ Export to RTF was introduced
+ Excel export formats improvements
+ Various Interface improvements
+ Documentation update
- Minor bugs fixes
- Spelling corrections

5.3.6.1

+ Added installation options

5.3.6.0

+ Introduced support for Salesforce as datatarget

5.3.5.37

- MySQL bugs fixes

5.3.5.36

+ Better Data Reader Memory Management

5.3.5.35

- Addressed issues with BIGINT fields

5.3.5.33

+ Import Script checking improvements

5.3.5.32

- Date Format bugs fixes

5.3.5.31

+ Import Script checking improvements

5.3.5.30

+ Added Delete Leading Characters script function
+ Added Delete Trailing Characters script function
+ Added support for special characters
+ Interface improvements

5.3.5.29

+ Introduced support for salesforce QueryAll interface
- Addressed problems with batch import via ODBC

5.3.5.28

+ Excel processing engine update

5.3.5.27

+ Support for latest version of Google spreadsheets was intruduced

5.3.5.26

+ Up to 50 percent faster working with QVD files
- Minor XML processing fixes

5.3.5.23

- Addressed issues of loading data from the files with old creation date
- Addressed DD-MMM-YYYY date format issues
+ Smaller Setup

5.3.5.22

- XML and ODBC fixes

5.3.5.20

+ Up to 5 percent performance increase

5.3.5.19

- MySQL date processing bugs fixes

5.3.5.18

- Minor bugs fixes

5.3.5.15

- Addressed issues of empty date fields

5.3.5.14

- Addressed issues of loading data from Excel files

5.3.5.13

- Addressed issues of loading data from flat files
- Addressed issues with loading data into MySQL

5.3.5.12

+ Progress dialogue shows now execution log as well
+ Progress dialogue has option to clear log first

5.3.5.11

- Adressed some issues of loading data from text files

5.3.5.9

+ Better handling of large Salesforce tables
+ Support for multiple Salesforce environments was introduced
- Addressed issues with updating data

5.3.5.8

- QVD reading bug fixes

5.3.5.7

+ Better handling of empty Salesforce tables
+ Support for GreenPlum was introduced

5.3.5.6

+ Added select count(*) from table menu item to sql browser
- Addressed issues with date fields processing
- Addressed issues of loading data from delimited files

5.3.5.3

+ Better source connection errors handling

5.3.5.2

- Salesforce bug's fixes

5.3.5.1

- Fixed data preview screen
- Addressed issues with loading data from Salesforce
- Addressed issues with loading data into NTEXT fields

5.3.5.0

+ Support for MariaDB was introduced
- Addressed problems with loading date fields
- Addressed problem with handling NULLs
- Fixed AV when loading data into MySQL

5.3.4.11

- Addressed problems with formating dates
- Addressed problems with SalesForce connection
+ Documentation update

5.3.4.10

- Addressed problems with autoformat option

5.3.4.8

+ Another 10 percent performance increase
- Addressed problems with scientific numbers in Excel
- Fixed bug with too many rejected records
- Smaller executable

5.3.4.6

+ Up to 10 percent performance increase
+ Up to 3 times faster comparing to version 5.3.3.0

5.3.4.3

+ Up to 100 percent performance increase

5.3.4.2

+ Further 20 percent performance increase for loading data from text files

5.3.4.1

Another performance boost

+ Up to 50 percent increase for loading data via OleDB
+ Up to 40 percent increase when using stored procedures for loading the data

5.3.4.0

Massive performance boost

+ ODBC to SQL Server up to 48.51%
+ Text to ORACLE via Conventional Path Loading up to 27.10%
+ Text to ORACLE via Direct Path Loading up to 34.99%
+ Text to PostgreSQL up to 32.60%
+ Text to SQL Server via BCP up to 33.89%
- Various bug fixes and interface improvements

5.3.3.11

+ Various bug fixes and interface improvements

5.3.3.10

Massive performance boost:

+ text to PostgreSQL up to 25 percent
+ text to Oracle up to 25 percent
+ text to Oledb up to 25 percent
+ text to MYSQL up to 10 percent
+ text to MS SQL server up to 25 percent

5.3.3.8

- Various bug fixes and interface improvements

5.3.3.7

+ Data reader timeout was introduced for ODBC,Access,MS Sql Server, OleDB, PostgreSQl, MySQl and MS Sql Server CE connections

5.3.3.6

+ Smaller executable
+ Memory usage was reduced for Excel files
- Various bug fixes and interface improvements

5.3.3.5

+ Addressed problems with updating Oracle blob fields
+ Added Register option to help menu
+ Various bug fixes and interface improvements

5.3.3.0

+ Various bug fixes and interface improvements

5.3.2.9

+ Added Keep Characters Function
+ Added Epoch to Date Function
+ Added Date to Epoch Function
+ Interface improvements
+ Documentation update
- Various bug fixes

5.3.2.6

+ Improved support for MS SQL Server 2012
+ Improved support for BDE
+ Logging improvements for connection type, connection name and connection details
+ Executable is smaller now
+ Support for Excel 2013 was itroduced
- Various bug fixes

5.3.2.2

+ Support for BDE was introduced
+ Documentation update
- Various bug fixes

5.3.1.2

- Various bug fixes

5.3.1.0

+ Introduced Auto complete functionality
- Addressed some issues related to loading data from QVD files
- Various bug fixes

5.3.0.0

+ Support for stored procedures as data target was introduced
+ Performance improvements for MS SQL Server Connection
+ Various Bug Fixes
+ Documentation Update

5.2.0.3

+ Added option to ignore XML tags between Table tag and Record tag
+ Documentaiton Update

5.2.0.2

- Various bug fixes

5.2.0.1

+ Support for QVD files as datasource was intruduced

5.1.1.0

+ Massive performance improvement up to 10+ times for some data sources/targets
- Various bug fixes

5.1.0.0

+ Support for BrightPearl was introduced
+ Support for Sales Force was introduced
+ Support for JDBC was introduced
+ Documentation update
- Various bug fixes

5.0.0.2

+ Uses 10 times less memory for large excel files
+ Documentation update
+ Support RSS, Google Spreasheets and Windows event log as datasource now

5.0.0.0

+ 6+ Times performance improvement for working with large excel files.
+ Uses less memory for excel files

4.9.10.1

+ Support for Dynamic SQL for ETL transformations was introduced

4.9.9.8

- Addressed some issues related to working with MS Sql Server Compact edition

4.9.9.6

+ CRC16,CRC24,CRC32,Adler32,CRC64,eDonkey,eMule,MD4,MD5,RIPEMD160,SHA1,SHA224,SHA256,SHA384,SHA512,Whirlpool checksums
+ Documentation Update
+ Open Excel/text/access files from Visual Importer ETL
+ GUI Improvements

4.9.9.3

+ Added incremental search for expressions editor
+ Added filesize transformation function
+ GUI Improvements

4.9.9.2

+ Support for variables in inport was introduced
+ Better error handling for datasource

4.9.9.0

+ Support for MySQL 5.5 was introduced
+ Interface Improvements
+ Command line parameter transformation function
+ Standard print preview
- Boolean fix for MySql
- Better error handling for ADO and MS Sql scripts

4.9.8.15

Fixed bugs related to working with time fields in MySQL

4.9.8.13

Added Support for XSLT transformations
User Interface Update
Various bug fixes

4.9.8.12

User Interface Update

4.9.8.11

XML processing improvments

4.9.8.10

Fixed number of issues related to loading data from XML file
Added "Search in subdirectories" option to data reader

4.9.8.9

Added Save, Save As and Open items to menu
Clear log shows dialog box first
Direct Latest Version downloads from application
Various Bug Fixes

4.9.8.6

Get latest version menu item was added
Support for utf-16 was introduced for XML data reader
Various bug fixes

4.9.8.5

Now user can double click on *.vis file to open it

4.9.8.4

Data transformation language extension

Added:

DeleteCharacters(S,CharactersToDelete) Deletes specific characters from the string
Delete(S,Start,End) Deletes part of string S
EnsureNoPrefix(S,Prefix) Removes prefix from the string when present
EnsureNoSuffix(S,Suffix) Removes Suffix to the string when present
EnsurePrefix(S,Prefix) Adds prefix to the string when not present
EnsureSuffix(S,Suffix) Adds prefix to the string when not present
EscapeString(S) C style sring escape
UnEscapeString(S) C style sring unescape
LeftDelete(S,Length)Deletes Left part of the string

4.9.8.3

Fixed number of problems related to working with uniqueidentifierfileds in sql server
Added post changes button
Added Optimize Column Width button for all grids
Some corrections for German Locale were introduced

4.9.8.2

Addressed number of problems related to working with uniqueidentifier fields in SQL Server
Fixed bug loading zero length files
Various bugs fixes

4.9.8.1

Support for MS SQL Server Compact Edition was introduced
Calculations Enhancements
Various bugs fixes

4.9.7.11

Fixed some Issues with SQLite

4.9.7.9

Corrected problem with duplicated source fields
Various bugs fixes

4.9.7.8

Various bugs fixes

4.9.7.6

Problem with null dates was resolved

4.9.7.5

Majour update

Calculations and scripting language changes

Syntax is slightly different now

1 source fields are aways strings
a) no need to use "[F1]"
b) [F1]+[F2] will concatenate two fields
if you want to add them use conversion functions
StrtoFloat([F1])+StrtoFloat([F2])

2 use single quotes instead of double quotes
eg GetSystemVariable('SYSTEM_DATE') GetSystemVariable("SYSTEM_DATE")

3 in order to make conversion easier we have added new menu item
"Correct calculations"

4 Lots of new fuctions, procedures and language changes (see documentation)

Date time fields support

Default Format was changed to YYYY-MM-DD HH:NN:SS.ZZZ for ODBC and SQL server connections
They also support fractions of seconds now


4.9.7.3

MD5 Function was introduced
Various bug fixes

4.9.7.2

Works correctly with mixed case objects in PostgreSQL

4.9.7.1

Data grid grouping access violations fixes
Send email to support fixed

4.9.7.0

Loads Data from XML files
Exports data into XML
Works correctly with multiple PosgreSQL schemes
Support for PosgreSQL 9 was introduced
Support for German Locale was introduced
Select all and copy from data grids
Documentation Update

4.9.6.13

Loads data into PostgreSQL 9.0
Improved Unicode support for Oracle connections
Title menu in data grids was added
Various Data transformation improvements

4.9.6.12

Supports multiple end of line delimiters now

4.9.6.11

Memory leaks fixes

4.9.6.10

Works directly with SQLite now
New look and feel
Various Interbase/Firebird related bug fixes
Fixed bug with import of MS Access tables with spaces in names

4.9.6.9

Various bug fixes

4.9.6.8

Excel:
Works directly with Excel 3.0-2007
No ODBC, OleDB or MS Jet Required
Works correctly with mixed data types
Works correctly with cells with more 255 characters
No need for IMEX=1, HDR=Yes or Registry hacks (TypeGuessRows)
Loads data correctly all the time + no need to edit Excel file
Data grids modifications:
Grouping panel was added
Advanced filter dialog was introduced
Record number
New look and feel
Also:
Table browser loads data much faster
Various Access violation and bug fixes

4.9.6.7

Various interface improvements
Various access violations were fixed
Problem with duplicated fields was resolved

4.9.6.6

Some problems were addressed related to loading data into varchar(max),nvarchar(max),varbinary(max)

4.9.6.3

Various bug fixes

4.9.6.1

Support for SQL Server 2005/2008 was improved

4.9.6.0

Improved support for blobs.
Various bug fixes

4.9.5.1

Fields Notes were added

4.9.5.0

Support for Ole Db was Introduced
New tab was added to data source properties dialog called "Data reading restrictions"

4.9.4.8

Added GetSystemVariable("OUTPUT_RECORDNUMBER")
Aded new calculation function DateDiffS
DecDateS(Date1,Format1, Date2,Format2,Type):String.
Use DateDiffS to calculate Type difference between two dates.
Documentation update

4.9.4.4

Support for MySql, PostgreSQL and interbase was added

4.9.2.4

Some spelling errors were corrected
Minor bug fixes

4.9.2.3

ODBC Connection String Builder was introduced
Improved support for NonStop ODBC/MX 2.0 ver 3.51.20.126 ODBC Driver
Various Cosmetic Changes and Bug Fixes

4.9.2.2

Changes are:
Automatic Version check was introduced
Various bug fixes

We have 210 guests and no members online