The Datgel Administrator Tools gINT Add-In consists of nine tools that provide powerful functionalities and capabilities to your existing gINT system.
Once installed you simply select the Datgel Administrator Tools from the gINT INPUT Add-Ins Menu.
The AGS Format Tool helps developers to support AGS format in gINT. It reads the Excel data dictionary file in the structure used by the AGS Committee in the UK, and produces files that a gINT developer needs to create correspondence files and test correspondence files. Further, it generates a gINT AGS Scheme file (*.gas) which otherwise is very hard to generate, and will strip continuation lines out of AGS 3.1 files to assist a developer with testing.
The Convert Projects 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 Excel Export Tool facilitates the export of data from gINT to a formatted excel template. Configuration for what data is exported and where it is places is stored in an XML file. Useful to generate lab testing schedules in Excel.
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:
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.
Converts a gci file into a csv file in the format needed by DATA DESIGN | Project Database | Tools > Replace Field Names. Unless your gci file is very simple, you will need to open to csv file in Excel and make manual changes before using the field map data.
The import tool allows for the import of one or many data files in the standard gINT supported formats of AGS, database excel and CSV. Further it includes import support for the RMS ENCORE Lab data file used by the Roads and Maritime Service in NSW Australia, and the VicRoads Excel Borehole log file used by VicRoads in Victoria Australia.
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.
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.