EDGE Configuration Format

EDGE has several customizable forms. Each option requires entering data into several EQuIS database tables in advance of creating the RVF, or re-creating a new RVF, as explained in Create Reference Value File. The EDGE_Configuration Format is available in the EDGE\Configuration Formats folder in the EDGE package and can be used to import the data into an EQuIS database for the following customizable EDGE forms:

•Activity Forms accommodating various data collection needs, such as well inspections or flora/fauna surveys. See discussion in Create Groups for Custom Activity Lists.

•Analyte Groups for the Field Results form accommodating various data collection needs. See discussion in Create Groups for Field Results Tab.

•Range Checks for the data entered into the Field Results Form. See discussion in Create Range Checks in Field Results.

•The Calibration Form in EDGE is intended to store all field calibration data. The form is built dynamically from tables in the Reference Value File (RVF). See discussion in Create Dynamic Calibration Form.

•On the Lithology Field tab in EDGE, the Lithology Wizard opens when clicking to add a value in the Classifications field. The options in the Wizard are populated from two reference tables, RT_LITHOLOGY_COMPONENT and RT_LOOKUP. These work together with Material Groups to generate the custom values. See discussion in Create Custom Reference Values for the Lithology Wizard.

Use EDGE Configuration Format

Use a copy of the EDGE_ConfigurationEDDexample.xlsx file to enter data. This example EDD file is located in the EDGE\Configuration Formats folder. The example EDD shows the kinds of data that can be entered in each column. Add, change, or delete the data to get the desired values in the forms. The format will map the data into each required table, including creating rows such as "spm_activity" in the ST_GROUP_TYPE table, if one does not already exist.

Complete the following steps to use the EDGE_Configuration Format to create a custom form:

1.Open the EDGE_ConfigurationEDDexample file in Microsoft Excel.

2.Edit the worksheet that corresponds to the form desired using the example cells as a guide.

3.Delete the example cells in the sheet that are not needed, and then save the Excel file.

4.Open EDP and load the EDGE_Configuration.xse file as the format. Open the configuration EDD created in the previous steps.

5.Resolve any errors; some fields may need to be deleted if they are not needed.

6.Create, then Insert and Update the EDD into Professional.

7.Open the standard EDGE format in EDP.

8.Create a new reference value file, as explained in Create Reference Value File.