Exporting Data to EQuIS for gINT
Copyright © 2019 EarthSoft, Inc • Modified: 31 May 2019
The EQuIS for gINT Interface makes creating borehole logs, fence diagrams, reports, and tables quick and easy. In addition to creating static "snapshot" databases, output defined in the gINT library can be created automatically, sometimes in only one click!
In order to create output, a gINT data template (.gdt) and gINT library (.glb) are required. As with the "gint us.gpj" project database, the corresponding template (gint us.gdt) and library (gint us.glb) are installed with the EQuIS for gINT Interface and can be found in the "C:\Program Files\EarthSoft\EQuIS\Tutor\gINT" directory.
The following message may occur on 64-bit machines running the EQuIS for gINT export.
...System.Exception: Unable to initialize connection ---> System.Runtime.InteropServices.COMException (0x800A0E7A): Provider cannot be found. It may not be properly installed....
To address this message, EQuIS for gINT should be launched through EQuIS_x86.exe (found in Program Files\EarthSoft\EQuIS directory). The 64-bit version of Professional EQuIS_x86 executable was created for use with third party 32-bit (x86) applications such as gINT that are not able to host 64-bit (x64) DLLs.
One additional file, the gINT queries file, is also required. This file is not used by gINT itself, but is required by the EQuIS for gINT Interface, because it contains the queries necessary to extract the data out of the EQuIS Database and make it usable by gINT. The gINT queries file must have the same name and exist in the same directory as the template. For example, the installed gINT queries file, "gint us.gdx" can be found in the same location as the "gint us.gdt".
The queries file is simply an XML based text file that includes the queries utilized by the interface. (In earlier versions of the interface, these queries were contained within the EQuIS Database. An example showing the POINT query as it has been defined in the EQuIS Database and how it is now defined in the .gdx file). Maintaining the queries in the .gdx file affords several advantages and increased flexibility to the user.
To launch the EQuIS for gINT Interface, click the gINT icon button in the Plus section of the Graphics tab in EQuIS Professional.
If no gINT button is visible, follow the instructions here to restore the button.
If the interface has not previously been opened on this machine, it will first require that the user select the gINT data template file (.gdt) by doing the following:
1.Browse to the gINT data template, "C:\Program Files\EarthSoft\EQuIS\Tutor\gINT\gint us.gdt". Several tabs should now be populated with data exactly as gINT will see that information.
Note: In order to open any files located in the "C:\Program Files\. . ." folder, EQuIS must be run as an administrator.
2.Under "gINT Library (.glb)" on the right side, click <Browse>...
3.Browse to the gINT library, "C:\Program Files\EarthSoft\EQuIS\Tutor\gINT\gint us.glb". Once the gINT library has been selected, the various types of output defined in that library are listed in the Generate Output section of the gINT Interface. It should be noted that all output formats contained in the library are listed, regardless of the data available. For example, even though a moisture content histogram requires laboratory data which is not part of the gint us.gpj — and consequently, the EQuIS gINT Database — it is still displayed and is an available option in the interface. Clicking the Moisture Content histogram will produce the histogram, but as there are no data to support that output, it will essentially be blank.
oSelect CPT-1 on the POINT tab and click CPT in the Logs section.
Clicking on the output option desired under Generate Output first creates a temporary gINT Database. (database is saved in user's EQuIS Work directory under name of database, and then name of facility. In this example, the file would be found in C:\Documents and Settings\ [User Name]\My Documents\My EQuIS Work\gINT\gINT Example). The temporary gINT Database is then processed by gINT using a gINT scripting (.gsc) file, saved in the same directory. Finally, the output, saved as a PDF document, is opened in the default system reader of .pdf files, typically Adobe Acrobat.
•Select B-1 on the POINT tab and click ENVIRONMENTAL BH in the Logs section.
•Select B-3 on the POINT tab and click GEOTECH BH COLUMNS or GEOTECH BH PLOTS in the Logs section.
•Select B-1, B-2, and B-3 on the POINT tab; click STRATIGRAPHY & GW - A Size in the Fences section.
•Select all locations on the POINT tab and click SITE MAP in the Graphs section.
•Click PROJECT SUMMARY in the Text Docs section
Note: The EQuIS Professional installation has been updated to include an import format file and export mapping file (.gdx) that correspond to the gINT std us tutorial gINT project. (older gINT and gINT_Lab formats have been removed). It is recommended that the EQuIS Database contain the geotechnical schema for best results when importing data using the gINT std us format.