3.3.0.11 + 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 3.3.0.9 + Added support for using variables in file header/footer and SQL before and SQL after - Addressed problem with arranging objects 3.3.0.7 + After and Before transformation functions + CRC16,CRC24,CRC32,Adler32,CRC64,eDonkey,eMule,MD4,MD5,RIPEMD160,SHA1,SHA224,SHA256,SHA384,SHA512,Whirlpool checksums + Documentation update - Various AV fixes 3.3.0.5 + Documentation update - Various AV fixes 3.3.0.4 + Documentation update + Import and Export functionality were added to Pivot and Unpivot objects - Reader fixes - Sorter bug fixes - Various AV fixes 3.3.0.2 - Various AV fixes + Documentation update 3.3.0.1 + Added incremental search for expressions editor + Added filesize transformation function + Added filesize option to Reader parameter transformation function 3.3.0.0 + On win64 can now access 3gb of memory + Support for themes + Documentation update - Text writer unicode fixes - Various bug fixes 3.2.7.2 - "Program" file was created on drive c - XML XSLT tranformation fix - Some auto format issues were addressed - Minor interface tweaks 3.2.7.0 + Null function + Interface Improvements + Standard print preview + Support for scrolling in transformation editor - Boolean fix for MySql - Better error handling for ADO and MS Sql scripts - Command line parameter transformation function save problems 3.2.6.9 + 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 3.2.6.7 - Various bug fixes 3.2.6.6 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 3.2.6.5 Quote all menu item was added Format field names dialog box was introduced Various bug fixes 3.2.6.4 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 3.2.6.3 Added Support for XSLT transformations Added Get Variable, XML XSLT transformation, Validate XML function Interface Update Various bug fixes 3.2.5.11 Documentation Update Support for dynamic file names was improved 3.2.5.10 Added File name and Directory name extraction transformation functions Data splitter modifications Various bug fixes 3.2.5.9 Added Fields Selector transformation function Various bug fixes 3.2.5.8 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 3.2.5.5 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 3.2.5.3 Range lookup transformation function was introduced When data is exported into excel file numeric values are stored as numbers Various bug fixes 3.2.5.2 Added "Search in subdirectories" option to data reader 3.2.5.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 3.2.4.2 Incremental Transformation function search was introduced 3.2.4.1 Lookup Improvements and Fixes Data preview improvements Clear log shows dialog box first Transformer and Validator have names now Added Save, Save As, Open and New items to menu Direct Latest Version downloads from application Various Bug Fixes 3.2.3.14 Now user can double click on *.ats file to open it 3.2.3.12 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 String Value Two new data transformation fuctions ReplaceSuffix ReplacePrefix 3.2.3.11 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 3.2.3.10 Various bug fixes 3.2.3.7 Added post chages button to table browser Added Optimize Column Width button Fixed number of problems related to working data groupper 3.2.3.6 Fixed number of problems related to working with InList and Lookup functions 3.2.3.5 Fixed number of problems related to working with uniqueidentifierfileds in sql server 3.2.3.4 Addressed number of problems related to working with uniqueidentifierfileds in sql server Fixed bug loading zero length files 3.2.3.2 Fixed some data sorting bugs 3.2.3.1 New Reader parameter: Source File Creation Date Various bug fixes 3.2.3.0 Šupport for Sql Server Compact Edition was introduced Various bug fixes 3.2.2.16 Fixed some Issues with SQLite 3.2.2.15 Calculation was not showing result correctly in preview mode 3.2.2.13 Corrected problem with duplicated source fields 3.2.2.11 Various bugs fixes 3.2.2.5 Major 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 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 Problem with null dates was resolved 3.2.2.4 MD5 transfornation function was added Scripting language was extended Various Excel related bug fixes Documentation update 3.2.2.3 Works correctly with mixed case objects in PostgreSQL Scripting language was extended Various bug fixes Documentation update 3.2.2.2 Data grid grouping access violations fixes Send email to support fixed 3.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 3.2.1.1 Supports multiple text line delimiters now 3.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 Memory leaks were fixed 3.2.0.10 Various bug fixes 3.2.0.8 It is possible now to pass variables between transformations Keep value transformation function Shows PK information for access target and ole db target No more duplication in transformation and validator grids Copy,cut,paste from sql log Table browser loads data much faster Various Access violation and bug fixes Documentation update 3.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 3.2.0.3 Various Excel related bugs fixes 3.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 3.1.0.9 Various interface improvements Various access violations were fixed Problem with duplicated fields was resolved 3.1.0.8 Various access violations were fixed Problem with duplicated fields was resolved 3.1.0.7 Various interface improvements Popup menu was added to data grouper. New options for unpivot and pivot data transformation object Documentation update Various bug fixes 3.1.0.5 Some problems were addressed related to loading data into varchar(max),nvarchar(max),varbinary(max) 3.1.0.3 Various bug fixes 3.1.0.1 Support for SQL Server 2005/2008 was improved 3.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. Command line bug fixes Total number of Data transformation functions is now 49 Documentation Update+minor bug fixes 2.4.3.4 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 2.4.3.3 Various bug fixes Documentation Update 2.4.3.2 Now you can use Advanced ETL Processor to generate SQL Insert Scripts from any table 2.4.3.1 Support for Ole Db was Introduced InList and Lookup ETL objects bugs were fixed Support for text files footer and header was added New tab was added to data reader properties dialog called "Data reading restrictions" Documentation update 2.4.2.11 Minor Bug Fixes Documentation Update Support for Dynamic file names was introduced Now you can use calculations in file names {GetSystemVariable('SOURCE_FILE_NAME')+'.good'} {GetSystemVariable('SOURCE_FILE_NAME')+'.very_very_bad'} 2.4.2.6 Support for MySql, PostgreSQL and Interbase/Firebird Updated sequence transformation object Running totals Updated documentation Minor bug fixes 2.4.0.15 Minor bug fixes 2.4.0.13 you can use for default vaues for example Bad date will expand into Bad date 014200 Minor bug fixes 2.4.0.12 Some spelling errors were corrected Minor bug fixes 2.4.0.11 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 2.4.0.10 Automatic Version check was introduced Various bug fixesonStop ODBC/MX 2.0 ver 3.51.20.126 ODBC Driver Various Cosmetic Changes and Bug Fixes 2.4.0.10 Automatic Version check was introduced Various bug fixes