Data Mapping

<< Click to Display Table of Contents >>

EQuIS 7  >>  Collect > EQuIS Collect Enterprise > Form Designer Page > Forms and Fields >

Data Mapping

Depending on the used format, mapping to the database is provided by default but can also be customized at will. To select or build the data mapping, click the Data Mapping button on the Fields section of the Form Setup page on the Form Designer page.

 

DataMapping Button

 

The Data Mapping window opens with all of the fields available on the form. The fields are grouped by the target section of the format assigned to the form template. Select the Mapping Name drop-down menu to display fields from a different format section.

 

DataMapping Window

 

Fields in the target format section are displayed in the Field Names box. This allows for easy review and editing of data mapping on the entire form. Select the Field Name in the Field Names box to add or change data mapping for the field. The selected field will be highlighted blue and any existing data mapping to the field is displayed. If the field is a primary key field, the Is Key box will automatically be checked.

 

The data mapping value for each field can be customized through the Formula Builder. Click the Value button to open the Formula Builder. Details about using the Formula Builder are provided in the Formula Builder article.  

 

Create New Data Mapping

 

Select the Create New Mapping button to add a new data mapping. The Data Mapping window will change.

 

Col-Data_Mapping_New

 

Click on the Target Format Table drop-down menu to display available format sections.

 

Col-Data_Mapping_New2

 

Select the desired target format section. Fields associated with that section will be displayed. Click the Add Mapping button to apply data mapping to the fields. Key Fields will be automatically added.

 

Col-Data_Mapping_New3

 

By default, the data mapping value for any field is the field name. Click the Value button to open the Formula Builder and customize the data mapping value. Details about using the Formula Builder are provided in the Formula Builder article.  

 

Col-Data_Mapping_New4

 

Fields can be easily removed from any mapping table by selecting the desired field to be removed and clicking the Delete Field button.

 

Note: A database field can be mapped multiple times. For example, the SYS_LOC_CODE can be mapped to HISTORICWATERLEVEL_V1 and also to HISTORICALOCATION_V1.

 

 

Copy Data Mapping

 

Data mappings can be copied for quick and minimal changes, which is helpful when adding multiple data mappings that require similar structure for the same Target Format Table. Select the Copy Mapping button and a dialog box will appear allowing the user to rename the new mapping table.

 

Example Application

 

An example is when mapping field parameters (e.g., pH, ORP, DO, etc.) for a Groundwater Form to the format table FieldResults_v1. The mapping structure will be the same for all the field parameters, but the values for the parameters will change depending on which parameter is being mapped.

 

Col-Comb_Fields-Example

 

Create the data mapping for one of the field parameters, such as pH. As demonstrated in the image below, the desired fields have been add and the values specified for each field. A formula has been added to the Active property for the CAS_RN field. Save the data mapping.

 

Col-Data_Mapping-pH-Field

 

Use the Copy Mapping button to copy the pH data mapping to the next field parameter, such as ORP. A Mapping Name dialog box will appear. Enter the new field parameter name and click OK.

 

Col-Data_Mapping-Copy_Window

 

The fields used in the pH data mapping are available, many of which will remain the same, such as the SYS_LOC_CODE field. Changes can quickly be made to the few fields requiring changes (i.e., CAS_RN, RESULT_VALUE, and RESULT_UNIT).

 

Col-Data_Mapping-ORP-Field

 

Save the new data mapping and repeat the process for the remaining field parameters.

 

 

Other Data Mapping Options

 

To rename a mapping table, click the Rename Mapping button. A dialog box will appear allowing the user to rename the current mapping table.

 

To delete the current data mapping, click the Delete Mapping button and the current mapping section will be removed.