Import systems from Excel - Intergraph Smart 3D - Help

Intergraph Smart 3D Systems and Specifications

Language
English
Product
Intergraph Smart 3D
Subproduct
Systems and Specifications
Search by Category
Help
Smart 3D Version
12 (2018)
  1. Open Microsoft Excel, and modify the workbook file as needed.

  2. Save your changes, and exit Microsoft Excel.

  3. Open Smart 3D, and go to Systems and Specifications.

  4. Click Tools > Import Systems Hierarchy from Excel to display the Import Systems Hierarchy from Excel dialog.

  5. Specify the Excel file to import. The software delivers two sample Excel files, ImportData_Sample.xls and Pipelines_Sample.xls, locally to [Product Folder]\SystemsAndSpecs\Import as part of the default client setup.

  6. Make any additional changes as needed.

  7. Click Import for the software to begin reading data from the specified workbook. During the import process, data from the spreadsheet is compared against the Model database. If the system does not currently exist, then the new system is created. If the system exists in the Model database, then the existing system is updated.

  • Systems defined in the spreadsheet are created in the order that they are defined in the spreadsheet.

  • A log file is generated during the import process. This file indicates whether or not a row is imported successfully and specifies the reason for any failed imports.