CSV files not in invariant format - HxGN SDx - Update 63 - Administration & Configuration

Administration and Configuration of HxGN SDx

Language
English
Product
HxGN SDx
Search by Category
Administration & Configuration
SmartPlant Foundation / SDx Version
10

What is invariant format?

Invariant format is a property that does not change when a specified transformation is applied on a CSV file. For example, Data Validator uses the invariant format for thousand separator “,” and for decimal separator “.”. So a value of 1.001 would always be interpreted as 1 with three decimal places even if your intention may have been 1001, as the decimal point was really a thousand separator. Data Validator will not return any validation errors on properties using the invariant format, but you run the risk of not getting the intended data into the system.

Invariant format CSV files

If the data in a CSV file is not supplied in invariant format, it is possible that Data Validator will interpret the data as valid data and not return any validation errors on the export of the data. Therefore, you run a risk of not getting the intended data into the target system. For example, submitting a value of 1.001 would be interpreted as 1 with three decimal places, when the intention may have been 1001, as the decimal point was really a thousand separator. Similar conditions can occur with dates.

If you import a CSV file that is not in invariant format, you must use computed columns to convert the data to invariant format. This applies to all dates, time offsets, and numerics in localized format.

SHARED Tip Data Validator uses the invariant format as defined by HxGN SDx as follows:

  • Date Time Format: yyyy/MM/dd - HH:mm:ss:fff

  • Timezone: GMT with no day light savings adjustment

  • Year Month Day Format: yyyy/MM/dd

  • Numeric format:

    • Thousand separator ","

    • Decimal separator "."

For more information on using computed columns and functions, see Use the Computed column and Functions.