In order to get a unique part number, serial number, or any other attribute for a CADWorx component based on the Main and Reduction size of that component, we need to utilize two unique tables in the CADWorx Catalog - they are Index Code Tables, and DB Code Tables. What follows is an example of building an index code table and a DB code table on top of the default CADWorx Catalog and Project file, in order for you to use unique part numbers for components that have different values for main and reduction sizes.
1. Open the CADWorx specification editor.
2. On the file menu on the top left, open the CADWorx default Catalog, which is Inch_Catalog.cat, located in C:\CADWorx 2015\Plant\Spec
note: Change CADWorx 2015 to 2014 or 2016, if required.
3. Right click IndexCode Tables on the left hand side, choose ADD
4. I will be adding this Index Code table for serial numbers, so I will name the table SERIAL.
6. In the large open area for the Index Code table of SERIAL, Right Click and choose Insert Row. Repeat this process for as many rows as you want to enter for this table. More rows = more different types of components in CADWorx that I want a new group of main / reduction size serial number lists for. So if I have two Weld-O-Lets, 4.00 x 0.25 and 4.00 x 0.50, then these both go under the same row, since they are both Weld-O-Lets. We'll divide by main / size later.
7. Drag each column so that you can view the description of all three columns - INDEXCODE, DESCRIPTION, and COMPTYPE.
8. Before you fill in the data, notice the COMPTYPE field. Click inside this cell in the first row, and you'll see a dropdown box. For each component that you want to have a custom description for Main or Reduction size, you'll have to select which component you want it to be under. I'm making custom serial numbers for various main and reduction sizes of Weld-O-Lets, so I'm going to select that now:
9. To fill the INDEXCODE table, pick a value for INDEXCODE that you will remember to use, that will be associated with that component. I'm randomly choosing 500 as the INDEXCODE value for Weld-O-Lets. The description and COMPTYPE will also be "Weld-O-Let".
9. Your INDEXCODE table is complete - now it's time to move on to the DBCode table. Right click DBCODE Tables on the left hand side, and choose add.
10. Notice that it's choosing which INDEXCODE table to reference when you create. I'm going to name this SERIAL as well.
11. Right click, choose multiple rows.
12. Notice that it asks which IndexCode row to reference when you bring in Main / Reduction sizes of multiple lines. I'm going to pick 500, which referenced my Weld-O-Lets, and pick the sizes I want to import. I'll start off with all the 4" nominal sizes, and all the reduction sizes. Click ok.
13. See all of the rows that were entered? They contain the description that you set in your IndexCode table, the INDEXCODE itself, as well as the main and reduction size, and finally, a field called PTN - which we will utilize for the PART NUMBER.
14. At this point you can copy / paste the cells into Excel, OpenOffice Calc, Google Sheets, or your favorite spreadsheet application, and enter the part number information. Then copy / paste the data back.
15. We are done editing the Catalog. Save your work. You have unsaved edits if you see a * symbol. Now, open up the Inch_Specs.prj file, located in C:\CADWorx 2016\Plant\Spec\Inch_Specs.prj
16. Once you are in the PRJ, Double click the 150 spec, and hit the dropdown for DBCode table name, and choose SERIAL.
17. In your list of components, drop down the component list for O-Lets, pick the WELD-O-LET in the list, go to IndexCode and choose "500", and click Apply.
18. Now you need to tell the Specification Editor to use the new descriptions it has access to. While you're still on the Weld-O-Let part, click on the three dots by Part Number:
19. Highlight all rows and hit the arrow going to the left, to remove the old part number description.
20. Drop down the list box in the upper left corner of that dialog that says component tables, and choose DBCode Tables.
21. Select the row that says PTN_DBCODE_TBL, hit the arrow going to the right, and then click OK. Descriptions for part numbers for weld-o-lets are now set. Don't forget to hit APPLY, and then save and close the specification editor.
22. Back in CADWorx, connect to the Inch_Specs.prj and open the Spec View palette to test it out. I dropped in a 4" x 1" Weld-O-Let, and a 4" x 0.50" Weld-O-Let. Here are the results. "Code" is my Part Number Format, where I inserted the data for PTN_DBCODE_TBL: