{"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":"a1b7f576-92e5-45db-9c49-131436c6f8d9"},"schemaVersion":{"value":"1"},"title":"Table of Contents"}},"localId":"d2a3482c-0217-469c-bb0d-310f7c8b7333"}},{"type":"heading","attrs":{"level":2},"content":[{"text":"Capability","type":"text"}]},{"type":"paragraph","content":[{"text":"The Service Import allows the User to INSERT and UPDATE Service Records. Each Service import type should only be used to add or update Services of that type. For example, the Auth Code Service import should only process Auth Code services. This accommodates the service-specific fields used by different Service types. For example, Phone Service uses Service Host as a field choice that is not available for other Service types.","type":"text"}]},{"type":"paragraph","content":[{"text":"Recently added, there is also a general \"Service\" import that can be used to process Services of any type. If you are creating a new Service import, you should use the general Service import type. It will support all of the special fields for all of the different Service types.","type":"text"}]},{"type":"paragraph","content":[{"type":"inlineExtension","attrs":{"extensionType":"com.atlassian.confluence.macro.core","extensionKey":"excerpt-include","parameters":{"macroParams":{"":{"value":"(2024.2) Bulk Update"},"nopanel":{"value":"true"}},"macroMetadata":{"macroId":{"value":"a0b7bd4f-8c5c-499b-be5e-19a528e2906a"},"schemaVersion":{"value":"1"},"title":"Insert excerpt"}},"localId":"9ecb39c7-51b5-412a-a079-ce2da8c509e3"}}]},{"type":"heading","attrs":{"level":3},"content":[{"text":"Matches On","type":"text"}]},{"type":"paragraph","content":[{"text":"If a Service RECID is provided, the Import only attempts to find that RECID for the update, and errors if not found. If the Service Recid is not provided, the Service ID is used. If there is no match, the record from the Import will INSERT. If there is a match, the remaining fields can UPDATE. A Service ID can exist in the Database multiple times, with and without different formats. For example, \"6165551234\" and \"616-555-1234\" and \"(616) 555-1234\" can be three different Service records. The Service Catalog can be used to force Service IDs into certain formats.","type":"text"}]},{"type":"paragraph","content":[{"text":"If you provide an unformatted Service ID to the Service import, it will try to find a matching unformatted Service ID first. If one is not found, it will try to find a similar formatted Service ID. If multiple different formatted records are found, it will cause an error. If exactly one match is found, it will do an update. If none are found, it will do an Add. If you provide a formatted Service ID, it will only try to find that exact formatted Service ID. If it is found, it will do an update. If it is not are found, it will do an Add.","type":"text"}]},{"type":"heading","attrs":{"level":2},"content":[{"text":"Fields","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"}}]},{"text":", see text.","type":"text","marks":[{"type":"textColor","attrs":{"color":"#000000"}}]},{"type":"hardBreak"}]},{"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":"Service ID will only INSERT if there is not a match in the Import File with an existing Service record based on the Service ID.","type":"text"}]},{"type":"paragraph","marks":[{"type":"indentation","attrs":{"level":1}}],"content":[{"text":"Since the Import matches on the Service ID, this field CANNOT UPDATE.","type":"text"}]},{"type":"paragraph","marks":[{"type":"indentation","attrs":{"level":1}}],"content":[{"text":"If the Service ID field is blank (and no Service RECID is provided), then it is assumed you are trying to add a new Service that has a blank Service ID. This is only allowed for Service Catalog types \"Other\", and non-Phone Custom types.","type":"text"}]},{"type":"heading","attrs":{"level":4},"content":[{"text":"Service 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":"Default is blank.","type":"text"}]},{"type":"paragraph","marks":[{"type":"indentation","attrs":{"level":1}}],"content":[{"text":"This is used to specify the Service Record for Services that have a blank Service ID.","type":"text"}]},{"type":"paragraph","marks":[{"type":"indentation","attrs":{"level":1}}],"content":[{"text":"If this is provided, the provided value must be a valid existing service RECID.","type":"text"}]},{"type":"paragraph","marks":[{"type":"indentation","attrs":{"level":1}}],"content":[{"text":"If it is not, it will cause an error.","type":"text"}]},{"type":"paragraph","marks":[{"type":"indentation","attrs":{"level":1}}],"content":[{"text":"The only Service Types permitted to have blank Service IDs are Other Services and non-Phone Custom Services.","type":"text"}]},{"type":"heading","attrs":{"level":4},"content":[{"text":"Service Catalog","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 trying to INSERT a new record.","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":"NOT ","type":"text"},{"text":"Required","type":"text","marks":[{"type":"textColor","attrs":{"color":"#ff0000"}}]},{"text":" if the Import File is trying to UPDATE an existing record.","type":"text"}]},{"type":"paragraph","marks":[{"type":"indentation","attrs":{"level":1}}],"content":[{"text":"Service Catalog can be provided for the whole Import from the Import Record Format definition.","type":"text"}]},{"type":"heading","attrs":{"level":4},"content":[{"text":"Service Status","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":"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 trying to INSERT a new record.","type":"text"}]},{"type":"paragraph","marks":[{"type":"indentation","attrs":{"level":1}}],"content":[{"text":"NOT Required if the Import File is trying to UPDATE an existing record.","type":"text"}]},{"type":"paragraph","marks":[{"type":"indentation","attrs":{"level":1}}],"content":[{"text":"Permitted Values must be one of ","type":"text"},{"text":"List Values","type":"text","marks":[{"type":"link","attrs":{"href":"https://pcr360.atlassian.net/wiki/spaces/pcr360wiki/pages/498730802"}}]},{"text":" of type SERVICE_STATUS: Available, Inactive, Active, Reserved, Order Pending, Suspend, or Retired.","type":"text"}]},{"type":"paragraph","marks":[{"type":"indentation","attrs":{"level":1}}],"content":[{"text":"Any values added by a User to the SERVICE_STATUS list can also be used.","type":"text"}]},{"type":"heading","attrs":{"level":4},"content":[{"text":"Service Host","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":"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 all of the following are true.","type":"text"}]},{"type":"paragraph","marks":[{"type":"indentation","attrs":{"level":2}}],"content":[{"text":"The Import is trying to INSERT the record and,","type":"text"}]},{"type":"paragraph","marks":[{"type":"indentation","attrs":{"level":2}}],"content":[{"text":"The Status is Active and,","type":"text"}]},{"type":"paragraph","marks":[{"type":"indentation","attrs":{"level":2}}],"content":[{"text":"The Service Catalog is of the Phone type.","type":"text"}]},{"type":"paragraph","marks":[{"type":"indentation","attrs":{"level":1}}],"content":[{"text":"Service Host is NOT ","type":"text"},{"text":"Required","type":"text","marks":[{"type":"textColor","attrs":{"color":"#ff0000"}}]},{"text":" if the Import is trying to UPDATE.","type":"text"}]},{"type":"paragraph","marks":[{"type":"indentation","attrs":{"level":1}}],"content":[{"text":"The provided Service Host must be allowed based on the ","type":"text"},{"text":"Service Host Permissions","type":"text","marks":[{"type":"link","attrs":{"href":"https://pcr360.atlassian.net/wiki/spaces/pcr360wiki/pages/499158235"}}]},{"text":" on the Service Catalog or the Service Host will not INSERT or UPDATE.","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 Contact or Dept. Hierarchy) may be 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 following conditions are met:","type":"text"}]},{"type":"paragraph","marks":[{"type":"indentation","attrs":{"level":2}}],"content":[{"text":"The Import is attempting to INSERT the Service Record and,","type":"text"}]},{"type":"paragraph","marks":[{"type":"indentation","attrs":{"level":2}}],"content":[{"text":"The Service Status is Active.","type":"text"}]},{"type":"paragraph","marks":[{"type":"indentation","attrs":{"level":2}}],"content":[{"text":"Otherwise, the Owner field is NOT required.","type":"text"}]},{"type":"heading","attrs":{"level":5},"marks":[{"type":"indentation","attrs":{"level":1}}],"content":[{"text":"Contact Owner","type":"text"}]},{"type":"paragraph","marks":[{"type":"indentation","attrs":{"level":2}}],"content":[{"text":"Datatype is String.","type":"text"}]},{"type":"paragraph","marks":[{"type":"indentation","attrs":{"level":2}}],"content":[{"text":"Import matches on the Customer Number field only.","type":"text"}]},{"type":"paragraph","marks":[{"type":"indentation","attrs":{"level":2}}],"content":[{"text":"If the existing Contact is not a Customer type Contact, the record fails to Import.","type":"text"}]},{"type":"heading","attrs":{"level":5},"marks":[{"type":"indentation","attrs":{"level":1}}],"content":[{"text":"Dept. Hierarchy Owner","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"}]},{"type":"paragraph","marks":[{"type":"indentation","attrs":{"level":2}}],"content":[{"text":"This Import expects the Department Hierarchy code, not the Name","type":"text","marks":[{"type":"textColor","attrs":{"color":"#172b4d"}}]},{"text":".","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","marks":[{"type":"textColor","attrs":{"color":"#172b4d"}}]}]},{"type":"heading","attrs":{"level":4},"content":[{"text":"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":"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 Status is Active AND if the ","type":"text"},{"text":"Service Catalog","type":"text","marks":[{"type":"link","attrs":{"href":"https://pcr360.atlassian.net/wiki/spaces/pcr360wiki/pages/498797294"}}]},{"text":" flag Location ","type":"text"},{"text":"Required","type":"text","marks":[{"type":"textColor","attrs":{"color":"#ff0000"}}]},{"text":" is set.","type":"text"}]},{"type":"paragraph","marks":[{"type":"indentation","attrs":{"level":1}}],"content":[{"text":"The full Location Path is expected.","type":"text"}]},{"type":"heading","attrs":{"level":4},"content":[{"text":"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":"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":"Permitted values are from the LOCATION_TYPE List Values.","type":"text"}]},{"type":"paragraph","marks":[{"type":"indentation","attrs":{"level":1}}],"content":[{"text":"This field is used for the Location lookup if provided.","type":"text"}]},{"type":"heading","attrs":{"level":4},"content":[{"text":"Location 911","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"}}]},{"text":".","type":"text"},{"type":"hardBreak"},{"type":"hardBreak"},{"text":"Defaults to False","type":"text"},{"type":"hardBreak"},{"text":" ","type":"text"},{"type":"hardBreak"},{"text":"This is only used if the Service has the Multi-Location flag set. This determines which Location will be reported for the 911 Report.","type":"text"}]},{"type":"heading","attrs":{"level":4},"content":[{"text":"Location Status","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"}}]},{"text":".","type":"text"},{"type":"hardBreak"},{"type":"hardBreak"},{"text":"Defaults to Active","type":"text"},{"type":"hardBreak"},{"type":"hardBreak"},{"text":"This is only used if the Service has the Multi-Location flag set. This determines if an individual Service Location is Active.","type":"text"}]},{"type":"paragraph","marks":[{"type":"indentation","attrs":{"level":1}}],"content":[{"text":"Note: ","type":"text","marks":[{"type":"strong"}]},{"text":"If you need to specify Multiple Locations for a Service, you will need to use Conditional Logic to set up an array of values. See the Notes section at the bottom of this page.","type":"text","marks":[{"type":"em"}]}]},{"type":"heading","attrs":{"level":4},"content":[{"text":"Rating Group","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":"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 following two conditions are met:","type":"text"}]},{"type":"paragraph","marks":[{"type":"indentation","attrs":{"level":2}}],"content":[{"text":"If the Service is Active ","type":"text"},{"text":"AND","type":"text","marks":[{"type":"strong"}]},{"text":",","type":"text"}]},{"type":"paragraph","marks":[{"type":"indentation","attrs":{"level":2}}],"content":[{"text":"The ","type":"text"},{"text":"USE_RATING_GROUP","type":"text","marks":[{"type":"link","attrs":{"href":"https://pcr360.atlassian.net/wiki/spaces/pcr360wiki/pages/498110170"}}]},{"text":" Configuration flag is set to True.","type":"text"}]},{"type":"heading","attrs":{"level":4},"content":[{"text":"SLA Catalog","type":"text"}]},{"type":"paragraph","marks":[{"type":"indentation","attrs":{"level":1}}],"content":[{"text":"Datatype is ","type":"text","marks":[{"type":"textColor","attrs":{"color":"#172b4d"}}]},{"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","marks":[{"type":"textColor","attrs":{"color":"#172b4d"}}]}]},{"type":"heading","attrs":{"level":4},"content":[{"text":"Reference","type":"text"}]},{"type":"paragraph","marks":[{"type":"indentation","attrs":{"level":1}}],"content":[{"text":"Datatype is String.","type":"text"}]},{"type":"heading","attrs":{"level":4},"content":[{"text":"Billing Group Override","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":"This is an override of the Owner Billing Group.","type":"text"}]},{"type":"heading","attrs":{"level":4},"content":[{"text":"Multiple Locations","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"}}]},{"text":".","type":"text"}]},{"type":"paragraph","marks":[{"type":"indentation","attrs":{"level":1}}],"content":[{"text":"Defaults to False [0].","type":"text"}]},{"type":"heading","attrs":{"level":4},"content":[{"text":"Essential","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"}}]},{"text":".","type":"text"}]},{"type":"paragraph","marks":[{"type":"indentation","attrs":{"level":1}}],"content":[{"text":"Defaults to False [0].","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"}}]},{"text":".","type":"text"}]},{"type":"paragraph","marks":[{"type":"indentation","attrs":{"level":1}}],"content":[{"text":"Defaults to False [0].","type":"text"}]},{"type":"heading","attrs":{"level":4},"content":[{"text":"Directory","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"}}]},{"text":".","type":"text"}]},{"type":"paragraph","marks":[{"type":"indentation","attrs":{"level":1}}],"content":[{"text":"Defaults to True [1].","type":"text"}]},{"type":"heading","attrs":{"level":4},"content":[{"text":"Report 911","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"}}]},{"text":".","type":"text"}]},{"type":"paragraph","marks":[{"type":"indentation","attrs":{"level":1}}],"content":[{"text":"Defaults to False [0].","type":"text"}]},{"type":"heading","attrs":{"level":4},"content":[{"text":"Company ID","type":"text"}]},{"type":"paragraph","marks":[{"type":"indentation","attrs":{"level":1}}],"content":[{"text":"Datatype is String.","type":"text"}]},{"type":"heading","attrs":{"level":4},"content":[{"text":"Auth Code Type","type":"text"}]},{"type":"paragraph","marks":[{"type":"indentation","attrs":{"level":1}}],"content":[{"text":"Datatype is List.","type":"text"}]},{"type":"paragraph","marks":[{"type":"indentation","attrs":{"level":1}}],"content":[{"text":"Default is blank.","type":"text"}]},{"type":"paragraph","marks":[{"type":"indentation","attrs":{"level":1}}],"content":[{"text":"Permitted values are from the customer-defined AUTH_CODE_TYPE ","type":"text"},{"text":"List Values","type":"text","marks":[{"type":"link","attrs":{"href":"https://pcr360.atlassian.net/wiki/spaces/pcr360wiki/pages/498730802"}}]},{"text":".","type":"text"}]},{"type":"paragraph","marks":[{"type":"indentation","attrs":{"level":2}}],"content":[{"text":"Note","type":"text","marks":[{"type":"strong"}]},{"text":": ","type":"text"},{"text":"This is only available for Auth Code Service Import","type":"text","marks":[{"type":"em"}]},{"text":".","type":"text"}]},{"type":"heading","attrs":{"level":4},"content":[{"text":"Class of Service","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":"Default is blank.","type":"text"}]},{"type":"paragraph","marks":[{"type":"indentation","attrs":{"level":1}}],"content":[{"text":"Permitted values must be existing Class of Service Codes from ","type":"text"},{"text":"Admin > System Tables > Class of Service","type":"text","marks":[{"type":"textColor","attrs":{"color":"#ff0000"}}]},{"text":".","type":"text"}]},{"type":"paragraph","marks":[{"type":"indentation","attrs":{"level":2}}],"content":[{"text":"Note","type":"text","marks":[{"type":"strong"}]},{"text":": ","type":"text"},{"text":"This is only available for Auth Code Service Import.","type":"text","marks":[{"type":"em"}]}]},{"type":"heading","attrs":{"level":2},"content":[{"text":"Child Records","type":"text"}]},{"type":"heading","attrs":{"level":3},"content":[{"text":"Charges Tab","type":"text"}]},{"type":"paragraph","content":[{"text":"Charges are handled with a separate Import file. See the ","type":"text"},{"text":"Service Charges","type":"text","marks":[{"type":"link","attrs":{"href":"https://pcr360.atlassian.net/wiki/spaces/pcr360wiki/pages/498797104"}}]},{"text":" Import for details.","type":"text"}]},{"type":"heading","attrs":{"level":3},"content":[{"text":"Contacts Tab","type":"text"}]},{"type":"heading","attrs":{"level":4},"content":[{"text":"Contact 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":"Default is blank","type":"text"}]},{"type":"heading","attrs":{"level":4},"content":[{"text":"Contact 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":"Default is blank","type":"text"}]},{"type":"heading","attrs":{"level":4},"content":[{"text":"Contact 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":"Default is blank","type":"text"}]},{"type":"heading","attrs":{"level":3},"content":[{"text":"GLA Tab","type":"text"}]},{"type":"paragraph","content":[{"text":"GLAs added to a Service with the Service Import ","type":"text"},{"text":"ONLY","type":"text","marks":[{"type":"strong"}]},{"text":" adds an association between the existing GLAs and the selected Service in the Import File. The Service Import cannot INSERT or UPDATE GLA records.","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":"heading","attrs":{"level":4},"content":[{"text":"GLA Expense 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 GLA is provided.","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":"Must be one of the following: Default, Usage, Equipment, or Labor.","type":"text"}]},{"type":"heading","attrs":{"level":4},"content":[{"text":"GLA Split Percent","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 a GLA is provided If a split GLA is desired, the Import File must have one line for each different GLA and its relevant split percentage.","type":"text"}]},{"type":"paragraph","marks":[{"type":"indentation","attrs":{"level":1}}],"content":[{"text":"Percentages must be whole integers.","type":"text"}]},{"type":"paragraph","marks":[{"type":"indentation","attrs":{"level":1}}],"content":[{"text":"If the percents do not add up to 100%, the Service will still INSERT or UPDATE, but the GLA causes an error and no GLA values change.","type":"text"}]},{"type":"paragraph","marks":[{"type":"indentation","attrs":{"level":1}}],"content":[{"text":"If the GLA values do add up to 100%, the GLA for that given GLA Expense Type are replaced with the new values.","type":"text"}]},{"type":"heading","attrs":{"level":3},"content":[{"text":"Pool Tab","type":"text"}]},{"type":"heading","attrs":{"level":4},"content":[{"text":"Pool Name","type":"text"}]},{"type":"paragraph","marks":[{"type":"indentation","attrs":{"level":1}}],"content":[{"text":"Datatype is String.","type":"text"}]},{"type":"heading","attrs":{"level":3},"content":[{"text":"Remarks Tab","type":"text"}]},{"type":"paragraph","content":[{"text":"This adds a Remark through the Import into the Service.","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":"heading","attrs":{"level":3},"content":[{"text":"Equipment Tab","type":"text"}]},{"type":"paragraph","content":[{"text":"Equipment added to a Service with the Service Import ONLY adds an association between the existing Equipment and the selected Service in the Import File. The Service Import cannot INSERT or UPDATE Equipment records.","type":"text"}]},{"type":"paragraph","content":[{"text":"This includes the changing of the Equipment Status from Unassigned to Assigned. So if you want the Equipment Status to change, you will need to also run an Equipment import.","type":"text"}]},{"type":"paragraph","content":[{"text":"The Equipment fields try to identify an existing Equipment record to add to the Equipment tab of the Service. They are checked in the order of the list below. If a value is blank, it is ignored by the Import process. If the value is filled in, the Import attempts to do the lookup.","type":"text"}]},{"type":"paragraph","content":[{"text":"An Equipment can only be associated if the Service Status is 'Active' or 'Suspend'. And the existing Equipment Status must be 'Assigned'.","type":"text"}]},{"type":"paragraph","content":[{"text":"If the Service Location and Equipment Location are different, it will cause an import Warning, but the association will still get created.","type":"text"}]},{"type":"paragraph","content":[{"text":"By default, Equipment will get appended to any existing Equipment already on the Service. See the Flags below to change this behavior.","type":"text"}]},{"type":"heading","attrs":{"level":4},"content":[{"text":"Equipment Asset","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":"Datatype is String.","type":"text"}]},{"type":"heading","attrs":{"level":4},"content":[{"text":"Equipment 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":"The Equipment Location value is used only with a non-blank Equipment ID. If a non-blank Equipment ID is not provided, then the Location value is ignored. You cannot lookup an Equipment with just a Location.","type":"text"}]},{"type":"heading","attrs":{"level":4},"content":[{"text":"Equipment Serial Number","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 Mac Address","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 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":"This is the RECID field from the Equipment record. This is usually not visible, but it can be obtained from an export. This method will always provide a unique number. It is useful for Equipment with blank values for all of the other key fields.","type":"text"}]},{"type":"paragraph","marks":[{"type":"indentation","attrs":{"level":1}}],"content":[{"text":"If the lookup fails, that import line will output an error message. This error does not affect the Service INSERT or UPDATE, only the Equipment tab association.","type":"text","marks":[{"type":"textColor","attrs":{"color":"#172b4d"}}]}]},{"type":"heading","attrs":{"level":2},"content":[{"text":"Flags / Conditional Logic","type":"text"}]},{"type":"heading","attrs":{"level":3},"content":[{"text":"CLEAR_CONTACTS:","type":"text"}]},{"type":"paragraph","content":[{"text":"Datatype is String","type":"text"},{"type":"hardBreak"},{"text":"Default: Flag is unset.","type":"text"}]},{"type":"paragraph","content":[{"text":"By default, the first time a Service ID is encountered in an Import file and a Contact is provided, the Contact list is cleared. Then, the provided value is added. After the first occurrence, the values are appended.","type":"text"}]},{"type":"bulletList","content":[{"type":"listItem","content":[{"type":"paragraph","content":[{"text":"True: If true, the Contact list will be cleared with or without providing a new value.","type":"text"}]}]},{"type":"listItem","content":[{"type":"paragraph","content":[{"text":"False: If false, you will append without clearing the list","type":"text"}]}]}]},{"type":"heading","attrs":{"level":3},"content":[{"text":"REPLACE_EQUIPMENT:","type":"text"}]},{"type":"paragraph","content":[{"text":"Default Value is False","type":"text"}]},{"type":"bulletList","content":[{"type":"listItem","content":[{"type":"paragraph","content":[{"text":"True: When the flag is True, all of the Equipment is removed and the Import appends the Import Record item.","type":"text"}]}]},{"type":"listItem","content":[{"type":"paragraph","content":[{"text":"False: The default behavior is to simply append Equipment associations.","type":"text"}]}]}]},{"type":"heading","attrs":{"level":3},"content":[{"text":"CLEAR_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 this is set, the Equipment list gets cleared even if no new Equipment is provided.","type":"text"}]}]},{"type":"listItem","content":[{"type":"paragraph","content":[{"text":"False: Equipment is not to be cleared.","type":"text"}]}]}]},{"type":"heading","attrs":{"level":3},"content":[{"text":"APPEND_POOLS:","type":"text"}]},{"type":"paragraph","content":[{"text":"Default Value is False.","type":"text"}]},{"type":"bulletList","content":[{"type":"listItem","content":[{"type":"paragraph","content":[{"text":"True: Setting the flag to True appends Pools to matching Service ID Pools and does not clear any existing Pools.","type":"text"}]}]},{"type":"listItem","content":[{"type":"paragraph","content":[{"text":"False: Setting the flag to False clears existing Pools on matching Service IDs and updates the Pool on the first instance of that Service. Any additional Service ID Pools are appended after the first instance.","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 or multiple matches 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 : Found multiple existing Equipment with Serial Number '<serialNumber>'
Error : Found multiple existing Equipment with MAC Address '<macAddress>'
Error : Found multiple existing Equipment for Equipment ID '<equipmentId>'
Error : Invalid Equipment RECID '<recid>'
Error : Invalid Equipment MAC Address '<macAddress>'
Error : Invalid Equipment Asset Tag '<asset>"
Error : Invalid Equipment Location '<location>'
Error : Invalid Equipment for Equipment ID '<equipmentId>'
Error : Invalid Equipment Serial Number '<serialNumber>'
Error : Invalid Service Pools '<service_pool>'
Error : Invalid Billing Group '<BILLING_GROUP>'
Error : Invalid Class Of Service '<class of service>'
Error : Invalid GLA '<gla>'
Error : Invalid Service Host '<SERVICE_HOST>'
Error : Invalid Location '<LOCATION>'
Error : Invalid Service Catalog '<SERV_CATALOG>'
Error : Invalid Contact '<OWNER_CONTACT>'
Error : Invalid Dept Hierarchy '<OWNER_DEPT_HIERARCHY>'

","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 : Found multiple existing Equipment with Serial Number ''","type":"text"}]}]},{"type":"listItem","content":[{"type":"paragraph","content":[{"text":"Error : Found multiple existing Equipment with MAC Address ''","type":"text"}]}]},{"type":"listItem","content":[{"type":"paragraph","content":[{"text":"Error : Found multiple existing Equipment for Equipment ID ''","type":"text"}]}]},{"type":"listItem","content":[{"type":"paragraph","content":[{"text":"Error : Invalid Equipment RECID ''","type":"text","marks":[{"type":"textColor","attrs":{"color":"#333333"}}]}]}]},{"type":"listItem","content":[{"type":"paragraph","content":[{"text":"Error : Invalid Equipment MAC Address ''","type":"text","marks":[{"type":"textColor","attrs":{"color":"#333333"}}]}]}]},{"type":"listItem","content":[{"type":"paragraph","content":[{"text":"Error : Invalid Equipment Asset Tag '\"","type":"text","marks":[{"type":"textColor","attrs":{"color":"#333333"}}]}]}]},{"type":"listItem","content":[{"type":"paragraph","content":[{"text":"Error : Invalid Equipment Location ''","type":"text","marks":[{"type":"textColor","attrs":{"color":"#333333"}}]}]}]},{"type":"listItem","content":[{"type":"paragraph","content":[{"text":"Error : Invalid Equipment for Equipment ID ''","type":"text","marks":[{"type":"textColor","attrs":{"color":"#333333"}}]}]}]},{"type":"listItem","content":[{"type":"paragraph","content":[{"text":"Error : Invalid Equipment Serial Number ''","type":"text","marks":[{"type":"textColor","attrs":{"color":"#333333"}}]}]}]},{"type":"listItem","content":[{"type":"paragraph","content":[{"text":"Error : Invalid Service Pools ''","type":"text","marks":[{"type":"textColor","attrs":{"color":"#333333"}}]}]}]},{"type":"listItem","content":[{"type":"paragraph","content":[{"text":"Error : Invalid Billing Group ''","type":"text","marks":[{"type":"textColor","attrs":{"color":"#333333"}}]}]}]},{"type":"listItem","content":[{"type":"paragraph","content":[{"text":"Error : Invalid Class Of Service ''","type":"text","marks":[{"type":"textColor","attrs":{"color":"#333333"}}]}]}]},{"type":"listItem","content":[{"type":"paragraph","content":[{"text":"Error : Invalid GLA ''","type":"text","marks":[{"type":"textColor","attrs":{"color":"#333333"}}]}]}]},{"type":"listItem","content":[{"type":"paragraph","content":[{"text":"Error : Invalid Service Host ''","type":"text","marks":[{"type":"textColor","attrs":{"color":"#333333"}}]}]}]},{"type":"listItem","content":[{"type":"paragraph","content":[{"text":"Error : Invalid Location ''","type":"text","marks":[{"type":"textColor","attrs":{"color":"#333333"}}]}]}]},{"type":"listItem","content":[{"type":"paragraph","content":[{"text":"Error : Invalid Service Catalog ''","type":"text","marks":[{"type":"textColor","attrs":{"color":"#333333"}}]}]}]},{"type":"listItem","content":[{"type":"paragraph","content":[{"text":"Error : Invalid Contact ''","type":"text","marks":[{"type":"textColor","attrs":{"color":"#333333"}}]}]}]},{"type":"listItem","content":[{"type":"paragraph","content":[{"text":"Error : Invalid Dept Hierarchy ''","type":"text","marks":[{"type":"textColor","attrs":{"color":"#333333"}}]}]}]}]}]}],"version":1}}}}]},{"type":"paragraph","content":[{"type":"hardBreak"}]}]},{"type":"listItem","content":[{"type":"paragraph","content":[{"text":"The value provided from another table is Inactive","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 : Inactive Service Catalog '<SERV_CATALOG>'

Error : Missing Auth Code type for new Auth Code '<SERVICE_ID>'
Error : Missing GLA
Error : Missing GLA Expense Type
Error : Missing GLA Percent
Error : No Service Catalog Specified
Error : No Status provided for new Service '<SERVICE_ID>'

Error : Service <serviceId>, GLA type <expenseTypeListsRecid>, Percents add up to <sum> (should be 100)
Error : This Equipment Catalog type is restricted from being on this Service Catalog type
Error : Can't assign Equipment unless Service Status is Active or Suspend
Error : Can't assign Equipment unless Equipment Status is Assigned
Error : Provided Service Host not permitted for this service catalog
Error : Provided Location not permitted for this Service Catalog
Error : No Service ID Specified

Error : Failed to save Service record; <errorMessage>
Error : Service <serviceId>, GLA type <expenseTypeListsRecid>; <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 Service record; ","type":"text"}]}]},{"type":"listItem","content":[{"type":"paragraph","content":[{"text":"Error : Service , GLA type ; ","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":"paragraph","content":[{"text":"The ability to append Pools to a Service was added. The default behavior for adding Pools is to clear the Pool list for the first instance of a Service ID in the import file. Then, append to the Pool list for every instance of the Service ID after the first. This can be changed with the APPEND_POOLS flag as described in the Flags section.","type":"text"}]},{"type":"paragraph","content":[{"text":"If a ","type":"text"},{"text":"Remarks","type":"text","marks":[{"type":"strong"}]},{"text":" value is provided, that value is appended as a new record in the Remarks tab of the Service. This happens even if an identical Remark already exists. Care must be taken to avoid unintentional duplicate Remarks if the same file is Imported multiple times.","type":"text"}]},{"type":"paragraph","content":[{"text":"If you need to specify Multiple Locations for a Service, you will need to use Conditional Logic to set up an array of values. Here is how that is done:","type":"text"}]},{"type":"codeBlock","attrs":{"language":"php"},"content":[{"text":"// This is the mappings for the first location, using input fields 5 through 8:\n[SERVICES.LOCATION][] = [5];\n[SERVICES.LOCATION_TYPE][] = [6];\n[SERVICES.LOCATION_911][] = [7];\n[SERVICES.LOCATION_STATUS][] = [8];\n\n// This is the mappings for the second location, using input fields 9 through 12:\n[SERVICES.LOCATION][] = [9];\n[SERVICES.LOCATION_TYPE][] = [10];\n[SERVICES.LOCATION_911][] = [11];\n[SERVICES.LOCATION_STATUS][] = [12];","type":"text"}]},{"type":"paragraph","content":[{"text":"Note the extra brackets before the equals sign. That is what is turning these into array references.","type":"text"}]},{"type":"paragraph","content":[{"text":"Using this method, you can add any number of Locations.","type":"text"}]},{"type":"paragraph","content":[{"text":"Providing the Type, 911 flag, and Status are optional. But if you provide one of these values for one location, you need to provide the value for all the locations.","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. 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":"https://pcr360.atlassian.net/wiki/spaces/pcr360wiki/pages/498436486"}}]},{"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":"f9ed95cc-35c0-4302-993a-c567c4d9c5ba"}}],"version":1}

Browser not supported