Upload blast holes into database

You can use this function to load blast holes, that are in string file format and displayed in Graphics, into a blast hole database. After you save the blast holes in the database, you can work with only the blast holes that are most relevant to you at any time.

Prerequisites: A blast hole database exists and at least one blast hole is displayed in Graphics in the layer called blast hole layer. If the database is not already open when you run this function, you are prompted to select a database to open.

To run this function: Choose Design > Blast design > Database > Upload blast holes into database, or...

In the Function Chooser, type BLAST LOAD TO DATABASE, and press ENTER.

Fields on the Load blast holes to database form

Field	Description
Duplicate blast holes	If any of the blast holes that you are uploading already exist in the database, those holes appear in the list in this section. Two holes are marked as duplicates if they have the same hole ID and the same blast pattern number.
Overwrite with new blastholes	Selected: You will overwrite the duplicate blast holes with the new ones. Cleared: The option to clear this check box might be used in a future version of Surpac. Currently, if there are duplicate blast holes and you clear this box and click Apply, Surpac prevents you from loading any of the blast holes to the database and displays a message in the Message box to inform you.
Extra blast holes	This section shows a list of the blast holes, that already exist in the database, which you are not uploading.
Delete holes from database	Selected: All the extra blast holes are deleted from the database. Cleared: None of the extra blast holes are deleted from the database.
Charging Data
Load charging data	Selected: Data is loaded into the Charging Data table you choose. Cleared: No charging data is loaded into the database.
Table name	The name of the table, in the blast hole database, to which all charging data is loaded.
Sample data
Load sample data	Selected: Sample interval fields are created in the Sample Data table you choose. Select this option if you are drilling the holes for both sampling and blasting. Cleared: No sample interval fields, or any other fields or data, are loaded to the Sample Data table. Select this option if you are drilling the blast holes only for blasting, and not for sampling.
Table name	The name of the table, in the blast hole database, that contains data about sample intervals.
Sample prefix	The prefix to use in each sample ID record. To use the ID of each hole as the prefix, type a sample prefix of %ID%.
Sample suffix	The suffix to use in each sample record.
Increment start	The single number, or letter, to use to uniquely identify the first sample. The system will increment this number or letter for each sample record. Tip: Press TAB, and look in the Sample Id example field to see what the Sample prefix will look like.
Increment method	Continuous: The sample number, or letter, continues to increment for each record even when the hole id changes. Reset at each hole: The sample number, or letter, resets to the Increment start value when the hole id changes.
Padding length	The number of digits that the increment has. When Padding length is 0, the increment is left aligned. When Padding length is a positive integer, the increment is right aligned, and the Padding character is used for any missing digits.
Padding character	The character to use for missing digits to create a fixed length hole id, for example 0.
Sampling method	Single sample: Creates a single sample for each hole. You must also type a Sample length. Fixed length: Creates samples of a fixed length in each hole. The number of samples for each hole depends on the Sample length and the length of the hole. Varying length: Creates samples of different lengths using the range specification that you type in the Sample length field.
Sample length	Each Sampling method uses the Sample length field differently. Single sample. Sample length is the length of the single sample used for every hole. When Sample length is blank, the length is the entire hole depth. Fixed length. Sample length is the length of each sample. For example, if Sample length is 5 and a hole is 15 metres long, you will create 3 samples in that hole. Note: You can use End sample method to set a method of handling any distance remaining at the end of each hole. Varying length. Sample length is a range specification. For example, 2;5;10 creates a sample from 0-2 metres in every hole, a sample from 2-5 metres, and a sample from 5-10 metres
End sample method	The method of handling any distance remaining at the end of each hole. ignore partial sample: distance remaining is not used. include partial sample: distance remaining is used as a separate sample extend to hole length: the final sample in the hole is extended to include the remaining distance. extend on tolerance: the final sample in the hole is extended to include the remaining distance, provided that the extra distance is less than or equal to Distance. include if min length: an additional sample is created to hold the remaining distance, provided that the remaining distance is greater than or equal to Distance.
Distance	The threshold value that determines whether extra distance remaining at the end of a hole is included in the final sample in a hole.
Sample Id example	This section shows a preview of the sample ids that you will create in the ring design database. When you type different values in the Sample Label section, the Sample Id example changes.

Report file name	The name of the report that Surpac creates. All messages or errors that occurred when uploading the blast holes to the database appear in the report. This field is mandatory.
Format	The file format of the upload report.

Output

The positional information of each blast hole in the layer called blast hole layer is loaded into the collar table and survey table of the blast hole database. If you selected the Load charging data option, charging data is loaded into the table you chose for charging data. If you selected Load sample data, sample fields are created in the table you specified for sample data.

Note: The sample fields do not yet contain any sample data.

The blast holes that are in string format, are removed from Graphics.

Messages