The comma separated data file (.csv) is one of two files required when importing a wire list data set. A wire list data set can include both cables and wires. The data file contains the actual wire and cable wire data to import into the active harness assembly to establish connectivity.
Preceding a line with // denotes a comment line that is ignored during import. Typically, the first line of the data file is an optional comment line listing the columns in the data fields. This line corresponds with the Header1 row in the configuration file, preceded with // to denote a comment line.
The format of the input text file is described by the configuration file. The log file lists details on added and modified properties, or validation problems.
Required format
All values in the data file must correspond to the data types specified in the configuration file. Units on values, if specified, must be appropriate for the corresponding data type.
For each wire and cable included in the file, the following information must be included:
|
Wire ID |
A unique identifier for the wire. The Wire ID is optional for cable wires. If the Wire ID is not listed in the file, it is automatically generated using the Cable ID and Conductor ID. |
|
Note: If the Wire ID is specified again in the same .csv file or on a subsequent import, you can add or change properties but cannot change connectivity.
|
|
|
Cable ID |
(Cables only.) A unique identifier for the cable. All wires with the same Cable ID are imported onto the same cable. |
|
Note: If the Conductor ID is specified again in the same .csv file or on a subsequent import, you can add or change properties but cannot change connectivity.
|
|
|
Library Name |
The wire or cable name in the Cable and Harness Library. |
|
Conductor ID |
(Cables only.) A unique identifier for the cable wire, which maps to an existing Conductor ID in a library cable. |
|
RefDes1 |
A unique identifier for the first connector or splice. |
|
Pin1 |
A unique pin name for the first connector or splice. |
|
RefDes2 |
A unique identifier for the second connector or splice. |
|
Pin2 |
A unique pin name for the second connector or splice. |
Additional wire occurrence properties can be imported on a wire-by-wire basis in addition to the required input parameters. The corresponding data type and unit for each custom property added must be listed in the associated configuration file.
Custom properties are imported for cable wires but not for cable occurrences. To add custom properties to a cable occurrence, edit the cable and add the property manually.
Sample data (.csv) file
The following data .csv file adds six wires to the harness assembly. The first wire is added between pin 2 on connector U4 and pin 11 on connector J12. A wire ID property value of 1004 is added to the wire, and it is placed in the Data category. It also has a Strip Length of 0.2.
Wire ID 1036 and 1017 have a comma representing a blank for the Strip Length. Both the class and strip length are blank for Wire ID 1034.
//Wire ID,Wire Name,RefDes1,Pin1,RefDes2,Pin2,class,Strip Length
1004,16AWG-BLK,U4,2,J2,11,Data,0.2
1045,24AWG-RED,U4,3,J3,12,Power,0.1
1042,18AWG-ORG,TB1,15,J6,W,Data,0.25
1036,18AWG-BLK,J6,B,CB1,LN1,Ground,
1017,20AWG-WHT,CB2,LN5,J4,G,Neutral,
1034,22AWG-GRN,CB2,LD5,J2,12,,
The following data .csv file adds two cables with four cable wires each and three discrete wires, one of which is connected to a splice. It requires a .cfg file that used the new file format that includes cables.
//Wire ID,Cable ID,Library Name,Conductor ID,REFDES 1,Pin 1,REFDES 2,Pin 2
1001,CA1,Belden 4C 22AWG,1,J1,2,J5,6
1002,CA1,Belden 4C 22AWG,2,J1,3,J5,7
1003,CA1,Belden 4C 22AWG,3,J1,11,J5,8
1004,CA1,Belden 4C 22AWG,4,J1,12,J5,9
1005,,18 AWG BLU,,SP1,2,J6,1
1005,,18 AWG BLU,,J3,2,J6,1
1006,,18 AWG BLK,,J3,3,J6,3
1007,,18 AWG RED,,J3,4,J6,2
1008,CA2,Belden 4C 22AWG,1,J2,1,J8,3
1009,CA2,Belden 4C 22AWG,2,J2,2,J8,4
1010,CA2,Belden 4C 22AWG,3,J2,3,J8,5
1011,CA2,Belden 4C 22AWG,4,J2,4,J8,6