Location import guidelines
The CSV template file that you download from the Manage Assets Work Center includes ten columns for importing locations data.
You must provide a value for the LOCATION and SITEID columns. For columns that are optional, a default value is supplied if you do not provide a value. For columns that are conditional, values are required under specific conditions, which are described in the notes in the following table.
| Field | Description | Field Type | Required | Max Characters | Notes |
|---|---|---|---|---|---|
| LOCATION | The short unique identifier of the location. | Upper case alphanumeric | Required | 12 | |
| DESCRIPTION | The name or description of the location. | Alphanumeric | Optional | 100 | Add a description to provide a meaningful reference to the location. |
| TYPE | The type of the location. | Uppercase alphanumeric | Optional | 16 | Values for location type include REPAIR,
OPERATING, and HOLDING. If no location type is specified, the default value OPERATING is applied to the location. You can specify only one HOLDING location per site. |
| STATUS | The status of the location. | Uppercase alphanumeric | Optional | 20 | Values for location status include ACTIVE, NOT
READY, and DECOMMISSIONED. If no status is specified, the default status ACTIVE is applied to the location. |
| SITEID | The unique identifier of the site for the location. | Uppercase alphanumeric | Required | 8 | Site ID of the location to be added or modified. Sites are facilities or subdivisions in an organization where work and supply chain activities are managed. Each site can track inventory and related data separately from other sites. Sites do not have to be physical locations. |
| LOCHIER_LOCATION | The unique identifier of the location that you are adding or modifying. | Uppercase alphanumeric | Conditional | 12 | The unique identifier of the location within the system hierarchy. When you add a location to a system or change the parent of a location in a system, you must provide a value in this field. The value must be the same value that is specified in the LOCATION field. |
| LOCHIER_SITEID | The unique identifier of the site that you are assigning the location to. | Uppercase alphanumeric | Conditional | 8 | When you add a location to a system or change the parent of a location in a system, you must provide the Site ID of the location that you specified for LOCATION. |
| LOCHIER_SYSTEMID | The unique identifier of the system that you are assigning the location to. | Uppercase alphanumeric | Conditional | 12 | When you add a location to a system or change the parent of a location in a system, you must provide the System ID of the location that you specified for LOCATION. |
| LOCHIER_PARENT | The unique identifier of the parent that you are assigning the location to. | Uppercase alphanumeric | Conditional | 12 | If the location that you are adding is the first location in a system, do not provide a value
for this attribute. By default, the first location that you add becomes the top-level location,
which has no parent. For other locations that you add, you must specify a parent location. |
| LOCHIER_NEWPARENT | The unique identifier of the new parent that you are assigning the location to. | Uppercase alphanumeric | Conditional | 12 | When you assign an existing location in a system to a different parent location that already exists in the system, specify a value for the LOCHIER_NEWPARENT attribute. Assigning a new parent removes the original parent assignment of the location. |