Grid Data Import
To import Grid Data using Dips Import Wizard:
- Select: File > Import > Import Wizard.
- In the Import Data Types page of the Dips Import Wizard dialog:
- Select the Grid Data checkbox to import to Grid Data.
- If at least one of the Data Types is selected, the Next button will be enabled.
- Select Next to proceed to defining the import file and format.
- In the Grid Data Import page of the Dips Import Wizard dialog:
- Under Import File:
- Select the Open
button to add an Excel (.xls or .xlsx) file to Import File. You may select one or more files. The Input File Preview will show a preview of the first 100 rows of the selected Import File.
- Select the Excel Sheet to read from the Import File.
- Set the First Data Row. The First Data Row will be the row where Dips starts reading data from.
- Select the Open
- To automatically import all columns of Excel data, select Append All Unused Columns as Extra Columns checkbox. This will automatically take any columns of data not assigned in the Data to Columns grid (i.e., From Column = None) and add it as an extra columns in Grid Data (to the right of all predefined columns).
- To include the header text with this data, select the Import Headers from Row checkbox and set the header row to read from.
- Under Orientation:
- Set the Global Orientation Format of all the data in Grid Data. The Global Orientation Format set here will override the Global Orientation Format set in Project Settings.
- Set the Declination correction of all the data in Grid Data. The Declination set here will override the Declination set in Project Settings.
- Under Columns:
- Check the Quantity Column checkbox if you want to include the predefined Quantity column in Grid Data.
- Check the Distance Column checkbox if you want to include the predefined Distance column in Grid Data.
- Check the X, Y, Z Columns checkbox if you want to include the predefined X, Y, Z columns in Grid Data.
- Check the Persistence Column checkbox if you want to include the predefined Persistence column in Grid Data.
- The Quantity Column, Distance Column, X, Y, Z Columns, and Persistence Column set here will override the Columns set in Project Settings.
- Under Units:
- Select the Metric or Imperial radio control to set the Units used for length measurements.
- The Units set here will override the Units set in Project Settings.
- Under Data to Columns:
- Set the From Column to the corresponding Excel column from which Dips will read in the data to populate the Header Data entries.
- If Quantity Column is checked, a "Quantity" entry will be added in the Data to Columns grid.
- If Distance Column is checked, a "Distance" entry will be added in the Data to Columns grid.
- If X, Y, Z Columns is checked, three "X", "Y" and "Z" entries will be added in the Data to Columns grid.
- If Persistence Column is checked, a "Persistence" entry will be added in the Data to Columns grid.
- If any Traverses are being imported or already exist, a "Traverse" entry will be added. Any extra columns which already exist, will also be automatically added.
- If you would like to add additional data as extra columns in Grid Data, you may do so by clicking the Add
button. A new entry row will appear in the Data to Columns grid, below the existing entries.
- To delete a Data Header, click the Delete
button.
- You can rename any newly added Data Header. You cannot rename or delete predefined Dips entry types, or existing columns, which are shaded in grey.
- By default, Overwrite Existing Grid Data checkbox is selected, which means that existing row entries in the Grid Data will be replaced by this data upon import. Uncheck Overwrite Existing Grid Data checkbox if you would like to append the data to existing entries in the Grid Data.
- If at least one Data Header is being imported, the Import Data Preview will show a preview of the first 100 rows of the selected import data, and the Next button will be enabled.
- Select Next to proceed to the Import Summary page of the Dips Import Wizard dialog.
- Under Import File:
- In the Import Summary page of the Dips Import Wizard dialog:
- Review the Import Data Type and its Status (Overwrite or Append).
- If any errors were detected (see Grid Data Import Rules and Limitations topic for more information), they will be listed under the Warnings box. The Finish button will not be enabled until all errors are resolved.
- To save the current settings as a template, select the Save Current Import Settings as a Template checkbox and specify the Template Name. See the Import Settings Template topic for more information.
- Go Back to modify any import data.
- Click Finish to start importing the data into Dips.
Navigate to the main Grid Data view. You should see that the data was successfully imported from Excel and into the Grid Data table.