ContextHub - TrendMiner Asset structure configuration and import requirements

The asset tree

Your asset tree can be found in the asset browser on TrendHub.  

  1. Select the tags icon, and click on the "Search tags & attributes" button located next to the Hub Switcher in the unified top bar.  
  2. Look to the drop down menu that opens, and click on the "Assets" option.  

The asset root nodes that have been published or activated will display in the drop down. 

The root node is the starting node of an asset path. The path can be made up of many branches and nodes that leads eventually to the assets or attributes of the structure, for example; temperature or concentration.  

This asset browser is also located in ContextHub and is made available when adding a component to a newly created context item or a newly created context view filter.  

Asset tree structure

The following is a typical example of an asset tree in TrendMiner: 

  • Houston  (root node asset) 
    • Reactor 1 (standard node sub-asset) 
      • Concentration (attribute - leaf node) 
      • Temperature 
      • Level 

Asset structure csv import (admin option)

If you are without a specialized tool like OSIsoft PI AF, and want to set up an asset structure, you can use the built in asset structure CSV import inside ContextHub. You can define your structure inside a ready made CSV file available for download.  

  1. Select ContextHub using the hubswitch 
  2. Select "Config" 
  3. Select "Asset structure" 
  4. Click on the Add asset structure option 


An "Add asset structure" side panel opens from the right of the screen. Download the example file made available in the side panel. 


The following is the example file, opened with a spreadsheet tool: 


General rules when laying out the structure in CSV

  • The parent of a node (single row) should be defined above its children 
  • The markup of the file requires you to use the CSV markup with a comma (,) as a separator and all values optionally quoted with “ 
  • Encoding must be UTF-8 
  • The path is the full path of the asset. It must include the name. And the name must be consistent in use. This means consistent spelling and case use. 

Updating the CSV asset structure

IMPORTANT!!! From the Asset structure config screen (ContextHub → Config → Asset structure) download your current asset structure. This way your list of assets and attributes will have a column called ‘id’. This id is the unique identifier of the asset or attributes in the TrendMiner system. This way, we’ll know that when you update one of the rows in your csv-file, to which asset in the TrendMiner system you are referring to. Also the source column is filled in now. 

To update a row, make sure the ‘id’ column of your row is filled in. Here you can edit the path,name, description, type, template and tag.

Note: when updating the name of an item, you also need to update the path.

For new entries in the structure, leave the ‘id’ field empty.

To delete entries, leave out the rows in the csv-file to delete the asset or attribute from the TrendMiner asset structure.

Mandatory columns in the csv-file:

  • Path 
  • Name 
  • Type (can be ASSET (no tag data reference), ATTRIBUTE (with tag data reference) 
  • Tag with historian prefix (if type = ATTRIBUTE) (eg: [PI18]BA:LEVEL.1) 
  • Source 

Note: ID is mandatory for updates, otherwise it will try to create the asset and an error will be returned: Asset with path {0} already exists with ID {1}. You must use this ID if you want to re-enable the node. 

Note: The prefix is only needed when we have multiple historians. If there's only one, the prefix is not needed.

Note: The source is mandatory when updating. When adding a new asset structure, it is mandatory to be empty.

Once your CSV file has been populated:  

  1. Fill in a name for your asset structure. 
  2. Add the file by clicking on the "Add attachment" button in the  "Add asset structure" side panel. Select the file.  
  3. Click the "Add" button at the base of the panel. Your new asset structure is now added to your asset structure menu in ContextHub. You will receive a notification when it's done. If there was something wrong with the file, an error file will be generated with error messages for specific rows. 
  4. To activate the newly uploaded asset structure, click on the "Publish asset structure for everyone with permissions" switch.  
  5. Click the save button. 

Now published, your new asset structure is available in the platform asset browser when opened. Unpublished asset structures are only available for admins. 

Note: Multiple uploaded asset structures can be published and made available in the asset browser at any time.  

To reconfigure your asset structure:  

  1. Click on the three vertical dots located to the right of each asset structure row in the ContextHub. A small drop down menu appears.  
  2. Select "Configure asset structure". A side panel opens providing the CSV details of your asset structure. 
  3. Click on the small clock located right of the "Download" button.  

A "History" panel will open. This panel will list the uploads for this asset structure, associated times of uploads and whether it was successfully uploaded. Error files can be consulted here. You can close this panel using the "Close history" button at the base of the panel. 

To update the asset structure, simply  

  1. Alter the CSV file as necessary (see above). 
  2. Add the file to the side panel via the "Add attachment" option.  
  3. Click the "Save" button. 

Templates and the cross asset value based search

To indicate that different assets are similar and contain the same set of attributes, TrendMiner uses templates in the asset structure. 

In the CSV file you can add templates by adding them in the ‘template’ column. This displays them next to your assets in the asset browser and helps our searches and algorithms to give back better results in the future. 

The cross asset value based search is a TrendMiner search option that enables you to explore through similar assets and attributes that are predefined as part of a template.  

Having defined your templates and grouped your assets and attributes within the template column, you will be able to search through your assets and attributes in the form of groups, as opposed to individual datasets.  

The image directly below is an example of an asset file structure that contains the template name "BA Reactor". This particular template groups reactors 1, 2 and 3. Traditionally through the value based search you would need to save each individual reactor search for a particular value of interest, to then compare and contrast. With the cross asset value based search you can easily search through all reactor data by ensuring at the description level you group each reactor under the template, in this case, BA reactor. 


Note: The created template name must be consistent in its use. This means consistent spelling and case use.

Enjoying TrendMiner? Share your experience to help the community.
Rate TrendMiner