User Guide

About the Product

The Datgel Administrator Tools gINT Add-In consists of nine tools that provide powerful functionalities and capabilities to your existing gINT system.

  • AGS Format Tool: Developer tools to help with the support of AGS Format within gINT.
  • Convert Projects Tool: Convert gINT access projects with extended options.
  • Excel Export Tool: Facilitates the export of data from gINT to a formatted excel template.
  • Export Tool: Exports data to several files types, either one file per PointID or all PointIDs in one file, and allows the user to define a filter.
  • Find and Set Property Tool: Find or Set the property of a database, table or field in gINT.
  • Import Correspondence File to Field Map Tool: Converts a gci file into a csv file in the format needed by DATA DESIGN | Project Database | Tools > Replace Field Names.
  • Import Tool: Batch imports data files in the formats: AGS, GPJ, MDB, XLSX/XLS, CSV, RMS ENCORE CSV, and VicRoads Excel Log XLSX/XLS.
  • Lookup List Check Tool: Checks all tables and fields in the gINT project for lookups and verifies the value with the lookup source.
  • SQL Tool: Builds and executes SELECT, UPDATE, INSERT and DELETE SQL statements.

New Features in Version 3.1

  • AGS Format Tool
  • Excel Export Tool
  • Import Correspondence File to Field Map Tool
  • Import Tool
  • Single User Hardware Key support for Win 8, Win 8.1 and Server 2012
  • Support for enterprise database / SQL Server in all tools

Versions Used When Writing This Document

This user guide has been written using:

  • Administrator Tools gINT Files 3.02
  • Administrator Tools DLL 3.1.0.0
  • gINT Professional Plus 8.30.04.242 or later
  • Windows 7 64 bit and 8.1 operating system

Support

You are eligible for support and maintenance if the DSM subscription for your license is current. For technical support please email support@datgel.com or call +61 2 8202 8600 or +65 6631 9780.

System Requirements

gINT

The product runs optimally using gINT 8.2.008 or 8.1.2.008 (23/Jun/2010 12:00:00 PM) or higher.

The Tools work with all product levels of gINT.

Hardware and Operating System

Windows 7 and Server 2008 or later, otherwise no additional system requirements to those for gINT.

Required Windows Components

  1. Windows Installer 4.5
  2. .NET 4.5.1 Framework

Installation and Activation

Before the Administrator Tools can be used you need to:

  1. Complete the installation procedure (see Installation and Licensing)
  2. Activate the product (see Datgel Product Licensing System)

About this Guide

This document is intended for use by both new users of Datgel Administrator Tools, and users who are ready to explore some of its more advanced features. It is assumed you have intermediate to advanced level skills with MS windows and gINT.

Conventions and typography used in this guide

Information


Tip


Warning


Note


ExampleDescription

>

Used to indicate a series of menu commands, e.g. Select File > Open.

|

Used to indicate a gINT Application Group, Application, Table Group or Table , e.g. DATA DESIGN | Project Database.

Bold Text

Items you must select, command buttons, or items in a list, e.g. Navigate to UTILITIES | Convert Projects (4th tab).

Italics Emphasis

Use to emphasize the importance of a point such as parameters, e.g. Data Entry – Check Omit Must Save prompt when save is required.

CAPITALS

Names of keys on the keyboard, for example, SHIFT, CTRL, or ALT.

KEY+KEY

Key combinations, for example CTRL+P, or ALT+F4.

Code Snippet

Indicates a code snippet within a paragraph.

Code sample

Indicates a sample program codes inserted in user guide e.g.

public override string ToString ()
File name or path

Used for formatting file name and paths e.g. abc lib.glb or V:\10 gINT\Datgel Install Files.

Table_Name

Database table name, e.g. POINT_TABLE.

Field_Name

Database field name; e.g. PointID.

Command line

Command line, presented exactly as it must be entered e.g. cdir.

Field Colours

Each of the fields in the project tables have been coloured to improve the data entry process as indicated the following table.

 Field Colour

Field Name and Explanation

Yellow

gINT Key Field – mandatory data entry

Pastel Purple

AGS Data – data associated with the AGS Data Interchange Format

Pastel Green

Calculated Field – data is written to this field by Datgel's code

Brown - Green

Data Enter and Calculated field

Pastel Beige

Data Entry Field – data should be entered into this field, or data in this field influences the calculation

Pastel Red

Legacy Data Field – historic data entered here, is typically from an old database

Pastel Blue

Output Option – used to control how data displays on a report

Pastel Orange

Remark or Metadata Field – additional data associated with the primary information

Grey

Read-only


On this page