Dynamic data import / export

datenbank

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

FAQ - Frequently Asked Questions

Common

After upgrading to new versions, do old Definition files still work?
Why does FlowHeater not function with network drives?

Functionality

How do I make use of the If-Then-Else Heater?
How can data be filtered?
How can data be consolidated?
How can I copy one record on the READ side to several records on the WRITE side?
How can the sequence of data records be changed or the data sorted?
What can I do to untangle a confusion of close connecting lines?
How can Definitions be run in the background or scheduled?

 

Q: [After upgrading to new versions, do old Definition files still work]
Yes, with a new version 1.x of FlowHeater you can continue to use Definition files prepared with an earlier version. It is also possible for older versions to be used with Definition files written by a newer version, provided the Definition does not make use of features introduced later.



Q: [Why does FlowHeater not function with network drives]
This is due to a .NET code security rule, which states that anything that is not derived from a local drive (e.g. C:) is to be mistrusted in the first instance. Of course, there is a technical workaround for this. If you urgently need to install FlowHeater on a network drive we would pleased to advise you how to do this. We will shortly include a comprehensive description of the procedure to follow in our documentation.



Q: [How do I make use of the If-Then-Else Heater]
This question is often asked and so we have expanded our documentation to provide a thorough explanation. We now provide two examples as well as the help text on the If-Then-Else Heater.

- Simple If-Then-Else example

- Complex If-Then-ElseIf ... Else example



Q: [How can data be filtered]
Make use of the Filter Heater for this.



Q: [How can data be consolidated]
Make use of the GroupBy Heater for this.



Q: [How can I copy one record on the READ side to several records on the WRITE side]
Make use of the GroupOut Heater for this.



Q: [How can the sequence of data records be changed or the data sorted]
Make use of the Sort Heater for this.



Q: [What can I do to untangle a confusion of close connecting lines]
With Definitions involving lots of fields, the different Pipes are hard to discern and sometimes cross one another, etc. In order to make everything clearer to see, you can divide the Pipes with the Clone Heater (even making chains of them) and thereby reposition the Pipe to a more convenient place in the design area. You only need to move the mouse cursor over a Pipe to highlight it and then with a right mouse click, open the context menu where you choose the "Insert Clone Heater" option. The inserted Heater can then be dragged to any convenient position in the Designer.



Q: [How can Definitions be run in the background or scheduled?]
The Batch Module (FHBatch.exe) is designed specifically to do this.
By inspecting an example of how to import data automatically into an Access table, you will observe in detail how this works.