Excel 1D Import
Prior to performing
an import, download a configured Excel spreadsheet template for the equipment
type you want to import. Add your import data to the spreadsheet. See chapter
Downloading Excel spreadsheet templates.
-
In the menu bar, click Acquisition.
The Data Acquisition service opens.
-
Click
New
Import, and select
Excel from the pop up menu.
The New Excel Import page appears. At the top of the page, the new import is identified as a "New Excel Import" with the Type and Status indicated. The Information tab is activated for creation of the new import, and the Log tab is available to provide access to logs of the processed import.
- Click Browse to navigate to the file location where you select the Excel file you want to import.
-
Select the Excel file to import.
The Excel filename appears in the field below the Browse button.
- (Optional) Click to remove the selected file.
- Enter a Name and a Description. Name, allows you to specifically and uniquely name the import. Import naming conventions can be a useful tool in controlling and identifying imports. Description, allows for a more detailed definition of the import while keeping the name a more manageable size.
- Click to select an Excel Configuration for the equipment type you want to import.
- In the window Select Excel Configuration, select a configuration.
- Click Select.
-
Do one of the following:
You are returned to the main Data Acquisition page. The import State changes to indicate the process is "Running" or "Draft" depending upon which above option you choose.
When you select
Start import, and the import is successfully
completed, it is displayed in
All Imports and
Completed Imports tab. When completed the import
status changes to
"Complete". Additionally, an e-mail and a notification
is sent to advise the process is complete. The notification can be viewed in
the
PlantSight project Home page or in the
separate email sent.
To move your imported objects to the Digital Twin,
aggregate the import.