Use the Piping Reference Data Merge Utility - Intergraph Smart 3D - Reference Data

Intergraph Smart 3D Reference Data

Language
English
Product
Intergraph Smart 3D
Subproduct
Reference Data
Search by Category
Reference Data
Smart 3D Version
12.1 (2019)

Before running the Piping Reference Data Spreadsheet Merge Utility, you must convert at least two PDS specifications using the PDS translator. The conversion results in one specification workbook and one catalog workbook per spec. The Piping Reference Data Spreadsheet Merge Utility merges catalog (part) workbooks.

  1. In Windows Explorer, navigate to the software installation folder.

  2. Under [Product Folder]\CatalogData\PDSTranslator\Bin, double-click PipingReferenceDataMergeUtility.exe.

    SHARED Tip The Workstation setup includes the PDSTranslator folder only if you have specified the Project Management option during installation.

  3. In the Input Excel Files location box, browse and select the location that stores the files to merge.

  4. In the Output Excel file box, browse and select the Excel workbook (.XLS format) that will contain the merged data.

  5. In the Log file box, browse to the location where you want the log file stored.

  6. Click Start. As the utility processes the files, you can view the status messages on the dialog. After completion, Finished displays on the dialog.

  • The output workbook includes a Sheet1 worksheet. You can remove this sheet and save the workbook before bulk loading. Not removing it does not impact the load, although a message is printed in the log file.

  • Worksheets unique to a specific source workbook are copied to the new output workbook.

  • In the case of worksheets that are common to all the input workbooks, unique data records (rows) are included in the output.

  • In the case of worksheets that are common to all input workbooks, if data is duplicated, then the data from the first worksheet is taken. The utility ignores duplicate data from the subsequent common worksheets.

See Also

Using the Piping Reference Data Merge Utility