Export Tool

Overview

The Datgel Export Tool is designed to export most gINT exportable data formats to either individual files or all in one file.  It is available in multiple Datgel products, including the Administrator Tools, DGD Tool and CPT Tool.  Only in the CPT Tool it can export GEF. 

Using the Tool

When using SQL Server, this Tool works with the current selected project in an Enterprise database.

Select INPUT | Add-Ins > Tool Name > Datgel Export Tool to launch the Datgel Export Tool.

The file formats supported are:

  • Text (*.csv)
  • Text (*.dat)
  • Text (*.txt)
  • Excel (*.xls, *.xlsm, *.xlsx)
  • Database (*.gpj)
  • Database (*.mdb)
  • AGS (*.ags)
  • GEF CPT-DATA and DISSIPATION-DATA 1.1.3 (*.gef)

Each file type group has specific options. For an explanation of these options please read the relevant gINT Help file topic. 

You have a choice of exported file configuration:

  • All PointIDs in one file – this is what gINT's native exporter does – to define the target file click on the File or Folder browse button.
  • Individual file for each PointID – unique to the Datgel Export Tool – to define the target folder click on the File or Folder browse button. Each file will have the same name as the exported PointID. Illegal characters such as \ and / are replaced by _ in the file name.

Optionally you may specify a data template file for export to gpj and mdb.

Optionally you may specify a correspondence file to export the PointIDs with by browsing to a correspondence file.

Optionally an SQL statement may be used to define a list of PointIDs to export. An example SQL statement can be inserted using the hyperlink text.

Optionally you may specify a comma separated list of tables to export in the Selected Tables text field. If this field is left blank, then all tables will be exported.

Default for many of the forms controls can be set and loaded using the Tool menu commands. The saved defaults are populated when the form is loaded. The initial directory for the File or Folder Browse is defined separately.

AGS Options - Check file after exports: the Export Tool will check if the AGS file has been exported correctly.

Excel Options – Separate worksheet for each PointID: the Export Tool will export the selected PointIDs to one Excel file, and table data for each PointID will be placed in separate worksheets.


GEF Export

The Data Export Tool allows you to export data to GEF format 1.1.3 CPT and Dissipation data. The function is located in INPUT > Add-Ins > Datgel CPT Tool > Export Tool.

Configuration

Form options

  • Language: select English or Netherlands
  • Dissipation tests: check to export this type of data
  • Pre-drill material description: check to export this type of data
  • File Name: SQL script to define file name
  • Columns: defines which data block columns will be exported.  If you check none, then all columns that have data will export.  Otherwise check the columns you want to export.
  • File or Folder: select a folder when the GEF files will be saved

Project database fields

The following fields were added specifically for the GEF data export:

  • PROJECT.Principal
  • POINT.Acquisiton_Framework
  • POINT.Delivery_Framework
  • CPT_GENERAL.Orientation_of_Inclination_Remark
  • ORGANISATION.Registration_Number
  • ORGANISATION.Country_Code
  • ELEVATION_DATUM.GEF_Number
  • COORDINATE_SYSTEM.GEF_Number

You need to have valid data in the following PROJECT table fields: Contractor, Coordinate System and Elevation Datum data. i.e. they the values need to exist in the lookup list table in the Lists group.

Library tables

The framework is user definable and expandable. Library tables named DG_EXP_GEF_* store the configuration

  • DG_EXP_GEF_01_FILE_TRACING
  • DG_EXP_GEF_02_DATA_DESCRIPTIVE
  • DG_EXP_GEF_03_DATA_COLUMN
  • DG_EXP_GEF_04_PROCEDURE_DESCRIPTIVE
  • DG_EXP_GEF_05_FILE_DESCRIPTIVE

The query formed for header data has a from clause that refers to the following tables: PROJECT, POINT, CPT_GENERAL, CPT_CONE_INFORMATION.  Other tables can be referenced via a sub query.

The query formed for body data has a from clause that refers to the following tables: CPT_DATA, CPT_DATA_ENVIRONMENTAL

On this page