5.0.1.4 + Support for QlikView QVX files was introduced - Various bug fixes 5.0.1.3 + Timeout was added to sql scripts + Documentation update + First Record flag, Last Record flag, First Record flag for file/table/sheet, Last Record for file/table/sheet were added to Reader parameter data trasformation function + Sequence and Running total trasformation function improvements - Various bug fixes 5.0.1.2 - Corrected some issues related to agent registration 5.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 5.0.0.10 MAJOR RELEASE + New repository structure compatible with Database browser, + Visual Importer ETL Processor and Active Table Editor + After and Before transformation functions + Package Debugging + Parallel execution + Highly optimised code + Execution agent is now only 5 mb (compare this to some java etl tools) + Schedule for execution Packages, Transformations and SQL scripts + Run Packages, Transformations and SQL scripts from command line + Application Notes + 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 + Run Packages, Transformations and SQL scripts from command line + Edit lookup data + 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 - Various bugs fixes and improvements 4.2.7.3 - Addressed some scheduler issues 4.2.7.2 + Package debugger was introduced + Breakpoints were introduced + Execute single package object option was introduced + Project Tree View - COLLAPS/EXPAND buttons were added + More generic log viewer + Ability to group packages, sql scrits reports and emails was addedd + Package objects have objects tree for the selection now + Execution agent writes startup error messages in the log file - Disaprearing tree nodes problem was addressed - "Progam" file was created on drive c - Double attachments - XML XSLT tranformation fix - Some auto format issues were addressed - Minor interface tweaks - Addressed issues related to running execution agent on win64 4.2.7.0 + Null function + Interface Improvements + Standard print preview + Support for scrolling in Package editor and transformation editor + Option "Full tree expand" when unticked objects tree shows list of projects - Better error handling for ADO and MS Sql scripts - Command line parameter transformation function save problems 4.2.6.19 Support for MySQL 5.5 was introduced Boolean fix for MySql Better error hadling for ADO and MS Sql scripts Insert and delete colums for excel and and text data source and targets Interface Improvements Better NULL's handling Command line parameter transformation function was introduced 4.2.6.17 Various bug fixes 4.2.6.15 FormatStrToDate was added to calculation transformation ReformatDate, Set variable Get variable transformation functions were added SQL execution log functionality was greatly enhanced Execution log was added to data transformation/validation screen 4.2.6.14 Various bug fixes 4.2.6.13 Format field names dialog box was introduced Quote all menu item was added Fixed problem with compressing files Various bug fixes 4.2.6.12 File data writer have following new options now Overwrite all files Skip existing add create new ones Append data to existing files and create new ones Append data to existing files Delete Files 4.2.6.11 Added Insert Script generation to the package 4.2.6.10 Added Support for XSLT transformations Added Get Variable, XML XSLT transformation, Validate XML function Interface Update Various bug fixes Documentation Update Support for dynamic file names was improved 4.2.6.9 Ping Server and Check Database connection was introduced Added File name and Directory name extraction transformation functions Data splitter modifications Various bug fixes 4.2.6.8 Added Fields Selector transformation function Various bug fixes 4.2.6.7 Improved support for spaces in table names and sql reserved words Added clear log check box to transformation progress dialog Added open open execution log button Added Clone Row, Base64 Encode, Base64 Decode, GUID, Random transformation functions Various bug fixes 4.2.6.4 Sorter object allows to define directory to store data in and buffer size New transformation functions Decode HTTPDecode Encode HTTP Encode HTML Decode HTML Unix Path To Dos Path Dos Path To Unix Path 4.2.6.3 Range lookup transformation function was introduced When data is exported into excel file numeric values are stored as numbers Various bug fixes 4.2.6.2 Added "Search in subdirectories" option to data reader 4.2.6.1 Major update This release changes the way the Data Validator works It allows the user to validate and transform the data at the same time. To update: Open Data Validator and map validation rules to output fields. Save Data transformation. Repeat for all transformations 4.2.5.3 Incremental Transformation function search was introduced 4.2.5.1 Lookup Improvements and Fixes Data preview improvements Clear log shows dialog box first Transformer and Validator have names now Direct Latest Version downloads from application Various Bug Fixes 4.2.4.17 Various bug fixes Uses MS XML now 4.2.4.15 LeftPad(S,Length,Char):String, Pads Left part of the string with Character Char RightDelete(S,Length):String, Deletes Right part of the string RegularExpression(S,Expression):Boolean, Returns true if string matches expression EncodeXMLElement(S,ElementName):String, Returns XML Element ElementName="S" DecodeXMLElement(S,ElementName):String, Returns XML Element Value EncodeXMLAttribute(S,AttributeName):String, Returns XML Attribute DecodeXMLAttribute(S,AttributeName):String, Returns XML Attribute Value EncodeXMLString(S):String,Returns XML String DecodeXMLString(S):String,Returns XML Element Value Two new data transformation fuctions ReplaceSuffix ReplacePrefix 4.2.4.14 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 4.2.4.13 Added CopyFile function Various bug fixes 4.2.4.10 added post chages button added Optimize Column Width button fixed number of problems related to working data groupper added more demos to repository 4.2.4.8 Addressed sftp host key not verified problem fixed number of problems related to working with uniqueidentifierfileds in sql server 4.2.4.7 Fixed move bugs Addressed number of problems related to working with uniqueidentifierfileds in sql server Fixed bug loading zero length files 4.2.4.4 FTP Log is more compact now More useful error messages for copy and move file operations 4.2.4.3 Fixed some data sorting bugs 4.2.4.2 New Reader parameter: Source File Creation Date SFTP bug fixes Repository scripts update 4.2.4.1 Minor bug fixes 4.2.4.0 Support for Sql Server Compact Edition was introduced Various bug fixes 4.2.3.9 Support for Cross tab reports was introduced Report Export format was extended 4.2.3.6 Fixed Issues with SQLite imports Support for zip files > 4 gigs was introduced Some issues related to SMTP and POP3 connections were resolved Support for Charts, Bar codes and OLE objects was added to reports 4.2.3.5 Support for SFTP was introduced Export of empty tables was fixed Various problems related to working with very large files were resolved Copy and Move file operations can also rename multiple files Put into target directory: {ChangeFileExt('','.old')} C:\{ExtractFileName(ChangeFileExt('','.old'))} Calculation was not showing result correctly in preview mode 4.2.2.10 Copy project option was added Various bugs fixes 4.2.2.8 Various bugs fixes 4.2.2.5 Major update Calculations and scripting language changes Syntax is slightly different now 1 source fields are always 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 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 Problem with null dates was resolved 4.2.2.4 MD5 transformation function was added Scripting language was extended Various Excel related bug fixes Documentation update 4.2.2.3 Works correctly with mixed case objects in PostgreSQL Scripting language was extended Various bug fixes FTP bug fixes Documentation update 4.2.2.2 Data grid grouping access violations fixes Send email to support fixed 4.2.2.1 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 4.2.1.1 Supports multiple text line delimiters now 4.2.1.0 Works directly with SQLite now Various Interbase/Firebird related bug fixes Fixed bug with import of MS Access tables with spaces in names Minor Interface Changes Fixed FTP list command for WindowsNT Memory leaks were fixed "Fail when no files found" check box was added to FTP object 4.2.0.10 Various bug fixes 4.2.0.8 It is now possible to pass variables between packages and transformations Keep value transformation function Shows PK information for access target and ole db target Renaming transformations changes tab caption as well No more duplication in transformation and validator grids Copy, cut, paste from sql log Access violation when directory does not exist for a backup/export Table browser loads data much faster Sql browser loads data much faster Log screen loads much faster Various Access violation and bug fixes Documentation update 4.2.0.7 Various bugs fixes Was not saving update key Add column did not refresh data for excel and text data source and target Problem with excel sheets with spaces Delete characters did not show any characters to delete in title Wrong icon for grid grouping in table browser 4.2.0.3 Various Excel related bugs fixes 4.2.0.0 Data grids modifications: Grouping panel was added Advanced filter dialog was introduced Record number New look and feel 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 Can create excel files in Excel 3.0-2007 format Can insert data starting from specific cell Can clear area before adding data into Excel 4.1.0.12 Massive performance improvement for large data repositories Various access violations were fixed Problem with duplicated fields was resolved 4.1.0.11 Massive performance improvement for large data repositories Various access violations were fixed Problem with duplicated fields was resolved 4.1.0.10 Various interface improvements Popup menu was added to data grouper. New options for unpivot and pivot data transformation object Documentation update Various bug fixes 4.1.0.7 Some problems were addressed related to loading data into varchar(max), nvarchar(max), varbinary(max) 4.1.0.6 ETL Package Variables Package Script HTTP Download Object Documentation Update Unlimited Email Attachments System variables 4.1.0.5 Print reports directly to printer Several new report export formats - Excel, Rtf, Csv and Pdf 4.1.0.4 New button was added to data transformation log Show first 100 records 4.1.0.3 Various bug fixes 4.1.0.1 Support for SQL Server 2005/2008 was improved 4.1.0.0 Database to Email and Email to Database transformations Transform files into blob fields and Export of blob fields Detailed SMTP Log Detailed POP3 Log Detailed FTP Log Secure Email It is no longer required to use "SET sql_mode='ANSI'" for MySql Connection Ole db connections works with blobs now Ms Sql Server connection support: TEXT, NTEXT, VARBINARY(MAX), VARCHAR(MAX),XML, NVARCHAR(MAX), IMAGE ODBC Performance Improvements. ODBC Support for BLOBS was improved and tested with various databases Oracle connection support for BLOB,CLOB and NCLOB, LONG RAW data types. PostgresSQL connection works with bytea Interbase/Firebird support for blobs MySQL support for blobs Several MS Access bug fixes Redesign of reader and writer properties dialog boxes. Total number of Data transformation functions is now 49 Documentation Update 3.3.3.7 Secure email is now supported More detailed log for SMTP,POP3 and FTP objects Project Restore 3.3.3.6 7 new ETL Transformation functions were added In Place Replace Encode Xml Element Decode Xml Element Encode Xml Attribute Decode Xml Attribute Encode Xml String Decode Xml String Total number of Data transformation functions is now 48 Documentation Update + minor bug fixes 3.3.3.5 Support for FTPS and FTPES was introduced 3.3.3.4 New tab was added to data source properties dialog called "Data reading restrictions" Find Object dialog was introduced Minor bug fixes 3.3.3.2 Now you can use Advanced ETL Processor to generate SQL Insert Scripts from any table Support for text files footer and header was added New tab was added to data reader properties dialog called "Data reading restrictions" Documentation update 3.3.3.0 Support for Ole Db was Introduced (this part is still in beta stage) InList and Lookup ETL objects bugs were fixed 3.3.2.21 Minor Bug Fixes Documentation Update Support for Dynamic file names was extended Now you can use calculations in target file names {GetSystemVariable('SOURCE_FILE_NAME')+'.good'} {GetSystemVariable('SOURCE_FILE_NAME')+'.very_very_bad'} FTP Improvements 3.3.2.15 Some issues related to zip object and repository backup were resolved 3.3.2.9 Corrected couple of bugs related to reports execution 3.3.2.8 Two new package objects Show message and Ask question Additional option of Ftp object Passive Data Export object Various bugs fixes Filtering incoming email messages based on sender or subject. 3.3.2.4 Support for MySql, PostgreSQL and Interbase/Firebird Various Bug Fixes 3.3.2.0 Updated sequence transformation object Running totals Updated documentation Minor bug fixes 3.3.0.21 minor bug fixes 3.3.0.19 Minor bug fixes 3.3.0.18 Updated Documentation You can use for default values for example Bad date will expand into Bad date 014200 Minor bug fixes 3.3.0.17 FTP Move files option was added Move files has "Overwrite files" option now Minor bug fixes 3.3.0.16 Some spelling errors were corrected Directory Listing is tab delimited now Minor bug fixes 3.3.0.15 ODBC Connection String Builder was introduced 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 Additional Option to select OLE DB Provider for Oracle was introduced 3.3.0.14 Automatic Version check was introduced Various bug fixes