Dynamic data import / export

datenbank

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

Bug Fix: GroupBy Heater

Release notes for version 1.3.2 on March 5, 2011

 

Bug Fix: GroupBy Heater

When the GroupBy Heater was used together with the Filter Heater in a Definition and the first record / data row was filtered out by the Filter Heater, processing of the first grouping failed to process properly. This problem only occurred in Memory Mode, whereas Mass Data Mode was not affected. The problem is resolved with this release.

 

Standard CSV separator characters from system control panel

Release notes for version 1.3.1 on January 15, 2011

 

Standard CSV separator characters from system control panel

The Textfile Adapter now uses the standard setting for list separators in the system control panel as the default character for a CSV separator. The system setting is now accessed whenever a new FlowHeater Definition is created that employs the Text file Adapter. The actual character used as CSV separator can thereafter be overridden in the Configurator of the Text File Adapter to whatever is desired. Older, previously saved, Definition files are unaffected and continue to function as before.

 

MySQL Adapter with zero DateTime support

Release notes for version 1.2.8 on December 6, 2010

 

MySQL Adapter with zero DateTime support

The MySQL Adapter in this version of FlowHeater now supports zero values (00.00.0000) in DateTime fields. Previously such DateTime values were interpreted as DBNULL/NULL values by FlowHeater. Depending on the MySQL server configuration, in many cases this resulted in the import/export process terminating with an error message. The latest version allows you to import and export DateTime values of zero without any problems.

Continue Reading

Simple, Powerful Data Conversion Application

Press release from November 29, 2010

FlowHeater GmbH has released FlowHeater Designer v. 1.2, a powerful Windows application that imports, dynamically converts, and exports data. Unlike complicated data conversion tools that require you to be - or hire - a programmer, FlowHeater Designer delivers a simple way to transfer data from one format to another. Using a simple graphical user interface to define the modifications needed to transform your data, you simply move it from place to place. By streamlining the data conversion function, FlowHeater Designer eliminates one of the major bottlenecks that cause cost- and time-overruns in many application development projects.

Continue Reading

Improved support for NULL database values

Release notes for version 1.2.6 on November 8, 2010

 

Improved support for NULL database values

Previously FlowHeater would only write the database values NULL or DBNULL when they were explicitly assigned with the NULL Heater. If a DBNULL value from a database table were imported into another, the resulting SQL Insert statement would not include the field and so it would obtain the default field value defined for the table. However, when a default value is lacking for the table field an automatic value of NULL or DBNULL would result. This approach was OK for Insert, but for Update statements it often led to confusion. If in cases where fields could contain NULL or DBNULL on the READ side with an Update, these had to be laboriously attached IF-THEN-ELSE conditions field-by-field and the NULL Heater assigned in each case. This procedure is no longer necessary with the latest release. NULL or DBNULL values are now transferred from the READ to the WRITE side verbatim.

Continue Reading