Administrator Tools 2
Overview
The Datgel Administrator Tools gINT Add-In consists of 5 tools that provide
powerful functionalities and capabilities to your existing gINT system.
- Convert Project Tool: Convert gINT access 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 in gINT
- SQL Tool: Builds and executes SELECT, UPDATE, INSERT and DELETE SQL statements.
- Lookup List Check Tool: Checks all tables and fields in the gINT project for lookups and verifies the value with the lookup source.
New in Version 2
Where applicable, the Datgel Administrator Tools gINT Add-In also now supports gINT SQL Server (Enterprise) databases.
Convert Project Tool:
- Sub-folder search depth
- Informational Field caption grid column, and improved grid control
Export Tool:
- Option to create a separate worksheet for each PointID
- List tables to export
Find or Set Property Tool:
- Replace Substring option added – it is now possible to only partially change a value
- Batch Mode – This tool gives the user the ability to save an .xml file to record a set configuration of settings, and then re-use that configuration as required
SQL Tool:
- Project Select Options – it is now possible to run SQL queries by Current Project Only, All Projects, and Selected Project(s) in an Enterprise database
Lookup List Check Tool:
- Project Select Options – it is now possible to run the Lookup List Check tool against the Current Project, All Projects, and Selected Project(s) in an Enterprise database
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, *.dat, *.txt)
- Excel (*.xls, *.xlsx, *.xlsm)
- Database (*.gpj, *.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 in 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 data 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 customisation pricing, a
trial version and free demonstration either at your
office or using Webex