TechTypeTable for selecting and configuring e.g. pipe and valve dimensions and other properties
The tech type table is a table of values for district component properties. Each record contains a techTypeId as a key column, with other columns providing values for component properties.
The TechTypeTable is imported from a CSV file with the following characteristics:
Interpretation of the CSV file:
- First row is for variable names
- Second row is for unit and/or other explanatory messages
- Messages are enclosed in parenthesis (...) and not displayed in the table UI
- Both comma (,) and semicolon (;) are accepted as field separators and are automatically detected.
- Dot (.) and comma (,) are accepted as decimal separators for numeric values.
- Double quote characters (") are used for values that contain separator characters
- Any cell of a numeric property column that contains a non-numeric value is interpreted as a missing value
- The CSV file is loaded using the default enconding of the system (usually cp1252 on Windows), which is also used by Excel
- The data is stored in the model database as a normal string literal (in UTF-8 encoding).
Ontology for TTT persistence:
DN = <http://www.simantics.org/DistrictNetwork-1.0>
TT = DN.TechType : L0.Library
table = TT.TechTypeTable <T L0.Entity
// Table data as a CSV string literal
>-- table.HasData <R L0.HasProperty : L0.TotalFunction
--> L0.String
// Link to corresponding component type
>-- table.HasComponentType <R L0.IsRelatedTo : L0.FunctionalRelation
--> STR.ComponentType
Edited by Reino Ruusu