Describing the Common Sheets in the Workbooks - Intergraph Smart 3D - Reference Data

Intergraph Smart 3D Reference Data

Language
English
Product
Intergraph Smart 3D
Subproduct
Reference Data
Search by Category
Reference Data
Smart 3D Version
11 (2016)

The following sheets appear in most of the Excel workbooks, which are located in the [Product Folder]\CatalogData\BulkLoad\DataFiles folder on the administrator computer.

  • Revision History*

  • Legend*

  • Index*

  • Instructions*

  • Custom Interfaces

  • GUIDs

  • CatalogRoot

  • ClassNodeType

  • R-ClassNodeDescribes

  • R-Hierarchy

* The Bulkload utility does not process these sheets, so you can type any comments and information on them.

In addition to the common sheets, each Excel workbook contains unique sheets. Some of the unique sheets define classes of objects, and other unique sheets define tabular reference data, such as pipe specifications. No two sheets in the same workbook can have the same name.

  • You should not change the sheet name for the Custom Interfaces, R- ClassNodeDescribes, ClassNodeType, and GUIDs sheets.

Revision History

This sheet contains comments that describe modifications to the workbook, the person who made the modifications, and the date modified. Updates to this sheet are not mandatory, but they are recommended for internal tracking purposes. This sheet is not processed by the Bulkload utility. The text on this sheet is purely for the benefit of change tracking, notes, and revision records. For more information, see Revision History Sheet.

Legend

This sheet provides information about common conventions in the workbook. It lists the keywords and the associated meanings. This sheet is not processed by the Bulkload utility. For more information, see Legend Sheet.

Index

This sheet provides a list of all the classes in the workbook and links to each sheet. This sheet is not processed by the Bulkload utility. For more information, see Index Sheet.

Instructions

This sheet provides a list of prerequisite workbooks that must be loaded into the catalog first. This sheet is not processed by the Bulkload utility. For more information, see Instructions Sheet.

Custom Interfaces

This sheet defines user attributes that are in the reference data. This sheet describes the names of attributes, such as length and weight, and contains information about the units of measurement. The Custom Interfaces sheet also defines links between reference data parameters and parametric symbol arguments.

You can control whether the attributes are Read/Write or Read-Only. For more information about attribute access, see Controlling Access to Attributes.

For more information about custom interfaces and attributes, see Custom Interfaces Sheet. For more information about units of measurement, see Appendix: Units of Measure.

Custom Class Interface List

This sheet lists any additional virtual interfaces that will be implemented by non-virtual classes. During the bulkload process, these interfaces are mapped to the specified classes. For more information, see Custom Class Interface List Sheet.

GUIDs (Globally Unique Identifiers)

This sheet contains identification numbers for the part classes. For more information, see GUIDs Sheet.

The Custom Interfaces, Custom Class Interface List, and GUIDs sheets are metadata definition sheets. Familiarity with the metadata is important when copying objects between models with different catalogs.

CatalogRoot

This sheet defines the name of the root folder for the data in a workbook. The catalog root is the highest allowable level in the hierarchy for a discipline. For example, in the Equipment.xls workbook, the root folder is Equipment. This name appears in the Catalog task user interface. For more information, see CatalogRoot Sheet.

ClassNodeType

This sheet allows you to create classification folders in the Catalog hierarchy. A classification folder is similar to a folder in Windows Explorer, except a classification folder can only contain other folders, not individual items. The ObjectName column contains the folder object name, which represents the internal name for the node in the software. The Name column contains the identifier name that appears in the Catalog task user interface. An example is an item with V205 in the ObjectName column and Towers in the Name column. The Bulkload utility and internal catalog know the item by its object name, V205. The Catalog task user interface displays the item name as Towers.

The ClassNodeType sheet does not specify the hierarchy of the classification folders. For more information, see ClassNodeType Sheet.

R-ClassNodeDescribes

This sheet defines the parent-child relationships between the classification folders and the part classes. This sheet uses the object names of the classification folders and the names of the part classes. The RelationSource column contains the parents (classification folders), and the RelationDestination column contains the children (part classes). For example, the Pumps classification folder is the parent of a part class named Pump. For more information, see R-ClassNodeDescribes Sheet.

R-Hierarchy

This sheet defines the parent-child relationships among the folders in the Catalog hierarchy that are above the classification folders. This sheet uses the object names of the folders. For example, RefDataEquipmentRoot has a child named Pumps. This sheet does not define new classification folders or part classes. For more information, see R-Hierarchy Sheet.

See Also

Catalog Hierarchy Sheets
Adding Part Classes to the Catalog