Expert Modelling: Hands-on help from Rocscience Engineers. Register Here
 

Search Results

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.

Account Icon - click here to log in or out of your account Shopping Cart icon Click here to search our site Click here to close Learning Tech Support Documentation Info Chevron Delete Back to Top View More" PDF File Calendar Location Language Fees Video Click here to visit Rocscience's LinkedIn page Click here to visit Rocscience's YouTube page Click here to visit Rocscience's Twitter page Click here to visit Rocscience's Facebook page Click here to visit Rocscience's Instagram page Bookmark Network Scroll down for more Checkmark Download Print Back to top Single User Multiple Users CPillar Dips EX3 RocFall RocPlane RocSupport RocTopple RS2 RS3 RSData RSPile Settle3 Slide2 Slide3 SWedge UnWedge Commercial License Education License Trial License Shop safe & secure Money-back guarantee