Document toolboxDocument toolbox

.Ports/Pins/Lens Imports v2018.1

Capability

The Ports/Pins/Lens Import will INSERT and UPDATE Ports/Pins/Lens on Equipment records.

Matches On

To find an existing Ports/Pins/Lens (PPL) record, the Import process attempts to match on the following:

  1. Equipment ID
  2. Port
  3. Side (side is an optional value)

Fields

Equipment ID

Required

Datatype is String.

Port/Pin/Len

Required

Datatype is String.

Pair Status

Required

Datatype is String.

Permitted values are from the PAIR_STATUS List Values : Left In, Spare, Assigned, Reserved, PDPC, Pending Disconnect, Pending Connect, Bad, and Unknown.

Any values added by a User to the PAIR_STATUS list can also be used.

Multiple Paths

Datatype is Boolean.

Default value = False [0].

Permitted Values are 1, Yes, and True and set the Directory to True [1].

All other values enter as False [0].

Port Side

Datatype is String.

Permitted values are from the PORT_SIDE List Values : Front, Back, Cross-Connect, and N/A.

Any values added by a User to the PORT_SIDE list can also be used.

Port Tx Rx

Datatype is String.

Permitted values are from the PORT_TX_RX List Values : TX, TX/RX, RX, and N/A.

Any values added by a User to the PORT_TX_RX list can also be used.

Port Type

Datatype is String.

Permitted values are from the PORT_TYPE List Values : BNC, FC, SC, LC, WW, RJ11, RJ45, and N/A.

Any values added by a User to the PORT_TYPE list can also be used.

Port Speed

Datatype is List.

Default value is blank.

Permitted values are from the PORT_SPEED List Values : 10 Mbps, 100 Mbps, 1 Gbps, Auto, Auto-10, and Auto-10-100.

VLAN

Datatype is String.

Default value is blank.

Attaches a VLAN to the port.

If the provided VLAN does not exist, it is created.

VLAN Description

Datatype is String.

Default value is blank.

Only used on new VLAN creation.

If the VLAN already exists, this is ignored. It will not update.

Flags

REPLACE_VLANS

Default value is False

  • True: when a new Vlan value is provided to a Port, all of the existing Vlans on that port will be removed.
  • False: when a new Vlan value is provided to a Port, all of the existing Vlans on that port will be appended.

Errors

The following errors display if the Ports/Pins/Lens INSERT or UPDATE fails:

  • Error : Invalid Equipment '<EQUIPMENT_ID>'
  • Error : Missing Equipment
  • Error : Port is blank or not mapped for Equipment '<EQUIPMENT_ID>'
  • Error : Port Status is blank or not mapped for Equipment '<EQUIPMENT_ID>'
  • Error : Failed to save Ports/Pins/Lens record; <errorMessage>
  • Error : Failed to create new Vlan <vlan>
  • Error : Failed to add Vlan <vlan> to Port

Notes

The Ports/Pins/Lens Import does not create the Equipment. Equipment MUST already exist to associate Ports/Pins/Lens to be associated with it.

UDF Associations

User Defined Fields on any given Import are all handled the same way with Conditional Logic. For more information about adding a UDF to the Import, see the User Defined Fields section of the Imports main page.

Help Desk Portal - Email: help@pcr.com - Phone: 616.259.9242