Excel Import Wizard - SmartPlant Foundation - IM Update 48 - Help - Hexagon

SmartPlant Foundation Help

Language
English
Product
SmartPlant Foundation
Search by Category
Help
SmartPlant Foundation / SDx Version
10
SmartPlant Markup Plus Version
10.0 (2019)
Smart Review Version
2020 (15.0)

Allows you to load data created or edited in a Microsoft Excel spreadsheet, compare the data with existing data, create a new document with the same name as that of the Excel file from which the data is being loaded, and attach files to that document.

Excel file - Selects the Excel file to import. Click SPF DTC BTN Browser to select the file.

You can import a Microsoft Excel 97-2003 spreadsheet (.xls) or Microsoft Excel macro-enabled spreadsheet (.xlsm) or Excel Microsoft Office Open XML spreadsheet (.xlsx).

Template - Selects the template document to use when importing an Excel file. Click SPF DTC BTN Browser to select the file.

Import Document - Stores the spreadsheet in SmartPlant Foundation attached to a new document that is named after the spreadsheet. You can change the name in the new document form if required.

Run Compare - Compares the data in the Excel file to the existing SmartPlant Foundation database. If Import Document is not also selected, the Compare Scope options are enabled to indicate if the compare should be done by object or by a selectable Container ID. A View window appears showing the comparison results between the imported data and the data that already exists in SmartPlant Foundation.

Add objects to New Items window - Places objects imported from the Excel file into the New Items window.

Main Details

Name - Creates a document with the name specified.

Description - Creates a document with the description specified.

Details

Title - Creates a document with the title specified.

Status - Creates a document with the configured status. This is configured as a read-only field by default.

Owning Group

Item owning group – Associates the selected owning group to the document being created.

Revision Details Section

Revision scheme - Creates the document with the selected Revision Scheme.

Major Revision - Creates the document with the Major revision specified. By default, this file is automatically populated based on the selected Revision Scheme.

Minor Revision - Creates the document with the Minor revision specified. By default, this is automatically populated based on the selected Revision Scheme.