ST_CONFIG Entries

<< Click to Display Table of Contents >>

Navigation:  Administration and Configuration >

ST_CONFIG Entries

EarthSoft.Common

EarthSoft.EDP

EarthSoft.Net

EarthSoft.Reports

Other Settings

Enterprise Settings

oEnterprise Workflow Service

oWidgets

oEnterprise Controls

oBLOB Storage

 

The ST_CONFIG System Table, accessible only to EQuIS administrators, stores configuration settings for the EQuIS application—similar to settings previously found in .config files—and contains the following columns (fields):

CONFIG_SECTION – Defines the section to which this item belongs; similar to a <configuration> section in an XML .config file.

CONFIG_KEY – Defines the key of the value within a section (i.e., what this item is, or a grouping of such).

OBJECT_TYPE – Defines the type of the object within the CONFIG_KEY field.

OBJECT_VALUE – Defines the object value for this item.

STRING_VALUE – Specifies the configuration value of this item (i.e., this is the value for the configuration setting).

 

The ST_CONFIG system table can be used to customize database-wide behavior such as in EDP, reports, and interactions with Excel.

 

After adding or changing configuration entries, restart EQuIS Professional.

 

EarthSoft.Common

 

Improve performance and reduce processing time across EQuIS products. CONFIG_KEYS in this section usually apply to all formats.

EarthSoft.Common.Data.Connection.BatchInsert – Optional setting to improve data loading via optimal, progressive batch sizing.

EarthSoft.Common.Data.Connection.SkipBulkCopy – Setting to decrease the time for inserting data into the database; can cause timeout errors when committing large datasets.

EarthSoft.Common.Utilities.File.zipTempFolder – Specify a default directory for temporary unzipped files.

 

EarthSoft.EDP

 

Customize EDP (EQuIS Data Processor) settings for users and formats.

EarthSoft.EDP.RVF – When enabled, adds values to EDP’s Reference Value Tab, such as NonZeroSecondsAction (truncate non-zero seconds on a time or date/time field) or KeyValueCase (automatically capitalizing Key Fields).

EarthSoft.EDP.EddCustomHandler.ShowUpdateMode – Limits the commit type in EDP Professional for a given format, optionally by user.

EarthSoft.EDP.EddMapping.RowDifferenceError – Displays an error message when the target row already exists during the Create Package step, optionally by user.

EarthSoft.EDP.Pro.RegisterFile – Registers EDD files committed via Professional EDP to the ST_FILE_REGISTRATION table, optionally by format.

EarthSoft.EDP.CommentIndicator – Sets a single character as a comment indicator for rows in an EDD. The default is ‘#.’  

Coordinate Conversion in DB Format: The DB Format tool in Professional EDP can be used to convert coordinates from one type of coordinates to another.

 

EarthSoft.Net

 

Define default values for a new MailClient or FtpClient instance.

mailSettings – Defines the default values loaded when creating a new instance of EarthSoft.Common.Net.MailClient.

ftpSettings – Defines the default values loaded when creating a new instance of EarthSoft.Common.Net.FtpClient.

 

EarthSoft.Reports

 

Customize report settings, including Excel file type and style type.

Common.Data.DataSetHelper.ExcelVersion – Sets the default file type for Excel exports by choosing the associated Microsoft Excel version, such as 2003, 2007, 2010, or 2013.

EarthSoft.Reports.ActiveReports.HideDataSource – Hides the data source icon in Active Reports. May be user specific. Does not hide the data source by default.

EarthSoft.Reports.ReportGrid.TurnOffDropDowns – Turns off all dropdowns in an EQuIS data grid.

EarthSoft.Reports.RDL.EmptyReportTemplate – Sets a default *.rdl file for viewing tabular data in Report Definition Language (RDL) reports.

XlsForceStyle – Sets the style applied (None, Normal, or Efficient) for performance when exporting to Microsoft Excel. The default setting is Normal.

ReportService.Caching – Within Enterprise, retains and returns the output of a report for the length of the cache limit.

 

Enterprise Settings

 

Enterprise Workflow Service

 

The EQuIS Enterprise workflow runs through a Microsoft Windows service or Microsoft Azure webjob to automatically process EDDs and reports. Each individual service thread within the workflow has configuration options in ST_CONFIG.

EFD Management – defines the management and consumption of EQuIS Format Definition (EFD) within the Enterprise workflow service, including the following settings:

oDisable Upload Rename

oEFD Configuration

oEFD File Monitor

oInbound File Type

EmailDeliver – Sends notices from other workflow service agents.

EmailRetrieve – Retrieves messages from a defined email box and saves their attachments.

FtpRetrieve – Retrieves certain files from the specified folder of a remote File Transfer Protocol (FTP) server.

FileMonitor – Loads Electronic Data Deliverables (EDDs) into EQuIS by scanning folders for new EDDs.

FileProcess – Loads EDDs into EQuIS via the Enterprise EQuIS Data Processor (EDP).

FollowUpTask – Runs upon successfully loading an EDD to the database that will create an ST_FILE_REGISTRATION record.

ScheduledWorkflow (heartbeat agent) – Scans ST_SCHEDULE for scheduled entries to run.

Workfolder – A file exchange location for the Enterprise workflow service and web application.

 

Widgets

 

Explorer – Names the root folder in the Explorer widget.

EZView – Sets a default report for new EZView widgets.

GIS – Default, Geometry Server, and optional settings for GIS:

oGIS.DefaultSpatialReference – Determines a spatial reference for coordinates if RT_COORD_TYPE.SRID is blank.

oGIS.DefaultExtent – Sets a default extent for mapping widgets where not previously set.

oGIS.DefaultBasemap – Sets a default basemap for mapping widgets where not previously set.

oGIS.GeometryServerURL – Specifies the Geometry Server.

oGIS.API_URL – Replaces the default ESRI JS API (optional).

Live Historical Chart – Configures color order.

Login – Sets password complexity, enables registration, and changes authentication.

Role Manager – Designates a "Data Manager" role, which allows assigned users to download error and commit logs without being an Administrator or the EDD Data Submitter.

 

Enterprise Controls

 

Chooser Configuration – Set a per-user default view (Favorites or Recent) and rendering (Tile, Details, or potentially Map) for the Dashboard, Facility, Report, and/or Widget Choosers.

New User Default Configuration – Define a default dashboard for new Enterprise users.

 

BLOB Storage

 

AzureBlobService – Specify Azure Blob Storage to store Binary Large OBjects (BLOBs) outside of EQuIS.

NtfsService – Specify local NTFS folder to store BLOBs outside of EQuIS.

 

Other Settings

 

FormatsEarthSoft.EDP.UseNumberFormatting – Determines if the cell Number formatting is honored when importing data from a Microsoft Excel file.

FormatsEQEDD.EQEDDHandler.Suppress.sys_loc_code.check – Suppresses error warnings when committing EQEDD or EQEDD_v2 data to the database.

Formats – Coordinate Conversion in the DB Format – The DB Format tool in Professional EDP can be used to convert coordinates from one type of coordinates to another.

CascadeDelete – Controls access to the Cascade Delete button.