Import Asset type parents
- Last UpdatedFeb 25, 2025
- 2 minute read
AVEVA Mobile Operator can import Asset type parents via CSV files. This function uses columns K and onward, which are optional, to specify parents of the asset type in column J.
|
Field |
Column |
Description |
|
1 |
A |
Corresponds to the “Name” Asset datum. |
|
2 |
B |
Corresponds to the “Description” Asset datum. |
|
3 |
C |
This optional entry designates the Asset entry’s Parent asset. If left blank, the Asset entry is placed at the root level of the Asset list. |
|
4 |
D |
The unique identifier for an external system of record. Valid only if imported via an application other than Procedure Builder. |
|
5 |
E |
Specifies the classification of the Asset. Enter a 0 to indicate Location, or 1 to indicate Equipment. |
|
6 |
F |
Specifies the classification of the Asset’s Parent. Enter a 0 to indicate Location, or 1 to indicate Equipment. |
|
7 |
G |
Enter “true” to indicate that Work Order Requests (s) are allowed on the Asset, or “false” to indicate that they are not. |
|
8 |
H |
The display name of the Asset. |
|
9 |
I |
Enter “true” to indicate that the Asset should be marked as deleted within the Database, or “false” to indicate otherwise. |
|
10 |
J |
Text specifying the Asset Type of the Asset. (e.g. “Centrifugal Pump”) |
|
11 |
K |
Text specifying the Asset Type which is the parent of the Asset Type in Field 10 (e.g. “Pump”) |
|
12 |
L |
Text specifying the Asset Type which is the parent of the Asset Type in Field 11 (e.g. “Rotating Equipment”) |
|
13+ |
M+ |
Text specifying the Asset Type which is the parent of the Asset Type in Field 11 or 12 or 13, etc. |
This association continues until there is a blank column in this order, which indicates the root level. For example, here is a line from a CSV file (columns M and beyond are blank):
TestAsset,"This is a test asset",,,1,0,TRUE,,FALSE,Centrifugal Pump,Pump,P101
This example appears in Excel as follows:
Once this is imported into AVEVA Mobile Operator , it appears as follows:
