GUIDs Sheet - Intergraph Smart 3D - Reference Data - Hexagon PPM

Intergraph Smart 3D Reference Data

Language
English
Product
Intergraph Smart 3D
Subproduct
Reference Data
Search by Category
Reference Data
Smart 3D Version
13

The GUIDs sheet contains Globally Unique Identifiers, which are registry identifiers. The GUIDs are visible only in the Excel workbooks; the GUIDs do not appear on the user interface in the software.

GUIDs create a connection between part classes in reference data and the occurrences created in the model from those part classes. For example, when you delete a part class, redefine it, and bulk load the new definition, you should keep the old GUID if you want any previously-created occurrences in the model to be connected to the new part class definition in reference data.

GUIDs are also used when you bulk load a spreadsheet to another, new catalog. The GUIDs for the objects in the new catalog are exactly the same as those in the original catalog. 

The GUIDs sheet records the GUIDs used when bulkloading the spreadsheet the first time. This sheet is specific to a particular workbook and contains only those GUIDs of the user classes and interfaces in that workbook.

GUIDs are stored so that you can replace a Catalog database during a project. The replacement catalog must have the same name and location as the previous catalog. The GUIDs sheet prevents a replacement Catalog database from causing existing models to become invalid. If the GUIDs were not saved, this situation would be impossible because the Catalog and Model databases share the same schema.

Two utilities generate GUIDs: the Database Wizard and the Bulkload utility. The Database Wizard generates GUIDs when creating the Catalog database set from the delivered catalogdb.dat (for MSSQL) or catalogdb.dmp (for Oracle) file. The Bulkload utility generates GUIDs when creating a new Catalog database set using the New mode. When the Bulkload utility creates new GUIDs, it uses Excel to write these values to the workbooks.

The catalogdb.dat (for MSSQL) or catalogdb.dmp (for Oracle) template files contain sample Smart 3D reference data and, while they contain many useful examples, they are not certified for production use by Hexagon PPM.

After you have bulk loaded a catalog using Excel workbooks, you must not modify the GUID entries in the workbooks used to create the live database. Only the Bulkload utility should change data on a GUIDs sheet that is linked to a live Catalog database.

You must not manually modify any generated GUIDs.

Class/InterfaceName

Lists the part class names and interface names of the classes defined in the workbook. Custom interfaces are defined on the Custom Interfaces sheet.

PackageName

Lists the packages, if applicable, for the class and interface names.

GUID

Contains GUIDs for the part class occurrences and interface occurrences in the model. The software identifies an occurrence by this GUID when you place an object in the model.

AttributeName

Lists the user attribute names. This column is applicable only to those user interfaces for which user attributes have been defined. The column is empty for user classes.

DispID

Lists the DispIDs for the user attributes. This column is applicable only to those user interfaces for which user attributes have been defined. The column is empty for user classes.

The AttributeName and DispId columns are necessary for achieving metadata consistency between multiple catalogs.