RCL Commands - Database Imports

There are some programs within RockWorks which do not utilize "tree-style" menus, thus you cannot quickly generate an RCL listing of DEFINE and EXECUTE commands.  This topic discusses the commands used to import data from an external database (acQuire database, Newmont database, or other) into the RockWorks database via RCL. The menu-based version of this program is File | Import | Database.

Contents

• Introduction
• Define the Import Template File Name
• Perform the Import

  Back to RCL Imports

Introduction

This set of RCL commands replicates the File | Import | Database menu option in the Borehole Manager. The documentation for that program is not duplicated here - please read its discussion for details about how the importer works. Some notes:

• The automated, RCL version of the database import requires that you have already created an import template which maps the external database fields to the RockWorks database. Please see the discussion of the Import Template in the menu-based program.
• We highly recommend that you make use of the Project | Backup Database menu option or the RCL BACKUP command before running any import scripts.

Define the Import Template File Name

Required.

When you import from a database using the program menus, you are permitted to save the settings in an "import template". RockWorks saves these in an "XML" format file. It is required that you have previously created this template to automate the import via RCL.
! Note that it is required that you store the data link in the template.

DEFINE:    ADO_IMPORT     TEMPLATE       my_import_template.xml

 You do not need to enclose the file path or file name in quotation marks.

Perform the Import

Required.

You can execute the import using the following EXECUTE command.

EXECUTE:  ADO_2_BM_RCL

Table of Contents

   Back to RCL Imports

RockWare home page