2011

Table Of Contents
dialog box, placing them in the drawing one at a time.
After the connectors are created the Connector Selection
dialog box appears with the connector rows marked as 'x.'
Overview of the spreadsheet import file structure
You can select various file types (including XLS, CSV, MDB, and XML) to
import into AutoCAD Electrical. For the Insert Connector from List tool to
work, the spreadsheet and CSV import file must have the following structure.
The spreadsheet for import allows 27 columns per record. The first row in the
CSV or XLS file is treated as a header row, and is skipped in the import. All
columns must exist and the required fields (bolded) determine the connector
to be used in the Connector Selection dialog box.
NOTE The structure of this file does not apply to an XML import.
Column TypePurposeFieldPosition
TextCMP1: C = Connector/ S = SpliceTYPE11
TextInstallation Code of CMP1INST12
TextLocation Code of CMP1LOC13
TextComponent 1CMP14
TextConnected pin on CMP1PIN15
TextDescription of CMP1DESC16
TextCatalog number for CMP1CAT17
TextManufacturer of CAT1MFG18
TextAssembly code for CMP1ASM19
TextCMP2: C = Connector/S = SpliceTYPE210
TextInstallation Code of CMP2INST211
TextLocation Code of CMP2LOC212
1174 | Chapter 14 Point-to-Point Wiring Tools