niota

View info message display changes - "... set to read only ..." message appears only when it is must
UCA connection handling change: UCA uses message connection
In system default application drop down list is opened by default
Bug fix: retrieve transactions for default system application
Bug fix: load login help content from client folder
Bug fix: negative catalog id does not work inside custom subject area

MySQL v8.0 meta db server
Cascading lookup feature
Multi client feature
Debug/log setting on user level
Language definition on user level
Distributed communication area

Deployment feature
New administrative menu items
File upload and callable object call
Custom icons for callable objects 
Validation feature
Excel - partial upload
New details of catalog object instances: 'group by' and 'order by'
Switch on/off advanced filter when configured in transaction menu
Switch on/off automatic 'order by primary key(s)' clause
Bug fix - LDAP connection handling
Bug fix - input type validation with constraints 

New feature: configurable link

Bugfix - Teradata connection: retrieve column types for views
Bugfix - date- and datetimepicker: put focus on input field after value is selected
Bugfix - lookup pulldown: put focus on input field after value is selected
Send info message when grid is forced to read only mode
Error handling - redirect to logout page if fatal error occures
Logging error and debug info into file (new files: 'niota/log/error.log', 'niota/log/error_sql.log', 'niota/log/debug.log')
New administrative feature: administrator can set his/her own settings as default layout of a grid for all users

Niota v3.2.1 is a standalone installation with v3.2.0 functionallity and Php 7.3.8 compatibility!
Requires: Apache 2.4.41 64bit, Php 7.3.8 64bit! 
Adodb5 library is updated to version 5.20.14. You can check changes from version 5.20.7 here: https://github.com/ADOdb/ADOdb/blob/v5.20.14/docs/changelog.md

New feature: callable object sequence
New feature: web service call
Bugfix, Chrome only: excel export jumps to blank page
Bugfix, MSSQL: excel export problems when column type is nvarchar and value contains accented letters

Portable MySQL database server included
Provide a preconfigured Niota sample system
Encryption tool for database connection passwords
New login page layout
Handling of missing grant of database user on database tables
Bugfix: accept formatting files on master-detail settings
Bugfix: selection went wrong in some cases of line level callables call
Bugfix: warning PHP message at the top of the page in the case of some specific datatypes
Bugfix: excel import failes when zero value is found in integer column and there wasn't a default value set

Relative file path handling bug fix
Excel import fix. Handling of decimal values.
Admin script corrections
Update language files
Update Salva theme					

- admin page 'Constraints saving method changed' -> tiped in values are saved, checkbox to use constraint in grid
- change the way of filter out 'et_...' meta tables -> filter out only form mate data connection
- the same lookup definition can be used many times without using aliases
- call stored procedure for logging, $installation variable can be used
- internationalization and language file code revision
- naming convention: ALL USERS, ALL ADMIN USERS, ALL NON-ADMIN USERS naming checged -> ALL_USERS, ALL_ADMIN_USERS, ALL_NON_ADMIN_USERS (see metadata update sql)
- internationalization of grid edit feedback messages

- bugfix: Deutsch language - excel upload feedback message appears in wrong place + warning msg on screen
- bugfix: SQL Server and MySQL master - detail crash
- bugfix: stored procedure selection does not work without multiselect
- bugfix: constraints menu counter shows wrong when a setting is deleted
- bugfix: operation column settings for superuser
- bugfix: inline edit decimal value saving
- bugfix: inline edit - datetime value changing
- bugfix: excel import handles whitespace characters in not-caharcter fields (date, int, etc.)

- Oracle related settings stored without database name in metadata tables
- $installation variable value can be set at conf/my_formatting.php -> INSTALLATION_NAME constant for stored procedure calls
- Master - detail tables: detail tables also use the defined decimal point (',' or '.') format
- bugfix: inline edit - insert lookup values correctly if more than one values are shown in the droppdown list
- bugfix: action column position disordered column values
- bugfix: Internet Explorer page reload made blank page
- bugfix: between constraint - value 0 cannot be saved
- bugfix: Oracle table export error
- formatanytable.php -> line altered: old: 'formatoptions'=>array('keys'=>true, 'editbutton'=>$editButtonStatus, 'delbutton'=>$deleteButtonStatus, 'reviewbutton' => true)
									  new: 'formatoptions'=>array('keys'=>true, 'editbutton'=>$editButtonStatus, 'delbutton'=>$deleteButtonStatus)
					 -> new constants for positioning operation column (ACTIONS_FIRST, ACTIONS_LAST)				 
- test button for stored procedures working changed: returns unsuccesfull in the case of php warninrgs. Eg.: tipeo or less / more apostrohe(s) written. 
- new upgrade log in conf/ folder

- editable detail tables which use all of the restrinctions
- new grid color themes
- new choosable niota color theme - Salva
- grid menu display - not allowed menu points does not show up
- stored procedures - new system variable for sp declarations: $installation
- new file structure
- choosable Deutsch (or English) language for grid area
- new setup files -> conf/formatting.php is split to my_formatting.php and branding.php
- new formatting features under 'conf/my_custom_formatting/' folder (changeable column names,  switch to inline edit, mark mandatory fields)
- prevent niota directory listing
- allow again to run stored procedures for logging into database
- use both 'SEL' and 'SELECT' in lookup definitions - ONLY IN TERADATA
- test button for master - detail definition
- lookup test button - multiple changes and tests with one save
- stored procedure table can be hided and shown
- Teradata overwrite ODBC connection in niota -> FULLY QUALFIED TABLENAMES REQUIRED IN THE SAVED SQL QERIES AND DEFINITIONS(lookup, master-detail, etc. Eg.: sample_database.sample_table)!!!
  ========									 	 ==========================================================================
- bugfix: navigation menu droppdowns - MySQL related counting info display