Dynamic data import / export


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

Excel and TextFile Adapters with dynamic column recognition

This version extends FlowHeater with more powerful features. One of the most important of these is the possibility to dynamically allocate CSV or Excel data to the correct fields by its column headings. Until now the field/column in a Definition was determined purely by the sequence of columns. When subsequently attempting to read an Excel worksheet or CSV text file with a different sequence of data columns to that originally defined, the column data would be misallocated. This version enables you to handle this situation without the need to modify the Definition for the import of CSV text files or Excel documents by using dynamic column assignment.

Continue Reading

Batch processing with encrypted Parameter passing

FlowHeater has supported Parameters since version 2.2.0 to enable dynamic import/export Definitions. This makes it possible to develop a Definition with alternative connection parameters for a testing environment and to be able to run the Definition without change in a production environment using the Batch Module.

To do this, the Parameter defined is temporarily redefined by a command line option: “/SetParameter Name=Value”. The problem with this until now is that it meant openly passing passwords on the command line. As of this version, FlowHeater supports an option to pass encrypted parameters.

Continue Reading

Access to Excel sheets using index number

Until now, specifying the Excel sheet to use was limited to the sheet name. As of this version the Excel Adapter now also supports access by the individual Excel worksheet index numbers. If instead of the sheet name you give an index (1-n) the Excel Adapter will attempt to address the sheet using this number.

Continue Reading

Support for vCard (contact data) text files

vCards are electronic business cards that are typically imported and exported from the address books of email client software. As of this version, FlowHeater now provides explicit support for vCard text files in addition to the general reading and writing of similar line-based (order independent) text data files. FlowHeater also supports the image data that may possibly be embedded in a vCard.

Continue Reading

New functions for string extraction

This version adds powerful flexibility to the String Split Heater and SubString Heater. The String Split Heater can now optionally index the substrings in reversed sequence, starting with the last substring. In the SubString Heater you are now able to extract substrings enclosed by delimiter strings. Previously it was only possible to extract a substring by specifying a fixed starting position and length within the string.

Continue Reading