Saved Search Setup and Export to Excel

The standard Search feature can be used to configure a search which returns, in a grid, the attributes required to generate a line list.

To access the Search Utility, if not already open, select Search from the View menu.

Create a search with the following criteria:

Item Type: SCPLIN

In Database: Schematic

Execute the search by selecting the Search option:

The Search Results grid will be displayed.

Right-click on a column heading, and from the right click menu that is then displayed, select Column Setup…

The Column Setup dialog is then displayed. Enter the following columns:

Select the Create "Saved Search" Based on Current Search Criteria option. Give the search a meaningful name, in this example "Example Line List" is used.

Run the saved search. The search results will be displayed.

These will include the LLFROM and LLTO derived values, including "Butt Welded Pipe Cap" where appropriate.

To export the example line list to Microsoft Excel, right-click on a column heading, and from the right-click menu that is then displayed, select Export to Excel...

A Save As dialog will then be displayed. Enter meaningful name for the exported line list, in this example "Line List" is used.

The saved search results will then be exported to an Excel spreadsheet file.

The file will contain your line list data, including your defined column headings, and some default formatting.