Edit2008/10/17 - Version 2008 R07
- fixed: GIS not functional (server script error)
- New RowVectorMultiSelect and ColumnVectorMultiSelect variables allow to limit the selection in one or both vectors to one item only. (no checkboxes)
- The standalone Remote Console installer doesn't require write access to the HKLM registry section thus may be installed on machines with limited access rights.
- List of registered folders in the web client selection combo is now ordered. (ascending)
- List of global favorites is ordered by the OrderId field.
- fixed: favorites not functional in IE8
- KNOWN ISSUE in IE8: The web client permanently redirect to the TreeCombo ActiveX installer page if the DEP (Data Execution Prevention) feature is switched on in windows.
Data Execution Prevention & IE8Workarounds:
DEP Switch
1. Switch off the
DEP feature or exclude Internet Explorer.
Right click on "My Computer"->Properties->Advanced->
Settings button in the "performance" area->
Data Execution Prevention tab and select "
Turn on DEP for essential Windows programs and services only" or insert Internet Explorer into the list (
c:\program files\internet explorer\iexplore.exe)
2. always navigate to
http://<webclienturl>/main.aspx page to avoid the ActiveX component creation.
Edit2008/09/13 - Version 2008 R06
- Key feature: Full SSL support.
- webclient improvements
- removed some of the obsolete pages (tableXLS, tableXLSnew and some others)
- fixed: the menu disappeared after export to excel in IE7. (The browser's "save as..." dialog cancelled all pending server requests, added 1600ms delay)
- reimplemented optional legacy mode of the "export to excel" feature ("right click and save as..." instead of pushing the file)
- fixed: ASP.NET Views initialization didn't work with SSL. AppRemotelyAccessibleURL returned the original machine name instead of the DNS alias.
- Installation page for the "TreeCombo" ActiveX component with improved detection and user-friendly installation of the component.
- Engine Controller contains a new menu item "Servers down with Controller". If this option is checked, all excel processes are terminated before the Controller is closed. The purpose of this feature is to ensure that no server is running when the machine is shutting down automatically, otherwise a message "Cannot quit Excel" could cancel the shutdown process. The Controller pops up a warning in the case of manual closing by user, for security reasons.
- Statistics generator improvements.
- All input/output file names have to be specified by user in the file open/save dialogs. (no "default" file names anymore)
- The "raw" logfile table can be exported to *.csv
- The "raw" logfile table contains the chosen custom user parameters.
- Output folder is automatically opened in windows explorer after the statistics report (*.html) or the raw table export (*.csv) are generated.
- Renamed from an inappropriate name "Datacquire WebClient Statistics" to "Datacquire WebClient usage statistics generator."
- Minor improvements.
- ASP.NET WebViews improvements
- support assembly MEX.WebViews.dll now works with SSL.
- New properties in the DataGridEx component - ColumnsComboEditableNoEmptyItem, ColumnsEditableMaxLength, ReadOnlyTextboxMode; optimized html output code of disabled objects.
- Fixed incorrect resizing of database selection combo and the treeview in Internet Explorer 8 Beta 2. This required a complete code cleanup of the "Registered folders" toolbar. Favorites don't work in IE8 Beta 2
Edit2008/07/06 - Version 2008 R05
- Password change feature in the web client. (may be disabled in the corporate design package configuration file)
- Slovak localizations of Startpage and Load Balancer error templates.
Edit2008/06/27 - Version 2008 R04
- Removed the custom implementation of dhtml code immediate window (obsolete)
- Removed the possibility to place quick login link to the desktop, NTLM authentication should be used instead.
- Introduced Corporate Design Package system that allows to customize application design (corporate identity)
- The default language is a property of corporate design, no configuration file changes are required anymore.
- Built-in resource files used for customization the old way were removed from the compilation.
- Translated some of the stuff to Slovak (sk-SK)
- Basic SSL support. Web Client, Load Balancer and the Startpage may be used with https:// prefix. Since most of the pages are still not fully trusted, the browser may display warning when changing the security zone.
- View search dialog enlarged to fit XP themed windows.
- Versions of all assemblies renumbered to the correct format year.release.framework.buildnumber, from the original framework.year.release.
- "No folder open" error message not displayed anymore after the menu logo is clicked.
- Viewsync Server - default page allows to enter Synchronization ID for manual online cache dump. Added script injection validation and published at http://services.projee.com/vsyncserver
Edit2008/05/30 - Version 2008 R03
- (WebClient) Fix/Improvement: Quotes (") allowed in scalar/vector attributes and in the values of textboxes, editareas and standalone comboboxes.
- Fixed bug introduced as a side effect of the Favorites feature in R02 - the views reopened each time instead of just switching a sheet if the view was already open.
Edit2008/05/19 - Version 2008 R02
- New: Favorites in web client are optionally stored with parameter settings. (webclient, engine core and mex client changes)
- Fixed: Specialview icon not visible in the web client menu.
- WebClient: Fixes and improvements in the folder administration forms.
- Fixed: apostrophe in reg. folder's name caused that user rights couldn't be set via the web interface.
- Added multilanguage support to the main and details administration forms.
- Added Legend to the details form.
- Configuration utility
- The account used for WebClient impersonation renamed from ASPNET_MEX to IUSR_DATACQUIRE to conform the naming conventions of Microsoft.
- IUSR_DATACQUIRE account has RW rights to the temporary folder of the currently logged user. (not only %windir%\temp)
- IUSR_DATACQUIRE account creation failed on Windows 2000 - account comment exceeded the max. supported size.
- Remote Console: Messaging didn't work since R01.
Edit2008/04/11 - Version 2008 R01
- Converted to .NET Framework 3.5, which is also included in the Prerequisities.
- Minor internal improvements, code quality enhancements (option strict and some others)
- Startpage and LoadBalancer are distributed in two versions, compiled both against 2.0 and 3.5 frameworks. (.NET Framework 3.5 is not supported in Win2K)
- Added: View synchronization tool(s). Consists of 3 modules (client, server, uploader)
- Preliminary preparation for SSL implementation. The web client didn't respond correctly to the Startpage and Load Balancer requests in case of "https://" prefix in the Startpage URL.
- MexDotNet2006.dll used in MexUtl.xla and MEX.xls is now obsolete, replaced by mexinterop.dll, also compiled against 3.5. A new function in the library - Dialog Box with countdown.
Edit2007/12/04 - Version 2007 R06
- LoadBalancer couldn't retrieve availability information from servers defined in the configuration file. Only the first server worked correctly.
- LoadBalancer decision algorithm ignored the BalanceIndex parameter in the configuration file.
- WebClient: Favorites could not be moved in the treeview using drag n' drop.
- WebClient: "export to excel folder" textbox removed from user settings. This was confusing since the exported excel workbooks are not saved automatically anymore.
- Engine Controller: "minimized on startup" menu item didn't work.
- Offline helpfile removed. Help menu items of all components (console, controller, statistics generator and the configuration tool) point now to this wiki.
Edit2007/08/13 - Version 2007 R05
- Engine Controller: added context menu "Display engine info". The menu displays an information about paths to web client, mex client and the global site database.
- Minor optimization of Remote Console and the Configuration Tool for windows XP themes.
- Fixed WebClient ActiveX activation issue. Windows XP SP2 introduced a new annoying "feature" into Internet Explorer 6. ActiveX or .NET controls embedded in HTML pages required user intervention to be activated. ("Click to activate the control" message.) The following actions were negatively affected:
- selecting a scalar/vector value from treecombo.
- selecting a view from the registered folder menu.
- browsing the favorites.
- administration page - detail view.
This IE "feature" is now bypassed and no user unnecesary user clicks are needed anymore.
- Installation improvements.
- All package components store Description and Version information in the registry.
- Prerequisities installer doesn't check for IIS. There was a problem installing Prerequisities on a client PC that was used just for server administration via Remote console.
- LoadBalancer: Configuration and error page templates are distributed in a zip archive.
All files that might be modified by user are now permanent - not removed during uninstallation.
(600.htm, 601.htm, 602.htm, 603.htm, 604.htm, 605.htm, 606.htm, _errors.css, _balancer.config.mcfg).
- Startpage: Configuration and error page templates are distributed in a zip archive.
All files that might be modified by user are now permanent - not removed during uninstallation.
( 500-1.htm. 500-2.htm, 500-3.htm, 500-4.htm, 501.htm, 502.htm, 503.htm, 504.htm, 506.htm, 507.htm, 508.htm, custom.js, _errors.css, _startpage.config.mcfg, custom.js, startpage.htm, startpage.css)
Edit2007/07/27 - Version 2007 R04
- Added context menu icons into remote console.
- Improved Startpage/Load Balancer
- Improved XHTML validity of generated code and the default startpage template. Some of the configuration files are now permanent. They don't have to be backed up because they're not removed during uninstallation. (_startpage.config.mcfg, startpage.htm, startpage.css, _balancer.config.mcfg)
- Fixed navigation from WebClient to Startpage. Navigating from WebClient back to the Startpage caused failure 500-4 "No resources available for your connection." in case that there were no free SIS Clients running. This was a problem in application logic. Starting this release the WebClient pretends to the StartPage that the user's session is still free. The connection is reused (RELOGIN) after the user gets back to the WebClient. The user is even connected to the same SIS Client instance.
- Fixed favorites. Custom user favorites always returned an empty list.
Edit2007/12/06 - Version 2007 R03
- Added Startpage - fully customizable company-specific website that can be used as an entry point for the WebClient.
- WebClient support for Startpage
- Minor WebClient optimizations
- Added PowerBatch utility 2.7.3
- New features and improvements
- Redesigned Password encryptor
- Added WebClient Statistics generator
- Extended statistic information.
- timeout count per user.
- "timeout w/o logout" per user.
- recalculations total/per user.
- logfile RECALC actions contain new parameters "Folder, View, XLS".
Edit2007/02/28 - Version 2007 R02
FIX: Web client startup failure
The web client may be configured to use impersonation: in such case it runs in the security context of the specified user account on the server. The startup failed if the specified account didn't have sufficient rights to launch another process. These rights are not required anymore.
PowerBatch utility Beta 1
Starting this release the package is equipped with a visual batch file processor that makes repetitive file/folder operations easier. The batch files are easy to write without any programming skills. Suitable for configuration backups, etc.
Configuration utility improvements
The configuration utility sets user rights for ASP.NET temporary directory upon creation of the default ASPNET_MEX account; .NET Framework 2.0 is now supported.
Some of the required components (netuser and ntrights) are checked on startup; the startup fails if they are not present in the application directory.
Fix: System.InvalidProgramException (WebClient)
This problem occured in some cases during web client startup.
Edit2007/02/15 - Version 2007 R01
Load Balancer
Load Balancer included in the package with XHTML 1.1 compliant templates of the error pages. Web application that improves system performance by redirecting users to more servers, depending on their current load. The web client has to be installed and the engine controller should be running on these machines. Another advantage is the possibility to restart one of the configured servers while the others are running. (higher server availability)
FIX: AutoServerRecycling + AutoServerManagement (engine controller)
"Access denied" failure after server recycling.
Automatic server management stopped working as a consequence of this error.
Engine startup optimized and improved (engine controller)
The process was split into more phases (initialization & startup)
FIX: Logging (engine controller)
Incorrect failure phase "engine startup" reported if an error occured during the regular engine maintainance process.
Engine startup failure notification (engine controller)
If a failure occured during engine startup, the console and engine controller GUI were not notified and reported an incorrect engine state. (running)
Logging extended
Some of the events have more detailed logging.
Send message window displayed in taskbar while opened.
Eventscript extended
GetOriginalValue function.
Textboxes can be processed by the eventscript.
Full recalculation with DoRecalc(1) supported in all events. Eventstrings are now obsolete.
Edit2006/12/07 - Version 2006 R09
Parameter AllowServerRecycling (console)
An attempt to launch new MEX server by the Engine Controller on the server may fail with the error message "Not enough memory to start Microsoft Excel". In such case all instances of the excel.exe process have to be closed to clean up the memory. This option helps to reduce the occurence of this error. With this option applied, all servers are recycled automatically each time the last user is logged off/timed out.
Parameter RecycleAllProcesses (console)
This option extends the behavior of AllowServerRecycling parameter. AllowServerRecycling causes that all the servers in the console list are recycled. Somethimes this is not enough: there may be invisible excel.exe processes running in the memory - MEX clients that crashed previously and are not listed in the console. This option ensures that also these processes are killed.
Warning: This option unexpectedly closes all instances of Excel therefore it should only be used in the server environment with no interactive Excels running. (to prevent data loss)
Search user (console)
Toolbar for searching users in the database fields UserName, Name, Surname. Possible search modes are "Exact match", "Contains", "Starts with", "Ends with".
Web user Importer (configuration utility)
It's now possible to import the users from a table in SQL server. Fully functional except of storing the parameters into a config file. Therefore, the set of fields is limited to UserName,WinUserName,Name,Surname and BLZ, which is imported to a custom user parameter. The field set will be extensible in some of the future releases after the configuration saving is implemented.
Help integration
Help/Search and Help/Contents menu items included into Engine Controller and Remote Console. Preliminary help for Virtual group queries written for the remote console.
Several new menu icons added (console + controller)
FIX: Slow menu loading (WebClient)
Loading of registered folders having "exclusive views" (MW_AUV_EX) defined in the global site was very slow. Optimized.
WORKAROUND: Invisible records in the list of web users (console)
Opening virtual group having an invalid query or performing a search with invalid characters caused that the user list items became invisible until the next console restart. Probably caused by .NET Framework bug.
Logfile viewer (console)
Displays the contents of a log file that is stored on the server. Since the logfile may grow up to several megabytes, it's possible to choose how many megabytes from the log file should be downloaded.
Minor fixes and improvements
Edit2006/11/07 - Version 2006 R08
- Console: Added Show server screenshot menu item. Takes a screenshot at the server and displays it in the console. No more using remote access tools like Netmeeting for simple status checks.
- Console: Added menu item "Send message to online users" into the remote console. Allows to send a message to online web users. Send progress is reported for every logged user (sent, displayed, read) and the administrator is notified after all users accept the message. Any number of message templates can be predefined in the configuration panel.
- Remove user (console)
- Context menu item for deleting web users from the database.
- Disable login (console)
- Group role IsRoleIgnoreLoginDisabled
Users with this role may login even if login is disabled.
- WebClient login can be disabled in the configuration panel.
- Only users with IsRoleIgnoreLoginDisabled role may login while this setting is applied. Any other login attempt fails with a message that can be modified in the configuration panel.
- "WinUserName" column in the connection list. (console)
User connection list contains the windows authentication information (DOMAIN\USER) for every online user. Requires that the windows authentication is enabled in IIS.
- "Registered folder" column in connection list. (console)
- User connection list contains the registered folder alias for every online user.
- Login process rebuilt.
- The login flow has been simplified and tested for roles IsRoleSuperAdmin and IsRoleIgnoreLoginDisabled.
User with role IsRoleIgnoreLoginDisabled may login even if login is disabled.
User with role IsRoleSuperAdmin may login under any account without using the password, even if the windows authentication is not allowed in the web client configuration. Requires that the windows authentication is enabled in IIS.
- More information in the statusbar. (console)
- Server operating system and the number of processors displayed in the console status bar.
- FIX: Size of the objects (scalars) placed on a view in WebClient was not set correctly by Internet Explorer after recalculation.
- FIX: Export to excel failed if there were hidden labels placed on a sheet.
- Parameter "ScrollStateOff"
- Sheets in a workbook can be excluded from the "scrollbar state saving" default behavior in the WebClient by specifying the list of the excluded sheets in the "ScrollStateOff" parameter.
- Configuration panel items grouped and ordered. (console)
- Several new menu items added (console)
- Validation of username/groupname in the add user/add group forms. (console)
- Processor Affinity - experimental feature.
- Server list contains new column "Processor ID" displays which processor(s) is the server "attached" to.
- Menu item for overriding the default affinity set by the operation system. This could improve the performance on multi-processor or dualcore machines and will be a subject to testing in the future releases.
Warning: The previous generation of web client (MEX WebClient 4.5.6) is not supported anymore. Fixes of any bugs found in the old releases will be implemented into the future releases of Datacquire.