Dynamic data import / export

datenbank

simply more productive
Up to 100,000 records can be processed with the freeware version!

Further Adapters available: SQLite and PostgreSQL

Release notes for version 2.5.0 on October 6, 2012

 

Support for SQLite and PostgreSQL databases

This version of extends FlowHeater by introducing two further Adapters for the import/export of SQLite and PostgreSQL databases. The new Adapters support database server version 3 of SQLite and versions 8.x and 9.x of PostgreSQL.

Continue Reading

TextFile Adapter with support for header and footer rows

Release notes for version 2.4.1 on August 20, 2012

 

TextFile Adapter with support for header and footer rows

Based on FlowHeater parameters, header and footer rows on CSV text files can now also be processed with the TextFile Adapter.

 

Addition Heater with total accumulated for the whole run

This function enables the sum total of a complete run to be accumulated. An example of the possible uses of the feature includes calculating a total for the header and/or footer rows of CSV files or flat file reports.

Continue Reading

Filter duplicated entries out

Release notes for version 2.4.0 on July 23, 2012

 

Filter duplicates records out
Filter duplicates records out

Filter duplicated entries out

The Filter Heater has been extended to provide a powerful new function. Repeated (duplicate) records or rows in the READ data source can now be filtered out with the Filter Heater. And in order to detect duplicate record/rows the data source does not need to be sorted!

 

Skipping empty lines

A further useful function has been added to the TextFile Adapter to ignore empty lines when reading (importing) text files (CSV, TXT, Flat File).

Continue Reading

Improved handling of default values

Release notes for version 2.3.1 on May 26, 2012

 

Improved handling of default values

When the value of a field contains DBNULL, NULL or an empty string, the field’s default value defined in the FlowHeater Definition will now be used.

Continue Reading

New numeric data type DOUBLE

Release notes for version 2.3.0 on May 7, 2012

 

New numeric data type DOUBLE

The existing FlowHeater numeric data types INTEGER, DECIMAL and CURRENCY were optimized for financial mathematics to avoid the occurrence of rounding differences. A new data type DOUBLE is now introduced for the higher precisions required in scientific calculations. The FlowHeater DOUBLE data type can process the SQL data types of float, real, single and double.

Continue Reading