2011

Table Of Contents
The TEXTVALS value can be used to filter your pick list based on the
component's FAMILY code value. For this to work, the text substring
"FAMILY=<family code>" needs to be somewhere in each line of text to be
displayed. The TEXTVALS field can also be used to auto-fill attribute values
on insertion. For example, if the line includes the substring
"MFG=AB;CAT=1492;LOC=PNL1" then the MFG, CAT, and LOC edit boxes
will auto-fill with the values "AB", "1492", and "PNL1" respectively.
The schematic lookup file
The schematic lookup file maps catalog information from a panel component
or equipment list to a specific schematic component library symbol. AutoCAD
Electrical supplies a starter lookup file called schematic_lookup.mdb in Access
".mdb" file format. Within the database file are tables based on Manufacturer
codes. When you select a panel footprint from an AutoCAD Electrical extract
file or select a panel footprint from a catalog lookup file, it carries a
manufacturer code, on the MFG attribute. AutoCAD Electrical takes this MFG
code, goes to the matching table name in the schematic lookup database and
tries to find a match on the manufacturer, catalog number and assembly code
(if non-blank). If a match is found, AutoCAD Electrical retrieves the component
block path/name (or AutoCAD Electrical command list) from the matching
record and inserts the schematic component representation into the drawing.
You must expand and modify these tables to meet your specific schematic
needs. You can do this using tools provided with AutoCAD Electrical or
through the use of a database program that can read/write the Access file
format. You may use the MDB file (schematic_lookup.mdb) or a project-specific
schematic lookup file, called <project>_schematic_lookup.mdb. If the
project-specific .mdb file is used, it needs to be in the same subdirectory as
the <project>.wdp file.
Lookup file naming convention: AutoCAD Electrical takes the target footprint's
MFG code and looks for a table, in your Access schematic_lookup.mdb file
with that name. For example, if the footprint's MFG value is SQD, then
AutoCAD Electrical searches for a schematic lookup table called SQD;
manufacturer code of AB yields the table name AB.
Lookup file format
All fields contain characters except for RECNUM, which is automatically
numbered in the list for you. Fields may be blank and may use wildcards, with
780 | Chapter 10 Component Tools