{"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":"f136bf81-da1c-4344-9070-a650437d86a5"},"schemaVersion":{"value":"1"},"title":"Table of Contents"}},"localId":"587bd731-7dbf-430d-b106-d640131a5fca"}},{"type":"heading","attrs":{"level":2},"content":[{"text":"Capability","type":"text"}]},{"type":"paragraph","content":[{"text":"The Equipment Import allows the User to INSERT new records and UPDATE existing Equipment records if a match is found.","type":"text"}]},{"type":"paragraph","marks":[{"type":"indentation","attrs":{"level":1}}],"content":[{"text":"Note:","type":"text","marks":[{"type":"strong"}]},{"text":" ","type":"text"},{"text":"The Equipment import cannot assign an Equipment to a Service. To do this task, the Equipment must be created first, and then the Service import can be used to make the assignment.","type":"text","marks":[{"type":"em"}]}]},{"type":"heading","attrs":{"level":3},"content":[{"text":"Matches On","type":"text"}]},{"type":"heading","attrs":{"level":4},"content":[{"text":"Equipment RECID","type":"text"}]},{"type":"paragraph","marks":[{"type":"indentation","attrs":{"level":1}}],"content":[{"text":"If an Equipment RECID is provided, the Equipment Import only attempts to match on the Equipment RECID. If no match is found, an error occurs.","type":"text"}]},{"type":"heading","attrs":{"level":4},"content":[{"text":"Asset Tag","type":"text"}]},{"type":"paragraph","marks":[{"type":"indentation","attrs":{"level":1}}],"content":[{"text":"The Equipment Import first attempts to match on the Asset Tag.","type":"text"}]},{"type":"heading","attrs":{"level":4},"content":[{"text":"Equipment ID","type":"text"}]},{"type":"paragraph","marks":[{"type":"indentation","attrs":{"level":1}}],"content":[{"text":"If there is not an Asset Tag match, the Import attempts to match on the Equipment ID field.","type":"text"}]},{"type":"paragraph","marks":[{"type":"indentation","attrs":{"level":1}}],"content":[{"text":"If there are multiple matches by the Equipment ID, the Import attempts matching both the Equipment ID and Location together.","type":"text"}]},{"type":"paragraph","marks":[{"type":"indentation","attrs":{"level":1}}],"content":[{"text":"If there are multiple matches by the Equipment ID and Location, an error occurs.","type":"text"}]},{"type":"heading","attrs":{"level":4},"content":[{"text":"Serial Number","type":"text"}]},{"type":"paragraph","marks":[{"type":"indentation","attrs":{"level":1}}],"content":[{"text":"If there is not an Equipment ID match, the Import attempts to match on the Serial Number. If there are multiple matches by the Serial Number, an error occurs.","type":"text"}]},{"type":"heading","attrs":{"level":4},"content":[{"text":"MAC Address","type":"text","marks":[{"type":"textColor","attrs":{"color":"#172b4d"}}]}]},{"type":"paragraph","marks":[{"type":"indentation","attrs":{"level":1}}],"content":[{"text":"If there is not a Serial Number match, the Import attempts to match on the MAC Address. If there are multiple matches by the MAC Address, an error occurs.","type":"text","marks":[{"type":"textColor","attrs":{"color":"#172b4d"}}]}]},{"type":"paragraph","marks":[{"type":"indentation","attrs":{"level":1}}],"content":[{"type":"hardBreak"}]},{"type":"paragraph","marks":[{"type":"indentation","attrs":{"level":1}}],"content":[{"text":"Note:","type":"text","marks":[{"type":"strong"}]},{"text":" Because of all of the different methods to lookup an existing record, some extra care must be taken when intending to update key fields of a record. For example, say you want to find a record by the Equipment ID, and update the Asset Tag. If the Asset Tag you provide already exists on a different record, then that different record will be found and updated instead. The lookup order is: Recid, Asset Tag, Equipment ID, Serial Number. Similarly, if you intend to create a new record and you provide an Asset Tag, Equipment ID, and Serial Number, if any of those values already exist, then that existing record will get updated instead of the new addition.","type":"text","marks":[{"type":"em"}]}]},{"type":"heading","attrs":{"level":2},"content":[{"text":"Fields","type":"text"}]},{"type":"heading","attrs":{"level":4},"content":[{"text":"Asset Tag","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":" ","type":"text","marks":[{"type":"textColor","attrs":{"color":"#ff0000"}}]},{"text":"if the Equipment status is set to ","type":"text"},{"text":"Installed","type":"text","marks":[{"type":"strong"}]},{"text":" AND the Asset Flag is set on the ","type":"text"},{"text":"Equipment Catalog","type":"text","marks":[{"type":"link","attrs":{"href":"/wiki/spaces/pcr360wiki/pages/17238155"}}]},{"text":".","type":"text"}]},{"type":"paragraph","marks":[{"type":"indentation","attrs":{"level":1}}],"content":[{"text":"Each Asset Tag must be unique, trying to create a new piece of Equipment with a matching Asset Tag will UPDATE the existing Equipment instead.","type":"text"}]},{"type":"paragraph","marks":[{"type":"indentation","attrs":{"level":1}}],"content":[{"text":"Datatype is String.","type":"text"}]},{"type":"heading","attrs":{"level":4},"content":[{"text":"Equipment ID","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":" ","type":"text","marks":[{"type":"textColor","attrs":{"color":"#ff0000"}}]},{"text":"if the Equipment status is set to ","type":"text"},{"text":"Installed","type":"text","marks":[{"type":"strong"}]},{"text":".","type":"text"}]},{"type":"paragraph","marks":[{"type":"indentation","attrs":{"level":1}}],"content":[{"text":"A duplicate error will trigger if there is already Equipment in the system with the same Equipment ID-Location pairing.","type":"text"}]},{"type":"paragraph","marks":[{"type":"indentation","attrs":{"level":1}}],"content":[{"text":"Datatype is String.","type":"text"}]},{"type":"heading","attrs":{"level":4},"content":[{"text":"Serial Number","type":"text"}]},{"type":"paragraph","marks":[{"type":"indentation","attrs":{"level":1}}],"content":[{"text":"Data type 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":"The Serial Number may be ","type":"text"},{"text":"Required","type":"text","marks":[{"type":"textColor","attrs":{"color":"#ff0000"}}]},{"text":", depending on the state of the REQUIRE_SERIAL_NUMBER configuration setting in your environment.","type":"text"}]},{"type":"heading","attrs":{"level":4},"content":[{"text":"Equipment RECID","type":"text"}]},{"type":"paragraph","marks":[{"type":"indentation","attrs":{"level":1}}],"content":[{"text":"Datatype Number","type":"text"}]},{"type":"paragraph","marks":[{"type":"indentation","attrs":{"level":1}}],"content":[{"text":"This can be used to find Equipment Records for updates. This is especially useful for finding Equipment records that have blank Equipment ID, Asset Tag, and Serial Number.","type":"text"}]},{"type":"paragraph","marks":[{"type":"indentation","attrs":{"level":1}}],"content":[{"text":"If a value is provided for the RECID, then it will be assumed to be an update operation, and no other keys will be tried to find the existing record.","type":"text"}]},{"type":"heading","attrs":{"level":4},"content":[{"text":"Equipment Status","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":" ","type":"text","marks":[{"type":"em"}]},{"text":"if the Import is doing an INSERT.","type":"text"}]},{"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":"NOT","type":"text","marks":[{"type":"strong"}]},{"text":" ","type":"text"},{"text":"Required","type":"text","marks":[{"type":"textColor","attrs":{"color":"#ff0000"}}]},{"text":" if the Import is doing an UPDATE.","type":"text"}]},{"type":"paragraph","marks":[{"type":"indentation","attrs":{"level":1}}],"content":[{"text":"Permitted values are one of the following ","type":"text"},{"text":"List Values","type":"text","marks":[{"type":"link","attrs":{"href":"/wiki/spaces/pcr360wiki/pages/17237724"}}]},{"text":" of type EQP_STATUS: Unassigned, Assigned, Retired, Broken, Lost, or Installed.","type":"text"}]},{"type":"paragraph","marks":[{"type":"indentation","attrs":{"level":1}}],"content":[{"text":"No other values are permitted for the Import.","type":"text"}]},{"type":"paragraph","marks":[{"type":"indentation","attrs":{"level":1}}],"content":[{"text":"If the Equipment's Status is Unassigned, it MUST be assigned to a Location that has the ","type":"text"},{"text":"Warehouse","type":"text","marks":[{"type":"link","attrs":{"href":"/wiki/spaces/pcr360wiki/pages/17238968"}}]},{"text":" flag set or has a blank (Null) Location value.","type":"text"}]},{"type":"heading","attrs":{"level":4},"content":[{"text":"Part Number","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":" ","type":"text","marks":[{"type":"textColor","attrs":{"color":"#ff0000"}}]},{"text":"if the Import is doing an INSERT.","type":"text"}]},{"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":"The Part Number field come from Equipment Catalog field not the full Catalog Path.","type":"text"}]},{"type":"heading","attrs":{"level":4},"content":[{"text":"Units","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":" ","type":"text","marks":[{"type":"textColor","attrs":{"color":"#ff0000"}}]},{"text":"if the ","type":"text"},{"text":"Has Units","type":"text","marks":[{"type":"strong"}]},{"text":" flag is set on the ","type":"text"},{"text":"Equipment Catalog","type":"text","marks":[{"type":"link","attrs":{"href":"/wiki/spaces/pcr360wiki/pages/17238155"}}]},{"text":".","type":"text"}]},{"type":"paragraph","marks":[{"type":"indentation","attrs":{"level":1}}],"content":[{"text":"Datatype is Number.","type":"text"}]},{"type":"heading","attrs":{"level":4},"content":[{"text":"New Equipment ID","type":"text"}]},{"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 a New Equipment ID value is provided, it is used to UPDATE the Equipment ID field.","type":"text"}]},{"type":"heading","attrs":{"level":4},"content":[{"text":"Billable","type":"text"}]},{"type":"paragraph","marks":[{"type":"indentation","attrs":{"level":1}}],"content":[{"text":"Datatype is ","type":"text"},{"text":"Boolean","type":"text","marks":[{"type":"link","attrs":{"href":"https://pcr360.atlassian.net/wiki/x/0JEQAQ"}}]}]},{"type":"paragraph","marks":[{"type":"indentation","attrs":{"level":1}}],"content":[{"text":"Default Value = False","type":"text"}]},{"type":"heading","attrs":{"level":4},"content":[{"text":"Consumed","type":"text"}]},{"type":"paragraph","marks":[{"type":"indentation","attrs":{"level":1}}],"content":[{"text":"Datatype is ","type":"text"},{"text":"Boolean","type":"text","marks":[{"type":"link","attrs":{"href":"https://pcr360.atlassian.net/wiki/x/0JEQAQ"}}]}]},{"type":"paragraph","marks":[{"type":"indentation","attrs":{"level":1}}],"content":[{"text":"Only used if the Configuration Option ","type":"text"},{"text":"SHOW_CONSUMED","type":"text","marks":[{"type":"link","attrs":{"href":"/wiki/spaces/pcr360wiki/pages/17307955"}}]},{"text":" is set to True [1].","type":"text"}]},{"type":"paragraph","marks":[{"type":"indentation","attrs":{"level":1}}],"content":[{"text":"Default Value = False","type":"text"}]},{"type":"heading","attrs":{"level":4},"content":[{"text":"Cabling Eqp Type","type":"text"}]},{"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":"The value must be one of the following ","type":"text"},{"text":"List Values","type":"text","marks":[{"type":"link","attrs":{"href":"/wiki/spaces/pcr360wiki/pages/17237724"}}]},{"text":" of type CABLING_EQP_TYPE: Switch, Router, Jack, IDF, MDF, or BDF.","type":"text"}]},{"type":"paragraph","marks":[{"type":"indentation","attrs":{"level":1}}],"content":[{"text":"User entered values to the CABLING_EQP_TYPE list may also be used.","type":"text"}]},{"type":"heading","attrs":{"level":4},"content":[{"text":"Parent Equipment ID","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":"Should match an existing Equipment ID.","type":"text"}]},{"type":"paragraph","marks":[{"type":"indentation","attrs":{"level":1}}],"content":[{"text":"Look up is based on the ","type":"text"},{"text":"Match On","type":"text","marks":[{"type":"strong"}]},{"text":" values for Equipment records.","type":"text"}]},{"type":"heading","attrs":{"level":4},"content":[{"text":"Parent Location","type":"text"}]},{"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":"Optionally Used with Parent Equipment ID to identify a Parent Equipment.","type":"text"}]},{"type":"heading","attrs":{"level":4},"content":[{"text":"Parent Location Type","type":"text"}]},{"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":"Optionally Used with Parent Location to identify a Parent Equipment.","type":"text"}]},{"type":"paragraph","marks":[{"type":"indentation","attrs":{"level":1}}],"content":[{"text":"Permitted values are from List Values of type LOCATION_TYPE: Site, Building, Floor, Room, Cube, Truck, Closet, Rack, Elevation, Manhole, or Warehouse.","type":"text"}]},{"type":"heading","attrs":{"level":4},"content":[{"text":"Parent Asset Tag","type":"text"}]},{"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":"Optional method to identify a Parent Equipment.","type":"text"}]},{"type":"heading","attrs":{"level":4},"content":[{"text":"Parent Serial Number","type":"text"}]},{"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":"Optional method to identify a Parent Equipment.","type":"text"}]},{"type":"heading","attrs":{"level":4},"content":[{"text":"Parent MAC Address","type":"text"}]},{"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":"Optional method to identify a Parent Equipment.","type":"text"}]},{"type":"heading","attrs":{"level":4},"content":[{"text":"Parent Equipment RECID","type":"text"}]},{"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":"Optional method to identify a Parent Equipment.","type":"text"}]},{"type":"heading","attrs":{"level":4},"content":[{"text":"Private","type":"text"}]},{"type":"paragraph","marks":[{"type":"indentation","attrs":{"level":1}}],"content":[{"text":"Data type is ","type":"text"},{"text":"Boolean","type":"text","marks":[{"type":"link","attrs":{"href":"https://pcr360.atlassian.net/wiki/x/0JEQAQ"}}]},{"text":".","type":"text"}]},{"type":"paragraph","marks":[{"type":"indentation","attrs":{"level":1}}],"content":[{"text":"Default value is false.","type":"text"}]},{"type":"heading","attrs":{"level":4},"content":[{"text":"Card Number","type":"text"}]},{"type":"paragraph","marks":[{"type":"indentation","attrs":{"level":1}}],"content":[{"text":"Data type is String.","type":"text"}]},{"type":"paragraph","marks":[{"type":"indentation","attrs":{"level":1}}],"content":[{"text":"Default value is blank.","type":"text"}]},{"type":"heading","attrs":{"level":4},"content":[{"text":"Owner","type":"text"}]},{"type":"paragraph","marks":[{"type":"indentation","attrs":{"level":1}}],"content":[{"text":"At least one Owner (either Customer Number, Dept Hierarchy Code, or Dept Hierarchy Name) may be ","type":"text"},{"text":"Required","type":"text","marks":[{"type":"textColor","attrs":{"color":"#ff0000"}},{"type":"em"}]},{"text":" ","type":"text","marks":[{"type":"textColor","attrs":{"color":"#ff0000"}}]},{"text":"IF the following conditions are met:","type":"text"}]},{"type":"paragraph","marks":[{"type":"indentation","attrs":{"level":1}}],"content":[{"text":"The Import is attempting to INSERT the Equipment record and the Equipment Status is Assigned.","type":"text"}]},{"type":"paragraph","marks":[{"type":"indentation","attrs":{"level":1}}],"content":[{"text":"Otherwise, the Owner field is ","type":"text"},{"text":"NOT","type":"text","marks":[{"type":"textColor","attrs":{"color":"#000000"}},{"type":"strong"}]},{"text":" Required","type":"text","marks":[{"type":"textColor","attrs":{"color":"#ff0000"}}]},{"text":".","type":"text"}]},{"type":"heading","attrs":{"level":5},"marks":[{"type":"indentation","attrs":{"level":1}}],"content":[{"text":"Customer Number","type":"text"}]},{"type":"paragraph","marks":[{"type":"indentation","attrs":{"level":2}}],"content":[{"text":"Data type is String.","type":"text"}]},{"type":"paragraph","marks":[{"type":"indentation","attrs":{"level":2}}],"content":[{"text":"Default value is blank.","type":"text"}]},{"type":"heading","attrs":{"level":5},"marks":[{"type":"indentation","attrs":{"level":1}}],"content":[{"text":"Dept Hierarchy Code","type":"text"}]},{"type":"paragraph","marks":[{"type":"indentation","attrs":{"level":2}}],"content":[{"text":"Data type 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":" or String.","type":"text","marks":[{"type":"textColor","attrs":{"color":"#172b4d"}}]}]},{"type":"paragraph","marks":[{"type":"indentation","attrs":{"level":2}}],"content":[{"text":"Default value is blank.","type":"text"}]},{"type":"paragraph","marks":[{"type":"indentation","attrs":{"level":2}}],"content":[{"text":"The value for this field can be the full Hierarachial Path, or it can be just the last part of the Path. If you provide only the last part, then there is a chance that there could be duplicate values in the database. If duplicate values are found, then you will get an error.","type":"text"}]},{"type":"heading","attrs":{"level":5},"marks":[{"type":"indentation","attrs":{"level":1}}],"content":[{"text":"Dept Hierarchy Name","type":"text"}]},{"type":"paragraph","marks":[{"type":"indentation","attrs":{"level":2}}],"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":" or String.","type":"text","marks":[{"type":"textColor","attrs":{"color":"#172b4d"}}]}]},{"type":"paragraph","marks":[{"type":"indentation","attrs":{"level":2}}],"content":[{"text":"Default value is blank.","type":"text"}]},{"type":"paragraph","marks":[{"type":"indentation","attrs":{"level":2}}],"content":[{"text":"The value for this field can be the full Hierarachial Path, or it can be just the last part of the Path. If you provide only the last part, then there is a chance that there could be duplicate values in the database. If duplicate values are found, then you will get an error.","type":"text"}]},{"type":"heading","attrs":{"level":4},"content":[{"text":"Billing Group Override","type":"text","marks":[{"type":"textColor","attrs":{"color":"#172b4d"}}]}]},{"type":"paragraph","marks":[{"type":"indentation","attrs":{"level":1}}],"content":[{"text":"Datatype is String","type":"text","marks":[{"type":"textColor","attrs":{"color":"#172b4d"}}]}]},{"type":"paragraph","marks":[{"type":"indentation","attrs":{"level":1}}],"content":[{"text":"Value must match an existing Billing Group.","type":"text","marks":[{"type":"textColor","attrs":{"color":"#172b4d"}}]}]},{"type":"heading","attrs":{"level":4},"content":[{"text":"Eqp Condition","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":"Allowed values are from the EQP_CONDITION List Type values.","type":"text"}]},{"type":"paragraph","marks":[{"type":"indentation","attrs":{"level":1}}],"content":[{"text":"Common values are: New, Used, and Refurbished but may vary for your organization.","type":"text"}]},{"type":"heading","attrs":{"level":4},"content":[{"text":"Host Name","type":"text"}]},{"type":"paragraph","marks":[{"type":"indentation","attrs":{"level":1}}],"content":[{"text":"Data type is String.","type":"text"}]},{"type":"paragraph","marks":[{"type":"indentation","attrs":{"level":1}}],"content":[{"text":"Default value is blank.","type":"text"}]},{"type":"heading","attrs":{"level":4},"content":[{"text":"IPv4 Address","type":"text"}]},{"type":"paragraph","marks":[{"type":"indentation","attrs":{"level":1}}],"content":[{"text":"Data type 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":"The IPv4 Address must be in the form \"a.b.c.d\" where each part is a decimal number between 0 and 255.","type":"text"}]},{"type":"heading","attrs":{"level":4},"content":[{"text":"IPv4 Gateway","type":"text"}]},{"type":"paragraph","marks":[{"type":"indentation","attrs":{"level":1}}],"content":[{"text":"Data type is String.","type":"text"}]},{"type":"paragraph","marks":[{"type":"indentation","attrs":{"level":1}}],"content":[{"text":"Default value is blank.","type":"text"}]},{"type":"heading","attrs":{"level":4},"content":[{"text":"IPv4 Gateway Address","type":"text"}]},{"type":"paragraph","marks":[{"type":"indentation","attrs":{"level":1}}],"content":[{"text":"Data type 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":"The IPv4 Address must be in the form \"a.b.c.d\" where each part is a decimal number between 0 and 255.","type":"text"}]},{"type":"heading","attrs":{"level":4},"content":[{"text":"IPv4 Subnet Mask","type":"text"}]},{"type":"paragraph","marks":[{"type":"indentation","attrs":{"level":1}}],"content":[{"text":"Data type 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":"The IPv4 Address must be in the form \"a.b.c.d\" where each part is a decimal number between 0 and 255.","type":"text"}]},{"type":"heading","attrs":{"level":4},"content":[{"text":"IPv6 Address","type":"text"}]},{"type":"paragraph","marks":[{"type":"indentation","attrs":{"level":1}}],"content":[{"text":"Data type 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":"The IPv6 Address must be in a valid IPv6 address format. The basic layout of this format is 8 sets of 0-4 length hex digits, separated by colons. For example: 001:0db8:85a3::0000:a2e:0370:7334","type":"text"}]},{"type":"heading","attrs":{"level":4},"content":[{"text":"IPv6 Gateway","type":"text"}]},{"type":"paragraph","marks":[{"type":"indentation","attrs":{"level":1}}],"content":[{"text":"Data type is String.","type":"text"}]},{"type":"paragraph","marks":[{"type":"indentation","attrs":{"level":1}}],"content":[{"text":"Default value is blank.","type":"text"}]},{"type":"heading","attrs":{"level":4},"content":[{"text":"IPv6 Gateway Address","type":"text"}]},{"type":"paragraph","marks":[{"type":"indentation","attrs":{"level":1}}],"content":[{"text":"Data type 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":"The IPv6 Address must be in a valid IPv6 address format. The basic layout of this format is 8 sets of 0-4 length hex digits, separated by colons. For example: 001:0db8:85a3::0000:a2e:0370:7334","type":"text"}]},{"type":"heading","attrs":{"level":4},"content":[{"text":"IPv6 Subnet Mask","type":"text"}]},{"type":"paragraph","marks":[{"type":"indentation","attrs":{"level":1}}],"content":[{"text":"Data type 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":"The IPv6 Address must be in a valid IPv6 address format. The basic layout of this format is 8 sets of 0-4 length hex digits, separated by colons. For example: 001:0db8:85a3::0000:a2e:0370:7334","type":"text"}]},{"type":"heading","attrs":{"level":4},"content":[{"text":"LAN Name","type":"text"}]},{"type":"paragraph","marks":[{"type":"indentation","attrs":{"level":1}}],"content":[{"text":"Data type is String.","type":"text"}]},{"type":"paragraph","marks":[{"type":"indentation","attrs":{"level":1}}],"content":[{"text":"Default value is blank.","type":"text"}]},{"type":"heading","attrs":{"level":4},"content":[{"text":"MAC Address","type":"text"}]},{"type":"paragraph","marks":[{"type":"indentation","attrs":{"level":1}}],"content":[{"text":"Data type 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":"The MAC Address must be in a valid MAC address format. These examples are valid: 99:00:34:4a:44:44, 99-00-34-4a-44-44, 990.034.4a4.444, 9900344a4444.","type":"text"}]},{"type":"heading","attrs":{"level":4},"content":[{"text":"Billed Date","type":"text"}]},{"type":"paragraph","marks":[{"type":"indentation","attrs":{"level":1}}],"content":[{"text":"Data type is String.","type":"text"}]},{"type":"paragraph","marks":[{"type":"indentation","attrs":{"level":1}}],"content":[{"text":"Default value is blank.","type":"text"}]},{"type":"heading","attrs":{"level":4},"content":[{"text":"Ordered Date","type":"text"}]},{"type":"paragraph","marks":[{"type":"indentation","attrs":{"level":1}}],"content":[{"text":"Data type is String.","type":"text"}]},{"type":"paragraph","marks":[{"type":"indentation","attrs":{"level":1}}],"content":[{"text":"Default value is blank.","type":"text"}]},{"type":"heading","attrs":{"level":4},"content":[{"text":"Received Date","type":"text"}]},{"type":"paragraph","marks":[{"type":"indentation","attrs":{"level":1}}],"content":[{"text":"Data type is String.","type":"text"}]},{"type":"paragraph","marks":[{"type":"indentation","attrs":{"level":1}}],"content":[{"text":"Default value is blank.","type":"text"}]},{"type":"heading","attrs":{"level":4},"content":[{"text":"Warranty End Date","type":"text"}]},{"type":"paragraph","marks":[{"type":"indentation","attrs":{"level":1}}],"content":[{"text":"Data type is String.","type":"text"}]},{"type":"paragraph","marks":[{"type":"indentation","attrs":{"level":1}}],"content":[{"text":"Default value is blank if Received Date is not provided. If Received Date is provided, Warranty End Date is automatically set.","type":"text"}]},{"type":"heading","attrs":{"level":4},"content":[{"text":"Purchase Price","type":"text"}]},{"type":"paragraph","marks":[{"type":"indentation","attrs":{"level":1}}],"content":[{"text":"Data type is String.","type":"text"}]},{"type":"paragraph","marks":[{"type":"indentation","attrs":{"level":1}}],"content":[{"text":"Default value is blank.","type":"text"}]},{"type":"heading","attrs":{"level":4},"content":[{"text":"Parent Equipment","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":"Default value is blank.","type":"text"}]},{"type":"paragraph","marks":[{"type":"indentation","attrs":{"level":1}}],"content":[{"text":"The value must be a unique Equipment ID if provided.","type":"text"}]},{"type":"heading","attrs":{"level":4},"content":[{"text":"Serial Number Barcode","type":"text"}]},{"type":"paragraph","marks":[{"type":"indentation","attrs":{"level":1}}],"content":[{"text":"Data type is String.","type":"text"}]},{"type":"paragraph","marks":[{"type":"indentation","attrs":{"level":1}}],"content":[{"text":"Default value is blank.","type":"text"}]},{"type":"heading","attrs":{"level":4},"content":[{"text":"Use DHCP","type":"text"}]},{"type":"paragraph","marks":[{"type":"indentation","attrs":{"level":1}}],"content":[{"text":"Data type is ","type":"text"},{"text":"Boolean","type":"text","marks":[{"type":"link","attrs":{"href":"https://pcr360.atlassian.net/wiki/x/0JEQAQ"}}]},{"text":".","type":"text"}]},{"type":"paragraph","marks":[{"type":"indentation","attrs":{"level":1}}],"content":[{"text":"Default value is false.","type":"text"}]},{"type":"heading","attrs":{"level":4},"content":[{"text":"Location","type":"text"}]},{"type":"paragraph","marks":[{"type":"indentation","attrs":{"level":1}}],"content":[{"text":"Conditionally ","type":"text","marks":[{"type":"textColor","attrs":{"color":"#172b4d"}}]},{"text":"Required","type":"text","marks":[{"type":"textColor","attrs":{"color":"#ff0000"}},{"type":"em"}]},{"text":" ","type":"text","marks":[{"type":"textColor","attrs":{"color":"#ff0000"}}]},{"text":"if the Import is doing an Insert AND the Location ","type":"text","marks":[{"type":"textColor","attrs":{"color":"#172b4d"}}]},{"text":"Required","type":"text","marks":[{"type":"textColor","attrs":{"color":"#ff0000"}},{"type":"em"}]},{"text":" Flag is set on the ","type":"text","marks":[{"type":"textColor","attrs":{"color":"#172b4d"}}]},{"text":"Equipment Catalog","type":"text","marks":[{"type":"link","attrs":{"href":"https://pcr360.atlassian.net/wiki/display/PCR360/.Equipment+Catalogs+v2020.4"}}]},{"text":".","type":"text","marks":[{"type":"textColor","attrs":{"color":"#172b4d"}}]}]},{"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":"heading","attrs":{"level":4},"content":[{"text":"Location Type","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":" ","type":"text","marks":[{"type":"textColor","attrs":{"color":"#ff0000"}}]},{"text":"if the provided Location Name exists with multiple Types.","type":"text"}]},{"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":"Used for the Location lookup if provided.","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":"https://pcr360.atlassian.net/wiki/x/pPYQAQ"}}]},{"text":" of type LOCATION_TYPE: Site, Building, Floor, Room, Cube, Truck, Closet, Rack, Elevation, Manhole, or Warehouse.","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":"New 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":"Used to UPDATE the Location of an existing record, or INSERT a Location into a new record.","type":"text"}]},{"type":"paragraph","marks":[{"type":"indentation","attrs":{"level":1}}],"content":[{"text":"If both Location and New Location are given while attempting to insert a record, the Import Process will use the New Location field.","type":"text","marks":[{"type":"textColor","attrs":{"color":"#172b4d"}}]}]},{"type":"heading","attrs":{"level":4},"content":[{"text":"New Location Type","type":"text"}]},{"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":"Used to UPDATE the Location Type of an existing record, or INSERT a Location Type into a new record.","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":"https://pcr360.atlassian.net/wiki/x/pPYQAQ"}}]},{"text":" of type LOCATION_TYPE: Site, Building, Floor, Room, Cube, Truck, Closet, Rack, Elevation, Manhole, or Warehouse.","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":"Remarks","type":"text"}]},{"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":"Remarks are always appended to the Remarks list.","type":"text"}]},{"type":"heading","attrs":{"level":4},"content":[{"text":"Author First Name","type":"text"}]},{"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":"Optional Author for the Remark. If provided, this value must match an existing Contact record.","type":"text"}]},{"type":"paragraph","marks":[{"type":"indentation","attrs":{"level":1}}],"content":[{"text":"This field will be ignored if there is no Remark value.","type":"text"}]},{"type":"heading","attrs":{"level":4},"content":[{"text":"Author Last Name","type":"text"}]},{"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":"Optional Author for the Remark. If provided, this value must match an existing Contact record.","type":"text"}]},{"type":"paragraph","marks":[{"type":"indentation","attrs":{"level":1}}],"content":[{"text":"This field will be ignored if there is no Remark value.","type":"text"}]},{"type":"heading","attrs":{"level":4},"content":[{"text":"Author Customer Number","type":"text"}]},{"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":"Optional Author for the Remark. If provided, this value must match an existing Contact record.","type":"text"}]},{"type":"paragraph","marks":[{"type":"indentation","attrs":{"level":1}}],"content":[{"text":"This field will be ignored if there is no Remark value.","type":"text"}]},{"type":"heading","attrs":{"level":4},"content":[{"text":"GLA Expense Type","type":"text"}]},{"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":"The Expense Type of the GLA being provided. The value must be one of the List Values of type EXPENSE_TYPE: Default, Usage, Equipment, Labor, or any custom type.","type":"text"}]},{"type":"heading","attrs":{"level":4},"content":[{"text":"GLA","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":"Multiple GLA values can be provided on one input line. See the notes at the bottom of this page.","type":"text"}]},{"type":"heading","attrs":{"level":4},"content":[{"text":"GLA Percent","type":"text"}]},{"type":"paragraph","marks":[{"type":"indentation","attrs":{"level":1}}],"content":[{"text":"Datatype is Number","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 was found with multiple matches","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 : Found multiple existing Equipment for Equipment ID '

Error : Trying to use Inactive Charge Catalog <PART_NUMBER>

Error : Missing Status for new Equipment'
Error : Missing or Invalid Units, and Charge Catalog specifies Units are required
Error : Missing or blank Location and Charge Catalog specifies Location is required
Error : Missing Part Number

Error : Invalid Contact '<CUSTOMER_NUMBER>'
Error : Invalid Dept Hierarchy Name '<DEPT_HIERARCHY_NAME>'
Error : Invalid Dept Hierarchy Code '<DEPT_HIERARCHY_CODE>'
Error : Invalid Parent Equipment ID '<PARENT_EQUIPMENT>'
Error : Invalid Part Number '<PART_NUMBER>'
Error : Invalid Location '<LOCATION>'
Error : Invalid Location Type '<LOCATION_TYPE>'
Error : Equipment status is Unassigned but Location '<LOCATION>' is not a Warehouse

Error : Failed to save Equipment record <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 : Failed to save Equipment record ","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":"heading","attrs":{"level":2},"content":[{"text":"Notes","type":"text"}]},{"type":"bulletList","content":[{"type":"listItem","content":[{"type":"paragraph","content":[{"text":"If attempting to UPDATE existing Equipment, none of these ","type":"text"},{"text":"Required","type":"text","marks":[{"type":"textColor","attrs":{"color":"#ff0000"}}]},{"text":" fields except the ","type":"text"},{"text":"Match On","type":"text","marks":[{"type":"strong"}]},{"text":" fields are needed.","type":"text"},{"type":"hardBreak"},{"text":"For updates, it is assumed that the Required values are already entered. For updates, you only need to provide enough values to successfully find the Equipment record you are trying to update (Asset Tag or Equipment ID, and maybe Location).","type":"text"}]}]},{"type":"listItem","content":[{"type":"paragraph","content":[{"text":"If the Equipment Catalog has the 'Has Units' flag set, a Units value must be provided or an error happens.","type":"text"},{"type":"hardBreak"},{"text":"Units must be a positive integer or a zero. Null and negative values are not allowed. If the Equipment Catalog does not have the Has Units flag set to True [1], any provided Units value is ignored with no error or warning.","type":"text"}]}]},{"type":"listItem","content":[{"type":"paragraph","content":[{"text":"The Equipment import cannot associate Equipment to a Service. See the ","type":"text"},{"text":"Service Import","type":"text","marks":[{"type":"link","attrs":{"href":"https://pcr360.atlassian.net/wiki/x/pogQAQ"}}]},{"text":" for a way to do this.","type":"text"}]}]},{"type":"listItem","content":[{"type":"paragraph","content":[{"text":"If you want to provide a single GLA, you can use the regular field mappings. If you want to provide multiple GLA values on one input line, you will need to use some Conditional Logic to create an array of values. This will let you provide GLAs for different Expense Types, and/or do split GLA Percentages.","type":"text"}]}]}]},{"type":"paragraph","marks":[{"type":"indentation","attrs":{"level":3}}],"content":[{"text":"Here is an example of how this is done:","type":"text"}]},{"type":"codeBlock","content":[{"text":"// Assign fields 13-18 into the GLA array\n[FLAGS.GLA_ARRAY] = array(\n array(\n 'Expense_Type' = [13];\n 'GLA' = [14];\n 'Percent' = [15];\n ),\n array(\n 'Expense_Type' = [16];\n 'GLA' = [17];\n 'Percent' = [18];\n ),\n);","type":"text"}]},{"type":"paragraph","marks":[{"type":"indentation","attrs":{"level":3}}],"content":[{"text":"Using this method, you can provide any number of sets of GLA values.","type":"text"}]},{"type":"paragraph","marks":[{"type":"indentation","attrs":{"level":3}}],"content":[{"text":"If you provide a set of GLA values, you must provide all 3 parts: the Expense Type, GLA, and Percent.","type":"text"}]},{"type":"heading","attrs":{"level":2},"content":[{"text":"UDF Associations","type":"text"}]},{"type":"paragraph","content":[{"text":"User Defined fields on any given Import are all handled the same way with Conditional Logic.","type":"text"}]},{"type":"paragraph","content":[{"text":"For more information about adding a UDF to the Import, see the ","type":"text"},{"text":"User Defined Fields","type":"text","marks":[{"type":"link","attrs":{"href":"/wiki/spaces/pcr360wiki/pages/17237763"}}]},{"text":" section of the Imports main page.","type":"text"}]},{"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":"c4252087-653a-4aa9-9a43-f45316740579"}}],"version":1}

Browser not supported