Bulk Load Database with Data - Intergraph Smart 3D - Reference Data - Hexagon PPM

Intergraph Smart 3D 2D Symbols

Language
English
Product
Intergraph Smart 3D
Subproduct
2D Symbols
Search by Category
Reference Data
Smart 3D Version
13.1
SmartSketch Version
11

  • You should back up all Excel workbooks before modifying them and bulk loading. All of the workbooks are delivered with read-only properties.

  • When you use the Bulkload utility to create a new Catalog, the Excel workbooks for the Hangers and Supports task must appear last in the list. If they are not placed at the end of the input files list, errors will be generated in the log file.

  • Do this procedure on a workstation computer with the Bulkload component and Server Connectivity component installed. Log on with a user name that has database ownership privileges. For more information about necessary components, see the Installation Guide available from the Help > Printable Guides command in the software.

  • You should close all Excel workbooks before starting the bulkload. Do not open Excel during the bulkload.

  1. Click Start > Programs > Intergraph Smart 3D > Database Tools > Bulkload Reference Data.

  2. In the Excel files box, specify the Excel workbooks to load by clicking Add.

    • The default location for reference data workbooks is [Product Folder]\CatalogData\BulkLoad\DataFiles.

    • You can select more than one workbook to bulk load. Hold CTRL and click each workbook in the Open dialog box.

    • Select the workbooks that contain the parts and cross sections in the Excel files box. You specify the codelist workbooks in the Excel codelist files box.

  3. In the Excel codelist files box, click the browse button to specify the codelist workbooks.

    SHARED Tip You must specify a workbook in this box if you are creating a new catalog, adding a new codelist, or modifying an existing codelist. In all other cases, you are not required to populate this box.

  4. Under Bulkload mode, select a mode for the bulkloading process.

    Bulk load to a new catalog - Creates a new catalog database.

    Append to existing catalog - Adds new classes only to an existing database.

    Add, modify, or delete records in existing catalog - Reads flags in the Excel workbook to add, modify, or delete data.

    Delete and replace - Deletes all records in the Catalog database and replaces them with data in the Excel workbooks. New part classes are appended to the Catalog.

  5. If you want to store geometry for each unique part defined by the Solid Edge model, select Create flavors.

    • Do not select Create flavors when you are creating symbols.

    • The Create flavors option can increase the time needed for the bulkload process. If you are loading Solid Edge flavors, you must have Solid Edge installed on the bulkload computer.

  6. Under Catalog information, select either MSSQL or ORACLE in the Database Type box. This box is enabled only if you are creating a new database set.

    • If you selected MSSQL, select the name of a server in the Database server name box. This location is where the Catalog database and schema are stored (or will be stored, if you are creating a new database set).

    • If you selected ORACLE, select the name of the Oracle net service for the Catalog database connection in the Oracle Service box. The service must exist before you choose it in this box.

  7. In the Database name box, select the name of the Catalog database that you want to update with new reference data.

    • To create a new database, select <New Database>, and type a name for the new database. You must not start the name with a digit.

    • If you select a site or model database in the Database name box, the utility displays a notification message.

  8. If you are modifying an existing catalog, select the Catalog Schema database name in the Schema database name box.

    SHARED Tip The Schema server name box is read-only. The software completes this box with the name of the database server that you selected in the Database server name box.

  9. If you are creating a new catalog, click the browse button beside the Template file to be used to create schema box to specify the template file for the Catalog Schema.

    • For MSSQL, use the apprepos.dat file to create the Catalog Schema. This file is located in [Product Folder]\DatabaseTemplates on the server computer.

    • For ORACLE, use the apprepos.dmp file to create the Catalog Schema. This file is located in [Product Folder]\DatabaseTemplates on the server computer.

  10. In the Log file box, click the browse button to specify the name and location of the log file.

    • The default location for the log file is [Product Folder]\CatalogData\BulkLoad\DataFiles, but you can change this location.

    • You must have write privileges to the folder in which you are saving the log file.

    • The log file name must not contain any special characters. However, you can use the back slash when specifying a UNC path to a log file.

    • You must use the file extension .log for the log file.

  11. If you are bulk loading to a new catalog, click the browse button under Symbol and custom program file location and select a shared symbol folder on the server.

    • This box is populated automatically if you are using the Append, Add/Modify/Delete, or Delete and Replace modes. You should not modify the location unless you are sure that you want to change the symbol path for the catalog.

    • To allow all workstations to access the symbols, specify a UNC path to a shared folder on a remote computer, such as the server. The server setup installs the contents of the SharedContent folder under [Product Folder]\CatalogData, so if the computer name is smith, you can type \\smith\SharedContent. At a minimum, you need read access to this share. You need change access in order to modify the symbols.

  12. Click Load. You can see messages in the status bar of the Bulkload utility while it is running.

    SHARED Tip If you interrupt the bulkloading process, you may see a Switch To/Retry message. Click Switch To to return to the bulkloading process.

  13. Open the log file to check for any errors or warnings in the bulkloading process. You can quickly scan the Error Analysis section at the end of the log file to check for errors.

  14. Click Close.

    You can modify the Excel workbooks and bulk load again to correct errors.