May 15th, 2012· Uses 10 times less memory for large excel files
· Documentation update
· Support RSS, Google Spreasheets and Windows event log as datasource now
May 15th, 2012· 6+ Times performance improvement for working with large excel files.
· Uses less memory for excel files
March 9th, 2012· Support for Dynamic SQL for ETL transformations was introduced
February 20th, 2012· Addressed some issues related to working with MS Sql Server Compact edition
December 30th, 2011· CRC16, CRC24, CRC32, Adler32, CRC64, eDonkey, eMule, MD4, MD5, RIPEMD160, SHA1, SHA224, SHA256, SHA384, SHA512, Whirlpool checksums
· Open Excel/text/access files from Visual Importer ETL
December 20th, 2011· Documentation Update
· GUI Improvements
December 2nd, 2011· Added incremental search for expressions editor
· Added filesize transformation function
· GUI Improvements
October 20th, 2011· Support for variables in inport was introduced
· Better error handling for datasource
October 10th, 2011· 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
September 8th, 2011· Fixed bugs related to working with time fields in MySQL
September 7th, 2011· Added Support for XSLT transformations
· User Interface Update
· Various bug fixes
August 8th, 2011· XML processing improvments
June 21st, 2011· Fixed number of issues related to loading data from XML file
May 26th, 2011· Added Save, Save As and Open items to menu
· Clear log shows dialog box first
· Direct Latest Version downloads from application
· Various Bug Fixes
May 13th, 2011· Added Save, Save As and Open items to menu
· Clear log shows dialog box first
· Direct Latest Version downloads from application
· Various Bug Fixes
April 21st, 2011· Now user can double click on *.vis file to open it
April 13th, 2011· 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
March 29th, 2011· 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
March 1st, 2011· Addressed number of problems related to working with uniqueidentifier fields in SQL Server
· Fixed bug loading zero length files
· Various bugs fixes
February 7th, 2011· Support for MS SQL Server Compact Edition was introduced
· Calculations Enhancements
· Various bugs fixes
January 20th, 2011· Fixed some Issues with SQLite
December 16th, 2010· Corrected problem with duplicated source fields
· Various bugs fixes
November 30th, 2010· Various bugs fixes
November 20th, 2010· Problem with null dates was resolved
November 18th, 2010· 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
November 18th, 2010· MD5 Function was introduced
· Various bug fixes
November 12th, 2010· Works correctly with mixed case objects in PostgreSQL
October 26th, 2010· Data grid grouping access violations fixes
· Send email to support fixed
October 24th, 2010· 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
October 11th, 2010· Loads data into PostgreSQL 9.0
· Improved Unicode support for Oracle connections
· Title menu in data grids was added
· Various Data transformation improvements
September 24th, 2010· Supports multiple end of line delimiters now
September 15th, 2010· Memory leaks fixes
September 8th, 2010· 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
September 1st, 2010· Various bug fixes
August 24th, 2010· 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
July 25th, 2010· Various interface improvements
· Various access violations were fixed
· Problem with duplicated fields was resolve
June 28th, 2010· Some problems were addressed related to loading data into varchar(max),nvarchar(max),varbinary(max)
May 22nd, 2010· Fixed Loading data into DBF files
April 13th, 2010· Support for SQL Server 2005/2008 was improved
· Various bug fixes
February 2nd, 2010· Various bug fixes
January 14th, 2010· Support for Ole Db was Introduced New tab was added to data source properties dialog called "Data reading restrictions"
December 23rd, 2009· Minor bug fixes
October 25th, 2009· 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.
August 8th, 2009· Minor Bug Fixes Documentation Update
August 4th, 2009· Minor Bug Fixes Documentation Update
July 14th, 2009· In this version we added support for PostgreSQL and Interbase/Firebird
July 6th, 2009· In this version we added support for MySql databases. Rest of the products to follow. We also working on adding support for PostgreSQL and Interbase/Firebird
June 5th, 2009· Some spelling errors were corrected
· Minor bug fixes
June 1st, 2009· 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
May 24th, 2009· Automatic Version check was introduced
· Various bug fixes
April 1st, 2009· ETL Calculations now provide Full Support for Unicode. Log file format is utf8 Rejected file is in utf8 Table browser help you to chose the table
February 14th, 2009· Up to 7 times faster ETL Transformation Thousands of records per second Full Support for Unicode Better integration for Oracle databases
November 25th, 2008· Various bugs related to sql generation were fixed
October 17th, 2008· Abort Import on error option was added Support for transactions was added for ODBC connection
September 13th, 2008· Support for Excel 2007 and Access 2007
August 3rd, 2008· Incremental table filter was introduced for source connection
May 3rd, 2008· Some Minor bug fixes
· Now it is possible to specify newline character for text files.
February 24th, 2008· Now works with MS SQL Server
September 9th, 2007· Now works with MS Access and DBF Files
April 30th, 2007· In this version Auto Map function was completely rewritten. It possible now to mach fields by number or name, ignore special characters like underscores and spaces and use fields prefixes and suffixes
August 16th, 2006· New Transformation type was added -
· Add new records
July 30th, 2006· New Transformation type was added - Add new records
Find us on Google+
