===== Grid area toolbar ===== Depending on your access authorities and the configuration of the table you may find this clickable icons in the grid area toolbar. ==== import from Excel sheet into database table ==== {{niota-docs:import.png?nolink|}}\\ Icon is visible only when you have the proper access rights for this catalog object. Click to import data from Excel into the table. All data in table is deleted before it will be replaced by data from the Excel. **Be careful! There is no way to restored delete records with a niota feauture.** ==== replace/update table from Excel sheet ==== {{niota-docs:excel_import_partial.png?nolink|}}\\ Icon is visible only when you have the proper access rights for this catalog object. Click to import data from Excel into the table. All data in table **that is also in the Excel** is deleted before it will be replaced by data from the Excel. **Be careful! There is no way to restored delete records with a niota feauture.** ==== export and download Excel sheet ==== {{niota-docs:export.png?nolink|}}\\ Icon is visible only when you have the proper access rights for this catalog object. Click to emport data from niota to CSV file. All data selected for this table instance will be exported. The export file may not contain all the data from the table. It contains only data that is visible to you. **Be careful!** ==== show callable objects (procedures/scritps/web-services/...) ==== {{niota-docs:display_sp.png?nolink|}}\\ Icon is visible only when you have the proper access rights for this callable objects assigned to the active catalog object. Click to open pop-up window where you can start the callable objects. ==== set/reset current grid as favourite ==== {{niota-docs:save_path.png|?nolink|}}\\ {{niota-docs:reset_path.png|?nolink|}}\\ Click set to set the active catalog object to your favourite object. Click reset to remove the favourite property. ==== reload table and prompt for selections ==== {{niota-docs:search.png?nolink|}}\\ Icon only visible when there is an advanced filter definition. Click to open the advanced filter form. You can enter there new criterias to filter the actual catalog object. ==== validate table constraints and lookup ==== {{niota-docs:grid_validation.png?nolink|}}\\ Icon only visible when there are lookups or constraints defined for the actual catalog object. Click to process the validations immediately for the whole table. Results of verification are written to a niota system table.