Share

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:

Wire Name

The unique name given to the library wire.

Appearance

An appearance name that determines the appearance in which the wire is drawn in the graphics window. The appearance must match one of the predefined appearances listed in the harness assembly template. Other appearances can be created and added to the template. If the appearance does not match a predefined appearance, the wire is not imported.

Outer Diameter

The wire's outer diameter.

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:

Cable Name

The unique name given to the library cable.

Outer Diameter

The cable's outer diameter. If this value is blank, then the value is calculated from cable wires.

Wire Name

The name of the library wire associated with the cable wire. The library wire must exist or the cable wire is not imported.

Conductor ID

The unique identifier for the cable wire within the cable.

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:

Splice Name

The unique name given to the library splice.

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:

Raw Ribbon Cable Name

The unique name given to the library raw ribbon cable.

Number of Conductors

The number of conductors that are included in the selected raw ribbon cable.

Pitch

The distance increment of the conductors in the selected raw ribbon cable.

Height

The height or thickness for the selected raw ribbon cable.

Width

The width for the selected raw ribbon cable.

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:

Terminal Name

The unique name given to the library cable.

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:

Seal Name

The unique name given to the library seal.

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:

Plug Name

The unique name given to the library plug.

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:

Loom Name

The unique name given to the library loom.

Appearance

An appearance name that determines the appearance in which to draw the segment to which the loom is assigned. It is typically the appearance of the segment or the loom. The appearance must match one of the predefined appearances listed in the harness assembly template. Other appearances can be created and added to the template. If the appearance does not match a predefined appearance, the loom is not imported.

Thickness

The loom's thickness.

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:

Virtual Part Name

The unique name given to the custom library virtual part.

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

Note: For Loom appearances, make sure the style in your .cfg file exists in the harness assembly.

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,

Was this information helpful?