Add the PDMS interfaces to the catalog - Intergraph Smart 3D - 13 - Administration & Configuration - Hexagon PPM

Intergraph Smart 3D PDMS Conversion to Smart 3D

Language
English
Product
Intergraph Smart 3D
Search by Category
Administration & Configuration
Smart 3D Version
13
Smart Interop Publisher Version
16

Before you start

  • 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. See the Intergraph Smart 3D Installation Help.

  • 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 to open the Bulkload utility.

  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 [Reference Data Folder]\SharedContent\Data\Translators\PDMSS3DImport\ConfigurationFiles\Bulkloadables\PDMSPropertyCodeLists.xls workbook.

    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. Select Append to existing catalog under Bulkload mode to add the new data to an existing database.

  5. Select the server on which the catalog database resides from the Database server name list.

  6. Select the name of the catalog database that you want to update with the new reference data from the Database name list.

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

  8. Click Browse Browse ... ICON in the Log file box to navigate to 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 to update the catalog database with the required data. You can view 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 Help.