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 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. On this page we will post sample code that you can use as starting points for your own code modules.
Unless otherwise noted below, gINT Rules requires gINT version 6 or later and gINT Logs Plus or gINT Professional. gINT Logs can run 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. 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) |
10 Mar 2006 |
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) |
30 Jan 2008 |
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 |
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) |
02 Apr 2005 |
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 |
gra005.zip
(v.8 or later) |
24 Jun 2007 |
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.002 or later) |
03 Oct 2008 |
Add-In
Imports Sieve Analysis data from Excel into the current project.
Full Description |
gra009.zip
(v.8 or later) |
06 Oct 2008 |