Live File Processor Widget

<< Click to Display Table of Contents >>

Navigation:  Live > Widgets >

Live File Processor Widget

The Live File Processor widget provides for the management and configuration of Live File Processor instances, which load data from various types of delimited files into the EQuIS Live database tables:

DT_LOGGER ('logger')

DT_LOGGER_SERIES ('series')

DT_LOGGER_DATUM ('datum').

 

A processor / file type (e.g., HOBO, In-Situ-5, Landtec) watches a folder, detects file changes in that folder, and adds the file data into the database. Each file type can have multiple instances. The Live File Processor widget displays all available instances of file processors stored in the ST_CONFIG table. The widget will be empty if no file processor agents exist in the ST_CONFIG table.

Live-File_Processor_Widget

 

Sorting – The Instance Name and File Type columns are sortable by clicking on the column header (click again to reverse the sort). Sorting is alphabetically (A to Z or Z to A).  

 

Filtering – Enter a search term (one or more characters) in the search box above the list. Only records that contain the search term will be displayed.

 

Grouping – Select the Group By drop-down menu to group by the Instance Name or the File Type in a folder (tab) structure. Once grouped, select a folder to see all items in the group.

Live-File_Processor_Widget-Group_By

Live-File_Processor_Widget-Group_Instance

Live-File_Processor_Widget-Group_File-Type

 

 

Widget Setup

 

Individual file types (i.e., processors) must be defined in the ST_CONFIG table to display within the Live File Processor widget. At least one setting (i.e., row) must be defined per file type for that instance to display in the widget. See the Live File Processor Agent Settings article for more details.

 

In the ST_CONFIG table image below, the HOBO file type settings are defined for a "Project 1" instance of this agent.

 

live-file_processor-config_table_zoom75

 

 

Editing Processor Instance

 

Click the Edit Live-Edit-Icon icon to the right of the desired instance of a file type to open the Live File Processor Configuration window. All file types for the selected instance will be available for editing. Settings for each file type (e.g., Datum, Logger) are displayed horizontally across the top of the window.

live-file_processor_widget-hobo-folder_zoom55

Each setting for any of the file types in the selected instance can be configured in the widget. If setting(s) already exist in the ST_CONFIG table for the selected file type, the number of records is indicated in brackets to the right of the setting name.

 

To change or add any setting, select the setting and then click the Add/Remove Settings button. A dialog will provide options for the selected setting. Check (or uncheck) the desired option(s) and click OK. The selected setting option(s) will be visible in the Live File Processor Configuration window. Enter a value for the selected setting options; this is required.

 

Changes will be applied to the ST_CONFIG table by clicking the Save Live-Widget-Save-Icon button.

 

Folder Settings

 

These settings define which folder to watch and how to process files. See the Live File Processor Agent Folder article for more details.

Live-File_Processor_Widget-Settings-Folder

 

FTP Settings

 

Additional settings are needed when the watch folder is on an FTP site. See the Live File Processor Agent Folder article for more details.

Live-File_Processor_Widget-Settings-FTP

 

Archive Settings

 

These settings define how Live File Processor files will be archived. See the Live File Processor Agent File – Archive article for more details.

Live-File_Processor_Widget-Settings-Archive

 

Date Time Settings

 

The date and time settings are used to set DT_LOGGER_DATUM.DATUM_UTC_DT field. See the Live File Processor Agent File – Date Time article for more details.

Live-File_Processor_Widget-Settings-DateTime

 

Datum Settings

 

The datum settings define how data are processed.

See the Live File Processor Agent File – Datum article for more details.

Live-File_Processor_Widget-Settings-Datum

 

Header Settings

 

This setting is used to define headers for the files. See the Live File Processor Agent File – Header article for more details.

Live-File_Processor_Widget-Settings-Header

 

Ignore Settings

 

This setting defines if certain data should be ignored. See the Live File Processor Agent File – Ignore article for more details.

Live-File_Processor_Widget-Settings-Ignore

 

 

Logger Settings

 

The DT_LOGGER.LOGGER_CODE identifies the logger to which the series and datum are added. See the Live File Processor Agent File – Logger article for more details.

Live-File_Processor_Widget-Settings-Logger

 

Reading Settings

 

These settings determine how the file will be read. See the Live File Processor Agent File – Reading article for more details.

Live-File_Processor_Widget-Settings-Reading

 

Series Settings

 

These settings identify the series to which the data are added. See the Live File Processor Agent File – Series article for more details.

Live-File_Processor_Widget-Settings-Series

 

Update Settings

 

This setting determines if/how values are handled if a datum row already exists in the database? See the Live File Processor Agent File – Update article for more details.

Live-File_Processor_Widget-Settings-Update