- + Improved: "Data Reader" performace by approximately 5 percent
Visual Importer ETL Standard History
Recent changes, fixes, and improvements for Visual Importer ETL Standard.
Showing 282 releases
- + Updated: Help, Support and Order links
- + Improved: "Data Writer Dialogue" interface behaviour (SQL Server only)
- - Fixed: Sql Server 2025 connection issues
- + Added: Support for Clarion TPS Files
- - Fixed: Disabled Google Spreadsheets Import Script Connection Type
- - Fixed: Disabled Rest Import Script Connection Type
- + Improved: Support for international characters
- + Added: Parquet Source
- + Updated: Interbase client
- + Added: Firebird client to setup
- + Added: Interbase/Firebird client to setup
- + Improved: Minor Interface Tweaks
- + Improved: JSON Reader Error Handling
- - Fixed: Issue with reading complex json
- + Improved: When transformation fails progress dialogue is not closed automatically
- - Fixed: AV while obtaining file owner
- - Fixed: Excel 2 Reader Bug
- - Fixed: Excel Reader Bug
- - Fixed: SQL Server Reader Table name with space bug
- - Fixed: ODBC taget bug
- - Fixed: SQL Server taget bug
- + Improved: Minor Data Import Performance boost
- + Improved: Table Browser Search performace while working with large list of tables
- - Fixed: HTML Table Reader AV
- - Fixed: Oracle reader bugs
- - Fixed: Oracle writer bugs
- + Added: Additional Parameters to MongoDB connection
- + Updated: MongoDB client
- - Fixed: BIGINT Field Issue
- + Added: Support for Windows Arm (Experimental)
- + Improved: Removed unused button in Data Browser screen
- - Fixed: Minor bugs
- + Improved: Third party components update
- + Added: Incremental Search to Transformation log
- + Added: Sorting to Transformation log
- + Added: Copy ability to Transformation log
- + Added: Application name to Registration Dialogue and Trial Expired message
- - Fixed: Autoformat Excel Bug
- - Fixed : Import Script bugs
- + Added: Support for extracting data from Excel tables
- + Improved: Working with excel files ranges
- - Fixed : Fixed autoformat grid bugs
- + Improved: License server error handling
- + Improved: String delimiter handling
- - Fixed: Issues with viewing/editing very large numbers (MySQL, Postgress, Interbase/Firebird and SQLite)
- + Improved: Print preview dialogue is closed on ESC
- + Updated: SSH components
- - Fixed: Issues with reading Excel files
- + Updated: Excel components
- - Fixed: SQLite data reader bug
- + Updated: Third party components
- + Updated: Excel components
- + Added: Refresh Tables list menu item to Table Browser dialogue
- - Fixed: Minour interface issues
- + Added: Support for python versions 3.10, 3.11 and 3.12
- + Updated: Excel engine
- + Improved: Calculation engine update
- + Improved: Components update: SSL, SSH, SFTP, MySQL, Postgre, SQLite, Interbase/Firebird
- + Added: Incremental search to Expression editor dialogue
- - Fixed: Issues with inserting default values within the data grid. (MySQL, Postgress, Interbase/Firebird and SQLite)
- + Improved: Updated documentation link
- + Added: Support for SSH Connections to MySQL,Postgres and MongoDDB
- - Fixed: Viewing Views Issues while browsing the data
- + Improved: Loading data into smalldatetime fields
- + Improved: Look and feel on high definition monitors
- + Added: New themes Office 2016 White, Office 2016 Gray and Office 2016 Black
- + Improved: default theme is set to Office 2016 White
- + Added: GUIDNB Transformation language function, it returns clean GUID value without brackets and underscores
- + Improved: XML Reading performance
- + Improved: Excel components update
- - Fixed: Issues with long month names
- + Improved: Third party components update
- - Fixed: Installation Issues
- - Fixed: Issues with closing ODBC connection when refreshing target fields list
- - Fixed: Windows log message format
- + Improved: Working with HTML tables
- + Improved: Changed table search from case sensitive to not case sensitive
- + Improved: user can select HTML table file from import script designer
- - Fixed: Licensing issues when running the software on AWS servers.
- - Fixed: Access violations when reading excel files
- - Fixed: Problems with reading version information
- - Fixed: Various tableau related bugs
- + Improved: Updated hyper API to the latest version
- - Fixed: Licence management issues
- + Added: HTML Table Source
- + Updated: Digital signature
- - Fixed: Loading data from FoxPro
- + Added: GetSystemDate function returns the fractions of a second now
- - Fixed: Licence management issues
- + Added: To, ReplyTo, Cc and Bcc fields to POP3 and IMAP4 data source
- - Fixed: Issues with special characters inside SQL server database names
- + Improved: Setup look and feel
- + Added: Owner field to file system reader
- + Added: FileOwner scripting language function
- + Added: Support for reading Tableau Hyper files
- + Improved: Support for DATETIME2 Fields
- + Improved: Support for DATETIME2 Fields
- - Fixed: Issues with reading JSON objects
- + Improved: Software registration process
- + Improved: JSON Data Handling
- + Added: Support for SQL Server 2017
- - Fixed: Issues with loading data into varchar(max) field
- - Improved: SQL Server error handling
- + Added: Support for PostgreSql 12
- + Added: "Complex JSON" check box to JSON datasource
- + Added: Ability to pull a license from the license server
- + Added: Checks for source and target structure changes
- - Fixed: IMAP4 reader shows UID correctly now
- - Fixed: Losing mapping bug when the search box is used
- + Improved: Third-party components update:
- Excel processing libraries
- + Improved: Various bug fixes and improvements
- - Fixed: Excel data reading problems
- + Improved: Salesforce connection uses TLS 1.2 now
- + Added: Syslog data source
- - Fixed: Reading JSON Data AV
- + Improved: Software Installation Process
- + Improved: Third-Party Components Update
- + Fixed: Minor Python Integration Issues
- Software registration changes:
- Starting from this release users would need to enter the license key and control number to register the software.
- + Improved: Extracts data from OLE Db up to 4 times faster
- + Improved: Extracts data from SQLite up to 2 times faster
- + Improved: The application starts much faster
- - Fixed: Issues with reading google spreadsheet data
- + Improved: Import data error handling
- + Improved: Extracts data from OleDB up to 5 times faster
- + Added: Support for calculations inside the source file
- + Added: New data source - Twitter
- + Improved: Loads data into SQL server up to 25 per cent faster
- + Improved: Active Directory Connection look and feel
- + Improved: Slight performance improvement
- + Improved: Third-party components update
- - Fixed: Issues with loading data into Varchar(MAX) fields (SQL Server)
- + Improved: Third-party components update
- - Fixed: Addressed issues with loading data into XML, Image and Identity fields (SQL Server)
- + Improved: Up to two times faster loading data into SQL server
- - Added: Support for TLS 1.2 SQL Server connections
- - Fixed: Issues with exporting data into CSV and tab files from grids
- + Added: GetWindowsTemporaryDirectory,GetTemporaryFile,GetTemporaryFileInDirectory,GetTemporaryDirectory transformation language functions
- + Added: Get File Content Dynamic transformation function
- + Improved: Third party components update
- + Improved: Google Spreadsheet import
- - Fixed: Salesforce Bulk API load issues
- - Fixed: Round Function issues
- - Fixed: Issues with exporting very large grids into excel files
- - Fixed: Salesforce Bulk API load issues
- - Fixed: Issues with Google spreadsheet import
- - Fixed: Issues with SFTP keys storage
- + Added: Ansi Driver checkbox to odbc connections
- + Added: Support For MongoDB
- + Improved: Third party components update (Data Grid)
- + Improved: Empty Data Grids shows
- message
- + Improved: Third-party components update (Excel)
- + Improved: Changed logic fro processing excel files: if the software is unable to open file import is aborted
- - Fixed: Issues with QVX Files reading
- - Fixed: Issues with loading version info
- - Fixed: Fixed QVD reading issues
- + Improved: Setup procedure
- - Fixed: Issues with loading version info
- + Improved: Maximum ODBC Connection String is 4K now
- + Improved: Updated Salesforce API to v38
- + Improved: Query Builder components update
- + Improved: SSL components update
- - Fixed: Issues with reading windows event log
- - Fixed: Issues with updating data via table browser
- + 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
- + Added: Table generation option to import grid PopUp menu
- - Fixed: Issues with reading data from SalesForce
- + Added: Option to disable record count
- + Improved: Once deleted packages are disabled in the scheduler
- - Fixed: Fixed issues with reading XML files
- + Improved: Up to 10 percent performance increase while loading data into date/time fields
- + Improved: Support for JSON as a data source
- + Added: Support for JSON as a data source
- - Fixed: BDE Datasource issues
- + Improved: MySQL Error handling
- + Improved: Date Format list
- - Fixed: Problems with reading delimited text files when the delimiter is more than one character log
- - Fixed: Problems with reading data from Salesforce
- - Fixed: Problems with a refreshing list of Oracle Tables
- - Fixed: Problems with AM/PM Date conversion
- + Improved: JDBC Processing
- - Fixed: Problems with data preview dialogue
- + Improved: JDBC Errors Handling
- - Fixed: Problems with aborting import were resolved
- - Fixed: Problems with reading data from Unicode files
- + Third-party components update
- + Support for the new functions introduced in the Excel 2016 January Update
- + Improved compatibility with third-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
- - Addressed Salesforce data update issues
- - Addressed Salesforce data update issues
- + Improved support for RSS feeds
- + Support for the latest tableau api was introduced
- + New data source file system was introduced
- - Date fields processing bugs fixes
- - SalesForce data processing fixes
- - Addressed DTD is prohibited issues
- + Improved support for very large QVD files
- - Addressed Date conversion problems
- + SSL Libraries update
- + Third party components update
- + SalesForce connection uses TLS 1.1 now
- + Uses tableau API 9.2 now
- + 64 Bit version release
- - Added support for MRU Lists
- - Addressed issues with getting stored procedures parameters
- + 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
- + Faster QVD files processing
- - Addressed issues with reading very large QVD files
- + Added RUNHIDDEN command line option
- + Third-party components update
- + Reduced memory usage for QVD files processing
- - Addressed issues with loading data into time fields
- + Added support for Active Directory as a data source
- - Addressed issues with filtering date
- - Addressed issues with exporting data into excel files
- - Addressed issues with loading empty date fields into MySQL
- + Smaller Executable
- + Updated regular expression Engine
- + Added UTC To Local Date and Local Date to UTC script functions
- - Addressed issues with Slemma Import
- + Added support for Clarion
- + Added support for Slemma
- + All documentation is in wiki format now
- + Excel Import and export form data grids is much faster now
- - Addressed issues with exporting data as excel from data grids
- - Addressed issues with deleting records from data grids
- - Addressed issues with loading null values into salesforce
- - Addressed issues with loading data from SQL Server CE
- - Addressed issues with loading data from delimited files
- + Documentation update
- + Added GetExcelCellValue calculation function
- - Addressed issues with retrieving information about Primary keys
- + Documentation update
- - Addressed issues with the processing of delimited files
- - Addressed issues with date formats
- + 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
- + 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
- + Up to 3 times faster reading data from QVD files
- - Various bugs fixes and improvements
- - Various bugs fixes and improvements
- - Addressed issues with processing end of line characters inside delimited files
- - Addressed issues with salesforce data processing
- - Various bug fixes and improvements
- - Addressed issues with running ODBC Manager from the application
- + SSL libraries update
- - Various bug fixes and improvements
- + Up to 10 percent faster data loading
- + Support for MS SQL server 2014 was extended
- - Addressed issues with the theme management
- - Loads recent history of changes by default now
- (Full history is too big and slows down the application)
- + Added Vertical Grid
- + Third-party components update
- + Third party components update
- + Query builder update
- + Added support for subqueries
- + Added incremental search to the Query builder
- + Third-party components update
- + Setup and executable are digitally signed now
- - Minor bugs fixes
- - Addressed issues with XML encoding
- + 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
- + Added installation options
- + Introduced support for Salesforce as data-target
- - MySQL bugs fixes
- + Better Data Reader Memory Management
- - Addressed issues with BIGINT fields
- + Import Script checking improvements
- - Date Format bugs fixes
- + Import Script checking improvements
- + Added Delete Leading Characters script function
- + Added Delete Trailing Characters script function
- + Added support for special characters
- + Interface improvements
- + Introduced support for salesforce QueryAll interface
- - Addressed problems with batch import via ODBC
- + Excel processing engine update
- + Support for the latest version of Google spreadsheets was introduced
- + Up to 50 percent faster working with QVD files
- - Minor XML processing fixes
- - Addressed issues of loading data from the files with old creation date
- - Addressed DD-MMM-YYYY date format issues
- + Smaller Setup
- - XML and ODBC fixes
- + Up to 5 percent performance increase
- - MySQL date processing bugs fixes
- - Minor bugs fixes
- - Addressed issues of empty date fields
- - Addressed issues of loading data from Excel files
- - Addressed issues of loading data from flat files
- - Addressed issues with loading data into MySQL
- + Progress dialogue shows now execution log as well
- + Progress dialogue has an option to clear log first
- - Addressed some issues of loading data from text files
- + Better handling of large Salesforce tables
- + Support for multiple Salesforce environments was introduced
- - Addressed issues with updating data
- - QVD reading bug fixes
- + Better handling of empty Salesforce tables
- + Support for Greenplum was introduced
- + Added select count(*) from table menu item to SQL browser
- - Addressed issues with date fields processing
- - Addressed issues of loading data from delimited files
- + Better source connection errors handling
- - Salesforce bug's fixes
- - Fixed data preview screen
- - Addressed issues with loading data from Salesforce
- - Addressed issues with loading data into NTEXT fields
- + Support for MariaDB was introduced
- - Addressed problems with loading date fields
- - Addressed problem with handling NULLs
- - Fixed AV when loading data into MySQL
- - Addressed problems with formatting dates
- - Addressed problems with SalesForce connection
- + Documentation update
- - Addressed problems with autoformat option
- + Another 10 percent performance increase
- - Addressed problems with scientific numbers in Excel
- - Fixed bug with too many rejected records
- - Smaller executable
- + Up to 10 percent performance increase
- + Up to 3 times faster compared to version 5.3.3.0
- + Up to 100 percent performance increase
- + Further 20 percent performance increase for loading data from text files
- 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
- 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
- + Various bug fixes and interface improvements
- 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
- - Various bug fixes and interface improvements
- + Data reader timeout was introduced for ODBC, Access,MS SQL Server, OleDB, PostgreSQL, MySQL and MS SQL Server CE connections
- + Smaller executable
- + Memory usage was reduced for Excel files
- - Various bug fixes and interface improvements
- + Addressed problems with updating Oracle blob fields
- + Added Register option to help menu
- + Various bug fixes and interface improvements
- + Various bug fixes and interface improvements
- + Added Keep Characters Function
- + Added Epoch to Date Function
- + Added Date to Epoch Function
- + Interface improvements
- + Documentation update
- - Various bug fixes
- + 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 introduced
- - Various bug fixes
- + Support for BDE was introduced
- + Documentation update
- - Various bug fixes
- - Various bug fixes
- + Introduced Autocomplete functionality
- - Addressed some issues related to loading data from QVD files
- - Various bug fixes
- + Support for stored procedures as a data target was introduced
- + Performance improvements for MS SQL Server Connection
- + Various Bug Fixes
- + Documentation Update
- + Added option to ignore XML tags between Table tag and Record tag
- + Documentaiton Update
- - Various bug fixes
- + Support for QVD files as data source was introduced
- + Massive performance improvement up to 10+ times for some data sources/targets
- - Various bug fixes
- + Support for Brightpearl was introduced
- + Support for SalesForce was introduced
- + Support for JDBC was introduced
- + Documentation update
- - Various bug fixes
- + Uses 10 times less memory for large excel files
- + Documentation update
- + Support RSS, Google Spreadsheets and Windows event log as data source now
- + 6+ Times performance improvement for working with large excel files.
- + Uses less memory for excel files
- + Support for Dynamic SQL for ETL transformations was introduced
- - Addressed some issues related to working with MS SQL Server Compact edition
- + 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
- + Added incremental search for expressions editor
- + Added filesize transformation function
- + GUI Improvements
- + Support for variables in import was introduced
- + Better error handling for data source
- + 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
- Fixed bugs related to working with time fields in MySQL
- Added Support for XSLT transformations
- User Interface Update
- Various bug fixes
- User Interface Update
- XML processing improvments
- Fixed number of issues related to loading data from XML file
- Added "Search in subdirectories" option to the data reader
- Added Save, Save As and Open items to the menu
- The clear log shows the dialogue box first
- Direct Latest Version downloads from application
- Various Bug Fixes
- Get latest version menu item was added
- Support for utf-16 was introduced for XML data reader
- Various bug fixes
- Now user can double click on *.vis file to open it
- Data transformation language extension
- 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
- Fixed number of problems related to working with unique identifier fields in SQL server
- Added post changes button
- Added Optimize Column Width button for all grids
- Some corrections for German Locale were introduced
- Addressed a number of problems related to working with unique identifier fields in SQL Server
- Fixed bug loading zero-length files
- Various bugs fixes
- Support for MS SQL Server Compact Edition was introduced
- Calculations Enhancements
- Various bugs fixes
- Fixed some issues with SQLite
- Corrected problem with duplicated source fields
- Various bugs fixes
- Various bugs fixes
- The problem with null dates was resolved
- Major update
- Calculations and scripting language changes
- The 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 a new menu item
- "Correct calculations"
- 4 Lots of new functions, 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
- MD5 Function was introduced
- Various bug fixes
- Works correctly with mixed case objects in PostgreSQL
- Data grid grouping access violations fixes
- Send email to support fixed
- Loads data from XML files
- Exports data into XML
- Works correctly with multiple PostgreSQL schemes
- Support for PostgreSQL 9 was introduced
- Support for German Locale was introduced
- Select all and copy from data grids
- Documentation Update
- Loads data into PostgreSQL 9.0
- Improved Unicode support for Oracle connections
- Title menu in data grids was added
- Various Data transformation improvements
- Supports multiple ends of line delimiters now
- Memory leaks fixes
- Works directly with SQLite now
- New look and feel
- Various Interbase/Firebird related bug fixes
- Fixed bug with the import of MS Access tables with spaces in names
- Various bug fixes
- 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 than 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:
- A grouping panel was added
- Advanced filter dialogue was introduced
- Record number
- New look and feel
- Also:
- Table browser loads data much faster
- Various Access violation and bug fixes
- Various interface improvements
- Various access violations were fixed
- The problem with duplicated fields was resolved
- Some problems were addressed related to loading data into varchar(max),nvarchar(max),varbinary(max)
- Various bug fixes
- Support for SQL Server 2005/2008 was improved
- Improved support for blobs.
- Various bug fixes
- Fields Notes were added
- Support for Ole Db was Introduced
- A new tab was added to the data source properties dialogue called "Data reading restrictions"
- Added GetSystemVariable("OUTPUT_RECORDNUMBER")
- Aded new calculation function DateDiffS
- DecDateS(Date1,Format1, Date2,Format2,Type):String.
- Use DateDiffS to calculate the difference between two dates.
- Documentation update
- Support for MySql, PostgreSQL and Interbase was added
- Some spelling errors were corrected
- Minor bug fixes
- 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
- Changes are:
- Automatic Version check was introduced
- Various bug fixes
Need help with an upgrade?
If you are upgrading an older repository, review the repository update notes and test the upgrade on a copy first.