<< Click to Display Table of Contents >> Navigation:  Professional > Administration > Configuration File (EQuIS.exe.config)

•Excerpt from Example EQuIS 7 Configuration File

•Modifying Add Key Values

•Other Configuration Variables

oXlsForceNumeric

oXlsForceStyle

 

The EQuIS.exe.config file is used by EQuIS Professional during the login process. To edit this file, browse to the directory where EQuIS Professional is installed (typically located at C:\Program Files\EarthSoft\EQuIS or, for per-user installation, %localappdata%\Programs\EarthSoft\EQuIS) and open the EQuIS.exe.config file in a text editor. Always create a backup of this file prior to making any changes.

 

 

Modify Connection String Options for EQuIS through the Connect Tab for the current server for SQL users, or by editing the EQuIS.exe.config file directly.

 

Excerpt from Example EQuIS 7 Configuration File

 

The following example shows portions of the EQuIS.exe.config file.

 

 

Modifying Add Key Values

 

Users can modify the add key values to suit specific needs. The following entries are included in the EQuIS.exe.config file by default. Additional configuration variables may also be applied and are described below.

•remoteFolder: This value should contain the URL used to download software updates (i.e. support.earthsoft.com).

•userName: Provided by EarthSoft to allow access to the EarthSoft servers to receive software updates.

•password: Provided by EarthSoft to allow access to the EarthSoft servers to receive software updates.

•updateFrequency: Indicates how often the application should check for software updates. Typical values: -1 (never), 0 (always), X (every X days).

•lastUpdate: Dynamic and indicates the last time auto update was run on the computer. This value will change any time updates are downloaded.

•EdpAllowEdit: Provides the ability to prevent users from modifying EDDs. The default value is True. Valid values are "", "True",  or "False".

 

 

Other Configuration Variables

 

Other configuration variables (typically for the appSetting section) are described below.

 

networkFolder

AppSetting option that should contain the UNC path (or mapped network drive) where the network license files are located. Subsequent versions store the network licenses in the EQuIS Database.

 

dataProvider

Indicates what type of database the application will be connecting to. SQL Server uses:

▪value="EarthSoft.Common.Data.SqlConnection"

 

databaseConnection

Encrypted data, do not alter. The last database connection used. Used to support network licensing for some third-party interfaces.

 

licenses

EQuIS Product licenses for this workstation. Keys are tied to the Workstation ID and are not valid on other workstations.

 

useNetworkLicenses

Add this optional setting to appSettings to enable or disable use of Network licenses. For more details, see the Change Licensing Mode page. Settings are:

▪True (default) – uses network licenses

▪False – EQuIS will check out a workstation/local license instead of attempting to check out a network license.

▪Config – when added in conjunction with a connection string entry in the configuration section, this setting will always use the connection string provided to access licensing.

For information on the default value of this string for the EQuIS Data Processor (EDP), see the EDP.exe.config page.

 

connectionOptions

Can be used for options such as increasing the Connection Timeout to avoid timeout errors.

 

XlsForceNumeric

In EQuIS 7.22.3+, by default, report output columns defined as text (such as REPORT_RESULT_TEXT) will export to Excel as text, while report output columns defined as numeric (such as REPORT_RESULT_VALUE) will export to Excel as numeric, using Excel's General formatting. Within a numeric column, cells containing duplicates continue to use General formatting, but will be handled as text.

To force exported numbers to always take on numeric formatting when exporting to Excel, add the XlsForceNumeric setting to the appSetting section:
 

<add key="XlsForceNumeric" value="True"/>

 

 

In EQuIS 7.22.2 and prior, by default, exported numbers take on Text formatting when exporting to Excel. To restore this behavior in later builds of EQuIS, add the XlsForceNumeric setting to the appSetting section:
 
<add key="XlsForceNumeric" value="False"/>

 
To restore default EQuIS 7.22.3+ behavior, remove the XlsForceNumeric appSetting from the equis.exe.config file.

 

XlsForceStyle

To control the formatting of Excel output such as Crosstab Reports, add the XlsForceStyle setting to the appSetting section. For example:

 
<add key="XlsForceStyle" value="None"/>
 
The settings are:

•None - No style setting or formatting will be applied (provided there is no conflicting setting in ST_CONFIG), regarding of column type.

•Normal (default) – Styles, formatting lines, alignments and formatted cell borders and colors are applied to the output Excel file. Also the output style if no XlsForceStyle is added into the appSetting section of EQuIS.exe.config.

•Efficient - High performance style setting. Use if you are experiencing "out of memory" errors when exporting the crosstab report to Excel. This will apply the styles to rows and columns, instead of individual cells so it will appear that the style extends past the data table part of the sheet. This is expected behavior.

 

If working with a large set of data or if exporting to Excel is very slow, take the following steps:

•Set XlsForceStyle in EQuIS.exe.config to None or to Efficient.

•Set Limit columns per page to of the Crosstab user interface to 250 or less, and/or

•Add cell borders and/or any other formats manually in Excel (i.e. select all worksheets first and then add cell border lines that will apply to all worksheets at one operation), if necessary.