EQuIS Link Data Mapping

<< Click to Display Table of Contents >>

 >Geotechnical Module > EQuIS Link >

EQuIS Link Data Mapping

The Mapping Project window allows users to load source tables and create data mappings from the source data tables to sections and fields in the desired format file (e.g., Geotechnical). Multiple options exist to provide mapping definitions:

Add – Add new table mapping definitions. Many target fields can be added for the selected source table. The new mapping definition(s) are added to the Mapping Definition pane and are available for editing.

Edit – Edit an existing table mapping definition.

Copy – Copy an existing mapping definition. The duplicate mapping definition is added to the Mapping Definition pane and is available for editing.

Copy Remap Field – Copy an existing table mapping definition, but select new field(s) to replace field(s) in the existing mapping. The new mapping definition is added to the Mapping Definition pane and is available for editing.

Copy Remap Table – Copy an existing table mapping definition, but select new table(s) to replace table(s) in the existing mapping. The new mapping definition is added to the Mapping Definition pane and is available for editing.

 

 

Add Data Mapping

 

1.After loading an existing EQuIS Link project template or creating a new project template, a new data mapping can be added to the template. Select the desired Source Table from the drop-down menu and click the Add button on the right-side of the Mapping Project window.

EDP_Link-Data-Mapping-AddButton

2.The Mapping Definition window opens. Select the Target Table from the drop-down menu and click the Add Field Mapping button. A default data mapping formula will appear in the Target Fields pane.

EDP_Link-MapDef-AddFieldButton2

3.Select the Target Field Name from the drop-down menu. If this field will be a primary key, check the Key box. Primary key fields are displayed in red.

EDP_Link-MapDef-FieldName

4.To open the Edit Attribute Formula window and create the data mapping, click the Value button for the Target Field.

EDP_Link-MapDef-FieldValue

5.In the Edit Attribute Formula window, create the desired data mapping. See the Formula Building and Functions articles for details regarding the formula building process.

6.In this simple example, the gINT database field of PointID is mapped to the EQuIS field SYS_LOC_CODE. Select the Normal Fields tab in the Object Editor pane and click the desired field in the data source (e.g., gINT database). The field name will appear in the Text Editor pane. By default, the field value will be Null. Click on the Parse button to see the formula in the Tree View pane.

EDP_Link-Edit-Att-NormalFields

7.Click the OK button to save the attribute formula and close the Edit Attribute Formula window. The formula value for the field is displayed on the Target Field Value button and in the Target Fields pane. By default, the field mapping will be active.

EDP_Link-Mapping-Def-LithologySimple

8.Repeat the above steps to add data mappings for other Target Fields.

9.Use the Remove Field Mapping(s) button to remove unwanted data mappings. Any data mapping can be changed by selecting the mapping in the Target Fields pane and clicking the Value button.

10.In addition to assigning attributes to individual fields, mapping attributes can be assigned to entire data records. This feature especially useful to ensure that records with null values are not mapped. If desired, click the Record Mapping Active Attribute button to open the Edit Attribute Formula window and assign a formula to the record attribute. Click the OK button to save the record attribute formula and close the Edit Attribute Formula window. The formula will display on the Record Mapping Active Attribute button.

EDP_Link-Mapping-Def-LithologySimple2

11.When finished, click the OK button to save the data mappings for the selected source table and close the Mapping Definition window. The mapping definitions will be displayed in the Mapping Definitions pane of the Mapping Project window.

EDP_Link-Mapping-LithologySimple

12.Repeat the above steps to add data mappings for other source tables.

13.When finished, click the Save button to save the data mappings and the OK button to close the Mapping Project window.

 

Edit Data Mapping

 

1.After loading an existing EQuIS Link project template or creating a new project template, an existing mapping definition can be edited. Select the desired mapping definition and click the Edit button on the right-side of the Mapping Project window.

EDP_Link-Data-Mapping-gINT_US2

2.The Mapping Definition window opens. Select the Target Field to edit and click the Value button for the Target Field.

EDP_Link-Mapping-Def-Lithology

3.In the Edit Attribute Formula window, edit the data mapping as desired. See the Formula Building and Functions articles for details regarding the formula building process.

EDP_Link-Edit-Att-Formula-Lithology

4.Click the OK button to save the attribute formula and close the Edit Attribute Formula window.

5.In addition to assigning attributes to individual fields, mapping attributes can be assigned to entire data records. This feature especially useful to ensure that records with null values are not mapped. If desired, click the Record Mapping Active Attribute button to open the Edit Attribute Formula window and assign a formula to the record attribute. Click the OK button to save the record attribute formula and close the Edit Attribute Formula window. The formula will display on the Record Mapping Active Attribute button.

6.When finished, click the Save button to save the mapping definition changes and the OK button to close the Mapping Project window

 

Copy Remap Field

 

1.After loading an existing EQuIS Link project template or creating a new project template, an existing mapping definition can be copied with substituting new field(s) for the existing field(s). Select the desired mapping definition and click the Copy Remap Field button on the right-side of the Mapping Project window.

EDP_Link-MapDef-RemapFieldButton

2.Within the dialog window, select the used field and then the select new field(s) to replace the used field in the existing mapping. A description of the field remapping is displayed in the dialog window.

EDP_Link-MapDef-RemapField

3.Select the OK button to save the field remapping and add the new mapping definition to the Mapping Definition pane of the Mapping Project window.

EDP_Link-Mapping-LithologySimpleRemap1

 

 

Copy Remap Table

 

1.After loading an existing EQuIS Link project template or creating a new project template, an existing mapping definition can be copied with substituting new tables(s) for the existing tables(s). Select the desired mapping definition and click the Copy Remap Table button on the right-side of the Mapping Project window.

EDP_Link-MapDef-RemapTableButton

2.Within the dialog window, select the used table and then the select new tables(s) to replace the used table in the existing mapping. A description of the table remapping is displayed in the dialog window.

EDP_Link-MapDef-RemapTable

3.Select the OK button to save the table remapping and add the new mapping definition to the Mapping Definition pane of the Mapping Project window.

EDP_Link-Mapping-LithologySimpleRemap2