Bulk load the database - Intergraph Smart 3D - 2019 - Administration

Intergraph Smart 3D PDMS Design and Data Exchange

Language
English
Product
Intergraph Smart 3D
Search by Category
Administration & Configuration
Smart 3D Version
12.1 (2019)

After running the validation tool, you must bulkload the PDMSPropertySchemaDefinition.xls workbook into the Smart 3D catalog. This bulkload is required to add the PDMS interfaces to the Smart 3D catalog, and to update the Smart 3D property dialog boxes with the PDMS category.

  • Perform this procedure on a computer with the Bulkload utility and Server Connectivity component installed. Log on with a user name that has database administrator privileges. For more information about necessary components, see the Intergraph Smartâ„¢ 3D Installation Guide. You can access the installation guide using the Help > Printable Guides command.

  • Close all Excel workbooks before starting the bulkload. Do not open Excel during the bulkload process.

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

    The Bulkload utility appears.

  2. In the Excel files box, click Add and navigate to the PDMSPropertySchemaDefinition.xls workbook.

    By default, the workbook is delivered to the [Reference Data Folder]\SharedContent\Data\Translators\PDMSS3DImport\ConfigurationFiles\Bulkloadables folder.

  3. In the Excel codelist files box, click Add and navigate to the PDMSPropertyCodeLists.xls workbook.

    • By default, the workbook is delivered to the [Reference Data Folder]\SharedContent\Data\Translators\PDMSS3DImport\ConfigurationFiles\Bulkloadables folder.

    • You must specify a workbook in this box if you are modifying the delivered codelist. In all other cases, you are not required to populate this box.

  4. Under Bulkload mode, select Append to existing catalog to add the new data to an existing database.

  5. In the Database server name list, select the server on which the catalog database resides.

  6. In the Database name list, select the name of the catalog database that you want to update with the new reference data.

  7. Select the Catalog Schema database name in the Schema database name box.

  8. In the Log file box, click Browse 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.

  9. Click Load.

    The software updates the catalog database with the required data. You can see progress messages in the status bar of the Bulkload utility as the bulkload operation runs.

  10. 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.

  11. Click Close.

  • You can modify the Excel workbooks, and then bulk load them again to correct errors.

  • Create a new log file for each bulkload operation, instead of overwriting the existing one. Check the log file for errors after each bulkload operation.

  • For more information about using the Bulkload utility, see Loading Reference Data into the Catalog in the Smart 3D Reference Guide available with the Help > Printable Guides command.