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)
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)
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)
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)
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)
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 DescriptionVideo
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
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
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.
3 Dec 2014
Add-InImports 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-InGenerates 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-InGenerates 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-InGenerates fence baselines perpendicular to a centerline.Full Description
gra004.zip(v.7 or later)
11 Sep 2005
Add-InGenerates 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-InDetermines which area or areas a specific coordinate resides.Full Description
gra006.zip(v.8 or later)
05 Feb 2007
Add-InPopulates 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-InIllustrates the publishing of project data to Google Earth.Full Description
gra008.zip (v.8.2.003 or later)
25 Apr 2019
Add-InImports Sieve Analysis data from Excel into the current project.Full Description
gra009.zip(v.8 or later)
Add-InGenerates 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-InImports 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)
Add-InAutomatically 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-InBatch 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-InLinks 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_365Video
gra014.zip(V8i Ss1 or later)
gra014_365.zip (V8i Ss1 or later)
28 Oct 2013
10 Jun 2019
Add-InInserts 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)
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:
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