|
Datgel Administrator Tools gINT Add-In
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.
Convert Projects Tool
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.
Export Tool
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)
Find or Set Property Tool
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
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.
Lookup List Check Tool
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.
Please contact us additional pricing information.
|