{"type":"doc","content":[{"type":"extension","attrs":{"layout":"default","extensionType":"com.atlassian.confluence.macro.core","extensionKey":"toc","parameters":{"macroParams":{"outline":{"value":"true"},"style":{"value":"none"}},"macroMetadata":{"macroId":{"value":"5f3e6e99-947c-4843-9edd-0ee73af00285"},"schemaVersion":{"value":"1"},"title":"Table of Contents"}},"localId":"e888cacc-e773-49eb-b385-fc643d0f4a55"}},{"type":"heading","attrs":{"level":2},"content":[{"text":"Capability","type":"text"}]},{"type":"paragraph","content":[{"text":"This Import allows the User to INSERT new records or UPDATE Services, Equipment, Ports/Pins/Lens, and Cable Paths all in one pass.","type":"text"}]},{"type":"paragraph","content":[{"text":"The Import will notice if any ","type":"text"},{"text":"'Location'","type":"text","marks":[{"type":"strong"}]},{"text":" already exists in a ","type":"text"},{"text":"'Hidden'","type":"text","marks":[{"type":"strong"}]},{"text":" state. The process will locate that hidden Location record and update it to ","type":"text"},{"text":"'Not Hidden'","type":"text","marks":[{"type":"strong"}]},{"text":". It will also blank out any old information on the Location from before it was hidden, so it will seem like a fresh new record. The remainder if the process will treat the record like a new record, and fill in values as normal. The ","type":"text"},{"text":"'Imported Records'","type":"text","marks":[{"type":"strong"}]},{"text":" Grid will display a line showing a new Location record added.","type":"text"}]},{"type":"paragraph","content":[{"text":"A consequence of this is that if there were any old ","type":"text"},{"text":"'Service Orders'","type":"text","marks":[{"type":"strong"}]},{"text":" that referenced this Location, then any details of the location that were displayed on the Service Order will now show the new Location values instead of the original values. This problem will eventually be solved by \"","type":"text"},{"text":"Service Order Archiving","type":"text","marks":[{"type":"em"}]},{"text":"\", when the ability to hide Locations ","type":"text"},{"text":"will be removed","type":"text","marks":[{"type":"textColor","attrs":{"color":"#ff6600"}}]},{"text":".","type":"text"}]},{"type":"heading","attrs":{"level":3},"content":[{"text":"Matches On","type":"text"}]},{"type":"bodiedExtension","attrs":{"layout":"default","extensionType":"com.atlassian.confluence.macro.core","extensionKey":"excerpt","parameters":{"macroParams":{"atlassian-macro-output-type":{"value":"INLINE"}},"macroMetadata":{"macroId":{"value":"b5689265-2f44-44dd-a3de-1fbcda3a49d6"},"schemaVersion":{"value":"1"},"title":"Excerpt"}},"localId":"380a3f9d-a4fd-411c-ba22-3c5714f3258a"},"content":[{"type":"paragraph","content":[{"text":"The Full Path import can create records for ","type":"text"},{"text":"'Path'","type":"text","marks":[{"type":"strong"},{"type":"link","attrs":{"href":"/wiki/spaces/pcr360wiki/pages/17237985"}}]},{"text":", ","type":"text"},{"text":"'Path Legs'","type":"text","marks":[{"type":"strong"},{"type":"link","attrs":{"href":"/wiki/spaces/pcr360wiki/pages/17238094"}}]},{"text":", ","type":"text"},{"text":"'Locations'","type":"text","marks":[{"type":"strong"},{"type":"link","attrs":{"href":"/wiki/spaces/pcr360wiki/pages/17238321"}}]},{"text":", ","type":"text"},{"text":"'Equipment'","type":"text","marks":[{"type":"strong"},{"type":"link","attrs":{"href":"/wiki/spaces/pcr360wiki/pages/17238958"}}]},{"text":" (from and to, each leg), ","type":"text"},{"text":"'Services'","type":"text","marks":[{"type":"strong"},{"type":"link","attrs":{"href":"/wiki/spaces/pcr360wiki/pages/17241229"}}]},{"text":", ","type":"text"},{"text":"'Ports/Pins/Lens'","type":"text","marks":[{"type":"strong"},{"type":"link","attrs":{"href":"/wiki/spaces/pcr360wiki/pages/17238036"}}]},{"text":" (from and to, each leg) and ","type":"text"},{"text":"'Vlans'","type":"text","marks":[{"type":"strong"},{"type":"link","attrs":{"href":"/wiki/spaces/pcr360wiki/pages/17238111"}}]},{"text":". Each of these needs to check to see if the record it is trying to save already exists.","type":"text"}]}]},{"type":"paragraph","content":[{"text":" Here is a list of the fields used to match existing records.","type":"text"}]},{"type":"bulletList","content":[{"type":"listItem","content":[{"type":"paragraph","content":[{"text":"For Paths:","type":"text","marks":[{"type":"strong"}]},{"text":" Service ID, and/or Location Name and Location Type.","type":"text"}]}]},{"type":"listItem","content":[{"type":"paragraph","content":[{"text":"For Services:","type":"text","marks":[{"type":"strong"}]},{"text":" Service ID or Services RECID.","type":"text"}]}]},{"type":"listItem","content":[{"type":"paragraph","content":[{"text":"For Location of the Path:","type":"text","marks":[{"type":"strong"}]},{"text":" Location Name and Location Type, or Location of the Path Legs.","type":"text"}]}]},{"type":"listItem","content":[{"type":"paragraph","content":[{"text":"Location of the Path Leg From Equipment.","type":"text"}]}]},{"type":"listItem","content":[{"type":"paragraph","content":[{"text":"Location of the Path Leg To Equipment.","type":"text"}]}]},{"type":"listItem","content":[{"type":"paragraph","content":[{"text":"Path Leg From Equipment.","type":"text"}]}]},{"type":"listItem","content":[{"type":"paragraph","content":[{"text":"Path Leg To Equipment.","type":"text"}]}]},{"type":"listItem","content":[{"type":"paragraph","content":[{"text":"Path Leg From Equipment Ports/Pins/Len.","type":"text"}]}]},{"type":"listItem","content":[{"type":"paragraph","content":[{"text":"Path Leg To Equipment Ports/Pins/Len.","type":"text"}]}]},{"type":"listItem","content":[{"type":"paragraph","content":[{"text":"Vlan","type":"text"}]}]}]},{"type":"heading","attrs":{"level":2},"content":[{"text":"Fields","type":"text"}]},{"type":"heading","attrs":{"level":4},"content":[{"text":"Location Name","type":"text"},{"text":" ","type":"text","marks":[{"type":"strong"}]}]},{"type":"paragraph","marks":[{"type":"indentation","attrs":{"level":1}}],"content":[{"text":"Required ","type":"text","marks":[{"type":"textColor","attrs":{"color":"#ff0000"}},{"type":"strong"}]}]},{"type":"paragraph","marks":[{"type":"indentation","attrs":{"level":1}}],"content":[{"text":"Datatype is ","type":"text"},{"text":"Hierarchical String","type":"text","marks":[{"type":"textColor","attrs":{"color":"#172b4d"}},{"type":"link","attrs":{"href":"https://pcr360.atlassian.net/wiki/x/wpEQAQ"}}]},{"text":".","type":"text"}]},{"type":"paragraph","marks":[{"type":"indentation","attrs":{"level":1}}],"content":[{"text":"If the Location does not exist, the Import will INSERT a new record.","type":"text"}]},{"type":"heading","attrs":{"level":4},"content":[{"text":"Service ID","type":"text"}]},{"type":"paragraph","marks":[{"type":"indentation","attrs":{"level":1}}],"content":[{"text":"Required ","type":"text","marks":[{"type":"textColor","attrs":{"color":"#ff0000"}},{"type":"strong"}]}]},{"type":"paragraph","marks":[{"type":"indentation","attrs":{"level":1}}],"content":[{"text":"Datatype is String.","type":"text"}]},{"type":"paragraph","marks":[{"type":"indentation","attrs":{"level":1}}],"content":[{"text":"If the Service ID does not exist, the Import will INSERT a new record.","type":"text"}]},{"type":"heading","attrs":{"level":4},"content":[{"text":"Location Type","type":"text"},{"text":" ","type":"text","marks":[{"type":"strong"}]}]},{"type":"paragraph","marks":[{"type":"indentation","attrs":{"level":1}}],"content":[{"text":"Conditionally ","type":"text"},{"text":"Required","type":"text","marks":[{"type":"textColor","attrs":{"color":"#ff0000"}},{"type":"em"}]},{"text":" ","type":"text","marks":[{"type":"textColor","attrs":{"color":"#ff0000"}}]},{"text":"when the Import is attempting to INSERT the Location.","type":"text"}]},{"type":"paragraph","marks":[{"type":"indentation","attrs":{"level":1}}],"content":[{"text":"Datatype is ","type":"text"},{"text":"Hierarchical String","type":"text","marks":[{"type":"textColor","attrs":{"color":"#172b4d"}},{"type":"link","attrs":{"href":"https://pcr360.atlassian.net/wiki/x/wpEQAQ"}}]},{"text":".","type":"text"}]},{"type":"paragraph","marks":[{"type":"indentation","attrs":{"level":1}}],"content":[{"text":"Permitted values are from ","type":"text"},{"text":"List Values","type":"text","marks":[{"type":"link","attrs":{"href":"/wiki/spaces/pcr360wiki/pages/17237724"}}]},{"text":" of type LOCATION_TYPE: Site, Building, Floor, Room, Cube, Truck, Closet, Rack, Elevation, or Manhole.","type":"text"}]},{"type":"paragraph","marks":[{"type":"indentation","attrs":{"level":1}}],"content":[{"text":"User entered values to the LOCATION_TYPE list may also be used.","type":"text"}]},{"type":"heading","attrs":{"level":4},"content":[{"text":"Service Catalog","type":"text"},{"text":" ","type":"text","marks":[{"type":"strong"}]}]},{"type":"paragraph","marks":[{"type":"indentation","attrs":{"level":1}}],"content":[{"text":"Datatype is ","type":"text"},{"text":"Hierarchical String","type":"text","marks":[{"type":"textColor","attrs":{"color":"#172b4d"}},{"type":"link","attrs":{"href":"https://pcr360.atlassian.net/wiki/x/wpEQAQ"}}]},{"text":".","type":"text"}]},{"type":"paragraph","marks":[{"type":"indentation","attrs":{"level":1}}],"content":[{"text":"Conditionally ","type":"text"},{"text":"Required","type":"text","marks":[{"type":"textColor","attrs":{"color":"#ff0000"}},{"type":"em"}]},{"text":" if the Import is attempting to INSERT.","type":"text"}]},{"type":"paragraph","marks":[{"type":"indentation","attrs":{"level":1}}],"content":[{"text":"Ignored if Service already exists.","type":"text"}]},{"type":"heading","attrs":{"level":4},"content":[{"text":"Service Status","type":"text"},{"text":" ","type":"text","marks":[{"type":"strong"}]}]},{"type":"paragraph","marks":[{"type":"indentation","attrs":{"level":1}}],"content":[{"text":"Datatype is String.","type":"text"}]},{"type":"paragraph","marks":[{"type":"indentation","attrs":{"level":1}}],"content":[{"text":"Conditionally ","type":"text"},{"text":"Required","type":"text","marks":[{"type":"textColor","attrs":{"color":"#ff0000"}},{"type":"em"}]},{"text":" if the Import is attempting to INSERT.","type":"text"}]},{"type":"heading","attrs":{"level":4},"content":[{"text":"Service Owner","type":"text"},{"text":" ","type":"text","marks":[{"type":"strong"}]}]},{"type":"paragraph","marks":[{"type":"indentation","attrs":{"level":1}}],"content":[{"text":"Datatype is ","type":"text"},{"text":"Hierarchical String","type":"text","marks":[{"type":"textColor","attrs":{"color":"#172b4d"}},{"type":"link","attrs":{"href":"https://pcr360.atlassian.net/wiki/x/wpEQAQ"}}]},{"text":".","type":"text"}]},{"type":"paragraph","marks":[{"type":"indentation","attrs":{"level":1}}],"content":[{"text":"Conditionally ","type":"text"},{"text":"Required","type":"text","marks":[{"type":"textColor","attrs":{"color":"#ff0000"}},{"type":"em"}]},{"text":" if the Import is attempting to INSERT.","type":"text"}]},{"type":"paragraph","marks":[{"type":"indentation","attrs":{"level":1}}],"content":[{"text":"The Import expects this to be a Department Hierarchy.","type":"text"}]},{"type":"paragraph","marks":[{"type":"indentation","attrs":{"level":1}}],"content":[{"text":"Match requires the Department Hierarchy in the following format: 'Code - Description'.","type":"text"}]},{"type":"heading","attrs":{"level":4},"content":[{"text":"Service Reference","type":"text"},{"text":" ","type":"text","marks":[{"type":"strong"}]}]},{"type":"paragraph","marks":[{"type":"indentation","attrs":{"level":1}}],"content":[{"text":"Datatype is String.","type":"text"}]},{"type":"heading","attrs":{"level":4},"content":[{"text":"Service GLA","type":"text"},{"text":" ","type":"text","marks":[{"type":"strong"}]}]},{"type":"paragraph","marks":[{"type":"indentation","attrs":{"level":1}}],"content":[{"text":"Datatype is ","type":"text"},{"text":"Hierarchical String","type":"text","marks":[{"type":"textColor","attrs":{"color":"#172b4d"}},{"type":"link","attrs":{"href":"https://pcr360.atlassian.net/wiki/x/wpEQAQ"}}]},{"text":".","type":"text"}]},{"type":"paragraph","marks":[{"type":"indentation","attrs":{"level":1}}],"content":[{"text":"The Default value is blank.","type":"text"}]},{"type":"heading","attrs":{"level":4},"content":[{"text":"Location Building ID","type":"text"},{"text":" ","type":"text","marks":[{"type":"strong"}]}]},{"type":"paragraph","marks":[{"type":"indentation","attrs":{"level":1}}],"content":[{"text":"Datatype is String.","type":"text"}]},{"type":"paragraph","marks":[{"type":"indentation","attrs":{"level":1}}],"content":[{"text":"Default value is blank.","type":"text"}]},{"type":"paragraph","marks":[{"type":"indentation","attrs":{"level":1}}],"content":[{"text":"Only used to provide a building number if a new building location is being created by this Import.","type":"text"}]},{"type":"heading","attrs":{"level":4},"content":[{"text":"Service RecID","type":"text"},{"text":" ","type":"text","marks":[{"type":"strong"}]}]},{"type":"paragraph","marks":[{"type":"indentation","attrs":{"level":1}}],"content":[{"text":"Datatype is Number.","type":"text"}]},{"type":"paragraph","marks":[{"type":"indentation","attrs":{"level":1}}],"content":[{"text":"Default value is blank.","type":"text"}]},{"type":"paragraph","marks":[{"type":"indentation","attrs":{"level":1}}],"content":[{"text":"Used to specify an existing Service that is getting the path if the Service has a blank Service ID.","type":"text"}]},{"type":"paragraph","marks":[{"type":"indentation","attrs":{"level":2}}],"content":[{"text":"Note","type":"text","marks":[{"type":"strong"}]},{"text":": ","type":"text"},{"text":"If the Service already exists, the Service Status, Service Owner, and Service Reference can be updated by the provided values.","type":"text","marks":[{"type":"em"}]}]},{"type":"heading","attrs":{"level":2},"content":[{"text":"Flags / Conditional Logic","type":"text"}]},{"type":"paragraph","content":[{"text":"Import Flags","type":"text","marks":[{"type":"strong"}]}]},{"type":"paragraph","content":[{"text":"These optional flags can be set in the Conditional Logic.","type":"text"}]},{"type":"paragraph","content":[{"text":"Example - [FLAGS.ADD_EQUIPMENT] = True","type":"text"}]},{"type":"heading","attrs":{"level":3},"content":[{"text":"ADD_EQUIPMENT:","type":"text"}]},{"type":"paragraph","content":[{"text":"Default Value is False.","type":"text"}]},{"type":"bulletList","content":[{"type":"listItem","content":[{"type":"paragraph","content":[{"text":"True: If True, INSERT To Equipment and From Equipment when there is not an existing Equipment record.","type":"text"}]}]},{"type":"listItem","content":[{"type":"paragraph","content":[{"text":"False: If False, an error generates when the Equipment does not exist.","type":"text"}]}]}]},{"type":"heading","attrs":{"level":3},"content":[{"text":"RECREATE_EXISTING_PATH:","type":"text"}]},{"type":"paragraph","content":[{"text":"Default Value = False","type":"text"}]},{"type":"bulletList","content":[{"type":"listItem","content":[{"type":"paragraph","content":[{"text":"True: If a Cable Path already exists on the Service or Location, UPDATE all existing Paths with the Path value in the Import File.","type":"text"}]}]},{"type":"listItem","content":[{"type":"paragraph","content":[{"text":"False: If a Cable Path already exists, the Import generates an error.","type":"text"}]}]}]},{"type":"heading","attrs":{"level":3},"content":[{"text":"REPLACE_IP","type":"text","marks":[{"type":"strong"}]},{"text":":","type":"text"}]},{"type":"paragraph","content":[{"text":"Default Value False.","type":"text"}]},{"type":"bulletList","content":[{"type":"listItem","content":[{"type":"paragraph","content":[{"text":"True: Allows the IP Address of Equipment to UPDATE when the Import File record has a different value.","type":"text"}]}]},{"type":"listItem","content":[{"type":"paragraph","content":[{"text":"False: Causes an error when the IP Address doesn't match.","type":"text"}]}]}]},{"type":"heading","attrs":{"level":3},"content":[{"text":"REPLACE_VLANS:","type":"text"}]},{"type":"paragraph","content":[{"text":"Default Value False.","type":"text"}]},{"type":"bulletList","content":[{"type":"listItem","content":[{"type":"paragraph","content":[{"text":"True: If True, when a VLAN is already assigned to a Port, UPDATE all the previously existing VLANs on that Port with the record from the Import File.","type":"text"}]}]},{"type":"listItem","content":[{"type":"paragraph","content":[{"text":"False: If False, append VLANs into the list of VLANs for that Port.","type":"text"}]}]}]},{"type":"heading","attrs":{"level":3},"content":[{"text":"LOOKUP_PATH_BY_EQUIPMENT:","type":"text"}]},{"type":"paragraph","content":[{"text":"Default Value False.","type":"text"}]},{"type":"bulletList","content":[{"type":"listItem","content":[{"type":"paragraph","content":[{"text":"True: Sets the Import to try to match the existing Equipment ID and its full Location path.","type":"text"}]}]},{"type":"listItem","content":[{"type":"paragraph","content":[{"text":"False: When the flag is False, the Lookup is done by the Service ID.","type":"text"}]}]}]},{"type":"heading","attrs":{"level":3},"content":[{"text":"Legs Array","type":"text"}]},{"type":"paragraph","content":[{"text":"The real magic of the Cable Paths Full Import is the Legs Array field. This field cannot be assigned in the field mappings. It must be set in the Conditional Logic because it must be assigned to a PHP associative array of values containing the possibly multiple Legs of the Cable Path. For each Path Leg, the User is required to specify the Location Name, Type, From Equipment, To Equipment, Port, and optional VLAN. If any of these Locations, Equipment, Ports, or VLANs do not exist, the Import will INSERT them.","type":"text"}]},{"type":"paragraph","content":[{"text":"You can have as many Path Legs in a Path as needed. Each Path Leg may have a variety of associative indexes.","type":"text"}]},{"type":"paragraph","content":[{"text":"Each Path Leg has these array indexes:","type":"text"},{"type":"hardBreak"},{"text":"\"","type":"text"},{"text":"INSTANCE","type":"text","marks":[{"type":"strong"}]},{"text":"\" => Path Leg arbitrary instance number. If not provided, the first leg is set to 100, and each leg after is incremented by 100 (100, 200, 300...).","type":"text"},{"type":"hardBreak"},{"text":"\"","type":"text"},{"text":"pathLegLocationName","type":"text","marks":[{"type":"strong"}]},{"text":"\" => The Path Leg full Location path.","type":"text"}]},{"type":"paragraph","marks":[{"type":"indentation","attrs":{"level":1}}],"content":[{"text":"This can be the same as the Path location, or it can be different in the case of multiple Location Services.","type":"text"}]},{"type":"paragraph","content":[{"text":"\"","type":"text"},{"text":"pathLegLocationType","type":"text","marks":[{"type":"strong"}]},{"text":"\" => The Path Leg Types.","type":"text"}]},{"type":"paragraph","marks":[{"type":"indentation","attrs":{"level":1}}],"content":[{"text":"Formatted like the Path Location Types.","type":"text"}]},{"type":"paragraph","content":[{"text":"\"","type":"text"},{"text":"pathLegCableName","type":"text","marks":[{"type":"strong"}]},{"text":"\" => The preexisting Cable Name to be assigned to the Path Leg.","type":"text"},{"type":"hardBreak"},{"text":"\"","type":"text"},{"text":"pathLegPairStrand","type":"text","marks":[{"type":"strong"}]},{"text":"\" => The preexisting Pair/Strand Number to be assigned to the Path Leg.","type":"text"},{"type":"hardBreak"},{"text":"\"","type":"text"},{"text":"FROM","type":"text","marks":[{"type":"strong"}]},{"text":"\" => Associative array of Equipment, Port, and VLAN values.","type":"text"}]},{"type":"paragraph","marks":[{"type":"indentation","attrs":{"level":1}}],"content":[{"text":"The same values are available for both the FROM and TO arrays.","type":"text"}]},{"type":"paragraph","marks":[{"type":"indentation","attrs":{"level":1}}],"content":[{"text":"All of the values are optional.","type":"text"}]},{"type":"paragraph","marks":[{"type":"indentation","attrs":{"level":1}}],"content":[{"text":"Assigning a value of Null is the same as not assigning the value at all.","type":"text"}]},{"type":"paragraph","content":[{"text":"\"","type":"text"},{"text":"TO","type":"text","marks":[{"type":"strong"}]},{"text":"\" => Associative array of Equipment, Port, and VLAN values.","type":"text"}]},{"type":"paragraph","marks":[{"type":"indentation","attrs":{"level":1}}],"content":[{"text":"The same values are available for both the FROM and TO arrays.","type":"text"}]},{"type":"paragraph","marks":[{"type":"indentation","attrs":{"level":1}}],"content":[{"text":"All of the values are optional.","type":"text"}]},{"type":"paragraph","marks":[{"type":"indentation","attrs":{"level":1}}],"content":[{"text":"Assigning a value to Null is the same as not assigning the value at all.","type":"text"}]},{"type":"paragraph","content":[{"text":"The following indexes are indexes in the FROM and TO arrays not the PATH_LEG array.","type":"text"},{"type":"hardBreak"},{"text":"\"","type":"text"},{"text":"EqpCatalog","type":"text","marks":[{"type":"strong"}]},{"text":"\" => Equipment Catalog Name","type":"text"}]},{"type":"paragraph","marks":[{"type":"indentation","attrs":{"level":1}}],"content":[{"text":"Conditionally ","type":"text"},{"text":"Required","type":"text","marks":[{"type":"textColor","attrs":{"color":"#ff0000"}},{"type":"em"}]},{"text":" and only used when Import is attempting to INSERT the Equipment.","type":"text"}]},{"type":"paragraph","marks":[{"type":"indentation","attrs":{"level":1}}],"content":[{"text":"If the Import is attempting to UPDATE the Equipment, Status is always set to Installed.","type":"text"}]},{"type":"paragraph","content":[{"text":"\"","type":"text"},{"text":"EqpId","type":"text","marks":[{"type":"strong"}]},{"text":"\" => Equipment ID","type":"text"},{"type":"hardBreak"},{"text":"\"","type":"text"},{"text":"EqpLocationName","type":"text","marks":[{"type":"strong"}]},{"text":"\" => Location of the Equipment","type":"text"},{"type":"hardBreak"},{"text":"\"","type":"text"},{"text":"EqpLocationType","type":"text","marks":[{"type":"strong"}]},{"text":"\" => Location Type","type":"text"}]},{"type":"paragraph","marks":[{"type":"indentation","attrs":{"level":1}}],"content":[{"text":"Formatted like the Path location types.","type":"text"}]},{"type":"paragraph","marks":[{"type":"indentation","attrs":{"level":1}}],"content":[{"text":"Only used if Location is provided.","type":"text"}]},{"type":"paragraph","content":[{"text":"\"","type":"text"},{"text":"EqpIP","type":"text","marks":[{"type":"strong"}]},{"text":"\" => IP4 Address","type":"text"},{"type":"hardBreak"},{"text":"\"","type":"text"},{"text":"EqpRemarks","type":"text","marks":[{"type":"strong"}]},{"text":"\" => Equipment Remarks","type":"text"},{"type":"hardBreak"},{"text":"\"","type":"text"},{"text":"EqpPPLPort","type":"text","marks":[{"type":"strong"}]},{"text":"\" => Equipment Port","type":"text"},{"type":"hardBreak"},{"text":"\"","type":"text"},{"text":"EqpPPLStatus","type":"text","marks":[{"type":"strong"}]},{"text":"\" => Port Status","type":"text"},{"type":"hardBreak"},{"text":"\"","type":"text"},{"text":"EqpPPLSpeed","type":"text","marks":[{"type":"strong"}]},{"text":"\" => Port Speed","type":"text"},{"type":"hardBreak"},{"text":"\"","type":"text"},{"text":"EqpPPLPOE","type":"text","marks":[{"type":"strong"}]},{"text":"\" => Port POE flag","type":"text"}]},{"type":"paragraph","marks":[{"type":"indentation","attrs":{"level":1}}],"content":[{"text":"Datatype is Boolean.","type":"text"}]},{"type":"paragraph","marks":[{"type":"indentation","attrs":{"level":1}}],"content":[{"text":"Should be set to 0 for False or 1 for True.","type":"text"}]},{"type":"paragraph","content":[{"text":"\"","type":"text"},{"text":"EqpPPLTxrx","type":"text","marks":[{"type":"strong"}]},{"text":"\" => Port TxRx value","type":"text"},{"type":"hardBreak"},{"text":"\"","type":"text"},{"text":"EqpPPLType","type":"text","marks":[{"type":"strong"}]},{"text":"\" => Port Type","type":"text"},{"type":"hardBreak"},{"text":"\"","type":"text"},{"text":"EqpPPLSide","type":"text","marks":[{"type":"strong"}]},{"text":"\" => Port Side","type":"text"},{"type":"hardBreak"},{"text":"\"","type":"text"},{"text":"EqpPPLVlan","type":"text","marks":[{"type":"strong"}]},{"text":"\" => Port Vlan","type":"text"},{"type":"hardBreak"},{"text":"\"","type":"text"},{"text":"EqpPPLVlanDesc","type":"text","marks":[{"type":"strong"}]},{"text":"\" => Port VLAN Description.","type":"text"}]},{"type":"paragraph","marks":[{"type":"indentation","attrs":{"level":1}}],"content":[{"text":"Only used when the Import is attempting to INSERT the VLAN.","type":"text"}]},{"type":"heading","attrs":{"level":3},"content":[{"text":"Example","type":"text"}]},{"type":"paragraph","content":[{"text":"The best way to describe how to do this is by example. This example creates two Path Legs: Jack to Panel and Panel to Switch. 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 noticed it is slightly more readable when we assign the input values to variables before doing the path_leg assignments.","type":"text"}]},{"type":"paragraph","content":[{"text":"Here is an example of some Conditional Logic:","type":"text"}]},{"type":"codeBlock","attrs":{"language":"php"},"content":[{"text":"///// begin Conditional Logic /////\n$cl_switch = [0];\n// for Port number, if length is 1 then zero pad value.\n$cl_switch_port = strlen([1]) == 1 ? '0'.[1] : [1];\n$cl_switch_location = [2];\n$cl_jack = [3];\n$cl_jack_port = [4];\n$cl_jack_location = [5];\n$cl_panel = [6];\n$cl_panel_port = strlen([7]) == 1 ? '0'.[7] : [7];\n\n[PATHS.LEGS_ARRAY] = array(\n // first leg\n array(\n \"pathLegLocationName\" => $cl_jack_location,\n \"pathLegLocationType\" => 'Building > Room',\n \"pathLegCableName\" => $cl_cable_name,\n \"pathLegPairStrand\" => $cl_pair_strand,\n \"FROM\" => array(\n \"EqpId\" => $cl_jack,\n \"EqpCatalog\" => 'Faceplate',\n \"EqpLocationName\" => $cl_jack_location,\n \"EqpLocationType\" => 'Building > Room',\n \"EqpPPLPort\" => $cl_jack_port,\n \"EqpPPLStatus\" => 'Assigned',\n ),\n \"TO\" => array(\n \"EqpId\" => $cl_panel,\n \"EqpCatalog\" => 'Block / Panel',\n \"EqpLocationName\" => $cl_switch_location,\n \"EqpLocationType\" => 'Building > Closet',\n \"EqpPPLPort\" => $cl_panel_port,\n \"EqpPPLStatus\" => 'Assigned',\n )\n ),\n // second leg\n array(\n \"pathLegLocationName\" => $cl_jack_location,\n \"pathLegLocationType\" => 'Building > Room',\n \"pathLegCableName\" => $cl_cable_name,\n \"pathLegPairStrand\" => $cl_pair_strand,\n \"FROM\" => array(\n \"EqpId\" => $cl_panel,\n \"EqpCatalog\" => 'Block / Panel',\n \"EqpLocationName\" => $cl_switch_location,\n \"EqpLocationType\" => 'Building > Closet',\n \"EqpPPLPort\" => null,\n \"EqpPPLStatus\" => null,\n ),\n \"TO\" => array(\n \"EqpId\" => $cl_switch,\n \"EqpCatalog\" => 'CISCO 3750X',\n \"EqpLocationName\" => $cl_switch_location,\n \"EqpLocationType\" => 'Building > Closet',\n \"EqpPPLPort\" => $cl_switch_port,\n \"EqpPPLStatus\" => 'Assigned',\n )\n ),\n);\n///// end Conditional Logic /////","type":"text"}]},{"type":"heading","attrs":{"level":2},"content":[{"text":"Errors","type":"text"}]},{"type":"paragraph","content":[{"text":"When an Import Line fails, it is usually because the Line falls into one of the following categories:","type":"text","marks":[{"type":"textColor","attrs":{"color":"#172b4d"}}]}]},{"type":"orderedList","attrs":{"order":1},"content":[{"type":"listItem","content":[{"type":"paragraph","content":[{"text":"The value provided from another table was not found within the Database","type":"text"}]},{"type":"paragraph","content":[{"type":"inlineExtension","attrs":{"extensionType":"com.atlassian.confluence.migration","extensionKey":"__confluenceADFMigrationUnsupportedContentInternalExtension__","text":"","parameters":{"cxhtml":"","block-inline":true,"nestedContent":{"type":"doc","content":[{"type":"extension","attrs":{"extensionType":"com.atlassian.confluence.macro.core","extensionKey":"toggle-cloak","parameters":{"macroParams":{"__bodyContent":{"value":""}},"macroMetadata":{"macroId":{"value":"d6db053b-4cb2-46f2-84f0-041ed12383ea"},"schemaVersion":{"value":"1"},"placeholder":[{"type":"icon","data":{"url":"https://compositiontabs.bobswift.appfire.app/assets/img/composition80x80.png"}}],"title":"(Legacy) Toggle Cloak"}}}}],"version":1}}}}]},{"type":"paragraph","content":[{"type":"hardBreak"}]},{"type":"paragraph","content":[{"type":"inlineExtension","attrs":{"extensionType":"com.atlassian.confluence.migration","extensionKey":"__confluenceADFMigrationUnsupportedContentInternalExtension__","text":"","parameters":{"cxhtml":"

Error : Couldn't find GLA <pathsServiceGla> for Service Id <pathsServiceID>
Error : Unable to find from equipment <from_EqpId> at Location <from_EqpLocationName>; <errorMessage>
Error : Unable to find to equipment <to_EqpId> at Location <to_EqpLocationName>; <errorMessage>
Error : Services RECID is invalid
Error : Invalid from Equipment Location <pathLeg_from_EqpLocationName>; ID=<pathLeg_from_EqpId>
Error : Invalid to Equipment Location <pathLeg_to_EqpLocationName>; ID=<pathLeg_to_EqpId>
Error : Invalid from Equipment ID=<pathLeg_from_EqpId> Location=<pathLeg_from_EqpLocationName>
Error : Invalid to Equipment ID=<pathLeg_to_EqpId> Location=<pathLeg_to_EqpLocationName>
Error : Invalid Cable Name <pathLeg_CableName>
Error : Invalid Pair/Strand <pathLeg_PairStrand> for cable <pathLeg_CableName>

","block-inline":true,"nestedContent":{"type":"doc","content":[{"type":"bodiedExtension","attrs":{"extensionType":"com.atlassian.confluence.macro.core","extensionKey":"cloak","parameters":{"macroParams":{},"macroMetadata":{"macroId":{"value":"81bddda3-f946-4a5a-bbdf-bccc714bd338"},"schemaVersion":{"value":"1"},"placeholder":[{"type":"icon","data":{"url":"https://compositiontabs.bobswift.appfire.app/assets/img/composition80x80.png"}}],"title":"(Legacy) Cloak"}}},"content":[{"type":"bulletList","content":[{"type":"listItem","content":[{"type":"paragraph","content":[{"text":"Error : Couldn't find GLA for Service Id ","type":"text"}]}]},{"type":"listItem","content":[{"type":"paragraph","content":[{"text":"Error : Unable to find from equipment at Location ; ","type":"text"}]}]},{"type":"listItem","content":[{"type":"paragraph","content":[{"text":"Error : Unable to find to equipment at Location ; ","type":"text"}]}]},{"type":"listItem","content":[{"type":"paragraph","content":[{"text":"Error : Services RECID is invalid","type":"text"}]}]},{"type":"listItem","content":[{"type":"paragraph","content":[{"text":"Error : Invalid from Equipment Location ; ID=","type":"text"}]}]},{"type":"listItem","content":[{"type":"paragraph","content":[{"text":"Error : Invalid to Equipment Location ; ID=","type":"text"}]}]},{"type":"listItem","content":[{"type":"paragraph","content":[{"text":"Error : Invalid from Equipment ID= Location=","type":"text"}]}]},{"type":"listItem","content":[{"type":"paragraph","content":[{"text":"Error : Invalid to Equipment ID= Location=","type":"text"}]}]},{"type":"listItem","content":[{"type":"paragraph","content":[{"text":"Error : Invalid Cable Name ","type":"text"}]}]},{"type":"listItem","content":[{"type":"paragraph","content":[{"text":"Error : Invalid Pair/Strand for cable ","type":"text"}]}]}]}]}],"version":1}}}}]},{"type":"paragraph","content":[{"type":"hardBreak"}]}]},{"type":"listItem","content":[{"type":"paragraph","content":[{"text":"The value provided from another table has at least one existing Path","type":"text"}]},{"type":"paragraph","content":[{"type":"inlineExtension","attrs":{"extensionType":"com.atlassian.confluence.migration","extensionKey":"__confluenceADFMigrationUnsupportedContentInternalExtension__","text":"","parameters":{"cxhtml":"","block-inline":true,"nestedContent":{"type":"doc","content":[{"type":"extension","attrs":{"extensionType":"com.atlassian.confluence.macro.core","extensionKey":"toggle-cloak","parameters":{"macroParams":{"__bodyContent":{"value":""}},"macroMetadata":{"macroId":{"value":"e1bb00a3-6f1f-465a-8f28-4e475d594000"},"schemaVersion":{"value":"1"},"placeholder":[{"type":"icon","data":{"url":"https://compositiontabs.bobswift.appfire.app/assets/img/composition80x80.png"}}],"title":"(Legacy) Toggle Cloak"}}}}],"version":1}}}}]},{"type":"paragraph","content":[{"type":"hardBreak"}]},{"type":"paragraph","content":[{"type":"inlineExtension","attrs":{"extensionType":"com.atlassian.confluence.migration","extensionKey":"__confluenceADFMigrationUnsupportedContentInternalExtension__","text":"","parameters":{"cxhtml":"

Error : Service <serviceId> has multiple existing Paths
Error : Location <pathsLocationName> has multiple existing Paths
Error : Location <pathsLocationName> already has a Path

Error : Missing Service ID and Location - one is required
Error : Missing Path Legs Array
Error : No Service or Location for Path.
Error : Missing Equipment Catalog <from_equipment_EqpCatalog> for from equipment id <from_equipment_EqpId>
Error : Missing Equipment Catalog <to_equipment_EqpCatalog> for to equipment id <to_equipment_EqpId>

Error : This Service has status 'Order Pending', so no updates allowed
Error : Service <serviceId> already has a Path
Error : Path leg <pathLegIndex> from equipment <importPathLeg_from_EQP> existing properties are different
Error : Path leg <pathLegIndex> to equipment <importPathLeg_to_EQP> existing properties are different

Error : Couldn't process path Location <pathsLocationName>; <errorMessage>
Error : Couldn't update Service Id <pathsServiceID>
Error : Couldn't save Service Id <pathsServiceID>; <$errorMessage>
Error : Couldn't update from equipment <PathLeg_from_EQUIPMENT_RECID> to IP <PathLeg_from_IP; <errorMessage>
Error : Couldn't update to equipment <PathLeg_to_EQUIPMENT_RECID> to IP <PathLeg_to_IP; <errorMessage>
Error : Couldn't process Path <serviceId> <locationId>; <errorMessage>
Error : Couldn't process Path Leg Location <pathLeg_LocationName>; <errorMessage>
Error : Couldn't process from equipment <from_EqpId> Location <from_EqpLocationName>; <errorMessage>
Error : Couldn't process to equipment <to_EqpId> Location <to_EqpLocationName>; <errorMessage>
Error : Unable to add from equipment <from_EqpId> at Location <from_EqpLocationName>; <errorMessage>
Error : Unable to add to equipment <to_EqpId> at Location <to_EqpLocationName>; <errorMessage>
Error : Couldn't process from Equipment <from_EqpId> Remarks; <errorMessage>
Error : Couldn't process to Equipment <to_EqpId> Remarks; <errorMessage>
Error : Couldn't process Equipment <EqpId> Ports Information; <errorMessage>
Error : Couldn't process Leg <pathLeg_FROM_EQP_PPL_RECID> to <pathLeg_TO_EQP_PPL_RECID> <errorMessage>
Error : Couldn't update Service Id <pathsServiceID>; <errorMessage>
Error : Failed to create new Vlan <vlan>; <errorMessage>
Error : Failed to add new Vlan <vlan> to port; <errorMessage>

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.

","block-inline":true,"nestedContent":{"type":"doc","content":[{"type":"bodiedExtension","attrs":{"extensionType":"com.atlassian.confluence.macro.core","extensionKey":"cloak","parameters":{"macroParams":{},"macroMetadata":{"macroId":{"value":"a95b344a-6e0c-4cd6-bfb0-7f4951c415ac"},"schemaVersion":{"value":"1"},"placeholder":[{"type":"icon","data":{"url":"https://compositiontabs.bobswift.appfire.app/assets/img/composition80x80.png"}}],"title":"(Legacy) Cloak"}}},"content":[{"type":"bulletList","content":[{"type":"listItem","content":[{"type":"paragraph","content":[{"text":"Error : Couldn't process path Location ; ","type":"text"}]}]},{"type":"listItem","content":[{"type":"paragraph","content":[{"text":"Error : Couldn't update Service Id ","type":"text"}]}]},{"type":"listItem","content":[{"type":"paragraph","content":[{"text":"Error : Couldn't save Service Id ; <$errorMessage>","type":"text"}]}]},{"type":"listItem","content":[{"type":"paragraph","content":[{"text":"Error : Couldn't update from equipment to IP ","type":"text"}]}]},{"type":"listItem","content":[{"type":"paragraph","content":[{"text":"Error : Couldn't update to equipment to IP ","type":"text"}]}]},{"type":"listItem","content":[{"type":"paragraph","content":[{"text":"Error : Couldn't process Path ; ","type":"text"}]}]},{"type":"listItem","content":[{"type":"paragraph","content":[{"text":"Error : Couldn't process Path Leg Location ; ","type":"text"}]}]},{"type":"listItem","content":[{"type":"paragraph","content":[{"text":"Error : Couldn't process from equipment Location ; ","type":"text"}]}]},{"type":"listItem","content":[{"type":"paragraph","content":[{"text":"Error : Couldn't process to equipment Location ; ","type":"text"}]}]},{"type":"listItem","content":[{"type":"paragraph","content":[{"text":"Error : Unable to add from equipment at Location ; ","type":"text"}]}]},{"type":"listItem","content":[{"type":"paragraph","content":[{"text":"Error : Unable to add to equipment at Location ; ","type":"text"}]}]},{"type":"listItem","content":[{"type":"paragraph","content":[{"text":"Error : Couldn't process from Equipment Remarks; ","type":"text"}]}]},{"type":"listItem","content":[{"type":"paragraph","content":[{"text":"Error : Couldn't process to Equipment Remarks; ","type":"text"}]}]},{"type":"listItem","content":[{"type":"paragraph","content":[{"text":"Error : Couldn't process Equipment Ports Information; ","type":"text"}]}]},{"type":"listItem","content":[{"type":"paragraph","content":[{"text":"Error : Couldn't process Leg to ","type":"text"}]}]},{"type":"listItem","content":[{"type":"paragraph","content":[{"text":"Error : Couldn't update Service Id ; ","type":"text"}]}]},{"type":"listItem","content":[{"type":"paragraph","content":[{"text":"Error : Failed to create new Vlan ; ","type":"text"}]}]},{"type":"listItem","content":[{"type":"paragraph","content":[{"text":"Error : Failed to add new Vlan to port; ","type":"text"}]}]}]},{"type":"paragraph","content":[{"text":"If you experience any of these Errors, without another accompanying Message about what might have caused the Save Failure, please ","type":"text"},{"text":"submit a Ticket to PCR","type":"text","marks":[{"type":"link","attrs":{"href":"https://jira.pcr.com/servicedesk/customer/portal/12/create/192"}}]},{"text":".","type":"text"}]}]}],"version":1}}}}]},{"type":"paragraph","content":[{"type":"hardBreak"}]}]}]},{"type":"extension","attrs":{"layout":"default","extensionType":"com.atlassian.confluence.macro.core","extensionKey":"children","parameters":{"macroParams":{"style":{"value":"h6"},"sort":{"value":"title"}},"macroMetadata":{"macroId":{"value":"49fc0618-4e3d-40c8-92c0-5e0b87f43c92"},"schemaVersion":{"value":"2"},"title":"Child pages (Children Display)"}},"localId":"c7b4e50d-c785-4278-872b-c0a1df9bc2a3"}}],"version":1}

Browser not supported