Library data file (.csv) reference
The comma-separated value data file specifies the description of each harness object to import into the Cable and Harness Library. It uses a locale-specific list separator (typically a comma) for the column delimiter. Each row in the wire data file represents the data used to generate a new library wire. For cable data files, each row represents a cable wire with a Cable Name property that is a reference to the corresponding cable definition. Cable properties are imported to the cable definition with the provided Cable Name. The Conductor ID and Wire Name reference describe a cable wire in the cable definition, thus the cable wires must already exist in the library or wires must be imported before importing the cable definitions.
For export of library data, a data file with the same format is created, except that required properties need not be exported. The data exported is determined by the selected configuration file.
The order of the properties is defined by the list in the third row of the configuration file. Comment lines are specified with a preceding // and are ignored during import.
Required format for wires
For each wire, the following information is required:
Other guidelines include the following:
- The gauge property value must be in the predefined list of values for the import to recognize that property. If it is not, the gauge property does not import.
- If gauge or core size properties are imported, the values are compared against the outer diameter value. They must be less than or equal to the outer diameter value or the wire is not imported.
- If the system-defined delimiter (usually a comma) is contained in a string, the string must be enclosed in double quotes.
Required format for cables
For each cable, the following information is required:
Other guidelines include the following:
- All wires in the cable must exist in the Cable and Harness library. If a wire does not exist, it does not import.
- If an entry in the file uses the same Cable Name more than once, but the properties that are common to the cable such as Outer Diameter and Part Number have changed, you can override them on subsequent entries in the same file or a different file.
- If the system-defined delimiter (usually a comma) is contained in a string, enclose the string in double quotes.
- The library wire (Wire Name) for a previously defined Conductor ID within a specific Cable Name can be changed.
Required format for splices
For each splice, the following information is required:
Other guidelines include the following:
- The gauge property value must be in the predefined list of values for the import to recognize that property. If it is not, the gauge property does not import.
- The number of pins property value must be 2 for the import to recognize that property. If it is not, the gauge property does not import.
- If the system-defined delimiter (usually a comma) is contained in a string, enclose the string in double quotes.
Required format for ribbon cables
For each ribbon cable, the following information is required:
Other guidelines include the following:
- The width property value should be greater than or equal to Pitch*(Conductor+1), or less than or equal to pitch times the conductors property value plus 1 or the ribbon cable is not imported.
- The height must be less than or equal to the pitch or the ribbon cable is not imported.
- If importing gauge, the equivalent diameter for the gauge property value must be less than or equal to the height or the ribbon cable is not imported.
- If importing core size, the value must be less than or equal to the height or the ribbon cable is not imported.
- If the system-defined delimiter (usually a comma) is contained in a string, the string must be enclosed in double quotes.
Required format for terminal
For each terminal, the following information is required:
Other guidelines include the following:
- The gauge property value must be in the predefined list of values for the import to recognize that property. If it is not, the gauge property does not import.
- If the system-defined delimiter (usually a comma) is contained in a string, enclose the string in double quotes.
Required format for seal
For each seal, the following information is required:
Other guidelines include the following:
- The gauge property value must be in the predefined list of values for the import to recognize that property. If it is not, the gauge property does not import.
- If the system-defined delimiter (usually a comma) is contained in a string, enclose the string in double quotes.
Required format for plugs
For each plug, the following information is required:
Other guidelines include the following:
- If the system-defined delimiter (usually a comma) is contained in a string, enclose the string in double quotes.
Required format for labels
For each label, the following information is required:
Label Name | The unique name given to the library label. |
Height | The height of the label's printable area. |
Width | The width of the label's printable area. |
Other guidelines include the following:
- If the system-defined delimiter (usually a comma) is contained in a string, enclose the string in double quotes.
Required format for looms
For each loom, the following information is required:
Other guidelines include the following:
- If the system-defined delimiter (usually a comma) is contained in a string, enclose the string in double quotes.
Required format for Custom Virtual Parts
For each custom virtual part, the following information is required:
Other guidelines include the following:
- If the system-defined delimiter (usually a comma) is contained in a string, enclose the string in double quotes.
Sample data files (.csv)
Sample wire file
The following file is set to import the listed wires into the Cable and Harness Library with the required properties, and with the Part Number and Gauge properties.
//Wire Name,Appearance,Outer Diameter,Category,Part Number,Gauge
24AWG-BLK,black,0.024,Generic,24AWG_BLK,24
24AWG-BRN,brown,0.024,Generic,24AWG_BRN,24
24AWG-RED,red,0.024,Generic,24AWG_RED,24
24AWG-YEL,yellow,0.024,Generic,24AWG_YEL,24
24AWG-ORG,orange,0.024,Generic,24AWG_ORG,24
24AWG-GRN,green,0.024,Generic,24AWG_GRN,24
24AWG-BLU,blue,0.024,Generic,24AWG_BLU,24
See the corresponding configuration file if desired.
Sample cable file
The following file is set to import the listed cables into the Cable and Harness Library with the required properties.
//Cable Name,Category,Part Number,Outer Diameter,Conductor ID, Wire Name
Belden 4C 22AWG,Belden,9794,0.2,1,22GRN
Belden 4C 22AWG,Belden,9794,0.2,2,22RED
Belden 4C 22AWG,Belden,9794,0.2,3,22YEL
Belden 4C 22AWG,Belden,9794,0.2,4,22BLK
Sample splice file
The following file is set to import the listed splices into the Cable and Harness Library with the required properties.
//Library Name, Category,Part Number,Embedded Length, MyCustom
Splice_L,Size,SP_L_001,0.3in,1s,a,a,a
Splice_M,Size,SP_LM001,0.32in,12,a,a,a
Splice_LS,Size,SP_S_001,0.31in,13,a,a,a
Sample terminal file
The following file is set to import the listed terminals into the Cable and Harness Library with the required properties.
//Name,Category,Part Number,Min gauge, Max gauge, gauge type
Female_18-24AWG_Tin,Series_1000,Term-1001,24,18,Range
Female_16AWG_Tin,Series_1001,Term-1002,,16,Fixed
Male_18-24AWG_Tin,Series_1000,Term-1003,24,18,Range
Male_16AWG_Tin,Series_1001,Term-1004,,16,Fixed
Sample seal file
The following file is set to import the listed seals into the Cable and Harness Library with the required properties.
//Name,Category,Part Number,Min Outer Diameter,Max Outer Diameter,Diameter type
Seal_18-22AWG,Series_1001,SL-1002,0.5735,0.723,Range
Seal_16AWG,Series_1001,SL-1001,,0.8282,Fixed
Sample plug file
The following file is set to import the listed plugs into the Cable and Harness Library with the required properties.
//Name,Category,Part Number
Plug_Series_1000,Series_1000,PL-1001
Plug_Series_1001,Series_1001,PL-1002
Sample label file
The following file is set to import the listed labels into the Cable and Harness Library with the required properties.
//Name,Category,Part Number,Height,Width
Wire_Label,Clear,LB_1001,0.25,0.5
Wire_Label,White,LB-1002,0.25,0.5
Part_Label,White,LB-1003,0.5,1
Sample loom file
The following file is set to import the listed looms into the Cable and Harness Library with the required properties.
//Name,Category,Part Number,Appearance,Wall Thickness,Min Diameter, Max Diameter, Diameter Type
Sleeve_.25-1.25,Wire_Sleeve,WS-1000,Wire Sleeve,0.01,0.25,1.25,Range
Spiral_Wrap_.5-2,Spiral_Wrap,SW-1000,Spiral Wrap,0.01,0.5,2,Range
Corrugated_Tube_1.5,Corrugated_Tube,CT-1000,Corrugated Tube,0.01,,1.5,Fixed
Sample custom (user-define) virtual part file
The following file is set to import the listed custom virtual parts into the Cable and Harness Library with the required properties.
//Name,Category,Part Number
Clip01,Misc,CP-1000
Solder,Misc,SD-1001
Tye_Wrap,Misc,TW-1000
Sample raw ribbon cable file
The following file is set to import the listed custom raw ribbon cables into the Cable and Harness Library with the required properties.
//Name,Category,Part Number,Conductor One Appearance,Ribbon Body Appearance,Number of Conductors,Pitch,Height,Width,Gauge,Core Size
28AWG_10Con,Standard Gray,28AWG_10Con,Red,Gray,10,0.050,0.035,0.500,28,
28AWG_14Con,Standard Gray,28AWG_14Con,Red,Gray,14,0.050,0.035,0.710,28,
28AWG_16Con,Standard Gray,28AWG_10Con,Red,Gray,16,0.050,0.035,0.800,28,