Jump to content
RockWare Support Forum
Guest Jason

database templates

Recommended Posts

Guest Jason

Firstly, Hi everyone. My first post and new user of Rockworks.

I am building a borehole database from scratch (which is fun) but is a lot of work to get all of my specifics into the database schema (tables). My question for today is - are there any borehole database templates available? Specifically I am looking for a template to deal with coal seam gas exploration data, but even a coal-oriented database would be handy.

I don't want to take any shortcuts, but would like to have my database in a solid state before entering a mountain of data.

Alternatively, just let me know if building a BD/tables from scratch is a right-of-passage :)

Share this post


Link to post
Share on other sites

I just did a similar thing with a large data set. The key is to do it in Excel (not input directly through the RW interface), then import the excel file.

I found the best way to do this was to create 2-3 dummy holes, setup all the Lithology Types, Stratigraphy Types, P-Data Types etc, then populate them with some dummy data. Once everything is populated, under borehole manager, hit file, export, xls. This will give you a nice Excel sheet with all the correct headings and data structure.

Once you have your RW Excel output, export all data from your database (perhaps gINT?) to an excel sheet and copy/paste the values into the appropriate fields in the RW Excel sheet.

Looking through help, there are also a number of ways to pull data straight from gINT etc, but this method worked best for me as I only populated lithology, stratigraphy and about 4 different P-Data types.

Share this post


Link to post
Share on other sites
Guest Dan

Jason,

Their are many ways to input the data but,as Dan C said, using Excel is a good way to go. If you would like to see how the Excel spreadsheets look, follow these steps.

- Open the "Samples" project in RockWorks

- Click on File, hover over Export and select XLS (Microsoft Excel)..

- On the left side of the screen select the All (Enabled + Disabled) radio button

- Click on the Items to include and make sure that all options are checked except for the last one (Include XYZ Computations)

- Click on the Process button at the lower left corner of the screen

- An Excel icon should appear on your computer. Open it up and you will see the proper structure to use for generating your Excel data tables.

Share this post


Link to post
Share on other sites
Guest Jason

Thanks Dan(s)

Most of my existing data is in Excel, so thanks for the tips. This will make life much easier.

Share this post


Link to post
Share on other sites

Create an account or sign in to comment

You need to be a member in order to leave a comment

Create an account

Sign up for a new account in our community. It's easy!

Register a new account

Sign in

Already have an account? Sign in here.

Sign In Now

×