You can quickly export your data from MX Deposit to CSV files using the built-in export function. The default behaviour of the export is that every table is exported as a CSV file and the headers in the CSV file match exactly as they appear in MX Deposit. If you want to customize the export, you can make use of the Export Templates feature.
If you are exporting data for multiple projects, the data will be exported for each activity. That is - you will get a set of CSV files for each activity.
How it Works
The steps to export your data are:
- Select the list of holes or points to be exported
- Click the Export icon
- Select your export options
- Click Export
The data for the selected list of drill holes or points will be compiled into CSV files and a compressed (.ZIP) file will be downloaded to your computer.
Header & Coordinates
The "header" file contains a single coordinate record, which represents the "top" row in the coordinates table for each hole or point. Always make sure your most accurate coordinate appears at the top of the coordinates table. Alternatively, you can use the "coordinate type ranking" options in the Export Template feature to specify a ranking of what coordinates types to use.
The header file contains a set of columns that are prefixed with "coordinates." (e.g. "coordinates.grid", "coordinates.northing", "coordinates.easting", etc.). These columns represent the data (of the top row) as it appears in MX Deposit. There is another set of columns that are prefixed with "converted.coordinates" (e.g. "converted.coordinates.grid", "converted.coordinates.northing", "converted.coordinates.easting", etc.) that represent the converted coordinates. The coordinate conversion is performed at the time of export, based on the export grid that was selected (see export options below).
The header file contains a single coordinate (using behaviour described above), and another "Coordinates" file is generated that exports all coordinate rows from the coordinate table in every point/hole included in the export.
Tables
Each table in the activity will be exported as a separate CSV file. The column headers appear as they are defined in MX Deposit.
Table Views
Each table view in the activity will be exported as a separate CSV file. The column headers appear as they are defined in MX Deposit and each column header is prefixed with the table name (since a table view can have columns from multiple tables).
If you enable the "Include child table files" export option (see below) then an additional file will be exported for each table that is contained in each table view.
For example, if you have a table view that consists of columns from a Mineralization table as well as columns from an Alteration table - you will get one export file with all columns from both tables, and each column will have the "Mineralization." or "Alteration." prefix (depending on which table it came from). If you enabled the "Include child table files" option, you would also get one file with all the Mineralization columns and another file with all the Alteration columns.
Samples & Sample Results
The "samples" and "sample results" tabs that you see in MX Deposit are merged into a single "samples" file on export. All sample result columns will be exported, including any Ranked Sample Result columns that are configured in the activity. For any sample result columns that are flagged as "result with status", the export will also contain the following columns for each result with status:
[status] : the actual status that was assigned on import (based on validation rules)
[certificate] : the lab certificate number for the result with status
[certificate completed] : the "date completed" value for the lab certificate
For example, if you have an "Au (ppm) Au-AA23" column that is set as a "result with status", the export will look like this:
The export will also include a [parent sample number] column if there are any duplicate samples in the export set. This value shows the link back to the "parent" sample for each "duplicate" sample.
Export options
When you click on the export icon to run an export, the "Export options" dialog appears:
Destination
Select the file type(s) that you want to export to, CSV files or a single Excel file. You can choose both output options, or any single one.
Grid
Select the grid that you want to export the header coordinates as. This option controls what gets populated in the "converted.coordinates" columns described above. The "coordinates." columns in the export file will always contain the raw coordinates as they were entered, and the "converted.coordinates." columns will contain the coordinates converted to the selected grid.
File Encoding
All data in MX Deposit is stored using the UTF-8 character encoding. By default, the export CSV files generated by MX Deposit are created using the same UTF-8 encoding. If you are importing the files generated by MX Deposit into another software package that is using a different encoding, you can sometimes have problems with that software recognizing certain characters.
For example, if you have some text in a comments column with special characters:
If you export this data as UTF-8 and then open it with an application that is using a different encoding, that text would appear like this:
This is a function of how the characters are encoded, and how the application is rendering them. The encoding needs to match for everything to appear correctly.
NOTE: The default encoding for most Windows applications is "Windows-1252". If you open a UTF-8 encoded CSV file in an application that is using the default Windows encoding, you might have the issue described above (for special characters).
The "ANSI" encoding option matches the default Windows encoding, so if you encounter any issues with special characters appearing as above, then use the "ANSI" encoding export option.
Date Format
Select the date format that you want to apply to all date values in the export file. The default date format is determined by your browser regional settings.
NOTE: Some applications apply their own date formats when they recognize date values. For example, if you open a CSV file in MS Excel, it will apply its own date format. To confirm that dates are exported in the correct format, you must open the CSV file in a text editor that will treat it as a text file.
Additional Options
| Include system fields |
This option will append 4 columns to every export file. These "system" fields are automatically populated for every row of data in the database. These fields are: [Created date] : the date that the hole/point/row was created [Created by] : the user that created the hole/point/row [Last updated date] : the date the the hole/point/row was last updated [Last updated by] : the user that last updated the hole/point/row |
| Include ID column | This option will append an [ID] column to every export file (except the header). This [ID] value is auto-generated by the system and is the unique identifier for the row. You can use this [ID] value to perform updates through the import module. If you import a file with an [ID] value, the import will update the row with that ID (as opposed to appending new import rows). |
| Include files |
This option will export any files associated with the holes/points that are being exported. Files are organized by hole/point, and then organized by file type (photos vs. other files).
The export constructs a file name for each file based on: [hole/point number] + [header/table name] + [column/field name] + [filename]
|
| Include metadata | This option will export a metadata file for each table in the export. The metadata file is in JSON format, and describes the schema of the data in each export file (e.g. data types, validations, list values). |
| Include child table files | This option will export a file for each table contained in a table view. The default behaviour is that a table view will export as a single file and every column is prefixed with the table name. |
To export data:
- Open the drill hole or point module that you want to export data for.
- Click on the project tab that you want to export data for.
- Select the data that you want to export.
- You can also set a sort preference to determine the order that the data will appear in the export file by clicking on the "Sort" icon.
- Click the "Export" icon.
- Select any export options.
- Click the “Export” button.
- The export will be processed and a compressed (.ZIP) file will be downloaded to your browser.
To export data using an Export Template:
- Open the drill hole or point module that you want to export data for.
- Click on the project tab that you want to export data for.
- Select the data that you want to export.
- You can also set a sort preference to determine the order that the data will appear in the export file by clicking on the "Sort" icon.
- Click the down-arrow beside the "Export" icon.
- Choose the export template that you want to apply.
- The export will be processed, based on the export template settings, and a compressed (.ZIP) file will be downloaded to your browser.
0 Comments