====== Grid edit - user interface ======

When successfully logged in you are usually linked to the grid editing dialog. How this dialog appears to you depends on how your local niota admin has configured the system.
Your local niota admin can configure e.g.

**the look and feel**\\
  * theme - (color, background image, font)
  * language - Englisch/German
  * branding - logo, claim 
 
**tables and menue items you have access to**\\

**functions and features you may use**\\

However your admin configures the system there will be generic features which are explained below.


===== Page layout =====
The page can be divided into three sections. From top to bottom:
  * Upper menu bar
  * Lower menu bar
  * Grid area

{{ :niota-docs:g_01_010_grid_area_overview_01.png?nolink |}}
\\
\\
==== Upper menu bar ====

Depending on local configurations and your access rights you find this in the upper menu bar


{{ :niota-docs:g_01_020_grid_area_upper_menu_bar_01.png?nolink |}}
\\
\\
==== Upper menu bar clickable icons ==== 

  * {{niota-docs:admin_area.png?nolink|}} **[[grid_edit_upper_menu_bar | switch to admin pages]]**\\
  * {{niota-docs:logout.png?nolink|}} **[[grid_edit_upper_menu_bar | log out]] **\\
  * {{niota-docs:user.png?nolink|}} **[[grid_edit_upper_menu_bar | change profile settings]]**\\
\\
  * {{niota-docs:help_custom.png?nolink|}} **[[grid_edit_upper_menu_bar | custom help link]]**\\
  * {{niota-docs:help_system.png?nolink|}} **[[grid_edit_upper_menu_bar | system help link]]**\\
\\
\\
==== Lower menu bar ====

Depending on local configurations and your access rights you find this in the lower menu bar

{{ :niota-docs:g_01_030_grid_area_lower_menu_bar_01.png?nolink |}}
\\
\\
==== Lower menu bar clickable icons ==== 

  * catalog object (grid) selector
  * connection filter - only the catalog instances of the selected connection will be displayed in the grid selector
  * category filter - only the catalog instances of the selected category will be displayed in the grid selector (to create categories check the related admin feature: #LINK)
\\
  * {{niota-docs:double_arrow.png?nolink|}} **[[grid_edit_lower_menu_bar | hide or display selectors]]**\\
  * {{niota-docs:transactions.png?nolink|}} **[[grid_edit_lower_menu_bar | menu of available transaction]]**\\
\\
\\
==== Grid area ====

Depending on local configurations and your access rights you find this in the grid area

{{ :niota-docs:g_01_040_grid_area_grid_area_01.png?nolink |}}
\\
\\
==== 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.

  * {{niota-docs:import.png?nolink|}} **[[grid_edit_toolbar | import from Excel sheet into database table]]**\\
  * {{niota-docs:excel_import_partial.png?nolink|}} **[[grid_edit_toolbar | replace/update table from Excel sheet]]**\\
  * {{niota-docs:export.png?nolink|}} **[[grid_edit_toolbar | export and download Excel sheet]]**\\
  * {{niota-docs:display_sp.png?nolink|}} **[[grid_edit_toolbar | show callable objects (procedures)]]**\\ 
  * {{niota-docs:save_path.png|?nolink|}} **[[grid_edit_toolbar | set current grid as favourite]]**\\
  * {{niota-docs:reset_path.png|?nolink|}} **[[grid_edit_toolbar | reset favourite grid]]**\\
  * {{niota-docs:search.png?nolink|}} **[[grid_edit_toolbar | reload table and prompt for selections]]**\\
  * {{niota-docs:grid_validation.png?nolink|}} **[[grid_edit_toolbar | validate table constraints and lookup]]**\\
\\
\\
==== Grid edit features ====

You can find edit features at the bottom of the grid. With additional configuration it can be displayed at the top of the grid too (as you can see on the picture upwards).

  * {{niota-docs:add.png|add row}} add row: inserts a new row into the grid (and the database table)\\
  * {{niota-docs:edit.png|edit row}} edit row: edit the current row\\
  * {{niota-docs:view.png|view row}} view row: opens the content of the row in a popup\\
  * {{niota-docs:delete.png|view row}} delete row: deletes the selected row(s)\\
  * {{niota-docs:reload.png|reload grid}} reload grid: reloads the grid content\\
  * {{niota-docs:search-grid.png|search}} search: opens the search input on the top of the columns\\

For special cases of "null" and empty string editing click here:
[[niota-docs:grid_edit_null_and_empty|Grid editing special cases]]