Versions Compared

Key

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

Capability

The Department Hierarchy Import will INSERT and UPDATE Department records. When an existing Department Hierarchy record is included in the Import File, and no changes are present, that line of the file will be skipped.

...

Fields

Code

Required

Datatype is Hierarchical String.

The Import Process CANNOT UPDATE the Code.

...

Datatype is String.

Default GLA

Datatype is Hierarchical String.

Default SLA Catalog

Datatype is Hierarchical String.

Default Incident SLA Catalog

Datatype is Hierarchical String.

Directory

Datatype is Boolean.

...

Default value is Active [1].

Permitted GLA

Datatype is Hierarchical String.

Default value is blank.

The Permitted GLA values are GLAs that are appended to the list of GLA Permissions. Values can include NONE which removes all entries in the list and adds the 'Permit None' record or ALL which removes all entries in the list. Adding any GLA to the list removes the Permit None record. If you want to add several Permitted GLAs, they must each be on a separate line of the Import File.

...

When an Import Line fails, it is usually because the Line falls into one of the following categories:

  1. The value provided from another table was not found or multiple matches found within the Database

    Toggle cloak


    Cloak
    • Error : Could not find the Billing Group '<BillingGroup>'
    • Error : Could not find the Default SLA '<SLA>'
    • Error : Could not find the Default Incident SLA '<SLA>'
    • Error : Could not find the Default GLA '<GLA>'
    • Error : Could not find the Permission GLA '<GLA>'
    • Error : Invalid parent Dept Hierarchy Code <DeptHierarchyCode>
    • Error : Default GLA is a different format than Billing Group GLA
    • Error : Permitted GLA is a different format than Billing Group GLA
    • Error : Coordinator Contact '<CUSTOMER_NUMBER>' is not a Coordinator


  2. A blank value was provided, for a field with a required value

    Toggle cloak


    Cloak
    • Error : Missing or Blank Dept Hierarchy Code
    • Error : Missing Billing Group for New Dept Hierarchy


  3. The System was unable to save the record

    Toggle cloak


    Cloak
    • Error : Failed to save Dept Hierarchy <DeptHiearchyCode>; <errorMessage>
    • Error : Failed to save null GLARestrict record; <errorMessage>
    • Error : Failed to save DEPT_HIER_COORDINATORS 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.


UDF Associations

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 (2024.1) User Defined Fields section of the Imports main page.

Child pages (Children Display)
styleh6
sorttitle