Rocscience International Conference 2025 is going to take place in Sydney, Australia Read more

Search Results

Traverse Information 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 a given Traverse type, 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 Traverse Information Import 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 Traverse Information checkbox. This will append the imported data.

Import Data

TRAVERSES

Selections in the Traverses tab must ensure that the import data follows the these rules:

  • The ID Header Data must be non-blank.
  • All orientation Header Data (i.e., Trend, Plunge, Orient 1, Orient 2, Orient 3) must be non-blank and numeric.
  • Traverse IDs must be unique for all Traverses, not just for a given Traverse type.

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.

COLLAR DATA

If importing curved borehole Traverse types (i.e., Curved BH Oriented Core, Curved BH Televiewer), you will also need to import Collar Data.

Selections in the Collar Data tab must ensure that the import data follows the these rules:

  • The ID Header Data must be non-blank
  • The Collar Data ID matches the ID in Traverse Information.
  • The X, Y, Z Header Data must be non-blank and numeric.
  • The Total Depth Header Data must be non-blank and numeric.

SURVEY DATA

If importing curved borehole Traverse types (i.e., Curved BH Oriented Core, Curved BH Televiewer), you will also need to import Survey Data.

Selections in the Survey Data tab must ensure that the import data follows the these rules:

  • The ID Header Data must be non-blank
  • The Survey Data IDs contain the IDs in Traverse Information.
  • All the orientation Header Data (i.e., Trend, Plunge) must be non-blank and numeric.
  • The Total Depth Header Data must be non-blank and numeric.
  • The Total Depth Header Data must be in ascending order with no repeats.

NOTE: If appending the data to existing Traverse Information (i.e., Overwrite Existing Traverse Information checkbox is unselected), the above rules will also be checked against the existing data.

Rocscience logo, click here to return to the homepage Portal Account Portal Account Log In Log Out Home 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" Previous Next 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 X page Click here to visit Rocscience's Facebook page Click here to visit Rocscience's Instagram page Click here to visit Rocscience's Reddit page Bookmark Network Scroll down for more Checkmark Download Print Back to top Single User Multiple Users RSLog RocFall3 CPillar Dips EX3 RocFall RocPlane RocSlope3 RocSupport RocTopple RS2 RS3 RSData RSPile Settle3 Slide2 Slide3 SWedge UnWedge RocTunnel3 RocSlope2 BlastMetrix ShapeMetriX Fragmenter Commercial License Education License Trial License Shop safe & secure Money-back guarantee