Versions Compared

Key

  • This line was added.
  • This line was removed.
  • Formatting was changed.
Table of Contents
outlinetrue
stylenone

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.

...

Datatype is String.

Cable Type

Conditionally Requiredwhen Import is attempting to create a new Cable.

...

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

Cable Owner

Conditionally Requiredwhen Import is attempting to create a new Cable.

...

Pair/Strand Fields

Pair Status

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

...

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

Pair Type

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

...

Pair/Strand Number

Conditionally Required to INSERT a Pair/Strand.

Datatype is Number.

...

From Equipment Location

Datatype is 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.

...

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. 

...

To Equipment Location

Datatype is 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.

...

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.

...

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

    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.


Child pages (Children Display)
styleh6
sorttitle