Document toolboxDocument toolbox

.Department Hierarchy Imports v2.1.4.7

Capability

The Department Hierarchy Import will INSERT and UPDATE Department records.

Matches On

The Department Hierarchy matches on the Code field.

Fields

Code 

Required

Datatype is String.

The Code should be the full path of the Department Hierarchy with the HIERARCHYPATH_CONCATENATOR between the individual path Codes.

Multiple levels of a hierarchy "path" (like Locations, GLAs, and Catalogs) are connected by the HIERARCHYPATH_CONCATENATOR string. The default value for this string is right angle- brace (>) with a space on either side: " > "

    • Example: "Parent Service Catalog > Child Service Catalog"
    • Example: "Building Number > Floor Number > Room Number > Desk Number"

When importing nested values, the separator used for each level of the hierarchy must match the HIERARCHYPATH_CONCATENATOR string.

The Import Process CANNOT UPDATE the Code.

Billing Group

Required

Datatype is String.

Name

Datatype is String.

Default GLA

Datatype is String.

Default SLA Catalog

Datatype is String.

Default Incident SLA Catalog

Datatype is String.

Directory

Datatype is Boolean.

Default value = False [0].

Permitted Values are 1, True, or Yes and set the Flag to True [1].

All other values enter as False [0].

Taxable

Datatype is Boolean.

Default value = False [0].

Permitted Values are 1, True, or Yes and set the Flag to True [1].

All other values enter as False [0].

Status

Datatype is Boolean.

Default value is Active [1].

Permitted Values are 1, True, Yes, or Active and set the Flag to Active[1].

All other values enter as Inactive. 

Permitted GLA

Datatype is 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.

Flags

APPEND_PERMITTED_GLA

By default, the first time a Department Hierarchy is encountered in an Import File and a Permitted GLA is provided, the Permitted GLA list is cleared. Then, the provided value is added. After the first occurrence, the values are appended. If you want to append to the existing list without clearing it, the APPEND_PERMITTED_GLA flag should be set to True.

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

Help Desk Portal - Email: help@pcr.com - Phone: 616.259.9242