Step 5: Define how duplicate records should be handled and save your import template
- Borehole Overwrite Options: Use these settings, on the Location Fields tab, to specify what should happen if the Location worksheet in the Excel file references borehole names which already exist in the current project database.
! These settings only apply to the Location worksheet in Excel.
- Skip Existing Record: If a borehole ID exists in the RockWorks database, the importer will skip all Excel Location records with the same borehole ID.
Example: if there is already a borehole named "BH-01" in the project, the importer will not import any new Location data flagged for a "BH-01" boring, and the original borehole's Location 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 Excel Location records you've mapped for import that have the same borehole ID.
Example: if there is already a borehole named "BH-01" in the project, and you're importing Location data for a borehole named "BH-01," the program will create a new borehole record named "BH-01_1" and import the Excel data into that new record, leaving the original borehole record unchanged.
- Replace Existing Record: If a borehole ID exists in the RockWorks database, the importer will delete all existing data for that borehole and replace it with the Excel records you've mapped for import with the same borehole ID.
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 Excel 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.
! You can activate Warn on Existing Record (the check-box below these options) to have the program display a confirmation dialog box for each existing borehole, so that you can choose to replace, update, skip, or create a new record, on a borehole-by-borehole basis.
- Update Existing Record: If a borehole ID exists in the RockWorks database, the importer will not delete that borehole's Location data before import. Instead it will add new record types from Excel 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 from Excel, 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, T-Data, and P-Data, an "existing" data type refers to specific tracks, so that you can import new track names to an existing table. For example, if your Excel file lists "Gamma" measurements in the Point (P-Data) worksheet, the update process will add those measurements to an existing borehole's P-Data table that contains only "Resistivity" data.
- Confused? Please refer to the "Goals" topic for more specific examples of replacing and appending data.
- Warn on Existing Record: If activated, this option will force the importer to display a warning when it finds boreholes in the Excel file that already exist in the database. The warning window will offer the same overwrite options as discussed above, on a borehole-by-borehole basis.
- Template File: If you would like to save all of the mappings and settings that you have established, you can save these in a "template" for future use. This can be handy if you will be importing from Excel frequently, and the data layout is consistent.
- Save As Template: Click this button to type in a name for the template ".xml" file which will be created.
Prev ( Location fields ) | Next ( import the data ) 
RockWare home page