FlowHeater now speaks XML
Although the XML Adapter is still in beta, it can already be used to process some XML files. The XML processing is presently limited to relatively “flat” not overly complex XML structures with few child nodes. To illustrate the current possibilities we have assembled some simple XML import/export examples, and further will follow. General example of processing XML files
Release notes for version 4.0.0 on October 13, 2015
Independent 32-bit and 64-bit binaries available
FlowHeater comes in 32 and 64-bit binaries as of version 4. On 64-bit systems both variants can be installed and used in parallel. The Definitions processed by both variants are fully compatible with one another. On 32-bit systems there is no question about which variant to use, in this case we use only the 32-bit binary. On 64-bit systems we recommend using the 64-bit binary, which can achieve much faster data import/export processing rates as well as use more than 2 GB of main memory. This is a significant advantage with large Definitions that are processed entirely in main memory. The only exception to this recommendation is when using a 32-bit version of MS Access on a 64-bit system; see the next point for more about this.
Support for 64-bit Access databases (Office installation)
The Access Adapter can now also read Access databases on systems where a 64-bit version of Office or Access is installed. Due to an incompatibility in the database drivers, a 32-bit Office/Access installation was previously necessary. FlowHeater now issues a warning message informing you to use the other binary if you attempt to use the wrong FlowHeater variant (32 or 64-bit) that is incompatible with the Access version installed (32 or 64-bit).
Note: the Excel Adapter is unaffected by this restriction.
Database Adapters: improved field recognition of duplicated field names in joins
When several database tables were selected with an SQL join and the tables contained the same field names, previously only the first of such fields was addressable. In order to overcome this limitation it was necessary to define aliases for these field names in the select statement.
e. g. select table1.id as id1, table2.id as id2, ...
As of this version, identical field names are automatically detected and can be directly used without resorting to aliases.
Extendable SQL Editor
Sometimes rather complex SQL statements are required for reading databases on the READ sides. The entry field in the database configurator on the READ side can quickly become confusing with long and complicated SQL statements. As of this version, in all available database Adapters double-clicking on the SQL field will open an SQL editor to edit the export statement.
Snap-to-grid function for Heaters
Often called for by lovers of esthetics, now implemented at long last. At this point I wish to give thanks to the many suggestions for improvements. Heater/functions that are dragged onto the Designer page are now aligned onto a grid. This way Heaters are pleasingly arranged tidily in the Designer. If desired this feature can be disabled in “Menu->Extras->Options”.
Bug fix: Addition and GroupBy Heaters when used in combination with the Filter Heater
The unfortunate combination of Addition, GroupBy and Filter Heaters previously led to incorrectly calculated results and this version tidies up the problem. The fault was previously fixed by version 3.5.4. Click here for the download page.
Release notes for version 4.0.0.1 on October 21, 2015
- Minor adjustments regarding 32 Bit driver in the Access Adapter
- Customized setup for Windows 10
Release notes for version 4.0.0.2 on October 31, 2015
- Bug Fix: Memory Mode processing
- Updated third party database drivers for (MysQL, Oracle, PostgreSQL, SQLite)
- Added general example of processing XML files
- Example of how CSV files can be exported in segments: CSV export divided into several files
