Import Bolts from CSV File

The Import Bolts from CSV File option is used to import bolts from a CSV file. This includes delimited text files such as *.txt and *.csv.

To import bolts from a CSV file:

1. Select Support > Import Bolts from CSV File.
2. The Import Bolts From CSV File dialog appears.
   1. Click the Browse button.
   2. In the Open file dialog, select a delimited text file (.txt, .csv) and click Open to load it.
   3. Under Define Bolt Geometry By, there are two options in which the bolt geometry can be imported:
      1. Start Point and End Point
      2. Start Point, Orientation and Length
   4. Optionally, users can select the Import Bolt Properties checkbox if the Bolt Property assignment data is also contained in the CSV file.
      
   5. Optionally, users can select the Import Stage Settings checkbox if the staging data for Install at Stage and Remove at Stage is contained in the CSV file.
   6. Click Next.
3. A preview of the file is shown. From this window, the user can specify how the data is imported.
   1. Set the Data Delimiter (e.g., Comma, Semi-Colon, Space, Tab, Pipe, or All).
   2. Set the Start Row. Any data from rows before the start row are ignored.
   3. Set the Data Column Selection for each of the expected columns by setting the column index.
      Note: The file must contain, at minimum, the predefined columns. All additional columns are appended to the right of the predefined columns.
   4. Click Next.
4. The next window shows a preview of the imported data and performs data validation on the bolt parameters.
   1. Enter a Name for the imported bolts.
   2. Assign a Bolt Property to each bolt by double-clicking the cell to activate the drop down and select a predefined bolt property.
      1. To assign a bolt property to all bolts: right-click, select Assign Bolt Property to All, and select a predefined bolt property.
      2. To assign a bolt property to selected bolts: highlight one or more cells/rows under the Bolt Property column, right-click, select Assign Bolt Property to Selected, and select a predefined bolt property.
         
   3. Assign Install at Stage and Remove at Stage to each bolt by double-clicking the cell to activate the drop down and select a predefined stage.
      1. To assign a stage to all bolts: right-click, select Assign Stage to All, and select a predefined stage.
      2. To assign a stage to selected bolts: highlight one or more cells/rows under the Install at Stage or Remove at Stage column, right-click, select Assign Stage to Selected, and select a predefined stage.
         
   4. If any cells contain invalid data (e.g., blank, mismatching Bolt Property name), then those cells are highlight RED, and the message "Some bolts are not shown in the Preview due to invalid data highlighted in the table above."
   Invalid bolt entries are not shown in the Preview.
   5. A Preview of bolts for import is shown in the 3D CAD View, coloured according to the Bolt Property colour.
   6. Click Import to import the data.
      
5. The Import Summary dialog shows the number of bolts which were imported successfully, and a list of import issues (if any).
6. Click Close to finish the import.

Once bolts are successfully imported, bolts that share the same Bolt Property (and Staging settings) are grouped under one Imported Bolts node in the Visibility Tree.

Bolt Geometry Definition

The Import Bolts from CSV File option allows for different bolt geometry definition formats:

Start Point and End Point

The following columns are expected:

• Start X
• Start Y
• Start Z
• End X
• End Y
• End Z

Start Point, Orientation, and Length

If Orientation is defined by Trend and Plunge, then the following columns are expected:

• Start X
• Start Y
• Start Z
• Trend
• Plunge
• Length

If Orientation is defined by Vector, then the following columns are expected:

• Start X
• Start Y
• Start Z
• Direction X
• Direction Y
• Direction Z
• Length

By default, the bolt geometry is defined by Start Point, Orientation and Length with Orientation set as Trend and Plunge.

Import Bolt Properties

By default, Import Bolt Properties checkbox is selected, which means that a Bolt Property column is expected. If Import Bolt Properties is selected, then the data under this column must correspond to the Name(s) of predefined bolt properties in the Define Bolt Properties dialog. If the CSV file does not contain a Bolt Property column, then uncheck Import Bolt Properties and manually assign Bolt Property to each bolt entry later in the import process.

Import Stage Settings

By default, the Import Stage Settings checkbox is selected, which means that Install at Stage and Remove at Stage columns are expected. If Import Stage Settings is selected, then the data under the two columns must correspond to the Name(s) of predefined stages in the Project Settings dialog. If the CSV file does not contain Install at Stage and Remove at Stage columns, then uncheck Import Stage Settings and manually assign staging to each bolt entry later in the import process.

Data Validation

In order for the bolt import to be successful, ensure that:

• Required fields are not blank
• Start X, Start Y, and Start Z are numeric and not blank.
• End X, End Y, and End Z are numeric and not blank. The length between the Start and End points is greater than 0.
• Direction X, Direction Y, and Direction Z are numeric and not blank. The length of the Direction vector is greater than.
• Length is numeric, greater than 0, and not blank.
• Trend is numeric, between 0 to 360 degrees, and not blank.
• Plunge is numeric, between -90 to 90 degrees and not blank.
• Bolt Property matches the Name of a predefined bolt property in the Define Bolt Properties dialog.
  
• Install at Stage and Remove at Stage matches the Name of predefined stages in the Project Settings dialog. Remove at Stage must also be a later stage to the Install at Stage.