Skip to end of metadata
Go to start of metadata

You are viewing an old version of this page. View the current version.

Compare with Current View Page History

Version 1 Next »

Capability

The Locations import allows the User to INSERT new Locations into Catalog Locations or UPDATE existing ones if a match is found.

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 String. This field CANNOT UPDATE. The full Location 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. 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 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. Conditionally Required if the provided Parent Location exists with multiple Types. 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. Status Datatype is Boolean. Defaults to Inactive 0. Permitted Values are 1, True, Yes, Active set the Flag to True 1. All other values enter as False 0. Latitude Datatype is String. Longitude Datatype is String. Warehouse 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. 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 String. Sets the Default Warehouse for the Location to use. Default Warehouse Type Datatype is String. Permitted values are from the LOCATION_TYPE List Values. This field is used for the Default Warehouse lookup if provided. Conditionally Required if the provided Default Warehouse Name exists with multiple Types. Default Return Warehouse Datatype is String. Default value is blank. Sets the Default Warehouse for the Location to use. Default Return Warehouse Type Datatype is String. Permitted values are from the LOCATION_TYPE List Values. This field is used for the Default Return Warehouse lookup if provided. Conditionally Required if the provided Default Return Warehouse Name exists with multiple Types.

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 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 Datatype is String. Permitted values are from the LOCATION_TYPE List Values. This field is used for the Equipment Location lookup if provided. Conditionally Required if the provided Equipment Location exists with multiple Types. Equipment Service Catalog Datatype is 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 Number 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. 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.

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

The following is a listing of the Errors and Warning that are generated by the Locations Import.

The following errors are displayed if the Location INSERT or UPDATE fails:

  • Error : Missing Location
  • Error : Missing or Blank Location Type for new Location <FULL_LOCATION>
  • Error : Invalid Parent Location '<parentLocation>'
  • Error : Invalid Equipment Location <EQUIPMENT_LOCATION> for Equipment ID <EQUIPMENT_ID>
  • Error : Invalid Equipment for Equipment ID <EQUIPMENT_ID> in Location <EQUIPMENT_LOCATION>
  • Error : Missing Service Catalog <SERVICE_CATALOG> for Equipment ID <EQUIPMENT_ID>
  • Error : Failed to save Address record; <errorMessage>
  • Error : Failed to save Location record; <errorMessage>
  • Error : Invalid Parent Location Type '<LOCATION_TYPE>'
  • Error : Invalid Default Warehouse Type '<LOCATION_TYPE>'
  • Error : Invalid Default Return Warehouse Type '<LOCATION_TYPE>'
  • Error : Equipment Location Type '<LOCATION_TYPE>'

These do NOT cause the Location INSERT or UPDATE to fail. They are non-essential for the Location or they happen after the Location save.

  • Warning : Invalid Default Warehouse '<DEFAULT_WAREHOUSE>'
  • Error : Failed to save LocationsSvcEquipment record; <errorMessage>

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.

  • No labels

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