(2024.1) Department Hierarchy Imports
- Brian Dixon
- 1 Capability
- 1.1 Matches On
- 2 Fields
- 2.1 Code
- 2.2 Billing Group
- 2.3 Name
- 2.4 Default GLA
- 2.5 Default SLA Catalog
- 2.6 Default Incident SLA Catalog
- 2.7 Directory
- 2.8 Taxable
- 2.9 Status
- 2.10 Permitted GLA
- 2.11 Coordinator
- 3 Flags
- 4 Errors
- 5 UDF Associations
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.
Matches On
The Department Hierarchy matches on the Code field.
Fields
Code
Required
Datatype is Hierarchical String.
The Import Process CANNOT UPDATE the Code.
Billing Group
Required
Datatype is String.
Name
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 = False [0].
Taxable
Datatype is Boolean.
Default value = False [0].
Status
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.
Coordinator
Datatype is String.
Default value is blank.
Value must be a Customer Number of a Contact that has the Coordinator Contact Type.
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.
CLEAR_COORDINATORS
Datatype is String
Default: Flag is unset.
By default, the first time a Department Hierarchy is encountered in an Import file and a Coordinator is provided, the Coordinator list is cleared. Then, the provided value is added. After the first occurrence, the values are appended. If you want to append without clearing the list, you can set this flag to False. If you want to just clear the Coordinator list with or without providing a new value, you can set this flag to True.
Errors
When an Import Line fails, it is usually because the Line falls into one of the following categories:
The value provided from another table was not found or multiple matches found within the Database
A blank value was provided, for a field with a required value
The System was unable to save the record
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.