Dynamic data import / export


simply more productive
Download full trial Version

Processing text files with user-defined line breaks

The lines in text files are usually either terminated by a two-byte sequence CR LF (0x0D0A) under Windows or by a single byte LF (0x0A) under Linux/Unix or Mac OS X. Both kinds of terminator have previously been supported by the TextFile Adapter. However, the format of text files is occasionally specified differently and an alternative character or sequence of characters are used for the record/row line breaks. The TextFile Adapter now supports freely defined characters for the recognition of line terminators, which means non-standard text files can now be processed in the normal way. Any character or string can be specified as the line terminator.

Continue Reading

Retrieving your system’s environment variables in FlowHeater

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

Continue Reading

AutoID Heater with incremental counter for groups of input values

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.

Continue Reading

Oracle Adapter supports spaces in field names

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.

Continue Reading