Open a Project Folder from RockWorks14 or RockWorks2006

Each project you work on in the Borehole Manager must have its own folder, called a Project Folder, on your computer. The Project Folder is where the following items are stored:

The borehole database (.SQLite) of the same name as the folder, for storage of borehole data and miscellaneous project data
Your RockWorks datasheet files (.RwDat)
Graphic files, grid and solid models, and other accessory files for the project

! Because of the changes we've made in the program, RockWorks14 and RockWorks2006 project databases cannot be opened directly into RockWorks20. Instead, you'll need to export your old project data, and then import the data into the new program. These steps are outlined below.

! Any RockWorks14 or RockWorks2006 .ATD files can be opened directly into the RockWorks20 datasheet.

Step-by-Step Summary
Important Notes

Follow these steps to export borehole data from an existing RockWorks14 or RockWorks2006 project, and import the data into a new RockWorks project database.

Export the data from the old version.
1. Launch RockWorks14 or RockWorks2006.
2. Open the project you wish to bring into RockWorks20 (or newer).
3. When the drillhole data is loaded into the Borehole Manager, select the File | Export | ASCII menu option.
4. In RockWorks14, enter the following:
  
  In RockWorks2006, enter the following:
5. Under "Items to Include" be sure that all of the data types are checked.
6. Click Continue to export the data.
Create a new project for this data in RockWorks20. (Please refer to Creating a New Project if you need more details than are listed here.)
1. Launch RockWorks20.
2. Click on the Project Folder button at the top-left corner of the program window, and select Create New Project.
3. On the Folder tab:
  - Project Name: Type in the name for the new project folder to be created. We recommend creating the folder in the "RockWorks Data" folder which resides in your "Documents" folder.
    Example: C\Users\RockWare\Documents\RockWorks Data\Airport 2013
  - Choose Use Default Database Engine.
  - Choose Base the New Project on Default Settings.
4. On the Coordinates tab: (Please refer to Coordinate Systems if you need more details than are listed here.)
  - Horizontal Coordinates: Here you can tell RockWorks20 the map coordinate system you wish to define for this project. If you know the coordinate system in which your old project's borehole locations were defined, and you want to continue using that system, choose that. If you don't know, choose Local (Custom). (If you want to define a different map coordinate system for this new project, that's OK; RockWorks can convert the old coordinates when you import the data in the next step.)
    - For Local (Custom) coordinates, you can geo-reference the project by typing in the known Latitude and Longitude at the project's "0,0" coordinate spot. If you don't know, leave these set to "0,0".
    - For State Plane coordinates, you need to click on the button to define the State Plane zone.
    - For UTM coordinates, you need to select the Datum and the UTM Zone.
  - Horizontal Units: This defines the units for the map points for this new project. Choose Feet or Meters. (Again, you can choose the same units or different units than your previous project; RockWorks can convert them.)
  - Vertical Units: This lets you define whether you want this project's depths and elevations to represent feet or meters.
  - Output Coordinates: The coordinate system you've selected for data storage (above) will also be used in your output models and diagrams. If your horizontal and vertical units don't match (e.g. mixed feet and meters), then you need to select which units to use for your output. Since RockWorks does a lot of volume computations, cubic meter-feet don't make sense. You have to choose one or the other. Choose either Feet or Meters.
5. Click the Finish button.
6. Confirm the data coordinates and units, and the output units by clicking Yes. If you wish to make any changes, click No.
7. RockWorks will build the project folder and the borehole database. Note that the coordinate system and units will be shown on the Borehole Manager's Location tables, and in the Coordinates pane at the top of the window.
Import the Data.
1. Once the new project is created, click on the Borehole Manager program tab.
2. Click on the File menu, right above the borehole Name pane, and choose Import | CSV | Multiple Tables.
3. On the File Selection Tab:
  - Import Filename: Browse for the name of the file you created under Step 1, above.
  - File Contains Column Titles: Check this box, if you did include column titles, as shown in the windows above. If you did not include column titles in the export file, uncheck this setting.
4. On the Block Selection Tab:
  - All of the RockWorks14/RockWorks2006 data blocks should be mapped automatically. But, it's good to double-check.
5. On the Data Coordinates Tab: These settings will default to the project coordinates you just established. If you created the new project using a different coordinate system or units than the old project, be sure to specify the imported data setup here; RockWorks will convert the data as necessary.
  - Imported Data Coordinate System: Choose the coordinate system represented in the imported data. The project coordinates are shown to the right, for your reference.
    - For Local (Custom) coordinates, you can geo-reference the project by typing in the known Latitude and Longitude at the project's "0,0" coordinate spot. If you don't know, leave these set to "0,0".
    - For State Plane coordinates, you need to click on the button to define the State Plane zone.
    - For UTM coordinates, you need to select the Datum and the UTM Zone.
  - Vertical Values: Here choose whether the depths and elevations of your old project data are defined in Feet or Meters.
6. On the Location Fields tab: You'll see your import fields displayed in the left column, and the database fields to the right of them. RockWorks should be able to map the expected fields automatically.
  - Confirm that the automatic fields were mapped properly by the program.
  - If there are columns in the input file which do not yet have a place to land in the new project database, click on the RW Database Field cell, and choose <New Field> to create a new field in the Location table.
  - Borehole Overwrite Options: If you are importing data into a new database, you can simply choose Create a New Record.
7. Click the Finish button to import the data.

RockWorks will import the text data into the Borehole Manager. You'll see the boreholes in that project now listed in the Name pane, and their data loaded into the data tables.

Project Dimensions: The project dimensions were not included in RockWorks14/RockWorks2006 export files. You'll need to type in the desired Grid & Model Dimensions in that pane at the top of the program window, or use the Scan Boreholes button to have the program compute them automatically.
Models, Graphics, etc.: None of the accessory files in your RockWorks14/RockWorks2006 project folder will be copied into the new project folder. If you want to copy your grid models, solid models, maps, 3D graphics, and other files into the new project folder, you can do so using Windows Explorer.
File Formats: The model and graphic file formats, and their file name extensions, have changed between RockWorks14/RockWorks2006 and RockWorks20, with the addition of the coordinate information. RockWorks20 can read the old file formats and update them automatically to the new versions. See RockWorks File Types for details.

Back to RockWorks Projects - Overview

RockWare home page