1. Introduction
The Instrument Data Columns page lets administrators define, import, and manage the set of data fields (columns) that every instrument type uses when uploading or entering measurements. Configuring these columns ensures data files and manual entries map correctly into GeoSens.
Note: All instrument data columns have been pre-configured at the global level in Geosens for each instrument type. This standardization helps streamline data processing and reduce setup time.
As a result, this page is primarily designed for administrators to customize how the data is displayed—such as adjusting column headers, changing the order of columns, and modifying other visual settings.
2. Page Navigation
Sign in to GeoSens.
In the left menu expand Instrument → click Instrument Data Columns.
3. Instrument Data Columns Data Grid Introduction
This section introduces each field in the data grid.
3.1 Field introduction
Field | Description |
Instrument Type | The instrument type the data column belongs to. |
Column Index | Numeric position of the data column in instrument data grid. NOTE: The column index must be numeric and cannot duplicates. For example, for the same instrument type and same usage type, column indexes must be unique, because it indicates the order of each column. |
Column Identifier | Internal code recognized by system. |
Column Header | User-friendly label displaying in data grid (e.g. “Instrument Name”, “Level”). |
Short Code | Abbreviated label for compact displays or exports. |
Data Type | Underlying type: String, Number, Date-Time, Boolean, etc. |
Data Format | Formatting guidance (e.g. |
Data Unit | Measurement unit (e.g. “mRL”, “mm”, “kPa”). |
Usage Type | Indicates where this column is used (e.g. CALI, DATA, REV). |
Enabled | ✓ tick to ensure the column data is active and in Geosens operation. |
Is Editable | ✓ tick to ensure users can modify this field and change data in instrument data grid page. |
Is Visible | ✓ tick to ensure the field appears in instrument data grid. ✕ means it will not show in the instrument data grid, but still in Geosens operation if enabled is ticked. |
Is Nullable | ✓ tick to ensure empty values are allowed; ✕ means it requires a value on import or entry. |
3.2 Viewing additional Information Column
Additional columns can be dragged and dropped from the column chooser '
' into the data table to customize the view and add more information.
Field Name | Introduction |
instruDataCollId | A unique identifier for the instrument data collection entry. |
instruTypeId | The identifier linking the entry to a specific instrument type. |
Notes | Additional comments or information related to the data collection. |
Is Prj Column | Indicates whether the field is specific to the project. |
Has Custom Column | Indicates whether the entry includes custom-defined columns. |
Created By | The user who originally created the data collection entry. |
Created On | The date and time when the entry was first created. |
Updated By | The user who last modified the entry. |
Updated On | The date and time of the most recent update to the entry. |
3.3 Viewing & Filtering Columns
Select Instrument Type: Choose your instrument (e.g. Survey Settlement Point (SSP)).
Select Category: Typically DATA for measurement columns.
Sort: Click any column header (e.g. Column Index) to reorder.
Filter: Hover over a header, click the funnel icon, and set criteria (e.g. Data Type = “Number”).
4. Data Column Function Bar Introduction
This section provides introductions on function bar that located at the top-right corner of the instrument data column data grid.
Function Name | Introduction |
Edit Grid | Allows customization of the grid layout and content for better data management. Click 'Edit Grid' to enter inline edit mode and make changes directly in the table cell. |
Import | Enables uploading or bringing in data from external sources into the system. Click the link to download the data template, fill the data, and click Import to finish bulk upload. 
|
Export | Allows downloading or saving data from the system to external formats. 
|
Edit | Tick to select an existing data column row, and click on 'Edit' to open its setting panel and make changes. |
Delete | Tick to select an existing data column row to remove selected entries from the system. |
5. How to Import Instrument Data Columns
NOTE: All Instruments Data Columns have been pre-configured in Geosens by-default. Therefore, by using the import columns function in this section, all the pre-configured data columns can be brought into this project for bulk import.
On the top of the data column data grid, locate the import function.
Select required instrument type (e.g. XYZ Prism), and select the data column type (e.g. INIT / REV / DATA) to be imported.
Click on 'Import Columns' to bring all the pre-configured data columns into this project.
Please repeat steps 1-3 to ensure all instrument types and all data column types have been imported.
If it's necessary to make changes on the column Index, Column header, etc, users can click on 'Edit Grid' to enter inline edit mode; or select to click 'Edit' and open setting panel to make changes.
NOTE: When import data columns, please ensure all necessary instrument types and all data column types have been imported.
6. How to Bulk Import Columns by File uploading
Click on the 'Import' button to open the import panel and download the data template file.
Prepare a CSV file by filling necessary information to the downloaded template.
Upload the prepared csv file and click on 'import' to upload data columns.
Review the imported data columns in the data grid and make changes if necessary.
7. Application Example on Column Index, header, etc
7.1 Example on checking imported data columns
Use the filter next to column header 'Instrument type' to filter out 'XYZ Prism'
Use the filter next to column header 'Usage Type' to filter out 'DATA'.
The current data grid shows all the data columns to be displayed for XYZ Prism DATA data grid.
Check the Column Index column if they are all unique, and edit to change column order if necessary.
Check the Column header column to change the displaying header name if necessary.
On the right-hand side 'Enabled / Is Editable / Is Visible / Is Nullable', edit to change the ticked status, in order to enable the column, allow-editing, allow visibility, allow empty data cell.
7.2 Example on column index & column header application
The instrument data columns will take effect and show in the instrument page.
To access the instrument page to view the effect:
Click on the top-left corner setting panel, click to expand 'Instrument', and click on 'Instrument' page to enter.
Use the filter to select instrument type as 'XYZ Prism' and click on any instrument to load the data.
In the middle section of the page, the selected instrument data grid table will appear, based on the instrument data column configurations.
InstrumentName will be named as 'Survey XYZ Name', placed at 1st column in the instrument data grid (column index =1).
InstrumentRevision will be named as 'Revision', placed at 2nd column in the instrument data grid (column index =2).
InstrumentDateTime will be named as 'Date-Time', placed at 3rd column in the instrument data grid (column index =3).
Easting will be named as 'Easting', placed at 4th column in the instrument data grid (column index =4).
7.3 Example on Enable/editable/visible/nullable functions
The instrument data columns will take effect and show in the instrument page, following the same steps to enter the instrument page and locate a XYZ data grid to see the effects:
InstrumentName is visible, so it's named as 'Survey XYZ Name' to be displayed in the 1st column.
InstrumentRevision is invisible, even it's placed as the 2nd column, it will not appear in the instrument data grid.
InstrumentDateTime is visible, so it's named as 'Date-Time' to be displayed in the 3rd column (since 2nd column is not showing, so it shows as the 2nd column).