The functionality of FlowHeater has been enhanced with a new and powerful feature: Environment variables can now be used as placeholders for dynamic configuration settings, in addition to FlowHeater Parameters.
If you wish to use environment variables this way, you enclose them in percent signs. For example, by specifying %TEMP% you refer to the TEMP folder defined in your system settings and you could use “%TEMP%\%USERNAME%_export.csv” as a dynamic path and filename for exporting a CSV file in the TextFile Adapter, etc.
Environment variables can be used anywhere you would otherwise use FlowHeater Parameters and of course you can combine them as you wish, e.g. “%TEMP%\$DATUM$_export .csv”.
The AutoID Heater has been extended with a powerful new function. Consecutive numbers (Auto IDs) can now be generated during a series of identical input parameter values. The count is reset with the first different input parameter value and continues to increment until the next change of input value. Unlike the “GroupBy (Heater)” this function does not summarize (group) the records on the WRITE side, but instead outputs them one to one.
Although rare in Oracle field names, when spaces did crop up they were more than irritating, because they prevented the whole table from being read or written with the Oracle Adapter. As of this version field/column names containing spaces are processed normally by the Oracle Adapter. This feature is automatically applied, no configuration change is needed to enable it.
Although the XML Adapter is still in beta, it can already be used to process some XML files. The XML processing is presently limited to relatively “flat” not overly complex XML structures with few child nodes. To illustrate the current possibilities we have assembled some simple XML import/export examples, and further will follow. General example of processing XML files
Aggregation functions Min/MaxWith this version the Min and Max Heaters, each of which determine the lowest or highest value for a record or row, is extended with two powerful new features.
The first of these is an option to determine the lowest or highest value for the entire process of a run, as an alternative to the existing ability to find the lowest or highest of each grouped data set. This makes it possible to add the lowest or highest value in header and footer rows of CSV text files, for example.
The second feature now makes the Min and Max Heaters also capable of delivering the highest or lowest of the FlowHeater data types Date, Time and DateTime. In so doing the Heaters automatically detect the incoming data type and process them appropriately.