Refresh Drillhole Project

Use the DH-Data >Refresh Project menu option (DHREFRESH GX) to refresh the constituent drill project databases from the original data sources.

Refresh Drill Project Data

Import mode

Overwrite: Start from scratch; if the database exists it is first deleted.

Append/Merge: The existing database is preserved. If the import data contains a hole which did not previously exist in the database, the hole is added (this is the "append" part). If data is imported into a hole which already exists in the database, the following process is followed: If the From-To intervals or Depth values are identical in the existing and in the imported data, then the different fields/channels are overwritten in-place. Pre-existing channels which are not imported are preserved. However, if the from-to or depth values in the imported data do not match the pre-existing hole data, then the original data is deleted, and the new data is imported into a newly created database table.

Script Parameter: DHREFRESH.OVERWRITE

Application Notes

This GX works only with databases that have been created using the wizards for the ASCII, XLS/Database or ODBC imports on databases created since v6.0, and for acQuire imports on drillhole projects created since v8.2.

When data is imported using an import wizard, an import template file is created which stores all the necessary information about the source of data and the format and selection of the data fields which are to be imported. Subsequent imports from the same source can be done using the template directly, without needing to go through the wizard again.

As of version 6.0, the import template produced during the import is stored inside the database into which the data is imported. This GX goes through each constituent database in the drill project, extracts the stored import template, and runs the DHIMPORT GX using that template to refresh each database in turn. The DHIMPORT GX preserves the various channel-specific plotting options used in creating drillhole maps (plan, section, strip log etc.), even if the database is overwritten.