Adding data parsing information to a data file section in the Load Definition File editor consists of the following steps:

Step 1

The first step is to select the Edit Existing Package task in the PACKAGES task bar along the left side of the load definition file editor to activate the PACKAGES page if it isn't already activated.

Step 2

The second step is to activate the package that the data file section containing the data parsing information to be added. Double-click on the section in the Data File Sections list to open the Edit Data File Section dialog box:

To learn more about editing a data file section, refer to Edit Data File Section topic of this documentation.

Step 3

The third step is to click the Add button under the Data Parsing Information list. This will open the Add Relation dialog box:

The left side of the Add Relation dialog box contains a list of available data fields that can be used to map the data from the data source file. The other components defined on the Add Relation dialog box include the following:

Step 4

The fourth step is to enter the Field Token for the relation being added:

The Field Token is the string used to identify the data field within the input data file. The field token can be directly entered into the Field Token edit box or you can click the Options button to open the Data Token Options dialog box:

The Data Tokens Options dialog box allow you to select from a list of special tokens or specify an expression to be used as the field token. Simply select the special token or enter an expression and click the OK button to close the dialog box. The token specifed will be entered into the Field Token edit box.

Step 5

The fifth step is to select the Related Data Field. This can be done two different methods:

The first method is to select the data field from the Related Data Field drop-down list:

The second method is to select the data field from the Available Data Fields list on the left side of the Add Relation dialog box:

This will cause the Related Data Field drop-down list to change to the data field selected.

Step 6 (Optional)

The sixth step is to define the Special Processing if any is necessary. This is done by clickng the Processing button. The dialog box that appears when clicking the Processing button depends on the data type of the Related Data Field selected.

String and Text Special Processing

In the above example we have selected the data field _City which happends to be a string data field. Upon clicking the Processing button, the String Special Processing dialog box would appear:

The String Special Processing dialog box contains the following special processing options:

Numeric Special Processing

If a numeric data field is selected as the Related Data Field, as in the example below,

upon clicking the Processing button the Numeric Special Processing dialog box will appear:

Select the special processing that you would like to add to the relation being defined and enter any information required by your selection:

In the above example, the special processing argument Process Latitude has been selected and the necessary field has been defined.

Attribute Special Processing

If an attribute data field is selected as the Related Data Field, as in the example below,

upon clicking the Processing button the Attribute Special Processing dialog box will appear:

Select the special processing that you would like to add to the relation being defined:

In the above example, the special processing argument Extract Bits has been selected.

Click the OK button after the special processing has been defined to add it to the relation:

Note: Every attribute field should specify either Extract Bits or Extract Mask special processing. If no special processing is specified you will be prompted to specify it before the relation can be added.

Step 7

The seventh step is to either click the OK button to close the Add Relation dialog box and add the relation to the data parsing information or click the Apply button to add the relation without closing the Add Relation dialog box so additional relations may be defined.

The relation is added to the data parsing information.