Skip to content

adding port connector connection details after cable import

Jump to bottom
craigmcchesney edited this page Feb 2, 2022 · 1 revision

After importing cable catalog items (cable types) and cable design items (cables), you may wish to add add cable connection details. There are "follow on" CDB import spreadsheet formats for this purpose.

cable connection details

Once cable design items have been created by importing cables, details about their connections can be added from the CDB cable design import format for cable design connections. It contains columns for:

  • existing item id - left blank for new connections, id of existing connection (item_connector) when editing an existing connection
  • delete existing item - left blank for new connections, "TRUE" when deleting existing connections
  • cable design item reference (name or id)
  • cable end specification (1 or 2)
  • primary connection indicator (true or false)
  • machine item reference for device (name or id)
  • name of port on device (optional) - assumes port with specified name exists for machine item
  • name of connector on cable (optional) - assumes connector with specified name exists for cable

device port details

To include device ports in cable connection details, ports must be defined for the device machine item (by adding them to its catalog item). The CDB catalog import format for creating ports is used for this purpose. It includes columns for:

  • existing item id - left blank for new ports, id of existing item_connector when editing an existing port
  • delete existing item - left blank for new ports, "TRUE" when deleting existing ports
  • catalog item reference - id or name of catalog item for which port will be added
  • port name - name of port to be added
  • description - description of port
  • connector type - port's connector type (name must be a valid CDB connector type)

cable connector details

To include cable connectors in cable connection details, connectors must be defined for the cable design item (by adding them to it cable catalog item). This is analogous to adding ports to catalog items. The CDB cable catalog import format for creating connectors is used for this purpose. It includes columns for:

  • existing item id - left blank for new connectors, id of existing item_connector when editing an existing connector
  • delete existing item - left blank for new connectors, "TRUE" when deleting existing connectors
  • cable catalog item reference - id or name of cable catalog item for which connector will be added
  • connector name - name of connector to be added
  • description - description of connector
  • connector type - connector's connector type (name must be a valid CDB connector type)

connector type details

To use connector types in defining catalog item ports or cable catalog item connectors, the corresponding connector type name must be defined in CDB. There is a CDB import spreadsheet format available from the import button on the administrative "Connector Types" list view for creating connector types. Columns include:

  • existing item id - left blank for new connector types, id of existing connector_type when editing an existing connector type
  • delete existing item - left blank for new connector types, "TRUE" when deleting existing connector types
  • name - connector type name (includes gender where applicable)
  • description - description of connector type
Clone this wiki locally