Copyright © 2018 EarthSoft, Inc • Modified: 23 Nov 2018
EDGE will import the raw *.csv file that is produced from a RST data logger. The following list shows what headers are supported with the import (the header name must start with the text shown).
•Data logger ID
•Date and Time
•Pressure Transducer A Digit Reading
•Pressure Transducer A Temperature
The headers can be in any order for the import to work, but 'data logger id' and 'Date and Time' values must be present for each line of data. The 'Data and Time' column must be in the type of 'Dublin Julian Date'.
To import the data:
1.Click the Devices tab within the ribbon
2.Click the RST button.
3.Click Open File to select and open the csv file. The data will now load into the RST_DT2011B tab within EDGE.
This data will be saved in the EDD that is exported from EDGE, and is ready to import into EQuIS.
By default, the EDGE format is set up to import RST data into the EQuIS Live Schema and will create the pressure, water depth and elevation series during the EDP "Create" step using the following formula:
Pressure (kPa): CF(Li-Lc)+[Tk(Ti-Tc)]
Depth (m) : Depth - (Pressure *(1/y))
Total Head (masl): TOP - DTW
Lc: Current pressure measured by the data logger (B units)
Tc: Current temperature measured by the data logger (C)
(for definition of other parameters see below)
To import the data into the Live Schema, the required records listed below must already have been created.
•A DT_LOGGER record that matches the data logger id of the data being loaded. For the water series to be created this record must have the SYS_LOC_CODE value.
•A DT_LOGGER_SERIES record for each transducer using the series name TRANSDUCER_A, TRANSDUCER_B, TRANSDUCER_C, TRANSDUCER_D.
The data below is required for the pressure and depth-to-water calculation to work.:
•Custom_field_1: (-)Cf constant - Linear Calibration Factor (kPa/B Unit)
•Custom_field_2: TK - Temperature Correction (kPa/C rise)
•Custom_field_3: Li - Initial factory pressure reading (B unit)
•Custom_field_4: Ti - Initial factory Temp reading at calibration (C)
•Custom_field_5: 1/(y) - Pore fluid (kN/m3)
•Depth: depth of transducer (m)
•TOP - For the water series to be created a DT_MEASURE_DATUM record must be present for the location (SYS_LOC_CODE) that is associated with the DT_LOGGER_SERIES record. It will use the most recent record as the collar elevation.
After the first set of data has been created, EDP will create new DT_LOGGER_SERIES for TRANSDUCER_A_WATER_DEPTH and TRANSDUCE_A_WATER_ELEV. The SERIES_UNIT for each of these new records should be completed either in EDP or in EQuIS Professional data tables.