Editable Grid - Intergraph Smart 3D - Help

Intergraph Smart 3D Catalog

Intergraph Smart 3D
12.1 (2019)

In previous versions of the software, specification writers and other project administrators used Microsoft Excel to modify all the delivered reference data and then used the Bulkload Utility for any additions, modifications, and deletions into the Catalog database. The Catalog task was read-only, except for the capability to modify permission group and status on the Properties dialog for certain reference data.

In this software release, you can use the Catalog task to create and manage piping, equipment, structure, and electrical reference data, as well as select lists, interfaces, and properties. You can toggle the content view between a read-only list view and an editable grid view.

A third view option is available when you review branch table data, reinforcing weld data, and reinforcing pad data in human specification format. For more information, see Using the Branch Table.

The editable grid view provides additional functionality for creating and editing reference data, such as embedded lists and configurable columns:

Using the Catalog task to create and manage reference data provides several significant advantages over the Excel and bulkload workflow:

  • Create and modify data directly in the database.

  • Multiple users can create and modify reference data simultaneously.

  • Verification of some real-time data as you enter it into the editable grid, as well as provide an interactive interface for correcting inconsistencies in related data in other tables.

  • Drop-down lists display appropriate select list values for properties.

  • Set the Industry Practice property (ASCII, DIN, JIS, U.S. Practice, and so on) to filter all select lists in the Catalog database.

  • Add values to existing select lists while entering specification data.

  • Use the Branch Table to enter information in a format that is consistent with the human spec.

  • Automatic creation of commodity codes as you enter part data, including a special user interface for building and selecting commodity codes based on property values of the part.

Except for piping parts, piping specifications, piping rules, instruments, piping specialty data, conduit parts and specifications, cableway specifications, cabletray parts and specifications, there is no mechanism for exporting your reference data from the Catalog database back into a Microsoft Excel workbook. Consequently, if you intend to use the Bulkload Utility in tangent with the editing capabilities in the Catalog task, we recommend that you implement a workflow that keeps the data in the Excel workbooks synchronized with the changes you make in the Catalog task. For more information about the Excel workbooks delivered with the software, see Smart 3D Reference Data.

See Also

Insert Row Command
Save Command
Select Lists
Piping Rules