...
Passing in a blank value or Null causes the Import to create a new Work Order record.
PREVIOUS
The Keyword PREVIOUS assigns assigns the current line of the Import File record to UPDATE the last successfully saved Work Order with a new record. This is most often used when appending an additional GLA child record.
SD Number
...
Datatype is String.
See the Matches On section for information about allowable values.
...
Status
Datatype is String.
Default value Pending.
If the Import is attempting an INSERT, the only valid value is Pending
...
If they are both provided, an error is generated.The
Owner
...
Owner Contact
Datatype is String.
...
Owner Department Hierarchy
Datatype is Hierarchical String.
The full Department Hierarchy Path and Code value should be provided.
...
MUST be used with Requestor First Name.
...
Impact
Datatype is String.
Default value: Off
Valid values are Nullblank (Off), Low, Medium, and High.
Note: You cannot provide the value 'Off'. You have to provide a blank, and it is displayed as 'Off'.
Any other values are converted to Nullwill cause an error.
Urgency
Datatype is String.
Default value: Off
Valid values are blank (Off), Low, Medium, and High.
Note: You cannot provide the value 'Off'. You have to provide a blank, and it is displayed as 'Off'.
Any other values will cause an error.
Default GLA
Datatype is Hierarchical String.
This sets the Action Default Expense GLA in the the Order's GLA tab.
Note this is ignored if the SDA_ALLOW_MULTIPLE_DEFAULT_GLAS Configuration Option is set to True.
Associated Project
Datatype is String.
Default value: blank
If this is provided, it must be an existing Project or Problem Service Desk Number.
...
Service Catalog
Datatype is Hierarchical String.
For Work Orders, the Service Catalog must be a 'Task' type.
Location
Datatype is Hierarchical String.
Location Type
Datatype is String.
...
Permitted values are from the LOCATION_TYPE List Values.
This field is used for the Action Work Order Location lookup if provided.
SLA
Datatype is Hierarchical String.
SDC
Datatype is String.
Details
Datatype is String.
The details field can contain multiple lines of string data, separated by newline characters.
GLAs
...
GLA
...
GLA
Datatype is String.
This is a full sequence of GLA 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.
Can be provided as an array to allow multiple GLAsHierarchical String.
If the GLA is blank, the GLA Expense Type, GLA Percent, and Default GLA Flag are all ignored.
...
This is only used if the SDA_ALLOW_MULTIPLE_DEFAULT_GLAS Configuration Option is set to True.
Errors
The following errors display if the Work Order Import fails:
...
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 within the Database
Toggle cloak Cloak - Error : SD Number PREVIOUS specified but no previous successful save
The value provided from another table is Inactive
Toggle cloak Cloak - Error : Default GLA '<GLA>' is Inactive
- Error : Inactive Service Catalog '<SERVICE_CATALOG>'
A blank value was provided, for a field with a required value
Toggle cloak Cloak - Error : Some GLA Percents are blank
- Error : Blank GLA
- Error : Service Rep is blank for new Service Desk record
The value provided is not acceptable for the record type being created
Toggle cloak Cloak - Error : Invalid Service Desk Number '<SD_ NUMBER>'
- Error : Invalid Service Desk Status. Only Pending is allowed for new Service Desk records.
- Error : Invalid Service Desk Status. Only Pending or Hold is allowed for Service Desk updates.
- Error : Provided CSR is not a Service Rep Contact Type
...
- Error : Invalid Default GLA '<GLA>'
- Error : Different count of GLAs and GLA percents
...
- Error : Some GLA Percents are out of range (1 to 100)
- Error : Some GLA Percents are not whole numbers
- Error : GLA Percents do not add up to 100
- Error :
...
- Default
...
- Owner Contact and Dept Hierarchy were both specified. Only one is allowed.
- Error : Not allowed to update SDC on existing Work Order
- Error : Not allowed to update Service Catalog on existing Work Order
- Error : SDC '<SDC>' is not valid for this Action
- Error : Provided Catalog type is not Task
- Error : Provided Location not permitted for this Service Catalog
- Error :
...
- Service
...
- Catalog '<SERVICE_CATALOG>' is a Category
- Error :
...
- Invalid Service Catalog '<SERVICE_CATALOG>'
The System was unable to save the record
Toggle cloak Cloak - Error :
...
- Failed to save Service Desk Assoc record; <ERROR_MESSAGE>
- Error : Failed to save Service Desk record; <ERROR_MESSAGE>
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.
Notes
| Anchor | ||||
|---|---|---|---|---|
|
The Work Order Source field CANNOT be set in Import. It is automatically set to Import on INSERT and unchanged for UPDATE.
...