2008

Table Of Contents
Map block values using a user-defined spreadsheet
NOTE A user-defined spreadsheet is required for this tool. Refer to the "Learn
about block/attribute mapping" file for help on creating the spreadsheet if you do
not already have one created.
1 On the Conversion toolbar, click the Block Replacement tool.
2 Select to run the block replacement for the entire project, the
active drawing, or a selected component on the active drawing.
3 Click OK.
4 On the Select Mapping Spreadsheet dialog box, select the
spreadsheet to be used for mapping the blocks and attributes.
5 Click Open.
If you select an existing spreadsheet the block replacement
automatically begins. If the spreadsheet file does not exist you
are presented with the option to create the spreadsheet
framework for the block/attribute mapping.
If a spreadsheet was not found, on the Spreadsheet Not Found
dialog box, click OK to run through the active project's drawing
set, and fill in a blank spreadsheet with extracted block names
and attributes. Only the first column of each of the sheets are
filled in. You can then add the block/attribute mapping inform-
ation and then rerun the command using the new spreadsheet.
Block replacement
Performs drawing-wide and project-wide block replacements using a
user-defined spreadsheet. This automatically maps the unconverted drawing's
non-AutoCAD Electrical block inserts and attributes to appropriate AutoCAD
Electrical-smart component symbols drawn from a symbol library.
Access:
On the Conversion toolbar, click the Block Replacement tool.
From the Projects menu, select Conversion Tools Block Replacement.
1154 | Chapter 17 Conversion Tools