Softpedia >Windows >Internet >Servers >Database Utils >Visual Importer Standard >  Changelog

Visual Importer Standard Changelog

What's new in Visual Importer Standard 5.4.6.19

Apr 12, 2024
  • Improved: License server error handling

New in Visual Importer Standard 5.4.6.18 (Mar 27, 2024)

  • Improved: String delimiter handling

New in Visual Importer Standard 5.4.6.17 (Mar 17, 2024)

  • Fixed: Issues with viewing/editing very large numbers (MySQL, Postgress, Interbase/Firebird and SQLite)
  • Improved: Print preview dialogue is closed on ESC

New in Visual Importer Standard 5.4.6.16 (Mar 15, 2024)

  • Updated: SSH components

New in Visual Importer Standard 5.4.6.15 (Mar 11, 2024)

  • Fixed: Issues with reading Excel files

New in Visual Importer Standard 5.4.6.14 (Mar 5, 2024)

  • Updated: Excel components

New in Visual Importer Standard 5.4.6.13 (Feb 16, 2024)

  • Fixed: SQLite data reader bug.

New in Visual Importer Standard 5.4.6.12 (Jan 2, 2024)

  • Updated: Third party components

New in Visual Importer Standard 5.4.6.11 (Dec 10, 2023)

  • Updated: Excel components

New in Visual Importer Standard 5.4.6.10 (Dec 5, 2023)

  • Added: Refresh Tables list menu item to Table Browser dialogue

New in Visual Importer Standard 5.4.6.9 (Nov 30, 2023)

  • Fixed: Minour interface issues

New in Visual Importer Standard 5.4.6.8 (Nov 17, 2023)

  • Added: Support for python versions 3.10, 3.11 and 3.12

New in Visual Importer Standard 5.4.6.7 (Nov 3, 2023)

  • Updated Excel engine

New in Visual Importer Standard 5.4.6.6 (Oct 25, 2023)

  • Improved: Calculation engine update

New in Visual Importer Standard 5.4.6.5 (Oct 8, 2023)

  • Improved:
  • Components update: SSL, SSH, SFTP, MySQL, Postgre, SQLite, Interbase/Firebird

New in Visual Importer Standard 5.4.6.4 (Sep 25, 2023)

  • Added: Incremental search to Expression editor dialogue

New in Visual Importer Standard 5.4.6.3 (Sep 13, 2023)

  • Fixed: Issues with inserting default values within the data grid. (MySQL, Postgress, Interbase/Firebird and SQLite).

New in Visual Importer Standard 5.4.6.2 (Sep 11, 2023)

  • Fixed: Issues with inserting default values within the data grid. (MySQL, Postgress, Interbase/Firebird and SQLite)

New in Visual Importer Standard 5.4.6.1 (May 16, 2023)

  • Improved: Updated documentation link

New in Visual Importer Standard 5.4.6.0 (Jan 4, 2023)

  • Added: Support for SSH Connections to MySQL,Postgres and MongoDDB

New in Visual Importer Standard 5.4.5.17 (Jun 28, 2022)

  • Fixed: Viewing Views Issues while browsing the data
  • Improved: Loading data into smalldatetime fields

New in Visual Importer Standard 5.4.5.16 (Jan 13, 2022)

  • 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

New in Visual Importer Standard 5.4.5.15 (Dec 15, 2021)

  • Added: GUIDNB Transformation language function, it returns clean GUID value without brackets and underscores

New in Visual Importer Standard 5.4.5.14 (Jul 23, 2021)

  • Improved: XML Reading performance

New in Visual Importer Standard 5.4.5.12 (Jun 30, 2021)

  • Fixed: Issues with closing ODBC connection when refreshing target fields list

New in Visual Importer Standard 5.4.5.11 (Apr 11, 2021)

  • Improved: Working with HTML tables
  • Improved: Changed table search from case sensitive to not case sensitive

New in Visual Importer Standard 5.4.5.10 (Apr 3, 2021)

  • 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

New in Visual Importer Standard 5.4.5.8 (Feb 3, 2021)

  • Added: HTML Table Source
  • Updated: Digital signature

New in Visual Importer Standard 5.4.5.7 (Dec 22, 2020)

  • Fixed: Loading data from FoxPro.

New in Visual Importer Standard 5.4.5.6 (Dec 19, 2020)

  • Added: GetSystemDate function returns the fractions of a second now
  • Fixed: Licence management issues

New in Visual Importer Standard 5.4.5.4 (Nov 23, 2020)

  • Fixed: Issues with special characters inside sql server database names

New in Visual Importer Standard 5.4.5.3 (Nov 22, 2020)

  • Improved: Setup look and feel

New in Visual Importer Standard 5.4.5.1 (Oct 2, 2020)

  • Added:
  • Owner field to file system reader
  • FileOwner stripting language function

New in Visual Importer Standard 5.4.5.0 (Sep 26, 2020)

  • Added: Support for reading Tableau Hyper files.

New in Visual Importer Standard 5.4.4.18 (Jul 5, 2020)

  • Improved: Support for DATETIME2 Fields

New in Visual Importer Standard 5.4.4.17 (Jun 7, 2020)

  • Improved: Support for DATETIME2 Fields

New in Visual Importer Standard 5.4.4.16 (May 17, 2020)

  • Improved: Software registration process

New in Visual Importer Standard 5.4.4.15 (May 4, 2020)

  • Improved: JSON Data Handling

New in Visual Importer Standard 5.4.4.14 (Apr 10, 2020)

  • Added: Support for SQL Server 2017
  • Fixed: Issues with loading data into varchar(max) field
  • Improved: SQL Server error handling

New in Visual Importer Standard 5.4.4.13 (Feb 5, 2020)

  • Added: Support for PostgreSql 12

New in Visual Importer Standard 5.4.4.12 (Sep 16, 2019)

  • Added: Ability to pull license from the license server

New in Visual Importer Standard 5.4.4.11 (Aug 26, 2019)

  • Fixed: Loosing mapping bug when search box is used

New in Visual Importer Standard 5.4.4.10 (Jun 18, 2019)

  • Improved: Third party components update:
  • Excel processing libraries
  • Improved: Various bug fixes and improvements
  • Fixed: Excel data reading problems

New in Visual Importer Standard 5.4.4.9 (May 13, 2019)

  • Added: Syslog datasource

New in Visual Importer Standard 5.4.4.8 (May 1, 2019)

  • Fixed: Reading JSON Data AV.

New in Visual Importer Standard 5.4.4.7 (Mar 27, 2019)

  • Improved: Software Installation Process
  • Improved: Thrird Party Components Update
  • Fixed: Minor Python Integration Issues

New in Visual Importer Standard 5.4.4.6 (Mar 7, 2019)

  • 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

New in Visual Importer Standard 5.4.4.4 (Jan 17, 2019)

  • + Added: Support for calculations inside source file

New in Visual Importer Standard 5.4.4.3 (Dec 21, 2018)

  • Added: New datasource - Twitter
  • Improved: Loads data into SQL server up to 25 percent faster
  • Improved: Active Directory Connection look and feel

New in Visual Importer Standard 5.4.4.0 (Aug 21, 2018)

  • Improved: Third party components update

New in Visual Importer Standard 5.4.3.33 (Aug 13, 2018)

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

New in Visual Importer Standard 5.4.3.32 (Jul 27, 2018)

  • Improved: Third party components update

New in Visual Importer Standard 5.4.3.31 (Jul 23, 2018)

  • Improved: Third party components update

New in Visual Importer Standard 5.4.3.30 (Jul 17, 2018)

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

New in Visual Importer Standard 5.4.3.28 (Jul 13, 2018)

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

New in Visual Importer Standard 5.4.3.27 (Jul 9, 2018)

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

New in Visual Importer Standard 5.4.3.26 (Jul 3, 2018)

  • Improved: Google Spreadsheet import
  • Fixed: Salesforce Bulk API load issues

New in Visual Importer Standard 5.4.3.25 (Jun 20, 2018)

  • Improved: Google Spreadsheet import

New in Visual Importer Standard 5.4.3.21 (Jun 7, 2018)

  • Fixed: Salesforce Bulk API load issues

New in Visual Importer Standard 5.4.3.20 (Feb 25, 2018)

  • Fixed : Loading data into Google spreadsheet
  • Fixed : Issues with SFTP keys storage
  • Added: Ansi Driver checkbox to odbc connections

New in Visual Importer Standard 5.4.3.19 (Nov 29, 2017)

  • Added: Support For MongoDB

New in Visual Importer Standard 5.4.3.18 (Oct 23, 2017)

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

New in Visual Importer Standard 5.4.3.17 (Oct 2, 2017)

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

New in Visual Importer Standard 5.4.3.15 (Jun 16, 2017)

  • Fixed : Issues with QVX Files reading

New in Visual Importer Standard 5.4.3.14 (May 17, 2017)

  • Fixed: Issues with loading version info

New in Visual Importer Standard 5.4.3.13 (Apr 11, 2017)

  • Fixed: Fixed QVD reading issues

New in Visual Importer Standard 5.4.3.10 (Mar 6, 2017)

  • Improved: Maximum ODBC Connection String is 4K now

New in Visual Importer Standard 5.4.3.7 (Jan 10, 2017)

  • Improved: Query Builder components update
  • Improved: SSL components update

New in Visual Importer Standard 5.4.3.6 (Jan 10, 2017)

  • Fixed : Issues with updating data via table browser

New in Visual Importer Standard 5.4.3.5 (Jan 10, 2017)

  • 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

New in Visual Importer Standard 5.4.3.4 (Jan 10, 2017)

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

New in Visual Importer Standard 5.4.3.3 (Nov 24, 2016)

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

New in Visual Importer Standard 5.4.3.2 (Nov 24, 2016)

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

New in Visual Importer Standard 5.4.3.1 (Oct 25, 2016)

  • Improved:
  • Support for JSON as data source

New in Visual Importer Standard 5.4.3.0 (Oct 25, 2016)

  • Added:
  • Support for JSON as data source

New in Visual Importer Standard 5.4.2.9 (Aug 22, 2016)

  • Fixed : BDE Datasource issues
  • Improved : MySQL Error handling

New in Visual Importer Standard 5.4.2.8 (Aug 22, 2016)

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

New in Visual Importer Standard 5.4.2.7 (Jul 30, 2016)

  • Fixed : Problems with reading data from Salesforce

New in Visual Importer Standard 5.4.2.6 (Jul 25, 2016)

  • Fixed : Problems with refreshing list of Oracle Tables

New in Visual Importer Standard 5.4.2.5 (Jul 25, 2016)

  • Fixed : Problems with AM/PM Date conversion

New in Visual Importer Standard 5.4.2.4 (Jul 25, 2016)

  • Improved : JDBC Processing
  • Fixed : Problems with data preview dialogue

New in Visual Importer Standard 5.4.2.3 (Jul 25, 2016)

  • Improved : JDBC Errors Handling

New in Visual Importer Standard 5.4.2.2 (Jun 10, 2016)

  • Fixed : Problems with aborting import were resolved

New in Visual Importer Standard 5.4.2.1 (Jun 7, 2016)

  • Fixed : Problems with reading data from unicode files

New in Visual Importer Standard 5.4.2.0 (May 29, 2016)

  • Third party compoments 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

New in Visual Importer Standard 5.4.1.1 (Mar 23, 2016)

  • Support for latest tableau api was introduced

New in Visual Importer Standard 5.4.1.0 (Mar 14, 2016)

  • New datasource file system was introduced

New in Visual Importer Standard 5.4.0.4 (Feb 15, 2016)

  • Improved support for very large QVD files s

New in Visual Importer Standard 5.4.0.3 (Feb 15, 2016)

  • Addressed Date conversion problems

New in Visual Importer Standard 5.4.0.2 (Feb 15, 2016)

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

New in Visual Importer Standard 5.4.0.1 (Feb 15, 2016)

  • Uses tableau API 9.2 now

New in Visual Importer Standard 5.4.0.0 (Jan 9, 2016)

  • 64 Bit version release
  • Added support for MRU Lists

New in Visual Importer Standard 5.3.8.8 (Dec 7, 2015)

  • Addressed issues with getting stored procedures parameters

New in Visual Importer Standard 5.3.8.7 (Nov 5, 2015)

  • 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

New in Visual Importer Standard 5.3.8.6 (Oct 26, 2015)

  • Faster QVD files processing

New in Visual Importer Standard 5.3.8.5 (Oct 19, 2015)

  • Faster QVD files processing

New in Visual Importer Standard 5.3.8.3 (Oct 19, 2015)

  • Added RUNHIDDEN command line option

New in Visual Importer Standard 5.3.8.2 (Oct 19, 2015)

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

New in Visual Importer Standard 5.3.8.1 (Oct 6, 2015)

  • Addressed issues with loading data into time fields

New in Visual Importer Standard 5.3.8.0 (Sep 23, 2015)

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

New in Visual Importer Standard 5.3.7.8 (Sep 23, 2015)

  • Addressed issues with loading empty date fields into MySQL

New in Visual Importer Standard 5.3.7.4 (Sep 23, 2015)

  • Smaller Executable
  • Updated regular exression Engine

New in Visual Importer Standard 5.3.7.3 (Sep 23, 2015)

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

New in Visual Importer Standard 5.3.7.2 (Aug 11, 2015)

  • Added Save button to Transformer and Validator
  • Addressed issues with Slemma Import

New in Visual Importer Standard 5.3.7.1 (Aug 5, 2015)

  • Added support for Clarion

New in Visual Importer Standard 5.3.7.0 (Jul 20, 2015)

  • Added support for Slemma

New in Visual Importer Standard 5.3.6.27 (Jul 15, 2015)

  • 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

New in Visual Importer Standard 5.3.6.25 (May 27, 2015)

  • Addressed issues with loading null values into salesforce

New in Visual Importer Standard 5.3.6.24 (May 26, 2015)

  • Addressed issues with loading data from SQL Server CE

New in Visual Importer Standard 5.3.6.23 (May 19, 2015)

  • Addressed issues with loading data from delimited files

New in Visual Importer Standard 5.3.6.22 (May 8, 2015)

  • Documentation update
  • Added GetExcelCellValue calculation function

New in Visual Importer Standard 5.3.6.21 (Apr 16, 2015)

  • Addressed issues with retrieving information about Primary keys

New in Visual Importer Standard 5.3.6.20 (Apr 16, 2015)

  • Documentation update
  • Addressed issues with processing of delimited files
  • Addressed issues with date formats

New in Visual Importer Standard 5.3.6.19 (Apr 8, 2015)

  • Addressed issues with processing of delimited files

New in Visual Importer Standard 5.3.6.17 (Apr 1, 2015)

  • 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

New in Visual Importer Standard 5.3.6.16 (Mar 25, 2015)

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

New in Visual Importer Standard 5.3.6.14 (Mar 5, 2015)

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

New in Visual Importer Standard 5.3.6.13 (Feb 27, 2015)

  • Addressed issues with running ODBC Manager from application

New in Visual Importer Standard 5.3.6.12 (Feb 25, 2015)

  • SSL libraries update
  • Various bug fixes and improvements

New in Visual Importer Standard 5.3.6.11 (Feb 23, 2015)

  • Up to 10 percent faster data loading

New in Visual Importer Standard 5.3.6.9 (Feb 11, 2015)

  • Support for MS SQL server 2014 was extended

New in Visual Importer Standard 5.3.6.8 (Feb 2, 2015)

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

New in Visual Importer Standard 5.3.6.7 (Jan 30, 2015)

  • Added Vertical Grid
  • Third party components update

New in Visual Importer Standard 5.3.6.6 (Jan 19, 2015)

  • Third party components update

New in Visual Importer Standard 5.3.6.5 (Jan 13, 2015)

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

New in Visual Importer Standard 5.3.6.4 (Dec 10, 2014)

  • Setup and executable are digitally signed now
  • Minor bugs fixes

New in Visual Importer Standard 5.3.6.3 (Dec 2, 2014)

  • Addressed issues with XML encoding

New in Visual Importer Standard 5.3.6.2 (Nov 25, 2014)

  • 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

New in Visual Importer Standard 5.3.6.1 (Nov 11, 2014)

  • Added installation options

New in Visual Importer Standard 5.3.6.0 (Oct 14, 2014)

  • Introduced support for Salesforce as datatarget

New in Visual Importer Standard 5.3.5.37 (Sep 19, 2014)

  • MySQL bugs fixes

New in Visual Importer Standard 5.3.5.36 (Sep 16, 2014)

  • Better Data Reader Memory Management

New in Visual Importer Standard 5.3.5.35 (Sep 4, 2014)

  • Addressed issues with BIGINT fields

New in Visual Importer Standard 5.3.5.34 (Aug 27, 2014)

  • Addressed issues with BIGINT fields

New in Visual Importer Standard 5.3.5.33 (Aug 26, 2014)

  • Import Script checking improvements

New in Visual Importer Standard 5.3.5.32 (Aug 14, 2014)

  • Date Format bugs fixes

New in Visual Importer Standard 5.3.5.31 (Aug 1, 2014)

  • Import Script checking improvements

New in Visual Importer Standard 5.3.5.30 (Jul 28, 2014)

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

New in Visual Importer Standard 5.3.5.29 (Jul 28, 2014)

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

New in Visual Importer Standard 5.3.5.28 (Jul 15, 2014)

  • Excel processing engine update

New in Visual Importer Standard 5.3.5.27 (Jun 28, 2014)

  • Support for latest version of Google spreadsheets was introduced

New in Visual Importer Standard 5.3.5.26 (Jun 20, 2014)

  • Up to 50 percent faster working with QVD files

New in Visual Importer Standard 5.3.5.23 (May 30, 2014)

  • Addressed issues of loading data from the files with old creation date
  • Smaller Setup

New in Visual Importer Standard 5.3.5.22 (May 15, 2014)

  • XML and ODBC fixes

New in Visual Importer Standard 5.3.5.20 (Mar 28, 2014)

  • Up to 5 percent performance increase

New in Visual Importer Standard 5.3.5.19 (Mar 17, 2014)

  • MySQL date processing bugs fixes

New in Visual Importer Standard 5.3.5.18 (Mar 14, 2014)

  • Minor bugs fixes

New in Visual Importer Standard 5.3.5.15 (Mar 14, 2014)

  • Addressed issues of empty date fields

New in Visual Importer Standard 5.3.5.14 (Mar 14, 2014)

  • Addressed issues of loading data from Excel files

New in Visual Importer Standard 5.3.5.13 (Jan 3, 2014)

  • Addressed issues of loading data from flat files

New in Visual Importer Standard 5.3.5.12 (Dec 16, 2013)

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

New in Visual Importer Standard 5.3.5.11 (Dec 6, 2013)

  • Adressed some issues of loading data from text files

New in Visual Importer Standard 5.3.5.9 (Nov 27, 2013)

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

New in Visual Importer Standard 5.3.5.8 (Nov 15, 2013)

  • QVD reading bug fixes

New in Visual Importer Standard 5.3.5.7 (Nov 11, 2013)

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

New in Visual Importer Standard 5.3.5.6 (Nov 7, 2013)

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

New in Visual Importer Standard 5.3.5.3 (Oct 29, 2013)

  • Better source connection errors handling

New in Visual Importer Standard 5.3.5.2 (Oct 29, 2013)

  • Salesforce bug's fixes

New in Visual Importer Standard 5.3.5.1 (Oct 14, 2013)

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

New in Visual Importer Standard 5.3.5.0 (Oct 10, 2013)

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

New in Visual Importer Standard 5.3.4.11 (Oct 7, 2013)

  • Addressed problems with formating dates
  • Addressed problems with SalesForce connection
  • Documentation update

New in Visual Importer Standard 5.3.4.10 (Sep 30, 2013)

  • Addressed problems with autoformat option

New in Visual Importer Standard 5.3.4.8 (Sep 30, 2013)

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

New in Visual Importer Standard 5.3.4.6 (Sep 18, 2013)

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

New in Visual Importer Standard 5.3.4.5 (Sep 9, 2013)

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

New in Visual Importer Standard 5.3.4.3 (Sep 9, 2013)

  • Up to 100 percent performance increase

New in Visual Importer Standard 5.3.4.2 (Sep 9, 2013)

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

New in Visual Importer Standard 5.3.4.1 (Sep 9, 2013)

  • 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

New in Visual Importer Standard 5.3.4.0 (Sep 9, 2013)

  • 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

New in Visual Importer Standard 5.3.3.11 (Jul 31, 2013)

  • Various bug fixes and interface improvements

New in Visual Importer Standard 5.3.3.9 (Jul 24, 2013)

  • 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

New in Visual Importer Standard 5.3.3.8 (Jul 1, 2013)

  • Various bug fixes and interface improvements

New in Visual Importer Standard 5.3.3.7 (Jun 6, 2013)

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

New in Visual Importer Standard 5.3.3.6 (May 29, 2013)

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

New in Visual Importer Standard 5.3.3.5 (Apr 25, 2013)

  • Addressed problems with updating Oracle blob fields

New in Visual Importer Standard 5.3.3.2 (Mar 9, 2013)

  • Added Register option to help menu
  • Various bug fixes and interface improvements

New in Visual Importer Standard 5.3.3.0 (Mar 9, 2013)

  • Various bug fixes and interface improvements

New in Visual Importer Standard 5.3.2.9 (Feb 14, 2013)

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

New in Visual Importer Standard 5.3.2.6 (Feb 12, 2013)

  • Executable is smaller now
  • Support for Excel 2013 was itroduced

New in Visual Importer Standard 5.3.2.3 (Jan 29, 2013)

  • Improved support for MS SQL Server 2012
  • Improved support for BDE
  • Logging improvements for connection type, connection name and connection details
  • Various bug fixes

New in Visual Importer Standard 5.3.2.2 (Jan 21, 2013)

  • Support for BDE was introduced
  • Documentation update
  • Various bug fixes

New in Visual Importer Standard 5.3.2.0 (Jan 15, 2013)

  • Support for BDE was introduced
  • Documentation update
  • Various bug fixes

New in Visual Importer Standard 5.3.1.0 (Dec 3, 2012)

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

New in Visual Importer Standard 5.3.0.0 (Nov 22, 2012)

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

New in Visual Importer Standard 5.2.0.3 (Nov 5, 2012)

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

New in Visual Importer Standard 5.2.0.2 (Oct 9, 2012)

  • Various bug fixes

New in Visual Importer Standard 5.2.0.1 (Sep 3, 2012)

  • Support for QVD files as datasource was intruduced

New in Visual Importer Standard 5.2.0.0 (Aug 25, 2012)

  • Support for QVD files as datasource was intruduced

New in Visual Importer Standard 5.1.1.0 (Jul 5, 2012)

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

New in Visual Importer Standard 5.1.0.0 (Jul 5, 2012)

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

New in Visual Importer Standard 5.0.0.1 (May 15, 2012)

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

New in Visual Importer Standard 5.0.0.0 (May 15, 2012)

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

New in Visual Importer Standard 4.9.10.0 (Mar 9, 2012)

  • Support for Dynamic SQL for ETL transformations was introduced

New in Visual Importer Standard 4.9.9.8 (Feb 20, 2012)

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

New in Visual Importer Standard 4.9.9.6 (Dec 30, 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

New in Visual Importer Standard 4.9.9.4 (Dec 20, 2011)

  • Documentation Update
  • GUI Improvements

New in Visual Importer Standard 4.9.9.3 (Dec 2, 2011)

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

New in Visual Importer Standard 4.9.9.1 (Oct 20, 2011)

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

New in Visual Importer Standard 4.9.9.0 (Oct 10, 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

New in Visual Importer Standard 4.9.8.15 (Sep 8, 2011)

  • Fixed bugs related to working with time fields in MySQL

New in Visual Importer Standard 4.9.8.13 (Sep 7, 2011)

  • Added Support for XSLT transformations
  • User Interface Update
  • Various bug fixes

New in Visual Importer Standard 4.9.8.11 (Aug 8, 2011)

  • XML processing improvments

New in Visual Importer Standard 4.9.8.10 (Jun 21, 2011)

  • Fixed number of issues related to loading data from XML file

New in Visual Importer Standard 4.9.8.9 (May 26, 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

New in Visual Importer Standard 4.9.8.8 (May 13, 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

New in Visual Importer Standard 4.9.8.5 (Apr 21, 2011)

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

New in Visual Importer Standard 4.9.8.4 (Apr 13, 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

New in Visual Importer Standard 4.9.8.3 (Mar 29, 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

New in Visual Importer Standard 4.9.8.2 (Mar 1, 2011)

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

New in Visual Importer Standard 4.9.8.1 (Feb 7, 2011)

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

New in Visual Importer Standard 4.9.7.11 (Jan 20, 2011)

  • Fixed some Issues with SQLite

New in Visual Importer Standard 4.9.7.9 (Dec 16, 2010)

  • Corrected problem with duplicated source fields
  • Various bugs fixes

New in Visual Importer Standard 4.9.7.7 (Nov 30, 2010)

  • Various bugs fixes

New in Visual Importer Standard 4.9.7.6 (Nov 20, 2010)

  • Problem with null dates was resolved

New in Visual Importer Standard 4.9.7.5 (Nov 18, 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

New in Visual Importer Standard 4.9.7.3 (Nov 18, 2010)

  • MD5 Function was introduced
  • Various bug fixes

New in Visual Importer Standard 4.9.7.2 (Nov 12, 2010)

  • Works correctly with mixed case objects in PostgreSQL

New in Visual Importer Standard 4.9.7.1 (Oct 26, 2010)

  • Data grid grouping access violations fixes
  • Send email to support fixed

New in Visual Importer Standard 4.9.7.0 (Oct 24, 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

New in Visual Importer Standard 4.9.6.13 (Oct 11, 2010)

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

New in Visual Importer Standard 4.9.6.12 (Sep 24, 2010)

  • Supports multiple end of line delimiters now

New in Visual Importer Standard 4.9.6.11 (Sep 15, 2010)

  • Memory leaks fixes

New in Visual Importer Standard 4.9.6.10 (Sep 8, 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

New in Visual Importer Standard 4.9.6.9 (Sep 1, 2010)

  • Various bug fixes

New in Visual Importer Standard 4.9.6.8 (Aug 24, 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

New in Visual Importer Standard 4.9.6.7 (Jul 25, 2010)

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

New in Visual Importer Standard 4.9.6.6 (Jun 28, 2010)

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

New in Visual Importer Standard 4.9.6.4 (May 22, 2010)

  • Fixed Loading data into DBF files

New in Visual Importer Standard 4.9.6.2 (Apr 13, 2010)

  • Support for SQL Server 2005/2008 was improved
  • Various bug fixes

New in Visual Importer Standard 4.9.5.1 (Feb 2, 2010)

  • Various bug fixes

New in Visual Importer Standard 4.9.5.0 (Jan 14, 2010)

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

New in Visual Importer Standard 4.9.4.9 (Dec 23, 2009)

  • Minor bug fixes

New in Visual Importer Standard 4.9.4.6 (Oct 25, 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.

New in Visual Importer Standard 4.9.4.2 (Aug 8, 2009)

  • Minor Bug Fixes Documentation Update

New in Visual Importer Standard 4.9.4.1 (Aug 4, 2009)

  • Minor Bug Fixes Documentation Update

New in Visual Importer Standard 4.9.4.0 (Jul 14, 2009)

  • In this version we added support for PostgreSQL and Interbase/Firebird

New in Visual Importer Standard 4.9.3.9 (Jul 6, 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

New in Visual Importer Standard 4.9.2.4 (Jun 5, 2009)

  • Some spelling errors were corrected
  • Minor bug fixes

New in Visual Importer Standard 4.9.2.3 (Jun 1, 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

New in Visual Importer Standard 4.9.2.2 (May 24, 2009)

  • Automatic Version check was introduced
  • Various bug fixes

New in Visual Importer Standard 4.9.2.0 (Apr 1, 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

New in Visual Importer Standard 4.9.1.6 (Feb 14, 2009)

  • Up to 7 times faster ETL Transformation Thousands of records per second Full Support for Unicode Better integration for Oracle databases

New in Visual Importer Standard 4.8.10 (Nov 25, 2008)

  • Various bugs related to sql generation were fixed

New in Visual Importer Standard 4.8.8 (Oct 17, 2008)

  • Abort Import on error option was added Support for transactions was added for ODBC connection

New in Visual Importer Standard 4.8.6 (Sep 13, 2008)

  • Support for Excel 2007 and Access 2007

New in Visual Importer Standard 4.8.5 (Aug 3, 2008)

  • Incremental table filter was introduced for source connection

New in Visual Importer Standard 4.8.3 (May 3, 2008)

  • Some Minor bug fixes
  • Now it is possible to specify newline character for text files.

New in Visual Importer Standard 4.8.1 (Feb 24, 2008)

  • Now works with MS SQL Server

New in Visual Importer Standard 4.7.7 (Sep 9, 2007)

  • Now works with MS Access and DBF Files

New in Visual Importer Standard 4.7.3 (Apr 30, 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

New in Visual Importer Standard 4.6.5 (Aug 16, 2006)

  • New Transformation type was added -
  • Add new records

New in Visual Importer Standard 4.6.3 (Jul 30, 2006)

  • New Transformation type was added - Add new records