1. Introduction
The Property Types and Codes Page in SensGrid Geosens is designed to manage and configure property types & codes for instruments and station groups.
Property Types and Codes of Instrument/Station-Group contain pre-defined configuration Items like PARAM, CARRY, etc. in the Revision Property (REV).
CARRY may contain Carry Over items when PARAM contains more configuration items, like Chart, Report, Baselines, various Parameters/Factors, etc.
By doing this, additional configuration items can be introduced easily. The user can simply setup some default values for each Instrument/Station-Group Type.
Users can:
Import Items of Property Types and Codes for each Instrument or Station-Group Type.
Re-import properties when any new item is introduced or item/data is changed from the SensGrid Global level.
Select and edit property data values/content of an Instrument or Station-Group.
2. Instrument Property Types and Codes Data Table Section – Viewing Details
This section is for displaying property types related to specific instruments. This section contains key data columns, sorting and filtering functions:
Cascading Sorting of data columns can be done by holding the Shift key and clicking on each column header in order.
2.1 Key data columns
Field Name | Description |
Instrument Type | Type of instrument being configured (e.g., "Disto Tilt Displacement Sensor"). |
Referred Table | Source data table (e.g., "InstruRevParam"). |
Property Type | Category of the property (e.g., "PARAM", "REPORT_CHART"). |
Property Code | Unique identifier for the property. |
Property Title | Display name or purpose of the property. It is editable by the project users. |
Default Value | Initial Number value assigned to the property (e.g., -0.75, 25.66). It is editable by the project users. |
Default Text Value | Initial Text value assigned to the property (e.g., true, 0|0|1|1|0,[Max,Avg], rgba(250, 118, 100, 0.8)). It is editable by the project users. |
Data Type | Type of data accepted (e.g., "Number", "Boolean"). |
Notes | Additional information or comments about the property. |
Value/Text value entered here will be automatically transferred into each newly created instrument/station-group as default values.
For all existing instrument/station-group, update can be simply done by clicking Re-import.
2.2 Viewing more Column Data
Bring up more column data by clicking on the Column Chooser ‘
’ at the top right corner, choose the data column you want to view, and drag it to the current data table to add the column in and view the information.
Field Name | Description |
Station-Group Type | Indicates if the instrument is linked to any Station-Group Type. |
Is Default | Specifies whether this property type is imported as default. |
Default Text Value | Text value set by default for this property type, if applicable. |
Is Nullable | Indicates if the property type can accept null values; affects RevProperty table. |
Is Editable | Indicates if the property code can be edited; affects RevProperty table. |
Enabled | Indicates if the property type is active; affects RevProperty table. |
Created On | Date and time when the property type was created or imported. |
Created By | Email of the user who created or imported the property type. |
Updated On | Date and time of the most recent update to the property type. |
Updated By | Email of the user who made the latest update. |
2.3 Sorting Function
Sort column data alphabetically by clicking the column header, and an arrow will display next to the header and show ascending / descending order.
Cascading Sorting of data columns can be done by holding the Shift key and clicking on each column header in order.
2.4 Filtering Function
Filtering for any specific info by clicking on the filter icon ‘
’ right next to the column names. Search and click on the desired categories to filter and display those categories only, for better viewing purpose.
3. Instrument Property Types and Codes Import Section – Import / Clean / Overwrite
The Instrument property type Import enables the functions to import / clean & re-import / overwrite of any types of instruments property code. By selecting different options, the Instrument property type (Rev Parameter or Rev Carry Over Factor) can be added with default value / be clean & re-imported / be overwritten. The detailed steps are shown below:
Step 1: In the first selection bar, select an instrument type to Import the property types and codes for. The options in the drop-down list will be all the potential instrument types. Please select the one you want to Import.
Step 2: In the second selection bar, select the instrument property type (Rev Parameter or Rev Carry Over Factor) to take actions.
Step 3: In the third selection bar, select the specific action on the selected instrument type and selected property type:
Clean & Re-Import: Clears existing data and Re-import all.
Overwrite: Add Missing and overwrite/update existing editable items and data values.
Add Missing: Only Import missing property types and codes without touching any existing records. This ‘Add Missing’ option is suitable for many situations.
NOTE: Please note to use ‘Clean & Re-Import’ and ‘Overwrite’ with cautions. This is an action for bulk property records Import, and the overwritten items/data won’t be able to recall if using this function by mistake.
4. Step 4: Click on ‘Import Properties’ at the right-side button to take action for the selected instrument type and selected property type.
4. Instrument Property Types and Codes Toolbar – Edit, Save, Delete
This section provides action buttons to make any changes (edit / delete) to the existing Instrument Property Type Code data table.
4.1 Edit Grid
By clicking on the ‘Edit Grid ’ button, the instrument property type code data table becomes editable for a few fields (some fields are fixed in Geosens and cannot be edited).
Click on a field in instrument property type code data table to make any changes (e.g. change the property title or change the editable status for the property type code).
Click on ‘Save’ button to save any changes or click on ‘Cancel’ button to cancel any changes.
4.2 Delete
Tick to select the instrument property code that aims to be deleted.
Click on ‘Delete’ to delete this instrument property code permanently. Please note to delete with caution: If it has been deleted wrongly, only the default value can be imported back by using the ‘Add Missing’ function in the Instrument property type code Import Property Section at the top of the page.
5. Station-Group Property Types and Codes Data Table Section – Viewing details
This section is for displaying Property Types and Codes records related to Station-Group Types. This section displays the following default data columns and sorting and filtering functions:
5.1 Data Columns
Field Name | Description |
Station-Group Type | The type of Station-Group being configured (e.g., "Disto Tilt Displacement Sensor"). This field is for viewing only. |
Referred Table | The data source table (e.g., "StationParam"). This field is for viewing only. |
Property Type | The category of the property (e.g., "PARAM," "REPORT_CHART"). This field is for viewing only. |
Property Code | A unique identifier for the property. This field is for viewing only. |
Property Title | A description of the property’s displayed name / purpose. This field can be edited and customized. |
Default Value | Initial Number value assigned to the property (e.g., -0.75, 25.66). It is editable by the project users. |
Default Text Value | Initial Text value assigned to the property (e.g., true, 0|1|1|0|0,[Max,Avg], rgba(250, 118, 100, 0.8)). It is editable by the project users. |
Data Type | The type of data the property accepts (e.g., "Number," "Boolean"). This field is for viewing only. |
Notes | Additional information about the property. This field can be edited and customized. |
5.2 Viewing more Column Data
Bring up more column data by clicking on the column chooser ‘
’ at the top right corner, click on the data column you want to view, and drag it to the current category table to add it in and view the information.
Field Name | Description |
Instrument Type | Show the instrument type of the instruments contained in this Station-Group. |
Is Default | Configure the status if this property type is imported as default or not. |
Default Text Value | Configure the text value set by-default for this property type, if applicable. |
Is Nullable | Configure the status if this property type can be filled with null or not. This field can be edited and make effects on corresponding property type in the RevProperty table of each instrument. |
Is Editable | Configure the status if this property code can be editable or not. This field can be edited and make effects on corresponding property type in the RevProperty table of each instrument. |
Enabled | Configure the status if this property type is enabled/disabled. This field can be edited and make effects on the corresponding property type for the Station Group. |
Created On | The date and time of the create / import of this property type. |
Created By | The email address of the user who created / imported this property type. |
Updated On | The date and time for the latest time of property type update. |
Updated By | The email address of the user who made the latest update. |
5.3 Sorting Function
Sort column data alphabetically by clicking the column header, and an arrow will display next to the header and show ascending / descending order.
5.4 Filtering Function
Filtering for any specific info by clicking on the filter icon ‘’ right next to the column names. Search and click on the desired categories to filter and display those categories only, for better viewing purpose.
6. Station-Group Property Types and Codes Import Section – Import / Clean / Overwrite
The Station-Group property type Import can enable the functions to import / clean & Re-import / overwrite any types of station group property codes. By selecting different options, the Station-Group property type (Rev Parameter or Rev Carry Over Factor) can be added with default value / be clean & reimported / be overwritten. The detailed steps are shown below:
In the first selection bar, select a Station-Group type to configure the property type for. The options in the drop-down list will be all the potential Station-Group types. Please select the one you want to configure.
In the second selection bar, select the Station-Group property type (Rev Parameter or Rev Carry Over Factor) to take actions.
In the third selection bar, select the specific action on the selected Station-Group type and selected property type:
Clean & Re-Import: Clears existing data and Re-import the default data.
Overwrite: Overwrite all existing data.
Add Missing: Check if any property type code is missing in the data table and add the default value correspondingly. Using this ‘Add Missing’ will be a suitable action for many situations, e.g. when the property code data table is empty / wants to add any property code that is missing.
NOTE: Please use ‘Clean & Re-Import’ and ‘Overwrite’ with cautions. This is an action for bulk data process, and the data won’t be able to recall if used this function by mistake.
4. Click on ‘Import Properties’ at the right-side button to take action for the selected Station-Group type and selected property type code.
7. Station-Group Property Types and Codes Toolbar – Edit, Save, Delete
This section provides action buttons to make any changes (edit / delete) to the existing Station-Group Property Type Code data table.
7.1 Edit Grid
By clicking on the ‘Edit Grid ’ button, the Station-Group property type code data table becomes editable for a few fields (some fields are fixed in Geosens and cannot be edited).
Click on a field in Station-Group property type code data table to make any changes (e.g. change the property title displayed in the system or change the editable status for the property type code).
Click on ‘Save’ button to save any changes or click on ‘Cancel’ button to cancel any changes.
7.2 Delete
Tick to select a Station-Group property code that aims to be deleted.
Click on ‘Delete ’ to delete this Station-Group property code permanently. Please note to delete with caution: If it has been deleted wrongly, only the default value can be imported back by using the ‘Add Missing’ function in the Station-Group property type code Import Property Section.
8. General Workflow to Check & Edit Property Codes
1) Filter Data:
Use the dropdown menu to select a specific instrument or station-group type.
2) View Properties:
Examine property details such as Property Type, Property Title, Default Value/Text Value, and Data Type in the grid.
3) Edit Properties:
Click on the "Edit Grid" button to make inline edits to the property values.
Modify values such as Default Value or Notes as needed.
4) Import Properties:
Use "Import Properties" to add new property configurations.
Use "Clean & Re-Import" to clear existing data and import updated configurations.
5) Delete Properties:
Select a row and click the "Delete" button to remove it.
9. Best Practices
Always back up existing data before using the "Clean & Re-Import" function.
Use descriptive notes for properties to ensure clarity for future users.
Regularly review default values and data types to ensure accuracy.
10. Troubleshooting
1) Unable to Import Properties
Solution: Ensure the selected instrument/station-group type and property type are correct. There is also one possibility that No Property Types and Codes has been setup in the Global Level for this Type or Property.
2) Property Items have been updated, or new Items are introduced in the Global Level
Solution Case I: Use the "Overwrite" option if any property item in Global has been updated/Changed. However, please be noticed that any property data value or text value in the project must be backup as they will be overwritten.
Solution Case II: Use the "Add Missing" option if only new items from Global need to be imported, or when deleting property records which require to be updated is possible.
3) Issue: Incorrect pre-defined Data values or Text values in the project level
Solution Case I: Use the "Clean & Re-Import" option to reload property records, if the entire Property Types and Codes of the Type can be replaced.
Solution Case II: Use the "Overwrite" option to re-Import and replace current values in the Project Level.
Solution Case II: Use the "Add Missing" option to re-Import after deleting incorrect property records.
3) Issue: Missing all or some of Property Types & Codes records
Solution: Select Instrument/Station-Group type, the referred table (e.g. RevParam or RevCarry) and Import all or missing Property records. Then the user should check and update Property Title and default value/text value if required.
11. Support Contact
For further assistance, please contact IDD Tech SensGrid Support team.