Administrator Tools
Overview
The Datgel Administrator Tools gINT Add-In consists of 5 tools that provide
powerful functionalities and capabilities to your existing gINT database.
- Convert Project Tool: Convert gINT projects with extended options.
- 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 or Set Property Tool: Find or
set the property of a database, table or field gINT database.
- SQL Tool: Builds and executes SELECT, UPDATE, INSERT and DELETE SQL statements.
- Lookup List Check Tool: Checks all fields in the gINT project for lookups and verifies the value with the lookup source.
How It Works
Once installed you simply select the Datgel Administrator Tools from the gINT Add-Ins
Menu. You can access the five tools below from this menu.
The Convert Project Tool does a similar task to the native gINT command UTILITES
> Convert Project, but provides the option to search folders and sub-folders
for gINT projects and list the contents of a field on a Project level table which
could store the version number of the project file. This tool was designed to help
a company gINT Administrators manage the data template file versions of gINT projects
stored in many folders on a file server.
The Datgel Export Tool is designed to export most gINT exportable data formats to
either individual files or all in one file. In addition the Tool allows the user
to write a SQL query or use a pick to define the PointID to export.
The file formats supported are:
- Text (*.csv)
- Text (*.dat)
- Text (*.txt)
- Excel (*.xls)
- Database (*.gpj)
- Database (*.mdb)
- AGS (*.ags)
The Find and Set Property Tool is designed to search, display and set the properties
of fields, tables and database using filters or globally. These properties are
not always accessible through gINT.
SQL Tool can display the results of SELECT SQL queries and executes other
query types such as UPDATE, INSERT and DELETE. You also can export the result of
an SQL statement to an Excel file.
The Datgel Lookup List Check Tool scans the current project's fields to see
if the field requires a lookup, compares the values of the fields with the values
in the lookup source, and then writes any problems to a text file. This tool is
useful when checking if an imported database is compatible or compliant with the
lookup lists in the current database/library, and is also useful for checking the
integrity and validity of the existing data in the database.
This tool was designed to validate Data interchange standard pick lists, such as
those for AGS RTA Format.
User Guide
Read the comprehensive user guide.
Please contact us for additional pricing information.