Importing gINT Files into the Borehole Manager

Borehole Manager | File | Import | gINT

This program is used to import data from the gINT software program into the Borehole Manager database.  This program requires the following:

• You have gINT, version 7.1.039 or newer, installed onto your computer. *
• You have created a "correspondence file" in gINT, as described in that program's documentation.
• For documentation on how to set up a RockWorks correspondence file in gINT, search for "Export to RockWorks" in the gINT searchable help.

Menu Options
Step-by-Step Summary

Menu Options

• Overwrite Options:  Specify what should happen if the import file references the same borehole names as already exist in the current project folder.

• • Skip Existing Files:  If a borehole ID exists in the RockWorks database, the importer will skip all import records with the same borehole ID. 
    For example, if there is already a borehole named "BH-01" in the project, the importer will not import any new data flagged for a "BH-01" boring, and the original borehole data will remain unchanged.
  • Create New Record:  If a borehole ID exists in the RockWorks database, the importer will create a new borehole record (with a new name, appending "_1") for all import records you've mapped for import that have the same borehole ID. 
    For example, if there is already a borehole named "BH-01" in the project, and you're importing data for a borehole named "BH-01," the program will create a new borehole record named "BH-01_1" and import the data into that new record, leaving the original borehole record unchanged.
  • Replace:  If a borehole ID exists in the RockWorks database, the importer will delete all existing data for that borehole and replace it with the import records you've mapped for import with the same borehole ID. 
    For example, if there is already a borehole named "BH-01" in the project, the importer will delete all data for that borehole from the database, and then import the mapped ASCII data for BH-01.  The original borehole record will be completely replaced.
    ! Be sure about this. All existing data for existing boreholes will be lost. 
  • Update: If a borehole ID exists in the RockWorks database, the importer will not delete that borehole's data before import. Instead it will add new data types from the import file to the borehole.  Any existing data types in the borehole will be replaced.
    Example: There is already a borehole named "BH-01" in the project, with Location and Lithology data. You map only Stratigraphy data for import, and this new data type is appended to the project. 
    ! However, if you map Lithology data for import as well, then the existing Lithology data for that borehole will be replaced with the new.  You cannot append to an existing data type.
    ! For I-Data, I-Text, T-Data, P-Data, and P-Text, an "existing" data type refers to specific tracks, so that you can import new track names to an existing table.  For example, if your import file lists "Gamma" measurements in the Point (P-Data) block, the update process will add those measurements to an existing borehole's P-Data table that contains only "Resistivity" data.
     
• Multiply Depths by Constant:  Insert a check here if the gINT depth listings are to be multiplied by a constant value. Expand this heading to type in the multiplier.
  
  

Step-by-Step Summary

1. Outside RockWorks, use gINT's Utilities tools to build the Correspondence file.  This will map the gINT database tables to a RockWorks text import format.
2. Access the RockWorks Borehole Manager program tab.
3. Open the project folder (if necessary) in which the well records are to be created.
4. Select the File | Import | gINT menu option.
5. Enter the menu options, described above.
6. Click Process at the bottom of the options window.
7. The program will launch the gINT program in the background.  It will display several prompts.
   1. Select the gINT project file (.gpg) for the data to be imported.
   2. Select the gINT correspondence file (*.gcx) that you have created.
8. RockWorks will then display its standard field mapping window for text files.  You'll use this window to define which data fields go where in RockWorks. Click here to jump to that discussion.
   
   

* Troubleshooting

If you are using gINT v8i or later, you may need to follow these steps to import your data into RockWorks

1. In gINT, use the Utilities tools to build the Correspondence file.  This will map the gINT database tables to a RockWorks text import format.
2. In gINT, use the File | Export RockWorks menu option to export the data to a text file.
3. In RockWorks, use the File | Import | Text menu option to import the resulting file.

See also:

• Importing Text Data into the Borehole Manager
  
  

Back to Importing Data

RockWare home page