Live File Processor Agent Installation and Configuration

<< Click to Display Table of Contents >>

Navigation:  Live > Agents > File Agents > File Processor >

Live File Processor Agent Installation and Configuration

Installation and Setup

 

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

 

Continuous Data Loading

 

When the agent starts, it connects to the EQuIS Live database and watches each processor's folderWatcherPath for file changes. When the agent detects a new file, or new data in an existing file, it automatically loads the data to the EQuIS Live database tables: DT_LOGGER ('logger'), DT_LOGGER_SERIES ('series'), and DT_LOGGER_DATUM ('datum').

 

Note: A series can be activated or deactivated by setting its STATUS_FLAG = 'A' or 'R', to start or stop (respectively) obtaining data for it.

 

Command Line Options

 

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

 

Option

Description

db2json

Save the ST_CONFIG table settings to an EarthSoft.Live.FileProcessor.YYYYMMDDTHHMMSS.config.json file. (A databaseConnection connectionString, and a configKey value, need to be defined in the EarthSoft.Live.Agents.File Processor.exe.config file first.)

e.g., db2json or db2json "HOBO|In-Situ-5|Landtec"

 

Not specifying a processor will save all the ST_CONFIG table settings to the *.json file.

json2db

Add (or update) the EarthSoft.Live.FileProcessor.config.json file (example) settings to the ST_CONFIG table. (A databaseConnection connectionString, and a configKey value, need to be defined in the EarthSoft.Live.Agents.File Processor.exe.config file first.)

e.g., json2db or json2db "HOBO|In-Situ-5|Landtec"

 

Not specifying a processor will add all *.json file settings to the ST_CONFIG table.

 

Note: This command saves the original ST_CONFIG table settings (for all processors) to an EarthSoft.Live.FileProcessor.YYYYMMDDTHHMMSS.config.json file first. To restore the original settings, rename EarthSoft.Live.FileProcessor.YYYYMMDDTHHMMSS.config.json to EarthSoft.Live.FileProcessor.config.json (rename the original EarthSoft.Live.FileProcessor.config.json file first) and run json2db.

loaddata

Load data for all files that were added to the watched folder(s), or changed, while the agent was not running.

e.g., loaddata or loaddata "HOBO|In-Situ-5|Landtec"

 

Not specifying a processor will load data for all processors.

 

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