We've summarized here some scenarios that might apply to your use of the Borehole Manager's File | Import | Text tool, and general steps to take. You should also refer to the specific steps shown at the bottom of this topic for more detailed explanations of the mechanics of the import process.
Scenario 1: Import data for boreholes that do not yet exist in your RockWorks project
Scenario 2: Import new Location data fields for boreholes that already exist in your RockWorks project
Scenario 3: Import new (different) data fields for boreholes that already exist in your RockWorks project
Scenario 4: Import new (different) P-data tracks for boreholes that already exist in your RockWorks project
Example: RockWorks database already lists data for BH1 and BH2. You wish to bring in data for BH3 and BH4.
- In the text file:
- The text file must contain a Location block which lists only the names of the boreholes being imported (the borehole ID), the other required location fields (Easting, Northing, Elevation, Collar Elevation, and Total Depth) and any other location fields to be brought into RockWorks.
- The file should contain separate blocks for any other data you wish to import (Lithology, Stratigraphy, etc.) for those new boreholes.
- In RockWorks (in the Text Import dialog box):
- Block Selection tab: Map the data blocks that you wish to import to the database tables.
- Location Fields tab:
- Be sure to map all of the required Location block fields to the Name, Easting, Northing, Elevation, Collar Elevation, and Total Depth database fields.
! The borehole's ID must be mapped to the database Name field. Without this, nothing can be imported.
- Map any other optional Location fields that you wish to import to the corresponding Location fields in the database.
- Borehole Overwrite Options: These are not really applicable since you are importing new borehole records. However, if you are concerned that you might be inadvertently importing data for boreholes that already exist in the database, choose either Create a New Record or Skip Existing Record, and/or activate the Warn on Existing Record option so that you'll be presented with a warning.
Example: RockWorks database already lists Location and Lithology data for BH1 and BH2. You wish to import new Location data fields data for BH1 and BH2.
- In the text file:
- The text file must contain a Location block which lists the names of the boreholes being imported (the borehole ID) and the other required location fields: Easting, Northing, Elevation, Collar Elevation, and Total Depth.
- Be sure that the Location block also contains the additional columns with the data you wish to import.
- In RockWorks (in the Text Import dialog box):
- Block Selection tab:
- Map the Location block.
- Do not map any blocks whose data you do not wish to import at this time.
- Location Fields tab:
- Map the required Location fields to the appropriate fields in the database. Note that the new data for these fields will replace the existing data in the RockWorks project.
-
- Map any additional Location fields to be imported. For new, custom fields in the import file that don't yet exist in the database, you can create these at this time: Click <new field> in the Database Field drop-down and type in the name for the new field to which this data is to be imported.
-
- Borehole Overwrite Option settings should be set to Update Existing Record. Very Important!
-
- Warn on Existing Record: This can be activated if you would like to confirm the update for each existing borehole.
Example: RockWorks database already lists Location and Lithology data for BH1 and BH2. You wish to import Stratigraphy data for BH1 and BH2.
- In the text file:
- The text file must contain a block for each of the new data types, which list the new data you wish to import. In this example, your file would include a STRATIGRAPHY block (and possibly a STRAT TYPE block).
- Provided that the new data in the text file references boreholes that already exist in the project, you don't need to have a Location block in the import file.
- In RockWorks (in the Text Import dialog box):
- Block Selection tab:
- If you have a Location block in the text file, be sure it is NOT mapped in the Block Selection window.
- Map any other data with the new data you wish to import for the existing boreholes. Any existing data for mapped blocks (or existing tracks for multi-track blocks) will be replaced.
- Example: In this example, be sure only Stratigraphy and Strat Type are mapped.
-
- Location Fields tab:
- You don't need to map any Location fields since you are not updating the Location data.
- Borehole Overwrite Option settings:
- Warn on Existing Record: This can be activated if you would like to confirm the update for each existing borehole.
RockWorks database already lists Location and P-Data Gamma measurements for BH1 and BH2. You wish to import P-Data Resistivity data for BH1 and BH2.
- In the text file:
- The file must contain a P-Data block that references only the tracks you wish to import to the existing boreholes.
! This is really important. Multi-track data types in RockWorks can be appended by track provided that only the new tracks are listed in the import file.
- Be sure the P-Data block is sorted by borehole, then by track.
- Provided that the new data in the text file references boreholes that already exist in the project, you don't need to have a Location block in the text file.
- In RockWorks (in the Text Import dialog box):
- Block Selection tab:
- If you have a Location block in the text file, be sure it is NOT mapped in the Block Selection window.
- Map any other blocks with the new data you wish to import for the existing boreholes. Any existing data for mapped blocks (or existing tracks for multi-track blocks) will be replaced.
- In this example, you would map the P-Data block so that the new Resistivity data would be appended to the existing borehole records.
-
- Location Fields tab:
- You don't need to map any Location fields since you are not updating the Location data.
- Borehole Overwrite Option settings
- Warn on Existing Record: This can be activated if you would like to confirm the update for each existing borehole.
RockWare home page