Changes for XLeMs Version 2.0.0 =============================== Enhancements :- (1) Updated Config Database table structure to facilitate implementation of oBIX driver and drivers for other loggers/meters. The software will automatically update the database from an earlier version, which will render it incompatible with previous versions. (2) Improved dialogs for Edit Connection/Logger/Channel to make them easier to use and facilitate implementation of oBIX. (3) Implemented Historic Data driver for oBIX Loggers (eg. JACE). (4) Implemented oBIX Server (Historic Data only) to allow access to database. (5) If "Collect Data" fails but some readings have been received, then these readings are merged to the database. (6) The database indexes are Automatically regenerated after collecting data (if necessary). (7) Modem AT commands have changed and are now stored in the Registry. (8) Implemented generic "CSV Files" decoder. This uses the file "CsvDecoder.ini" to specify the types of CSV file and how to decode them. If you have previously used the "CubeIP" or "Iskra" CSV decoders, you will need to edit the corresponding "Logger" to select the correct decoder. (9) When viewing raw channel data, you can now export this to Excel. (10) Update formula calculation & implement COUNTIF() function internally. (11) New feature - "Instant Charting" of Templates or raw channel data. Fixes :- (1) Fix (rare) incorrect interpretation of historic data timestamps from SHM Loggers ("M" Records). (2) Improve handling of "GMT" and operation on different timezones. XLeMs stores readings with the timestamp of the logger's local time, which is expected to remain fixed on "GMT" (ie. Standard) time and not switch to Daylight Saving Time. For reporting etc. XLeMs can display the timestamp in either Standard only or Local (Standard/Daylight) time. (3) Ensure "next due" time is recalculated if Schedule Item is edited. Changes for XLeMs Version 1.4.0 =============================== Enhancements :- (1) Make Scheduler a Tray Application. The Close [X] and Minimize [_] boxes now minimize the application to the System Tray. The Shutdown menu command is now used to shut down the Scheduler, which prompts for confirmation before shutting down. (2) Implement FTP Export of Reports to one or more FTP Servers. (3) Cosmetic improvements to some dialogs. (4) Database Backup improvements :- Make work if destination directory doesn't exist. Don't backup empty directories in Sys archive. Save registry options in .opt file in Sys archive. (5) Special tools distributed with version 1.4.0. See :- [InstallDir]\Tools\Readme.txt Fixes :- (1) Fix authentication for SMTP Server when sending Emails. (2) Make "error" messsage less dramatic when using Excel to calc formulas for Alarm reports. (3) Fix incorrect results when gaps in data and "Diff" or "Half-hr MD" used in a Report. Changes for XLeMs Version 1.3.0 =============================== Enhancements :- (1) Implement "$" codes for Channel Headings in Reports. These are parameters which are substituted for dynamic text, eg. Channel Description, Units, Company Name etc. (2) Provide a configurable Date Offset for each Channel in a Report. This Offset from the main date span allows comparisons to be made with earlier data (eg. previous year). (3) A configurable Option now surpresses the "Do you wish to add another Recipe" dialog when editing a Template. You almost never need to use more than one Recipe. (4) Minor improvement to user interface for Quick Reports. Fixes :- (1) Impove Formula calculation in Reports. (2) Fix Scheduler when interval = 1 cal month. Previously, needed to set Template for shortest month (Feb). (3) Fixes for replicated sheets. Ranges were not translated correctly. Changes for XLeMs Version 1.2.1b ================================ Enhancements :- (1) Add support for exported data from Iskra SMS Client software. Fixes :- (1) Don't use Ctrl-C & Ctrl-V for record copy/paste (Edit Connection, Logger, Channel or Customer). Leave these shortcut keys for field copy/paste Use Ctrl-Ins & Shift/Ins for record copy/paste Changes for XLeMs Version 1.2.0 =============================== Enhancements :- (1) New "Quick Reports" feature to view data from any channel using one of the built-in "Quick Templates". (2) New "Constants" table, to give the option to include a named constants sheet in the template. (3) Add the ability to remove a CustRef from a Channel. (4) Add the ability to null out Customer Dates. (5) Migrate from obsolete .hlp to new .chm Help Files. (6) Allow "Weekly Modulo" option in weekly schedules. Fixes :- (1) FTP Client modified to avoid (infrequent) lockup. (2) Increase "Max Chans in Recipe" from 50 to 250. (3) Fix to increase T2 timeout from 5000 to 7000ms. Changes for XLeMs Version 1.1.1 =============================== NB. Only the Scheduler is changed. The Control Centre remains at 1.1.0. Fixes :- (1) Fix bug where DB Backup did not generate Database ZIP file (2) Fix bug where scheduled reports with End Date Constraint of "End Month" were generated 1 month too late. Changes for XLeMs Version 1.1.0 =============================== Enhancements :- (1) Add CSV Reports feature (2) Allow User & Password for SMTP login (3) New "Prune Database" action for Scheduler (4) Backup DB also backs up Licence & Template directories & SCH file to separate Zip file. (5) Allow Copy and Paste when editing Connections, Loggers, Chans, Customers. (6) Allow collection of data from CSV files exported by CubeIP meters. (7) Allow user to define template pages to be cloned. This option is not controllable from the user interface, but can be activated by filling in a field in the Recipe sheet. (8) Billing enhancements. New type "Bill Data 2" which ignores Customer timestamps for simplified billing. Fixes :- (1) Fix problem where new Date/Time fields were not generated in Cust table on the first run after installation. (2) Fix exception when viewing data for a channel with a null Description field. (3) Default Scheduler to showing diagnostics when first installed. (4) Vista fix (part 1). Move Paradox NET DIR from C:\ (not allowed in Vista) to C:\BDE\ This is the directory where PDOXUSRS.NET is stored. (5) Fix caption on "Edit Customer" dialog (was "Edit Connection").