Dynamic data import / export

datenbank

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

GroupBy Heater with InString grouping

Release notes for version 2.1.0 on August 1, 2011

 

GroupBy Heater with InString grouping
GroupBy Heater with InString grouping

GroupBy Heater with InString grouping

In earlier versions of FlowHeater, the GroupBy Heater only grouped data for an identical series of incoming field values. As of this version, the GroupBy Heater also supports grouping on a substring of the input values. A new group is started for each occurrence in the incoming data of a substring specified in the GroupBy Heater properties.

e.g. 

From: This email address is being protected from spambots. You need JavaScript enabled to view it.
Name: import
Info: Yes
From: This email address is being protected from spambots. You need JavaScript enabled to view it.
Name: export
Info: No

In this case, entering the value “From:” as the grouping condition in the GroupBy Heater will cause the blocks/groups to each commence with the “From:” substring.

Continue Reading

Templates

Release notes for version 2.0.7 on July 4, 2011

FlowHeater Templates
FlowHeater Templates

Templates

This version of FlowHeater introduces support for templates for the first time. Any FlowHeater Definition can now be saved as a Template using the menu option "File -> Save as a Template ..." As many Template files as you wish may be saved this way, catering for the most diverse of requirements. The storage location of Template files is freely selectable. The file extension for a Template file is .fhdt (FlowHeater Definition Template).

Continue Reading

Database transactions

Release notes for version 2.0.6 on June 20, 2011

 

Database transactions

The WRITE Adapter property AutoCommitAfter allows you to control how FlowHeater builds import/update transactions when writing to a database.
  • 0 = a single transaction is used for the complete import/update process (default)
  • X = (a number) after each X rows are written, an AutoCommit is executed
  • -1 (new) no database transactions are used

The new (-1) option disables database transactions (each row is effectively committed as soon as it is written) and this is useful when used together with the ODBC Adapter or OleDB Adapter when the underlying ODBC/OleDB database or driver cannot cope with database transactions.

Continue Reading

Replace Heater with extended settings

Release notes for version 2.0.5 on June 6, 2011

 

Replace Heater with extended settings

The Replace Heater is enhanced with some powerful capabilities. You can now replace tabs, line breaks and define complete lists of replacements. Replacement lists can consist of two alternatives:

Continue Reading