Because RockWorks allows you to define custom location fields in your borehole database, you can also list these custom fields in your Excel file's Location worksheet. You can use this screen to tell the program which Excel fields are to be imported into which database fields.
- Column from Input File: Listed in this column are all of the columns in the Location worksheet in the Excel file.
! If the Excel spreadsheet has a lot of columns, you'll need to use the scroll bar to view them all.
- RW Database Field: Listed in this column are the names of the fields in the Location table in the current Borehole Manager database.
- If the import columns to the left are the "expected" location fields and are named according to the format defined in the File Format section, the importer will recognize them and list the appropriate database field automatically.
- If a column is not recognized, no database field will be mapped.
- To remove an RW Database field name ("unmap" it), click on it; you'll see a long pop-up menu. Scroll to the top of the list and select the blank field.
- To select or change a field for the Excel information, click in the cell and select the field name from the pop-up list.
- To create a new field in the database, simply click on the <add new field> item and type in the name for the new Location tab field. During the import process, RockWorks will add this field to the project's data dictionaries.
RockWare home page