...
The Service Import allows the User to INSERT and UPDATE Service Records. Child records of the Service is association records only. Each Service type requires its own distinct Service Import. For example, Auth Codes are imported using an Auth Code Service import. 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.
| Insert excerpt | ||||||
|---|---|---|---|---|---|---|
|
Matches On
The Import attempts to match the Service ID. If there is no match, the record from the Import will INSERT. If there is a match, the remaining fields can UPDATE.
...
Service Catalog
Datatype is Hierarchical String.
Conditionally Required IF the Import is trying to INSERT a new record.
...
Only the Code From the Dept. Hierarchy is expected.
Location
Datatype is Hierarchical String.
Conditionally Required if Status is Active AND if the Service Catalog flag Location Required is set.
...
The USE_RATING_GROUP Configuration flag is set to True.
SLA Catalog
Datatype is Hierarchical String.
Reference
Datatype is String.
...
GLAs added to a Service with the Service Import ONLY adds an association between the existing GLAs and the selected Service in the Import File. The Service Import cannot INSERT or UPDATE GLA records.
GLA
Datatype is Hierarchical String.
GLA must be the full GLA Path with all Components separated by the GLA_CONCATENATOR.
...
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.
If the lookup fails, the Import stops and output an error message. This error does not affect the Service INSERT or UPDATE, only the Equipment tab association.
An Equipment can only be associated if the Service Status is 'Active' or 'Suspend'. And the existing Equipment Status must be 'Assigned'.
...
Equipment Location
Datatype is Hierarchical String.
The full Location Path hierarchy in a single string, with individual parts of the Location Hierarchy separated by the HIERARCHYPATH_CONCATENATOR.
...
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.
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.
Flags / Conditional Logic
...