Mapping Fields

When the target is a Forsta Survey Database, and the source is a Delimited Text File or another Forsta Survey Database, you can map fields (columns) that have different names in the source and target. To do this:

1. In the rule's Target tab, click the Map Fields button.

The Target page changes to display lists of the source fields and target fields - .



Figure 1 - Example of the Source and Target Field lists for a rule

2. Select pairs of fields; one in the Source Fields list and one in the Target Fields list, and click Map Fields.

The fields are mapped. To indicate this, the field name is moved from the Source Fields list and displayed in the Mapped To column in the Target Fields list - .



Figure 2 - The age field from the Source is mapped to the ageNum field in the Target

3. Save your changes.

Other buttons on this page are:

• Automap Fields - automatically maps all fields that have matching names in the Source and Target Fields lists. The types of the fields being mapped is ignored during automapping. Save changes on completion.
• Remove Mapping - select a mapping in the Target Fields list and click this button to remove it. The field in the Mapped To column is returned to the Source Fields list. Use this button also to remove un-wanted key fields. Save your changes.
• Remove All Mappings - click to remove all mappings (don't forget to save the changes).
• Toggle Key Field - changes the fields used as Key Fields (go to Survey Database for more information). Select a field in the target Fields list and click Toggle Key Field button. The Key Fields (source/target) row towards the top of the page is updated. Note that you can select any number of fields as key fields. However these must be selected individually, and only fields that have been indexed can be used. A Key icon is displayed in the Key Field column for the selected field.