UK Example File

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

Fullscreen UK GINT Example File.xml Download

<inputs>
	<input group="PROJECT">
		<output group="Project">
			<row>
				<field mode="Copy" destination="ProjectID" source="PROJ_ID" key="true" />
				<field mode="Copy" destination="ProjectTitle" source="PROJ_NAME" />
				<field mode="Copy" destination="SiteLocation" source="PROJ_LOC" />
				<field mode="Copy" destination="ClientName" source="PROJ_CLNT" />
				<field mode="Copy" destination="ContractorsName" source="PROJ_CONT" />
				<field mode="Copy" destination="ProjectEngineer" source="PROJ_ENG" />
				<field mode="Copy" destination="Remarks" source="PROJ_MEMO" />
			</row>
		</output>
	</input>

	<input group="POINT">	
		<output group="LocationDetails">
			<row condition="IsLocationValid('PointID')" merge="true">
				<field mode="Copy" destination="LocationID" source="PointID" key="true" />
				<field mode="Copy" destination="LocationType" source="HOLE_TYPE" />
				<field mode="Copy" destination="Easting" source="HOLE_NATE" />
				<field mode="Copy" destination="Northing" source="HOLE_NATN" />
				<field mode="Copy" destination="GroundLevel" source="HOLE_GL" />
				<field mode="Copy" destination="FinalDepth" source="HoleDepth" />
				<field mode="Evaluate" condition="IsDefined('HOLE_STAR')" expression="GetTimestamp(HOLE_STAR, '0000', 'hhmm')" destination="DateStart" />
				<field mode="Evaluate" condition="IsDefined('HOLE_ENDD')" expression="GetTimestamp(HOLE_ENDD, '0000', 'hhmm')" destination="DateEnd" />
				<field mode="Copy" destination="Remarks" source="HOLE_REM" />
				<field mode="Copy" destination="EastingTraverseEnd" source="HOLE_ETRV" />
				<field mode="Copy" destination="NorthingTraverseEnd" source="HOLE_NTRV" />
				<field mode="Copy" destination="GroundLevelEnd" source="HOLE_LTRV" />
				<field mode="Copy" destination="GridLetterReference" source="HOLE_LETT" />
				<field mode="Copy" destination="LocationingMethod" source="HOLE_LOCM" />
				<field mode="Copy" destination="Phase" source="HOLE_CLST" />
			</row>
		</output>
		 <output group="DepthRelatedExploratoryInformation">
			<row condition="IsLocationValid('PointID')" merge="true">
				<field mode="Copy" destination="LocationID" source="PointID" key="true" />
				<field mode="Constant" default="0" destination="DepthTop" key="true" />
				<field mode="Copy" destination="DepthBase" source="HoleDepth" key="true" />
				<field mode="Copy" destination="Type" source="HOLE_TYPE" key="true" />
				<field mode="Copy" destination="Logger" source="HOLE_LOG" safe-merge="true"/>
				<field mode="Copy" destination="RigCrew" source="HOLE_CREW" safe-merge="true"/>
				<field mode="Copy" destination="PlantUsed" source="HOLE_EXC" safe-merge="true"/>
				<field mode="Copy" destination="ShoringUsed" source="HOLE_SHOR" safe-merge="true"/>
				<field mode="Copy" destination="PitStability" source="HOLE_STAB" />
				<field mode="Copy" destination="PitLength" source="HOLE_DIML" />
				<field mode="Copy" destination="PitWidth" source="HOLE_DIMW" />
			</row>
		</output>
		<output group="OrientationAndInclination">
			<row condition="IsLocationValid('PointID')" merge="true">
				<field mode="Copy" destination="LocationID" source="PointID" key="true" />
				<field mode="Constant" default="0" destination="DepthTop" key="true" />
				<field mode="Copy" destination="DepthBase" source="HOLE_FDEP" key="true" />
				<field mode="Copy" destination="Orientation" source="HOLE_ORNT" />
				<field mode="Copy" destination="Inclination" source="HOLE_INCL" />
			</row>
		</output>	
	</input>	
	<input group="GEOL">
		<output group="StratumDetails">
			<row condition="IsLocationValid('PointID')">
				<field mode="Copy" destination="LocationID" source="PointID" key="true" />
				<field mode="Copy" destination="DepthTop" source="Depth" key="true" />
				<field mode="Copy" destination="DepthBase" source="GEOL_BASE" key="true" />
				<field mode="Copy" destination="Description" source="GEOL_DESC" />
				<field mode="Copy" destination="GeologyCode" source="GEOL_GEOL" />
				<field mode="Copy" destination="LegendCode" source="GEOL_LEG" />
				<field mode="Copy" destination="GeologyCode2" source="GEOL_GEO2" />
				<field mode="Copy" destination="StratumReference" source="GEOL_STAT" />
			</row>
		</output>
	</input> 	
	<input group="SAMP">
		<output group="SampleInformation">
			<row condition="IsLocationValid('PointID')">
				<field mode="Copy" destination="LocationID" source="PointID" key="true" />
				<field mode="Copy" destination="DepthTop" source="Depth" key="true" />
				<field mode="Copy" destination="SampleReference" source="SAMP_REF" default="" key="true" />
				<field mode="Copy" destination="Type" source="SAMP_TYPE" key="true" />
				<field mode="Copy" destination="DepthBase" source="SAMP_BASE" />
				<field mode="Copy" destination="Blows" source="SAMP_UBLO" />
				<field mode="Copy" destination="WaterDepth" source="SAMP_WDEP" />
				<field mode="Copy" destination="Diameter" source="SAMP_DIA" />
				<field mode="Copy" destination="Description" source="SAMP_DESC" />
				<field mode="Copy" destination="Remarks" source="SAMP_REM" />					
				<field mode="Evaluate" condition="IsDefined('SAMP_DATE') and IsUndefined('SAMP_TIME')" destination="DateTimeSampled" expression="GetTimestamp(SAMP_DATE, '0000', 'hhmm')" />				
				<field mode="Evaluate" condition="IsDefined('SAMP_DATE') and IsDefined('SAMP_TIME')" destination="DateTimeSampled" expression="GetTimestamp(SAMP_DATE, SAMP_TIME, 'hhmm')" />							
				<field mode="Copy" destination="BarometricPressure" source="SAMP_BAR" />
				<field mode="Copy" destination="WaterDepth" source="SAMP_WDEP" />
				<field mode="Copy" destination="Temperature" source="SAMP_TEMP" />
				<field mode="Copy" destination="GasPressure" source="SAMP_PRES" />
				<field mode="Copy" destination="GasFlowRate" source="SAMP_FLOW" />
			</row>
		</output>
	</input>	
	<input group="BKFL">
		<output group="BackfillDetails">
		  <row condition="IsLocationValid('PointID')">
			<field mode="Copy" destination="DepthBase" source="BKFL_BASE" />
			<field mode="Copy" destination="Description" source="BKFL_SYMB" />
			<field mode="Copy" destination="DepthTop" source="Depth" key="true" />
			<field mode="Copy" destination="LocationID" source="PointID" key="true" />
		  </row>
		</output>
	</input>	
	<input group="CHIS">
		<output group="Chiselling">
			<row condition="IsProjectValid('PROJ_ID')">
				<field mode="Copy" destination="LocationID" source="PointID" key="true" />
				<field mode="Copy" destination="DepthTop" source="Depth" key="true" />
				<field mode="Copy" destination="DepthBase" source="CHIS_TO"  />
				<field mode="Copy" destination="Duration" source="CHIS_TIME" />
				<field mode="Copy" destination="Tool" source="CHIS_TOOL" />
				<field mode="Copy" destination="Remarks" source="CHIS_REM" />
			</row>
		</output>
	</input>	
	<input group="DETL">
		<output group="StratumDetailDescriptions">
			<row condition="IsLocationValid('PointID')">
				<field mode="Copy" destination="LocationID" source="PointID" key="true" />
				<field mode="Copy" destination="DepthTop" source="Depth" key="true" />
				<field mode="Copy" destination="DepthBase" source="DETL_BASE" key="true" />
				<field mode="Copy" destination="Description" source="DETL_DESC" />
			</row>
		</output>
	</input> 		
	<input group="ISPT">	
		<output group="SPT">
			<row condition="IsLocationValid('PointID')" merge="true">
				<field mode="Copy" destination="SelfWeightPenetration" source="ISPT_SWP" />
				<field mode="Copy" destination="LocationID" source="PointID" key="true" />
				<field mode="Copy" destination="DepthTop" source="Depth" key="true" />
				<field mode="Copy" destination="BlowsSeating" source="ISPT_SEAT" />
				<field mode="Copy" destination="BlowsMainTotal" source="ISPT_MAIN" />
				<field mode="Copy" destination="PenetrationTotal" source="ISPT_NPEN" />
				<field mode="Copy" destination="NValue" source="ISPT_NVAL" />
				<field mode="Copy" destination="ReportedResult" source="ISPT_REP" />
				<field mode="Copy" destination="DepthCasing" source="ISPT_CAS" />
				<field mode="Copy" destination="DepthWater" source="ISPT_WAT" />
				<field mode="Copy" destination="TestType" source="ISPT_TYPE" />
				<field mode="Copy" destination="Remarks" source="ISPT_REM" />
				<field mode="Copy" destination="BlowsSeating1" source="ISPT_INC1" />
				<field mode="Copy" destination="BlowsSeating2" source="ISPT_INC2" />
				<field mode="Copy" destination="BlowsMain1" source="ISPT_INC3" />
				<field mode="Copy" destination="BlowsMain2" source="ISPT_INC4" />
				<field mode="Copy" destination="BlowsMain3" source="ISPT_INC5" />
				<field mode="Copy" destination="BlowsMain4" source="ISPT_INC6" />
				<field mode="Copy" destination="PenetrationSeating1" source="ISPT_PEN1" />
				<field mode="Copy" destination="PenetrationSeating2" source="ISPT_PEN2" />
				<field mode="Copy" destination="PenetrationMain1" source="ISPT_PEN3" />
				<field mode="Copy" destination="PenetrationMain2" source="ISPT_PEN4" />
				<field mode="Copy" destination="PenetrationMain3" source="ISPT_PEN5" />
				<field mode="Copy" destination="PenetrationMain4" source="ISPT_PEN6" />
			</row>
		</output>
	</input>	
	<input group="WSTK">
		<output group="WaterStrikeGeneral">
			<row condition="IsLocationValid('PointID')" merge="true">
				<field mode="Copy" destination="LocationID" source="PointID" key="true" />
				<field mode="Copy" destination="DepthStrike" source="Depth" key="true" />
				<field mode="Copy" destination="DepthCasing" source="WSTK_CAS" />
				<field mode="Evaluate" condition="IsDefined('WSTK_DATE') and IsUndefined('WSTK_TIME')" destination="DateTime" expression="GetTimestamp(WSTK_DATE, '0000', 'hhmm')" />				
				<field mode="Evaluate" condition="IsDefined('WSTK_DATE') and IsDefined('WSTK_TIME')" destination="DateTime" expression="GetTimestamp(WSTK_DATE, WSTK_TIME, 'hhmm')" />									
				<field mode="Copy" destination="DepthSealed" source="WSTK_SEAL" />
			</row>
		</output>
		<output group="WaterStrikeDetails">
		  <row condition="IsLocationValid('PointID') and IsDefined('W5MIN')" merge="true">
				<field mode="Copy" destination="LocationID" source="PointID" key="true" />
				<field mode="Copy" destination="DepthStrike" source="Depth" key="true" />
				<field mode="Copy" destination="TimeElapsed" source="WSTK_NMIN" key="true" />
				<field mode="Copy" destination="DepthWater" source="WSTK_POST" />
				<field mode="Copy" destination="Remarks" source="WSTK_FLOW" />
			</row>
		</output>	
	</input> 	
	<input group="CORE">
		<output group="Coring">
      			<row condition="IsLocationValid('PointID')">
        			<field mode="Copy" source="CORE_BOT" destination="DepthBase" key="true" />
        			<field mode="Copy" source="CORE_DIAM" destination="Diameter" />
       				<field mode="Copy" source="CORE_PREC" destination="TCR" />
        			<field mode="Copy" source="CORE_REM" destination="Remarks" />
        			<field mode="Copy" source="CORE_RQD" destination="RQD" />
       				<field mode="Copy" source="CORE_SREC" destination="SCR" />
        			<field mode="Copy" source="Depth" destination="DepthTop" key="true" />
       				<field mode="Copy" source="PointID" destination="LocationID" key="true" />
      			</row>
    		</output>
	</input>
	  <input group="DPRG">
		<output group="DynamicProbeGeneral">
      			<row condition="IsLocationValid('PointID')">
				<field mode="Copy" source="DPRG_ANG" destination="ConeAngle" />
       				<field mode="Copy" source="DPRG_RMSS" destination="RodMass" />
        			<field mode="Copy" source="DPRG_CONE" destination="DiameterCone" />
        			<field mode="Copy" source="DPRG_DAMP" destination="AnvilDampertype" />
        			<field mode="Copy" source="DPRG_DROP" destination="StandardDrop" />
        			<field mode="Copy" source="DPRG_MASS" destination="HammerMass" />
        			<field mode="Copy" source="DPRG_REM" destination="Remarks" />
        			<field mode="Copy" source="DPRG_ROD" destination="RodDiameter" />
        			<field mode="Constant" destination="TestNumber" default="" key="true" />
        			<field mode="Copy" source="DPRG_TEST" destination="Method" />
        			<field mode="Copy" source="DPRG_TIP" destination="FinalConeDepth" />
        			<field mode="Copy" source="DPRG_TYPE" destination="ProbeType" />
        			<field mode="Copy" source="PointID" destination="LocationID" key="true" />
      			</row>
    		</output>
  	</input>
	  <input group="DPRB">
		<output group="DynamicProbeData">
      			<row condition="IsLocationValid('PointID')">
        			<field mode="Copy" source="DPRB_BLOW" destination="BlowsIncrement" />
        			<field mode="Copy" source="DPRB_DEL" destination="Delay" />
        			<field mode="Copy" source="Depth" destination="DepthTop" key="true" />
        			<field mode="Copy" source="DPRB_INC" destination="DepthIncrement" />
        			<field mode="Copy" source="DPRB_REM" destination="Remarks" />
        			<field mode="Copy" source="DPRB_TORQ" destination="Torque" />
        			<field mode="Constant" destination="TestNumber" default="" key="true" />
        			<field mode="Copy" source="PointID" destination="LocationID" key="true" />
      			</row>
    		</output>
  	</input>  
</inputs>

Note, click on the UK Gint Example File.xml link at the top right of the preview to download the file.

Created by Stephen Evason
When: Wed, Nov 10 2021 8:48 AM
Last revision by Stephen Evason
When: Wed, Nov 10 2021 10:23 AM
Revisions: 3
Comments: 0

Recommended