Data Load - Intergraph Smart Materials - 10.2 - Help - Hexagon

Use this to import data from an Excel file into an interactive grid.

This option is not available in all grids.

1. Click Actions, from drop-down select Data Load > Import from Excel File.

2. Select the import file and click Open.

3. Alternatively, drag and drop the file into the grid.

To download a sample Excel file for the grid, proceed as follows.

• To export existing data from the grid to an Excel file, click Actions, from drop-down select Data Load > Export to Excel File.

• To download an empty Excel template for future import tasks, click Actions, from drop-down select Data Load > Download Excel Template.

The downloaded template can be used for later imports into the grid. However, it is important to keep the structure of the downloaded file as it is, as otherwise it might give error while importing data to the grid. For example, for Packages data, it is important not to delete the PCK_OR_PP_ID column, even though this needs to be kept empty for all the rows added manually in the download file. If you delete this column, import process won't work. This column contains a unique ID for each package which is generated by the system.