Import Systems Hierarchy from Excel Command - Intergraph Smart 3D - Help

Intergraph Smart 3D Systems and Specifications

Language
English
Product
Intergraph Smart 3D
Subproduct
Systems and Specifications
Search by Category
Help
Smart 3D Version
12 (2018)

Creates systems and a system hierarchy based on data from a Microsoft Excel workbook. You can create any type of system. Each system class can have its own set of properties, either default or user-defined.

The software provides an import utility that allows you to create systems for your model by reading data from a Microsoft Excel workbook. When you install the software, two sample workbooks are delivered locally to [Product Folder]\SystemsAndSpecs\Import as part of the default client setup. These workbooks contain sample template worksheets and sample system data sheets. Each of these worksheets can be modified to reflect the appropriate property values, the system parent, and the allowed specifications for each system you create.

Each system that you create requires a unique set of properties that includes the software-required properties as defined in the reference data. The workbooks use a different sheet for each different system type. Each column in a particular sheet corresponds to a property.

The import utility is on the Tools menu. Before starting the import process, you are prompted to specify a Microsoft Excel workbook to process. The utility reads data from the workbook and either creates a new system or updates an existing system, as is explained in the following:

  • Data from the workbook is compared against the Model database, and if the system does not currently exist in the database, the new system is created.

  • If the system already exists, the existing system is updated.

Systems defined in the workbook are created in the order in which they are defined in the workbook. In turn, each sheet in the workbook is completely processed before the next sheet. On individual sheets, rows are processed in order (from the top down).

In order to function properly, the parent system is created before the child. For example, the following system types would be on different sheets:

  • Units

  • Piping Systems

  • Piping Systems (sub-systems)

  • Pipelines

The following illustration demonstrates the need for providing an absolute parent tree when specifying the parent system in the workbook.

In this illustration, if you want to update Pipeline P1, the parent path up to the unit level is required (Parent system=SS1/S1/U1). If you want to update Pipeline P11, the path required to find a unique Parent system is SS5.

Leaving the Allowed Specifications field blank causes the system to use the same values as the Parent system; otherwise, filling in values will set the specifications. For example, if you want to add Pipeline 23 to Piping system SS5 but do not specify an allowed specification, the system sets the allowed specification of Pipeline 23 to the same values as the Parent system (SS5).

Import Systems Hierarchy from Excel Dialog

See Also

ImportData_Sample Workbook

Pipelines_Sample Workbook