User's Manual

After downloading dbe.exe, double click on dbe.exe.  The password is located in the email sent by technical support.  Three (3) files are contained in dbe.exe - DBExtr.exe, DBExtr.mdb and DBExtr.mdw.  It is essential for application operation that these 3 files are located in the same directory.

The files will default to the location C:\Windows\Temp to extract the setup kit to.  Modify C:\Windows\Temp to the location where you would like to install The Data Exporter.   It is recommended that the Data Exporter be installed in the same directory with The FLOW CONSULTANT ™.

Launch The Data Exporter either from either a desktop icon or from the Flow Consultant  Main Menu Under File, Export.

This screen will be displayed upon initial startup.

Use the Browse buttons to locate your Flow Consultant database (fc32.mdb).  If you are using multiple databases, this location can be changed at any time to export data from additional databases.

The location of the Lookup database (DBExtr.mdb) will be set automatically to the Data Exporter application directory.  If the Lookup database is not at the same location as the application, the Data Exporter will not function.

The name export.mdb is suggested for Export database to.  This may also be changed at any time. 

After selecting the appropriate databases, click OK.

To create a new database, type the name of the new database into the File Name list box and click Open Shown above as MyExports.mdb.

Click Yes when prompted to create a new database.

Accessible from any screen other than Files.

Unit Templates

Export

Export Specifications

File Paths

Exit

When exporting data, you may wish to convert all the records to the same units of use.  Use the Unit Templates screen to select or create your specific units.

The Data Exporter comes with built in templates you can use or modify. 

Build your own templates by clicking Save after typing the name of the template into the Stored Templates Selection List (top center of the screen, shown above as SI Gas). 

Old or test templates can be deleted by clicking the Delete Button.

To change units, scroll through the stored units by using the arrow keys to the right of the unit.  The unit must be highlighted to be selected, shown above as Bar, gage.

Use the Copy button to add your own units.  After selecting the appropriate unit, click the Copy button and you will be prompted to enter a new string unit equivalent to the selected unit.

Before exporting data, select fields to export using the Export Specification screen.

Select the export specification name from the teal Select Specification Listbox.  The specification named Default is shown above. 

After selecting a specification, the field list in the right pane will display the fields included in the specification.  Shown above as Base Pressure Unit, Base Temperature, Base Temperature Unit, Differential Pressure, Differential Pressure Unit, etc.

The field list in the left pane, shown below, contains all the variables that can be exported from The FLOW CONSULTANT ™.

Add fields to the specification using the field list in the left pane.

• Arrow keys to move up or down the field list.  Use the spacebar to select a field and the insert key to add the field.
• Click each field to select,  then click the Add Field button. 

• Double click the field.

The data type for each field is shown below the field list, shown above as dbDouble.  This defines whether the exported value will be a string or a number.

Remove fields from the specification using the field list in the right pane.

• Arrow keys to move up or down the field list.  Use the spacebar to select a field and the delete key to remove the field.
• Click each field to delete, then the Remove Field button.

• Double click the field.

No changes are made to the specification until Save Spec is clicked.  If an error is made, reload the specification from the Select Specification Listbox.

After your specification has been defined in the right pane, use the Save Spec button to save the definition. 

A new specification name may be entered in the Select Specification Listbox or when prompted.

Outdated specifications can be deleted by selecting the specification from the Select Specification Listbox then clicking the Delete Spec button.

After defining what to export in the Export Specifications screen, use the Export screen to export your data.

Use the Files button to open the File Paths screen to change either The Flow Consultant database or the export database.

The Specs button opens the Export Specification screen to edit or create a new specification.

Select the name of the specification to export from the Select Export Specification Listbox, shown below as Default .

To convert all the records to the same units of use, check the Convert to same units box and select a Unit Template, shown above as US Gas.

Click the Export button and all of the records in The Flow Consultant database will be appended to the export table (as defined by the export specification). 

The export database is now loaded with the current data contained in The Flow Consultant.

Before the Export is performed, a backup is made of the original Export Database.  This file will have the same name as the Export Database and the additional extension .bak.  In the event of damage to the database, remove the .bak from this file to restore your original export database.

DBExtr.mdb.bak is a back up of your export specifications.  This back up is created when the Data Exporter is launched.  If a specification has been changed in error, DBExtr.mdb.bak can be renamed as DBExtr.mdb to restore the original specification.