Assets

an asset is a logical representation of a physical component in your production environment such as a machine, line, tank, sensor, or entire facility each asset has a name id an internal {{uuid}} , making the asset truly unique this is especially relevant when scaling factry historian across multiple plants, where you could have assets that share the same name (e g reactor 1) an asset can furthermore have a description to give additional context to the asset prototype link if the asset is an instance of a prototypes docid 2ver8giwknsrzcbarxikv a parent root assets have no parent all other assets will have a single parent reference by assets can be referenced by asset properties, other assets, event configurations, forwarders, etc an asset could have linked to it one or more assets /#asset properties one or more events docid\ pn 7qsla jr7mnbf6er4a asset tree assets are structured in the asset tree with their parent child relationship this hierarchical tree can have as many levels as necessary to map the physical asset structure existing in the process to the asset model in factry historian for the asset model to be generic, it does not make any presumptions on what each level in the hierarchy could represent hence, the meaning of each level can be different across different use cases a production plant will typically want to follow the isa 95 standard to map their assets to the asset model a wind farm will potentially want to map their assets using a different organizational structure asset properties each asset can have one or more asset properties asset properties allow you to link measurements docid\ ewhzbz5pxxr1upqq xkj5 or calculations docid\ lh1debpbag ki7a0u 3fv to an asset and give them an alias these properties can be used in the configuring the factry historian datasource plugin for grafana docid\ q9t7hxoxsknylawporfdd , in a manual entry forms docid\ e6zvm8l zlpfpchdtqu0h , and as an creating a calculation docid 5ko0eady3x o y1jxd8cp the creating a measurement docid\ u5 07ylms2jix9kz m lb on the measurement will also be available when using the asset property events see events docid\ pn 7qsla jr7mnbf6er4a for more information excel export and import assets, the asset tree, and linked asset properties can be imported and exported in bulk to make mass editing easier the structure of the excel file for importing/exporting is as follows a sheet named assets containing the asset model structure a column import to indicate whether the asset should be imported or not, will import the row if not empty a column uuid to indicate the uuid of the asset, not required for new assets a column assetpath to indicate the path of the asset in the asset tree, separated by \\\ a column description to indicate the description of the asset, not required a sheet named asset properties containing the asset properties a column import to indicate whether the asset property should be imported or not, will import the row if not empty a column uuid to indicate the uuid of the asset property, not required for new asset properties a column assetpath to indicate the path of the asset in the asset tree to link the asset property to, separated by \\\ a column name to indicate the name of the asset property a column description to indicate the description of the asset property, not required a column datatype to indicate the datatype of the asset property, must be one of boolean , number , string , \[]number , \[]string , \[]boolean or raw and must match the datatype of the linked measurement a column measurement to indicate the measurement to link the asset property to a column database to indicate the timeseries database of the measurement both sheets can contain additional columns for metadata, the name of a metadata column must start with metadata + the key of the metadata field for example, if you have a metadata field with key location , you can add a column metadata location to the assets or asset properties sheet to set the value of this metadata field for the asset or asset property for each row that has a value for the metadata you fill it in in the following {{json}} format {"value" \<value>, "datatype" "\<datatype>"} examples for all datatypes {"value" "value", "datatype" "string"} {"value" 123, "datatype" "number"} {"value" true, "datatype" "boolean"} when clicking import from excel , a modal will open where the excel file containing the asset structure and properties can be uploaded when create missing parents is selected, the system will automatically generate any parent assets referenced in the assetpath column of the assets sheet; when create missing parents is not selected, parent assets must be already exist or must be defined first in the file once the upload completes, a preview will be shown detailing how many assets and properties will be created or updated