Exporting Data from gINT for Import into an InRoads Data Set

The File > Import/Export > Export to InRoads File command in INPUT allows generation of a Bentley InRoads‐compatible file, which details the layer boundaries within boreholes that define InRoads surfaces.

Correspondence File

To export subsurface data from gINT for import into an InRoads data set, you will need a correspondence file. This is used to map the fields in the source file to the fields in the target file when the table‐and‐field structures of the files don't match. It is used when importing or exporting spreadsheets, Access databases, delimited text files, or gINT projects.

gINT provides a DATA DESIGN utility to make it simple to create these files. (It is possible to create correspondence files with a text editor, but the gINT application is faster to use and less error‐prone.) Once you have a correspondence file for exporting to InRoads format, you can use it for export of these files as often as needed.

To build a correspondence file for export of gINT data to an InRoads‐compatible file:

  • Point the Source File field to a file containing your own database structure. Usually this is a data template file, although a project file can also be used.
  • Point the Target File field to a file with a CSV extension which contains the following lines:

**POINT
PointID,East,North,Station,Offset
**LAYER
PointID,LayerID,Top Depth,Description,Style

POINT Fields

  • In mapping your fields to the target structure, you can use East and North, or Station and Offset. If points are located in your gINT database using station and offset, on import to InRoads you will need to specify an alignment that matches your stations and offsets.
  • Offsets are negative to the left.
  • Stations must be in decimal format; there can be no '+' characters. For example, 123+45.67 needs to be exported as 12345.67. If you are using the "+" in your stations, write the following expression in the correspondence file:

<<Replace(<<TABLE.Field>>,0,0,+,)>>

   where <<TABLE.Field>> is the table and field where your station data are stored. This will replace '+' with nothing.

LAYER Fields

  • LayerID ‐ anything you wish to name each layer
  • Description ‐ limited to 63 characters
  • Style ‐ corresponds to a display style defined in your InRoads model; definable by you
  • PointID and Top Depth correspond to these values in the gINT Project database 
  • Surface elevation for each PointID is not exported.

Export to InRoads

  1. Select File > Import/Export > Export to InRoads File.
  2. Click Reset.
  3. Click the Browse button to the right of InRoads File.
  4. Specify a File name of InRoads Export in the \gINT\projects\ folder.
  5. Click the Browse button to the right of Correspondence File.
  6. Specify the path and filename of the export correspondence file you created for InRoads export.
  7. Leave the Select Points field blank to export all data; Click the Browse button to the right of this field to select points to export.
  8. Click OK.

The status log is generated.

After exporting from gINT in this way, you must associate the data upon import into InRoads with a ground surface defined in InRoads.