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.




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




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.




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.  




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.




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.




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.




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).




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.