Task 3 - Manipulating the Data in the EDE View - Intergraph Smart Instrumentation - Training - Intergraph Process, Power & Marine Documentation

Intergraph Smart Instrumentation Tutorial

PPMProductFamily
Engineering and Schematics
PPMProduct
Intergraph Smart Instrumentation
PPMCategory
Training
Version_SPI_custom
2018 (12.0)

To open an EDE View, you need to open the Engineering Data Editor. Click on the , from the main toolbar.

All your EDE Views are listed in the EDE Explorer. The EDE View is displayed in a grid format, and the data is presented in a column layout. You can edit, sort, and filter the data in the columns. On the left side, a View Actions tab opens with each EDE View, containing the properties of the data currently displayed in the main page. The tab is divided into three sections: Layout History, Tree View, and a Search Box.

In this task you will learn to perform a number of actions on the grid. For example:

  • Sort data in their columns

  • Applying filters to columns

  • Grouping columns

  • Copy/Paste data from column to column

  • Search functionality for specific data

The EDE Window with the Instrument Relations EDE View and the View Actions tab.


Sorting Columns in the EDE Grid View

You can sort a column or number of columns in an ascending or descending order.

  1. To sort the column in an ascending order, click on the column header.

  2. Click the Instrument Name header of the column to sort. The small blue arrow in the column header indicates sorting direction.

  3. Click Instrument Name header again to reverse the order.

  4. Click it a third time to return to the original item position in the column.

  5. To sort by more than one column, press the Shift key and click several columns.

Applying Filters in the EDE Grid View

  1. To filter your data, click the funnel icon next to a column header name, in our case it's Loop Name. A filtered column has a blue colored funnel icon.

    A filter dialog box opens next to the column you want to filter, composed of two sections.

  2. In the Filter dialog box do one of the following:

    • From the list, check the-box for 101-F-100, under the Loop Name to see the immediate filtered results in the EDE main window.

    • From the bottom section, you define the filter you want based on certain criteria you select. On column Loop Name, select Contains from the Show rows with value that drop-down, enter T in the field under the drop down.

  3. Click the Filter button to generate the filter.

  • Practice the Filter utility on other columns.

  • When done, clear all filters before proceeding.

Grouping Columns in the Grid

To group your data by a specific attribute, drag the column header to the Group by area where it says "Drag a column header and drop it here to group by that column", and drop it in order to group by this column. In our case we dragged the Loop Name header to the Grouped by area.

  • Practice dragging a column header to the Grouped by: area, to see the layout of the grid change accordingly.

When done, remove any item grouping by hovering over the attribute name in the Grouped by section. , and selecting the X next to the name.

The Copying and Pasting Command

You can copy and paste information between cells in the same EDE view or between different EDE Views.

  1. In the EDE Actions Explorer, type INSTRUMENT SERVICE in the search bar.

  2. Drag the Property Instrument Service from the Explorer next to the Instrument Name column in the EDE Grid view with Column Order 2 and drop. After a brief update you should see the view refresh showing the data from this newly added column.

  3. Scroll down and locate the tags for loop 101-F -201.

  4. Select the cell in the Instrument Service column next to 101-FE -201 and enter the text STRIPPING STEAM TO F-102 and hit Enter.

  5. Return to the cell with the Instrument Service for 101-FE -201, right-click, and select Copy from the shortcut menu.

    The cell will become darker and have a dashed border around the contents.

  6. Select the cell that is the destination for the pasted data, in this case the Instrument Service for 101-FT -201 (directly below). Right-click on the cell, and from the shortcut menu, select Paste.