Aller au contenu
SGS logo SGS Geological Services

Custom Tables

Overview

The Custom Tables window is used to manage data tables in GENESIS.

Custom Tables

It includes:

  • Fixed tables (for example: Collars, Assays, Deviations, Lithology, Mineralization, Alteration, RQD, Geochemistry, Structure)
  • Custom tables created by the user

You can create tables, import/reimport data, edit schema and display, run extraction/tagging operations, and validate content.

Table Types

When creating a table, choose one type:

  • From-To (Interval): requires interval-style records
  • Depth: requires depth-based records
  • Point: requires XYZ records
  • Other: special/custom use

Default key fields added by type:

  • Interval: HoleName, FromDepth, ToDepth
  • Depth: HoleName, Depth
  • Point: HoleName (optional), x, y, z

Create a Custom Table

  1. Open Custom Tables.
  2. Go to File > Create Table…
  3. Enter:
    • table name
    • table type
    • source file (optional at creation)
  4. In Custom Table Parameters, define additional variables.
  5. Complete import preparation/matching and load data.

Supported source formats in the create/import flows include:

  • .csv
  • .xls, .xlsx
  • .dat, .txt
  • .mdb, .accdb
  • .gnft (import dialog)

Import and Reimport

Import

Use File > Import… on a selected table.

Options:

  • Overwrite Only: can replace existing values
  • Append Only: keeps existing values and adds new rows
  • If both are off, GENESIS warns that table data will be cleared before import.

Reimport

Use File > Reimport to reload selected table(s) with saved import settings.

Fixed vs Custom Table Rules

  • Fixed tables are part of core drillhole workflow.
  • Custom tables are user-defined.
  • You can change a table classification with Edit > Data Type…
  • Fixed tables cannot be deleted.

Edit Data Type

Use Edit > Data Type… to reclassify a selected table.

Available choices depend on table geometry:

  • Interval tables: Assays, Lithology, Picture, Alterations, Mineralization, RQDS, Custom
  • Depth tables: Structure, Custom
  • Point tables: Collars, Custom

QAQC tables keep their specific QAQC category.

Edit Schema

Use Edit > Schema… to add/remove fields and adjust table schema parameters.

Edit Schema

Display and Color

Display settings

Use Edit > Display… to configure:

  • global vs table-specific color usage
  • color mode (interval color or dictionary color)
  • dictionary variable (text field)
  • fixed size vs variable-driven size
  • thickmarks visibility

Color table

Use Edit > Color Table… to manage interval and dictionary color tables.

Copy display

Use Edit > Copy Display… to apply one table’s display settings to other selected tables.

View, Export, and Log

  • File > View…: open data viewer for selected table
  • File > Export…: export selected table(s)
  • Log > View Log…: review action/import history for a table

Operations

The Operation menu provides advanced table tools.

Extract From Envelope…

Create a new table containing only records inside selected envelope(s).

Extract From SQL Query…

Create a new table using an SQL-compatible WHERE condition.

Example: Au > 0

Extract By Tag…

Extract by variable tag value:

  • use one specified tag, or
  • auto-create one output table per distinct tag value

Project on surface…

Project point data onto a selected surface envelope.

Notes:

  • For regular point tables: creates a new projected table.
  • For collars: modifies collar elevation and keeps a hidden backup table of original collar coordinates.

Import Column…

Import selected field(s) from another table into the current table.

Features:

  • adds missing target fields automatically
  • optional clearing of existing target fields
  • supports aggregation when multiple source values match:
    • First Value
    • Average
    • Highest
    • Sum
    • Mode

Transform to composites

Convert selected table(s) into composites.

Tag By Envelope…

Assign a tag value to selected fields for records inside envelope(s).

Tag value can come from:

  • a specified value
  • envelope tag
  • envelope name

Set Tag…

Bulk-assign a tag to selected variable(s) across selected table(s).

This action is irreversible.

Validation Tools

Use Validate menu:

  • Fixed Tables: validate core fixed tables
  • Selected Tables: validate only currently selected tables

Practical Notes

  • Interval/Depth tables are generally used with existing drillhole context.
  • Point tables can also be used independently (XYZ data).
  • After imports or operations, refresh/repaint updates are applied automatically in the table list and views.