Page Comparison

Capability

The Cable Path Import allows the User to INSERT a valid Cable Path with an Origination Equipment and a Destination Equipment record onto existing Cable. Cable Path is an association record that must have valid values before the User can create it for the Cable Name, Equipment, and Location fields. The Cable Path Import process CANNOT INSERT these records, they MUST already exist.

Fields

While the Service ID and the Location are optional, at least one of these must be provided to give the Path a valid location.

...

Conditionally Required if the provided Location Name exists with multiple Types.

Child Records

Path Leg

Individual Legs of the Path can be Imported onto the Cable Path.

...

Conditionally Required if the provided Leg Location Name exists with multiple Types.

Flags / Conditional Logic

IMPORT FLAGS

RECREATE_EXISTING_PATH

If the Location or Service you are creating the Path for already has a Path, the existing Path is compared to the new Path information. If the Path Legs are the same, nothing changes. If they are different, the default behavior produces an error. If this flag is set to true, then the existing Path will be removed, and a new Path will be created.

Legs Array

To use the above fields to provide Path Leg data, Users can only create a Path with one Path Leg. To use this optional Legs Array field, Users can create Paths with any number of legs.

...

The Legs Array must be assigned in the conditional logic and not mapped.

Example

Here is an example of how this is done with a two-leg Path, from a switch to a panel then a panel to a jack. The strings that are in double quotes are associative array indexes, and they must be written exactly as they appear in this example. The values after the '=>' operators can be literal strings. They can come from the input CSV file using the index syntax or come from Conditional Logic variables that were previously assigned. We recommend using the variables to make the logic slightly more readable and easier to maintain.

///// begin Conditional Logic /////

// Values for first leg
$cl_cable_1 = [5];
$cl_pair_1 = [6];
$cl_location_1 = [7];
$cl_backbone_1 = [8];
$cl_from_eqp_1 = [9];
$cl_from_port_1 = [10];
$cl_from_side_1 = [11];
$cl_to_eqp_1 = [12];
$cl_to_port_1 = [13];
$cl_to_side_1 = [14];

// Values for second leg
$cl_location_2 = [15];
$cl_cable_2 = [16];
$cl_pair_2 = [17];
$cl_backbone_2 = [18];
$cl_from_eqp_2 = [19];
$cl_from_port_2 = [20];
$cl_from_side_2 = [21];
$cl_to_eqp_2 = [22];
$cl_to_port_2 = [23];
$cl_to_side_2 = [24];

[PATHS.LEGS_ARRAY] = array(
    // first leg
    array(
        "pathLegLocationName" => $cl_location_1,
        "pathLegCableName" => $cl_cable_1,
        "pathLegPairStrand" => $cl_pair_1,
        "pathLegBackbone" => $cl_backbone_1,
        "FROM_EqpId" => $cl_from_eqp_1,
        "FROM_EqpPPLPort" => $cl_from_port_1,
        "FROM_EqpPPLSide" => $cl_from_side_1,
        "TO_EqpId" => $cl_to_eqp_1,
        "TO_EqpPPLPort" => $cl_to_port_1,
        "TO_EqpPPLSide" => $cl_to_side_1,
    ),
    // second leg
    array(
        "pathLegLocationName" => $cl_location_2,
        "pathLegCableName" => $cl_cable_2,
        "pathLegPairStrand" => $cl_pair_2,
        "pathLegBackbone" => $cl_backbone_2,
        "FROM_EqpId" => $cl_from_eqp_2,
        "FROM_EqpPPLPort" => $cl_from_port_2,
        "FROM_EqpPPLSide" => $cl_from_side_2,
        "TO_EqpId" => $cl_to_eqp_2,
        "TO_EqpPPLPort" => $cl_to_port_2,
        "TO_EqpPPLSide" => $cl_to_side_2,
    ),
);

///// end Conditional Logic /////

Errors

The following errors occur if the Cable Path Import INSERT or UPDATE fails:

...