Create a Custom Catalog Database - Intergraph Smart 3D - Reference Data

Intergraph Smart 3D Structural Manufacturing Reference Data

PPMProductFamily
3D Design and Visualization
PPMProduct
Intergraph Smart 3D
PPMCategory
Reference Data
Version_S3D
12.x(2018)

The testing catalog that is delivered with the software provides a general starter set of reference data. As you customize this starter set to match your own needs and practices, those changes should be bulkloaded into a custom database.

The custom Catalog is created using spreadsheets. These spreadsheets are then bulkloaded into a database using the Bulkload utility.

Bulkload

The Bulkload utility loads data into the database. It reads spreadsheets and uses them to create rows of data in the Catalog database. By default, the Bulkload utility is delivered to the [Product Folder]\CatalogData\Bulkload\Bin\Bulkload.exe file. When you use the Bulkload utility, you perform the following tasks:

  1. Specify the Bulkload files to load.

  2. Specify the Codelist files to load.

  3. Select the mode to use. You can select from the following:

    • Create a new Catalog database.

    • Append files to an existing Catalog database to create new classes

    • Add, modify, or delete items. This option does not create new classes

    • Delete and replace classes in an existing Catalog database. This option does not create new classes.

  4. Select the server and catalog schema.

  5. Specify a file for the resulting database.

  • Specify the codelist spreadsheets in the Excel codelist files box. Specify all the other spreadsheets in the Excel files box.

  • Create a new log for each file that you bulkload. Do not overwrite the existing log file.

  • Check the log file for errors after each bulkload.

  • Backup your data often. Should an error occur, it is easy to restore and correct the error if you have a current backup.

Create a Custom Catalog

To create a new Catalog database, perform the following tasks:

  1. Restore a new Catalog database.

  2. Update the Catalog Schema database.

  3. Create a new Model database.

  4. Bulkload the Molded Forms spreadsheets.

  5. Bulkload the Structural Detailing spreadsheets.

  6. Bulkload the Level 4 spreadsheets.

Restore a Catalog Database

Start the Smart 3D Database Wizard. You can either select an existing Site database, or you can create a new one. Select the Site and Schema to contain the new Catalog database.

Update the Catalog Schema database

Restore the delivered catalogdb.dat file. This loads the basic SmartPlant 3D® reference data with no Smart 3D data. The delivered catalogdb.dat file creates both a Catalog database and a Catalog Schema database. The Catalog Schema database must be updated to add Smart 3D tables.

Use the UpdateSchemaandDB.exe utility to add registered Smart 3D data to the schema database. By default, this utility is delivered to the [Product Folder]\ProjectMgmt\Tool\Bin\UpdateSchemaandDB.exe file.

To use this utility, do the following:

  1. Start the utility.

  2. Select the server and Schema database.

  3. Click Check Version.

  4. Click Update Schema.

  5. When the update completes, click Update BOC.

  6. Close the dialog box.

Create a Model Database

To test the custom Catalog, you must create a Model that points to the Catalog and Catalog Schema databases. To create the model, do the following:

  1. Start the Project environment.

  2. Click Database > New > Ship.

  3. Type a name for the project.

  4. Select the customized Catalog, and then type information for the new Model and Reports databases.

Bulkload Ship Catalog Data

Ship drawings data is additional Smart 3D data appended to SmartPlant 3D data. The data is dependent upon rules. You must register all of the custom .DLL files on the computer before you bulkload the data.

Bulkload the following ship catalog data files in Append mode. By default, these files are delivered to the [Product Folder]\ShipCatalogData\Bulkload\DataFiles\Add_Marine folder.

HangersAndSupports.xls

This file contains Smart 3D hanger and support filters.

SM_Reports.xls

This file contains Smart 3D report templates.

Bulkload Molded Forms Data

You must bulkload Molded Forms data in a specific order. The files containing codelists must be listed in the Codelist box. The Molded Forms bulkload files are delivered by default to the [Product Folder]\ShipCatalogData\Bulkload\Datafiles folder.

  1. Bulkload the following files in Append mode:

    • SM_SRDHierarchy.xls - This file contains default continuity values, default molded conventions, and structural specifications.

    • SM_StructCommon.xls - This file contains material and thickness for plates and profiles and custom profile bit maps.

    • AllShipCodeLists.xls - This file must be listed in the Codelist box. It contains codelists to support the Molded Forms task.

  2. Bulkload the following files in Append mode:

    • SM_BracketEdgeContours.xls - This file contains the tripping bracket rules and symbols. By default, this file is delivered to the [Product Folder]\StructDetail\Data\BulkloadFiles folder.

    • SM_StructXsections.xls - This file contains profile cross section symbols.

    • SM_ShipCheckMftcyRules.xls - This file contains manufacturability rules.

    • SM_SRDNamingRules.xls - This file contains molded forms naming rules.

    • SRDQueries.xls - This file contains the required classes for reporting.

    • SM_ProfileKnuckleRules.xls - This file contains knuckled profile rules.

    • SM_TOffsetRules.xls - This file contains tripping bracket offset rules.

Bulkload Structural Detailing Data

Structural Detailing data is dependent on Visual Basic rules. You must register the .DLL files that are listed in the spreadsheet. You can bulkload all of the Structural Detailing spreadsheets at the same time. By default, the Structural Detailing spreadsheets are delivered to the [Product Folder]\ShipCatalogData\bulkload\DataFiles\StructDetail folder.

Bulkload the following files in Append mode:

SM_SRDAssyConnection.xls

This file contains assembly connection rule.

SRDBoardMgtRules.xls

This file contains Board Management rules.

SM_SRDBracket.xls

This file contains bracket rules and symbols.

SM_SRDConstDetailsClips.xls

This file contains clip and collar rules and symbols.

SM_SRDConstDetailsEndCuts.xls

This file contains the end cut rules and symbols.

SM_SRDFreeEndCuts.xls

This file contains free end cut rules and symbols

SM_SRDConstDetailsSlots.xls

This file contains the slot rules and symbols.

SM_SRDCornerFeature.xls

This file contains the corner feature rules and symbols.

CornerFeatureRules.xls

This file contains the multi-corner feature rules.

SM_SRDEdgeFeature.xls

This file contains the edge feature rules and symbols.

SM_SRDPlateChamfer.xls

This file contains the chamfer rules and symbols.

SRDSketchedFeatures.xls

This file contains sketched feature symbols.

SM_SRDWelds.xls

This file contains the physical connection rules.

AllShipCodelistsStructDetails.xls

This file must be listed in the Codelist box. It contains codelists to support the Structural Detailing task.

Bulkload Structural Manufacturing Data

Structural manufacturing data is not needed to test Structural Detailing, but loading the full catalog allows you to test the interaction between Structural Detailing and Structural Manufacturing tasks. The addition data is dependent upon rules. You must register all of the custom .DLL files on the computer before you bulkload this data.

Bulkload the following Structural Manufacturing files in Append mode. By default, these files are delivered to the [Product Folder]\ShipCatalogData\BulkLoad\DataFiles\StructManufacturing folder.

AllStructMfgCodeLists.xls

This file must be listed in the Codelist box. It contains codelists to support the Structural Manufacturing task.

StructMfgCustomClasses.xls

This file contains interface attributes required for using the Swage Plate part.

StructMfgLabel.xls

This file contains report label information for all of the structural manufacturing entities. It describes a list of available Tooltips.

StructMfgNamingRules.xls

This file contains default naming rules for all of the structural manufacturing entities.

StructMfgNesting.xls

This file contains the special attribute NestBlock to track the existence of a given object when it is moved between blocks.

StructMfgProcessAndMarking.xls

This file contains manufacturing process and marking rules for templates, plates, profiles, and members.

StructMfgReports.xls

This file contains report template for all Structural Manufacturing entities.

StructMfgSettings.xls

This file contains rules for frame system service, shrinkage, margin, pin jig, template naming, migration rules and output command service (Part Monitor and Output Command).

StructMfgSymbols.xls

This file contains feature and weld tab symbols.

Bulkload Planning Data

Planning data is not needed to test Structural Detailing, but loading the full catalog allows you to test the interaction between Structural Detailing and Planning tasks. The data is dependent upon rules. You must register all of the custom .DLL files on the computer before you bulkload the data.

Bulkload the following Planning files in Append mode. By default these files are delivered to the [Product Folder]\ShipCatalogData\BulkLoad\DataFiles\Planning folder.

AllPlanningCodeLists.xls

This file must be listed in the Codelist box. It contains codelists to support the Planning task.

PlanningCusomClasses.xls

This file contains build method and slot connectivity custom class attributes that are assigned to planning items.

PlanningEqipment.xls

This file contains attributes for shop equipment, such as cranes, jig floors, and welding equipment.

Jig Tip Types

Pin jig height depends on the jig tip type. If you do not specify a pin jig using the Jig Tip Type property, the software uses the Default Jig Tip (cone).

1 - Pin interval

2 - Part surface

3 - Pin height with jig tip

4 - Pin height without jig tip

No Jig Tip - The pin touches the supported surface of the plate as shown in the graphic below.

1 - Side view of pin jigs

2 - Supported surface

3 - Pin jig

4 - Default jig tip

5 - No jig tip

PlanningJoints.xls

This file contains planning joint (such as connection) rules and symbols.

PlanningNamingRules.xls

This file contains block, assembly, and planning joint naming rules.

PlanningReports.xls

This file contains the report template for Planning entities.

SM_PlanningRules.xls

This file contains the general planning rules, including Block Assignment.

PlanningWorkcenters.xls

This file contains attributes for shop workcenters.

Bulkload Hole Management Data

Hole Management data is not needed to test Structural Detailing, but loading the full catalog allows you to test the interaction between Structural Detailing and Hole Management tasks. The data is dependent upon rules. You must register all of the custom .DLL files on the computer before you bulkload the data.

Bulkload the following Hole Management files in Append mode. By default, these files are delivered to the [Product Folder]\ShipCatalogData\BulkLoad\DataFiles\HoleMgmt folder.

AllHoleMgtCodelists.xls

This file must be listed in the Codelist box. It contains codelists to support the Hole Management task.

HoleMgmtRules.xls

This file contains hole fitting clearance and selection rules.

HoleMgtEquipment.xls

This file contains rules and symbols for equipment (such as parts) assigned to holes, such as sleeves, coamings, and doors.

HoleMgtHoleTraces.xls

This file contains hole trace rules and symbols.

Bulkload Ship Drawings Data

Ship Drawings data is not needed to test Structural Detailing, but loading the full catalog allows you to test the interaction between Structural Detailing and Ship Drawings tasks. The data is dependent upon rules. You must register all of the custom .DLL files on the computer before you bulkload the data.

Bulkload the following Ship Drawings files in Append mode. By default, these files are delivered to the [Product Folder]\ShipCatalogData\BulkLoad\DataFiles\ShipDrawings folder.

AllShipDrawingsCodeLists.xls

This file must be listed in the Codelist box. It contains codelists to support the Ship Drawings task.

ShipDrawings.xls

This file contains ship drawing rules and symbols.

ShipDwgReports.xls

This file contains ship drawing reports templates.

After you successfully complete the bulkload process, you can view the custom data through the Catalog Browser.

See Also

Database Interaction