Generic Live Data Logger
Copyright © 2018 EarthSoft, Inc • Modified: 12 Dec 2018
EDGE will import generic logger or cross-tabbed data that may be produced by manual collection or manipulation of data. The image below shows an example of the header formatting for a data file.
1.The Excel worksheet must be named 'live_logger_data' or 'xxxx.live_logger_data' where xxxx is some unique identifier.
2.There must be no merged cells in the worksheet.
3.Column A row headers must be presented as shown (e.g. #sys_loc_code etc).
4.If the SERIES_UNIT (row 4) is set to "REMARK", that series will be mapped to DT_LOGGER_REMARK
5.If the data logger value is not numeric, then the text will be added to DT_LOGGER_DATUM.QUALIFIER.
Note: DT_LOGGER_DATUM.QUALIFIER is limited to four characters, any field lengths greater than four will be flagged as an error.
To import the data, click the Devices tab within the ribbon, and then click the Live button.
Select the file to load the data into the LIVE_LOGGER_DATA tab within EDGE.
A successful data load message will provide information on the number of rows that were imported and the elapsed time. After loading, the first four to seven rows of data will contain header information like SYS_LOC_CODE, LOGGER_ID, SERIES_NAME and units, depth and depth_units, according to the rules described in File Format. The exact number of rows depends on the number of headers in the file.
After the data have been imported, they can be saved in the EDD and exported from EDGE. For guidance on loading data to the database, please read more in Importing Logger Data to the Database.