In micromine, you can validate fields, to avoid error in the future database. With validate you can compare the data in selected fields of a file against permitted values that you have set up in a check file. When you run this function, data in the chosen fields is validated against the data in your check file. A report is then generated with detailed information on the results of the validation. Your data in both the input and check files remains unchanged. You can also check numeric values against a minimum and maximum range. Another example where you can use validation is to check the lithological names you have in a file. You would then set up a check file with all allowable names, and use it to compare your entries against that check.
To validate the data in a file, do the following:
- Select the File | Fields | Validate menu option.
- In the Input section, enter the name of the file to be validated. Define a filter to selectively control which records will be processed.
- To validate files with FROM and TO fields (e.g. Drill Holes), select DRILL HOLE from the Data type list and enter the name of the hole field and the fields containing the From and To measurements of the sample. If you want to validate any other type of data select GENERAL.
- Enter the name of the Check file that contains the permitted values against which you want to compare your data.
- Enter the name of the Report file where you want to store the results of the validation. The report file will only contain details of the fields that do not pass the validation. If this filedoes not yet exist it will be created.
- In the table, type the name of the fields (from the input file) that need to be validated, the minimum and maximum values they can contain and the name of the check fields (in the check file) that contain the acceptable values. (The minimum and maximum fields may only be entered for numeric values. You can also apply a check file to numeric fields but still need to enter values in the minimum and maximum fields).
- You can further restrict the validation by optionally selecting the Ignore Blanks or Case Sensitive boxes.
- Click OK.
This is the short video regarding this tutorial created by myself. Please leave any comment or question if any. Thanks.