...
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.
...
Conditionally Required when Import is attempting to INSERTcreate a new Cable.
Datatype is String.
Permitted values must be one of the following List Values of type CABLE_TYPE: Copper and Fiber.
...
Conditionally Required when Import is attempting to INSERTcreate a new Cable.
Datatype is String.
Permitted values must be one of the following 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 causes 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.
...
Pair Type
Conditionally Required when Import is attempting to INSERT create a new Pair/Strand.
Datatype is String.
...
Conditionally Required to INSERT a Pair/Strand.
Datatype is StringNumber.
Pair/Strand Description
Datatype is String.
...
Description
Datatype is String.
...
Datatype is String.
Signal Loss
Datatype is String.
Pair/Strand Length (ft)
Datatype is StringNumber.
Multiple Paths
Datatype is Boolean.
...
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.
...
Permitted values are from List Values of type LOCATION_TYPE: Site, Building, Floor, Room, Cube, Truck, Closet, Rack, Elevation, or Manhole.
...
Permitted values must be one of the following List Values of type PORT_SIDE: Front, Back, N/A, and Cross-Connect.
...
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.
...