General: [New] Usergroup assignment to user can now have begin and/or end time. When assigned time period arrives then Core service will activate the usergroup. When time period elapses, the rights from the group are removed. [New] Active Directory (LDAP) sync service framework created - for users and usergroups import. [New] Replaced UDP trigger with Socket trigger supporting both UDP and TCP protocols. [Improvement] Console menu system: added ctrl+c for copying editor contents. [Improvement] Console menu system: fixed character set when text is pasted using ctrl+v shortcut. [Improvement] Console menu system: fixed incorrect menu layout when console window size is forced by user. Services installer: [New] API service now included. [New] ISIC sync service included in Estonian installer. [New] Firebird version 3.0.12 in db installer Client installer: [New] Installer now supports installing more than one instance of client. Secondary installations can be named. Each installation will be placed in own folder (in user appdata folder) and will maintain its own settings. The installations can be upgraded independently going forward. [New] Installer now creates installation info when upgrading manually copied client folder. [New] When installer upgrades a client without installation information (a folder copy) it now sets a flag to have client copy registry settings from default registry location. [New] Demo client installer is now with its own application id to make it easier to try out new versions and uninstall without risking changing live installations. [Improvement] Adding of firewall rule task is now also available when upgrading. [Improvement] Outbound firewall rule task now visible in non-elevated install and will be run elevated when selected. [Improvement] Simplified uninstaller without annoying message boxes. Select uninstall tasks to perform on initial page and click next to confirm and proceed. [Improvement] Changed plugin descriptions in component selection page to be more descriptive. [Improvement] Split plugins to two groups - service plugins and other plugins. [Improvement] Removed unnecessary install type selection dropdown. [Fix] Firewall modification success or failure was not correctly detected. [Fix] Now running kill command to prevent zombie client instances blocking upgrade (that remained because of bug in browserbtn preventing client exit). Core: [New] User with department restriction can now view users from those departments that are included in his department. [Improvement] Firebird3 boolean typed columns and variables in scripts, queries, reports and triggers. [Improvement] Optimized processing and forwarding of large number of object changes when services comes online. [Improvement] Host name for connection is now included with IP. [Improvement] Optimized object/event department check for clients with department restriction. [Improvement] For gathering information for fine tuning, bugreport is now generated when handling of service command takes longer than 8 seconds. [Improvement] Services and clients connection keepalive timeout period increased from 10 to 20 seconds to prevent too agressive disconnecting in case of slow processing or network. [Fix] Events ocurring during client login were some times not delivered to client. [Fix] Reloading of users was triggered for any type of object (not just another department) added or removed from users department. [Fix] Password hash was not removed from database when user login name or password edit was cleared in client. [Fix] Service config changes were not delivered correctly to other clients (affected PanicAlarm settings change). [Fix] Clients disconnected when many clients were simultaneously connected and sync system generated large number of user changes. [Fix] Incorrect group members count was returned to client when user groups tab was opened. Db: [New] Created function fn_date_is_holiday to test wether given date is present in sys_holidays table. [New] Added views vw_users and vw_user_groups to simplify selecting records from users table. [Improvement] Changed default SMTP server in new db to smtp.gmail.com [Improvement] Added card number column to view_access_log. [Improvement] Audit trigger activation now also grants necessary privileges to new trigger. [Improvement] Event log columns param1, param2 and param3 added to view_log. [Improvement] Added delimiter and index columns to pr_list_name utility procedure output. API service: [New] Added command for running predefined report queries. [New] Added Users.GroupSetPeriod to support time limited usergroups. [New] Added UserGroups.Members command to get list of usergroup members. [Improvement] Updated Users.GroupList to include period info. [Fix] Corrected exe file description. Client: [New] Added option to include events by target user in user history. [New] Added Ctrl-Shift-C shortcut to report preview for quickly exporting report source data. [New] Auto-upgrade when logging in now upgrades the same specific client (based on folder). [New] Copying of default settings when flag set in registry by installer (to support seamless legitimization of folder-copy installations). [Improvement] Dont allow popup dialogs on floating dock forms. [Improvement] Own user is now highlighted with bold text in users table and can not be deleted or disabled. [Improvement] In system settings, made departments list and contained objects resizable with splitter. [Improvement] Now remembering usergroups tree layout in user editor. [Improvement] No longer need to close all instances of clients when performing update in one (as long as each client is started from own folder). [Improvement] OS error info included in error message when creating drawing cache folder fails. [Improvement] In users groups page, multiple usergroups can now be selected and added (or removed) together. [Improvement] Added visible column selection in usergroups page. [Improvement] Added storing of layout of usergroups treelist. [Improvement] Exposed DlgSelectUser.NameLookup function to reports for scripting. [Improvement] Speed optimization for editing/deleting of user records when large number of records are selected. [Improvement] Refinements to editing of multiple selected users together. Select multiple rows using shift/control modifier, then press F2 to change selected column value - all selected users will get same value in given column. Now works with checkbox and dropdown editors also. [Improvement] Added insert and delete buttons to system settings tables for more consistent look. [Improvement] Object selection dialog now can filter dropdown list by containing text (type partial words in the edit area). [Fix] Bring floating fock forms (log, map) to top after starting client (some times remained behind main form). [Fix] Wait until bugreport done sending to show issue id number. [Fix] When deleting multiple selected users failed with an error then users grid remained locked. [Fix] Rare AV after cancelling drawing changes. [Fix] Failed to set longer than 64 character password. [Fix] A window would some times get behind main form after unlocking. [Fix] Potential fix for "dpMap has no parent window". [Fix] Potential fix for unreproducible AV in action update handler. [Fix] Hang after clicking on "Cancel and disconnect" button in long running command wait dialog. [Fix] Solved multiple paths to error conditions when getting disconnected during login or loading of users or drawings. [Fix] Command wait dialog disappearing behind top window. [Fix] In specific circumstance, area drawing could fail to load with "file was not found" error. [Fix] Mouse back button some times activated incorrect previous drawing page. [Fix] If currently displaying area drawing was changed remotely then view was not made to fit and center after reloading. [Fix] Mouse panning was incorrectly activated without holding left button after in drawing mode an objects properties were previously opened via double-clicking. Browser button plugin: [New] Added option to log event when button is clicked on- [Improvement] Button is now made invisible when associated object is not found (for example when logged in user has department restriction that does not include the associated object). [Fix] Plugin caused client exe process to remain in memory and prevented version upgrades. SiteMonitor plugin: [Improvement] Update, insert and delete buttons in settings now matching style of other pages. Cardissue: [Improvement] Now accounting for Soyal card number mode (WG vs ABA10). Paradox: [New] Add Evo192 version 7.8. [New] Add EvoHD+ version 1.07, 1.08. [New] Reset bad password flag when panel is enabled to enable forced retry after fixing password. [Fix] Plugin: After ending design-mode, partition group remained in state that was set at design-time until next login. [Fix] Plugin: Door open/close menu item was enabled to users below allowed class (but did not work). Soyal: [New] Added AR725E version 4.5 to known version list [Improvement] Added delay after clearing users to work around issue where some 725E devices failed to store user floors data. [Improvement] Added sending of user names to AR837E. [Improvement] Skipping channel progress state when uploading only a few cards. [Improvement] Exposed "Close door stop alarm" config option for 721H based readers. [Fix] Variant conversion error in specific cases in card import wizard. [Fix] Plugin: Door open/close menu item was enabled to users below allowed class (but did not work). Sync: [New] Added color property for each sync system. Users from system will have given background color in users table. [New] Plugin now has capability to configure sync service options via client-side UI. UI added for EYL, ISIC and AD services. [New] Service now provides internal means for client services to add objects to system (departments for now). [New] Syncing start, complete and fail events are now logged. This provides oportunity to run scripts after sync. [New] EYL: added new mode of operation where no new users are created, instead access cards are added only to existing users. [New] EYL: Added saving of ISIC number to access card notes column. [New] ISIC: Add card type filtering by prefix letter. [New] ISIC: Add card import mode (with users or only match cards to users by user person code). [New] ISIC: Make card group prefixes configurable and skip adding group when prefix not set. [New] ISIC: Add storing of user person code to custom column (instead of employee number column). [New] ISIC: Add storing of isic number to custom column. [New] ISIC: Add automatic creating of usr_person_code column. [New] ISIC: Add automatic creating of usr_isic_number column. [New] ISIC: Add storing of ISIC number to access card notes column. [New] ISIC: Remove events and locks reporting to Minukool. [New] ISIC: Add capturing of existing users/cards by matching card number and person code. [New] ISIC: Add buffered event logging via core service (like in AD sync). [Improvement] Attempting to connect only one time when performing immediate sync or config fetch. [Improvement] Service now disconnects from client service after finishing sync. [Improvement] Service now connecting to client with shorter timeout to prevent long blocking waits when user configured wrong port. [Improvement] EYL: add groups only when user change succeeded [Improvement] ISIC: Enable TLS 1.1, 1.2 protocols [Improvement] ISIC: Improve card create/update exception messages [Fix] Sync service tried to connect in a tight loop (causing high cpu use) after sync interval had elapsed. [Fix] EYL: Prevent moving access cards back and forth between users with same person code. [Fix] EYL: Fixed applying changed ISIC number to user. [Fix] EYL: Wrong error message when failing to add card groups. [Fix] ISIC: fixed applying changed ISIC number to user [Fix] ISIC: Added checks to prevent moving card between same persons duplicate user records.