Solid Edge has a complete set of holes sizes and types available, but what if the size you want is not in the list?
Up until Solid Edge ST6, users could add their own hole sizes to the Holes.txt file, stored in the Solid Edge-preferences folder, but an overhaul of the holes command in ST7 changed how these were stored.
The Hole Options dialog box has gone through a few changes, with new options such as sub type and fit added. The sub type allows for the user to pick the function of the hole, such as drill size, dowel size or screw clearance. In the latter case, the Size field will switch from drill or dowel size to thread size and the actual hole diameter will be slightly larger to allow for the thread clearance.
With a larger number of options available, it became harder to manage, so it was decided to use excel files “as a database” to manage the details in a more user-friendly format. The files are typically stored in “C:\Program Files\Solid Edge ST8\Preferences\Holes” and an excel file is available for each hole standard.
The first thing to note when you edit these files is that the format of the excel files (order of tabs or columns) should not be changed.
In the spreadsheet, there are tabs for the four different types of holes – Simple, threaded, Counterbore and countersunk. These can be ordered by using the normal excel sorting and you can add your own custom holes by purely adding in a new row and filling in the desired values in the appropriate columns.
If you have any legacy hole text files, there is a utility (in the solid edge custom, HoleDatabaseCoverter folder) that will convert the files in to the new format.
17,955 total views, 5 views today