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
- Windows Installer 4.5
- .NET 4.5.1 Framework
Installation and Activation
Before the Administrator Tools can be used you need to:
- Complete the installation procedure (see Installation and Licensing)
- 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
| Example | Description |
|---|---|
> | 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 |