Dynamic data import / export

datenbank

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

Examples

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.

Our recommended approach

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.

Hello World examples

Introductory practical examples of FlowHeater in general use


General examples

These illustrate FlowHeater's basic functions


TextFile Adapter examples

These examples focus especially on the possibilities of the TextFile Adapter


MS Excel Adapter examples

Import/export examples of using the MS Excel Adapter


MS Access Adapter examples

Import/export examples of using the MS Access Adapter


MS SQL Server Adapter examples

Import/export examples of using the MS SQL Server Adapter


XML Adapter examples

Import/export examples of using the XML Adapter


MySQL Adapter examples

Import/export examples of using the MySQL Adapter


SQLite Adapter examples

Import/export examples of using the SQLite Adapter


PostgreSQL Adapter examples

Import/export examples of using the PostgreSQL Adapter


OleDB Adapter examples

Import/export examples of using the OleDB Adapter


DataTable Adapter examples

Import/export examples of using the .NET DataTable Adapter