Use this to import data from an Excel file into an interactive grid.
This option is not available in all grids.
-
Click Actions, from drop-down select Data Load > Import from Excel File.
-
Select the import file and click Open.
-
Alternatively, drag and drop the file into the grid.
To download a sample Excel file for the grid, proceed as follows.
-
Click Actions, from drop-down select Data Load > Download Sample Excel File.
The downloaded export.xlsx file can be used as template 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.