8.0.1.3 + Support for QlikView QVX files was introduced - Various bug fixes 8.0.1.2 + Timeout was added to sql scripts 8.0.1.1 - Corrected some issues related to agent registration 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.1 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 + Easy agent management + Package Debugging + Highly optimised code + Schedule for execution Packages, Import Scripts and SQL scripts + Notes for Directories and Connections. + Connection testing for FTP,SMTP and POP3 + 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 + Schedule for execution using agent only as option + 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 - Execution agent fix for win64 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 Documentation update Scripting languge was extended 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.13 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 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 Changes are: Automatic Version check was introduced Various bug fixes