Capability
This Import allows the User to INSERT or UPDATE existing Equipment on Service Desk Items.
Import Fields mapped via Column Mappings or Conditional Logic will constantly update values (when applicable). If a field is mapped and the value is left blank, the record will save that field as empty. This is especially important to remember when updating records. This behavior can be circumvented with the use of Conditional Logic.
Here is an example of how to conditionally unmap a field without value.
if (trim([<COLUMN_INDEX>]) !== '')
[<FIELD_IDENTIFIER>] = [<COLUMN_INDEX>];
Matches On Criteria
Currently only new Service Desk Equipment can be created. Updating existing records is not supported.
Fields
Operation
Datatype is String
Required
Allowed Values: "INSERT"
Denotes if the import should insert or update a record.
Service Desk Fields
Required
Multiple fields can be used to for the Service Desk Item.
Service Desk Number
Datatype is String
The SD Number of a Service Desk item.
Special Values:
Value Description
PREVIOUS Will use the last saved Service Desk item from an applicable Service Desk import record format (Service/Work Order).
Service Desk RECID
Datatype is Number
The RECID of a Service Desk item.
Special Values:
Value Description
PREVIOUS Will use the last saved Service Desk item from an applicable Service Desk import record format (Service/Work Order).
Service Desk Action Fields
Multiple fields can be used to for the Service Desk Action Item.
Service Desk Action Number
Datatype is String
The Number of a Service Desk Action item.
Special Values:
Value Description
PREVIOUS Will use the last saved Service Desk item from an applicable Service Desk import record format (Service Order).
Service Desk Action RECID
Datatype is Number
The RECID of a Service Desk Action item.
Special Values:
Value Description
PREVIOUS Will use the last saved Service Desk item from an applicable Service Desk import record format (Service Order).
Action Fields
Required
Multiple fields can be used for the Equipment Action.
Action
Datatype is String
A list value or code for the list type "SD_EQP_ACTIONS".
Action RECID
Datatype is Number
The RECID of a list item with the list type "SD_EQP_ACTIONS".
Quantity
Datatype is Number
Required
Must be a positive integer value.
Status Fields
Required
Multiple fields can be used to for the Equipment Status.
Status
Datatype is String
A list value or code for the list type "SD_EQP_STATUS".
Status RECID
Datatype is Number
The RECID of a list item with the list type "SD_EQP_STATUS".
Billable
Datatype is Boolean
Default: False
Equipment Catalog Fields
Required
Multiple fields can be used to for the Equipment Status.
Equipment Catalog
Datatype is Hierarchical String
The Path of an Equipment Catalog item.
Equipment Catalog RECID
Datatype is Number
The RECID of an Equipment Catalog item.
Replaced Equipment Fields
Multiple fields can be used to for the Replaced Equipment item.
Replaced Equipment Asset Tag
Datatype is String
Replaced Equipment Equipment ID
Datatype is String
Replaced Equipment Serial Number
Datatype is String
Replaced Equipment MAC Address
Datatype is String
Replaced Equipment RECID
Datatype is Number
Equipment Fields
Multiple fields can be used to for the Equipment item.
Equipment Asset Tag
Datatype is String
Equipment Equipment ID
Datatype is String
Equipment Serial Number
Datatype is String
Equipment MAC Address
Datatype is String
Equipment RECID
Datatype is Number
Expense Type Fields
Required
Multiple fields can be used to for the Expense Type.
Special Values:
Value Description
PREVIOUS Will use the last saved Equipment item from an Equipment import record format.
Field: Expense Type
Datatype is String
A list value or code for the list type "EXPENSE_TYPE".
Expense Type RECID
Datatype is Number
The RECID of a list item with the list type "EXPENSE_TYPE".
Asset Tag
Datatype is String
Equipment ID
Datatype is String
Serial Number
Datatype is String
MAC Address
Datatype is String
From Location Fields
Required
Multiple fields can be used to for the From Location.
From Location
Datatype is Hierarchical String
The path of a location item.
From Location RECID
Datatype is Number
The RECID of a location item.
From Location Type Fields
Multiple fields can be used to for the From Location.
From Location Type
Datatype is String
A list value or code for the list type "LOCATION_TYPE".
From Location Type RECID
Datatype is Number
The RECID of a list item with the list type "LOCATION_TYPE".
To Location Fields
Multiple fields can be used to for the To Location.
To Location
Datatype is Hierarchical String
The path of a location item.
To Location RECID
Datatype is Number
The RECID of a location item.
To Location Type Fields
Multiple fields can be used to for the To Location.
To Location Type
Datatype is String
A list value or code for the list type "LOCATION_TYPE".
To Location Type RECID
Datatype is Number
The RECID of a list item with the list type "LOCATION_TYPE".
Override GLA Fields
Multiple fields can be used to for the Override GLA.
Override GLA
Datatype is Hierarchical String
The path of a location item.
Override GLA RECID
Datatype is Number
The RECID of a GLA item.
Advanced Examples
How do I use Equipment created by another Record Format within the same Import?
The Record Formats needed
Equipment
Service Desk Equipment
Scenario: The Equipment Record Format created/modified an equipment record. How to match on that exact equipment record so it can be added as Service Desk Equipment?
Fields: The following Service Desk Equipment fields and values can be used.
Equipment RECID: PREVIOUS