Import Bolts from CSV File

The Import Bolts from CSV File feature offers an option to generate bolts by importing a CSV file. This includes delimited text files such as *.txt and *.csv.

To use this feature, an external geometry must exist, otherwise it will remain disabled, grayed out.

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. In default Snap Bolts option is checked with the tolerance of 10 % to make sure those bolts with their head locations in 10 % proximity to attach to the nearest surface. This can also be done after the importing process as a standalone feature to support this behavior is offered independent to Import Bolts from CSV feature. For more information about the Snap Bolts control, see linked topic.
   5. Optionally, users can select the Import Bolt Properties checkbox if different bolt property must be assigned for the imported bolts. However, bolt property items with matching names must exist in RS3 Bolt Properties dialog. Note that this option is not intended to explicitly import the mechanical properties, which are controlled from the Bolt Properties dialog within RS3, but to make distinguishment for different property assignment.
   6. The bolts can also imported with stage controls with Import Stage Settings checked (default). With this option enabled, it requires the imported database to have two separate columns for each bolt to define Installation Stage and Removal Stage. Analogous to Import Bolt Properties option, the project file must have the corresponding stages pre-defined with matching stage names as entered in the database.
   7. 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. Note that Bolt Property, Installation Stage and Removal Stage can be modified/selected in this dialog based on the available options; however, the geometrical information can only be fixed from the source file.
   
   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. 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."
      Note: Invalid bolt entries are not shown in the Preview.
   4. A Preview of bolts for import is shown in the 3D CAD View, colored according to the Bolt Property color.
   5. 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 are grouped under one Imported Bolts entity in the Visibility Tree.