(2022.1) Pair/Strand Imports
- Brian Dixon
- Frank Zerillo (Deactivated)
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:
A blank value was provided, for a field with a required value
The value provided was not found in the database
The System was unable to save the record