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

 

 

Add a Processor Instance

 

Individual file types (i.e., processors) must be defined in the ST_CONFIG table to display within the Live File Processor widget. See the Live File Processor Agent Settings article for more details.

 

Processors can be added to the ST_CONFIG table by either the Live File Processor widget or via Professional.

 

In the Live File Processor widget, click the Add button to open the Add Instance/Type dialog window. Enter an Instance name (ST_CONFIG.CONFIG_KEY) and select a file type (ST_CONFIG.OBJECT_TYPE) from the Template drop-down menu. The default settings for the selected file type will be applied, which can be edited. All fields must be populated or a new instance / file type will not be created. The instance / file type combo must be unique. Duplicate entries will not be created.

 

Live-File_Processor_Widget-Add_Instance

 

 

Click the OK button. The dialog will close and the new instance of the processor will be in the widget list.

 

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

 

 

Edit a Processor Instance

 

Click the Edit Live-LFP-Widget_Edit_Icon icon to the right of the desired instance of a file type to open the Live File Processor Configuration window. Settings for the file type (e.g., Datum, Logger) are displayed horizontally across the top of the window. 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.

Live-File_Processor_Widget-HOBO-Folder

Download – Click the Download button to export the existing settings for the instance / file type to a file in JavaScript Object Notation (JSON).

 

Upload – Click the Upload button to import new settings for the selected instance / file type.

 

Add/Remove – Each setting for the selected instance / file type can be configured in the widget. To change or add any setting, select the setting and then click the Add/Remove button. A dialog will provide options for the selected setting. At the top of each dialog are three radio buttons: All, With Value, and Any. With Value is the default option.

 

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

 

Clone a Processor Instance

 

Click the Clone Live-Clone-Icon icon to the right of the desired instance of a file type to create a copy of the selected row from the list. Change the instance name or file type to make a unique combination. Click OK to save the cloned instance.

 

Delete a Processor Instance

 

Click the Delete Live-LFP-Widget_Delete_Icon icon to the right of the desired instance of a file type to remove the processor from the ST_CONFIG table. A confirmation message prompts the user prior deleting. Click Yes to remove the processor.