Advanced ETL Processor Standard - History Of Changes

13/09/2023 3.9.8.7

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

25/07/2023 3.9.8.5

+ Disabled: ODATA Connection as no longer necessary

16/05/2023 3.9.8.4

+ Improved: Updated documentation link

04/02/2022 3.9.8.3

+ Improved: Increased Data writer fields' dedifintions widths

02/02/2022 3.9.8.2

- Fixed: Field is not mapped issue

04/01/2022 3.9.8.1

+ Added: Support for SSH Connections to MySQL,Postgres and MongoDDB
+ Improved: Data writer error handling

09/12/2022 3.9.7.39

+ Added: Rest Writer

24/11/2022 3.9.7.38

- Fixed: Office 35 Email Writer AV

21/11/2022 3.9.7.37

- Fixed: UID was missing from Office 35 Email Reader

20/11/2022 3.9.7.36

+ Added: Office 35 Email Writer

10/11/2022 3.9.7.35

+ Added: Office 35 Email Reader

26/08/2022 3.9.7.34

- Renamed: "Split RegX" to Split RegX Static
+ Added: Split RegX Dynamic transformation function

12/07/2022 3.9.7.33

- Fixed: Issue with Replace RegX transformation function

28/06/2022 3.9.7.32

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

24/05/2022 - 3.9.7.31

- Fixed: AV when adding new field to Joiner properties dialogue

17/05/2022 - 3.9.7.30

- Fixed: Databuffer double procession bug

02/03/2022 - 3.9.7.29

+ Added: Ignore null option to Date format, Date part, Reformat date, Date diff, Local Date to UTC,UTC to Local Date,Date to Epoch transformation functions

15/02/2022 - 3.9.7.28

+ Added: Support for dynamic field names (delimited files only)
+ Added: Support for RabbitMQ to data writer and reader

03/02/2022 - 3.9.7.27

- Fixed: Is value In Database transformation function bug

13/01/2022 - 3.9.7.26

+ 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

17/12/2021 - 3.9.7.24

+ Improved: Note's custom colours are persisted across user sessions

15/12/2021 - 3.9.7.23

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

23/07/2021 - 3.9.7.22

+ Improved: XML Reading performance
+ Improved: Excel components update
- Fixed: Issues with long month names
+ Improved: Third party components update
- Fixed: Installation Issues

16/07/2021 - 3.9.7.21

- Fixed: Issues with closing ODBC connection when refreshing target fields list
- Fixed: Issues with reading windows event log

21/06/2021 - 3.9.7.19

- Fixed: Windows log message format

11/06/2021 - 3.9.7.18

+ Improved: Split RegX transformation function

02/06/2021 - 3.9.7.17

- Fixed: Issues with lookup error handling

10/04/2021 - 3.9.7.16

+ Improved: Various cosmetic changes
+ Improved: Changed table search from case sensitive to not case sensitive
+ Improved: Working with HTML tables
- Fixed: Undo/Redo issues while working with source/target grid
- Fixed: Could not find any File(s) to read error when refreshing target grid

03/04/2021 - 3.9.7.15

- Fixed: Access violations when reading excel files
- Fixed: Licensing issues when running the software on AWS servers.

21/03/2021 - 3.9.7.14

+ Improved: Tableau hyper error handling
+ Added: IP Location and URL Location transformation functions
+ Fixed: Minor mapping designer bug fixes and improvements

17/03/2021 - 3.9.7.13

+ Added: Extract Attachments option to IMAP4 and POP3 reader
+ Added: Email footer message
+ Added: Cache option to "Get Excel Cell Value Dynamic" transformation function
- Removed: IP Location, URL Location and Url Shortener transformation functions
- Removed: Transformation type toolbar from the mapping designer
- Fixed: Licence management issues

27/02/2021 - 3.9.7.12

+ Improved: It is now possible to use a single transformation to write data into multiple excel sheets of the same file

21/02/2021 - 3.9.7.11

+ Improved: transformation designer response time while working with very large files
+ Improved: removed excess data refreshes within transformation designer this resulted in overall screen performance improvement
+ Improved: underscore characters can be seen in preview mode now
+ Improved: Updated hyper api to the latest version
- Fixed: Various tableau related bugs

03/02/2021 - 3.9.7.10

+ Added: HTML Table reader
+ Added: Recalculate Excel File check box to excel writer
- Fixed: Field selector access violation
+ Improved: Field selector performance
+ Updated: Digital signature

22/12/2021 - 3.9.7.9

- Fixed: Loading data from FoxPro

19/12/2020 - 3.9.7.8

+ Added: GetSystemDate function returns the fractions of a second now
+ Added: IMAP4 writer can move messages to a different folder now
- Fixed: Licence management issues

01/12/2020 - 3.9.7.7

+ Added: To, ReplyTo, Cc and Bcc fields to POP3 and IMAP4 readers

3.9.7.6

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

3.9.7.5

+ Improved: Setup look and feel
- Fixed: Issues with special characters inside field names

3.9.7.3

- Fixed: Access violations while using Get Excel Cell Value Dynamic

3.9.7.2

+ Added: Support Excel formulas creation
+ Improved: Writer SMS connection

3.9.7.1

+ Added: Owner field to file system reader
+ Added: FileOwner scripting language function

3.9.7.0

+ Added: Support for reading Tableau Hyper files
+ Added: Support for creating Tableau Hyper tables
+ Added: Support for python version 3.8 and 3.9
+ Improved: Tableau hyper client update
- Fixed: Note object color bug

3.9.6.28

+ Added: Variables: ,,,,,,

3.9.6.26

+ Improved: Support for DATETIME2 Fields

3.9.6.25

- Fixed: Issues with Accumulate String transformation function
- Fixed: Issues with reading JSON objects

3.9.6.24

+ Improved: Support for DATETIME2 Fields

3.9.6.23

+ Improved: Software registration process
- Fixed: Issues with Australian Post Code validation

3.9.6.22

+ Improved: JSON Data Handling

3.9.6.21

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

3.9.6.20

+ Added: colors to notes
+ Added: "Complex JSON" check box to JSON datasource
- Fixed: issues with aborting joiner transformation on error

3.9.6.19

+ Added: Support for PostgreSql 12

3.9.6.18

+ Added: IMAP4 as data writer connection
- Fixed: IMAP4 reader shows UID correctly now
- Fixed: Fixed issue with loosing transformations while closing transformation tab

3.9.6.17

- Fixed: SplitRegX transformation function bug
- Fixed: Lookup transformation function bug
+ Added: Checks for source and target structure changes

3.9.6.16

+ Added: Select Objects with no links menu option
+ Added: Select Inputs menu option
+ Added: Select Outputs menu option
+ Added: Select Linked Objects menu option

3.9.6.15

+ Added: Ability to pull license from the license server
- Fixed: Last record flag issue for files with two lines

3.9.6.14

+ Added: Case sensitive option to Lookup transformation object

3.9.6.12

- Fixed: Issues with joining empty files

3.9.6.11

+ Improved: Third party components update:

Excel processing libraries

+ Improved: Various bug fixes and improvements
+ Improved: Salesforce connection uses TLS 1.2 now
- Fixed: Excel data reading problems

3.9.6.10

- Fixed: Decode JSON Object and Decode JSON Array error handling issues

3.9.6.9

+ Added: Syslog datasource

3.9.6.8

- Fixed: JSON Data reader AV

3.9.6.7

+ Improved: Software Installation Process
+ Improved: Third Party Components Update
- Fixed: Minor Python Integration Issues

3.9.6.6

Software registration changes:

Starting from this release users would need to enter license key and control number to register the software.

+ 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

3.9.6.5

+ Added: Support for calculations inside source reader source file
- Fixed: Copy/Paste issues with SQL Lookup transformation

3.9.6.4

+ Added: New datasource - Twitter
+ Improved: Loads data into SQL server up to 25 percent faster
+ Improved: Generating Tableau hyper files up to 25 percent faster
+ Improved: Generating Tableau tde files up to 30 percent faster
+ Improved: Active Directory Connection look and feel

3.9.6.3

+ Improved: Slight performance improvement

3.9.6.2

- Fixed: Log tab issues

3.9.6.1

+ Improved: JSON null values handling

3.9.6.0

+ Added: Loading data into Google Spreadsheets
+ Improved: Third party components update

3.9.5.15

- Fixed: Issues with loading data into Varchar(MAX) fields (SQL Server)
+ Improved: transformer fields metadata

3.9.5.14

+ Added: Added Get Excel Cell Value Dynamic transformation function
+ Improved: Object selection visibility

3.9.5.13

+ Improved: Third party components update

3.9.5.12

- Fixed: Addressed issues with loading data into XML,Image and Identity fields (SQL Server)

3.9.5.11

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

3.9.5.10

+ Improved: Made Calculation dialogue box resizable`
- Fixed: Issues with exporting data into csv and tab files from grids

3.9.5.9

+ Added: GetWindowsTemporaryDirectory,GetTemporaryFile,GetTemporaryFileInDirectory,GetTemporaryDirectory transformation language functions
+ Added: Get File Content Dynamic transformation function
+ Improved: Third party components update
+ Improved: Pivot and unpivot performance

3.9.5.8

- Fixed: Loading Data Into Time Fields

3.9.5.7

+ Added: Data Buffer Transformation Function
+ Improved: Transformation Error Handling

3.9.5.5

+ Improved: Google Spreadsheet import
+ Improved: SQL Lookup transformation dialogue
- Fixed: Salesforce Bulk API load issues
- Fixed: SQL Lookup transformation issues

3.9.5.3

- Fixed: Round Transformation Function issues
- Fixed: Issues with exporting very large grids into excel files

3.9.5.2

- Fixed: Python Scripting issues

3.9.5.1

- Fixed: Salesforce Bulk API load issues

3.9.5.0

+ Added: Support fot Hyper Tableau files (64 bit version)
+ Improved: Third party components update

3.9.4.3

- Fixed : Loading data into Google spreadsheet
+ Added: Ansi Driver checkbox to odbc connections

3.9.4.2

+ Added: Support For MongoDB

3.9.4.1

+ Improved: Look and feel of Pivot object on win2008 server
+ Improved: Look and feel of UnPivot object on win2008 server
+ Improved: Third party components update (Data Grid)
+ Improved: Empty Data Grids show message
+ Improved: Execution log within Package editor looks the same way as execution log (Tree)

3.9.4.0

+ Improved: Third party components update (Excel)
+ Improved: Changed logic fro processing excel files: if software is unable to open file transformation aborted
+ Added: Check file to Excel Operation Action

3.9.3.29

- Fixed : Issues with JSON transformations

3.9.3.27

- Fixed : Issues with reading JSON data

3.9.3.26

- Fixed : Fixed AV's

3.9.3.25

- Fixed : Issues with reading brightpearl data

3.9.3.24

- Fixed : Issues with assigning default values to lookup

3.9.3.23

+ Improved: Functionality of Running totals transformation function

3.9.3.22

+ Improved: Open SSL libraries update
+ Improved: Up to 30 percent faster

3.9.3.21

+ Added : Support for SFTP Private Keys
- Fixed : Issues with QVX Files reading

3.9.3.20

+ Added :Paste functionality to target definitions (writer fields grid)
- Fixed : Issues with loading version info

3.9.3.19

- Fixed : Tableau Datetime fields processing issues

3.9.3.18

- Fixed : Fixed QVD reading issues

3.9.3.17

+ Improved: Setup has an option to download Tableau client now
+ Added : SQL Lookup Transformation Function
- Fixed : Scrolling issues
- Fixed : Change date dynamic bug

3.9.3.15

+ Improved: Setup procedure

3.9.3.14

- Fixed : Issues with loading version info

3.9.3.13

+ Improved: Maximum ODBC Connection String is 4K now
- Fixed : One Row QVD creation bug

3.9.3.12

+ Improved: Look and feel of object joins

3.9.3.9

+ Improved: Updated Salesforce API to v38

3.9.3.8

+ Improved: Query Builder components update
+ Improved: SSL components update

3.9.3.7

+ Added : FTP Files list as datasource
- Fixed : Issues with updating data via table browser

3.9.3.6

+ 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

3.9.3.5

- Fixed : Issues with reading data from SalesForce
+ Added : Table generation option to writer grid

3.9.3.3

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

3.9.3.2

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

3.9.3.1

+ Improved: Support for JSON as data source

3.9.3.0

+ Added: Support for JSON as data source and target
+ Improved : Lookup transformation supports JSON as datas source now

3.9.2.9

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

3.9.2.8

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

3.9.2.7

- Fixed : Problems with clone row transformation object

3.9.2.6

- Fixed : Problems with reading data from Salesforce

3.9.2.5

- Fixed : Problems with refreshing list of Oracle Tables

3.9.2.4

- Fixed : Problems with AM/PM Date conversion

3.9.2.3

+ Improved : JDBC Processing

3.9.2.2

+ Improved : JDBC Errors Handling

3.9.2.1

- Fixed : Problems with reading data from unicode files

3.9.2.0

+ 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
+ New : Support SSL v2, v3, v1_1 and v1_2 was introduced
+ 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

3.9.1.4

- Address issues with Change Date Static,Change Date Dynamic and If WeekDay functions
- Addressed Salesforce data update issues

3.9.1.3

- Addressed Salesforce data update issues

3.9.1.2

+ Improved support for RSS feeds

3.9.1.0

+ Calculation transformation function support Python now

3.9.0.15

- Addressed issues with Running Total transformation

3.9.0.14

+ Support for latest tableau api was introduced
- Log Object bugs fixes

3.9.0.13

+ Added Write to File transformation function

3.9.0.12

+ Minor transformation designer improvements

3.9.0.11

- Date fields processing bugs fixes

3.9.0.10

- Joiner Object bugs fixes

3.9.0.8

- SalesForce data processing fixes

3.9.0.7

- Addressed DTD is prohibited issues

3.9.0.6

+ Added End of line customisation for text data target

3.9.0.5

+ Improved support for very large QVD files

3.9.0.4

- Addressed Date validation and conversion problems

3.9.0.3

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

3.9.0.1

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

3.9.0.0

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

3.8.2.12

- Addressed issues with getting stored procedures parameters

3.8.2.11

+ 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
- 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

3.8.2.10

+ Addressed issues with creating Excel files

3.8.2.8

+ 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

3.8.2.7

+ Faster QVD files processing
- Addressed issues with reading very large QVD files
- Addressed issues with creating QVD files

3.8.2.6

+ Third party components update
+ Reduced memory usage for QVD files processing
- Addressed issues with clone row object

3.8.2.5

+ Better support for QVD's Timestamp and Date fields
- Addressed issues with union and sorter objects

3.8.2.4

- Addressed issues with subtransformation function

3.8.2.3

+ Added Ignore Data Format option to Excel Data reader
- Addressed issues with split function

3.8.2.2

+ Added Lookup Replace Transformation function
- Addressed issues with Running Totals functions
- Addressed issues with joining empty files

3.8.2.0

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

3.8.1.11

- Addressed issues with loading empty date fields into MySQL
- Addressed issues with Split Transformation Function

3.8.1.9

+ Smaller Executable
+ Updated regular exression Engine
+ Added Replace RegX and Split RegX transformation functions

3.8.1.7

+ Added Field Value transformation function

3.8.1.5

+ Added Read File Content Option to Reader
+ Added UTC To Local Date and Local Date to UTC script functions
+ Added UTC To Local Date and Local Date to UTC transformation functions
- Addressed issues with File Creation Dates

3.8.1.3

+ Added Save button to Transformer and Validator
+ Added FileLine transformation function
- Addressed issues with Slemma Import

3.8.1.2

+ Added support for Clarion dat files

3.8.1.1

- Addressed issues with sorter

3.8.1.0

+ Added support for Slemma
+ All documentation is in wiki format now

3.8.0.40

+ Excel Import and export from data grids is much faster now
+ Added Encode JSON Object and Decode JSON Object transformation functions
+ Added Encode JSON Array and Decode JSON Array transformation functions
+ Added Encode JSON Pair and Decode JSON Pair transformation functions
+ Added Encode JSON String and Decode JSON String
- Addressed issues with exporting data as excel from data grids
- Addressed issues with deduplicator
- Addressed issues with deleting records

3.8.0.39

+ Added trim option to format field names dialogue
+ Updated set fields' names functionality

3.8.0.38

+ Extended Date Diff functionality

3.8.0.37

+ Google spreadsheet API update
+ Support for Salesforce Bulk API was introduced
+ Added MONTH_EXACT to DateDiffS function

3.8.0.35

- IMAP4 and POP3 fixes
- Various bugs fixes and improvements

3.8.0.34

+ Support for salesforce BULK API was introduced

3.8.0.33

- Addressed issues with loading null values into salesforce

3.8.0.32

- Addressed issues with loading data from SQL Server CE

3.8.0.31

- Addressed issues with loading data from delimited files

3.8.0.30

- Addressed issues with groupper transformation
- Various bugs fixes and improvements

3.8.0.29

+ Documentation update
+ Added GetExcelCellValue calculation function
+ Sorter improvements

3.8.0.27

+ Improved performance of Join Transformation.
- Addressed issues with memory management

3.8.0.26

- Addressed issues with Is Number validation function

3.8.0.25

+ Added ability to swap reader and writer
+ Added support for 255 length fields names in Union All object

3.8.0.24

+ GetExcelCellValue function provides more detailed information about errors now
- Addressed issues with retrieving information about Primary keys
- Addressed issues with parallel sorting

3.8.0.22

+ Added ability to delete and insert items in the middle of Split, Join and calculation object

3.8.0.21

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

3.8.0.18

+ Up to 6 times faster data deduplication
+ Up to 2 times faster data groupping
+ Groupper is using less memory
+ 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
- Various bugs fixes and improvements

3.8.0.17

+ 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 QVX files creation
+ Up to 10 percent faster loading data into PostgreSQL
- Various bugs fixes and improvements

3.8.0.16

+ Up to 9 times faster QVD files creation
+ Up to 3 times faster reading data from QVD files
+ Up to 2 times faster data sorting
+ Up to 15 percent faster QVX files creation
+ Added thousands separator to transformation objects
- Various bugs fixes and improvements

3.8.0.14

- Addressed problems with reading googlespreasheet data
- Addressed Transformer AV's

3.8.0.13

+ Up to 30 percent faster text file processing
+ Up to 10 percent faster QVD generation
+ Up to 10 percent faster QVX generation
+ Up to 5 percent faster Excel Files generation
+ Up to 20 percent faster XML generation
- Addressed issues with Joiner object
- Various bug fixes and improvements

3.8.0.12

+ Up to 10 percent faster text file processing
- Addressed issues with processing end of line characters inside delimited files

3.8.0.11

+ Up to 7 times faster data sorting
- Addressed issues with salesforce data processing
- Fixed problems with data preview
- Various bug fixes and improvements

3.8.0.10

- Addressed issues with creating rejected records file

3.8.0.9

- Addressed issues with running ODBC Manager from application

3.8.0.7

+ SSL libraries update
- Various bug fixes and improvements

3.8.0.6

Massive performance increase

+ Working with text files - is more than 2 times faster
+ Creating QVD files - up to 30 percent faster
+ Creating QVX files - up to 30 percent faster
+ Creating Excel files - up to 20 percent faster
+ Loading data into SQL server - up to 10 percent faster
+ Loading data into Oracle - up to 10 percent faster
+ Loading data into PostgreSQL - up to 10 percent faster
+ Various bug fixes and improvements

3.8.0.4

+ Support for MS SQL server 2014 was extended

3.8.0.3

- Addressed issues with sequence transformation object
- Addressed issues with subtransformation object
- Addressed issues with sending SMS messages

3.8.0.2

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

3.8.0.1

- Addressed issues with metadata object
+ Added Vertical Grid
+ Third party components update

3.8.0.0

+ Support for multiple readers
+ Joiner Renamed to Join
+ Splitter Renamed to Split
+ Joiner Object was introduced
+ Skip empty fields option was introduced to Join object
+ Incremental object search was added to package designer
+ Minor interface improvements
+ Writer and Reader description are mandatory now
+ New option to Include reader name into Rejected records file
+ Documentation update
- Addressed issue with sending SMS messages

3.7.9.8

- Addressed issues with GetExcelCelValue transformation function

3.7.9.7

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

3.7.9.6

+ Added Reset height option

3.7.9.5

+ Up to 10 percent faster
+ License Update
+ Documentation Update

3.7.9.4

- Addressed issues with XML encoding

3.7.9.3

- Addressed some validator issues

3.7.9.2

+ 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
- Minor bugs fixes
- Spelling corrections

3.7.9.0

+ Added support for tableau tde files

3.7.8.17

+ Added option to generate table creation script to the transformer source grid
+ Log redirect object improvements
+ Various bugs fixes

3.7.8.16

+ Setup Update
- Addressed Splitter dialogue issues

3.7.8.15

+ Added new transformation field values
+ Documentation Update

3.7.8.14

+ Added two new fields to File Sytem datasource last modification date and last access date
+ Documentation Update

3.7.8.13

+ Minor interface improvements

3.7.8.12

+ Added Is Null or Empty string validation function
+ Added If Null or Empty string transformation function
+ Documentation Update
- Mapping editor bug fixes

3.7.8.10

- Addressed CASE transformation issues

3.7.8.7

- MySQL bugs fixes
- Bug fixes

3.7.8.6

+ Added Support for Message Queuing (MSMQ)
+ Documentation Update
+ Better Data Reader Memory Management

3.7.8.5

- Addressed issues with BIGINT fields

3.7.8.3

- Addressed issues with Get Excel Cell Value transformation function
- Addressed issues with copy paste functionality

3.7.8.2

+ Further improvements to Sending SMS functionality
- Date Format bugs fixes
- Addressed problem with keep characters functions

3.7.8.0

+ Support for Sending SMS messages was introduced
+ Documentation Update

3.7.7.13

+ Added URL shortener transformation function
+ Added URL Location transformation function
+ Added IP Location transformation function
+ Added Accumulate Strings transformation function
+ Extended Metadata transformation function functionality
+ Documentation Update

3.7.7.11

+ Interface improvements
- Addressed issues with CASE transformation function

3.7.7.10

+ Added CASE transformation function
+ Added Delete Leading Characters
+ Added Delete Trailing Characters
+ Added support for special characters
+ Interface improvements
+ Documentation Update

3.7.7.9

+ Ability to move objects between different tabs was introduced
- Subtransformation bugs fixes

3.7.7.8

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

3.7.7.7

+ Excel processing engine update

3.7.7.6

+ Extended functionality of Get Excel Cell Value and Get File Context functions
- Addressed issues with Undo Redo buttons
- Addressed excel' files locking problems

3.7.7.4

+ Added two new transformation functions Get Excel Cell Value and Get File Context
+ Documentation Update

3.7.7.3

+ Support for latest version of Google spreadsheets was introduced
- Minor XML processing fixes

3.7.7.2

+ Up to 50 percent faster working with QVD files

3.7.7.0

+ Renamed Web Service Lookup to HTTP Post
+ Added HTTP Get Transformation function
+ Documentation Update

3.7.6.12

- Web Service Lookup issues were addressed

3.7.6.11

+ up to 10 times faster data sorting

3.7.6.10

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

3.7.6.8

- XML and ODBC fixes

3.7.6.7

- Addressed file update problems

3.7.6.6

+ Up to 5 percent performance increase
- MySQL date processing bugs fixes

3.7.6.4

- MySQL date processing bugs fixes

3.7.6.2

- Addressed union object issues

3.7.6.1

- Addressed some subtransformation issues

3.7.5.26

- Fixed Copy/Paste problems with Sub Transformation object

3.7.5.25

- Addressed issues of loading data from Excel files

3.7.5.24

+ Added option to set defaults
+ Added option to filter target fields
- Addressed some sqlite issues

3.7.5.21

- Addressed issues with day of the week checking
- Addressed issues with loading data into MySQL

3.7.5.20

+ Updated regular expression for US SSN

3.7.5.19

- Addressed issues of loading data from flat files

3.7.5.18

+ Minor interface fixes
+ Autoformat fixes (Some mappings may need to be updated)
+ When new output field is added field id is assigned automatically
+ Documentation update

3.7.5.17

- Addressed issues with loading empty Date fields into MS SQL server

3.7.5.16

+ Support fro Zoom in/Out was introduced
+ Target Data tab was introduced to the transformation editor
- Corrected issues with processing emails send by IPAD
- Addressed issues of loading data from flat files

3.7.5.15

- Addressed issues of loading data from flat files

3.7.5.14

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

3.7.5.12

+ Better objects positioning while working with multiple tabs
+ Emails are send as HTML now
- Addressed issues with updating data

3.7.5.11

+ Better handling of large Salesforce tables
+ Support for multiple Salesforce environments was introduced

3.7.5.8

- Deduplicator AV fix
- QVD reading bug fixes

3.7.5.6

+ Better handling of empty Salesforce tables
+ More detailed information about Salesforce fields by data reader
+ Support for GreenPlum was introduced

3.7.5.5

+ Added tabs to transformation editor
+ 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

3.7.5.3

+ Added search functionality to transformation editor
- Addressed some issues of working with default values
- Salesforce bug's fixes

3.7.5.1

+ Better source connection errors handling

3.7.5.0

+ Salesforce is supported as datatarget
- Addressed more autoformat problems

3.7.4.9

- Salesforce bug's fixes
- Addressed autoformat problems

3.7.4.8

- Addressed issues with Salesforce processing

3.7.4.7

- Addressed issues with HL7 processing
- Addressed issues with loading data from Salesforce
- Addressed issues with loading data into NTEXT fields
- Addressed issues with loading data into MySQL
- Addressed issues with locking PostgreSQL tables

3.7.4.5

+ Salesforce 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

3.7.4.4

- Addressed problems with excel date formatting

3.7.4.3

+ New datasource HTTP
+ Documentation update
- Addressed issues with salesforce connection
- Addressed problems with fixed width files

3.7.4.2

- Addressed problems with formating dates

3.7.4.1

- Addressed problems with autoformat option

3.7.3.12

+ 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

3.7.3.6

+ Up to 20 percent performance increase

3.7.3.3

+ Up to 70 percent performance increase

3.7.3.2

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

3.7.3.1

+ Up to 50 percent increase for loading data via OleDB
+ Up to 40 percent increase when using stored procedures for loading the data
+ Further 10 percent performance increase for loading data from text files

3.7.3.0

Massive performance boost

+ Text to INTERBASE TABLE up to 25.50%
+ Text to MS SQL TABLE via BCP up to 32.64%
+ Text to MS SQL TABLE via OLE DB 2000 CLIENT up to 50.00%
+ Text to MS SQL TABLE via OLE DB 2005 CLIENT up to 50.00%
+ Text to MS SQL TABLE via OLE DB 2008 CLIENT up to 50.00%
+ Text to MS SQL TABLE via OLE DB 2012 CLIENT up to 50.00%
+ Text to MY SQL TABLE up to 20.61%
+ Text to ORACLE TABLE via Conventional Path Loading up to 24.40%
+ Text to ORACLE TABLE via Direct Path Loading up to 30.45%
+ Text to ORACLE TABLE via OLE DB up to 19.52%
+ Text to ORACLE TABLE via OLE DB using ODBC up to 30.00%
+ Text to POSTGRESQL TABLE up to 29.15%

+ Better handling of Target Schema Changes

+ Notes have pop up menu now

- SQL Statements: Leading comments -- or /**/ cause SQL to error - corrected
- Transforms Field List: Ctrl-X, C, V, Do not work (but right click does) - corrected
- Transforms File Names: Ctrl-X, C, V, Do not work (but right click does) - corrected
- Transforms Data List: Can not Ctrl-C or Right Click Copy - corrected
- Log Viewer: Can not Ctrl-C or Right Click Copy - corrected

3.7.2.1

- Addressed some lookup issues

3.7.2.0

Massive performance boost:

+ text to text up to 100 percent
+ odbc to text up to 20 percent
+ 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
+ QVD to text up to 100 percent

+ Save changes warnings were added to transformer and validator
+ Copy functionality was added to source and target definitions
- Bug with deleting writers was fixed
- Pivot bugs were fixed
- Undo/Redo bugs were fixes

3.7.1.5

+ Functionality of Splitter and Get Line functions was improoved
+ Documentation update
- Various bug fixes and interface improvements

3.7.1.4

+ QVD generation bugs fixes

3.7.1.3

+ "Is Value in Database" and "If Value in Database" were added
+ Documentation update

3.7.1.2

+ Support for the web services was introduced (SOAP)
- Various bug fixes and interface improvements

3.7.1.1

+ Data reader timeout was introduced for ODBC,Access,MS Sql Server, OleDB, PostgreSQl, MySQl and MS Sql Server CE connections
- Various bug fixes and interface improvements

3.7.1.0

+ Smaller executable
+ Memory usage was reduced for Excel files
- Adressed some HL7 issues
- Various bug fixes and interface improvements

3.7.0.10

+ Format field name dialogue improvements
+ Datareader minor improvements

3.7.0.9

- Addressed problems with "If in List" Function

3.7.0.7

+ Addressed problems with updating Oracle blob fields

3.7.0.6

+ Addressed some groupper issues

3.7.0.5

+ Undo/Redo Functionality was improoved
+ Documentation update

3.7.0.3

+ IF Functions were introduced
+ Total number of functions now 500+
+ Comments were added to Literal function
+ Various bug fixes and interface improvements
+ Documentation update
- Addressed some regular expressions bugs

3.6.3.8

+ Added parameter names to calculation object

3.6.3.7

+ Added Undo an Redo functionality
- Various bug fixes

3.6.3.6

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

3.6.3.5

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

3.6.3.3

+ Added align left, align top, align right, and align bottom buttons
+ Dedupicator, Lookup and InLinst functions are up to 20 percent faster
+ Ability to link output fields was introduced
+ Hints were added to Lookup object
+ Better object selection for mapings
+ Various bug fixes and interface improvements
+ Support for HL7 messaging was introduced

3.6.2.11

- Various bug fixes

3.6.2.9

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

3.6.2.6

+ Improved support for MS SQL Server 2012
+ Improved support for BDE
+ Executable is smaller now
+ Support for Excel 2013 was itroduced
+ Logging improvements for Connection type, connection name and connection details
- Various bug fixes

3.6.2.2

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

3.6.1.3

- Various bug fixes

3.6.1.0

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

3.6.0.0

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

3.5.1.7

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

3.5.1.1

- Various bug fixes

3.5.1.0

+ Added new object Log which can be used to analyse data quality issues
+ Reader Parameter Object was renamed to Metadata object
+ Ability to extract package name, os user name, computer name, transformation name and Application name was introduced
+ Documentation Update
- Various bug fixes

3.5.0.0

+ Support for QVD files was introduced
- Various bug fixes

3.4.4.3

- Various bug fixes

3.4.4.0

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

3.4.3.8

+ Documentation Update
- Various bug fixes

3.4.3.4

+ Support for IMAP4 was introduced
- Various bug fixes
- Corrected some problems related to dynamic file names

3.4.3.1

+ Support for Excel named ranges was introduced

3.4.3.0

+ Support for JDBC was introduced
- Various bug fixes

3.4.2.7

+ Support for adding data to existing excel files was introduced
+ Support for SalesForce was introduced
- Various bug fixes

3.4.2.3

- Various bug fixes

3.4.2.2

+ Support for excel formating was introduced

3.4.2.1

+ Uses 10 times less memory for large excel files
+ Documentation update

3.4.1.2

- Addressed some QVX creation issues
- Windows Event log improvments

3.4.1.0

+ Support for loading data from RSS, Google spread sheets and windows event logs was introduced
+ Dynamic Excel sheet names
+ 10+ performance increase while working with Excel files
- Various bug fixes

3.4.0.3

+ New arithmetical functions were added Add,Subtract,Divide,Multiply,Max and Min

3.4.0.0

+ Union ALL transformation object was created
+ Documentation update
- Various bug fixes

3.3.2.0

+ Support for Dynamic SQL for ETL transformations was introduced

3.3.1.3

+ 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