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:
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.
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.
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.
Click the Edit 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.
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 button.
These settings define which folder to watch and how to process files. See the Live File Processor Agent Folder article for more details.
Additional settings are needed when the watch folder is on an FTP site. See the Live File Processor Agent Folder article for more details.
These settings define how Live File Processor files will be archived. See the Live File Processor Agent File – Archive article for more details.
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.
The datum settings define how data are processed.
See the Live File Processor Agent File – Datum article for more details.
This setting is used to define headers for the files. See the Live File Processor Agent File – Header article for more details.
This setting defines if certain data should be ignored. See the Live File Processor Agent File – Ignore article for more details.
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.
These settings determine how the file will be read. See the Live File Processor Agent File – Reading article for more details.
These settings identify the series to which the data are added. See the Live File Processor Agent File – Series article for more details.
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.
Copyright © 2021 EarthSoft, Inc • Modified: 12 Feb 2021