Use this to import data from an Excel 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-->Download.
-
Select CSV.
-
Click Download.
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.
-
HXGN_JS_CUSTOM is used in 10.1 to activate the data load and copy down functionality of Smart Materials Web in custom pages. To do this you need to update the package HXGN_JS_CUSTOM. To activate the data load option add applications and page to g_ig_data_import and to activate copy down add applications and page to g_ig_context_menu. See the code snippets below for more information.
-
Create or replace PACKAGE HXGN_JS_CUSTOM AS
type g_func is table of boolean index by varchar2(30);
To activate data load for custom application 901, page 100 and 101 type the following
g_ig_data_import g_func := g_func(
'901:100' => true,
'901:101' => true);
To activate data load for custom application 901, page 100 and 101 type the following
g_ig_context_menu g_func := g_func(
'901:100' => true,
'901:101' => true);
END HXGN_JS_CUSTOM;
-
The above code snippets will only work if your custom application supports editable grids for all columns.
-
For custom pages with high complexity, hidden columns, or without access control provision, copy down and data load might not work. Please note, that Hexagon support team will not be able to help with data load or copy down configuration for such custom pages.
-
Before installing a service pack the content of HXGN_JS_CUSTOM should be copied and inserted afterwards.