gINT | Keynetix - gINT RULES SAMPLES

gINT Rules is a facility within the gINT Input and Library Data applications that allows you to write VBA-like code to run checks on your data entry and perform calculations and other data manipulations. These are called database rules. You create them to meet your unique and changing requirements.

The gINT Rules example gra005 has a set of videos posted with it that describes how to use the example gINT Rule to make calculations and populate fields in the database with a gINT Rule (Procedure on Save option), and also details the newly-added Import Add-In option with videos that describe; Introduction, Process, and Setup; Direct Text File Import; Direct Excel File Import; and Mapped Text File Import.

The full documentation on the facility is under the gINT Help:Contents menu anywhere in the program. gINT Rules has its own book in the table of contents.

We also have a gINT Rules Code Manual that will help you write your own code.

On this page we will post sample code that you can use as starting points for your own code modules.

gINT Rules require gINT Professional or gINT Professional Plus. gINT Logs can run Add-in gINT Rules, but does not have access to the code editor.

Each of these downloads are in the form of a ZIP file. To install, download to any folder and unZIP. Then open the file with the "TXT" extension in any text editor or word processor for further instructions. (See [[Using gINT Downloaded Examples]].) You can also use the unarchiving utility built into gINT version 6 and later. See the Utilities:Extract from ZIP application.

NOTE: Code samples are provided free of charge and as-is. gINT Software makes no claim or warranty as to the accuracy of the samples. It is the responsibility of the user to ensure that the code performs as it should. Comments, suggestions, and error reports are appreciated.

Description	Download	Last Update
Code samples described in gINT Rules Help topic. Full Description	gr001.zip (v.6 or later)	05 Jan 2004
Extension of some of the gINT built-in lab testing capabilities. Full Description	gr002.zip (v.6 or later)	01 Sep 2012
Build your own moisture content calculations and checking. Full Description	gr003.zip (v.6 or later)	03 Nov 2003
Component description checking. Full Description	gr004.zip (v.6 or later)	03 Nov 2003
Preload data into an empty dataset and then remove unused preloaded data on save. Full Description	gr005.zip (v.6 or later)	19 Feb 2004
Calculates a number of parameters from CPT data. Full Description	gr006.zip (v.6 or later)	07 Nov 2003
Determines the percent passing the 0.425mm sieve from the gradation results and copies that value to the parent record. Full Description	gr007.zip (v.6 or later)	08 Dec 2003
Generates project statistics and keeps track of the last date/time any data was modified in the project and the last date/time any data was modified in every borehole. Full Description	gr008.zip (v.6 or later)	05 Jan 2004
Illustrates the use of gINT Rules to restrict modification of particular tables in a project database by reading the network user name of the currently logged-in user and looking up his department in the organization. Each table allows different categories of personnel to perform edits. If the current user does not belong to one of the categories that has modification rights to the current table, the modifications are not saved. Full Description	gr009.zip (v.6 or later)	10 Apr 2004
Illustrates a method to determine if a field has changed value on the Save event. This is important if there are dependency on the field data in other tables. Full Description	gr010.zip (v.6 or later)	22 Mar 2007
Creates a profile of effective overburden stress at fixed intervals of depth based on a profile of densities with depth and the depth to groundwater. The resultant stress versus depth values are stored in another table for plotting on graph reports or plot vs depth entities. Full Description	gr011.zip (v.6 or later)	11 May 2005
If there are exactly two liquid limit tests, a warning is given if the two extrapolated liquid limits are more than 1% apart. Full Description	gr012.zip (v.6 or later)	08 Dec 2005
This rule populates the sample storage location from the sample table into the test scheduling table. Full Description	gr013.zip (v.7 or later)	03 Jun 2006
Hides or shows applications based on the person using the library. Full Description	gr014.zip (v.8 or later)	28 May 2007
Hides or shows table groups, tables, and fields in a project based on the project type. Full Description	gr015.zip (v.8 or later)	28 May 2007
Populates the GintPointSort field with numbers reflecting the desired sort order for PointIDs during the saving of the POINT table (see GRA007 for Add-In version). Full Description	gr016.zip (v.8 or later)	20 Mar 2010
Illustrates the use of the SoilClass object of gINTRules to perform soil classifications in the Input application based on lab test results. Full Description	gr017.zip (v.8.2 or later)	11 Sep 2008
Colors cells, rows, and columns in the Input grid based on user-defined criteria. Full Description	gr018.zip (v.8.2 or later)	11 Sep 2008
Determines the coordinates from station and offset along an alignment and station and offset along an alignment from coordinates. Full Description	gr019.zip (v.8.2 or later)	11 Sep 2008
For any number of raw data numeric fields required to calculate a value stored in a result field, this rule ensures that all the raw data fields have values or none do. If they all have data, the result value is calculated. If none have data, no calculation is performed. This allows the user to type in a final result only. If some but not all the raw data fields have data, an error message is returned. Full Description	gr020.zip (v.8.2 or later)	27 Jul 2011
Illustrates some uses for the "gINT Rules Procedure Before Required Fields Check" event. This code sample also sets up the architecture for unit conversions, that is, if you wish to store data in multiple units within the database. Instructive video link. Full Description Video	gr021.zip (V8i Ss2 or later)	14 Mar 2014
Automatically assigns a unique lab number to every new test specimen on saving the specimen table. These numbers are unique across projects, as long as all users are using the same library. Full Description	gr022.zip (V8i Ss2 or later)	12 Jun 2014
The code in this sample provides an automated alternative to the manual recalculation. This is through the gINTRules.RunRulesOnOtherTable method. See the GR023 module under the PointSave procedure for the usage in this sample. See the gINT Rules manual for further details. Full Description	gr023.zip (V8i Ss2 MR or later)	1 Nov 2014
The code in this sample provides curve fitting of data using moving average and best fit cubic spline methods. For more info see readme file supplied with the download. Full Description	gr024.zip (V8i Ss2 MR or later)	3 Dec 2014
Add-In Imports CPT data into the current project in Input and then previews the imported data on a log form. Full Description	gra001.zip (v.7 or later)	12 Apr 2012
Add-In Generates graph reports of N Value vs Depth to either the printer, screen, or PDF file. Each graph page shows N Values for each stratigraphic unit defined in the project. Full Description	gra002.zip (v.7 or later)	19 Dec 2007
Add-In Generates statistics for N Value in the current project. The output can be optionally filtered on selected boreholes and/or stratigraphic units. Full Description	gra003.zip (v.7 or later)	02 Apr 2005
Add-In Generates fence baselines perpendicular to a centerline. Full Description	gra004.zip (v.7 or later)	11 Sep 2005
Add-In Generates a skeleton gINT Rules procedure for use on prepopulating and saving a table. Full Description and Videos: Procedure on Save option; Introduction, Process, and Setup; Direct Text File Import; Direct Excel File Import; and Mapped Text File Import	gra005.zip (v.8 or later)	30 Apr 2012
Add-In Determines which area or areas a specific coordinate resides. Full Description	gra006.zip (v.8 or later)	05 Feb 2007
Add-In Populates the GintPointSort field with numbers reflecting the desired sort order for PointIDs via a menu command (see GR016 for version that works on save). Full Description	gra007.zip (v.8 or later)	30 Jan 2008
Add-In Illustrates the publishing of project data to Google Earth. Full Description	gra008.zip (v.8.2.003 or later)	25 Apr 2019
Add-In Imports Sieve Analysis data from Excel into the current project. Full Description	gra009.zip (v.8 or later)	12 Apr 2012
Add-In Generates a surface elevation for boreholes by interpolating from a surface included in the project database. Full Description	gra010.zip (v.8 or later)	15 Jul 2011
Add-In Imports Texas DOT WinCore3 files (www.txdot.gov/business/contractors_consultants/engineering_software.htm) into the current project. Full Description	gra011.zip (v.8 or later)	12 Apr 2012
Add-In Automatically generate a localized data template or project, or dynamically translate an existing project database to a localized version without changing the source database, for as many languages as needed. Provides for swift localization/translation of table Group names, field Units, and table and field Captions, Descriptions and Help text. Full Description	gra012.zip (v.8 or later)	12 Jun 2012
Add-In Batch import of CSV, Excel, and AGS files. The library inserts the "GRA013" submenu under the "Add-Ins" menu in Input with the command "Batch Import" under this submenu. On executing the command a dialog appears that asks for: Type of source files (your choices are CSV (comma separated values), XLSX (Excel 2010 and later), XLS (Excel 2007 and earlier), and AGS (Association of Geotechnical and Geoenvironmental Specialists data interchange format). Use Correspondence File: This is a check box. Mark this property if a correspondence file is required for the import. For AGS import, you must mark this property, that is, a correspondence file is required. Overwrite Option: The same options are available in the native gINT import dialogs. On clicking OK, the program will prompt for the correspondence file, if the "Use Correspondence File" check box was marked. Then it will prompt for the files to import. You can select as many as you wish from within one folder. Full Description	gra013.zip (v.8 or later)	23 Oct 2013
Add-In Links selected tables from a gINT ACCESS project (GPJ) and/or queries from a gINT library to a new Excel file. Each table/query link is stored in a separate worksheet. These linked data can be refreshed at anytime to obtain the latest data. On running the add-in you are prompted for the name and location of the new Excel file. Both XLS or XLSX are supported. Then you will see the list of tables in the currently opened project in Input. Select any number or none. If there are any queries stored in the current library, that list will be shown. Select any number or none. The linked Excel file is then launched. gINT does NOT have to be running for the links to work. Note: There are two versions. gra014 works with Office Excel versions prior to Office 365. gra014_365 works with Office 365 Excel. Full Description - gra014 Full Description - gra014_365 Video	gra014.zip (V8i Ss1 or later) gra014_365.zip (V8i Ss1 or later)	28 Oct 2013 10 Jun 2019
Add-In Inserts alignment Z values from surfaces. Can select as many alignments and surfaces as desired. Each surface is associated with a specific Z column (specified by the user). In addition, additional alignment points can be inserted by specifying a station increment for calculation of the Z values in addition to the calculation at existing alignment points. Full Description	gra015zip (V8i Ss2 or later)	12 Jun 2014
Add-In Illustrates the use of the command line interface to run the gINT AGS Checker. This is for automated testing. In a working environment you would probably not be using gINT Rules to do this but a standalone program. Here is the target scenario: Consultants place AGS files in a location specified by the client. This triggers an event which is captured by a monitoring program. The monitoring program calls the AGS Checker and tells it to check the file and write the checking log to a specific file. The checking log is opened by the monitoring program and searched for the text string "ERROR:". If an error is found, the consultant is sent the checking log with instructions to fix those problems. This gINT Rule performs steps 3 and 4 and gives a message box showing if there are errors or not. Multiple AGS files can be specified. Full Description	gra016.zip (08.03.04.243 or later)	15 May 2015