- - Fixed: Writer Transformation Type Selection Bug
Advanced ETL Processor Enterprise History
Recent changes, fixes, and improvements for Advanced ETL Processor Enterprise.
Showing 785 releases
- - Fixed: Duplicated Variables Bug
- - Fixed: Node Deletion Bug
- + Improved: SQL Server connectivity particularly: Windows Authentication, SQL Server Authentication, Microsoft Entra Service Principal, Microsoft Entra Managed Identity, Microsoft Entra Default, Microsoft Entra Password
- + Improved: Minor Data transformation and import performance improvement (ODBC and SQL Server)
- - Fixed: Memory Leaks
- + Improved: Minor Data transformation and import performance improvement
- - Fixed: Delimited text file reader bug
- + Improved: Extracting data from date/time/timestamp fieds performance
- + Improved: Loading data into Oracle performance by approximately 10 percent
- - Fixed: Oracle timestamp import bug
- - Fixed: Oracle timestamp and date fields formatting
- + Improved: "Data Reader" performace by approximately 5 percent
- + Added: Ability to hide certain objects types from objects tree
- + Improved: Project Creation Objects Order
- - Fixed: Project Deletion bug
- + Updated: Help, Support and Order links
- + Added: Ability to hide connections from objects tree
- + Added: Local System Account support to services registration during setup
- + Improved: "Data Writer Dialogue" interface behaviour (SQL Server only)
- - Fixed: User Fields Repository backup issues
- + Added: Clarion TPS Option to Import Script Wizard
- - Fixed: Sql Server 2025 repository backup issues
- + Improved: "Is In List" Validation Function Interface
- - Fixed: Sql Server 2025 connection issues
- + Improved: Range Lookup Transformation Performance (Up to 5 Times Faster)
- + Improved: Lookup Transformation Performance
- + Improved: Writer Data Grid Calculated Names Handling
- - Fixed: Excel Writer AV
- + Added: Support for Clarion TPS Files
- + Improved: Formula Calcualtion Inside Excel Tables
- + Improved: Objects Tree Refresh Performance
- - Fixed: Disabled Google Spreadsheets Import Script Connection Type
- - Fixed: Disabled Rest Import Script Connection Type
- - Fixed: Office 365 Mail loop bug (Certain processors only)
- - Removed: Support for Hubic and Amazon Drive (They are no loger exist)
- - Fixed: Arrange objects bug (Mapping Editor)
- - Fixed: Vertical aligment bug (Mapping Editor)
- - Fixed: Spelling Errors
- + Improved: Support for international characters
- + Improved: Set Excel formula field size to 8k (Excel Writer)
- - Fixed: Cloud Browser AV
- - Fixed: Package AV when copying notes
- + Improved: Text Editor Functionality
- + Added: Parquet Source to Reader
- + Added: Delimited File to Parquet Action
- + Improved: Datawriter Error Handling
- + Updated: Interbase client
- + Added: Firebird client to setup
- - Fixed: Download Files from Azure blobs AV
- + Added: Ability to download files from folders to Download Files from Azure blobs action
- + Added: Interbase/Firebird client to setup
- + Improved: Creating New Project performance
- + Improved: Handling XML Files without encoding
- + Updated: Repository scrips so it matches Active Table Editor
- + Added: #LoopHeader# variable to File Loop Action
- + Improved: Parsing Delimited Strings
- - Fixed: Sort Delimited Values Transformation function additional delimiter bug
- - Fixed: Deduplicate Delimited Values Transformation function additional delimiter bug
- + Added: Sort Delimited Values Transformation function
- + Added: Deduplicate Delimited Values Transformation function
- + Added: Keep From Folder parameter to Move Folder actions
- - Fixed: Copy Files action bug
- + Added: Default Sorting to Case Transformation Function
- + Improved: Lookup Editor Shows up 10k records now (instead of 1k)
- - Fixed: Text Writer bug
- + Improved: Renamed Get Line Transformation function to Get Field
- + Added: Set Field Transformation Function
- + Added: Parent Folder variable to File Metadata Action
- + Improved: Changed Pause Action time format to 24h
- + Added: Escape Qualifier to SQL To Text Action
- + Improved: Working with global variables when running Package Action
- + Improved: MS SQL Server Reader error handling
- + Added: Escape Qualifier to Text Writer
- + Improved: Minor Interface Tweaks
- + Improved: JSON Reader Error Handling
- - Fixed: Issue with reading complex JSON
- + Added: JSON To XML Dynamic action
- + Added: XML To JSON Dynamic action
- + Improved: JSON To XML Transformation function Renamed Node to Tag
- + Added: JSON To XML Transformation Example
- + Added: JSON To XML Transformation function
- + Added: XML To JSON Transformation function
- - Fixed: Loop End Joining Bug
- + Added: #ActionLogFile# variable to all Dynamic Actions
- + Improved: When transformation fails progress dialogue is not closed automatically
- - Fixed: Small bug with Set Variables Properties Dialogue
- - Fixed: Transformation Designer Object Movement Bug
- - Fixed: Missing Global Variables Bug
- - Fixed: Global Variables Python Bug
- + Added: 1057 Download IP Locations Table Example
- - Fixed: Transformation Designer Vertical Scroll Bug
- + Added: Move to the top menu item the Transformation Designer
- + Improved: Working with Excel templates
- - Fixed: Joiner AV
- + Added: Copy File Dynamic Action
- + Added: Insert Variable Value and Insert Variable Name to Dynamic Script Action
- + Added: Metadata Fields to object search dialogue
- + Added: Browsers to Main Menu
- + Added: FTP Browser to FTP Monitor
- - Fixed: FTP Browser Reconnection Bug
- - Fixed: FTP Action Mask Bug
- - Fixed: FTP Move Files Action Target Folder Bug
- - Fixed: Excel Block Transformation bugs
- + Added: 1056 LLM Translation Example
- - Fixed: AV while obtaining file owner
- + Improved: Save String Dynamic action saves data in UTF8 format
- + Improved: Set background to white
- + Improved: Set Variables Dynamic action functionality (Delete Variable)
- - Fixed: Package Execution Bug
- + Added: Replace Variables Option to Database Loop Action
- + Added: Insert Variable Name and Name to Text/Code editors
- - Fixed: Package Designer AV
- - Fixed: Check File Dynamic Action Bug
- - Fixed: MySQL Repository Bug
- + Added: Check File Date Dynamic Action
- + Improved: Notes Object Height and Width handling
- - Fixed: Minor Workflow editor bugs
- + Improved: Notes Object Interface
- + Added: Font Color selection to Notes Object
- + Added: Action Markers for Embedded scripts and SQL
- - Fixed: Excel 2 Reader Bug
- + Improved: Refresh token handling for MS Teams Connections
- + Added: hardtimeout, softtimeout and retries parameters to aetlcl.exe
- + Improved: Variable Search Dialogue Interface
- + Improved: Set Variable Dynamic Action Interface
- + Added: Populate Request Tab Values checkbox to HTTP Dynamic Action
- + Improved: Performace whlie working with large objects tree (copy, paste and clone)
- + Improved: Directory monitor network issues hadling
- + Added: 'Please Select Connection' message to all SQL Related Dynamic Actions
- - Fixed: SQL Record To Variables execution bug
- - Fixed: Fixed Directory monitor memory leaks
- - Fixed: Parameter Convertion To Integer Has Failed: ObjectId Bug
- + Added: Reusable scripts
- + Added: UseEmbeddedSQL option to all SQL Related Dynamic Actions
- + Updated: Documentation
- + Improved: Data Preview For Subtransformation Transformation
- + Updated: Report Engine
- + Added: 'Is File' flag to HTTP Dynamic Action Bug
- - Fixed: Case Dynamic Action Bug
- - Fixed: Excel Reader Bug
- - Fixed: Send Email Dynamic Action Bug
- - Fixed: SQL Server Reader Table name with space bug
- - Fixed: Directory Monitor RegX bugs
- - Fixed: Options.ini file update bug
- - Fixed: ODBC Importer taget bug
- + Improved: Agent Stability
- - Removed: unnecessary updates of Options.ini file
- + Added: Format Field Function To XML Writer
- - Fixed: Legacy Export File Selection Bug
- - Fixed: Joiner Transformation Bug
- - Fixed: Sub Transformation copy paste bug
- + Added: Delete completed menu item to log screen
- + Improved: Global variables handling
- + Updated: Report Engine
- - Fixed: '0' value bug
- + Improved: Directory Monitor Logging
- + Improved: Directory Monitor Logging
- - Fixed: XSLT Transformation Dynamic Action bug
- + Improved: Working with variables
- - Fixed: RegX Replace Hint
- - Fixed: Directory Monitor Bugs
- - Fixed: Log Date Bug
- - Fixed: Directory Monitor Bugs
- + Added: Support for python 3.13 and 3.14
- + Added: "Resume Loop" and "Loop Position File" Parameters to Loop Dynamic Actions
- + Improved: Minor Data Transformation Performance boost
- - Fixed: Legacy package actions AV
- - Fixed: POP3 and IMAP4 Reader Bugs
- - Fixed: Joiner Transformation Empty Files Bug
- + Added: #PACKAGE_LOGS# Variable. This variable holds list of log files created by a package
- + Improved: Table Browser Search performace while working with large list of tables
- + Improved: Deleting Objects from Objects Tree
- + Added: Post to MS Teams Channel Dynamic Action
- - Fixed: Minor interface issues
- + Added: Send As HTML option to Post to MS Teams Chat Dynamic Action
- - Fixed: Joiner Transformation Empty File Bug
- + Updated: Post to MS Teams Chat Dynamic Action
- - Fixed: IMAP4 Loop Dynamic Action cache bug
- + Added: Select MS Teams Chat Dialogue
- - Fixed: Minor interface issues
- + Added: Added Dynamic Action Icons to Management Console
- - Fixed: Minor issue with the Round transformation function dialogue
- + Added: 0105 Dynamically create excel sheet based on field value example
- + Added: 0106 Dynamically create excel sheet based on record number example
- + Improved: Office 365 Error Handling
- + Added: Send MS Teams Message Dynamic Action (Expirimental)
- + Added: Mail Folder selection dialogue
- - Fixed: Send Email Dynamic Action Multiple Attachments bug
- + Improved: Attachments Dialogue functionality
- + Added: Has Attachments filter to Check Email Dynamic Action
- + Added: Number Of Attachments variable to Office 365 Email Dynamic Action and IMAP4 Email Dynamic Action
- + Added: Restartable File Loop example
- - Fixed: Amazon S3 Key variable format bug
- + Added: Amazon S3 Key variable to Amazon S3 Upload Dynamic Action
- + Added: Support for Directories to Replace String Dialogue
- - Fixed: Replace String Dialogue bugs
- - Fixed: Fixed Google Spreadsheet reader bugs
- - Fixed: Minor Interface bugs
- - Fixed: JDBC Connection bugs
- - Fixed: HTML Table Reader AV
- + Added: Command Line Parameters Dynamic Action
- + Added: Default Email Footer
- - Fixed: Office 365 Email monitor bugs
- + Added: Send Price List Example
- - Fixed: Send email action BCC issue
- - Fixed: Oracle reader bugs
- - Fixed: Oracle writer bugs
- + Added: Keep Files Dynamic Action
- + Added: Additional Parameters to MongoDB connection
- + Updated: MongoDB client
- + Fixed: Agent OleDb connection bug
- + Added: Replace Variables parameter to SQL Record To Variables Dynamic Action
- + Added: Replace Variables parameter to SQL To Variables Dynamic Action
- + Fixed: ODBC DSN Installation Issue
- + Fixed: Validator UI Bug
- + Fixed: Minor Validator and Transformer UI bugs
- + Added: Option to Select MS SQL Server OleDb Provider to Repository Connection
- + Added: 2006 Secure FTP Delete example
- + Added: 2007 Check and log CRC
- - Fixed: BIGINT Field Issue
- + Added: #FileFound# variable to Check File Dynamic action
- + Added: ID field to Search dialogue
- + Added: #LogDirectory# variable
- + Updated: Backup Repository Example
- - Fixed: Minor Interface Bugs
- - Fixed: Minor Interface Bugs
- - Fixed: Joiner AV
- + Added: File Crc Dynamic Action
- + Added: String To Crc Dynamic Action
- + Added: Concatenate options to groupper transformation
- + Added: Google Gemini AI PDF Processing example
- - Fixed: Encode Base 64 Package Action Bug
- - Fixed: Load Variable Package Action Bug
- - Fixed: Object Library bugs
- + Improved: Round transformation functionality
- - Fixed: Import script AV
- - Fixed: Lookups bugs
- + Added: Google Gemini AI Chat example
- + Added: Encode Base64 Dynamic Package Action
- + Added: Decode Base64 Dynamic Package Action
- + Added: Get JSON Array Value Action
- + Updated: HTTP Dynamic Package Action Functionality
- - Fixed Agent Logging Issues
- - Fixed: Minor interface bug fixes and tweaks
- - Fixed: Excel Date write bug
- - Fixed: Transformation copy/paste bug
- + Added: ChatGPT Files cleanup example
- + Added: ChatGPT Assistants cleanup example
- + Updated: ChatGPT chat example
- - Fixed: Telegram Connection dialogue bug
- + Added: Word wrap option to text editors
- - Fixed: Minor interface bug fixes and tweaks
- + Added: Count Delimited Values Transformation Function
- + Updated: ChatGPT example
- + Updated: Hidden Save button within Sub Transformation screen
- - Fixed: Spelling mistakes
- - Fixed: Get JSON Object Property Dynamic Package Action bug
- + Added: ChatGPT Examples
- + Added: String To JSON Dynamic Package Action
- + Added: JSON To String Dynamic Package Action
- + Added: Get JSON Object Property Dynamic Package Action
- + Added: Set JSON Object Property Dynamic Package Action
- + Added: JSON Array Loop Dynamic Package Action
- + Added: JSON Object Loop Dynamic Package Action
- + Added: Timeout parameter to HTTP Dynamic Package Action
- + Added: Count String Transformation function
- + Updated: Demos
- + Updated: Renamed Save Variable Dynamic Package Action to Save String
- - Fixed: Transformation tabs bug
- - Fixed: HTTP Dynamic Package Action file upload bug
- - Fixed: FTP Upload bug
- - Fixed: Validation creation bug
- + Improved: Input and Output objects automatic positioning
- - Fixed: Transformation creation bug
- + Added: Support for Windows Arm (Experimental)
- + Improved: Sub transformation test data support
- - Fixed: Undo/Redo bugs
- - Fixed: Search bugs
- - Fixed: Sub transformation bugs
- + Improved: Transformation Dialogs were made resizable
- - Fixed: SQL to Text action Bug
- + Added: Ability to delete transformation links by clicking the output button.
- + Improved: Removed unused buttons in Data Browser, Lookup and Freehand SQL screens
- MAJOUR RELEASE
- + Added: Dynamic Package Action Demos
- + Added: Template option to Excel Writer
- + Added: Log Tab to Dynamic Package Actions
- + Added: Debug Logs are saved into separate subdirectory
- + Added: Editor to variables
- + Added: Log sorting
- + Added: Incremental search to log
- + Added: Text wrap to package notes
- + Added: Ctrl+A to Notes/Text editor
- + Added: Automatic positioning to user User input dialogue
- + Added: Variables are saved into two separated logs: before and after action execution
- + Improved: Import script logging
- + Improved: Transformation script logging
- + Improved: Log viewer shows action name in the title
- + Removed: "Line No" Field from Package debug log
- - Fixed: RabbitMQ Dialogue Header bug
- - Fixed: IMAP4 Folder selection bug
- - Fixed: Office 365 Folder selection bug
- + Added: HTTP Dynamic Package Action
- - Fixed: Report Parameters Refresh Bugs
- + Added: Select Value Dynamic Package Action
- + Added: Prompt Type to User Input Dynamic Package Action
- + Improved: Dynamic Actions Columns are Autosized now
- + Added: Clone package action to package designer
- + Added: Support for Dynamic Package Actions to Search Parameters Dialogue
- + Added: Support for Dynamic Package Actions to Replace Wizard Dialogue
- + Added: Support for Dynamic Package Actions to Find String Dialogue
- + Added: Support for Dynamic Package Actions to Used By Dialogue
- + Added: JPEG Quality option to Report Dynamic Package Action
- + Improved: Package drag and drop
- + Added: Hide Legacy Actions option to Options dialogue
- + Improved: Double click on variable disables/enables it (Dynamic Package Action Dialogue)
- + Improved: Double click on Package Dots removes links now
- + Added: Replace variables option to Show Message and Ask Question Dynamic Package Actions
- + Added: Insert File Name option to Text Editors
- + Added: Directory Name option to Text Editors
- + Added: Insert File Context option to Text Editors
- + Added: Incremental search to Dynamic Package Actions Editors
- - Fixed: Office 365 Email Bug
- + Added: Case Dynamic Package Action
- - Fixed: Split RegX Static Bug
- + Added: SQL To Text Dynamic Package Action
- + Added: SQL To Insert Dynamic Package Action
- + Added: SQL To XML Dynamic Package Action
- + Added: SQL To QVD Dynamic Package Action
- + Added: SQL To QVX Dynamic Package Action
- + Added: SQL To Excel Dynamic Package Action
- The total number of Dynamic Package Actions is 120 now
- + Added: Script Dynamic Package Action
- + Improved: Report Dynamic Package Action Dialogue
- + Improved: Set Variables Dynamic Package Action Dialogue
- + Improved: Round property functionality
- - Fixed: Empty fields list bug after report preview
- + Added: Cloud Data Browser Dialogue
- + Added: Cloud Download Dynamic Package Action
- + Added: Cloud Upload Dynamic Package Action
- + Added: Cloud Create Directory Dynamic Package Action
- + Added: Cloud Delete Directory Dynamic Package Action
- + Added: Cloud Delete Files Dynamic Package Action
- + Added: Cloud Files List Dynamic Package Action
- + Improved: Cloud Components Update
- + Added: OleDb Manager Button to the Repository Creation Wizard
- + Added: Amazon S3 Data Browser Dialogue
- + Added: Azure Blob Data Browser Dialogue
- + Added: ODBC Manager Button to Application Options Dialogue
- + Added: OleDb Manager Button to Application Options Dialogue
- + Added: Amazon S3 Download Dynamic Package Action
- + Added: Amazon S3 Upload Dynamic Package Action
- + Added: Amazon S3 Create Basket Dynamic Package Action
- + Added: Amazon S3 Delete Basket Dynamic Package Action
- + Added: Amazon S3 Delete Files Dynamic Package Action
- + Added: Amazon S3 Files List Dynamic Package Action
- + Added: Azure Blob Download Dynamic Package Action
- + Added: Azure Blob Upload Dynamic Package Action
- + Added: Azure Blob Create Container Dynamic Package Action
- + Added: Azure Blob Delete Container Dynamic Package Action
- + Added: Azure Blob Delete Files Dynamic Package Action
- + Added: Azure Blob Files List Dynamic Package Action
- + Improved: Round property functionality
- + Added: Added FTP Browser dialogue
- - Fixed: Empty fields list bug after report preview
- - Fixed: SMTP Package Action bugs
- - Fixed: Open dialogue default extension bug
- - Fixed: Report Builder missing components bug
- - Fixed: Import Script Dynamic Package Action logging bug
- - Fixed: XSLT Transformation Dynamic Package Action bug
- + Added: Added Edit button to Select Connection dialogue
- + Added: Added Edit button to Select Object dialogue
- + Added: Office 365 Email Loop Dynamic Package Action (Experimental)
- + Added: Office 365 Email Action Dynamic Package Action (Experimental)
- - Fixed: Copy paste Dynamic Package Actions bug
- + Added: IMAP4 Email Loop Dynamic Package Action
- + Added: IMAP4 Action Dynamic Package Action
- + Added: Check Email Message Dynamic Package Action
- + Added: Extract Email Attachments Dynamic Package Action
- + Improved: SMTP Package Action Performance
- + Added: Set Variables Dynamic Package Action
- - Fixed: Database Loop Dynamic Package Action missing values issue
- + Improved: Lookup Edit Dialogue was made resizable
- + Added: Check Regular Expression Dynamic Package Action
- + Added: File To Variables Dynamic Package Action
- + Added: File Line To Variables Dynamic Package Action
- + Added: Database To Variables Dynamic Package Action
- + Added: Database Record To Variables Dynamic Package Action
- + Added: Up Loop Dynamic Package Action
- + Added: Down Loop Dynamic Package Action
- + Added: File Loop Dynamic Package Action
- + Added: Files Loop Dynamic Package Action
- + Added: Database Loop Dynamic Package Action
- + Added: Application name to Registration Dialogue and Trial Expired message
- + Added: Load Variable Dynamic Package Action
- + Added: Save Variable Dynamic Package Action
- + Added: Delete Variable Package Action
- - Fixed: Report desigher hotkey issue
- - Fixed: Report creation wizard bugs
- - Fixed: Multiple Level Loop execution bug
- + Improved: Excel Operation Package action error handling
- + Added: Reset Report Designer button to options dialogue
- + Added: DayOfTheMonth script function
- + Improved: Reports can now use images from the web
- + Improved: Backup Repository Dynamic Package Action Error Handling
- + Improved: Transformation Error Handling
- + Improved: Code editor interface
- - Fixed: Variable Selection bug for Dynamic Package Actions
- + Improved: Execution Agent Timeout Handling
- + Added: Encript Dynamic Package Action
- + Added: Decript Dynamic Package Action
- - Fixed: SFTP List Sorting
- + Improved: FTP/SFTP logging
- + Added: FTP Download Dynamic Package Action
- + Added: FTP Upload Dynamic Package Action
- + Added: FTP Create Folder Dynamic Package Action
- + Added: FTP Delete Folder Dynamic Package Action
- + Added: FTP Delete File(s) Dynamic Package Action
- + Added: FTP Files List Dynamic Package Action
- + Added: FTP Rename File Dynamic Package Action
- + Added: FTP Move File Dynamic Package Action
- The total mumber of Dynamic Package Actions is 63.
- + Added: Copy File(s) Dynamic Package Action
- + Added: Move File(s) Dynamic Package Action
- + Added: Rename File Dynamic Package Action
- + Added: Delete File(s) Dynamic Package Action
- + Added: Merge File(s) Dynamic Package Action
- + Added: Change File(s) Dynamic Package Action
- + Added: Files List Dynamic Package Action
- + Added: Replace String Dynamic Package Action
- + Added: Open File Dynamic Package Action
- The total mumber of Dynamic Package Actions is 55.
- + Added: Excel Merge Files Dynamic Package Action
- + Added: Check Folder Dynamic Package Action
- + Added: Create Folder Dynamic Package Action
- + Added: Delete Folder Dynamic Package Action
- + Added: Clear Folder Dynamic Package Action
- + Added: Copy Folder Dynamic Package Action
- + Added: Move Folder Dynamic Package Action
- + Added: Excel Check If Sheet Exists Dynamic Package Action
- + Added: Excel Delete Sheet Dynamic Package Action
- + Added: Excel Add Sheet Dynamic Package Action
- + Added: Excel Rename Sheet Dynamic Package Action
- + Added: Excel Check File Dynamic Package Action
- + Added: Excel Change Extension Dynamic Package Action
- + Added: Excel Read Cell Value Dynamic Package Action
- + Added: Excel Set Active Sheet Dynamic Package Action
- + Added: Excel Keep Sheet Dynamic Package Action
- + Added: Excel List Sheets Dynamic Package Action
- + Added: Excel Set Cell Color Dynamic Package Action
- + Added: Excel Set Cell Value Dynamic Package Action
- + Added: Check License Dynamic Package Action
- + Added: External Application Dynamic Package Action
- + Added: Send Email Dynamic Package Action
- + Added: Compress Dynamic Package Action
- + Added: Decompress Dynamic Package Action
- + Added: Report Dynamic Package Action
- + Added: Report export to microsoft world
- + Added: Passing parameters to report package example
- Total number of parameters is now 104
- + Added: Receive Telegram Message Dynamic Package Action
- + Added: Send Telegram Message Dynamic Package Action
- + Added: Receive Message Apache Kafka Dynamic Package Action
- + Added: Send Message Apache Kafka Dynamic Package Action
- + Added: Compare Files Dynamic Package Action
- + Added: Change Encoding Dynamic Package Action
- + Added: Publish Tableau File Dynamic Package Action
- + Added: User Input Dynamic Package Action
- + Added: MIME Extract Dynamic Package Action
- + Added: Twitter Dynamic Package Action
- + Added: Send Message Rabbit MQ Dynamic Package Action
- + Added: Receive Message Rabbit MQ Dynamic Package Action
- + Added: XSD Validation Dynamic Package Action
- + Added: XSLT Transformation Dynamic Package Action
- + Added: Send SMS Dynamic Package Action
- + Added: File Meta Data Dynamic Package Action
- + Added: Check Disk Space Dynamic Package Action
- + Added: Check Connection Dynamic Package Action
- + Added: Check Date Dynamic Package Action
- + Added: Backup Repository Dynamic Package Action
- + Added: Clear Log Dynamic Package Action
- + Added: Ping Server Dynamic Package Action
- - Fixed: Unpivot group duplication bug
- + Added: SQL Data Check Dynamic Package Action
- + Added: SQL Script Dynamic Package Action
- + Improved: Dynamic parameters error handling
- + Improved: Disabled Static parameters
- - Fixed: Empty Email Body line bug
- - Fixed: Create new file preview bug
- + Added: Package Dynamic Package Action
- + Added: Block Transformation Dynamic Package Action
- + Added: Check Directory Dynamic Package Action
- + Added: Check File Dynamic Package Action
- + Added: Import Script Dynamic Package Action
- + Added: Transformation Dynamic Package Action
- + Added: Show Message Dynamic Package Action
- - Fixed: AV when openning Script Package Action
- + Added: Ask Question Dynamic Package Action
- + Improved: HTTP Post package action error handling
- + Added: Replace function to Report Designer
- + Added: Crossjoin example
- - Fixed: Missing label loop package action Bug
- - Fixed: Autoformat Excel Bug
- + Added: On loop end action to loop package action
- BREAKING CHANGE: PLEASE CHECK THE PACKAGES WITH LOOP ACTION
- + Improved: Parsing python parameters
- - Fixed: Writing to multiple excel tables bug
- - Fixed: Writing to hidden excel sheet bug
- + Added: Ability to Embed PDF files into Report
- + Added: Combo Box Report Object
- + Added: List Box Report Object
- + Added: Gauge Report Object
- + Added: Gauge Interval Report Object
- + Added: ZIP Code Report Object
- + Added: Table Report Object
- + Added: Map Report Object
- + Added: Cellular Text Report Object
- + Added: HTML Report Object
- + Added: Export to PNG files
- + Added: Export to JPEG files
- + Added: Export to TIFF files
- + Added: Export to SVG files
- + Added: Export to ZPL files
- + Added: Export to PS files
- + Added: Export to PPML files
- + Improved: Documentation Update
- + Improved: Various minor bug fixes and improvements
- + Improved: Copy fields writer functionality
- + Added: Clear table option to excel import
- - Fixed: Data sorter bug
- - Fixed: Data writer errors
- + Improved: Set Field size to 1024 chracters for sorter, groupper, pivot and unpivot transformation objects
- - Fixed : Report designer bug
- + Added: Variable
- to Cloud storage action
- + Improved: Expanded Cloud storage directory list format
- + Improved: Cloud strorage connection data entry validation
- - Fixed : Google drive connection bug
- - Fixed : Open Report bug
- + Added : "Select Value" package action
- + Added : "0103 Delete old FTP Files" example
- - Fixed : Import Script bugs
- - Fixed: Excel writer bugs
- + Added: "Added clear directory" option to File operation package action
- + Added: Support for Excel tables
- + Improved: Working with excel files ranges
- + Added: Default variable to "Create New File" transformation function
- - Fixed: Create New File transformation function AV
- + Added: "HTML Table" data writer target
- + Added: Example for "HTML Table" data writer target
- The total number of examples is 101 now
- + Added: "Create New File" transformation function
- + Added: Example for "Create New File" transformation function
- The total number of examples is 100 now
- - Fixed : Schedule creation bug
- + Added : "0098 Creating HTML Table" example
- + Added : "0099 Creating Beatiful HTML Table" example
- The total number of examples is 99 now
- + Added : "Use # for variables" option to Lookup package action
- - Fixed : Schedule creation bug
- - Fixed : Fixed autoformat grid bugs
- - Fixed : Lookup Contains transformation function case sensitive bug
- + Improved: "Lookup RegEx" and "Lookup Contains" transformation functions functinality
- + Added: Open file button to Lookup dialogue
- + Added: Support for multiple excel files to block transformation
- + Added: "Lookup RegEx" and "Lookup Contains" transformation functions
- + Improved: "Check Date" Functionality
- + Added: Ability to select mask or RegEx Directory Monitor dialogue
- (BREAKING CHANGE, PLEASE UPDATE DIRECTORY MONITOR SETTINGS)
- + Added: "Custom icon" support to External Application package action
- + Improved: "Fields Order" Error Handndling
- + Added: "Headers" option to send email package object
- + Added: "
- " variable to send email package object
- + Added: "ReplyTo" option to send email package object
- + Added: "
- " variable to send email package object
- + Improved: "Fields Order" transformation object interface
- + Improved: License server error handling
- + Added: "Fields Order" transformation object
- + Added: Support for mutiple variables to Package Loop Action
- + Added: Execution was stopped by the user to Package designer
- + Added:
- and
- variables
- + Improved: Setup logging
- - Fixed: Set Variables Package action delimited file handlinng bug
- + Improved: Set Variables Package action delimited file handlinng
- + Improved: String delimiter handling
- + Added: Delimiter, Text Qualifier, Skip Empty Values and Ignore Duplicates options to Accumulate Strings transformation function
- + Added: Log Events option to Directory monitor
- + Added: Support for Regular expressions to Directory monitor
- - Fixed: Issues with viewing/editing very large numbers (MySQL, Postgress, Interbase/Firebird and SQLite)
- - Fixed: Print preview issues
- - Fixed: Multitab search issues
- + Improved: Print preview dialogue is closed on ESC
- - Fixed: Data Preview Hint Problem
- + Updated: SSH components
- + Added: "Search In Subdirectories" option to Directory Monitor
- + Improved: Case transformation function functionality
- - Fixed: Issues with reading Excel files
- + Added: "Proper Name" option to Format Fields dialogue
- + Improved: Groups handling of UnPivot dialogue
- + Updated: Excel components
- - Fixed: Automap feature of Union all dialogue
- - Fixed: Backup/Restore bugs (MySQL only)
- + Added: Automap button to Union all dialogue
- + Updated: Repository creation scripts
- - Fixed: Minor transformation interface bugs
- - Fixed: Minor block transformation interface bugs
- + Added:
- variable to Check File Package Action
- + Added: Processing Web hook data example
- - Fixed: Split Dialogue AV
- + Added: XSD Validator package action
- - Fixed: SQLite data reader bug
- - Fixed: HTTP Post package action bug
- + Improved: Workinng with JSON Pairs
- + Added: File operation Open File option works with mask now
- + Added: Open File option to File operation package action
- - Removed: TelAPI SMS Support (The company no longer exists)
- + Updated: Excel Sheet option to Report Package Action
- + Updated: Third party components
- + Added: Set Cell Color option to Excel File operation package action
- + Added: Replace option to File operation package action
- + Updated: Excel components
- + Added: Search String option to File check package action
- + Added: Refresh Tables list menu item to Table Browser dialogue
- + Added: Write Variables option to all Package Actions
- + Updated: Documentation
- - Fixed: Package Action dialogue bug
- - Fixed: Minour interface issues
- + Added: Keep sheet and List sheets option to Excel Package action
- + Improved: Block transformation combine step interface
- + Improved: Lookup transformations error handling
- + Improved: HTTP Post Package action functinality
- - Fixed: Minour Object Tree Bug
- - Fixed: Bug with detaching tabs
- + Added: Support for python versions 3.10, 3.11 and 3.12
- + Improved: Block transformation error hadnling of missing source files
- + 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
- - Fixed: Rotate transformation bug
- - Fixed: Block transformation AV
- - Fixed: Block transformation double writing of Excel files
- + Improved: Block transformation progress bar position
- 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.html
- + Added: Ignore nulls and keep original values option to Excel Writer
- + Improved: Calculation engine update
- + Improved: Openning objects from find string dialogue
- + Added: "Abort when no data found" checkbox to Export Package Action
- + Improved: Openning objects from Schedule tab
- + Improved: Openning objects from search dialogue
- + Improved: Components update: SSL, SSH, SFTP, MySQL, Postgre, SQLite, Interbase/Firebird
- + 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
- + Added:
- ,
- ,
- ,
- variables to File metadata package action
- + Added: 0089 Convert all XML files in a directory example
- - Fixed: MS Access Repository structure
- + Added: Incremental search to Expression editor dialogue
- - Fixed: Issues with inserting default values within the data grid. (MySQL, Postgress, Interbase/Firebird and SQLite)
- + Improved: Added timeout hint to schedule dialogue
- + Improved: Logging fro send email package action
- + Improved: Copy and clone functionality
- + Improved: SFTP working with private keys
- - Disabled: ODATA Connection as no longer necessary
- + Improved: Ofiice365 Email monitor check for new emails only
- + Added: Dynamic pivot example
- + Added: User defined fields to properties dialogs
- + 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
- - Fixed: File is locked bug
- + Added: Ability to save packages and transformations as bmp files
- + Added: Office 365 connection cache
- - Fixed: Office 365 email memory leak
- + Added: User Input Package Action
- + Added: Default Application Platform to options dialogue
- + Improved: Increased maximum number of Office 365 email folders to 250
- + Improved: Repository Synchronization Wizard error handling
- + Improved: Variables Logging handling
- + Improved: aetlcl.exe error handling
- + 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
- + Added: How to embed picture into email demo
- - Fixed: Removed insert image button from Send email action dialogue
- + Improved: Updated documentation link
- + 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
- + Improved: Excel Operation Action working with mask
- + Improved: Ping package action error handling and logging
- + Improved: Reduced SQL Server connection timeout to 20 seconds for check connection package action
- + Added: Timeout to Ping package action
- - Fixed: Issues with showing lookup data
- - Fixed: Issues with package execution default result
- + Improved: Increased Data writer fields' dedifintions widths
- - Fixed: Field is not mapped issue
- + Added: Write Variables Check Box to options dialogue
- + 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
- + Added: Rest Writer
- - Fixed: ExecuteObject Failure - Index Out of Bounds
- - Fixed: Office 35 Email Writer AV
- - Fixed: UID was missing from Office 35 Email Reader
- + Added: Office 35 Email Writer
- + Added: Office 35 Email Reader
- - Fixed: Incorrect
- variable date format
- + Added: Office 365 Email monitor
- + Improved: Office 365 connection dialogue error handling
- - Fixed: Issue with deleting nodes on maintain tab
- + Added:
- variable
- + Renamed: "Split RegX" to Split RegX Static
- + Added: Split RegX Dynamic transformation function
- + Improved: Office 365 email logging
- - Fixed: Issue with reading Office 365 email folders list
- + Improved: Schedule sorting
- - Fixed: Issue with Replace RegX transformation function
- + Added: Do not create empty files option to Export Package Action
- - Fixed: Viewing Views Issues while browsing the data
- + Improved: Loading data into smalldatetime fields
- - Fixed: Missing DLL's
- - Fixed: AV when adding new field to Joiner properties dialogue
- - Fixed: Databuffer double procession bug
- - Fixed: Issues with autosaving Import script changes
- + Added: Appache Kafka connection
- + Added: Receive Appache Kafka message action
- + Added: Send Appache Kafka message action
- + Added: User name to log file name
- + Improved: Report Package Action generator embeds fonts by default now
- + 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
- + Added: Support for dynamic field names (delimited files only)
- + Added: Support for RabbitMQ to data writer and reader
- + Added: Out parameters to reports
- - Fixed: Issue with running Oracle SQL scripts from SQL script screen
- - Fixed: Is value In Database transformation function bug
- + 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
- + Improved: Note's custom colours are persisted across user sessions
- + Improved: Package Note's can be added to the object library now
- + 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
- - Fixed: IMAP4 and POP3 AV
- + 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
- + Added:
- variable
- + Added: Search string dialogue to the objects tree
- + Improved: Third party components update
- - Fixed: Installation Issues
- + Added: Ability to ignore missing files to file operation
- + Added: Search properties dialogue to package designer
- + Improved: Replace dialogue functionality
- + Improved: Excel components update
- - Fixed: Issues with long month names
- + Improved: FTP Error handling
- + Improved: XML Reading performance
- - Fixed: XSLT Transformation Action variable inside file name bugs
- + Added: Added Parent field to search dialogue
- - Fixed: Issues with saving email attachments
- - Fixed: Issues with reading windows event log
- - Fixed: Minor Issues with logging
- + 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
- + 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
- - 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
- + 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
- - Fixed: Issues with lookup error handling
- + Improved: All package actions dialogs are resizable now
- + Improved: Email dialogue design
- - Fixed: Issue with multiple semicolons within soap header
- - 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
- + 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
- + 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
- + 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
- + 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
- + 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
- + 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
- - Fixed: Fixed issue with
- package variable
- + 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
- - Fixed: Loading data from FoxPro
- + 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
- + Added: To, ReplyTo, Cc and Bcc fields to POP3 and IMAP4 readers
- - Fixed: Issues with special characters inside SQL Server database names
- + Fixed: Replace String Wizard bugs
- + Added: Popup menu to Replace String Wizard
- + Added: Replace String Wizard
- + Improved: Setup look and feel
- - Fixed: Issues with special characters inside field names
- - Fixed: Access violations while using Get Excel Cell Value Dynamic
- - Fixed: Wrong Package Name variable issue
- + Improved: Execution log refresh behaviour
- + Added: Support Excel formulas creation
- + Improved: Writer SMS connection
- + Improved: SMS connection dialogue
- + Added: Owner field to file system reader
- + Added: Owner variable to file metadata package object
- + Added: FileOwner scripting language function
- + 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
- + Added: Variables:
- ,
- ,
- ,
- ,
- ,
- ,
- + Added: Check License package object
- + Improved: Support for DATETIME2 Fields
- - Fixed: Issues with Azure blob loading
- - Fixed: Issues with running packages using GUI
- - Fixed: Issues with Accumulate String transformation function
- - Fixed: Issues with reading JSON objects
- + Improved: Support for DATETIME2 Fields
- + Improved: Software registration process
- - Fixed: Issues with Australian Post Code validation
- + Improved: JSON Data Handling
- + Added: Support for SQL Server 2017
- - Fixed: Issues with loading data into varchar(max) field
- - Improved: SQL Server error handling
- + 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
- + 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
- + Added: colours to notes
- - Fixed: issues with aborting joiner Transformation on error
- - Fixed: issues with deleting the text inside notes
- + Added: Support for PostgreSql 12
- + Added: Ability to delete files after compression
- + Improved: Expanded IMAP4 drop-down box
- - Fixed: Spelling errors
- + 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
- + Added: IMAP4 as data writer connection
- - Fixed: IMAP4 reader shows UID correctly now
- + Added: Support for Telegram Bot API
- + Added: Checks for source and target structure changes
- - Fixed: SplitRegX transformation function bug
- - Fixed: Lookup transformation function bug
- + 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
- + 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
- - 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
- + Added: Case sensitive option to Lookup transformation object
- + Added: Restore project option
- - Fixed: Issues with joining empty files
- + Added: Clear log Action
- + Improved: Loop Action Logging
- + Improved: Set Variable Action
- + Improved: Salesforce connection uses TLS 1.2 now
- - Fixed: Project clone issues
- + 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
- - Fixed: Decode JSON Object and Decode JSON Array error handling issues
- + Added: Syslog data source
- - Fixed: JSON Data reader AV
- + Improved: Excel action can change file extension now
- + Improved: Management Console look and feel
- + Improved: Software Installation Process
- + Improved: Third-Party Components Update
- + Fixed: Minor Python Integration Issues
- + Improved: if registration fails the message is displayed
- + Improved: "Disable Package Actions Variables By Default" is not be enabled by default.
- + 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
- 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
- + Added: Support for calculations inside source reader source file
- - Fixed: Copy/Paste issues with SQL Lookup transformation
- + 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
- + Improved: Slight performance improvement
- + 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
- + Added: Ability to download, upload, delete and create directories to FTP Monitor dialogue
- + 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
- + Improved: JSON null values handling
- + Added: Loading data into Google Spreadsheets
- + Improved: Third-party components update
- + Improved: Directory monitor stability while working with network shares
- - Fixed: FTP Upload Issues
- - Fixed: Issues with loading data into Varchar(MAX) fields (SQL Server)
- + Improved: transformer fields metadata
- + Added: Added Get Excel Cell Value Dynamic transformation function
- + Improved: Object selection visibility
- + Improved: Third-party components update
- - Fixed: Addressed issues with loading data into XML, Image and Identity fields (SQL Server)
- + Improved: Up to two times faster loading data into SQL Server
- - Added: Support for TLS 1.2 SQL Server connections
- + 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
- + 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
- - Fixed: Loading Data Into Time Fields
- - Fixed: Parallel Execution Issues
- + Added: ReadMe file to backup
- + Improved: Archive error handling
- + Improved: Setup Process
- + Added: Data Buffer Transformation Function
- + Improved: Transformation Error Handling
- + 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
- + 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
- - Fixed: Round Transformation Function issues
- - Fixed: Issues with exporting very large grids into excel files
- - Fixed: Reader Autoformat issues
- - Fixed: Problems with command line execution
- + Improved: Error handling for open files
- + Improved: Monitors support global variables now
- - Fixed: Package logging issues
- - Fixed: Registration issues
- + Improved: Added writer number to Transformation statistics variables
- - Fixed: Python Scripting issues
- + Added:
- and
- packages variables
- + Improved: Added more demos
- + Improved: Automatically uses the latest version of python installed
- + Improved: Support for python
- + 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
- + 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
- + Added: Package EMail attachment filter
- - Fixed : Loop action issue with adding values
- + Improved : Demos
- - Fixed : #3D000 No database selected issue
- - Fixed : Uploading large files via SFTP
- + Added :
- ,
- ,
- variables
- + Updated : SFTP components
- + Improved: Backup Error handling
- + Improved: Repository Switching
- + Fixed: Various bug fixes and improvements
- - Fixed: Loading data into Google spreadsheet
- - Fixed: Issues with SFTP keys storage
- + Added : Ansi Driver checkbox to odbc connections
- + 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
- - Fixed: Addressed issues with saving connection details (SQL Scripts and Report screen)
- + 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
- + Added: Support for Visual Importer Scripts design and execution
- 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)
- + 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
- - Fixed: Issues with Ping Package Action
- - Fixed: Issues with the management console
- - Fixed: Issues with JSON transformations
- - Fixed: Issues with reading JSON data
- + Added : HTML Editor to Email Action
- + Added: Support for sending embedded images
- + Improved: Pause Package Action
- - Fixed: Issues with non-English repositories
- + Improved: Setup for new users by adding a user to run services
- - Fixed : PGP Encription Action
- + Improved: Management Console
- - Fixed: Issues with reading Brightpearl data
- - Fixed: Issues with assigning default values to lookup
- + Improved: Functionality of Running totals transformation function
- + Added: Content type to SOAP action
- + Improved : SOAP action dialogue
- + Improved : Multiline select statement execution
- - Fixed: Issues with Copy/Paste functionality
- - Fixed: Issues with FTP downloads
- - Fixed: Azure backup Issues
- + Improved: Open SSL libraries update
- + Improved: Up to 30 per cent faster
- + Improved: 64-bit setup installs MS Access Ole DB provider automatically
- 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
- + Added: Support for SFTP Private Keys
- - Fixed: Issues with QVX Files reading
- + Added: Paste functionality to target definitions (writer fields grid)
- - Fixed: Issues with version control
- - Fixed: Issues with loading version info
- - Fixed: Tableau Datetime fields processing issues
- - Fixed: MySQL Server Repository Creation Scripts issues
- - Fixed: Repository backup issues
- - Fixed : HTTP Form post-action issues
- + Added: Tableau Server Connection
- + Added : Publishing Tableau TDE Files
- + Improved: Updated Tableau Client
- - Fixed: Fixed QVD reading issues
- 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
- + Improved: Setup has an option to download Tableau client now
- + Added : SQL Lookup Transformation Function
- - Fixed : Scrolling issues
- - Fixed : Change date dynamic bug
- - Fixed: Issues with About Dialogue
- - Fixed: Issues with Registration Dialogue
- + Improved: Setup procedure
- - Fixed: Issues with loading version info
- + Improved: Maximum ODBC Connection String is 4K now
- - Fixed: One Row QVD creation bug
- - Fixed: Issues with system variables
- - Fixed: Issues with services installation
- + 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
- + Improved: Updated Salesforce API to v38
- - Fixed: Addressed issues with log refresh
- + 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
- + Improved: Schedule dialogue allows to enter multiple lines now
- - Fixed: Issues with MySQL Repository
- - Fixed: Issues with refreshing logs
- + Added : FTP Files list as data source
- + Added : Object Dependency search
- - Fixed: Issues with updating data via table browser
- + 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
- + Added: Support for SFTP V06
- + Added: Table generation option to writer grid
- - Fixed: Issues with reading data from SalesForce
- + Added: Excel Operation action
- + Added: Option to disable record count
- + Improved: Once deleted packages are disabled in the scheduler
- - Fixed: Fixed issues with reading XML files
- + Improved: Up to 10 percent performance increase while loading data into date/time fields
- + Added:
- and
- variables
- + Improved: Support for JSON as data source
- + 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
- + 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
- + Improved: Global variables handling for Reports
- - Fixed: BDE Datasource issues
- + Improved: MySQL Error handling
- + Improved: Global variables handling
- + 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
- - Fixed: Problems with clone row transformation object
- + Added: Execute One Action at the time option
- - Fixed: Problems with reading data from Salesforce
- - Fixed: Problems with refreshing list of Oracle Tables
- - Fixed: Problems with AM/PM Date conversion
- - Fixed: SFTP Rename issues
- + Improved: JDBC Processing
- - Fixed: Problems with version control
- + Improved: JDBC Errors Handling
- - Fixed : Problems with Soap Package Action Parameters
- - Fixed : Agent stability issues
- + New : Keep-Alive option to FTP Dialogue
- + Improved: status bar formatting for FTP operations
- - Fixed: Problems with reading data from Unicode files
- - Fixed: Problems with command-line execution
- - Fixed: Agent stability issues
- + 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
- - Addressed data compression issues
- + Added support for aes192-cbc,aes192-ctr,aes256-cbc,aes256-ctr encryption to FTP connection dialog
- + Added support for aes192-cbc,aes192-ctr,aes256-cbc,aes256-ctr encryption to FTP client
- + Added
- variable
- - Address issues with Change Date Static, Change Date Dynamic and If WeekDay functions
- - Addressed Salesforce data update issues
- - Addressed Salesforce data update issues
- + Improved support for RSS feeds
- + Calculation transformation function support Python now
- - Addressed issues with Running Total transformation
- + Support for the latest tableau API was introduced
- - Log Object bugs fixes
- + Added Write to the File transformation function
- - Minor bug fixes
- + Minor transformation designer improvements
- + Script Package action support for Python was introduced
- - Package designer bugs fixes
- - Date fields processing bugs fixes
- - Agent stability improvements
- - Joiner Object bugs fixes
- - SalesForce data processing fixes
- - Addressed DTD is prohibited issues
- - Addressed email processing problems
- + PDF Report quality improvements
- + 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
- - Scheduler bug fix
- + Improved support for very large QVD files
- + Added ability to filter incoming messages by Recipient, CC and BCC to package actions
- - Addressed Date validation and conversion problems
- + SSL Libraries update
- + Third party components update
- + SalesForce connection uses TLS 1.1 now
- - Addressed issues with IMAP4 package action
- + Uses tableau API 9.2 now
- - Addressed issues with a print preview screen
- - Addressed issues flicking
- + 64-bit version initial release
- + Added MRU List to data entry grid
- + Error handling improvements
- + 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
- + 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
- - Addressed issues with downloading files via HTTP/HTTPS
- - Addressed issues with creating Excel files
- + Added option to save all objects into text files
- + Added option to check network share free space
- + 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
- + 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
- - Addressed issues with downloading files via HTTP/HTTPS
- + Faster QVD files processing
- - Addressed issues with variables
- + 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
- + Third-party components update
- + Reduced memory usage for QVD files processing
- - Addressed issues with FTP list action
- - Addressed issues with File merge action
- - Addressed issues with Clone row object
- + Better support for QVD's Timestamp and Date fields
- - Addressed issues with union and sorter objects
- - Addressed issues with Loop package action
- - Addressed issues with sub transformation function
- + 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
- + Added Check Directory Package action
- + Extended reader and writer variables support
- + Added support for variables to Joiner object
- + Added Lookup Replace Transformation function
- - Addressed issues with Running Totals functions
- - Addressed issues with joining empty files
- + 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
- - Addressed issues with loading empty date fields into MySQL
- - Addressed issues with Split Transformation Function
- + Smaller Executable
- + Updated regular expression Engine
- + Added Replace RegX and Split RegX transformation functions
- + Added Field Value transformation function
- + 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
- + Added Read File Content Option to Reader
- - Addressed issues with File Creation Dates
- - Addressed issues with Log screen
- + Added FileLine transformation function
- - Addressed issues with Loop package action
- - Addressed issues with adding objects to the library
- - Addressed issues with deleting objects from the library
- + Added Save button to Transformer and Validator
- - Addressed issues with Slemma Import
- - Addressed issues with Loop package action
- + Added support for Clarion dat files
- + Added support for Twitter
- - Addressed issues with sending emails with attachments
- - Addressed issues with sorter
- + All documentation is in wiki format now
- - Addressed issues with starting multiple packages at the same time
- + Added support for Slemma
- + Excel Import and export form data grids is much faster now
- - Addressed issues with exporting data as excel from data grids
- + 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
- + Added Encode JSON String and Decode JSON String
- - Addressed issues with deduplication
- + Added trim option to format field names dialogue
- + Updated set fields' names functionality
- - Management console fixes
- + Extended Date Diff functionality
- + 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
- - IMAP4 and POP3 fixes
- - Various bugs fixes and improvements
- + Support for salesforce BULK API was introduced
- + Report builder version update
- - Various bugs fixes and improvements
- - Addressed issues with loading null values into salesforce
- - Addressed issues with loading data from SQL Server CE
- - Addressed issues with loading data from delimited files
- - Addressed issues with grouper transformation
- - Various bugs fixes and improvements
- + Documentation update
- + Added GetExcelCellValue calculation function
- + Sorter improvements
- + Improved performance of Join Transformation.
- + Updated version of Report Editor
- - Addressed issues with memory management
- - Addressed issues with Is Number validation function
- + Added ability to swap reader and writer
- + Added support for 255 length fields names in Union All object
- + GetExcelCellValue function provides more detailed information about errors now
- - Addressed issues with retrieving information about Primary keys
- - Addressed issues with parallel sorting
- + Added ability to delete and insert items in the middle of Split, Join and calculation object
- + Added email notifications functionality to execution agent
- + Documentation update
- - Addressed issues with date fields processing
- - Addressed issues with the processing of delimited files
- - Addressed issues with date formats
- + 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
- + 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
- + 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
- + Added ability to lock the objects
- - Addressed issues with processing empty excel files
- - Addressed problems with validator data preview
- - Addressed problems with reading google spreadsheet data
- - Addressed Transformer AV's
- - Addressed issues with stopping the agent
- + 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
- + Up to 10 percent faster text file processing
- - Addressed issues with processing end of line characters inside delimited files
- + Up to 7 times faster data sorting
- - Addressed issues with salesforce data processing
- - Fixed problems with data preview
- - Various bug fixes and improvements
- - Addressed issues with creating rejected records file
- - Addressed issues with running ODBC Manager from the application
- + SSL libraries update
- - Various bug fixes and improvements
- 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
- + 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
- - Addressed issues with sequence transformation object
- - Addressed issues with sub transformation object
- - Addressed issues with sending SMS messages
- - Addressed issues with the theme management
- - Loads recent history of changes by default now
- (Full history is too big and slows down the application)
- - Addressed issues with a metadata object
- + Added Vertical Grid
- + Third-party components update
- - SFTP rename bug fix
- - Table Editor bug fixes
- + 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
- - Addressed issues with GetExcelCelValue transformation function
- + Setup and executable are digitally signed now
- - Minor bugs fixes
- + Added Reset height option
- - Updated repository creation scripts
- + Up to 10 percent faster
- + Check File Action has new option: Check if file is in Use
- + Licence Update
- + Documentation Update
- + Changed the way parameters are passed into reports
- + Documentation update
- - Addressed issues with XML encoding
- - Addressed some validator issues
- + 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
- + 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
- + Added support for tableau tde files
- + Loop Package Action improvements
- + 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
- + Setup Update
- + Added Loop Package Action
- + Added Create a list of files option to File Operation Package Action
- - Addressed Splitter dialogue issues
- + Added new transformation field values
- + Documentation Update
- - Addressed Salesforce connection dialogue issues
- + Documentation Update
- - Addressed SFTP bugs
- + Added two new fields to File System Datasource last modification date and last access date
- + Minor interface improvements
- + Added Hide Template Tab option
- + Better report error handling
- - Report generator bugs fixes
- - Report generator bugs fixes
- + Added Is Null or Empty string validation function
- + Added If Null or Empty string transformation function
- + Documentation Update
- - Mapping editor bug fixes
- - Addressed CASE transformation issues
- - MySQL bugs fixes
- - Bug fixes
- + Added Support for Message Queuing (MSMQ)
- + Documentation Update
- + Run At Agent Start Scheduler option was introduced
- + Better Data Reader Memory Management
- + Support for using variables inside package zip object password was introduced
- + Added GUID function to the scripting language
- + Documentation Update
- - Addressed issues with BIGINT fields
- - Management console fixes
- - Addressed issues with Get Excel Cell Value transformation function
- - Addressed issues with copy-paste functionality
- + New package Object - SMS
- + Documentation Update
- + Interface improvements
- + Further improvements to Sending SMS functionality
- - Date Format bugs fixes
- - Addressed problem with keep characters functions
- + Support for Sending SMS messages was introduced,
- following services are supported: Twilio, BulkSMS, TelAPI and Essendex.
- + PostgreSQL repository scripts corrections
- + Documentation Update
- + 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
- + Interface improvements
- - Addressed issues with CASE transformation function
- + Added CASE transformation function
- + Added Delete Leading Characters
- + Added Delete Trailing Characters
- + Added support for special characters
- + Interface improvements
- + Ability to move objects between different tabs was introduced
- - Subtransformation bugs fixes
- + Introduced support for salesforce QueryAll interface
- + Documentation Update
- - Addressed problems with batch import via ODBC
- - Addressed problems with refreshing logs
- + Excel processing engine update
- + 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
- + Added two new transformation functions Get Excel Cell Value and Get File Context
- + Documentation Update
- + Support for the latest version of Google spreadsheets was introduced
- + List of connections is sorted alphabetically now
- - Minor XML processing fixes
- + Up to 50 percent faster working with QVD files
- + Added Authentication support to HTTP package objects
- - Addressed memory leaks problems
- + Renamed Web Service Lookup to HTTP Post
- + Added HTTP Get Transformation function
- + Documentation Update
- - Web Service Lookup issues were addressed
- - Addressed issues with sending emails with attachments
- + up to 10 times faster data sorting
- - Addressed DD-MMM-YYYY date format issues
- - Addressed issues of loading data from the files with old creation date
- + Smaller Setup
- - Fixed problem with log deletion
- - Agent stability fixes
- - XML and ODBC fixes
- - Agent stability fixes
- - Date Diff function fixes
- + 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
- - Addressed file update problems
- + Added separate application to edit options
- + Added option clear sheet to excel writer
- + Added support for dynamic file names in attachments
- + Up to 5 percent performance increase
- - MySQL date processing bugs fixes
- - Addressed some copy/paste issues
- - MySQL date processing bugs fixes
- - Addressed union object issues
- - Addressed some sub transformation issues
- + Added library of objects
- - Fixed bugs with Copy/Paste of Sub transformation function
- - Addressed issues of loading data from Excel files
- + Added snap to grid option
- + Addded Data Port option to FTP Connection
- - Addressed issues with missing files
- + Tables list refresh is faster now
- + Added RichText object to the Report Designer
- + Added option to set defaults
- + Added option to filter target fields
- - Addressed some SQLite issues
- - Addressed issues with sending emails
- + 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
- + Introduced Management Console
- - Addressed some FTP Package dialogue issues
- + Updated regular expression for US SSN
- + Extended agent logging
- - Addressed issues of loading data from flat files
- - Addressed issues with long object names
- + HTTP Form package object was introduced
- + Documentation update
- +
- ,
- ,
- system variables we added
- - Corrected issues with FTP automation
- + 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)
- - Addressed issues with loading empty Date fields into MS SQL Server
- + 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
- - Corrected issues with processing emails send by IPAD
- - Addressed issues of loading data from flat files
- - Addressed issues of loading data from flat files
- - Addressed some execution agent issues
- + Addressed issues with parallel task executions
- + Added send as HTML option
- - Addressed issues of loading data from flat files
- - Fixed bugs related to loading data into VARCHAR(MAX) fields.
- + Better objects positioning while working with multiple tabs
- + Emails are sent as HTML now
- - Addressed issues with updating data
- + Better handling of large Salesforce tables
- + Support for multiple Salesforce environments was introduced
- - Deduplicator AV fix
- - QVD reading bug fixes
- + 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
- + 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
- + Added option to resize objects selector
- - Addressed some issues of working with default values
- + Added search functionality to transformation editor
- + Added search functionality to package editor
- - Addressed some issues of working with default values
- - Salesforce bug's fixes
- + Better source connection errors handling
- + Salesforce is supported as data-target
- - Addressed more autoformat problems
- + Extended Global variables scope
- - Salesforce bug's fixes
- - Addressed autoformat problems
- - Fixed problem with zip files locking
- - Resolved Synchronization problem
- - Addressed issues with Salesforce processing
- - 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
- + 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
- - Addressed problem with ping object
- + Minor Interface improvements
- - Addressed problems with excel date formatting
- + New datasource HTTP
- + Documentation update
- - Addressed issues with salesforce connection
- - Addressed problems with fixed width files
- - Addressed problems with formatting dates
- - Addressed problems with autoformat option
- - Addressed problems with package variables
- - Corrected problem with FTP progress bar
- - Addressed problems with Datediff function
- + 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
- Up to 20 percent performance increase
- + Up to 70 percent performance increase
- + Further 20 percent performance increase for loading data from text files
- + 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
- 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
- - Addressed some lookup issues
- 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
- + Functionality of Splitter and Get Line functions was improved
- + Documentation update
- - Various bug fixes and interface improvements
- + QVD generation bugs fixes
- + 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
- + Support for the web services was introduced (SOAP)
- - Various bug fixes and interface improvements
- + 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
- + Smaller executable
- + Memory usage was reduced for Excel files
- - Addressed some HL7 issues
- - Various bug fixes and interface improvements
- + Format field name dialogue improvements
- + Datareader minor improvements
- - Addressed Repository Synchronization wizard bugs
- - Various bug fixes
- + Introduced Repository Synchronization wizard
- + Addressed problems with updating Oracle blob fields
- + Addressed some grouper issues
- + HL7 Examples were added
- + Undo/Redo Functionality was improoved
- + Documentation update
- + Compare values function was added
- + Various bug fixes
- + Documentation update
- + 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
- + Added parameter names to calculation object
- - Address ping object issues
- + Added Undo and Redo functionality to the transformation designer
- - Various bug fixes
- + Added support to Redo and Undo to package designer
- + Added Register option to help menu
- + Various bug fixes and interface improvements
- + Added snap to grid to functionality
- + Various bug fixes and interface improvements
- + 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
- + Support for PGP was introduced
- + Interface improvements
- - Various bug fixes
- + Added Keep Characters Function
- + Added Epoch to Date Finction
- + Added Date to Epoch function
- + Interface improvemnets
- + Documentation update
- - Various bug fixes
- + 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
- + New function was introduced ExecuteObject(ObjectId)
- + Documentation update
- - Various bug fixes
- + Support for BDE was introduced
- + Documentation update
- - Various bug fixes
- + Added copy paste functionality to IMAP connections
- + OLE Reports Dialogue is resizable now
- - Various bug fixes
- + Introduced Autocomplete functionality
- - Addressed some issues related to loading data from QVD files
- - Various bug fixes
- + Support for stored procedures as a data target was introduced
- + Performance improvements for MS SQL Server Connection
- + Various Bug Fixes
- + Documentation Update
- + Added option to ignore XML tags between Table tag and Record tag
- + Documentaiton Update
- - Fixed set variables bugs
- - Various bug fixes
- - Repository Scripts fix
- + 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
- + Support for QVD files was introduced
- - Various bug fixes
Need help with an upgrade?
If you are upgrading an older repository, review the repository update notes and test the upgrade on a copy first.