Live EDD Format

<< Click to Display Table of Contents >>

EQuIS 7  >>  Enterprise > EQuIS Live > Concepts > Data Loading >

Live EDD Format

The EQuIS Live Format checks and loads data into the EQuIS Live tables via EQuIS Data Processor (EDP). See format section descriptions below:

 

EDD Section

Description

Logger

This section can be used to update EQuIS with new logger data. This information will update the table DT_LOGGER.

LoggerSeries

This section can be used to create or update EQuIS with the measurement parameters the loggers will be capturing (e.g., temperature). This information will update the table DT_LOGGER_SERIES.

LoggerDatum

This section can be used to import logger data values into EQuIS. This information will update the table DT_LOGGER_DATUM.

LoggerRemark

This section can be used to import logger data remarks into EQuIS. This information will update the table DT_LOGGER_REMARK.

 

The latest Live Format can be found in the Products> EQuIS Live folder in the EarthSoft Community Center Downloads Dashboard.

 

The help documentation for EDP is accessible here.

 

Information

 

The Live format uses the LoggerCode (DT_LOGGER.LOGGER_CODE) to uniquely identify the logger row, the LoggerCode and SeriesName (DT_LOGGER_SERIES.SERIES_NAME) to uniquely identify the series row, and the LoggerCode, SeriesName and DatumUtcDate (DT_LOGGER_DATUM.DATUM_UTC_DT) to uniquely identify the datum row.

 

If DT_LOGGER and DT_LOGGER_SERIES rows are being added to the database for the first time, their DT_LOGGER.LOGGER_IDs and DT_LOGGER_SERIES.LOGGER_SERIES_IDs are automatically populated, and their STATUS_FLAGs are set to 'A', and their FACILITY_IDs are set to the currently selected facility.

 

Note: Logger and LoggerSeries are lookups for LoggerDatum and LoggerRemark, and must exist in the database prior to loading Datum and Remark data.

 

The Live Format ONLY loads data to loggers that belong to the currently selected FACILITY_ID or NULL FACILITY_ID.