Dynamic data import / export

datenbank

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

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

Bug fixed: Excel Adapter and variant MS Excel language versions!

Release notes for version 1.2.4 on October 11, 2010

 

Changes

  • Bug fixed: Excel Adapter and variant MS Excel language versions!
    In a posting in the support forum a minor problem was reported with the Excel Adapter when used in a mixed language environment with different language versions of operating system and MS Office. In this particular case, with Windows XP in Italian and an English version of Office installed. If an Excel import or export were attempted, it would give the error message: "Old Format or Invalid Type Library ". If you should encounter this problem, you can workaround the problem from this version on by editing the registry entry

        HKEY_CURRENT_USERSoftwareFlowHeater

    Create a new value here with the name "ExcelLanguage" and type STRING. The value you enter depends on the Excel/Office language version actually installed on your computer. In the case above it is likely to be either en-GB or en-US. After editing this and restarting FlowHeater you will be able to run Excel import/exports.

 

Bug fixed: CSV text delimiter

Release notes for version 1.2.0 on August 02, 2010

 

Changes

  • Integrating external .NET DLLs into the .NET Script Heater
    In this way the functionality of FlowHeater can be extended almost as much as you like. The functions/methods/classes of external .NET DLLs can be dynamically  integrated and invoked with the help of the .NET Script Heater. A brief introductory example of doing this can be downloaded here.

Continue Reading

MySQL Adapter with improved UTF8 (Unicode) support

Release notes for version 1.1.8 on Jun 12, 2010

 

Changes

  • MySQL Adapter with improved UTF8 (Unicode) support
    The UTF8 (Unicode) import/export/update in MySQL Server tables now also functions with MySQL database servers that are incorrectly configured. Note: UTF8 / Unicode character sets are only supported by MySQL Server versions of 5 and above.

Continue Reading