About the Electrical Catalog Database Structure
Understand the structure of the catalog database used by the Electrical Catalog Browser.
Important: The fields must remain in this order in the database records.
Catalog Tables
Field Name | Width | Description |
|---|
CATALOG | 60 | Catalog number. |
MANUFACTURER | 24 | Manufacturer code; abbreviations are allowed. |
DESCRIPTION | 150 | Generic description. |
TYPE | 100 | Generic type (field name varies based on table name). |
RATING | 100 | Generic rating (field name varies based on table name). |
MISCELLANEOUS1 | 100 | First miscellaneous text field (header cell is based on the component family). |
MISCELLANEOUS2 | 100 | Second miscellaneous text field (header cell is based on the component family). |
ASSEMBLYCODE | 60 | Code to flag that this item has subassembly items. Spaces are allowed. Use a semi-colon, ";", to separate multiple codes. To define a quantity for a subassembly item, prefix the code with the quantity followed by a comma, ",". For example, an ASSEMBLYCODE value of: 2,NOBLOCK;3,NCBLOCK, would add the following: - 2 of the subassembly item with the code name "NOBLOCK" in the ASSEMBLYLIST field
- 3 of the subassembly item with the code name of "NCBLOCK" in the ASSEMBLYLIST field
|
ASSEMBLYLIST | 24 | Code to flag as a subassembly item of a main item. The value must match the ASSEMBLYCODE value of the main catalog item exactly. |
ASSEMBLYQUANTITY | 8 | Subassembly quantity (blank = quantity of 1). |
USER1 | 100 | Field #1 for other information. |
USER2 | 100 | Field #2 for other information. |
USER3 | 100 | Field #3 for other information. |
TEXTVALUES | 255 | Optional user-defined RATING/miscellaneous attribute values. |
WEBLINK | 255 | Associate .pdf files or Web URL to component. |
WDBLKNAM | 60 | AutoCAD Electrical block name minus the first character of the block name since the first character is the orientation of block (H= Horizontal, V= Vertical). |
SYMBOL2D | 255 | Schematic symbols associated to the catalog value that can be inserted from the Catalog Browser. Multiple symbol names are separated by a comma. |
SYMBOL3D | 255 | 3D parts associated to the catalog value that can be inserted from the Catalog Browser in Inventor using the AutoCAD Electrical add-in. Multiple part names are separated by a comma. |
Note: Only the CATALOG, MANUFACTURER, DESCRIPTION, and ASSEMBLYCODE fields are assigned as iProperties when a part is inserted in Inventor through the Electrical Catalog Browser.