Import equipment details from Excel - Intergraph Smart 3D - Help

Intergraph Smart 3D Equipment and Furnishings

PPMProduct
Intergraph Smart 3D
PPMCategory_custom
Help
SPFVersion_custom
2019 (10.0)
Version_S3D
12.1(2019)
  1. Click Tools > Import/Export Equipment with Excel.

    The software opens the Import/Export Equipment with Excel dialog box.

  2. Use Folder Location to specify the path to the folder that contains the equipment details to import. Type the full path location in the box, or use the browse feature to navigate to the folder location.

    The dialog box lists the Excel workbooks that reside in the specified folder.

  3. Select the workbook to use as input from the list. The Excel input file uses the same format as the EquipmentTemplate.xls file delivered with the software. For more information, see Equipment template workbook format in Import and Export Equipment with Excel.

  4. Click Load Equipment .

    The software reads the contents of the Excel file, and then performs the specified Add/Modify/Delete actions. When processing completes, the software displays a summary of the processing results.

  5. Click OK to close the message box.

  6. To save the Excel workbook folder location to the session preferences, click OK in the dialog box.
    -OR-
    To close the dialog box without adding the folder path, click Cancel.

  • The software writes the results of the import process in the Status column of the input Excel file.

  • If an error occurs during the placement, modification, or deletion of an equipment object, the software records an error in the Status column of the input Excel file. For additional information about the error, review the More Info column.

  • The software stores all user-selected folder paths that have been saved in the current session and displays them in the Folder Location list.

  • After the software loads the equipment from the Excel workbook, you can use Undo to reverse the modifications made to the model.