Retrieve all elements

Before you can retrieve all elements, you need to Specify a database.

You can use PI Builder to retrieve all elements from a PI AF database into Microsoft Excel.

Note: This operation can be lengthy if your PI AF database contains a large number of elements. Furthermore, current versions of Microsoft Excel support 1,048,576 rows. If you attempt to retrieve a large number of elements along with their attributes, analyses, and extended properties, you might reach the Excel row limit and produce an error.

1. On the PI Builder tab, click Elements > All Elements.

2. 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.

3. Click OK to retrieve the elements into the worksheet and fill the selected columns with any data for the elements.