0% found this document useful (0 votes)
187 views8 pages

Mitaa Not

Download as txt, pdf, or txt
Download as txt, pdf, or txt
Download as txt, pdf, or txt
You are on page 1/ 8

Database Management - Database Load Report Feb 10, 2018

Date : 10-Feb-18
Database : mitaa
Format_file : mitaa.dsc

=====================================================================

#############
Loading Table : collar from file Collar.csv
#############
Warning: Length of value to load into field ''hole_id'' is too great for the
defined field length
Warning: NULL values not allowed for field y
Warning: NULL values not allowed for field x
Warning: NULL values not allowed for field z
Warning: NULL values not allowed for field max_depth
Hole_ID;Northing;Easthing;Elevation;Max_Depth;Hole_Path;Location

Warning: Length of value to load into field ''hole_id'' is too great for the
defined field length
Warning: NULL values not allowed for field y
Warning: NULL values not allowed for field x
Warning: NULL values not allowed for field z
Warning: NULL values not allowed for field max_depth
1;9744207;253658;55;110;CURVED;PIT MITA

Warning: Length of value to load into field ''hole_id'' is too great for the
defined field length
Warning: NULL values not allowed for field y
Warning: NULL values not allowed for field x
Warning: NULL values not allowed for field z
Warning: NULL values not allowed for field max_depth
2;9744117;253723;54;110;CURVED;PIT MITA

Warning: Length of value to load into field ''hole_id'' is too great for the
defined field length
Warning: NULL values not allowed for field y
Warning: NULL values not allowed for field x
Warning: NULL values not allowed for field z
Warning: NULL values not allowed for field max_depth
3;9744031;253779;51;110;CURVED;PIT MITA

Warning: Length of value to load into field ''hole_id'' is too great for the
defined field length
Warning: NULL values not allowed for field y
Warning: NULL values not allowed for field x
Warning: NULL values not allowed for field z
Warning: NULL values not allowed for field max_depth
4;9744158;253695;54;110;CURVED;PIT MITA

Warning: Length of value to load into field ''hole_id'' is too great for the
defined field length
Warning: NULL values not allowed for field y
Warning: NULL values not allowed for field x
Warning: NULL values not allowed for field z
Warning: NULL values not allowed for field max_depth
5;9744127;253633;54;110;CURVED;PIT MITA

Warning: Length of value to load into field ''hole_id'' is too great for the
defined field length
Warning: NULL values not allowed for field y
Warning: NULL values not allowed for field x
Warning: NULL values not allowed for field z
Warning: NULL values not allowed for field max_depth
6;9743910;253850;52;110;CURVED;PIT MITA

Warning: Length of value to load into field ''hole_id'' is too great for the
defined field length
Warning: NULL values not allowed for field y
Warning: NULL values not allowed for field x
Warning: NULL values not allowed for field z
Warning: NULL values not allowed for field max_depth
7;9743938;253668;53;110;CURVED;PIT MITA

Warning: Length of value to load into field ''hole_id'' is too great for the
defined field length
Warning: NULL values not allowed for field y
Warning: NULL values not allowed for field x
Warning: NULL values not allowed for field z
Warning: NULL values not allowed for field max_depth
8;9743920;253702;54;110;CURVED;PIT MITA

Warning: Length of value to load into field ''hole_id'' is too great for the
defined field length
Warning: NULL values not allowed for field y
Warning: NULL values not allowed for field x
Warning: NULL values not allowed for field z
Warning: NULL values not allowed for field max_depth
9;9743825;253716;61;110;CURVED;PIT MITA

Warning: Length of value to load into field ''hole_id'' is too great for the
defined field length
Warning: NULL values not allowed for field y
Warning: NULL values not allowed for field x
Warning: NULL values not allowed for field z
Warning: NULL values not allowed for field max_depth
10;9743797;253603;58;110;CURVED;PIT MITA

Warning: Length of value to load into field ''hole_id'' is too great for the
defined field length
Warning: NULL values not allowed for field y
Warning: NULL values not allowed for field x
Warning: NULL values not allowed for field z
Warning: NULL values not allowed for field max_depth
11;9743726;253486;68;110;CURVED;PIT MITA

Warning: Length of value to load into field ''hole_id'' is too great for the
defined field length
Warning: NULL values not allowed for field y
Warning: NULL values not allowed for field x
Warning: NULL values not allowed for field z
Warning: NULL values not allowed for field max_depth
12;9743668;253442;68;110;CURVED;PIT MITA
Warning: Length of value to load into field ''hole_id'' is too great for the
defined field length
Warning: NULL values not allowed for field y
Warning: NULL values not allowed for field x
Warning: NULL values not allowed for field z
Warning: NULL values not allowed for field max_depth
13;9743673;253573;67;110;CURVED;PIT MITA

Warning: Length of value to load into field ''hole_id'' is too great for the
defined field length
Warning: NULL values not allowed for field y
Warning: NULL values not allowed for field x
Warning: NULL values not allowed for field z
Warning: NULL values not allowed for field max_depth
14;9743630;253701;57;110;CURVED;PIT MITA

Warning: Length of value to load into field ''hole_id'' is too great for the
defined field length
Warning: NULL values not allowed for field y
Warning: NULL values not allowed for field x
Warning: NULL values not allowed for field z
Warning: NULL values not allowed for field max_depth
15;9743684;253850;53;110;CURVED;PIT MITA

Warning: Length of value to load into field ''hole_id'' is too great for the
defined field length
Warning: NULL values not allowed for field y
Warning: NULL values not allowed for field x
Warning: NULL values not allowed for field z
Warning: NULL values not allowed for field max_depth
16;9743824;253931;56;110;CURVED;PIT MITA

Warning: Length of value to load into field ''hole_id'' is too great for the
defined field length
Warning: NULL values not allowed for field y
Warning: NULL values not allowed for field x
Warning: NULL values not allowed for field z
Warning: NULL values not allowed for field max_depth
17;9744174;253803;65;110;CURVED;PIT MITA

Warning: Length of value to load into field ''hole_id'' is too great for the
defined field length
Warning: NULL values not allowed for field y
Warning: NULL values not allowed for field x
Warning: NULL values not allowed for field z
Warning: NULL values not allowed for field max_depth
18;9744025;253952;48;110;CURVED;PIT MITA

Warning: Length of value to load into field ''hole_id'' is too great for the
defined field length
Warning: NULL values not allowed for field y
Warning: NULL values not allowed for field x
Warning: NULL values not allowed for field z
Warning: NULL values not allowed for field max_depth
19;9743884;253972;55;110;CURVED;PIT MITA

Warning: Length of value to load into field ''hole_id'' is too great for the
defined field length
Warning: NULL values not allowed for field y
Warning: NULL values not allowed for field x
Warning: NULL values not allowed for field z
Warning: NULL values not allowed for field max_depth
20;9743870;253840;52;110;CURVED;PIT MITA

Warning: Length of value to load into field ''hole_id'' is too great for the
defined field length
Warning: NULL values not allowed for field y
Warning: NULL values not allowed for field x
Warning: NULL values not allowed for field z
Warning: NULL values not allowed for field max_depth
21;9743741;253955;59;110;CURVED;PIT MITA

Warning: Length of value to load into field ''hole_id'' is too great for the
defined field length
Warning: NULL values not allowed for field y
Warning: NULL values not allowed for field x
Warning: NULL values not allowed for field z
Warning: NULL values not allowed for field max_depth
22;9743583;253957;60;110;CURVED;PIT MITA

Warning: Length of value to load into field ''hole_id'' is too great for the
defined field length
Warning: NULL values not allowed for field y
Warning: NULL values not allowed for field x
Warning: NULL values not allowed for field z
Warning: NULL values not allowed for field max_depth
23;9743577;253887;55;110;CURVED;PIT MITA

Warning: Length of value to load into field ''hole_id'' is too great for the
defined field length
Warning: NULL values not allowed for field y
Warning: NULL values not allowed for field x
Warning: NULL values not allowed for field z
Warning: NULL values not allowed for field max_depth
24;9743593;253795;54;110;CURVED;PIT MITA

Warning: Length of value to load into field ''hole_id'' is too great for the
defined field length
Warning: NULL values not allowed for field y
Warning: NULL values not allowed for field x
Warning: NULL values not allowed for field z
Warning: NULL values not allowed for field max_depth
25;9743736;253650;57;110;CURVED;PIT MITA

Warning: Length of value to load into field ''hole_id'' is too great for the
defined field length
Warning: NULL values not allowed for field y
Warning: NULL values not allowed for field x
Warning: NULL values not allowed for field z
Warning: NULL values not allowed for field max_depth
26;9743889;253501;63;110;CURVED;PIT MITA

Warning: Length of value to load into field ''hole_id'' is too great for the
defined field length
Warning: NULL values not allowed for field y
Warning: NULL values not allowed for field x
Warning: NULL values not allowed for field z
Warning: NULL values not allowed for field max_depth
27;9743987;253579;59;110;CURVED;PIT MITA

Warning: Length of value to load into field ''hole_id'' is too great for the
defined field length
Warning: NULL values not allowed for field y
Warning: NULL values not allowed for field x
Warning: NULL values not allowed for field z
Warning: NULL values not allowed for field max_depth
28;9743981;253666;53;110;CURVED;PIT MITA

Warning: Length of value to load into field ''hole_id'' is too great for the
defined field length
Warning: NULL values not allowed for field y
Warning: NULL values not allowed for field x
Warning: NULL values not allowed for field z
Warning: NULL values not allowed for field max_depth
29;9744109;253700;64;110;CURVED;PIT MITA

Warning: Length of value to load into field ''hole_id'' is too great for the
defined field length
Warning: NULL values not allowed for field y
Warning: NULL values not allowed for field x
Warning: NULL values not allowed for field z
Warning: NULL values not allowed for field max_depth
30;9744232;253676;65;110;CURVED;PIT MITA

Warning: Length of value to load into field ''hole_id'' is too great for the
defined field length
Warning: NULL values not allowed for field y
Warning: NULL values not allowed for field x
Warning: NULL values not allowed for field z
Warning: NULL values not allowed for field max_depth
31;9744046;253305;62;110;CURVED;PIT MITA

Warning: Length of value to load into field ''hole_id'' is too great for the
defined field length
Warning: NULL values not allowed for field y
Warning: NULL values not allowed for field x
Warning: NULL values not allowed for field z
Warning: NULL values not allowed for field max_depth
32;9744348;253685;65;110;CURVED;PIT MITA

0 records were inserted.


0 records were updated.
33 records were rejected.

#############
Loading Table : survey from file Survey.csv
#############
Warning: Length of value to load into field ''hole_id'' is too great for the
defined field length
Warning: NULL values not allowed for field depth
Warning: NULL values not allowed for field dip
Warning: NULL values not allowed for field azimuth
Hole_ID;Max_Depth;Dip;Azimuth

Warning: NULL values not allowed for field depth


Warning: NULL values not allowed for field dip
Warning: NULL values not allowed for field azimuth
1;110;-90;0

Warning: NULL values not allowed for field depth


Warning: NULL values not allowed for field dip
Warning: NULL values not allowed for field azimuth
2;110;-90;0

Warning: NULL values not allowed for field depth


Warning: NULL values not allowed for field dip
Warning: NULL values not allowed for field azimuth
3;110;-90;0

Warning: NULL values not allowed for field depth


Warning: NULL values not allowed for field dip
Warning: NULL values not allowed for field azimuth
4;110;-90;0

Warning: NULL values not allowed for field depth


Warning: NULL values not allowed for field dip
Warning: NULL values not allowed for field azimuth
5;110;-90;0

Warning: NULL values not allowed for field depth


Warning: NULL values not allowed for field dip
Warning: NULL values not allowed for field azimuth
6;110;-90;0

Warning: NULL values not allowed for field depth


Warning: NULL values not allowed for field dip
Warning: NULL values not allowed for field azimuth
7;110;-90;0

Warning: NULL values not allowed for field depth


Warning: NULL values not allowed for field dip
Warning: NULL values not allowed for field azimuth
8;110;-90;0

Warning: NULL values not allowed for field depth


Warning: NULL values not allowed for field dip
Warning: NULL values not allowed for field azimuth
9;110;-90;0

Warning: NULL values not allowed for field depth


Warning: NULL values not allowed for field dip
Warning: NULL values not allowed for field azimuth
10;110;-90;0

Warning: NULL values not allowed for field depth


Warning: NULL values not allowed for field dip
Warning: NULL values not allowed for field azimuth
11;110;-90;0

Warning: NULL values not allowed for field depth


Warning: NULL values not allowed for field dip
Warning: NULL values not allowed for field azimuth
12;110;-90;0
Warning: NULL values not allowed for field depth
Warning: NULL values not allowed for field dip
Warning: NULL values not allowed for field azimuth
13;110;-90;0

Warning: NULL values not allowed for field depth


Warning: NULL values not allowed for field dip
Warning: NULL values not allowed for field azimuth
14;110;-90;0

Warning: NULL values not allowed for field depth


Warning: NULL values not allowed for field dip
Warning: NULL values not allowed for field azimuth
15;110;-90;0

Warning: NULL values not allowed for field depth


Warning: NULL values not allowed for field dip
Warning: NULL values not allowed for field azimuth
16;110;-90;0

Warning: NULL values not allowed for field depth


Warning: NULL values not allowed for field dip
Warning: NULL values not allowed for field azimuth
17;110;-90;0

Warning: NULL values not allowed for field depth


Warning: NULL values not allowed for field dip
Warning: NULL values not allowed for field azimuth
18;110;-90;0

Warning: NULL values not allowed for field depth


Warning: NULL values not allowed for field dip
Warning: NULL values not allowed for field azimuth
19;110;-90;0

Warning: NULL values not allowed for field depth


Warning: NULL values not allowed for field dip
Warning: NULL values not allowed for field azimuth
20;110;-90;0

Warning: NULL values not allowed for field depth


Warning: NULL values not allowed for field dip
Warning: NULL values not allowed for field azimuth
21;110;-90;0

Warning: NULL values not allowed for field depth


Warning: NULL values not allowed for field dip
Warning: NULL values not allowed for field azimuth
22;110;-90;0

Warning: NULL values not allowed for field depth


Warning: NULL values not allowed for field dip
Warning: NULL values not allowed for field azimuth
23;110;-90;0

Warning: NULL values not allowed for field depth


Warning: NULL values not allowed for field dip
Warning: NULL values not allowed for field azimuth
24;110;-90;0
Warning: NULL values not allowed for field depth
Warning: NULL values not allowed for field dip
Warning: NULL values not allowed for field azimuth
25;110;-90;0

Warning: NULL values not allowed for field depth


Warning: NULL values not allowed for field dip
Warning: NULL values not allowed for field azimuth
26;110;-90;0

Warning: NULL values not allowed for field depth


Warning: NULL values not allowed for field dip
Warning: NULL values not allowed for field azimuth
27;110;-90;0

Warning: NULL values not allowed for field depth


Warning: NULL values not allowed for field dip
Warning: NULL values not allowed for field azimuth
28;110;-90;0

Warning: NULL values not allowed for field depth


Warning: NULL values not allowed for field dip
Warning: NULL values not allowed for field azimuth
29;110;-90;0

Warning: NULL values not allowed for field depth


Warning: NULL values not allowed for field dip
Warning: NULL values not allowed for field azimuth
30;110;-90;0

Warning: NULL values not allowed for field depth


Warning: NULL values not allowed for field dip
Warning: NULL values not allowed for field azimuth
31;110;-90;0

Warning: NULL values not allowed for field depth


Warning: NULL values not allowed for field dip
Warning: NULL values not allowed for field azimuth
32;110;-90;0

0 records were inserted.


0 records were updated.
33 records were rejected.

Page 1 of 1

You might also like