Advanced ETL Processor Enterprise - History Of Changes

29/11/2023 6.4.1.6

+ Added: Write Variables option to all Package Actions
+ Updated: Documentation
- Fixed: Package Action dialogue bug
- Fixed: Minour interface issues

28/11/2023 6.4.1.5

+ Added: Keep sheet and List sheets option to Excel Package action

27/11/2023 6.4.1.4

+ Improved: Block transformation combine step interface
+ Improved: Lookup transformations error handling
+ Improved: HTTP Post Package action functinality

26/11/2023 6.4.1.3

- Fixed: Minour Object Tree Bug

20/11/2023 6.4.1.2

- Fixed: Bug with detaching tabs

16/11/2023 6.4.1.1

+ Added: Support for python versions 3.10, 3.11 and 3.12
+ Improved: Block transformation error hadnling of missing source files

14/11/2023 6.4.1.0

+ Added: Pivot block transformation
+ Added: UnPivot block transformation
+ Added: Copy/Paste to block transformations
+ Added: MoveUp/MoveDown butttons to some block transformations
+ Improved: wiki documetation

12/11/2023 6.4.0.3

- Fixed: Rotate transformation bug

09/11/2023 6.4.0.2

- Fixed: Block transformation AV
- Fixed: Block transformation double writing of Excel files

07/11/2023 6.4.0.1

+ Improved: Block transformation progress bar position

06/11/2023 6.4.0.0 Major Release

+ Added: Block transformation
+ Added: Block transformation package action
+ Added: Added Enabled/Disabled flag to objects tree
+ Added: Added 4 new examples
+ Improved: Office 365 email reader no longer fails when no emails are found
+ Improved: Package editor popup menu
+ Improved: Setup procedure
+ Updated: Third-party Excel libraries

Repository upgrate scripts are located there

https://www.etl-tools.com/repository-database-updates/

01/11/2023 6.3.12.17

+ Added: Ignore nulls and keep original values option to Excel Writer

25/10/2023 6.3.12.16

+ Improved: Calculation engine update

16/10/2023 6.3.12.15

+ Improved: Openning objects from find string dialogue

16/10/2023 6.3.12.14

+ Added: "Abort when no data found" checkbox to Export Package Action

09/10/2023 6.3.12.13

+ Improved: Openning objects from Schedule tab
+ Improved: Openning objects from search dialogue

08/10/2023 6.3.12.12

+ Improved: Components update: SSL, SSH, SFTP, MySQL, Postgre, SQLite, Interbase/Firebird

04/10/2023 6.3.12.11

+ Improved: Renamed HTTP Form package action to HTTP Post
+ Improved: Renamed HTTP Download package action to HTTP Get
+ Added: 0090 Convert PDF to Excel example

30/09/2023 6.3.12.10

+ Added: , , , variables to File metadata package action

26/09/2023 6.3.12.9

+ Added: 0089 Convert all XML files in a directory example
- Fixed: MS Access Repository structure

25/09/2023 6.3.12.8

+ Added: Incremental search to Expression editor dialogue

13/09/2023 6.3.12.7

- Fixed: Issues with inserting default values within the data grid. (MySQL, Postgress, Interbase/Firebird and SQLite)
+ Improved: Added timeout hint to schedule dialogue

31/08/2023 6.3.12.5

+ Improved: Logging fro send email package action

08/08/2023 6.3.12.4

+ Improved: Copy and clone functionality

04/08/2023 6.3.12.3

+ Improved: SFTP working with private keys

25/07/2023 6.3.12.2

- Disabled: ODATA Connection as no longer necessary
+ Improved: Ofiice365 Email monitor check for new emails only

12/07/2023 6.3.12.1

+ Added: Dynamic pivot example

03/07/2023 6.3.12.0

+ Added: User defined fields to properties dialogs

22/06/2023 6.3.11.28

+ Added: Ability to detach tabs
+ Added: Added XML/XSLT editor to XSLT Transformation package action
+ Improved: Object Library Grid
+ Improved: Adding Objects from Library
+ Improved: Seach dailogue is sorted by type and description by default
- Fixed: Invalid Variant Type bug in Object Library Grid

14/06/2023 6.3.11.27

- Fixed: File is locked bug

13/06/2023 6.3.11.26

+ Added: Ability to save packages and transformations as bmp files
+ Added: Office 365 connection cache

07/06/2023 6.3.11.25

- Fixed: Office 365 email memory leak

05/06/2023 6.3.11.24

+ Added: User Input Package Action

02/06/2023 6.3.11.23

+ Added: Default Application Platform to options dialogue
+ Improved: Increased maximum number of Office 365 email folders to 250

26/05/2023 6.3.11.22

+ Improved: Repository Synchronization Wizard error handling
+ Improved: Variables Logging handling
+ Improved: aetlcl.exe error handling

22/05/2023 6.3.11.20

+ Improved: Excel operation action
+ Added: Added ability to merge two Excel files without losing formatting
+ Added: Added ability to set Excel file active sheet
+ Improved: The total number of demos is 87 now

16/05/2023 6.3.11.19

+ Added: How to embed picture into email demo
- Fixed: Removed insert image button from Send email action dialogue
+ Improved: Updated documentation link

10/05/2023 6.3.11.18

+ Improved: The total number of demos is 84 now
+ Improved: Error handling of HTTP download package action
+ Improved: Error handling of SOAP package action
+ Improved: Installation process

10/04/2023 6.3.11.17

+ Improved: Excel Operation Action working with mask

31/03/2023 6.3.11.16

+ Improved: Ping package action error handling and logging

30/03/2023 6.3.11.15

+ Improved: Reduced SQL server connection timeout to 20 seconds for check connection package action
+ Added: Timeout to Ping package action

16/03/2023 6.3.11.14

- Fixed: Issues with showing lookup data

12/03/2023 6.3.11.13

- Fixed: Issues with package execution default result

04/02/2023 6.3.11.12

+ Improved: Increased Data writer fields' dedifintions widths

02/02/2023 6.3.11.11

- Fixed: Field is not mapped issue

15/01/2023 6.3.11.10

+ Added: Write Variables Check Box to options dialogue

04/01/2023 6.3.11.9

+ Added: Support for SSH Connections to MySQL,Postgres and MongoDDB
+ Added: Start at option to Execute external application package action
+ Improved: Data writer working with variables
+ Improved: Data writer error handling

09/12/2022 6.3.11.7

+ Added: Rest Writer

27/11/2022 6.3.11.6

- Fixed: ExecuteObject Failure - Index Out of Bounds

24/11/2022 6.3.11.5

- Fixed: Office 35 Email Writer AV

21/11/2022 6.3.11.4

- Fixed: UID was missing from Office 35 Email Reader

20/11/2022 6.3.11.3

+ Added: Office 35 Email Writer

10/11/2022 6.3.11.2

+ Added: Office 35 Email Reader

26/10/2022 6.3.11.1

- Fixed: Incorrect variable date format

28/09/2022 6.3.11.0

+ Added: Office 365 Email monitor
+ Improved: Office 365 connection dialogue error handling
- Fixed: Issue with deleting nodes on maintain tab

26/09/2022 6.3.10.11

+ Added: variable

26/08/2022 6.3.10.10

+ Renamed: "Split RegX" to Split RegX Static
+ Added: Split RegX Dynamic transformation function
+ Improved: Office 365 email logging

15/08/2022 6.3.10.9

- Fixed: Issue with reading Office 365 email folders list

10/08/2022 6.3.10.8

+ Improved: Schedule sorting

12/07/2022 6.3.10.7

- Fixed: Issue with Replace RegX transformation function

09/07/2022 6.3.10.6

+ Added: Do not create empty files option to Export Package Action

28/06/2022 6.3.10.5

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

11/06/2022 - 6.3.10.4

- Fixed: Missing DLL's

24/05/2022 - 6.3.10.3

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

17/05/2022 - 6.3.10.2

- Fixed: Databuffer double procession bug

05/05/2022 - 6.3.10.1

- Fixed: Issues with autosaving Import script changes

22/03/2022 - 6.3.10.0

+ Added: Appache Kafka connection
+ Added: Receive Appache Kafka message action
+ Added: Send Appache Kafka message action

10/03/2022 - 6.3.9.5

+ Added: User name to log file name
+ Improved: Report Package Action generator embeds fonts by default now

02/03/2022 - 6.3.9.4

+ 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
- Fixed: Issue with sending emails in UTF-8 fromat

15/02/2022 - 6.3.9.3

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

08/02/2022 - 6.3.9.2

+ Added: Out parameters to reports
- Fixed: Issue with running Oracle SQL scripts from sql script screen

03/02/2022 - 6.3.9.1

- Fixed: Is value In Database transformation function bug

14/01/2022 - 6.3.9.0

+ Added: RabbitMQ connection
+ Added: Receive RabbitMQ message action
+ Added: Send RabbitMQ message action
+ Improved: Look and feel while working with High Dpi monitors
+ Improved: Default theme is set to Office 2016 White
- Fixed: Issues with running import scripts from the package

17/12/2021 - 6.3.8.3

+ Improved: Note's custom colours are persisted across user sessions
+ Improved: Package Note's can be added to the object library now

15/12/2021 - 6.3.8.2

+ Added: GUIDNB Transformation language function, it returns clean GUID value without brackets and underscores
+ Added: variable
+ Added: Fail On Zero Writes option to Transformation Package Action

06/12/2021 - 6.3.8.1

- Fixed: IMAP4 and POP3 AV

30/11/2021 - 6.3.8.0

+ Added: Office 365 connection
+ Added: receive Office 365 email action
+ Added: ability to save emails as EML files
+ Added: option to mark emails as read
+ Added: option to download unread/read emails only
+ Added: Send email action support office 365 connections
- Fixed: Issues with downloading large files via HTTP/HTTPS
- Fixed: Issues with file metadata package actions
+ Added: Automatic retry for STP downloads/uploads
+ Added: Ability to run transformations without a writer

04/11/2021 - 6.3.7.32

+ Added: variable

18/10/2021 - 6.3.7.31

+ Added: Search string dialogue to the objects tree
+ Improved: Third party components update
- Fixed: Installation Issues

02/10/2021 - 6.3.7.30

+ Added: Ability to ignore missing files to file operation

26/09/2021 - 6.3.7.29

+ Added: Search properties dialogue to package designer
+ Improved: Replace dialogue functionality
+ Improved: Excel components update
- Fixed: Issues with long month names

19/09/2021 - 6.3.7.28

+ Improved: FTP Error handling

23/07/2021 - 6.3.7.27

+ Improved: XML Reading performance
- Fixed: XSLT Transformation Action variable inside file name bugs

18/07/2021 - 6.3.7.26

+ Added: Added Parent field to search dialogue
- Fixed: Issues with saving email attachments
- Fixed: Issues with reading windows event log

11/07/2021 - 6.3.7.25

- Fixed: Minor Issues with logging

03/07/2021 - 6.3.7.24

+ Added: Ability to read single Excel value to Excel operation package action
- Fixed: Issues with Loop Package Action variables
- Fixed: Issues with closing ODBC connection when refreshing target fields list
- Fixed: Execution timeout bug
- Fixed: Email server reconnection bug

26/06/2021 - 6.3.7.23

+ Added: Ability to load variables from CSV file to Set Variable Package Action
+ Added: Ability to add Notes to Transformations, SQL Scripts, Import Scripts, Packages and Email templates

21/06/2021 - 6.3.7.22

- Fixed: Windows log message format
- Fixed: Issues with running ExecuteObject from script package action
- Fixed: Issues with running ExecuteObject from the agent
- Fixed: Ping package action bug
+ Added: Arrange Objects On Save to optios dialogue
+ Improved: Removed redundant options from options dialogue

11/06/2021 - 6.3.7.21

+ Added: etltools.ExecuteObject python function
+ Added: Error variables to Transformation, SQL check, SQL Script, and Import package actions
+ Improved: Split RegX transformation function
+ Improved: Email attachment detach uses regular expression now
- Fixed: Minor spelling mistakes

02/06/2021 - 6.3.7.20

- Fixed: Issues with lookup error handling
+ Improved: All package actions dialogs are resizable now
+ Improved: Email dialogue design

20/05/2021 - 6.3.7.19

- Fixed: Issue with multiple semicolons within soap header

22/04/2021 - 6.3.7.18

- Fixed: SFTP Upload issues when no files are found
- Fixed: Could not find any File(s) to read error when refreshing target grid
- Fixed: Issue with running transformations with lookups from package
- Fixed: Issues with FTP monitor

10/04/2021 - 6.3.7.17

+ Improved: Various cosmetic changes
+ Improved: Data import wizard object resizing
+ Improved: Added New and Edit to all connection dialogue headers
+ Improved: Connection dialogue is closed by pressing the ESC button
+ Improved: Changed table search from case sensitive to not case sensitive
+ Improved: Working with HTML tables
- Fixed: Twitter drag and drop was not working
- Fixed: Search dialogue issues
- Fixed: HTTP downloads shows message twice in the status bar
- Fixed: Restore Project Dialogue issues
- Fixed: Undo/Redo issues while working with source/target grid

03/04/2021 - 6.3.7.16

+ Improved: user can select HTML table file from import script designer
+ Improved: Send email package action uses HTML by default
+ Improved: Send email package action adds the selected file to the list of attachments automatically
+ Added: Support for variables to IMAP4/POP3 regular expressions.
- Fixed: Licensing issues when running the software on AWS servers.
- Fixed: Directory monitor issues when working with NAS storage.
- Fixed: Access violations when reading excel files

21/03/2021 - 6.3.7.15

+ Improved: Tableau hyper error handling
+ Improved: Group dialogue. When the user presses enter the dialogue is automatically closed
+ Added: IP Location and URL Location transformation functions
+ Fixed: Minor mapping designer bugs

17/03/2021 - 6.3.7.14

+ Added: Extract Attachments option to IMAP4 and POP3 reader
+ Added: Email footer message
+ Added: Cache option to "Get Excel Cell Value Dynamic" transformation function
+ Improved: When the application starts it will ask the user "Reopen last objects? (It will only happen if reopen tabs option is checked)
- Removed: IP Location, URL Location and Url Shortener transformation functions
- Removed: Transformation type toolbar from the mapping designer
- Fixed: Issue with empty decryption passphrase
- Fixed: Licence management issues
- Fixed: Schedule table backup/restore issues

27/02/2021 - 6.3.7.13

+ Improved: It is now possible to use a single transformation to write data into multiple excel sheets of the same file
+ Improved: Main screen log messages handling
- Fixed: Directory monitor screen bugs

21/02/2021 - 6.3.7.12

+ 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 character can be seen in preview mode now
+ Improved: the software will make three attempts to publish tableau files before failing
+ Improved: Updated hyper API to the latest version
- Fixed: Various tableau related bugs
- Fixed: Pause package action issues

05/02/2021 - 6.3.7.11

- Fixed: Fixed issue with package variable

03/02/2021 - 6.3.7.10

+ Added: HTML Table reader
+ Added: Recalculate Excel File check box to excel writer
+ Added: Do nothing option to Receive Email IMAP4 package action
+ Added: variable to Receive Email IMAP4 package action
+ Added: Extract MIME Data package action
- Fixed: Invalid pointer error while compressing
- Fixed: FTP Monitor bugs (SFTP Connection issue)
- Fixed: Field selector access violation
- Fixed: Tableau connection issues
+ Improved: Field selector performance
+ Updated: Digital signature

22/12/2020 - 6.3.7.9

- Fixed: Loading data from FoxPro

19/12/2020 - 6.3.7.8

+ Added: GetSystemDate function returns the fractions of a second now
+ Added: IMAP4 writer can move messages to a different folder now
+ Improved: Replace String Wizard
- Fixed: Installation issues
- Fixed: Problem with renaming library objects
- Fixed: Licence management issues
- Fixed: Issues with cloning connections

01/12/2020 - 6.3.7.7

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

6.3.7.6

- Fixed: Issues with special characters inside SQL Server database names
+ Fixed: Replace String Wizard bugs
+ Added: Popup menu to Replace String Wizard

6.3.7.5

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

6.3.7.4

- Fixed: Access violations while using Get Excel Cell Value Dynamic
- Fixed: Wrong Package Name variable issue
+ Improved: Execution log refresh behaviour

6.3.7.3

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

6.3.7.2

+ Improved: SMS connection dialogue

6.3.7.1

+ Added: Owner field to file system reader
+ Added: Owner variable to file metadata package object
+ Added: FileOwner scripting language function

6.3.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
- Fixed: Options dialogue email bug

6.3.6.17

+ Added: Variables: ,,,,,,
+ Added: Check License package object

6.3.6.16

+ Improved: Support for DATETIME2 Fields

6.3.6.15

- Fixed: Issues with Azure blob loading

6.3.6.14

- Fixed: Issues with running packages using GUI

6.3.6.13

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

6.3.6.11

+ Improved: Support for DATETIME2 Fields

6.3.6.10

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

6.3.6.9

+ Improved: JSON Data Handling

6.3.6.8

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

6.3.6.7

+ Improved: Email processing supports regular expressions now
+ Added: "Complex JSON" check box to JSON data source
+ Improved: Support for variables was added to IMAP4 folder names

6.3.6.6

+ Improved: Email attachments handling
+ Added: Path builder
+ Improved: The behavior of show message action was changed so when running from an agent it writes the message into the log

6.3.6.5

+ Added: colours to notes
- Fixed: issues with aborting joiner Transformation on error
- Fixed: issues with deleting the text inside notes

6.3.6.4

+ Added: Support for PostgreSql 12
+ Added: Ability to delete files after compression
+ Improved: Expanded IMAP4 drop-down box
- Fixed: Spelling errors

6.3.6.3

+ Added: Ability to select Amazon connection endpoint
+ Added: variable to Receive Email Package object (IMAP4 and POP3)
- Fixed: Fixed issue with loosing transformations while closing transformation tab
- Fixed: Fixed issue with Objects library

6.3.6.1

+ Added: IMAP4 as data writer connection
- Fixed: IMAP4 reader shows UID correctly now

6.3.6.0

+ Added: Support for Telegram Bot API
+ Added: Checks for source and target structure changes

6.3.5.7

- Fixed: SplitRegX transformation function bug
- Fixed: Lookup transformation function bug

6.3.5.6

+ Added: Multiuser support to the management console
+ Improved: Management console look and feel
+ Added: Select Objects with no links menu option
+ Added: Select Inputs menu option
+ Added: Select Outputs menu option
+ Added: Select Linked Objects menu option

6.3.5.5

+ Added: Added ability to pull a license from the license server
- Fixed: Package copy/paste issues
- Fixed: Eventlog crashes
- Fixed: Bat files execution problems
- Fixed: Last record flag issue for files with two lines

6.3.5.4

- Fixed: Objects Library bugs
- Fixed: Losing mapping bug when the search box is used
- Fixed: Windows event log corruption (64-bit version only)
+ Added: Parameters to External Application package action
+ Added: Copy Directory Structure option to File operation package action

6.3.5.3

+ Added: Case sensitive option to Lookup transformation object

6.3.5.2

+ Added: Restore project option
- Fixed: Issues with joining empty files

6.3.5.1

+ Added: Clear log Action
+ Improved: Loop Action Logging
+ Improved: Set Variable Action
+ Improved: Salesforce connection uses TLS 1.2 now
- Fixed: Project clone issues

6.3.5.0

+ Added: Support for Amazon S3 and Azure Blobs
+ Added: Amazon S3 operations: Download, upload and delete files, Create and delete baskets, Download basket files List
+ Added: Azure blob operations: Download, upload and delete files, Create and delete containers, Download container files List
+ Improved: Third-party components update:

Report generator
Excel processing libraries
Cloud libraries
Text conversion libraries

+ Improved: Various bug fixes and improvements
+ Fixed: FTP errors when working with very large files
- Fixed: Repository Synchronization dialogue issues with MongoDB
- Fixed: Used by dialogue issues with MongoDB
- Fixed: Excel data reading problems
- Fixed: Objects Library bugs

Update procedure: https://www.etl-tools.com/articles/upload-files-to-amazon-s3-and-azure-blobs.html

6.3.4.13

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

6.3.4.12

+ Added: Syslog data source

6.3.4.11

- Fixed: JSON Data reader AV

6.3.4.10

+ Improved: Excel action can change file extension now
+ Improved: Management Console look and feel

6.3.4.9

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

6.3.4.8

+ Improved: if registration fails the message is displayed
+ Improved: "Disable Package Actions Variables By Default" is not be enabled by default.

6.3.4.7

+ Improved: if an object is read-only, it's shown in grey colour
+ Improved: Added right context menu to the tabbed view of the designers, it allows to autosave all items being closed
+ Improved: Added '[-4]-Finish Package Execution - Failure' option to all package action's designers
+ Improved: Added '[-3]-Finish Package Execution - Success' option to all package action's designers

6.3.4.6

Software registration changes:

Starting from this release users would need to enter the 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: It is now possible to use agent during the trial period
+ Improved: The application starts much faster
+ Improved: It is now possible to add files to the existing archives
- Fixed: Issues with reading google spreadsheet data

6.3.4.5

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

6.3.4.4

+ Added: New data source - 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
+ Improved: Twitter message can include pictures
+ Improved: Gpg4win support for variables

6.3.4.3

+ Improved: Slight performance improvement

6.3.4.2

+ Added: Change Encoding Package Action
+ Added: Batch email processing option to IMAP4 and POP3 Package Actions
+ Improved: When the user press save objects are automatically added to the version control

6.3.4.1

+ Added: Ability to download, upload, delete and create directories to FTP Monitor dialogue

6.3.4.0

+ Added: Support for DropBox, Google Drive, Microsoft OneDrive, Box, Amazon Cloud Drive, Hubic, HiDrive and Yandex Disk cloud storage
+ Added: Cloud storage operations: Download, Upload, Create Remote Directory, Delete Remote Directory, Delete Files and Directory List
+ Added: Enable logging option to FTP Action Properties dialog
+ Added: Ability to download,upload,delete and create directories to FTP Action Properties dialog
+ Added: Enable logging option to POP3 Action Properties dialog
+ Added: Enable logging option to IMAP4 Action Properties dialog
+ Improved: Made FTP Action Properties dialog re sizable
+ Improved: Various bug fixes and improvements

6.3.3.2

+ Improved: JSON null values handling

6.3.3.1

+ Added: Loading data into Google Spreadsheets
+ Improved: Third-party components update
+ Improved: Directory monitor stability while working with network shares
- Fixed: FTP Upload Issues

6.3.2.18

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

6.3.2.17

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

6.3.2.16

+ Improved: Third-party components update

6.3.2.15

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

6.3.2.14

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

6.3.2.13

+ Improved: Made Calculation dialogue box resizable
+ Improved: Made Script Package Action dialogue box resizable
+ Improved: Made Send Email Package Action dialogue box resizable
- Fixed: Issues with exporting data into CSV and tab files from grids

6.3.2.12

+ 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

6.3.2.11

- Fixed: Loading Data Into Time Fields
- Fixed: Parallel Execution Issues

6.3.2.10

+ Added: ReadMe file to backup
+ Improved: Archive error handling
+ Improved: Setup Process

6.3.2.9

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

6.3.2.8

+ Improved: Ask question package action always fails now when run from the agent
+ Improved: Show message package action always fails when run from the agent
+ Improved: Spelling corrections
+ Improved: Email Notifications can be sent on all package failures
+ Improved: SMTP connection testing
+ Improved: Automatic database refresh

6.3.2.7

+ Improved: Google Spreadsheet import
+ Improved: Google Spreadsheet Reader Connection
+ Improved: Google Spreadsheet Reader works with international characters correctly now
+ Improved: SQL Lookup transformation dialogue
- Fixed: Salesforce Bulk API load issues
- Fixed: SQL Lookup transformation issues
- Fixed: aetlcl.exe AV

6.3.2.6

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

6.3.2.5

- Fixed: Reader Autoformat issues
- Fixed: Problems with command line execution

6.3.2.4

+ Improved: Error handling for open files
+ Improved: Monitors support global variables now

6.3.2.3

- Fixed: Package logging issues
- Fixed: Registration issues
+ Improved: Added writer number to Transformation statistics variables

6.3.2.2

- Fixed: Python Scripting issues

6.3.2.1

+ Added: and packages variables
+ Improved: Added more demos
+ Improved: Automatically uses the latest version of python installed
+ Improved: Support for python

6.3.2.0

+ Improved: 64 bit Agent can now execute 32-bit packages and transformations
+ Improved: Directory Monitor
+ Added: New events to watch to Directory Monitor: add, delete, modify and rename files
+ Added: Wait and Timeout option to Directory Monitor
+ Improved: UnInstall process
+ Fixed: Salesforce Bulk API load issues

6.3.1.0

+ Added: Support fot Hyper Tableau files (64 bit version)
+ Added: Upload type option to Publish Tableau File action dialogue
+ Added: "If File Exists" option to Publish Tableau File action dilaogue
+ Added: Support for hyper,tdsx,twb,twbx files to Publish Tableau File action
+ Improved : Publish Tableau File action uses rest now
+ Improved: Third party components update

6.3.0.5

+ Added: Package EMail attachment filter

6.3.0.4

- Fixed : Loop action issue with adding values
+ Improved : Demos

6.3.0.3

- Fixed : #3D000 No database selected issue
- Fixed : Uploading large files via SFTP
+ Added : , , variables

6.3.0.2

+ Updated : SFTP components
+ Improved: Backup Error handling
+ Improved: Repository Switching
+ Fixed: Various bug fixes and improvements

6.3.0.1

- Fixed: Loading data into Google spreadsheet
- Fixed: Issues with SFTP keys storage
+ Added : Ansi Driver checkbox to odbc connections

6.3.0.0

+ Added: Support for MongoDB
+ Added: Ability to delete nodes
+ Added: Repository backups functionality to Management console
+ Added: Added Execution Timeout

Various bug fixes and improvements
Repository connection details and designer user interface settings are no longer stored in the registry, ini files are used instead
Advanced ETL Processor Services - XXX were renamed to ETL Server - XXX

Update procedure: https://www.etl-tools.com/articles/january-etl-update.html

6.2.2.0

- Fixed: Addressed issues with saving connection details (SQL Scripts and Report screen)

6.2.1.0

+ Added: HTTP Headers page to Soap,HTTP Download and HTTP form package actions
- Fixed: Issues with loading data from POP3 connection as part of the Package

6.2.0.0

+ Added: Support for Visual Importer Scripts design and execution

6.1.0.0

Complete rewrite of Management Console.
Can be used on mobile devices
Uses bootstrap
Responsive design

+ Added: Event monitors editor to Management Console
+ Added: Incremental Search to Object Selector to Management Console
+ Improved: Restoring backups (Some users add fields to repository tables and that led to restore failures)
+ Improved: Look and feel of Pivot object on win2008 server
+ Improved: Look and feel of UnPivot object on win2008 server
+ Improved: Look and feel of Application options dialogue on win2008 server
+ Improved: Look and feel of Smtp connection dialogue on win2008 server
+ Improved: Object Selection Dropdown always shows the correct icon now (Scheduler Dialogue and Event Monitor Dialogue)
+ Improved: Removed "Every" field from event_monitors table
+ 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)

6.0.1.0

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

6.0.0.13

- Fixed: Issues with Ping Package Action
- Fixed: Issues with the management console

6.0.0.12

- Fixed: Issues with JSON transformations

6.0.0.11

- Fixed: Issues with reading JSON data

6.0.0.10

+ Added : HTML Editor to Email Action
+ Added: Support for sending embedded images
+ Improved: Pause Package Action

6.0.0.9

- Fixed: Issues with non-English repositories

6.0.0.8

+ Improved: Setup for new users by adding a user to run services

6.0.0.7

- Fixed : PGP Encription Action

6.0.0.6

+ Improved: Management Console
- Fixed: Issues with reading Brightpearl data

6.0.0.5

- Fixed: Issues with assigning default values to lookup

6.0.0.4

+ Improved: Functionality of Running totals transformation function

6.0.0.3

+ Added: Content type to SOAP action
+ Improved : SOAP action dialogue
+ Improved : Multiline select statement execution
- Fixed: Issues with Copy/Paste functionality

6.0.0.2

- Fixed: Issues with FTP downloads
- Fixed: Azure backup Issues

6.0.0.1

+ Improved: Open SSL libraries update
+ Improved: Up to 30 per cent faster
+ Improved: 64-bit setup installs MS Access Ole DB provider automatically

6.0.0.0 Major Release

The main feature in this release is the introduction of monitors. The monitor is a windows service which waits for a certain event to happen. It automatically responds to events by performing user-defined tasks and actions.

Supported Monitors: Directory Monitor, FTP Monitor, POP3 Monitor, IMAP4 Monitor, MSMQ Monitor, HTTP Monitor

Options Dialogue

The "Execute only local actions" option was removed
"Use agent for execution was" removed

Maintenance tab

Complete redesign

Schedule tab

Execute on computer check box was removed

Schedule dialogue

Execute on computer check box was removed
Application Platform drop-down box was added

Execution log tab

Execute on computer check box was removed
Added Submitted, Executed and Platform fields

Submitted = application name which added action to the execution queue
Submitted = application name which executed the action
Submitted = application platform which executed the action (Windows 32bit or Windows 64bit)

It is now possible to change user agent option

5.9.4.8

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

5.9.4.7

+ Added: Paste functionality to target definitions (writer fields grid)

5.9.4.6

- Fixed: Issues with version control

5.9.4.5

- Fixed: Issues with loading version info

5.9.4.4

- Fixed: Tableau Datetime fields processing issues
- Fixed: MySql Server Repository Creation Scripts issues
- Fixed: Repository backup issues

5.9.4.3

- Fixed : HTTP Form post-action issues

5.9.4.2

+ Added: Tableau Server Connection
+ Added : Publishing Tableau TDE Files
+ Improved: Updated Tableau Client

5.9.4.1

- Fixed: Fixed QVD reading issues

5.9.4.0

Major update: Uses the new backup format

+ Improved: Repository Backup performance
+ Improved: Repository Backup restore performance
+ Improved: Repository Synchronization Wizard can use the backup as a source for Synchronization

5.9.3.23

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

5.9.3.21

- Fixed: Issues with About Dialogue
- Fixed: Issues with Registration Dialogue
+ Improved: Setup procedure

5.9.3.20

- Fixed: Issues with loading version info

5.9.3.19

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

5.9.3.18

- Fixed: Issues with system variables

5.9.3.16

- Fixed: Issues with services installation

5.9.3.15

+ Improved: Look and feel of object joins
+ Improved: Installation
+ Improved: Reduced setup size for 64bit version
+ Improved: Services are registered automatically using the current user name during installation
+ Improved: Services start-up is set to manual during installation
- Fixed: Issues with Space horizontally and vertically logic
- Fixed: Issues with moving objects within object tree

5.9.3.14

+ Improved: Updated Salesforce API to v38
- Fixed: Addressed issues with log refresh

5.9.3.13

+ Added: Number Of Files Found variable to File Operation, Check File, Zip and FTP Package actions
+ Improved: Report generator components update
+ Improved: Query Builder components update
+ Improved: SSL components update
+ Improved: Improved file delete messages
+ Improved: Repository Creation Wizard
+ Improved: Removed Agent management buttons from the log tab and schedule tab
+ Improved: Removed Number of executions field from log tab
+ Improved: Removed clutter from maintain tab
- Fixed: Addressed issues with scheduler next execution date calculation
- Fixed: Addressed issues with SFTP file downloads

5.9.3.12

+ Improved: Schedule dialogue allows to enter multiple lines now

5.9.3.11

- Fixed: Issues with MySQL Repository

5.9.3.10

- Fixed: Issues with refreshing logs

5.9.3.9

+ Added : FTP Files list as data source
+ Added : Object Dependency search
- Fixed: Issues with updating data via table browser

5.9.3.7

+ Added : Added displayName, distinguisedName, initials, mailNickname, publicDelegates, sAMAccountType, scriptPath, showInAddressBook, sn, pager, extensionAttribute1-extensionAttribute15 fields to ActiveDirectory extract
+ Improved : Third party components update
+ Improved : Table generation
+ Improved : FTP Listing generation

5.9.3.6

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

5.9.3.5

+ Added: Excel Operation action

5.9.3.4

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

5.9.3.3

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

5.9.3.1

+ Added: and variables
+ Improved: Support for JSON as data source

5.9.3.0

+ Added: Support for JSON as data source and target
+ Added: File Metadata Action
+ Improved : Object tree search functionality
+ Improved: Lookup transformation supports JSON as a data source now

5.9.2.20

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

5.9.2.17

+ Improved: Global variables handling for Reports

5.9.2.16

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

5.9.2.15

+ Improved: Services registration during installation
+ Improved: Management console can start and stop agent now
+ Improved: Management console can amend agent service properties now
- Fixed: Problems with reading delimited text files when the delimiter is more than one character log

5.9.2.14

- Fixed: Problems with clone row transformation object

5.9.2.13

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

5.9.2.12

- Fixed: Problems with refreshing list of Oracle Tables

5.9.2.11

- Fixed: Problems with AM/PM Date conversion

5.9.2.10

- Fixed: SFTP Rename issues

5.9.2.9

+ Improved: JDBC Processing
- Fixed: Problems with version control

5.9.2.8

+ Improved: JDBC Errors Handling

5.9.2.7

- Fixed : Problems with Soap Package Action Parameters
- Fixed : Agent stability issues

5.9.2.5

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

5.9.2.4

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

5.9.2.2

- Fixed: Agent stability issues

5.9.2.0

+ Third-party components update
+ Support for the new functions introduced in the Excel 2016 January Update
+ Improved compatibility with third 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: Agent stability issues
- Fixed: Agent heartbeat issues
- Fixed: Row Cannot Be Located for Updating issue

5.9.1.12

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

5.9.1.11

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

5.9.1.10

+ Added variable

5.9.1.9

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

5.9.1.8

- Addressed Salesforce data update issues

5.9.1.7

+ Improved support for RSS feeds

5.9.1.5

+ Calculation transformation function support Python now

5.9.1.4

- Addressed issues with Running Total transformation

5.9.1.3

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

5.9.1.2

+ Added Write to the File transformation function
- Minor bug fixes

5.9.1.0

+ Minor transformation designer improvements
+ Script Package action support for Python was introduced

5.9.0.15

- Package designer bugs fixes
- Date fields processing bugs fixes
- Agent stability improvements

5.9.0.14

- Joiner Object bugs fixes

5.9.0.11

- SalesForce data processing fixes

5.9.0.10

- Addressed DTD is prohibited issues
- Addressed email processing problems

5.9.0.9

+ PDF Report quality improvements

5.9.0.7

+ Added End of line customization for text data target
+ Added fail on no emails check box option to POP3 and IMAP4 packages action
+ Added ,
,
,
variables

5.9.0.6

- Scheduler bug fix

5.9.0.5

+ Improved support for very large QVD files

5.9.0.4

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

5.9.0.3

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

5.9.0.1

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

5.9.0.0

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

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

5.8.3.23

+ Add refresh databases button to source and target connections
+ Added support for Unicode in the 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

5.8.3.22

- Addressed issues with downloading files via HTTP/HTTPS

5.8.3.20

- Addressed issues with creating Excel files

5.8.3.17

+ Added option to save all objects into text files
+ Added option to check network share free space

5.8.3.15

+ 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

5.8.3.14

+ 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

5.8.3.13

- Addressed issues with downloading files via HTTP/HTTPS

5.8.3.12

+ Faster QVD files processing
- Addressed issues with variables

5.8.3.10

+ 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

5.8.3.9

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

5.8.3.8

- Addressed issues with FTP list action
- Addressed issues with File merge action
- Addressed issues with Clone row object

5.8.3.7

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

5.8.3.6

- Addressed issues with Loop package action

5.8.3.5

- Addressed issues with sub transformation function

5.8.3.4

+ Added Ignore Data Format option to Excel Data reader
+ Added Additional Parameters option to GPG4 Package Action
+ Added After Execution tab to all Package Actions
- Addressed issues with split function

5.8.3.3

+ Added Check Directory Package action
+ Extended reader and writer variables support
+ Added support for variables to Joiner object

5.8.3.2

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

5.8.3.0

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

5.8.2.20

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

5.8.2.17

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

5.8.2.14

+ Added Field Value transformation function

5.8.2.13

+ 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 HTTP Download action

5.8.2.12

+ Added Read File Content Option to Reader
- Addressed issues with File Creation Dates

5.8.2.10

- Addressed issues with Log screen

5.8.2.9

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

5.8.2.8

- Addressed issues with adding objects to the library
- Addressed issues with deleting objects from the library

5.8.2.7

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

5.8.2.6

- Addressed issues with Loop package action

5.8.2.5

+ Added support for Clarion dat files
+ Added support for Twitter

5.8.2.4

- Addressed issues with sending emails with attachments

5.8.2.3

- Addressed issues with sorter

5.8.2.2

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

5.8.2.0

+ Added support for Slemma

5.8.1.6

+ Excel Import and export form data grids is much faster now
- Addressed issues with exporting data as excel from data grids

5.8.1.5

+ 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
- Addressed issues with deleting records

5.8.1.3

+ Added Encode JSON String and Decode JSON String
- Addressed issues with deduplication

5.8.1.2

+ Added trim option to format field names dialogue
+ Updated set fields' names functionality
- Management console fixes

5.8.1.1

+ Extended Date Diff functionality

5.8.1.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
+ All code related to execution packages was removed from the agent
+ Agent is used for scheduling only now
+ All packages are executed by aetlcl.exe
+ Added agent management buttons to Log and Schedule tabs

5.8.0.38

- IMAP4 and POP3 fixes
- Various bugs fixes and improvements

5.8.0.37

+ Support for salesforce BULK API was introduced
+ Report builder version update
- Various bugs fixes and improvements

5.8.0.36

- Addressed issues with loading null values into salesforce

5.8.0.35

- Addressed issues with loading data from SQL Server CE

5.8.0.34

- Addressed issues with loading data from delimited files

5.8.0.33

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

5.8.0.32

+ Documentation update
+ Added GetExcelCellValue calculation function
+ Sorter improvements

5.8.0.30

+ Improved performance of Join Transformation.
+ Updated version of Report Editor
- Addressed issues with memory management

5.8.0.29

- Addressed issues with Is Number validation function

5.8.0.28

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

5.8.0.27

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

5.8.0.25

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

5.8.0.24

+ Added email notifications functionality to execution agent
+ Documentation update
- Addressed issues with date fields processing

5.8.0.23

- Addressed issues with the processing of delimited files
- Addressed issues with date formats

5.8.0.20

+ Up to 6 times faster data deduplication
+ Up to 2 times faster data grouping
+ Grouper 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
+ Added record number to package export object
- Various bugs fixes and improvements

5.8.0.19

+ 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

5.8.0.18

+ 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

5.8.0.17

+ Added ability to lock the objects
- Addressed issues with processing empty excel files
- Addressed problems with validator data preview

5.8.0.16

- Addressed problems with reading google spreadsheet data
- Addressed Transformer AV's
- Addressed issues with stopping the agent

5.8.0.15

+ 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
+ Updated demos
- Addressed issues with Joiner object
- Various bug fixes and improvements

5.8.0.13

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

5.8.0.12

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

5.8.0.10

- Addressed issues with creating rejected records file

5.8.0.9

- Addressed issues with running ODBC Manager from the application

5.8.0.7

+ SSL libraries update
- Various bug fixes and improvements

5.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
+ New version of report builder
+ Report builder documentation update
+ Various bug fixes and improvements

5.8.0.5

+ Support for MS SQL server 2014 was extended
+ Is is no longer necessary to run the application as administrator to manage agent
+ Scheduler dialogue improvements
- Execution Agent bug fixes.
- Addressed issues with sending SMS messages

5.8.0.4

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

5.8.0.3

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

5.8.0.2

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

5.8.0.1

- SFTP rename bug fix
- Table Editor bug fixes

5.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 descriptions are mandatory now
+ New option to Include reader name into Rejected records file
+ Documentation update
- Addressed issue with sending SMS messages

5.7.10.10

- Addressed issues with GetExcelCelValue transformation function

5.7.10.9

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

5.7.10.8

+ Added Reset height option
- Updated repository creation scripts

5.7.10.7

+ Up to 10 percent faster
+ Check File Action has new option: Check if file is in Use
+ Licence Update
+ Documentation Update

5.7.10.6

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

5.7.10.5

- Addressed issues with XML encoding

5.7.10.4

- Addressed some validator issues

5.7.10.3

+ Added If South African company transformation function
+ Added Is South African company validation function
+ Added incremental search to application options dialogue
+ Documentation update
+ Corrected issues with "Is number less than", "Is number more than" and "Is number between" transformation function

5.7.10.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
+ Loop Package Action improvements
- Minor bugs fixes
- Spelling corrections

5.7.10.0

+ Added support for tableau tde files

5.7.9.44

+ Loop Package Action improvements

5.7.9.43

+ Transformation fails if there were problems with the data writer when run from the package
+ Added option to generate table creation script to the transformer source grid
+ Log redirect object improvements
+ Added system variable
+ Various bugs fixes

5.7.9.42

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

5.7.9.41

- Addressed Splitter dialogue issues

5.7.9.40

+ Added new transformation field values
+ Documentation Update

5.7.9.39

- Addressed Salesforce connection dialogue issues
+ Documentation Update

5.7.9.38

- Addressed SFTP bugs

5.7.9.37

+ Added two new fields to File System Datasource last modification date and last access date

5.7.9.36

+ Minor interface improvements

5.7.9.35

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

5.7.9.33

- Report generator bugs fixes

5.7.9.32

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

5.7.9.30

- Addressed CASE transformation issues

5.7.9.27

- MySQL bugs fixes
- Bug fixes

5.7.9.26

+ Added Support for Message Queuing (MSMQ)
+ Documentation Update
+ Run At Agent Start Scheduler option was introduced
+ Better Data Reader Memory Management

5.7.9.25

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

5.7.9.23

+ Added GUID function to the scripting language
+ Documentation Update

5.7.9.22

- Addressed issues with BIGINT fields

5.7.9.21

- Management console fixes

5.7.9.20

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

5.7.9.19

+ New package Object - SMS
+ Documentation Update
+ Interface improvements
+ Further improvements to Sending SMS functionality
- Date Format bugs fixes
- Addressed problem with keep characters functions

5.7.9.18

+ Support for Sending SMS messages was introduced,
following services are supported: Twilio, BulkSMS, TelAPI and Essendex.
+ PostgreSQL repository scripts corrections
+ Documentation Update

5.7.9.17

+ 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

5.7.9.15

+ Interface improvements
- Addressed issues with CASE transformation function

5.7.9.14

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

5.7.9.13

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

5.7.9.12

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

5.7.9.11

- Addressed problems with refreshing logs

5.7.9.9

+ Excel processing engine update

5.7.9.8

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

5.7.9.6

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

5.7.9.5

+ Support for the latest version of Google spreadsheets was introduced

5.7.9.4

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

5.7.9.3

+ Up to 50 percent faster working with QVD files

5.7.9.2

+ Added Authentication support to HTTP package objects

5.7.9.1

- Addressed memory leaks problems

5.7.9.0

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

5.7.8.7

- Web Service Lookup issues were addressed
- Addressed issues with sending emails with attachments

5.7.8.5

+ up to 10 times faster data sorting

5.7.8.4

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

5.7.8.3

- Fixed problem with log deletion
- Agent stability fixes

5.7.8.2

- XML and ODBC fixes

5.7.8.1

- Agent stability fixes
- Date Diff function fixes

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

5.7.7.23

- Addressed file update problems

5.7.7.22

+ Added separate application to edit options

5.7.7.20

+ Added option clear sheet to excel writer
+ Added support for dynamic file names in attachments

5.7.7.18

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

5.7.7.16

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

5.7.7.14

- Addressed union object issues

5.7.7.12

- Addressed some sub transformation issues

5.7.7.10

+ Added library of objects
- Fixed bugs with Copy/Paste of Sub transformation function

5.7.7.9

- Addressed issues of loading data from Excel files

5.7.7.8

+ Added snap to grid option
+ Addded Data Port option to FTP Connection

5.7.7.7

- Addressed issues with missing files
+ Tables list refresh is faster now

5.7.7.6

+ Added RichText object to the Report Designer
+ Added option to set defaults
+ Added option to filter target fields
- Addressed some SQLite issues

5.7.7.3

- Addressed issues with sending emails

5.7.7.2

+ Added following variables





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

5.7.7.0

+ Introduced Management Console
- Addressed some FTP Package dialogue issues

5.7.6.30

+ Updated regular expression for US SSN
+ Extended agent logging

5.7.6.29

- Addressed issues of loading data from flat files

5.7.6.27

- Addressed issues with long object names

5.7.6.26

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

5.7.6.25

- Corrected issues with FTP automation

5.7.6.24

+ When a new output field is added field id is assigned automatically
+ Documentation update
+ OleDB support for repository connections
- Addressed issues with running execution agent on windows 2003
- Autoformat fixes (Some mappings may need to be updated)

5.7.6.22

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

5.7.6.21

+ Support for Zoom in/Out was introduced
+ Target Data tab was introduced to the transformation editor
+ Better printing support
+ Execution Agent was optimized to run less SQL against the repository
- Email processing bug fixes

5.7.6.19

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

5.7.6.17

- Addressed issues of loading data from flat files
- Addressed some execution agent issues

5.7.6.16

+ Addressed issues with parallel task executions

5.7.6.15

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

5.7.6.13

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

5.7.6.12

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

5.7.6.8

- Deduplicator AV fix
- QVD reading bug fixes

5.7.6.7

+ Incremental Object search works with comments and connections now
+ Better handling of empty Salesforce tables
+ More detailed information about Salesforce fields by the data reader
+ Support for Greenplum was introduced

5.7.6.6

+ Added ability to hide tabs on the main screen
+ 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 the registry now
- Addressed issues with date fields processing
- Addressed issues of loading data from delimited files

5.7.6.4

+ Added option to resize objects selector
- Addressed some issues of working with default values

5.7.6.3

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

5.7.6.1

+ Better source connection errors handling

5.7.6.0

+ Salesforce is supported as data-target
- Addressed more autoformat problems

5.7.5.11

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

5.7.5.9

- Addressed issues with Salesforce processing

5.7.5.8

- 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

5.7.5.6

+ Salesforce connection support the 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

5.7.5.5

- Addressed problem with ping object

5.7.5.4

+ Minor Interface improvements
- Addressed problems with excel date formatting

5.7.5.3

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

5.7.5.2

- Addressed problems with formatting dates

5.7.5.1

- Addressed problems with autoformat option
- Addressed problems with package variables
- Corrected problem with FTP progress bar

5.7.5.0

- Addressed problems with Datediff function

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

5.7.4.6

Up to 20 percent performance increase

5.7.4.3

+ Up to 70 percent performance increase

5.7.4.2

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

5.7.4.1

+ Global Variables (very useful for switching from development to production)
+ 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
+ Documentation update
- Various bug fixes and interface improvements

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

+ It is now possible to use a package variable in the web service URL
+ It is now possible to use a package variable in defaults
+ Notes have pop up menu now

- Toolbox in Packages is movable and sizeable
- 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
- Clarify day label on File Operations - corrected

5.7.3.1

- Addressed some lookup issues

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

+ Multiple files decompression was introduced
+ File Rename with the mask was introduced
+ 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
- New object creation bugs were fixed

5.7.2.5

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

5.7.2.4

+ QVD generation bugs fixes

5.7.2.3

+ Option to schedule execution on the last/first day of the month was introduced
+ "Is Value in Database" and "If Value in Database" were added
+ Documentation update

5.7.2.2

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

5.7.2.1

+ Connection mapping dialogue was added to repository synchronisation wizard
+ 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

5.7.2.0

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

5.7.1.4

+ Format field name dialogue improvements
+ Datareader minor improvements
- Addressed Repository Synchronization wizard bugs

5.7.1.3

- Various bug fixes

5.7.1.0

+ Introduced Repository Synchronization wizard

5.7.0.10

+ Addressed problems with updating Oracle blob fields

5.7.0.8

+ Addressed some grouper issues

5.7.0.7

+ HL7 Examples were added
+ Undo/Redo Functionality was improoved
+ Documentation update

5.7.0.5

+ Compare values function was added
+ Various bug fixes
+ Documentation update

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

5.6.3.10

+ Added parameter names to calculation object
- Address ping object issues

5.6.3.9

+ Added Undo and Redo functionality to the transformation designer
- Various bug fixes

5.6.3.8

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

5.6.3.6

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

5.6.3.4

+ 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 the Lookup object
+ Better object selection for packages and mappings
+ Various bug fixes and interface improvements
+ Support for HL7 messaging was introduced

5.6.2.11

+ Support for PGP was introduced
+ Interface improvements
- Various bug fixes

5.6.2.10

+ Added Keep Characters Function
+ Added Epoch to Date Finction
+ Added Date to Epoch function
+ Interface improvemnets
+ Documentation update
- Various bug fixes

5.6.2.6

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

5.6.2.2

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

5.6.2.0

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

5.6.1.4

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

5.6.1.0

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

5.6.0.0

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

5.5.2.3

+ Added option to ignore XML tags between Table tag and Record tag
+ Documentaiton Update
- Fixed set variables bugs

5.5.2.2

- Various bug fixes

5.5.1.2

- Repository Scripts fix

5.5.1.0

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

5.5.0.0

+ Support for QVD files was introduced
- Various bug fixes