Visual Importer ETL Professional- History Of Changes


8.4.2.21

+ Added: Added variable
+ Added : Do not show notifications option was added
+ Improved : Computer to execute on is converted to upper case now
+ Improved : Current computer name is used by default as Computer to execute on
- Fixed : Addressed issues with variable

8.4.2.18

+ Improved : Date Format list
+ Improved : Global variables handling for reports

8.4.2.17

- Fixed : BDE Datasource issues
+ Improved : MySQL Error handling
+ Improved : Global variables handling

8.4.2.16

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

8.4.2.15

+ Added: Execute One Action at the time option
- Fixed : Problems with reading data from Salesforce

8.4.2.14

- Fixed : Problems with refreshing list of Oracle Tables

8.4.2.13

- Fixed : Problems with AM/PM Date conversion

8.4.2.12

- Fixed : SFTP Rename issues

8.4.2.11

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

8.4.2.10

+ Improved : JDBC Errors Handling

8.4.2.9

- Fixed : Problems with Soap Package Action Parameters

8.4.2.7

+ New : Keep Alive option to FTP Dialogue
+ Improved : status bar formatting for FTP operations

8.4.2.6

- Fixed : Problems with Import script properties dialogue

8.4.2.5

- Fixed : Problems with aborting import were resolved

8.4.2.4

- Fixed : Problems with reading data from unicode files
- Fixed : Problems with command line execution

8.4.2.2

+ 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
+ Improved : Log and rejected records files are no longer using executable location
+ Improved : Log screen refresh logic
+ New : Support SSL v2, v3, v1_1 and v1_2 was introduced
+ New : Support for opening xls versions from 2 to 4
- FTP action bug fixes
- 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
- Fixed : Row Cannot Be Located for Updating issue

8.4.1.9

- Addressed data compression issues
+ Added support for aes192-cbc,aes192-ctr,aes256-cbc,aes256-ctr encryption to FTP connection dialog

8.4.1.8

+ Added support for aes192-cbc,aes192-ctr,aes256-cbc,aes256-ctr encryption to FTP client

8.4.1.7

+ Added variable

8.4.1.6

- Addressed Salesforce data update issues

8.4.1.5

- Addressed Salesforce data update issues

8.4.1.4

+ Improved support for RSS feeds

8.4.1.2

+ Support for latest tableau api was introduced

8.4.1.1

+ New datasource file system was introduced
+ Script Package action support for Python was introduced
- Minor bug fixes

8.4.0.13

- Package designer bugs fixes
- Date fields processing bugs fixes

8.4.0.11

- SalesForce data processing fixes

8.4.0.10

- Addressed DTD is prohibited issues

8.4.0.9

- Addressed email processing problems

8.4.0.8

+ PDF Report quality improvements

8.4.0.6

+ Added fail on no emails check box option to POP3 and IMAP4 packages action
+ Added ,
,
,
variables

8.4.0.5

- Scheduler bug fix

8.4.0.4

+ Improved support for very large QVD files

8.4.0.3

+ Added ability to filter incoming messages by Recipient, CC and BCC to package actions
- Addressed Date conversion problems

8.4.0.2

+ SSL Libraries update
+ SalesForce connection uses TLS 1.1 now
+ Third party components update
- Addressed issues with IMAP4 package action

8.4.0.1

+ Uses tableau API 9.2 now
- Addressed issues with print preview screen
- Addressed issues with flicking

8.4.0.0

+ 64 bit version initial release
+ Added MRU List to data entry grid
+ Error handling improvements

8.3.14.0

+ Added SOAP package action
+ Added XSLT Transformation package action
+ Added Open Now button to HTTP download package action
- Addressed issues with getting stored procedures parameters
- Addressed issues with downloading files via HTTP/HTTPS

8.3.13.20

+ Add refresh databases button to source and target connections
+ Added support for Unicode in server, database and table names
+ ODBC error messages support Unicode now
+ Added processor info to application title
- Expanded red box size in the status bar
- Addressed issues with loading data from JDBC data sources
- Addressed issues with loading data from Windows Event Log
- Fixed issues with syntax highlighting in Mapping editor

8.3.13.19

- Addressed issues with downloading files via HTTP/HTTPS

8.3.13.16

+ 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
+ Added Active Directory connection

8.3.13.14

+ Added option to list only file names via ftp
- Addressed issues with reading very large QVD files
- Addressed issues with loading empty files via FTP

8.3.13.12

+ Added option to enable all variables in the package
+ Faster QVD files processing
- Addressed issues with creating QVD files
- Addressed issues with downloading files using SSL

8.3.13.11

- Addressed issues with downloading files via HTTP/HTTPS

8.3.13.10

+ Faster QVD files processing
- Addressed issues with variables

8.3.13.8

+ Added connection status variable to FTP, SMTP, POP3 ad IMAP4 connections
- Addressed issues with deleting notes from packages
- Addressed issues for FTP connection's variables

8.3.13.7

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

8.3.13.6

- Addressed issues with FTP list action
- Addressed issues with File merge action

8.3.13.2

- Addressed issues with loading data into time fields
+ Added Additional Parameters option to GPG4 Package Action
+ Added After Execution tab to all Package Actions

8.3.13.1

+ Added Check Directory Package action

8.3.13.0

+ Added support for Active Directory as data source
+ Added catch all objects to package
- Addressed issues with filtering date
- Addressed issues with exporting data into excel files

8.3.12.12

+ Smaller Executable
+ Updated regular exression Engine

8.3.12.11

+ Added UTC To Local Date and Local Date to UTC script functions
- Addressed issues HTTP Download action

8.3.12.10

- Addressed issues with Log screen

8.3.12.9

+ Added FileLine transformation function
- Addressed issues with Loop package action

8.3.12.7

- Addressed issues with deleting objects from the library

8.3.12.6

- Addressed issues with Slemma Import

8.3.12.5

- Addressed issues with Loop package action

8.3.12.4

+ Added support for Clarion
+ Added support for Twitter

8.3.12.3

- Addressed issues with sending emails with attachments

8.3.12.1

+ All documentation is in wiki format now
- Addressed issues with starting multiple packages at the same time

8.3.12.0

+ Added support for Slemma

8.3.11.3

+ 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

8.3.11.1

- Management console fixes

8.3.11.0

+ Google spreadsheet API update
+ Support for Salesforce Bulk API was introduced
+ Added MONTH_EXACT to DateDiffS function
+ Zip libraries update
+ Added Search in subdirectories Option to File Operation, Check File and Archive Actions

8.3.10.39

- Addressed issues with loading null values into salesforce

8.3.10.37

- Addressed issues with loading data from SQL Server CE

8.3.10.36

- Addressed issues with loading data from delimited files

8.3.10.35

+ Documentation update
+ Added GetExcelCellValue calculation function

8.3.10.34

- Addressed issues with retrieving information about Primary keys

8.3.10.32

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

8.3.10.30

+ 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
+ Added record number to package export object
- Various bugs fixes and improvements

8.3.10.28

+ 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

8.3.10.27

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

8.3.10.26

+ Added ability to lock the objects
- Addressed issues with google spreadsheets processing
- Various bugs fixes and improvements

8.3.10.25

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

8.3.10.24

- Addressed issues with salesforce data processing
- Various bug fixes and improvements

8.3.10.23

- Addressed issues with running ODBC Manager from application

8.3.10.21

+ SSL libraries update
- Various bug fixes and improvements

8.3.10.20

+ Up to 10 percent faster data loading
+ New version of report builder
+ Report builder documentation update
+ Various bug fixes and improvements

8.3.10.19

+ Support for MS SQL server 2014 was extended
+ Scheduler dialogue improvements
- Addressed issues with sending SMS messages

8.3.10.18

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

8.3.10.17

+ Added Vertical Grid
+ Third party components update

8.3.10.16

- SFTP rename bug fix
- Table Editor bug fixes

8.3.10.15

+ Third party components update

8.3.10.14

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

8.3.10.13

- Updated repository creation scripts

8.3.10.12

+ Check File Action has new option: Check if file is in Use
+ Licence Update
+ Documentation Update

8.3.10.11

+ Changed the way parameters are passed into reports
+ Documentation update

8.3.10.10

- Addressed issues with XML encoding

8.3.10.9

+ Third party components update
+ Incremental search was added to all grids
+ Export to RTF was introduced
+ Excel export formats improvements
+ Various Interface improvements
+ Documentation update
+ Loop Package Action improvements
- Minor bugs fixes
- Spelling corrections

8.3.10.8

+ Loop Package Action improvements

8.3.10.7

+ Setup Update
+ Added Loop Package Action
+ Added Create list of files option to File Operation Package Action

8.3.10.5

- Addressed Salesforce connection dialogue issues

8.3.10.4

- Addressed SFTP bugs

8.3.10.3

+ Minor interface improvements

8.3.10.2

+ Added Hide Template Tab option
+ Better report error handling
- Report generator bugs fixes

8.3.10.0

+ Introduced support for Salesforce as datatarget

8.3.9.30

- Report generator bugs fixes

8.3.9.29

+ Extended functionality of File Operation, Zip and Check File package actions

8.3.9.27

- MySQL bugs fixes

8.3.9.25

+ Documentation Update
+ Better Data Reader Memory Management

8.3.9.24

+ Support for using variables inside package zip object password was introduced

8.3.9.22

- Addressed issues with BIGINT fields

8.3.9.21

+ Import Script checking improvements
- Management console fixes

8.3.9.19

+ New package Object - SMS
+ Documentation Update
+ Import Script checking improvements
+ Interface improvements
- Date Format bugs fixes

8.3.9.17

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

8.3.9.16

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

8.3.9.15

- Addressed problems with refreshing logs

8.3.9.13

+ Excel processing engine update

8.3.9.12

- Addressed issues with Undo Redo buttons
- Addresed problems with refreshing logs

8.3.9.11

+ Support for latest version of Google spreadsheets was introduced

8.3.9.10

+ List of connections is sorted alphabetically now
- Minor XML processing fixes

8.3.9.9

+ Up to 50 percent faster working with QVD files

8.3.9.8

+ Added Authentication support to HTTP package objects

8.3.9.7

- Addressed memory leaks problems

8.3.9.6

- Addressed issues with sending emails with attachments

8.3.9.4

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

8.3.9.3

- Fixed problem with log deltion

8.3.9.2

- XML and ODBC fixes

8.3.9.0

+ Repository structure was changed
Two new tables were added QUEUE_HISTORY and QUEUE_ACTIONS_HISTORY
Once package execution is completed records from QUEUE and QUEUE_ACTIONS are moved into those two tables
These modifications improve overall application stability
+ Added separate application to edit options
- Addressed file update problems

8.3.8.17

+ Added support for dinamic file names in attachments
+ Up to 5 percent faster now

8.3.8.12

- MySQL date preocessing bugs fixes
- Addressed some copy/paste issues

8.3.8.11

- Minor bugs fixes

8.3.8.10

+ Added library of objects

8.3.8.9

- Addressed issues of empty date fields

8.3.8.8

- Addressed issues of loading data from Excel files

8.3.8.7

+ Added snap to grid option
+ Added RichText object to the Report Designer
+ Addded Data Port option to FTP Connection

8.3.8.4

- Addressed issues with sending emails

8.3.8.1

+ Added following variables





+ Documentation Update
+ Extended functionality of send email action
- Addressed issues with loading data into MySQL

8.3.8.0

+ Introduced Management Console
- Addressed some FTP Package dialogue issues

8.3.7.27

- Addressed issues of loading data from flat files

8.3.7.25

- Addressed issues with long object names

8.3.7.24

+ HTTP Form package object was introduced
+ Documentation update
+ ,, system variables we added

8.3.7.23

- Corrected issues with FTP automation

8.3.7.22

- Addressed issues with auto-save functionality

8.3.7.21

+ Progress dialogue shows now execution log as well
+ Progress dialogue has option to clear log first
+ Support for Zoom in/Out was introduced
+ Better printing support
- Email processing bug fixes

8.3.7.20

- Corrected issues with processing emails send by IPAD
- Addressed issues of loading data from flat files

8.3.7.19

- Addressed issues of loading data from flat files

8.3.7.18

+ Addressed issues with parralel task executions

8.3.7.17

+ Added send as HTML option
- Addressed issues of loading data from flat files
- Fixed bugs related to loadig data in to VARCHAR(MAX) fields.

8.3.7.15

+ Better handling of large Salesforce tables
+ Support for multiple Salesforce environments was introduced
+ Emails are send as HTML now
- Addressed issues with updating data

8.3.7.14

- QVD reading bug fixes

8.3.7.13

+ Incremental Object search works with comments and connections now
+ Better handling of empty Salesforce tables
+ Support for GreenPlum was introduced

8.3.7.12

+ Added ability to hide tabs on main screen
+ Added select count(*) from table menu item to sql browser
+ Added Space Horizontally and Space Vertically buttons
+ Search dialogue edit box value is stored in registry now
- Addressed issues with date fields processing
- Addressed issues of loading data from delimited files

8.3.7.10

+ Added option to resize objects selector

8.3.7.9

+ Added search functionality to package editor
- Salesforce bug's fixes

8.3.7.7

+ Better source connection errors handling

8.3.7.6

+ Extended Global variables scope
- Salesforce bug's fixes
- Fixed problem with zip files locking
- Resolved Synchronization problem

8.3.7.5

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

8.3.7.4

+ Sales force connection support latest API now
+ Support for MariaDB was introduced
+ Documentation Update
- Addressed problems with package editor
- Addressed problems with loading date fields
- Addressed problem with handling NULLs
- Fixed AV when loading data into MySQL

8.3.7.2

- Addressed problem with ping object

8.3.7.1

+ Minor Interface improovments
- Addressed problems with excel date formatting

8.3.7.0

- Addressed problems with SalesForce connection
+ Documentation update

8.3.6.12

- Addressed problems with formating dates

8.3.6.11

+ Another 10 percent performance increase
- Addressed problems with scientific numbers in Excel
- Fixed bug with too many rejected records
- Smaller executable
- Addressed problem with non ASCI characters in scripts/transformations/mappings etc

8.3.6.6

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

8.3.6.4

+ Up to 100 percent performance increase

8.3.6.3

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

8.3.6.2

+ Global Variables (very useful for switching from development to production)
+ Further 10 percent performance increase for loading data from text files
+ Documentation update
- Various bug fixes and interface improvements

8.3.6.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
- Various bug fixes and interface improvements

8.3.6.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%
+ Package Objects Selector is movable and resizeable now
- Various bug fixes and interface improvements

8.3.5.12

- Various bug fixes and interface improvements

8.3.5.9

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

+ Multiple files decompression was introduced
+ File Rename with mask was introduced
- Undo/Redo bugs were fixes
- New object creation bugs were fixed

8.3.5.6

+ QVD generation bugs fixes
+ Added option to save scripts without opening them

8.3.5.3

+ Option to schedule execution on the last/first day of the month was added
+ Documentation update

8.3.5.2

+ Connection mapping dialogue was added to repository synchronisation wizard

8.3.5.1

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

8.3.5.0

+ Smaller executable
+ Memory usage was reduced for Excel files (50-25 percent less)
+ Added ObjectId label to data target properties dialogue
- Various bug fixes and interface improvements

8.3.4.9

- Addressed Repository Synchronization wizard bugs

8.3.4.8

- Various bug fixes

8.3.4.6

+ Introduced Repository Synchronization wizard

8.3.4.5

+ Addressed problems with updating Oracle blob fields

8.3.4.3

+ Undo/Redo Functionality was improoved
+ Documentation update

8.3.4.2

+ Various bug fixes
+ Documentation update

8.3.4.1

+ Documentation update
- Addressed some regular expressions bugs

8.3.3.8

+ Added support to Redo and Undo to package designer
+ Added Register option to help menu
+ Various bug fixes and interface improvements

8.3.3.5

+ Added snap to grid to functionality
+ Various bug fixes and interface improvements

8.3.3.2

+ Added align left, align top, align right, and align bottom buttons
+ Better object selection for packages
+ Various bug fixes and interface improvements

8.3.2.11

+ Support for PGP was introduced
- Various bug fixes

8.3.2.10

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

8.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

8.3.2.2

+ New function was introduced ExecuteObject(ObjectId)
+ Documentation update
- Various bug fixes

8.3.2.0

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

8.3.1.4

+ Added copy paste functionality to IMAP connections
+ OLE Reports Dialogue is resizable now
- Various bug fixes

8.3.1.0

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

8.3.0.0

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

8.2.0.4

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

8.2.0.2

- Repository Scripts fix
- Various bug fixes

8.2.0.0

+ Support for QVD files was introduced
- Various bug fixes

8.1.2.3

+ New Version control tab was introduced
+ Version control can submit several objects now
+ Version control dialog can delete multiple objects now
- Various bug fixes

8.1.2.1

+ New package object was introduced = Case
+ New variables ,,'
- Various bug fixes

8.1.1.2

- Various bug fixes

8.1.1.0

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

8.1.0.0

+ Support for BrightPearl was introduced
+ Support for IMAP4 was introduced
+ Support for Sales Force was introduced
+ Support for JDBC was introduced
+ Additional filters for file/zip and check file operations
+ Documentation update
- Various bug fixes

8.0.3.2

+ Uses 10 times less memory for large excel files
+ Support for loading data from RSS, Google spread sheets and windows event logs was introduced
+ Dynamic Excel sheet names
+ Documentation update
- Various bug fixes

8.0.3.1

+ 10x performance increase for generating QVX files
- Addressed some issues related to working scheduler
- Various bug fixes

8.0.2.6

- Addressed some SMTP problems

8.0.2.1

+ Support for Dynamic SQL for ETL transformations was introduced

8.0.1.5

- Addressed some issues related to working with integrated scheduler

8.0.1.4

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

8.0.1.2

+ Support for QlikView QVX files was introduced
- Various bug fixes

8.0.1.1

+ Timeout was added to sql scripts

8.0.1.0

+ Support for decompression of following file formats was introduced:

Zip archive *.zip;*.jar;*.ear;*.war;*.cbz;*.apk;*.wsz;*.wal;*.xpi;*.crx;*.dfsz;*.pcv;*.bsz;*.mskin;*.wmz;*.ipa;*.docx;*.xlsx;*.pptx;*.sxw;*.sxi;*.sxt;*.sxd;*.sxc;*.sxm;*.sxg;*.stw;*.sti;*.std;*.stc;*.odh;*.odd;*.odt;*.odm;*.ods;*.ots;*.odg;*.otg;*.odp;*.otp;*.odf;*.odb
BZip2 archive *.bz2;*.bzip2;*.tbz2;*.tbz
Rar archive *.rar;*.r00;*.cbr
Arj archive *.arj
Z archive *.z;*.taz
Lzh archive *.lzh;*.lha
7z archive *.7z
Cab archive *.cab;*.fwp
Nsis archive *.nsis
Lzma archive *.lzma
Lzma86 archive *.lzma86
Pe archive *.exe;*.dll;*.sys;*.bpl
Elf archive *.
Mach-O archive *.
Udf archive *.iso;*.img
Xar archive *.xar;*.safariextz
Mub archive *.
Hfs archive *.hfs
Dmg archive *.dmg
Compound archive *.msi;*.msp;*.doc;*.xls;*.ppt
Wim archive *.wim;*.swm
Iso archive *.iso;*.img
Chm archive *.chm;*.chi;*.chq;*.chw;*.hxs;*.hxi;*.hxr;*.hxq;*.hxw;*.lit
Split archive *.001
Rpm archive *.rpm
Deb archive *.deb
Cpio archive *.cpio
Tar archive *.tar
GZip archive *.gz;*.gzip;*.tgz;*.tpz
Ntfs archive *.ntfs;*.img
Fat archive *.fat;*.img
Mbr archive *.mbr
Vhd archive *.vhd
MsLZ archive *.
Flv archive *.flv
Swf archive *.swf
Swf archive *.swf
APM archive *.
PPMD archive *.pmd
Terse Executable *.te
UEFIc archive *.scap
UEFIs archive *.
SquashFS archive *.squashfs
CramFS archive *.cramfs

+ Support for compression of following file formats was introduced:

Zip archive *.zip;*.jar;*.ear;*.war;*.cbz;*.apk;*.wsz;*.wal;*.xpi;*.crx;*.dfsz;*.pcv;*.bsz;*.mskin;*.wmz;*.ipa;*.docx;*.xlsx;*.pptx;*.sxw;*.sxi;*.sxt;*.sxd;*.sxc;*.sxm;*.sxg;*.stw;*.sti;*.std;*.stc;*.odh;*.odd;*.odt;*.odm;*.ods;*.ots;*.odg;*.otg;*.odp;*.otp;*.odf;*.odb
BZip2 archive *.bz2;*.bzip2;*.tbz2;*.tbz
7z archive *.7z
Tar archive *.tar
GZip archive *.gz;*.gzip;*.tgz;*.tpz
Swf archive *.swf

+ ZIP dialog can decompress and compress files now
+ Order of fields was charged in connection dialog: user selects server name, enters the user name and password and finally user selects the database.
+ Even smaller executable now
- SMTP testing was fixed for SSL connection
- Export Dialog alignment problem was corrected
- Main windows alignment problem was corrected
- Position saving problem was addressed for validator/transformer/package editor
- Corrected some repository creation scripts

8.0.0.2

MAJOR RELEASE

+ New repository structure compatible with Database browser,
+ Advanced ETL Processor and Active Table Editor
+ Mutiple SMTP, POP3, and FTP connections
+ Design and Generate Reports
+ Projects
+ Package Debugging
+ Highly optimised code
+ Schedule for execution Packages, Transformations and SQL scripts
+ CRC16,CRC24,CRC32,Adler32,CRC64,eDonkey,eMule,MD4,MD5,RIPEMD160,SHA1,SHA224,SHA256,SHA384,SHA512,Whirlpool checksums
+ Simplified Repository management
+ Execution log has Execution time percentage
+ Schedule package execution directly from the package designer
+ Same for sql scripts and data transformations
+ Schedule for execution on specific computer
+ Easy agent management
+ Simplified Repository management
+ Agent status logging and current agent tasks grid
+ Documentation update
+ Support for themes
+ Open Excel/text/access files from Visual Importer ETL
- Various bugs fixes and improvements

7.7.8.4

+ Package debugger was introduced
+ Breakpoints were introduced
+ Execute single package object option was introduced
+ More generic log viewer
+ Execution agent writes startup error messages in the log file
- Disaprearing tree nodes problem was addressed
- Minor interface tweaks

7.7.8.2

- Double atachment fix

7.7.8.1

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

7.7.8.0

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

7.7.7.23

Addressed some issues related to processing emails

7.7.7.22

Added pause package execution object

7.7.7.21

Fixed bugs related to working with time fields in MySQL
Export into excel via DDE was introduced

7.7.7.20

Added Support for XSLT transformations
Various bug fixes

7.7.7.16

Ping Server and Check Database connection was introduced
It is also possible to schedule package for execution directly from the package designer
Various bug fixes

7.7.7.15

Data Transformation Package can be run every second now

7.7.7.14

Data import wizard fixes
Import Script can get variables values from packages now

7.7.7.13

Added "Search in subdirectories" option to data reader

7.7.7.12

Fixed number of issues related to loading data from XML file

7.7.7.11

Package editor interface improvements

7.7.7.10

Clear log shows dialog box first
Direct Latest Version downloads from application
Various Bug Fixes

7.7.7.9

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

7.7.7.8

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

7.7.7.7

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

7.7.7.6

Addressed sftp host key not verified problem

7.7.7.5

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

7.7.7.4

SFTP bugs fixes

7.7.7.3

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

7.7.7.2

Fixed Issues with SQLite imports
Support for zip files > 4 gigs was introduced

7.7.7.0

Support for SFTP was introduced
Various problems related to working with very large files were resolved

7.7.6.8

Various bugs fixes
Repository creation wizard was introduced

7.7.6.6

Problem with null dates was resolved

7.7.6.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

7.7.6.3

MD5 Function was introduced
Various bug fixes

7.7.6.2

Works correctly with mixed case objects in PostgreSQL
Various bug fixes

7.7.6.1

Data grid grouping access violations fixes
Send email to support fixed

7.7.6.0

Loads Data from XML files
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

7.7.5.18

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

7.7.5.17

Supports multiple newline delimiters now

7.7.5.16

Memory leaks fixes

7.7.5.15

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

7.7.5.14

Various bug fixes

7.7.5.12

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
Sql browser loads data much faster
Log screen loads much faster
Various Access violation and bug fixes

7.7.5.11

Various interface improvements
Various access violations were fixed
Problem with duplicated fields was resolved
Application loads much faster now
Large repositories are updated much faster now

7.7.5.9

HTTP Downloads and ETL Package scripts were introduced
System Variables
Documentation Update
Some problems were addressed related to loading data into varchar(max),nvarchar(max),varbinary(max)

7.7.5.7

New button was added to data transformation log
Show first 100 records

7.7.5.6

Various bug fixes

7.7.5.4

Support for SQL Server 2005/2008 was improved

7.7.5.3

Improved support for blobs.
Various bug fixes

7.7.5.1

Fields Notes were added

7.7.5.0

Support for FTPS and FTPES was introduced
Support for Ole Db was added
Minor bug fixes


7.7.4.18

New tab was added to data source properties dialog called "Data reading restrictions"
Find Object dialog was added
Minor bug fixes

7.7.4.17

Various bug fixes

7.7.4.14

Repository Synchronization bugs were fixed
Support for MySql, Intebase and PostgreSql was added to Sql Check Data
Package copy paste bug was fixed
Minor bug fixes

7.7.4.10

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

7.7.4.6

Data Export Wizard was introduced
Now you can export 3000+ tables from the database with couple of clicks

7.7.4.5

Two new package objects Show message and Ask question
Additional option of Ftp object Passive/Active
various bugs fixes

7.7.4.4

Support for MySql, PostgreSQL and Interbase was added

7.7.2.9

Minor bug fixes

7.7.2.8

FTP Move files option was added
Move files has "Overwrite files" option now
Minor bug fixes

7.7.2.7

Some spelling errors were corrected
FTP Directory Listing is tab delimited now
Minor bug fixes

7.7.2.6

ODBC Connection String Builder Was Introduces
Support for FTP Directory Listing
Improved support for NonStop ODBC/MX 2.0 ver 3.51.20.126 ODBC Driver
Various Cosmetic Changes and Bug Fixes

7.7.2.5

Automatic Version check was introduced
Various bug fixes

Go to top