Page Comparison

...

Conditionally Required if the Has Units flag is set on the Equipment Catalog.

Datatype is StringNumber.

New Equipment ID

Datatype is String.

...

Parent Equipment ID

Datatype is Hierarchical String.

Should match an existing Equipment ID.

Look up is based on the Match On values for Equipment records.

Parent Location

Datatype is String

Optionally Used with Parent Equipment ID to identify a Parent Equipment.

Parent Location Type

Datatype is String

Optionally Used with Parent Location to identify a Parent Equipment.

Permitted values are from List Values of type LOCATION_TYPE: Site, Building, Floor, Room, Cube, Truck, Closet, Rack, Elevation, Manhole, or Warehouse.

Parent Asset Tag

Datatype is String

Optional method to identify a Parent Equipment.

Parent Serial Number

Datatype is String

Optional method to identify a Parent Equipment.

Parent MAC Address

Datatype is String

Optional method to identify a Parent Equipment.

Parent Equipment RECID

Datatype is Number

Optional method to identify a Parent Equipment.

...

Dept Hierarchy Code

Data type is Hierarchical String.

Default value is blank.

Dept Hierarchy Name

Datatype is Hierarchical String.

Default value is blankString or String.

Default value is blank.

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.

Dept Hierarchy Name

Datatype is Hierarchical String or String.

Default value is blank.

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.

Billing Group Override

Datatype is String

Value must match an existing Billing Group.

Eqp Condition

Default value is blank.

...

Parent Equipment

Datatype is Hierarchical String.

Default value is blank.

The value must be a unique Equipment ID if provided.

...

Default value is false.

Location

Conditionally Required if the Equipment Catalog Import is doing an INSERTInsert AND the Location Required Flag is set on the Equipment Catalog.

Datatype is Hierarchical String.

Location Type

Conditionally Required if the provided Location Name exists with multiple Types.

...

Permitted values are from List Values of type LOCATION_TYPE: Site, Building, Floor, Room, Cube, Truck, Closet, Rack, Elevation, Manhole, or Warehouse.

User entered values to the LOCATION_TYPE list may also be used.

New Location

Datatype is Hierarchical String.

Used to UPDATE the Location of an existing record, or INSERT a Location into a new record.

...

Permitted values are from List Values of type LOCATION_TYPE: Site, Building, Floor, Room, Cube, Truck, Closet, Rack, Elevation, Manhole, or Warehouse.

User entered values to the LOCATION_TYPE list may also be used.

Remarks

Datatype is String

Remarks are always appended to the Remarks list.

Author First Name

Datatype is String

Optional Author for the Remark. If provided, this value must match an existing Contact record.

This field will be ignored if there is no Remark value.

Author Last Name

Datatype is String

Optional Author for the Remark. If provided, this value must match an existing Contact record.

This field will be ignored if there is no Remark value.

Author Customer Number

Datatype is String

Optional Author for the Remark. If provided, this value must match an existing Contact record.

This field will be ignored if there is no Remark value.

GLA Expense Type

Datatype is String

The Expense Type of the GLA being provided. The value must be one of the List Values of type EXPENSE_TYPE: Default, Usage, Equipment, Labor, or any custom type.

GLA

Datatype is Hierarchical String.

Multiple GLA values can be provided on one input line. See the notes at the bottom of this page.

GLA Percent

Datatype is Number

Errors

When an Import Line fails, it is usually because the Line falls into one of the following categories:

...

• If attempting to UPDATE existing Equipment, none of these Required fields except the Match On fields are needed.
  For updates, it is assumed that the Required values are already entered. For updates, you only need to provide enough values to successfully find the Equipment record you are trying to update (Asset Tag or Equipment ID, and maybe Location).
• If the Equipment Catalog has the 'Has Units' flag set, a Units value must be provided or an error happens.
  Units must be a positive integer or a zero. Null and negative values are not allowed. If the Equipment Catalog does not have the Has Units flag set to True [1], any provided Units value is ignored with no error or warning.
• The Equipment import cannot associate Equipment to a Service. See the Service Import for a way to do this.
• If you want to provide a single GLA, you can use the regular field mappings. If you want to provide multiple GLA values on one input line, you will need to use some Conditional Logic to create an array of values. This will let you provide GLAs for different Expense Types, and/or do split GLA Percentages.

Here is an example of how this is done:

// Assign fields 13-18 into the GLA array
[FLAGS.GLA_ARRAY] = array(
   array(
      'Expense_Type' = [13];
      'GLA' = [14];
      'Percent' = [15];
      ),
   array(
      'Expense_Type' = [16];
      'GLA' = [17];
      'Percent' = [18];
   ),
);

Using this method, you can provide any number of sets of GLA values.

If you provide a set of GLA values, you must provide all 3 parts: the Expense Type, GLA, and Percent.

UDF Associations

User Defined fields on any given Import are all handled the same way with Conditional Logic.

...