niota

This is an old revision of the document!

---

4.0.0

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 

3.2.3_PF

New feature: configurable link

3.2.2

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

3.2.1

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

3.2.0

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

3.1.3

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

3.1.2

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

3.0.0

- 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.)

2.0.1

- 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

2.0.0

- 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