EarthSoft.EDP.UseNumberFormatting

<< Click to Display Table of Contents >>

Navigation:  Configuration > ST_CONFIG Entries > Formats >

EarthSoft.EDP.UseNumberFormatting

The UseNumberFormatting setting in Professional EDP can be  configured to specify a default setting for the entire format, default settings for specific section(s), and/or default settings for individual columns in a section. When importing data from a Microsoft Excel file, EDP will do the following based on the setting:

 

If set to “True”, then if the cell has Number formatting applied in Microsoft Excel, EDP will import the formatted value.

If set to “False” then EDP will import the value without formatting, regardless if the cell has Number formatting applied in Microsoft Excel.

 

Settings configured in this way will take precedence over the Use_Number_Formatting option in the Backstage.  

 

EQuIS Version: 7

 

Namespace: EarthSoft.EDP.UseNumberFormatting

 

Products Affected: Professional EDP

 

Required Modules: Professional

 

ST_CONFIG

VALUE

REMARK

VALID VALUES

CONFIG_SECTION

EarthSoft.EDP.UseNumberFormatting

Required


CONFIG_KEY

<format name>

 

Required

The name of the format to configure.

OBJECT_TYPE




OBJECT_VALUE




STRING_VALUE

<JSON Configuration String>

Required

A JSON string (not case-sensitive).

 

JSON string structure:

The JSON string should contain the following values for the UseNumberFormatting option:

 

Format

Use the “"Format” tag to set a default value for the entire format.

This will be overridden by any Section or Column specific setting.

This is not required.  

 

Specific Section

oSpecify values for a specific EDD Section of the Format by adding the Section name followed by the Section setting. See example below for formatting.

oTo set a Section default value, use the “Section” tag. This is not required.

 

Specific Column in Section

Within the Section settings above, specify the value for a specific column by adding the column name followed by the Column setting. See example below for formatting.

 

 

Example:

 

CONFIG_SECTION

CONFIG_KEY

OBJECT_TYPE

OBJECT_VALUE

STRING_VALUE

EarthSoft.EDP.UseNumberFormatting

EQEDD



{“format”: “true”, “TestResults_v1”: {“section”: “false”, “result_value”: “true”}, “TestResultsQC_v1”: {“section”: “false”}}

 

This would configure the EQEDD Format to import Microsoft Excel files using the following settings for UseNumberFormatting:

 

EQEDD Format Default: True

oTestResults_v1 Section Default: False  

Result_value Column Default: True

oTestResultsQC_v1 Section Default: False