General Properties | Database Fields

The Export Designer

The Export Designer provides functionality for editing and creating new data export styles. When data is generated using an export style, there is no custom formatting step performed; the data is simply written in ASCII form to the output file. The tool is accessed from the Static Product Builder window. To launch the tool, select an export style in the Product Styles list (Outputs tab) and click the Edit... button or create a new export style by clicking the Add Export button. Once the Export Designer is launched, you can load a different export style by clicking the Open button and selecting an export style file (*.exp) from the dialog that displays.

For practice using the Export Designer, see Exercise 1.5 in Getting Started with ODTK.

General Properties

You can set the following parameters in the General Properties tab:

General Properties
Parameter Description
Description Enter a text string to serve as documentation of the contents of the style. This string will not appear in the resulting output file.

Database Fields

This tab lets you define the contents of the data export.

Independent Variable (X) & Annotations
Parameter Description
Database Table & Fields Select the desired data field(s) to be output. Multiple fields may be selected from a single database table.

NOTE: You can only select a particular field once and you cannot select data from multiple database tables.

Header row Check this box to have the selected field names written in a header record at the top of the output file.
Table name in header row Check this box to have fully qualified names <table name.field name> written in a header record at the top of the output file. Header record will only be written if Header row is also checked.
Field's print format Highlight an entry in the selected fields list and enter the desired formatting for the data string. The formatting syntax follows the C programming language conventions for the printf() function, partially described in the tables below.


Formatting of Real Data
printf format option Description
%<n><.m>f Formats data in decimal format with a total minimum field length of n and displaying m digits past the decimal; n and m are optional.

Example: %8.1f    -12345.6
%<n><.m>e Formats data in scientific format with a total minimum field length of n and displaying m digits past the decimal; n and m are optional.

Example: %12.6e    -1.234560e+04
%<n><.m>g Formats data in decimal or scientific format, choosing the more compact form, with a total minimum field length of n and displaying m digits past the decimal; n and m are optional.
Default %14.6f


Formatting of Integer Data
printf format option Description
%<n>d Formats data with a minimum field length of n; n is optional.

Example: %4d    1234
Default %7d


Formatting of String Data
printf format option Description
%<n>s Formats data with a minimum field length of n; n is optional.

Example: %6s    HighEl
Default %s

ODTK 6.5