Live MIS Data Files

<< Click to Display Table of Contents >>

Navigation:  Live > Agents > File Agents >

Live MIS Data Files

The EQuIS Live Collection Agent for OTT Hydra MIS data files is designed to load logger data saved in .mis files.

 

How It Works

 

The agent will monitor one or more folders for any new data files. Once new files are detected, the agent will parse them and import data into the EQuIS database.

 

Installation and Setup

 

Follow these steps to install, configure, and start this agent.

 

EQuIS Live MIS Agent needs to be installed either on the same machine where the data files reside or somewhere with full access to the logger files (*.mis).

 

Before starting the service, make sure that its Log On As account has read and write access to the folder with the *.mis files, and add the desired data logger(s), as explained in the next section.

 

Add Logger(s)

 

Loggers can be added manually via EQuIS Professional, or automatically via addlogg command line option.

 

To add logger manually

 

1.Create a new row in DT_LOGGER per station from which to import data. Set DT_LOGGER.LOGGER_CODE to the station ID.

2.Create a new row in DT_LOGGER_SERIES per station's sensor. Set DT_LOGGER_SERIES.SERIES_NAME to the sensor ID. Series is linked to station by LOGGER_ID.

3.Set in the newly added DT_LOGGER row where the data files to process will be saved. Set field DT_LOGGER.LIVE_DATA_SOURCE to: file://*.mis

 

To add logger automatically and load data for it

 

1.Place MIS files in some FOLDER, other that the monitored folder.

2.Run agent with command line option addlogger FOLDER.

3.Wait for agent to process files.

4.Run agent with command line option loaddata FOLDER.

5.Wait for agent to process files.

 

Continuous Data Loading

 

When the application starts, it connects to the EQuIS Live database and examines the DT_LOGGER.LIVE_DATA_SOURCE to determine which loggers to process for mis files. By default, the agent will create new loggers/series for mis files for which there are no loggers/series already defined. To disable this, execute command line option autocreate off.

 

Command line Options

 

EarthSoft.Live.Agents.mis.exe supports the following command line options:

Command

Description

addlogger

Setup logger/series defined in the monitored folder. Does not load any data.

addlogger FILE

Setup logger/series defined in the provided FILE. Does not load any data.

addlogger FOLDER

Setup logger/series defined in the files of the provided FOLDER. Does not load any data.

autocreate

Show current state of the autocreate feature.

autocreate on

Enable automatic creation of new loggers/series when loading data.

autocreate off

Disable automatic creation of new loggers/series when loading data.

connect

Test current connection.

delay

Show current delay value for file processing [in miliseconds].

delay X

Set current delay value for file processing [in miliseconds]. Valid range: 0 to 1000.

folder

Display currently assigned folder being monitored for data files.

folder FOLDER

Set FOLDER to monitor for data files.

info

Show configuration information.

loaddata

Load data for existing loggers/series from the monitored folder. Loads one (1) row at a time.

loaddata FILE

Load data for existing loggers/series from the provided FILE. Loads one (1) row at a time.

loaddata FOLDER

Load data for existing loggers/series from files in the provided FOLDER.

write X

Create test file in monitored folder with X data points.

 

Common command line options for all EQuIS Live Agents that can be installed as Windows Services are listed here.

 

Mapping File Data to EQuIS Live Tables

 

The agent assumes mis file contains data for at least one logger, with at least one series. The file must contain description line per series in the following format:

<STATION>logger_id</STATION><SENSOR>logger_series_id</SENSOR><DATEFORMAT>YYYYMMDD</DATEFORMAT>

date,time,value

date,time,value

date,time,value

date,time,value