...
- 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.
...
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.
...
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.
...
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].
...
All other values enter as False [0].
Latitude
Datatype is String.
Longitude
Datatype is String.
Warehouse Flag
Datatype is Boolean.
Defaults to False [0].
...
All other values enter as False [0].
Report 911 Flag
Datatype is Boolean.
Defaults to False [0].
...
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
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.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
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.
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 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.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.
...