If you want to edit many tools, editing them individually in the
Tool Properties dialog may be time-consuming.
There are several ways to bulk-edit tools:
-
Export the tools to a
.tdb file, edit them in Excel, then
reimport them.
Warning: You must select
Overwrite with new tool in the
Tool Import dialog when reimporting, otherwise you lose form curve information. By selecting
Overwrite with new tool, the numeric information is overwritten, but the form curve is not lost.
-
Export the tools to an
.xml file, edit them in Notepad, then
reimport them. This method keeps the curve/holder information regardless of your overwrite choice upon import. The disadvantage with this method is that it is not so easy to edit an
.xml file.
- Use a BASIC macro to do your edits. This is useful if you have many edits to do of a similar type and you are adept at writing BASIC.
- Using MSACCESS is possible, to directly edit a network database, but the database structure is convoluted and confusing and easy to break. We do not recommend this method.