We present a constantly growing collection of examples here, illustrating how to use FlowHeater with practical tips. These range from the simplest "hello world" to some quite powerful Definitions for importing / exporting CSV text files, the dynamic conversion of data between databases and the generation of test data in a variety of forms.
Note: If you cannot locate a specific example for the actual task you are contemplating, refer to some of the other examples. The general methods applied in FlowHeater are always consistent and so by extension one of these examples will be found to approximate your requirements.
It is a tradition to begin by writing a “hello world” program when first learning a new programming language. Have no fear, we are not expecting you to learn programming; we merely wish to demonstrate to you that FlowHeater is just as flexible and capable as custom programming is.
All the examples are explained step by step, so you can easily repeat them yourself and for your convenience they are all included in the FlowHeater download. You will find the examples in the folder "..\Examples\EN". Click here for the download page.
You are advised to repeat the "hello world" examples to begin with, step by step. All in all this should not take you longer than 30 minutes and it is really worth your while. The fundamental methods of operation are all explained there. It will not matter whether you later want to export data from an SQL Server database into a CSV file or import data from Excel into an Oracle database; the methods used are always the same. Once you have mastered the general techniques you will soon discover new ways of using the software for your own uses.
The first example shows how CSV test data can be generated with FlowHeater.
Now we get more ambitious. First we will use the method already explained for writing a CSV format text file, but will convert it to a flat file (a text file with fixed string lengths, equivalent to fixed column widths) and also insert an incremental number on each line.
This example primarily focuses on describing in greater detail the use of the If-Then-Else Heater and to demonstrate a much more elegant possibility of how such relatively complex structures (9 heaters in this case) can be replaced using a single .Net Script Heater.
This example demonstrates how data can be filtered and grouped during a transformation.
This example describes how data can be filtered, grouped and values summed across groups during a transformation. As input let us assume the following small flat file, a report format text file (we do not always have CSV data).
In CSV or Flat File text files there are often header and/or footer rows included that contain additional information and require processing during the import/export process. With this example we wish to demonstrate to you how CSV header and footer rows are processed using FlowHeater Parameters.
With this example we wish to demonstrate how to import and export vCard (contact data) version 2.1 files. Commonly referred to as electronic business cards, vCards can typically be imported into and exported from email clients.
This example describes how to create mass test data for the t_Persons table in an Access database.
In this example we explain how to export with FlowHeater cumbersomely large SQL Server tables and split (segment) them into a series of CSV text files. The criterion for dividing the CSV files can be based on the content of a field or a fixed value for the maximum number of records to export.
Unlike with simple data imports, with migration or transfer of old data to a MySQL database a major problem arises when it is not possible to retain ID field values (Primary Keys) and the relations between tables have to be reconstructed. With this example we want to demonstrate the possibilities that FlowHeater offers to help with migration. Several example cases are listed, ranging from simple to fairly complex.
With this example we want to demonstrate to you how to configure a dynamic FlowHeater Definition using Parameters to export to a CSV file from a MySQL table that when run automatically only selects records that have been inserted since the previous run.
As there is no native Adapter for Sharepoint in FlowHeater at present, we wish to provide a short explanation about how you can gain access to Sharepoint Portal Server lists by using the FlowHeater OleDB Adapter. The three scenarios of import, export and update are briefly described.