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

Intergraph Smart Instrumentation Tutorial

Language
English
Product
Intergraph Smart Instrumentation
Search by Category
Training
Smart Instrumentation Version
13.1

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.

EDE View Main Window

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.

    EDE Column Sorting - Descending Order

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.

    EDE Grouping Columns

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.

SHARED Tip You can also use the standard CTRL + C and CTRL + V keyboard shortcuts to copy and paste your data.

  • A green border around the cell with the pasted data indicates that the copy/paste was successful.

  • An orange border around the cell, indicates the copy/paste process is in progress.

  • A red border around the cell indicates that the copy/paste was not successful. Placing the cursor over the destination cell displays a notification explaining why the paste failed.

Copying and pasting from one cell to a few cells:

  1. Select the cell with the data required.

  2. Use the right-click Copy shortcut to copy the selected information.

  3. Press and hold the CTRL key and select the target cells you want to copy.

  4. Use the right-click Paste shortcut to paste the selected information in the destination.

The same rules as with a one cell copy apply. A green or red border will give an indication of whether the process was a success or failed: Green indicates success, red indicates failure. An orange border indicates that the Paste action is still in progress.

Using the Search Box in the EDE Main Window

To search for specific data, type the text in the Search window. The EDE View automatically highlights the cells that include the text you typed in your search.

EDE Search Box