Identifying collars missing from collar file only
Does anyone know of a way in MIcromine to identify collars which are present in downhole data files but are not defined in the collar file?
I know Drillhole | Database | Validate > 'Check for missing collars' can do this, but the problem is that it also flags all collars that are in the collar file but have no downhole data, which is no good (there may be many valid reasons for a hole not being represented in certain downhole files).. I want to identify collars that are only missing from the collar file.
[this problem has been caused by Micromine treating Hole IDs as case sensitive - previously I was able to guard against missing collar records in Access, but that is no longer adequate as Micromine is now case sensitive - Access will not distinguish between hole ID "BNP001" and "bnp001" but case-sensitive Micromine will not see these hole IDs as being the same and so downhole data for this hole would not be plotted].
Customer support service by UserEcho
Micromine has always been case sensitive and while your DB may not be cases sensitive it is good practice to ensure that everything is in a consistent case. To identify the phantom holes, try File Fields Extract Unique, to get a unique list of hole IDs; Case sensitive, in your down hole file. Them use File | Merge |Micromine to merge a flag from your collar file to your file of unique IDs, the records that are not flagged will be the ones you need to correct.
Steve, Yes the validation also flags all collars that are in the collar file but have no downhole data, you can identify the collars that are in the collar file but have no downhole data by the file name column (which will be the collar file).