Versions Compared

Key

  • This line was added.
  • This line was removed.
  • Formatting was changed.

...

The Contact Import allows Users to Import records into the Workers / Contacts Grid. When an existing Contact record is included in the Import File, and no changes are present, that line of the file will be skipped.

Matches On

The Contact first attempts to match the Customer Number then the Email Address. If there is no match, the record from the Import will INSERT. If there is a match, the remaining fields can UPDATE.

...

Dept. Hierarchy

Datatype is Hierarchical String or String.Permitted values must be the full Dept. Hierarchy Path and Code values not the Department Hierarchy Name field.

This Import expects the Department Hierarchy code, not the Name.

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.

Default GLA

Datatype is Hierarchical String.

Default SLA

Datatype is Hierarchical String.

Default Incident SLA

Datatype is Hierarchical String.

Minimum Amount

Datatype is String.

...

[CONTACTS_TYPES.CONTACT_TYPE] = explode(",", [5]);

...

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.

...