Geokon Logger Import

<< Click to Display Table of Contents >>

EQuIS 7  >>  EDGE > Devices > Data Loggers >

Geokon Logger Import

EDGE Import (file type .csv)

 

EDGE will import the raw *.csv file that is produced from a Geokon 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

Battery Voltage

Internal Temperature

Pressure Transducer A Digit Reading

Pressure Transducer B Digit Reading

Pressure Transducer C Digit Reading

Pressure Transducer D Digit Reading

Pressure Transducer A Temperature

Pressure Transducer B Temperature

Pressure Transducer C Temperature

Pressure Transducer D Temperature

 

Note: The header row is case insensitive as of EDGE Version 6.6.0.

 

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 JD".

 

To import the data, click the Devices tab within the ribbon, and then click on Geokon. All rows that are before the header row are ignored in the import.

 

25087-GeoKonButton

 

Select the *.csv file and the data will now load into the Geokon_4500 tab within EDGE.

25087-GeoKonTab

 

This data can then be saved in the EDD that is exported from EDGE, and is ready to be imported into EQuIS.

 

EDP Import and Data Requirements

 

The EDGE format is set up to import Geokon data into the EQuIS Live Schema. To include automatic calculations of PSI, water depth, and elevation series during data creation in EDP, use the information in Turn On/Off Live Sections in Format in EDGE  to turn on the Live data prior to exporting the EDD.

 

To import the data into the Live Schema, the required records listed below must already be 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 series record for each transducer using the series name TRANSDUCER_A, TRANSDUCER_B, TRANSDUCER_C, TRANSDUCER_D.

 

The data below is required for successful PSI calculation.

 

Custom_field_1: G constant

Custom_field_2: K constant

Custom_field_3: R constant

Custom_field_4: T constant

Depth: depth of transducer

 

For the water series to be created, a DT_MEASURE_DATUM record must be present for the location that is associated with the DT_LOGGER record. It will use the most recent record as the collar elevation.