Grid Data Import Rules and Limitations
Import File
Dips Import Wizard reads columnized data in Excel format (.xls or .xlsx).
MULTIPLE EXCEL IMPORT FILES
If importing more than one Excel file for Grid Data, ensure that all files have consistent sheet, and column format.
- Same number of sheets
- Same order of sheets
- Same order of column headers
- Same first data row
- Same header row (if a header exists)
NOTE: The selections in the Grid Data page of the Dips Import Wizard dialog apply to all the Import Files, and are not set individually as file-specific settings.
If you need to import mutliple Excel file of differing formats, you can re-rerun Dips Import Wizard, make the corresponding selections, and unselect the Overwrite Existing Grid Data checkbox. This will append the imported data.
Import Data
Selections in the Grid Data must ensure that the import data follows the these rules:
- All orientation Header Data (i.e., Dip, Dip Direction, Strike (Right), Strike (Left), Trend, Plunge, Orient 1, Orient 2) must be non-blank and numeric.
- The Quantity Header Data must be non-blank and numeric.
- The Distance Header Data must be numeric and >= 0.
- The Traverse Header Data must match Traverse IDs specified in Traverse Information.
- The column headers (i.e., Header Data) names must be unique.
If any of these rules are violated, error message(s) will appear under Warnings in the final Import Summary page of the Dips Import Wizard dialog.
NOTE: If appending the data to existing Grid Data (i.e., Overwrite Existing Grid Data checkbox is unselected), the above rules will also be checked against the existing data.