Insert connector from list

[JMARSHALL1249]

Could someone please let me know the format of the list for generating a connector from an .xls spreadsheet.

I have a complicated connector to generate, (a PLC ribbon connector) and think it would be easier to create the connector in excel, and import it straight into AE.

Thanks,

John.

[Anonymous]

Hi!

As far as I know list for generating a connector has .xml format usually.

But! There is an interesting article about creating connector list in Excel. Maybe it could help you.

http://ketiv.com/support/tech-tips/unleash-the-spreadsheet

[JMARSHALL1249]

Thankyou for this.

From this, and a bit of googling from the source file, I have come up with the following, which may be useful for anyone considering using connector generation from a list, in the future.

All connectors .xls files require 27 fields which are as follows:-

Position	Field	Purpose	Column Type
1	TYPE1	CMP1: C = Connector/ S = Splice	Text
2	INST1	Installation Code of CMP1	Text
3	LOC1	Location Code of CMP1	Text
4	CMP1	Component 1	Text
5	PIN1	Connected pin on CMP1	Text
6	DESC1	Description of CMP1	Text
7	CAT1	Catalog number for CMP1	Text
8	MFG1	Manufacturer of CAT1	Text
9	ASM1	Assembly code for CMP1	Text
10	TYPE2	CMP2: C = Connector/S = Splice	Text
11	INST2	Installation Code of CMP2	Text
12	LOC2	Location Code of CMP2	Text
13	CMP2	Component 2	Text
14	PIN2	Connected pin on CMP2	Text
15	DESC2	Description of CMP2	Text
16	CAT2	Catalog number of CMP2	Text
17	MFG2	Manufacturer of CAT2	Text
18	ASM2	Assembly code for CMP2	Text
19	WIRENO	Wire number (may be blank)	Text
20	WIRELAY	Wire layer name	Text
21	CBLINST	Cable Installation Code	Text
22	CBLLOC	Cable Location Code	Text
23	CBL	Cable tag name	Text
24	CBLWCLR	Cable wire (conductor) color	Text
25	CBLCAT	Cable catalog item	Text
26	CBLMFG	Cable catalog manufacturer	Text
27	CBLASM	Cable assembly code	Text

The example .xls file is attached for your info.

Thanks again.