Retrieve elements by browsing
- Last UpdatedJan 11, 2023
- 2 minute read
- PI System
- PI Server 2024 R2
- PI Server
Before you can retrieve elements, you need to Specify a database.
You can use PI Builder to browse the element hierarchy in a PI AF database, and then select an element to retrieve into Microsoft Excel.
-
On the PI Builder tab, click Elements > Browse Elements to open the Element Browser window.
-
Navigate the element hierarchy by expanding parent elements.
-
Select the element you want to retrieve into your worksheet and click OK.
-
In the Select Object Types and Column Headers window, select the objects and column headers that you want to appear in the worksheet.
Note: Use the Template field to retrieve attributes from a template. The attributes defined by the selected template are displayed in the Attributes Columns (from Template 'name') group in the Object Types list.
If you want to retrieve:
Then:
Elements from all levels of the hierarchy into the worksheet
Select the Child Elements check box from the Object Types list.
Information about references to other elements
Select the Element References check box from the Object Types list.
Attributes into separate rows
Select columns in the Attribute group.
With attributes shown in rows, you can edit information about the attributes. See Show attributes in rows.
Attributes in multiple columns
Select columns in the Attribute Columns group.
With attributes shown in columns, you can only edit the attribute value or configuration string. See Show attributes in columns.
Analyses for the elements
Select columns in the Analysis group.
See Element columns for a list of available columns for elements.
-
Click OK to retrieve the selected element into the worksheet and populate the selected columns with any data for that element.