Document toolboxDocument toolbox

.Locations Imports v2020.4

Capability

The Locations Import allows the User to INSERT new Locations intoĀ Location Catalogs or UPDATE existing ones if a match is found.

The Import will notice if any 'Location' already exists in a 'Hidden' state. The process will locate that hidden Location record and update it to 'Not Hidden'. It will also blank out any old information on the Location from before it was hidden, so it will seem like a fresh new record. The remainder if the process will treat the record like a new record, and fill in values as normal. The 'Imported Records' Grid will display a line showing a new Location record added.

A consequence of this is that if there were any old 'Service Orders' that referenced this Location, then any details of the location that were displayed on the Service Order will now show the new Location values instead of the original values. This problem will eventually be solved by "Service Order Archiving", when the ability to hide Locations will be removed.

Matches On

The Import attempts to match the Full Location.

Parent Locations MUST exist before attempting to INSERT child Locations or the Import errors.

  • For example, if the Full Location 'X > Y > Z' is desired, the User must first Import 'X' and 'X > Y' before the Import can INSERT 'X > Y > Z'.

Fields

Full Location

Required

Datatype is Hierarchical String.

This field CANNOT UPDATE.

If an existing Full Location field is not found or the Location string exists with multiple Types, the Import generates an error.

Parent Location Type

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

Datatype is String.

Permitted values are from the LOCATION_TYPE List Values.

This field is used for the Parent Location lookup if provided.

The Parent Location is all of the parts of the Full Location string except for the last part.

Location Type

Datatype is String.

Conditionally Required if the Import is attempting to INSERT the Location.

Permitted values must be one of List Values of type LOCATION_TYPE: Site, Building, Floor, Room, Cube, Truck, Closet, Rack, Elevation, or Manhole.

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

If a Location Type is provided, the Import uses that Location Type to see if an existing record exists for UPDATE.

If the Location Type is not in the List Values, the Import errors.

If a record exists with the same Name but a different Location Type, the Import process does INSERT a new record.

If Location Type is not provided, the record is assumed to be an UPDATE of an existing Location.

New Name

Datatype is String

This is used to rename an existing Location. Only the Name should be provided, not the full hierarchical path.

If a New Name is provided, then the import is assumed to be updating an existing record. If the Location provided in the Full Location field does not exist, an error will occur instead of creating a new Location.

Status

Datatype is Boolean.

Defaults to Inactive [0].

Permitted Values are 1, True, Yes, Active and will set the Flag to True [1].

All other values enter as False [0].

Latitude

Datatype should be Number.

Valid Range is -90.00000 to 90.00000.

If the value has more than 5 digits after the decimal it will be truncated.

Longitude

Datatype should be Number.

Valid Range is -180.00000 to 180.00000.

If the value has more than 5 digits after the decimal it will be truncated.

Warehouse Flag

Datatype is Boolean.

Defaults to False [0].

Permitted Values are 1, True, or Yes and will set the Flag to True [1].

All other values enter as False [0].

Report 911 Flag

Datatype is Boolean.

Defaults to False [0].

Permitted Values are 1, True, or Yes set the Flag to True [1].

All other values enter as False [0].

If the Location Type is Building, the Report 911 flag must be either True or False.

If the Location Type is not a Building Type, the Report 911 flag is not used, and any provided value is ignored by the Import.

Default Warehouse

Datatype is Hierarchical String.

Sets the Default Warehouse for the Location to use.

Default Warehouse Type

Conditionally Required if the provided Default Warehouse Name exists with multiple Types.

Datatype is String.

Permitted values are from the LOCATION_TYPE List Values.

This field is used for the Default Warehouse lookup if provided.

Default Return Warehouse

Datatype is Hierarchical String.

Default value is blank.

Sets the Default Warehouse for the Location to use.

Default Return Warehouse Type

Conditionally Required if the provided Default Return Warehouse Name exists with multiple Types.

Datatype is String.

Permitted values are from the LOCATION_TYPE List Values.

This field is used for the Default Return Warehouse lookup if provided.

Child Records

Servicing Equipment

By default, any existing Equipment is removed from the Servicing Equipment list. The Equipment is added, and it is the only Servicing Equipment on that Location. This behavior can be overridden in the Conditional Logic.

Equipment ID

Datatype is String.

If an Equipment ID is provided, the Import adds that Equipment to the Servicing Equipment tab of the Location.

Equipment Location

Datatype is Hierarchical String.

Equipment Location is used by the Import to look up existing Equipment.

The Import does not INSERT or UPDATE this field.

The Equipment Location is only needed if the Equipment ID is not unique.

Equipment Location Type

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

Datatype is String.

Permitted values are from the LOCATION_TYPE List Values.

This field is used for the Equipment Location lookup if provided.

Equipment Service Catalog

Datatype is Hierarchical String.

This is only used if an Equipment ID is also provided.

Building Address

The Location Type must be a Building to add an Address.

Building ID

Datatype is String.

Community Name

Datatype is String.

Street Address

Datatype is String.

If any of the Address fields are filled, they all become Required except for the Address2 field.

If the Street Address is left blank, and any of the NENA2 E911 fields are provided, then the Street Address value will be built from the E911 field values.

Address2

Datatype is String.

City

Datatype is String.

State

Datatype is String.

Permitted values must be the 2 letter, all caps (MI) or full state name with the first letter capitalized (Michigan).

Zip Code

Datatype is String.

The Zip Code allows 5 + 4 Zip Codes (i.e. 49503-1111)

House Number

Datatype is String

This field can be used only if the USE_E911_NENA2_FIELDS configuration option is set.

House Number Suffix

Datatype is String

This field can be used only if the USE_E911_NENA2_FIELDS configuration option is set.

Pre Direction

Datatype is String

Allowed values are: N, S, E, W, NE, NW, SE, SW.

This field can be used only if the USE_E911_NENA2_FIELDS configuration option is set.

Street

Datatype is String

This field can be used only if the USE_E911_NENA2_FIELDS configuration option is set.

Street Suffix

Datatype is String

This field can be used only if the USE_E911_NENA2_FIELDS configuration option is set.

Post Direction

Datatype is String

Allowed values are: N, S, E, W, NE, NW, SE, SW.

This field can be used only if the USE_E911_NENA2_FIELDS configuration option is set.

Flags / Conditional Logic

FLAGS.APPEND_SVC_EQUIPMENT

Default Value = False.

  • True: Any existing Equipment is unchanged, and new Equipment is appended to the Servicing Equipment associations.
  • False: Any existing Equipment is removed from the Servicing Equipment list, and the new Equipment is added.
    Note: This means the Import only leaves the LAST Equipment record from the Import File associated on as the Servicing Equipment on that Location.

Errors

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

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

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

  3. The value provided was not found in the database


  4. The System was unable to save the record

UDF Associations

User Defined Fields on any given Import are all handled the same way with Conditional Logic. For more information about adding a UDF to the Import see theĀ User Defined Fields section of the Imports main page.

Help Desk Portal - Email: help@pcr.com - Phone: 616.259.9242