Versions Compared

Key

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

...

Service Catalog

Datatype is Hierarchical String.

Conditionally Required IF the Import is trying to INSERT a new record.

...

Dept. Hierarchy Owner

Datatype is Hierarchical String.

Only the Code From the This Import expects the Dept. Hierarchy is expectedcode, not the Description.

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.

Multiple levels of a hierarchy "path" (like Locations, GLAs, and Catalogs) are connected by the HIERARCHYPATH_SEPARATOR string.

The default value for this string is right angle-brace (>) with a space on either side: " > ".

When importing nested Locations, the separator you use for each level of the hierarchy must match the concatenator string.

For example, Site A > Building B > Room C.

GLA Expense Type

Conditionally Required if GLA is provided.

...

Equipment added to a Service with the Service Import ONLY adds an association between the existing Equipment and the selected Service in the Import File. The Service Import cannot INSERT or UPDATE Equipment records.

This includes the changing of the Equipment Status from Unassigned to Assigned. So if you want the Equipment Status to change, you will need to also run an Equipment import.

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.

...

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.

Multiple levels of a hierarchy "path" (like Locations, GLAs, and Catalogs) are connected by the HIERARCHYPATH_SEPARATOR string.

The default value for this string is right angle-brace (>) with a space on either side: " > ".

When importing nested Locations, the separator you use for each level of the hierarchy must match the concatenator string.

For example, Site A > Building B > Room C.

The Equipment Location value is used only with a non-blank Equipment ID. If a non-blank Equipment ID is not provided, then the Location value is ignored. You cannot lookup an Equipment with just a Location.

...

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

    Toggle cloak

    Cloak
    • Error : Found multiple existing Equipment with Serial Number '<serialNumber>'
    • Error : Found multiple existing Equipment with MAC Address '<macAddress>'
    • Error : Found multiple existing Equipment for Equipment ID '<equipmentId>'
    • Error : Invalid Equipment RECID '<recid>'
    • Error : Invalid Equipment MAC Address '<macAddress>'
    • Error : Invalid Equipment Asset Tag '<asset>"
    • Error : Invalid Equipment Location '<location>'
    • Error : Invalid Equipment for Equipment ID '<equipmentId>'
    • Error : Invalid Equipment Serial Number '<serialNumber>'
    • Error : Invalid Service Pools '<service_pool>'
    • Error : Invalid Billing Group '<BILLING_GROUP>'
    • Error : Invalid Class Of Service '<class of service>'
    • Error : Invalid GLA '<gla>'
    • Error : Invalid Service Host '<SERVICE_HOST>'
    • Error : Invalid Location '<LOCATION>'
    • Error : Invalid Service Catalog '<SERV_CATALOG>'
    • Error : Invalid Contact '<OWNER_CONTACT>'
    • Error : Invalid Dept Hierarchy '<OWNER_DEPT_HIERARCHY>'


  2. The value provided from another table is Inactive

    Toggle cloak

    Cloak
    • Error : Inactive Service Catalog '<SERV_CATALOG>'


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

    Toggle cloak

    Cloak
    • Error : Missing Auth Code type for new Auth Code '<SERVICE_ID>'
    • Error : Missing GLA
    • Error : Missing GLA Expense Type
    • Error : Missing GLA Percent
    • Error : No Service Catalog Specified
    • Error : No Status provided for new Service '<SERVICE_ID>'


  4. The value provided is not acceptable for the record type being created

    Toggle cloak

    Cloak
    • Error : Invalid Equipment RECID '<recid>'
    • Error : Invalid Equipment MAC Address '<macAddress>'
    • Error : Service <serviceId>, GLA type <expenseTypeListsRecid>; <errorMessage>
    • Error : Service <serviceId>, GLA type <expenseTypeListsRecid>, Percents add up to <sum> (should be 100)Error : Invalid Equipment Asset Tag '<asset>"
    • Error : Invalid Equipment Location '<location>'
    • Error : Invalid Equipment for Equipment ID '<equipmentId>'
    • Error : Invalid Equipment Serial Number '<serialNumber>'
    • Error : This Equipment Catalog type is restricted from being on this Service Catalog type
    • Error : Can't assign Equipment unless Service Status is Active or Suspend
    • Error : Can't assign Equipment unless Equipment Status is AssignedError : Invalid Service Pools '<service_pool>'
    • Error : Invalid Billing Group '<BILLING_GROUP>'
    • Error : Invalid Class Of Service '<class of service>'
    • Error : Invalid GLA '<gla>'
    • Error : Invalid Service Host '<SERVICE_HOST>'
    • Error : Provided Service Host not permitted for this service catalog
    • Error : Invalid Location '<LOCATION>'
    • Error : Invalid Location Type '<LOCATION_TYPE>'
    • Error : Provided Location not permitted for this Service Catalog
    • Error : Invalid GLA Percent '<percent>
    • Error : Invalid Service Catalog '<SERV_CATALOG>'
    • Error : No Service ID Specified
    • Error : No Status provided for new Service '<SERVICE_ID>'
    • Error : Invalid Contact '<OWNER_CONTACT>'
    • Error : Invalid Dept Hierarchy '<OWNER_DEPT_HIERARCHY>'


  5. The System was unable to save the record

    Toggle cloak

    Cloak
    • Error : Failed to save Service record; <errorMessage>
    • Error : Service <serviceId>, GLA type <expenseTypeListsRecid>; <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.


...