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.

...

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.

Cable Description

Datatype is String.

Length (ft)

Datatype is String.

Signal Loss

Datatype is String.

Pair/Strand Length (ft)

Datatype is StringNumber.

Other Fields

Multiple Paths

Datatype is Boolean.

...