
GRA009.TXT



gINT Rules Code Add-In menus Samples - 009



Requires gINT version 8 or later. gINT Logs cannot run gINT Rules but can access the code or the Add-Ins manager. gINT Logs Plus and gINT Professional have full access to both.



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

===========

This Add-in imports sieve analysis data from Excel spreadsheet files into the standard gINT Lab Testing tables. Any number of Excel files can be imported at once. The program assumes only one sieve analysis test per file. Further, it assumes that the worksheet name is "Sieve Analysis". Note that the % Finer values are not imported in this process. The gINT native code is used to perform the calculation. Further, if a PointID referenced in a test is not defined in the project, the PointID is created with a HoleDepth value of 0.



There is little error trapping in the code. It's main purpose is to illustrate some of the tools that can be used is reading Excel files.



This code must be modified if the spreadsheet structure is different from the supplied sample files (see below) or the structure of the project database is different.



Revision History

================

06Oct2008:

Initial public upload

*************************************************



INCLUDED FILES:

GRA009.GLB:

  Add-Ins:   GRA009 - Runs the import of the sieve data from Excel.



  gINT Rules code modules:

    GRA009:  Main

             CombineSieveFiles

             ExcelSieveDataToGintFileFnB

             ImportExcelSieveData



    GRA009 COMMON PROCEDURES:  RecordsetClose

                               UniqueFileNameFnS



SA_001.XLS, SA_002.XLS, and SA_003.XLS are included as sample import files.

*************************************************



INSTALLATION PROCEDURE:

Copy the files wherever you wish.  To see the gINT Rules Add-In and code module you must either merge the GLB into your library (Utilities:Lib Merge/Copy) or change to the included library (File:Change Library).

*************************************************



SPECIAL NOTES:

See the DESCRIPTION section above for detailed usage instructions.

*************************************************