This version adds powerful flexibility to the String Split Heater and SubString Heater. The String Split Heater can now optionally index the substrings in reversed sequence, starting with the last substring. In the SubString Heater you are now able to extract substrings enclosed by delimiter strings. Previously it was only possible to extract a substring by specifying a fixed starting position and length within the string.
Improved support for Oracle, MySQL, PostgreSQL and SQLite databases thanks to updated third-party database drivers.
It may be hard to believe, but apparently it happens. A worksheet in MS Excel can be assigned a name consisting of a single space character.
Leaving aside the questions of who makes use of this and whether it makes any sense, the FlowHeater Excel Adapter now functions properly with a sheet named with a space character.
Release notes for version 3.1.0 on May 2, 2013
Multiple Adapter support
A much requested feature has arrived: FlowHeater now supports Definitions with multiple Adapters, significantly advancing its flexibility. On the WRITE side, using the plus sign option over the Adapter section you can add as many Adapters you wish, including those with differing types. For example, it is now possible to setup a Definition that easily performs both an SQL database import and at the same time outputs a CSV report to log the actual data as it is imported by adding an extra TextFile Adapter to the Definition. Or you could use two or more database Adapters on the WRITE side to fork the data and so implement a 1:n database relationship. A further use might be to make use of the automatically generated auto-increment values in a database to assign specific fields across a “secondary” detail Adapter using the FlowHeater default value property.
Release notes for version 3.0.0 on March 16, 2013
New product: Runtime Designer
We were frequently asked: How can I license FlowHeater for runtime use by my clients? Our latest product "Runtime Designer" effectively makes this problem a thing of the past. You can now create Definitions with the Runtime Designer that are fully functional including use of the Batch Module for your clients who only need to download our Freeware Version. In addition, your users can make changes with only mild restrictions to the Definition themselves. However, to protect your development from your clients making unauthorized changes each Runtime Definition is encrypted and password protected.
You will find further information and examples here: Help using Runtime Designer
Oracle Adapter with Direct Connection
The Oracle Adapter has been completely reworked and improved. What is new in this version is that a direct connection to an Oracle database can now be established without the need for a locally installed Oracle client.