Examples

The first example shows how CSV test data can be generated with FlowHeater.

Taking the Hello World 1 Definition we produced a little further, let us now produce some more dynamic results 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 describes the standard method to transform numbers into strings and how FlowHeater can be used to sidestep the standard format options of the WRITE Adapter.

Here we see a short and simple example of how a conditional branch is defined in practice, demonstrating the use of the If-Then-Else Heater.

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).

With this example we wish to demonstrate how easy it is to convert text files to other formats (codepages and locales) with the TextFile Adapter and at the same time perform dynamic calculations.

With this example we wish to demonstrate how easy it is to convert text files to other formats (codepages and locales) with the TextFile Adapter and at the same time perform dynamic calculations.

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 illustrates how the following order details in an Excel workbook can be read with the help of the MS Excel Adapter and exported to a CSV text file using the TextFile Adapter.

This example describes how the Access Adapter can be used to import a CSV text file into a MS Access database table. It also explains how to configure FlowHeater for importing with insert or update SQL operations.

This example describes how to create mass test data for the t_Persons table in an Access database.

This example describes how several CSV text files can be automatically imported into an MS Access database table by FlowHeater, demonstrating the use of the Access Adapter and the Batch Module.

This example describes how the SQL Server Adapter can be used to import a CSV text file into an MS SQL Server database table. It also explains how to configure FlowHeater for importing with insert or update SQL operations.

This example shows how text is exported as a flat file (report) from an MS SQL Server database by using a combination of the FlowHeater SqlServer Adapter and the TextFile Adapter.

This example demonstrates how to import into Auto Increment (IDENTITY) fields into an MS SQL Server database using the FlowHeater SQLServer Adapter and what to watch out for when importing an Auto Value (IDENTITY) column.

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.

We wish to illustrate the general methods of XML processing using the XML Adapter with the following example. All the examples described here are available as complete Definition files in the downloaded zip archive.

This example describes how the MySQL Adapter can be used to import a CSV text file into a MySQL database table. It also explains how to configure FlowHeater for importing with insert or update SQL operations.

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.

In this example we demonstrate how data from a CSV text file and an Excel list can be merged into a large export text file in flat file report format.

This example describes how the TextFile Adapter can be used to import a CSV text file into an PostgreSQL database table. It also explains how to configure FlowHeater for importing with insert or update SQL operations.

PSQL array fields are processed by the PostgreSQL Adapter as the STRING FlowHeater data type. The individual elements are enclosed in curly brackets, e.g. {"one", "two", "three"} for a CHARACTER array with three elements, or {1.23, 4.56} for a NUMERIC array with two elements.

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.

Here we describe the different fields of application for the .NET DataTable Adapter by way of a small example.

This describes a brief Visual Basic .NET example to illustrate how the .NET DataTable Adapter can be used to integrate any data source and target in FlowHeater. Of course the example is also provided as Visual Studio Solution source code.

Simple example how to export a XML file by using the .NET DataTable Adapter.