| Table of Contents | ||||
|---|---|---|---|---|
|
Capability
The Locations Import allows the User to INSERT new Locations into Location Catalogs or UPDATE existing ones if a match is found.
...
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.
...
Parent Location Type
Conditionally Required if the provided Parent Location exists with multiple Types.
...
Datatype is String.
Conditionally Requiredif the Import is attempting to INSERT the Location.
...
Default Warehouse
Datatype is Hierarchical String.
Sets the Default Warehouse for the Location to use.
Default Warehouse Type
Conditionally Requiredif the provided Default Warehouse Name exists with multiple Types.
...
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 Requiredif the provided Default Return Warehouse Name exists with multiple Types.
...
Equipment Location
Datatype is Hierarchical String.
Equipment Location is used by the Import to look up existing Equipment.
...
Equipment Location Type
Conditionally Requiredif the provided Equipment Location exists with multiple Types.
Datatype is String.
Permitted values are from the LOCATION_TYPE List Values.
...
Equipment Service Catalog
Datatype is Hierarchical String.
This is only used if an Equipment ID is also provided.
...
If any of the Address fields are filled, they all become Requiredexcept 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.
...
Datatype is String.
Country
Default value: "United States"
Datatype is String.
City
Datatype is String.
State
...
This field can be used only if the USE_E911_NENA2_FIELDS configuration option is set.
...
This field can be used only if the USE_E911_NENA2_FIELDS configuration option is set.
...
This field can be used only if the USE_E911_NENA2_FIELDS configuration option is set.
...
This field can be used only if the USE_E911_NENA2_FIELDS configuration option is set.
...
This field can be used only if the USE_E911_NENA2_FIELDS configuration option is set.
...
This field can be used only if the USE_E911_NENA2_FIELDS configuration option is set.
...
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:
A blank value was provided, for a field with a required value
Toggle cloak Cloak - Error : Missing Location
- Error : Missing or Blank Location Type for new Location <FULL_LOCATION>
- Error : Missing Service Catalog <SERVICE_CATALOG> for Equipment ID <EQUIPMENT_ID>
The value provided is not acceptable for the record type being created
Toggle cloak Cloak - 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>'
The value provided was not found in the database
Toggle cloak Cloak - Warning : Invalid Default Warehouse '<DEFAULT_WAREHOUSE>'
- 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>
The System was unable to save the record
Toggle cloak Cloak - Error : Failed to save LocationsSvcEquipment record; <errorMessage>
- Error : Failed to save Address record; <errorMessage>
- Error : Failed to save Location record; <errorMessage>
If you experience any of these Errors, without another accompanying Message about what might have caused the Save Failure, please submit a Ticket to PCR.
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.
| Child pages (Children Display) | ||||
|---|---|---|---|---|
|