When you need to create custom cables and add colors for cable wires, we used to change Microsoft Access “default_cat.mdb” file - _W0_CBLWIRES table. Once migrated to Microsoft SQL, following is the procedure of adding wire colors for cables, using Microsoft SQL Server Management Studio console.
1. To add new Cables - use AutoCAD Electrical Cable Component Edit and select lookup, or in the Catalog Browser, select W0 table and add new Cable.
2. To add cable wires colors: Open Microsoft SQL instance used for AutoCAD Electrical BOM Database using Microsoft SQL management Studio
3. Go to Tools > Options. In the tree on the left, select SQL Server Object Explorer. Set the option "Value for Edit Top Rows command" to 0. It'll now allow you to view and edit the entire table from the context menu.
4. Expand Default_cat – Database and select _W0_CBLWIRES
5. Right Mouse click on the Database table and select “Edit All Rows”
6. You are ready to customize Database _W0_CBLWIRES and add more cables colors. Every row is responsible for one cable wire color. Scroll to the bottom empty row and add Catalog, Manufacture, Color and Gauge.
Comments