Versions Compared

Key

  • This line was added.
  • This line was removed.
  • Formatting was changed.

...

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.

...

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

    Toggle cloak

    Cloak
    • 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>'


  2. The value provided was not found in the database

    Toggle cloak

    Cloak
    • Error : Invalid Equipment '<EQUIPMENT_ID>'


  3. The System was unable to save the record

    Toggle cloak

    Cloak
    • Error : Failed to save Ports/Pins/Lens record; <errorMessage>
    • Error : Failed to create new Vlan <vlan>
    • Error : Failed to add Vlan <vlan> to Port

    If you experience any of these Errors, without another accompanying Message about what might have caused the Save Failure, please submit a Ticket to PCR.


...