Import data from Excel - Intergraph Smart Isometrics Material Editor - Help - Hexagon PPM

Smart Isometrics Material Editor Help

Language
English
Product
Intergraph Smart Isometrics Material Editor
Search by Category
Help
Material Editor Version
2019 R1 (6.1)

You use the Import Material Data Dialog Box to specify the item code and description data to import into the software.

  1. Click Tools > Import Material Data.

  2. Specify the file that contains the item code and description data to import.

  3. Select the worksheet or range that contains the data import.

  4. In the Item code column, type the column in the worksheet that contains the item code data to import.

  5. Optionally, type the columns in the worksheet that contain the material descriptions and component types and group data to import.

  6. Click Import to import the specified data into the software.

    If the import is successful, the software displays a message.

  7. Click OK in the message box.

  • To import the data in the specified worksheet automatically each time you open the software, select the Import on startup box.

  • After you successfully import your data, the Item code and Description boxes in the Material Builder display as lists instead of ordinary text boxes. If the selected component type is associated with the imported data, the Item code and Description lists are populated with the corresponding data from the worksheet.

  • In Material Builder, if you select an item code in the Item codes list the software automatically displays the associated description in the Description list, presuming that one exists. Conversely, if you select a description, the software displays the associated item code.