Document toolboxDocument toolbox

(2022.1) Pair/Strand Imports

Capability

The Pair/Strand Import allows the User to INSERT or UPDATE the Pairs or Strands onto existing Cable. The Conditional Logic also allows the User to INSERT Cable while creating the Pair/Strand.  The Pair/Strand Import cannot UPDATE the values of an existing Cable record, it can only INSERT new records.  Use the Cable Imports to UPDATE Cable record values.

Fields

Cable Fields

Cable Name

Required

Datatype is String.

Cable Type

Conditionally Required when Import is attempting to create a new Cable.

Datatype is String.

Permitted values must be one of the following (2022.1) List Values of type CABLE_TYPE: Copper and Fiber.

User entered values to the CABLE_TYPE list may also be used.

Cable Owner

Conditionally Required when Import is attempting to create a new Cable.

Datatype is String.

Permitted values must be one of the following (2022.1) List Values of type CABLE_OWNER: Customer and Telephone Company.

User entered values to the CABLE_OWNER list may also be used.

Null or blank values cause an error.

Cable Description

Datatype is String.

Cable Length (ft)

Datatype is Number.

Cable Signal Loss

Datatype is String.

Pair/Strand Fields

Pair Status

Conditionally Required when Import is attempting to create a new Pair/Strand.

Datatype is String.

Permitted values must be one of the following List Values of type PAIR_STATUS: Left In, Spare, Assigned, Reserved, Unknown, Pending Disconnect, Pending Connect, PDPC, and Bad.

User entered values to the PAIR_STATUS List may also be used.

Pair Type

Conditionally Required when Import is attempting to create a new Pair/Strand.

Datatype is String.

Permitted values must be one of the following (2022.1) List Values of type PAIR_TYPE: Voice and Data.

User entered values to the PAIR_TYPE list may also be used.

Pair/Strand Number

Conditionally Required to INSERT a Pair/Strand.

Datatype is Number.

Pair/Strand Description

Datatype is String.

Pair/Strand Length (ft)

Datatype is Number.

Multiple Paths

Datatype is Boolean.

Default Value is False.

Permitted values are True, 1, or Yes and set the flag to True [1].

All other values are considered False [0].

This flag indicates that the Pair/Strand can be on multiple Cable Paths.

If the Pair/Strand Status is not Spare before the assignment, it is not allowed on a Path unless the Multiple Paths flag is True [1].

From Equipment ID

Datatype is String.

Look up is by Equipment ID.

From Equipment Location

Datatype is Hierarchical String.

The From Equipment Location is only used to find the correct From Equipment. It is only needed if there are more than one From Equipment with the same Equipment ID in different Locations.

From Equipment Location Type

Datatype is String.

Permitted values are from List Values of type LOCATION_TYPE: Site, Building, Floor, Room, Cube, Truck, Closet, Rack, Elevation, or Manhole.

The From Location Type is only used to find the correct From Location. It is only needed if there are more than one From Location with the same Name with different Location Types.

User entered values to the LOCATION_TYPE list may also be used.

From Port/Pin/Len

Datatype is String. 

From Port/Pin/Len Side

Datatype is String.

Value is not saved but is used for the look up of the Port.

Permitted values must be one of the following List Values of type PORT_SIDE: Front, Back, N/A, and Cross-Connect.

User entered values to the PAIR_TYPE list may also be used.

To Equipment ID

Datatype is String.

Look up is by Equipment ID.

To Equipment Location

Datatype is Hierarchical String.

The To Equipment Location is only used to find the correct To Equipment. It is only needed if there are more than one To Equipment with the same Equipment ID in different Locations.

To Equipment Location Type

Datatype is String.

Permitted values are from List Values of type LOCATION_TYPE: Site, Building, Floor, Room, Cube, Truck, Closet, Rack, Elevation, or Manhole.

The To Location Type is only used to find the correct To Location. It is only needed if there are more than one To Location with the same Name with different Location Types.

User entered values to the LOCATION_TYPE list may also be used.

To Port Pin Len

Datatype is String.

To Port Pin Len Side

Datatype is String.

Value is not saved but is used for the look up of the Port.

Permitted values must be one of the following (2022.1) List Values of type PORT_SIDE: Front, Back, N/A, and Cross-Connect.

User entered values to the PAIR_TYPE list may also be used.

Multiples Status

Datatype is String.

Default Value is Assigned.

If a Pair/Strand has multiple To Equipment assignments, this keeps track of which Pair/Strand is Assigned.

Only one Pair/Strand can be Assigned at a time.

If the new To Equipment is set to Assigned, the previously Assigned record is set to Reserved.

Permitted values are Assigned, Reserved, or Spare.

Flags / Conditional Logic

CREATE_CABLE:

Default Value is False.

  • If False, the Cable Name must already exist.
  • If True, when the Cable Name does not already exist, it will INSERT.

APPEND_TO_EQUIPMENT:

Default Value is False for the first occurrence of each Cable and Pair/Strand number in an import file. Default Value is True for each following occurrence.

  • If True, then any To Equipment will be added to the To Equipment list.
  • If False, then the list will be cleared before adding the current item.

CLEAR_TO_EQUIPMENT:

Default Value is False.

  • If True, the To Equipment list will be cleared, even if no replacement item is provided.

Errors

When an Import Line fails, it is usually because the Line falls into one of the following categories:

  1. A blank value was provided, for a field with a required value

  2. The value provided was not found in the database

  3. The System was unable to save the record