The below example file was created as a starting level mapping file to import some gINT data into OpenGround.
Who is this mapping for?
It will import a number of basic fields from a gINT project file (GPJ) that is based on a UK gINT AGS 3.1 library and will import into any UK Standard configuration pack or a configuration pack derived from it. It can be used by any organisation and imported and used as needed. The mapping file can also be adjusted as required and used as a base for more advanced mapping if required.
What is Mapped?
The following tables and fields are mapped with this example mapping;
| Project | ||||||
| PROJ_ID | PROJ_NAME | PROJ_LOC | PROJ_CLNT | PROJ_CONT | PROJ_ENG | PROJ_MEMO |
Maps to the Project table in OpenGround.
| POINT | ||||||||||||||
| PointID | HOLE_TYPE | HOLE_NATE | HOLE_NATN | HOLE_GL | HoleDepth | HOLE_STAR | HOLE_ENDD | HOLE_REM | HOLE_ETRV | HOLE_NTRV | HOLE_LTRV | HOLE_LETT | HOLE_LOCM | HOLE_CLST |
| PointID | HoleDepth | HOLE_TYPE | HOLE_LOG | HOLE_CREW | HOLE_EXC | HOLE_SHOR | HOLE_STAB | HOLE_DIML | HOLE_DIMW | |||||
| PointID | HOLE_FDEP | HOLE_ORNT | HOLE_INCL | |||||||||||
Maps to the LocationDetails, DepthRelatedExploratoryInformation and OrientationAndInclination tables respectively in OpenGround.
| GEOL | |||||||
| PointID | Depth | GEOL_BASE | GEOL_DESC | GEOL_GEOL | GEOL_LEG | GEOL_GEO2 | GEOL_STAT |
Maps to the StratumDetails table in OpenGround
| SAMP | ||||||||||||||||
| PointID | Depth | SAMP_REF | SAMP_TYPE | SAMP_BASE | SAMP_UBLO | SAMP_WDEP | SAMP_DIA | SAMP_DESC | SAMP_REM | SAMPE_DATE | SAMP_TIME | SAMP_BAR | SAMP_WDEP | SAMP_TEMP | SAMP_PRES | SAMP_FLOW |
Maps to the SampleInformation table in OpenGround.
| BKFL | |||
| PointID | BKFL_BASE | BKFL_SYMB | Depth |
Maps to the BackillDetails table in OpenGround.
| CHIS | |||||
| PointID | Depth | CHIS_TO | CHIS_TIME | CHIS_TOOL | CHIS_REM |
Maps to the Chiselling table in OpenGround.
| DETL | |||
| PointID | Depth | DETL_BASE | DETL_DESC |
Maps to the StratumDetailDescriptions table in OpenGround
| ISPT | |||||||||||||||||||||||
| PointID | ISPT_SWP | Depth | ISPT_SEAT | ISPT_MAIN | ISPT_NPEN | ISPT_NVAL | ISPT_REP | ISPT_CAS | ISPT_WAT | ISPT_TYPE | ISPT_REM | ISPT_INC1 | ISPT_INC2 | ISPT_INC3 | ISPT_INC4 | ISPT_INC5 | ISPT_INC6 | ISPT_PEN1 | ISPT_PEN2 | ISPT_PEN3 | ISPT_PEN4 | ISPT_PEN5 | ISPT_PEN6 |
Maps to the SPT table in OpenGround
| WSTK | |||||
| PointID | Depth | WSTK_CAS | WSTK_DATE | WSTK_TIME | WSTK_SEAL |
| PointID | Depth | WSTK_NMIN | WSTK_POST | WSTK_FLOW | |
Maps to the WaterStrikeGeneral and WaterStrikeDetails tables respectively in OpenGround
| CORE | |||||||
| PointID | CORE_BOT | Depth | CORE_DIAM | CORE_PREC | CORE_REM | CORE_RQD | CORE_SREC |
Maps to the Coring table in OpenGround.
| DPRG | ||||||||||||
| PointID | DPRG_ANG | DRPG_RMSS | DPRG_CONE | DPRG_DAMP | DPRG_DROP | DPRG_MASS | DPRG_REM | DPRG_ROD | DPRG_TEST | DPRG_TIP | DPRG_TYPE | |
Maps to the DynamicProbeGeneral table in OpenGround.
| DPRB | ||||||
| PointID | DPRB_BLOW | DPRB_DEL | Depth | DPRB_INC | DPRB_REM | DPRB_TORQ |
Notes and Special Cases
In this mapping, the main majority of mapping is a simple 1 to 1 for each table and field. However, there are some exceptions which are worth noting;
- POINT
- The Point table gets split into 3 different tables in OpenGround; LocationDetails, DepthRelatedExploratoryInformation and OrientationandInclination.
- A special function is used to extract the start and end dates in the correct format.
- DepthRelatedExploratoryInformation and OrientationandInclination - A constant value of 0 is entered for the depth top to simulate the top of the hole.
- SAMP
- SAMP_DATE and SAMP_TIME are concatenated together if there is a SAMP_TIME record, else a value of 00:00 is used for the time.
- WSTK
- WSTK_DATE and WSTK_TIME are concatenated together if there is a WSTK_TIME record, else a value of 00:00 is used for the time.
- DPRG and DPRB
- TestNumber is a required field in OpenGround due to this being a key field, therefore a value of null is entered in the mapping in order to facilitate an import.
How To Import
A gINT import mapping file can be imported into a configuration pack and be available for use in all projects on that configuration pack by following these steps;
- Open OpenGround Professional and select the System - Configuration Packs
- Select the required configuration pack in the grid, then select Configuration Tools - Transfer Mapping - Upload Import XML Mapping
- Select the File Format to be gINT, enter a name for the mapping and browse through the mapping file, then select iimport.
The mapping will then be available when importing data into a project in OpenGround Professional.
Download the File
communities.bentley.com/.../UK-GINT-Example-File.xml
Note, click on the UK Gint Example File.xml link at the top right of the preview to download the file.