DC2009 Revision History
Updated April 23, 2010

What's New
Alarm Handler
2009.2.0 4/5/2010 Changed the behavior of Mercury Alarms. Only one alarm record is generated per call per type. Every interval in a Mercury corrector would show an alarm if the alarm condition didn't change. For example, if there was a Low Pressure condition for a 24 hour period there would be 24 alarm records (hour interval size) generated if the device called in once a day. More alarm records if the device had a smaller interval size. This in turn would generate 24 email notifications about the condition. This was an unnecessary amount of alarms and was reduced to a single alarm and notification per alarm type.
Clear Data
2009.0.3 10/12/2009 Fixed a problem when using the Send All Option for ANSI devices.
Data Viewer
2009.0.4 1/26/2009 Fixed the Login Window to correctly display the system version number.
Data Collection
2009.2.18 2/17/2010 Added Event Log Support for Mini-AT and Mini-Max
2009.2.19 3/15/2010 Fixed an issue that was causing Metretek AT Modems to hang-up before they answered the incoming call. The Line Feed character that was being sent in the ATA\r\n command was causing the modem to go back into command mode before the modems could handshake.
2009.2.20 4/9/2010 Fixed an issue where some of the newer correctors were not getting item code 338 cleared to indicate good call for the device.
Data Processing
2009.2.3 10/21/2009 Made further changes to the 225/226 mapping to 0/2 for time of call data. This mapping happens for all TOC readings regardless of the number of inputs. For inputs with Item Codes 0/225 2/226 Packed interval will always hold the interval data, 225/226, and time of call will hold index readings 0/2.
2009.2.4 12/18/2009 Added support for Orbcomm file type 50 processing.
2009.2.5 1/8/2010 Added the PLog Alarm support for the Mini-AT, TurboCor, AccuTest product types.
2009.2.6 1/29/2010 Found a bug in the mapping routine for 225 and 226 to 0 and 2.
2009.2.7 4/9/2010 Fixed an issue where some of the newer correctors were not getting item code 338 cleared to indicate good call for the device. Cleaned up the AT modem command handler so that there wasn't any unnecassary data going to the modem.
Remote Unit Configuration
2009.1.7 10/23/2009 Changed the way the hardware alarms are converted when changing a device type from an ECI into the device it is attached to.
2009.1.8 12/18/2009 Fixed a SQL Cursor Error when converting a CPA into an IMU
2009.1.9 4/06/2010 Disabled the Instrument Type selection for ECI and ECI2. It was causing problems when customers thought they could replace a corrector with a different corrector type.
System Configuration
2009.1.4 10/12/2009 Added the ability to use Site ID 1 or Site ID 2 for Mercury Devices.
Reldial
2009.2.0 04/23/2010 Added a new dial out token type for the SIP-CNI2.


Detailed Application History

Account Configuration
Version 3.x.x
00 1/7/98 initial version number - LV
01 10/19/99 added tab for sub-metering report flag (billable column account_member_config) - HM
02 11/30/99 fixed the SAM_Create message for dlgEditAcct.tblMerge - it was causing 20055 errors when querying for accounts with over 50 members.
03 9/5/2000 Updated for windows 2000
04 1/30/2001 Removed the reference to dbo in the Create Procedure( caused problems when the integ login wasn't aliased as dbo - SQL 7.0 JSP
05 3/06/2001 Changed the code to add the stored procedure only if it doesn't exist JSP
06 5/10/2001 Fixed the display for Windows 2000
07 1/20/2002 Had problems when working with large accounts- would delete multiple accounts JSP
Version 6.x.x
00 5/2/2002 initial version number - JSP
01 9/16/2002 Fixed a problem when editing an accout and clicking OK with no members causing a SQL Error - JSP
02 11/4/2003 Added Version Tracking. Changed the AddAccountMembers SP to AddAccountMembers2 to eliminate the problem of the to SP's for the different versions of this app having different number of params JSP
03 11/24/2003 Removed a lot of sqlconnect/disconnects and replaced them with a single handle hSqlMisc. Cleaned up the spaces at the end of all of the edit boxes for the edit account window. JSP
Version 7.x.x
00 12/7/2004 Updated the security model to comply with the Sarbanes-Oxley Act. Password now must be 8 characters long, contain upper and lower case letters and include numbers.
01 11/08/2006 Made sure the account note field doesn't contain ' characters.
Version 2009.1.x
0.0 9/26/2008 Updated the application for the new release version 2009 under Mercury Instruments.
0.1 9/22/2009 Fixed a problem where the search button didn't work if the "Sort" checkbox wasn't checked.

Alarm Handler
Version 2009.1.x
0.0 9/26/2008 Updated the application for the new release version 2009 under Mercury Instruments.
Version 2009.1.x
2.0 4/5/2010 Changed the behavior of Mercury Alarms. Only one alarm record is generated per call per type. Every interval in a Mercury corrector would show an alarm if the alarm condition didn't change. For example, if there was a Low Pressure condition for a 24 hour period there would be 24 alarm records (hour interval size) generated if the device called in once a day. More alarm records if the device had a smaller interval size. This in turn would generate 24 email notifications about the condition. This was an unnecessary amount of alarms and was reduced to a single alarm and notification per alarm type.

Alarm Maintenance
Version 3.x.x
00 10/7/97 International Date/Time - LV
01 10/7/97 Added Security - VT
02 10/9/97 Added newprefs apl - LV
Version 6.x.x
00 5/23/2002 Compiled with Centura 2000 JSP
Version 7.x.x
00 12/7/2004 Updated the security model to comply with the Sarbanes-Oxley Act. Password now must be 8 characters long and include numbers.
Version 2009.1.x
0.0 9/26/2008 Updated the application for the new release version 2009 under Mercury Instruments.
Version 2009.2.x
2.0 4/5/2010 Changed the behavior of Mercury Alarms. Only one alarm record is generated per call per type. Every interval in a Mercury corrector would show an alarm if the alarm condition didn't change. For example, if there was a Low Pressure condition for a 24 hour period there would be 24 alarm records (hour interval size) generated if the device called in once a day. More alarm records if the device had a smaller interval size. This in turn would generate 24 email notifications about the condition. This was an unnecessary amount of alarms and was reduced to a single alarm and notification per alarm type.

Alarm Report
Version 3.x.x
00 1/6/98 Initial version - LV
01 1/6/99 Fixed Autoload reports with a list name greater than 12 charaters. JSP
02 1/25/99 Added AE6000 alarms Only for Product_ID=92. JSP
03 3/26/99 Optimized WHERE clause in BuildWhereClause() when running report for a LIST. Report nows runs twice as fast on a LISTas it did before -- KMS
04 3/30/99 Debuged and Improved interaction with AE6000 Stuff
05 6/16/99 Fixed problem with report not referencing user defined alarm descriptions as well as the problem with the refresh Refresh button on the alarm report display.
06 7/8/99 Fixed problem with refresh button.
07 8/03/99 Special Messages column was getting cut off at 30 characters - changed to 40. KMS
08 8/12/99 Fixed the query of Alarm_Types -- KMS
09 8/18/99 Fixed the problem of Special Messages getting truncated if the first character of the special message was a space -- KMS
10 8/24/99 Fixed AE alarm queries to select alarm description from the Config table, not the default alarm items table -- KMS
11 2/8/2000 Recompiled with new EDITAUTO library - KMS
12 3/22/2000 added the option to select alarms by a.>time received by DC2000, or b.> time alarm occured at remote unit. Added Report Date/Times to report header. Fixed queries so that Display and Print buttons works exactly the same. Fixed queries so that the proper AE6000 alarm info was retrieved. -- KMS
13 4/19/2000 Added support for Web Reports JSP
14 5/16/2000 Added CDF file support for INETReporter
15 1/26/2001 Cleaned up DB Connections - ruduced run time to 1/3 JSP
16 1/30/2001 Fixed problem with autoload not createing file JSP
17 2/5/2001 Fixed bug with autoloading reports, optimised code. JSP
18 3/21/2001 Fixed Display for Windows 2000 JSP
19 4/4/2001 Fixed / Added Address to reprot and display window
Version 6.x.x
00 5/6/2002 initial version number - JSP
01 4/17/2003 Fixed some problems that occured when the is no default printer defined. JSP
02 4/17/2003 Added Version Tracking JSP
03 4/21/2003 Removed code to quit app when SQL Error occurs. Added ANSI descriptions to Alarms JSP
05 11/20/2003 Fixed a problem with a primary key violation when the image was saved. This was a result of the AE alarms being added to the alarm_type table. Also fixed problems with the custom descriptions not being displayed in the report. JSP
06 3/15/2004 Fixed a problem with the wrong description showing up for alarms. The alarm_num and Alarm_ID column were referenced backward in the code. JSP
Version 7.x.x
00 12/7/2004 Updated the security model to comply with the Sarbanes-Oxley Act. Password now must be 8 characters long, contain upper and lower case letters and include numbers.
Version 2009.1.x
0.0 9/26/2008 Updated the application for the new release version 2009 under Mercury Instruments.
0.1 08/31/2009 Fixed a problem with List Reports not saving correctly.

Application Launcher
Version 3.x.x
00 10/3/97 Added new Security - VT
01 11/04/97 Added - RU Summary, BG Translators, User/Security Removed - Users, Security - VT
02 11/13/97 Added the RU Search - VT
3.15.2 11/16/98 upgraded CLEAR.EXE to 3.2.05; fixed default_alarms for SIP and IMU;
3.2 2/2/1999 Added AE6000 bitmaps and Launcher folders
3.3 6/9/1999 Added Schlumberger Vectron bitmaps and Launcher support
3.4 9/6/2000 Windows 2000 Build - corrected image background color JSP
3.5 6/6/2001 License contol added JSP
3.6 5/8/2002 Added Cosecutive Days Alarm Report JSP
Version 6.x.x
00 5/23/2002 Compiled with Centura 2000 JSP
01 4/30/2003 Remove license warning when no executive_master present in applications table. Added Version Tracking JSP
1.01 5/11/2007 Changed the "Shut Down" button to a say Close.
Version 2009.1.x
1.0 9/26/2008 Updated the application for the new release version 2009 under Mercury Instruments.
Version 2009.2.x
2.0 4/15/2010 Updated the application for the new release version 2009.2.0.

Audit Report
Version 3.x.x
00 1/6/97 Initial version number -LV
Version 6.x.x
00 5/7/2002 Compiled with Centura 2000
Version 7.x.x
00 12/7/2004 Updated the security model to comply with the Sarbanes-Oxley Act. Password now must be 8 characters long, contain upper and lower case letters and include numbers.
Version 2009.1.x
0.0 9/26/2008 Updated the application for the new release version 2009 under Mercury Instruments.

Autoload
Version 2009.1.x
0.0 9/26/2008 Updated the application for the new release version 2009 under Mercury Instruments.

Autoload Scheduler
Version 3.x.x
00 1/6/98 Initial version - LV
01 1/27/2000 Added new report scheduling period "Fixed Start to Current Hour" -- KMS
Version 6.x.x
00 5/6/2002 Compiled with Centura 2000 JSP
01 5/28/2003 Fixed problems with Cursor busy error and string truncation error JSP
Version 7.x.x
00 12/7/2004 Updated the security model to comply with the Sarbanes-Oxley Act. Password now must be 8 characters long, contain upper and lower case letters and include numbers.
01 2/30/2008 The SGN_Translator_Image table strayed from the standard Report_Image to ReportImage. It wasn't dicovered that this would be an issue until well after the translator was released to the customer. The app now looks for SGN_Translator_Image and handles it correctly.
Version 2009.1.x
0.0 9/26/2008 Updated the application for the new release version 2009 under Mercury Instruments.

Call Configuration
Version 3.x.x
00 1/6/98 Initial release - LV
Version 6.x.x
00 5/6/2002 Compiled with Centura 2000 JSP
01 10/31/05 Avoid data sample/call time overlaps JRR
02 12/07/05 Changed stored procedures for sample/call time overlap (AdjustCallTime, AdjustCallTimeForDataInterval and DidCallCrossIntervalBoundary) to return success even if unit is not configured. This avoids problems when a new unit is configured JRR
03 1/23/2008 Removed changes made in version 01 and 02 JSP
04 4/17/2008 Found an issue with an Invalid Cursor Error.
Version 2009.1.x
0.0 9/26/2008 Updated the application for the new release version 2009 under Mercury Instruments.
0.1 8/21/2009 Updated the windows so that the buttons on the bottom of the windows didn't get cut off.

Clear Data
Version 3.x.x
00 1/6/98 Initial version number -LV
01 2/11/98 Took out reference to cbSetCommandcount during autoload. Added list to select during autoload so list would work - LV
02 4/2/98 Added new db connect to handle lists-rc
03 9/17/98 Fixed Clear Forward - Update RU_input for TOC read - HM Fixed Set Command Control button - (variable name mismatch )
04 10/5/98 Added to the ClearAlarms() function the new table ALARM_DATA_FILE2 - KMS
05 11/30/98 Fixed Code to handle different Regional Date/Time System Settings - Fixed Clear Forward and Clear Normal to clear data from null date and to initialize RU_Input table when all data is cleared from Time_Of_Call Installed Progress Bar for Clear Data. Toggled (Enabled/Disabled) options in setup screen to reflect User's choice Fixed writes to Log Audit Trail for Special, Field and Report Factors --gfd
06 2/2/99 Took out all Updates to RU_Input -- gfdz
07 2/18/99 Completely revised the clear data proccess to optimize performance. Significantly reduced the amount of system resources needed to run along with the amount of time it takes to run the clear data process.Also, all known bugs with Clear Data and its AutoLoad function have been eliminated. The system default for 'Clear' has also been changed from clear 'System Wide' to clear 'Single RU'.Also will now clear AE_x000 corrector data tables,AE_Interval_Item_Data and AE_Read_Item_Data,but only on systems with corrector product_id in theRU_Master table.
08 4/08/99 Fixed two bugs- Out of memory error and sql statement error
09 8/9/99 Added support for clearing Vectron table Added function CreatevectronTrigger - KMS
10 2/8/2000 recompiled with new EDITAUTO library - KMS
Version 6.x.x
00 5/9/2002 Compiled with Centura 2000 JSP
01 8/7/2002 Fixed problem with ClearAudit always being called Removed some unnessasry SqlConnect/SqlDisconnect statements JSP
02 8/20/2002 Fixed a bug where if you deleted data after the Last_Updated_date_Time( clear forward without deleteing the partial ) within the last interval record it would move the Last_Updated_date_Time pointer incorrectly into the future. A similar bug was also clearing dialy_reading and the last_Updated_Date_Time in Last_DR_Date_Time JSP
03 2/14/2003 Added Version Tracking and fixed a bug with the Search buttons being disabled for certian options JSP
04 3/24/2004 Added ANSI clear data functionality. Fixed an 'Unrecoverable Error' Window not created that holds the a used variable. JSP
05 3/30/3004 Fixed a bug found by tech support before final release. The bug was a problem with clear forward not clearing all of the data for a remote device. JSP
Version 7.x.x
00 12/7/2004 Updated the security model to comply with the Sarbanes-Oxley Act. Password now must be 8 characters long, contain upper and lower case letters and include numbers.
01 8/20/2007 Removed the ability to perform a Clear Normal on Field Scale values. JSP
Version 2009.1.x
0.0 9/26/2008 Updated the application for the new release version 2009 under Mercury Instruments.
0.1 12/26/2008 Added clear for Asc_Interval_Data table for Mercury Corrector Text type interval and toc data
0.2 9/02/2009 Fixed a problem with the send all option not working for mercury correctors.
0.3 10/12/2009 Fixed a problem when using the Send All Option for ANSI devices.

Consecutive Days Alarm Report
Version 3.x.x
00 1/6/98 Initial version - LV
01 1/6/99 Fixed Autoload reports with a list name greater than 12 charaters. JSP
02 1/25/99 Added AE6000 alarms Only for Product_ID=92. JSP
03 3/26/99 Optimized WHERE clause in BuildWhereClause() when running report for a LIST. Report nows runs twice as fast on a LISTas it did before -- KMS
04 3/30/99 Debuged and Improved interaction with AE6000 Stuff
1.01 5/25/99 Modified to create ConsAlrm.apt - Consecutive days alarm report. Modified Where clause to sort by Alarm_id and added code to PrintRpt section. - HSM
1.02 2/9/2000 Recompiled to include new version of EditAuto.apl per KS - HM
1.03 4/17/2000 Modified to include disable security feature -HM
Version 6.x.x
00 5/6/2002 Compiled with Centura 2000 JSP
Version 7.x.x
00 12/7/2004 Updated the security model to comply with the Sarbanes-Oxley Act. Password now must be 8 characters long, contain upper and lower case letters and include numbers.
Version 2009.1.x
0.0 9/26/2008 Updated the application for the new release version 2009 under Mercury Instruments.

Corrector Configuration
Version 3.x.x
00 1/6/98 Initial version - LV
01 6/1/98 Fixed program disappearing when adding a corrector with copy option. - LV
01A 3/16/99 Updated help file for add corrector and child windows. -- gfd
01B 5/6/99 Updated cmbAddCorrector List Initialization. gfd
02 9/23/99 Modified to add Equimeter information, and correct add corrector bug -- HM
03 9/26/2001 Changed the UI for ease of use JSP
Version 6.x.x
00 5/23/2002 Compiled with Centura 2000 JSP
Version 7.x.x
00 12/7/2004 Updated the security model to comply with the Sarbanes-Oxley Act. Password now must be 8 characters long, contain upper and lower case letters and include numbers.
01 09/08/2008 Removed the Metertek Logo.
Version 2009.1.x
0.0 9/26/2008 Updated the application for the new release version 2009 under Mercury Instruments.
1.1 4/30/2009 Added the Merucry PA
1.2 5/19/2009 Did consderable work on adding/editing new parameters to correctors and added the ability to edit the class type for the Item Codes.
1.3 10/2/2009 Had to add the MERCURY TURBO CORRECTOR to the dropdown list for adding correctors

Correction Integrity Report
Version 3.x.x
00 6/4/98 Initial version number - LV
01 12/22/98 Fixed a bug with the "Multiple accounts per page" option - KMS
02 1/7/99 Was calulating the wrong end date for daily reading report. Also printed an exta line even when no readings were presant JSP
03 2/5/99 Historical averages was getting divide by zero errors Wouldn't report for more than a ten day window Couldn't change the correction factor correctly. JSP
04 3/1/99 Trapped for divide by zero in entire outline.
04A 3/16/99 Updated Help files for all dialogs and tabs. -- gfd
05 4/2/99 Changed title of HistoricalFactors window. JSP
08 11/29/99 Modified to work through Autoload. - HSM
06-07 1/7/2000 Reading Daily read data, Fixed "No Factors" error msg to appear on report, added Delete factors button. -HM
09 1/11/2000 Modified to fix missing data problems. -HM
10 1/13/2000 Modified to fix packed interval data missing record -uncorr volume. Also rearranged heading and print what type of report (summary/detail, packed_interval/daily_reading. Fix bug - null value not allowed in hour field --HM
11 2/9/2000 Recompiled to include new EditAuto.apl per KS - HM
Version 6.x.x
00 5/6/2002 Compiled with Centura 2000 JSP
01 4/30/2003 Added self-registering ability and version tracking to the applications table JSP
02 6/15/2004 Fixed a problem with the date time being calculated wrong for a detail report. Whenever the next record was selected from the datetime of the first interval was getting another interval size added to it incorrectly. JSP
03 11/16/2004 Fixed a bug that only displayed the "No Factor" error message only for single RU reports and not for Lists. JSP
Version 7.x.x
00 12/7/2004 Updated the security model to comply with the Sarbanes-Oxley Act. Password now must be 8 characters long, contain upper and lower case letters and include numbers.
Version 2009.1.x
0.0 9/26/2008 Updated the application for the new release version 2009 under Mercury Instruments.

Custom Reports
Version 3.x.x
00 1/6/98 Initial version - LV
01 3/13/98 Widened Layout editing window Fixed Header/Footer editing bug - KMS
01 3/25/98 Fixed problem where if no default printer was setup, no fonts would appear in font list - KMS
02 5/1/98 Fixed &UNIT and &UNIT_DESCRIPTION header bug; changed &DESCRIPTION to &INPUT_DESCRIPTION - KMS
03 8/17/98 Added Functionality Security using new table (users_and_security_functions) - HM
04 10/13/98 Changed FillConversionUnits() and FillSpecialConversionUnits() to get units from DATA_SCALE table, not DEFAULT_SCALE -- KMS
01 12/15/98 Fixed bPrintDLL so that PC7PRINT.DLL version would appear in "About" dialog - KMS
02 1/14/99 Added Members 26-400 to GetInputs() function. This was needed for ECI support - KMS
03 2/10/99 Fixed incorrect dates being formatted in CreateReport() function by preformatting them in SAM_AppStartup -- KMS Also fixed bug that was resetting IntervalSize to 1440 if the layout was a Merge report -- KMS (see DCS 740)
04 2/17/99 Added better support for Merge Accounts
05 3/25/99 Fixed column reference problem in dlgColOther.tblColAssoc -- KMS Changed "Interval" label to "Interval Consumption"
06 5/7/99 Updated Justification labels (Left, Right, Center) -- KMS
07 7/7/99 Fixed Justification 0=Left, 1=Center, 2=Right for all column editing screens
08 8/13/99 Fixed problem with printing to network printer, cancel print dialog now working and Print dialog not setting the default printer when selecting a printer to print to.
09 10/15/99 Added Single Header per Report/Page functionality
10 11/12/99 Deleteing layout needed to delete from custom_report_layout_extras before deleting from custom_report_layout
11 12/1/99 The description of the Calculted Pressure equation column was incorrect.
12 12/22/99 Added member totaling - JSP
13/14 4/3/2000 Added Html Graphing Support JSP
15 2/18/2002 Fixed problem with layout Header/Footer removing unwanted spaces from the layout JSP
Version 6.x.x
00 5/2/2002 initial version number - JSP
02 12/30/2002 Fixed a Conversion problem - Table columns string length didn't get correctly converted in the new version. Removed numerous unnessary sql connects and disconnects. Added version tracking to the Applications table - JSP
03 4/21/2003 Added Html file output JSP
04 5/9/2003 Added version tracking for CustRpt.dll, added trap for start date past end date JSP
05 8/7/2003 Fixed a problem with printer names being too long. The code now updates the custom_report_Image table to increase the size of the Printer_device columns to 255 characters. No need for a roll back script since the old CR will still run correctly with the wider columns. Also fixed a problem in pc7print 6.0.0 with autoloaded reports always going to the default printer regardless of how they are saved in CR.Also added version tracking for Pc7Print.dll. JSP
06 12/8/2003 Fixed a problem with autoloading printed reports. A database string with 255 characters or more requires a Long String type. This is what was needed for the long printer names to work correctly with autoload
07 12/12/2003 Fix in 06 caused the List ID and Account_ID for a saved image not to be displayed correctly. It appeared as if the List ID or Account_ID wasn't saved. JSP
08 1/7/2004 Fixed a bug when running autoload the dat/time wasn't getting converted correctly causing the hour to start/stop at midnight JSP
Version 7.x.x
00 12/7/2004 Updated the security model to comply with the Sarbanes-Oxley Act. Password now must be 8 characters long, contain upper and lower case letters and include numbers.
Version 2009.1.x
0.0 9/26/2008 Updated the application for the new release version 2009 under Mercury Instruments.

Daily Read Build
Version 3.x.x
00 1/6/98 Initial release
01 5/18/98 Fixed CA0/CA1 build - LV
02 06/16/98 added start and end clock
03 06/24/98 added = sign so CA1 will build for current date - LV
04 08/26/98 Change CA0/CA1 code to use stored procedure "AddDailyReading" to make the build run faster; Removed functions 'AddDRRec' and 'StoreDailyReading' - KMS
05 10/20/98 Made yet another change to the Start Time/End Time used by DRBUILD when called via AUTOLOAD in SAM_AppStartup - KMS
05.1 10/27/98 KMS
06 2/4/99 fixed a bug in the select statement for CA0/CA1's in function BuildDailyReads
07 6/15/99 added "Other Options" datafield to reflect the contents of the "Wildcard_String" field that already existed in the BUILD_DAILY table. The Wildcard String is now only used to indicate whether to build DAILY_READING records only (no reads). This option was added primarily for Transco -- the daily read build takes up to 20 minutes LONGER on the 1st day of the month because it also has to create the records in the table. Now they can create the records independently of building the reads.
08 10/22/99 added the "All inputs" radio button to allow users to build reads for ALL inputs in one easy step. This option also required the changing of the GETTOCLIST_DRBUILD stored procedure in the database -- KMS
09 10/27/99 Fixed a problem when you pressed "NO" in answer to the "Do you want to build daily reads" prompt -- KMS
10 11/10/99 Fixed the "All inputs" algorithm to include CA0/CA1's -- KMS
Version 6.x.x
00 5/6/2002 Compiled with Centura 2000 JSP
01 5/2/2003 Fixed a problem when the last record in Packed_Interval contained all Missing records Also added version Tracking for the app and DLL JSP
Version 7.x.x
00 12/7/2004 Updated the security model to comply with the Sarbanes-Oxley Act. Password now must be 8 characters long, contain upper and lower case letters and include numbers.
Version 2009.1.x
0.0 9/26/2008 Updated the application for the new release version 2009 under Mercury Instruments.

Data Collection
Version 2009.1.x
0.0 12/01/08 Added full Item Code support while removing the fixed audit trail configuration for Mini-Max Mini-AT and ERX direct communications devices. This was done by changing the method that the audit trail is read in and processed by DP. DC now reads the configured Item Codes from the device and writes that configuration to the raw file. DP then uses that information to match the downloaded audit trail to the RU_Input configuration. Added next call time scheduling to the Direct Mercury Driver. Improved the AT Modem handler to be more robust and recover from errors durring initialization. Added Full Alarm Log support for added Mercury devices.
0.1 12/15/08 Fixed a popup warning message about tmp_y_buf being used without being initialized first.
0.2 1/6/09 Added extensive buffer checking and content validation for the Mercury driver. Fixed a possible error condition that could invalidate the channel trace file handle and cause a DC restart.
1.0 1/29/09 Added the Mercury IP Server. This server allows dialouts to Mercury IP devices.
2.0 2/09/09 Added support for CNI-2 based firmware downloads that write to memory above the first 64K.
2.5 8/13/09 Fixed some problems with ECI's working in transparent mode. Disabled Call Back Time for ECAT's since they don't support it. Made it so when a 4 Channel corrector has 225/226 in the audit trail it requests 0/2 index reads for the time of call value. This allows Daily Read Build to run on the device.
2.6 8/19/2009 Improved the Mercury device IP login handler to connect more reliably when the device thought it was still connected to a previous session. Fixed a problem that caused the write items not to go out to remotes on the Mercury IP Server. Fixed an issue when dialing out via the Mercury IP server and the wrong device type answered the server would go into retry incorrectly. Added extended traces for dialing out to an incorrect unit (Device IP address used for 2 different units). Fixed a problem where the last input from mercury correctors was sometimes not requested from the device.
2.7 8/28/2009 Fixed a problem with connecting to ECAT's. DC was incorrectly using the newer RG command that wasn't supported on the ECAT.
2.8 9/03/2009 Fixed a problem with a buffer overrun condition when asking for too many records in a sigle packet from a Pulse Accumulator.
2.12 9/18/2009 Improved the Mecury logon sequence by sending an XON character to try to recover from a timeout error.
2.13 9/21/2009 Made changes to support the Mercury Pulse Accumulator.
2.14 10/06/2009 Made changes to the IP Server to accomodate the PA.
2.15 10/12/2009 Added the ability to use Site ID 1 or Site ID 2 for Mercury Devices.
2.16 11/10/2009 Added parameter sanity checks for calling the stored procedure that calculates the next call time. Added parameter checks to the TimeCls so that function calls with bad parameters would not crash DC.
2.17 12/14/2009 Reduced the command retry rate to 3 attempts to read a particular value from a Mercury Corrector. During the read of a device some portions of the code were not exiting in a timely manner when the device connection was lost. After the 3 attempts to read an item from the device have failed DC will fail the call in a more timely fasion.
2.18 JSP 2/17/2010 Added Event Log Support for Mini-AT and Mini-Max
2.19 3/15/2010 Fixed an issue that was causing Meteretk AT Modems to hangup before they answered the incoming call. The Line Feed character that was being sent in the ATA\r\n command was causing the modem to go back into command mode before the modems could handshake.
2.20 4/9/2010 Fixed an issue where some of the newer correctors were not getting item code 338 cleared to indicate good call for the device. Cleaned up the AT modem command handler so that there wasn't any unnecassary data going to the modem.

Data Processing
Version 2009.1.x
0.0 12/01/08 Added full Item Code support while removing the fixed audit trail configuration for Mini-Max Mini-AT and ERX direct communications devices. This was done by changing the method that the audit trail is read in and processed by DP. DC now reads the configured Item Codes from the device and writes that configuration to the raw file. DP then uses that information to match the downloaded audit trail to the RU_Input configuration. Added Full Alarm Log support for added Mercury devices.
0.1 1/7/09 Found an incorrect alarm mapping for the Mini-Max and correctly mapped it to the correct alarm.
0.2 1/22/09 Fixed a problem that occurs when requested Time of Call data values are not present in the list available in the audit trail.
1.0 1/29/09 Mercury devices: Time of call values for inputs recording interval consumption, Item codes 225 and 226, are being mapped to the corresponding Index values Item Codes 0 and 2 respectively. This will allow daily read build to work with the correctors. For example, if input 1 is configured asItem Code 225 the Time of Call information for that input will be pulled fromItem Code 0, the meter index reading. Fixed an issue that was causing the patial not to show up correctly for MINI-MAX devices.
1.3 8/13/09 Fixed some problems with ECI's working in transparent mode. Fixed a problem that when a 10 channel corrector calls in with 225/226 configured it doesn't implement the 225/226 -> 0/2 time of call mapping.
2.0 8/31/09 First release of the email data processing.
2.1 9/10/09 Found some issues with email processing that were causing data gaps.
2.2 9/21/09 Had to make some minor changes to support the Pulse Accumulator.
2.3 10/21/2009 Made further changes to the 225/226 mapping to 0/2 for time of call data. This mapping happens for all TOC readings regardless of the number of inputs. For inputs with Item Codes 0/225 2/226 Packed interval will always hold the interval data, 225/226, and time of call will hold index readings 0/2.
2.4 12/18/2009 Added support for Orbcom satellite file type 50 processing.
2.5 1/8/2010 Added the PLog Alarm support for the Mini-AT, TurboCor, AccuTest product types.
2.6 1/29/2010 Found a bug in the mapping routine for corrector devices that need 225 and 226 mapped to 0 and 2 for time of call data
2.7 4/9/2010 Found more problems mapping routine for 225 and 226 to 0 and 2. This should be the final change.

Data Resyncronization
Version 3.x.x
00 1/6/98 Initial version 3 - LV
01 07/28/98 Fixed problem with synching more than one input. Took out Preview button. just preview after user selectsno more synching inputs.
02 10/8/98 make sure when updating the 60th interval we are updating the 59th interval -rc
Version 6.x.x
00 5/6/2002 Compiled with Centura 2000 JSP
01 7/30/2002 Fixed problem with OK button being disabled JSP
02 3/4/2003 Fixed a problem with program getting stuck in a loop when click OK in dlgTOCTIC JSP
04 12/8/2003 Fixed a problem that was causing the screen to look like it was doing a resync and changing the screen information but made no changes to the database. This would all happen when the user would press the cancel button while doing a resync.
Version 7.x.x
00 12/7/2004 Updated the security model to comply with the Sarbanes-Oxley Act. Password now must be 8 characters long, contain upper and lower case letters and include numbers.
Version 2009.1.x
0.0 9/26/2008 Updated the application for the new release version 2009 under Mercury Instruments.

Data Status Report
Version 3.x.x
00 1/6/98 Initial version number - LV
01 2/9/99 Fixed problem with running on the wrong list Fixed printing cancel button fixed problem with sql server locking up Cleaned up the printed report JSP
02 2/24/99 Fixed printing bug JSP
03 3/22/99 Now checks to see if an input is saving a particular type of data (ie. interval or daily reading) before it prints whether or not the data is missing, eliminateing unnecessary information in the report.
04 3/23/99 Found and fixed autoload bug. JSP
05 3/24/99 Fixed bug caused by fixing bug with autoload process. JSP
06 9/01/99 added bKMS to PrintRpt() in order to switch off CR/LF for every RU; the report was printing a CR/LF for every RU in the list, even if no data was printed for that RU -- KMS
07 2/8/2000 recompiled with new EDITAUTO library - KMS
Version 6.x.x
00 5/6/2002 Compiled with Centura 2000 JSP
01 7/23/2004 Added Version Tracking, Fixed a bug where it would show missing data before the actual report start time. The missing data would show up for data in the same packed_interval record that was before the actual start time of the report.
Version 7.x.x
00 12/7/2004 Updated the security model to comply with the Sarbanes-Oxley Act. Password now must be 8 characters long, contain upper and lower case letters and include numbers.
01 08/07/2007 Fixed a problem that was causing autoloaded reports to have a different output than when ran manually.
02 05/16/2007 Fixed an endless loop issue when running autoloaded reports. JSP
03 06/04/2008 Changed printer variables to Long String JSP
Version 2009.1.x
0.0 9/26/2008 Updated the application for the new release version 2009 under Mercury Instruments.
0.1 12/15/2008 Fixed a problem when the report was going to a File only and the printer could not be connected to. The application would pop up a message box and tell the user of the print error which hang any other autoloads until the box was acknowledged.

Data Viewer
Version 06.x.x
1.00 7/1/2003 Initial release. JSP
1.01 7/10/2003 Fixed a problem with ansi data not being correctly retrieved.JSP
1.02 7/17/2003 Fixed a problem with ansi present register data using the wrong data_type for table a23_register_data. JSP
1.03 7/18/2003 Fixed a list box drawing problem incountered on Window NT The problem happend when the CDBList class had to drawa text string with an elips. The problem was fixed by truncating the string and adding the elips by hand. JSP
1.04 7/22/2003 Added printing, "Change Values" ability. JSP
1.05 9/17/2003 Fixed a problem with date time conversion when the users computer is set for dd/MM/yyyy and the database is set for mdy. The code now calls the new CLocalFormat function GetOdbcDateFormat function which returns the correct format for the SQL server database and calls the "SET DATEFORMAT" T-SQL function with the appropriate argument - mdy, dmy, ymd. JSP
1.06 9/30/2003 Fixed a problem with data from the AE_Interval_Item_data table not being sorted correctly. JSP
2.00 10/3/2003 Added Insert and Delete capabilities for ANSI and AE data. JSP
3.00 10/4/2003 Added support for editing data in field and report units JSP
4.00 10/6/2003 Added Syncronized scrolling.
5.00 12/19/2003 Added complete list of standard metretek data status flags to ANSI data
5.01 2/12/2004 Fixed the Daily Readings so that the Daily read hour was used when calculating the Date/Time. JSP
5.02 2/26/2004 Fixed an oversite when the last TOC reading for a remote device was updated it didn't update RU_Input with the new reading. JSP
5.03 4/20/2004 Fixed a problem with the Audit Trail Inserts when the date/time format was something other than MDY. JSP
6.00 9/16/2004 Changed the end date of the default window to 1 day into the future. JSP
6.01 5/26/2005 Set the Export_Flag to 0 when edited in Packed_interval, daily_reading, Time_of_Call, AE_Read_Item_Data, and AE_Interval_Item_Data.
6.02 7/12/2005 Fixed a problem with the field units not displaying the correct unit description
Version 07.x.x
0.1 10/17/2006 Fixed a bug that would occur when deleteing all of the time of call records for a new device after the first unit reset call.
1.1 5/29/2007 Initialized dwMaximized to zero to eliminate the Error message that the variable was being used without being initialized.
1.2 5/14/2008 Removed the dynaset option from some of the CRecordset objects in hopes of fixing an SQL Server 2005 error message.
Version 2009.1.x
0.0 10/9/2008 Added new text type data record table for mercury device data. Updated login and about windows to the new mercury logo. Updated version number to 2009.
0.1 5/11/2009 Fixed an issue where the report units weren't being displayed properly when changing scale factors in the table view drop down.
0.2 8/22/2009 Fixed a problem where Text type data wasn't being displayed for product ID's 90,91, and 93.
0.3 9/23/2009 Changed thr registry location for saving variables from HKEY_LOCAL_MACHINE\Software\Metretek to HKEY_CURRENT_USER\Software\MercuryInstruments
0.4 1/26/2010 Fixed the Login Window to correctly display the system version number.

Dialout
Version 3.x.x
00 1/6/98 Initial version - LV
Version 6.x.x
00 5/6/2002 Compiled with Centura 2000 JSP
01 4/1/2003 Added support for dialing out to devices connected by transparent units. Added Version Tracking JSP
02 4/16/2003 Added code to automatically create the RU_Master_Slave table if it isn't in the DB JSP
03 3/12/2004 Fixed bug with Unrecoverable error, window variable not created for Autoloaded reports
Version 7.x.x
00 12/7/2004 Updated the security model to comply with the Sarbanes-Oxley Act. Password now must be 8 characters long, contain upper and lower case letters and include numbers.
Version 2009.1.x
1.0 4/1/2009 Added the ability to clear all pending dialouts. This was done to fix the occasional problem of a dialout getting stuck in the system.

Electric Reports
Version 3.x.x
01 12/01/99 Initial version number - JSP
02 12/09/99 Added seconds to the date string passed to elecrpt.dll so the dll could convert it correctly. - JSP
03 12/15/99 Added Show Demand checkboxes - JSP
04 12/22/99 Added member totaling - JSP
Version 2009.1.x
0.0 9/26/2008 Updated the application for the new release version 2009 under Mercury Instruments.

Executive
Version 2009.1.x
0.0 9/26/2008 Updated the application for the new release version 2009 under Mercury Instruments.
0.1 12/17/2008 Updated the display colomn name "Restarts" to "Restarts Per Day" to avoid confusion when the user closes a monitored application one or more days after it was started and it restarts. "Start All Processes" no longer requires a "Stop All Processes" to restart single applications.

List Configuration
Version 3.x.x
00 1/7/98 Initial version number -LV
3.2.01 4/13/2000 Modified to fix ambiquity of Search button. A Sort button added for the List Members. - HM
3.2.02 5/10/2001 Fixed appeance for Windows 2000 JSP
3.2.03 7/25/2001 Changed the way the list is rebuilt after saving the list - was causing problems with replication JSP
3.2.04 2/18/2002 Fixed problem with Allow Duplicates not working, added move up/down option to list window JSP
Version 6.x.x
00 5/23/2002 Compiled with Centura 2000 JSP
Version 2009.1.x
0.0 9/26/2008 Updated the application for the new release version 2009 under Mercury Instruments.

Multi-Member Corrector Config
Version 6.x.x
00 5/23/2002 Compiled with Centura 2000 JSP
Version 2009.1.x
0.0 9/26/2008 Updated the application for the new release version 2009 under Mercury Instruments.

Multi Member Configuration
Version 3.x.x
00 1/6/98 Initial version number - MG
01 08/01/98 Additions rc
02 02/08/2000 recompiled with new EDITAUTO library - KMS
Version 6.x.x
00 6/24/2002 Compiled with Centura 2000 JSP
01 4/14/2003 Added Version Control
02 9/2/2003 Fixed a problem with remote fesibility alarms not being sent to the remote Units by data collection JSP
03 1/24/2004 Fixed a problem with invalid hStmnt error. JSP
04 1/26/2004 Extension of 6.0.03 fix: The problem was with the way the tables were being filled, by using FillNormal instead of FillAll. Once a user had added more than 40 Images to the table, the table would leave data in the query result set and only retreive it if the user actually scrolled the table all the way to the bottom. This would force the table to retreive all of the rows and free the connection for another query. All tables now use TBL_FillAll and have the Discardable Option set to NO, as well as having an oversized Max Rows In Memeory value. JSP
Version 2009.1.x
0.0 9/26/2008 Updated the application for the new release version 2009 under Mercury Instruments.
0.1 02/19/2009 Found and fixed a problem with with the word UPDATE being misspelled in the autoloaded query.

Overdue Report
Version 03.x.x
00 1/6/98 Initial version number - LV
01 1/12/99 Fixed date bug when running via autoload - KMS
02 02/08/2000 Recompiled with new EDITAUTO library - KMS
03 02/29/2000 Added LIST support fixed RU_ID column to print 12 chars - KMS
04 04/19/2000 Added support for Web Reports - JSP
05 5/16/2000 Added CDF file support for INETReporter
06 2/6/2001 Fixed problem with Autoloaded reports not generating a file JSP
07 3/21/200 Fixed display colors for Win 2000 JSP
Version 06.x.x
00 6/24/2002 Compiled with Centura 2000 JSP
01 9/06/2007 Fixed a problem when autoloading reports
02 5/2/2008 Fixed a problem with WebReports not correctly creating reports
03 5/16/2008 Fixed a problem with the select printer dialog always popping up for autoloads
04 6/04/2008 Changed printer variables to Long String JSP
Version 2008.x.x
0.0 9/26/2008 Updated the application for the new release version 2008 under Mercury Instruments.
1.0 3/11/2009 The report reference date was changed to the current date time because it was confusing for users to have to set the start time of the autoloaded/web report to the current time in order to see what units were currently overdue.

Reldial.exe
Version 2009.1.x
0.0 9/26/2008 Updated the application for the new release version 2009 under Mercury Instruments.
1.0 1/29/2009 Added dialout token for the Mercury IP Server. JSP

Remote Unit Configuration
Version 3.x.x
00 1/6/98 Initial version number - MG
01 1/22/98 Fixed sql cursor errors Fixed date/time format in remote units input table - LV Added audit trail messages that reading was changed and made sure that the time_of_call was changed when you synched in ru_config.
02 2/10/98 Fixed spelling of synchronized on input table and pop up box
03 5/22/98 When filling the hardware alarms table for an eci we want to find out what kind of corrector we are hooking it up to.
04 08/10/98 Changes for direct connect ECAT (16) and ER (17) devices rc -Show relay tab for SIPS and IMU and disable the relay and Party Line tabs for ECI, ECI2, ER and ECAT -Allow only maximum of three relays per remote unit. -Make sure the user can change SET/RESET button for selected Relay that already exists-If a user changes SET/RESET button reset Relay_Failure_Count column in relay_type table for remote unit and set relay_changes to TRUE-Set relay_changes to TRUE if adding new relay-Allow the user to only delete the last Relay. So when a user selects a relay other than the last relay disable the pbDeleteRelay button.-Disable Party Line Information Tab for now.-Disable Next Call and Available Call profiles for ECI, ECI2, ER and ECAT in Call Information Tab-Hide corrector type, corrector firmware version, Control check box for ER and ECAT only in General Information Tab -Hide special command control and special command count for ECI, ECI2, ER and ECAT in General Information Tab. Display ECI_Send_All_Start_Time date and time field if Send All is selected in Standard command control in General Information Tab -Expand the tblRemoteUnitInputs to display more inputs -If resynching a remote unit input a user double-clicks the current value of the tblRemoteUnitInputs in the Input Description tab. A dialog box pops up with a read and a synch check box. If the reading is correct but the user clicks on the check box then do update of the Current_Meter_Reading and MR_Syncd values in ru_input table -Rearrange the Input Configuration dialog box. If the product type is ECI, ECI2, ER or ECAT then grouped data description with cbInterval and cbTimeOfCall -Two check boxes (cbInterval or cbTimeOfCall) to display just those MIL descriptions for Interval versus read/write. -Display those MIL descriptions for the appropriate Corrector i.e. ER or ECAT, all MIL descriptions will be displayed for all other product types. There is -Make sure that the colFieldEffectiveDate and colReportEffectiveDate are using correct picture format for the date-per Darrel, enable next call date time for ECI1 and ECI2 if ER and ECAT display corrector type and corrector firmware version but dont allow user to change them -if ER, ECAT,ECI1,ECI2 then enable dfCorrectorWriteItems and it is not read only
05 11/18/98 change all inputs when changing inputs interval size and fix getting message that TOC has changed, when adding new inputs for eci, eci2,ecat and er get the number of inputs from default ru_input
06 12/23/98 Modified Rucnfg.apt to speed up the process when a Ru Input Number was added, edited or deleted. Fixed the program so that the time_interval factors are constrained to one time_interval. The program will not hang when the last RU_input is deleted for a particular RU_ID. Fixed RU_factor_delete so that ONLY the last (greatest) input_factor_number can be deleted. Modified dlgInputConfiuration,SAM_CreateComplete to behave properly according to which Product_ID and which ACEReading is being added. Deletes from the file Corrector_Write_Items when deleting from inputs from Input_configuration. Set ECAT, ER, ECI, ECI2 inputs to Actual when adding in Input_Configuration, in the table (Other required CALCULATED). dfCorrectorWriteItems in dlgInputConfiguration correctly stipled. -- gfd
07B 01/08/99 Program now defaults to previous assigned interval sizes when adding or configuring a new ru_input ensuring that all interval sizes for the Remote Unit will have the same value. When deleting ru_inputs without selecting the last input, the program refreshes the table to show empty. However if the table is empty it will not allow any more deletions. The program deletes the RU_input when delete button is clicked on regardless if the RU_input is selected or not. If there is Interval data assoiciated with the ru_input, Input_Configuration will disable cmbIntervalSize accordingly. Therefore, to change the interval_size after Interval data has been collected user must clear ALL interval data first. (This now applies to all Product_IDs). -- gfd
08 02/03/99 Account Notes field was not being saved. Uncommented Sql statement for insert to Account_Note Table. -HM
08A 02/05/99 Enabled sync check box for product types CA0 ,CA1and CA2 when ACEReading = 65 (Actual) Slapped the name on the title fields of input configuration and edit remote unit data. -- gfd
08B 03/04/99 Updated program to process MINI-AT's identical to the way ECATs DTE ver 5.23. "Piggy-backed" command_bytes_special to store the modem type used for ECATs, ERs and MINI-ATs. Synchronized flag checked for ALL ECAT, ER, and MINI-ATs inputs. -- gfd
08C 03/15/99 Updated help context numbers on dlgProductTypeChange.
08D 03/18/99 Fixed Special Command Control bug (Not populating the combo box) and updated help files for adding and editing field and reports units. - gfd
08E 03/19/99 Fixed logic problem with modem selection. Installed --> If NOT((a=c) or (b=c)) for(a!=c) or( b!=c) in entire program. -- gfd
08E1 05/05/99 Enabled peak checkbox for CA1 and CA0.
08F 05/05/99 Tried to correct data input description. dfInputDesc truncates input from cmbMILDescription. Can't change database due to C++ apps. -- gfd
3.2.01 6/14/1999 Changed bFeasibilityEnabled to look at Alarm_Num instead of Alarm_ID in HARDWARE_ALARMS -- KMS
3.2.02 8/27/1999 Modified to search by product_desc and add/modify/delete product_id 92 and 94 - call Aeconfig.exe and Vconfig.exe accordingingly Also added new security to RUCONFIG - HM
3.2.03 9/23/1999 Added Equimeter EC3000 and Equimeter AutoCorector information ( system password/edit password) Update Ru_Master parameter_changes =1 when interval size changed Update Ru_Input parameter _id =-1 for Equimeter input 1 Fill Hardware Alarm List correctly for each type ECI-II corrector - HM
3.2.04 9/27/1999 Fixed Edit of Input 1 to default to parameter_id = -1 for equimeter - was using default parameter id instead of actual value
3.2.05 11/01/1999 Fixed the "description" field in the dlgInputConfiguration to handle 30 chars instead of 25 Fixed the Hardware alarms window to display the User Defined alarms by default Fixed the query that selects Remote Feasibility alarms KMS
3.2.06 11/22/1999 fill Hardware Alarm list correctly for MINI AT connected via ECI-II -- KMS
3.2.07 11/30/1999 fix the query that selects Central Feasibility alarms -- KMS
3.2.08 02/07/2000 Fixed problem with resynch box not updating TOC - problem with date format - Took out automatic update of input description, Added Change Description button. HM
3.2.09 03/02/2000 Modified to add Sconfig application calls, and fix Site Id Tab - Name field to length - 25 - HM
3.2.10 04/17/2000 Modified to fix disable security feature - HM
3.2.11 07/20/2001 Added code to support the MINIMAX-AT product ID 98 / Cleaned up alot of code JSP
3.2.12 09/28/2001 Verified that there where no hard coded exterioir refences to the MINIMAX-AT JSP
3.2.12 10/2/2001 Fixed a problem where selecting ECI when adding a ru would cause a SQL Error JSP
3.2.13 5/9/2002 Fixed a problem with Effective Date Time in Field_Scale containing seconds and not being able to edit the record JSP
3.2.14 6/2/2002 Added Per device licensing control JSP
Version 6.x.x
00 6/24/2002 Compiled with Centura 2000 JSP
01 7/23/2002 Fixed a problem with not all unit types not getting set to IP enabled Correctly JSP
02 7/26/2002 Fixed a another problem with not all unit types not getting set to IP enabled Correctly JSP
03/04 7/27/2002 Fixed a problem with the TOC getting set for a rysync every time the unit was edited
05 9/3/2002 Changed the size of the Interval Size drop down box
06 11/13/2002 Fixed a problem with CPA and CMU Feasability Alarms not displaying/updateing correctly Also changed the name of feasability alarms to Remote Data Alarms and Central Data Alarms Also did a major clean-up of the code JSP
07 1/15/2003 Added code to make sure that the ANSI tables are present before trying to delete a Device JSP
08 3/3/2002 Fixed bug in License code that would not allow units to be added regardless of their ability to to be IP Enabled. Currently only IP Enabled devices AND Non-Metretek Correctors are counted for per device Licensing JSP
09 3/31/2003 Replaced the following three long, expensive, buggy function calls with two SQL statments. JSP
10-15 4/11/2003 Added ANSI device support .JSP
16 4/15/2003 Added ValidateDeviceCount function call on shutdown JSP.
17 4/15/2003 Fixed a problem with DP not processing units that SW_Inputs in RU_master didn't match the number of inputs in RU_Input. JSP
18 4/16/2003 Added code to automatically create the RU_Master_Slave table if it isn't in the DB JSP
19 6/17/2003 Added the Send Configuration option to ANSI devices when creating a new device JSP
20 7/10/2003 Fixed a problem deleteing Field Units JSP
21 12/1/2003 Fixed a problem with the report scale fators for ANSI devices. It was only editing the first unit in the list and not adding new unit types to the default list of unit types. JSP
22 12/10/2003 Started using LogAudit2 fro better audit trail logging performance.
23 12/18/2003 Fixed a problem with the input current reading not being displayed correctly after the field had been edited in the input configuration screen
24 2/2/2004 Fixed the display of scaling factors so that they would round off the rounding errors and not display the data in exponetial form. JSP
25 3/18/2004 Fixed the Report Units delete button so that now it will work.
26 7/23/2004 Fixed a problem with an update statement. The Update RU_Input statement was too large to be handled using variables like :nRU_Input_Num. These centura variables were replaced by string literals that didn't require translating by Centura or the ODBC driver. This bug only shows up on some older computers, possibly from a DLL mismatch problem from some recently installed software on the Client machine.
Version 7.x.x
1.00 2/15/07 Update the Local Distribution Zone for SGN for new table RU_MASTER_EXT for SGN JRR
1.01 5/1/07 Added Maintenance Screens to display new remote maintenance table for SGN JRR
1.02 5/7/07 Added 5 new fields to site info tab and 5 new fields to the RU Input screen for the New database tables RU_CONFIG_EXT and RU_INPUT_EXT for the SGN project JRR
1.03 5/19/07 Help Screen Work for New Maintenance Screen JRR
1.04 5/22/07 Make combo box pulldowns not editable, added RU selection dialog to Add Maint JRR
1.05 6/11/07 Support AC powered check box on General Info Tab JRR
1.06 7/19/07 Fixed a problem on some clients getting an INSERT error on RU_Master_Ext JSP
1.07 8/14/07 Added Text Notifications to the remote maintenance tab to alert the user that colored maintenance records belong to a different remote unit. JSP
1.08 8/15/07 Added Audit_Trail Logging for deleted maintenance records JSP
1.10 2/21/08 Added push button for display of cellular parameters to the call Info Screen Hide Maintenance Screen and SGN Parameters if not SGN site JRR
1.11 5/14/2008 Enable the next call time and firmware version
Version 2009.1.x
0.0 9/26/2008 Updated the application for the new release version 2009 under Mercury Instruments.
1.0 1/29/2009 Device licenseing now counts all devices and not just IP enabled devices.
1.1 3/9/2009 Cleaned up the Input Data Types for Correctors. Also added a button on the RU Input tab to enable the user to set the current input configuration to the default input configuration for the specified product type.
1.2 3/26/2009 Fixed an issue with the maintenance index validation. It was incorrectly calculating the number of decimal places if they where none there. Removed the String Trim for the Serial Number per a customer request. It was triming multiple spaces in the middle of the field which was causeing problems in their downstream billing processes.
1.3 8/05/2009 Fixed a problem that was causing the ru_input Parameter_ID not to be set. The ECI Configuration was fixed.
1.4 8/22/209 Fixed an issue that was causing the parameter_id in ru_input to incorrectly get set to 0 for input 1 when adding a corrector device to the system.
1.5 8/28/2009 Fixed an issue where the modem type for newer correctors wasn't getting saved.
1.6 9/28/2009 Added the ability to convert an ECI / ECI-II into the corrector it is attached to.
1.7 10/23/2009 Changed the way the hardware alarms are converted when changing a device type from an ECI into the device it is attached to.
1.8 12/18/2009 Fixed a SQL Cursor Error when converting a CPA into an IMU.
1.9 4/06/2010 Disabled the Instrument Type selection for ECI and ECI2. It was causing problems when customers thought they could replace a corrector with a different corrector type.

Remote Unit Search
Version 3.x.x
00 1/6/98 Initial version - LV
Version 6.x.x
00 6/24/2002 Compiled with Centura 2000 JSP
Version 2009.1.x
0.0 9/26/2008 Updated the application for the new release version 2009 under Mercury Instruments.

Remote Unit Summary Report
Version 3.x.x
00 10/9/95 Starting revision
01 06/03/98 If all is not checked then process = < > rc
02 09/08/98 Fixed reference to "Dial_Out_Phone_Num" - the query was looking for "Dial_Out_Phone" and returning an SQL error -- KMS Also defaulted the "How" tab to check "ALL"
03 02/25/99 Fixed error messages - SP
03A 3/16/99 Updated help contexts. - gfd
04 6/17/99 Fixed the error with the SQL statement being built incorrectly ie "SELECT DISTINC FRO" JSP
05 02/08/2000 recompiled with new EDITAUTO library - KMS
06 02/16/2000 added more columns from which to select data; fixed "Less Than" bug; fixed date bug in SQL statement (quotes weren't being added) fixed bug that caused improper SQL statements when columns were re-arranged Added a "All Inputs" option Set colun defaults to "All", so a report can be printed immediately after creation (you don't have to modify each column first) KMS
07 02/17/2000 KMS - added "rui.ru_input_num = amc.ru_input_num" to WHERE clause when Account or List is selected, so that only inputs that are in the account get printed
08 03/15/2000 KMS - fixed the WHERE clause builder for the "All Remote Units" option. Also fixed a problem that forced a user to restart RUSUMM in order to see the proper output after making a change to the layout.
09 02/14/2001 JSP - fixed problem with the setup window not displaying the correct list
Version 6.x.x
00 6/24/2002 Compiled with Centura 2000 JSP
01 7/30/2002 Fixed problem with search button JSP
Version 2009.1.x
0.0 9/26/2008 Updated the application for the new release version 2009 under Mercury Instruments.

Router.exe
Version 2009.1.x
0.0 9/26/2008 Updated the application for the new release version 2009 under Mercury Instruments.

Show Procrss Information
Version 2009.1.x
0.0 9/26/2008 Updated the application for the new release version 2009 under Mercury Instruments.

Special Factors
Version 3.x.x
00 01/06/98 RC
Version 6.x.x
00 5/23/2002 Compiled with Centura 2000 JSP
Version 2009.1.x
0.0 9/26/2008 Updated the application for the new release version 2009 under Mercury Instruments.

Standard Correction
Version 3.x.x
00 08/04/98 Initial version number - RC
3.2.02 08/99 Modified to fill data gaps from max date-time on PI to end date time asked for - prior to insert data
3.2.03 09/1/99 Modified to fix bug where calculation repeat after no data found for date range requested (bmissingrow)
3.2.04 12/17/99 Modified before fill pi flow acct stored procedure to check max-date against start date- HM
3.2.05 12/28/99 Take out above modification and found bug where dtLastRowDate not being incremented (problem with updating/appending data - past end of data ) -HM
3.2.06 1/18/2000 Modified to add help and fix start date/time + 1 interval size - make work for matching interval size. - HM
3.2.07 2/9/2000 Recompiled to include new EditAuto.apl per KS - HM
3.2.08 2/10/2000 Modified to add trace file to autoload -HM
Version 6.x.x
00 7/1/2003 Compiled with Centura 2000. Changed ATOM method for checking for a previous Instance of the app. Added version tracking. JSP
01 8/8/2003 Fixed multiple problems with invalid sql handles busy errors. Also significantly sped up the application JSP
02 8/14/2003 Fixed a similar problem that was occuring in ver 01 for autoloaded report JSP
Version 2009.1.x
0.0 9/26/2008 Updated the application for the new release version 2009 under Mercury Instruments.

System Configuration
Version 3.x.x
0 01/06/98 RC
1 02/03/99 Modified to save a unique number in the "Machine Num" column in DC_Config table for each Machine. Was causing Data Collection problems.
3 04/15/1999 Changed Data Collection "ports enabled" scheme to use an environment variable called "METCONN" instead of a registry setting. -- KMS
4 05/19/1999 Added Schlumberger to the list of Comm Drivers and updated the related port enabling functions -- KMS
5 08/02/1999 Changed "Schlumberger" labels to "Schlumberger Vectron"
6 03/17/2000 Fix bug for editing channels already enabled , also fix break point message in copy machine logic - HSM
10 11/2/2000 Fixed a bug when saving an alarm handler process. message "Unrecoverable error... " JSP
11 5/31/2002 Added support for Internet Data Collection JSP
12 6/13/2002 Added enable/diable field to IP ports to enable the Port Number field. JSP
Version 6.x.x
00 6/24/2002 Compiled with Centura 2000 JSP
01 9/25/2002 Fixed problem with moving process not updating Alarm_Box_Config JSP
02 10/11/2002 Fixed problem with DC_Config data being inserted as wrong type JSP
03 11/15/2002 Fixed a SQL error when updating dial out configuration. Also added revision tracking in the applications table. Syscfg now automatically updates the revision field of the applications table with the current application revision. JSP
04 2/21/2003 Added ANSI Modem Support and added ANSI Comm port support to the METCONN JSP
05 3/19/2003 Added / Changed Comm_Driver values for IP connections Added SIP Server and Max Connections (Bit_Rate in DC_Channel) capabilities JSP
06/09 4/21/2003 Added a diifent scheme for adding IP port to DC JSP
10 4/25/2003 Added Remaining Channels to IP configuration screen JSP
11 5/21/2003 Changed the Phone Number field into the AT Modem Init String Currently only enabled for ANSI devices JSP
12 3/7/2006 Fixed a problem with ports configured for IP access adding to the number of enabled COM Ports JSP
13 6/19/2006 When adding a IP server the Modem stats and detailed call stats are automatically checked so DC will trace the starting of the server.
Version 7.0.x
00 6/01/2006 Initial Revision
1 11/8/2006 The baud rate for the DC modems was incorrectly specified at 192000, 384000. They have been changed to 19200, and 38400.
Version 7.1.x
01 7/11/2007 JRR fix logic to correctlly sequence the Machine_Num when adding a process to avoid duplicate Machine_Num for the same Process
02 1/17/2008 JSP Added InvisiConnect Modem Support
03 2/20/2008 JSP Fixed some issues with IP Channels and the new DC_Channel_Ext table
Version 2009.1.x
0.0 9/26/2008 Updated the application for the new release version 2009 under Mercury Instruments.
1.0 1/12/2009 Final build after adding Mercury IP Server setup
1.1 6/10/2009 Added Data Processing Email Configuration
1.2 6/30/2009 Set default values for processes to the most desired values.
1.3 8/19/2009 Updated the DC trace text from Timeing Stats to Comm Data tracing.
1.4 10/12/2009 Added the ability to use Site ID 1 or Site ID 2 for Mercury Devices.

System Monitor
Version 2009.1.x
0.0 9/26/2008 Updated the application for the new release version 2009 under Mercury Instruments.

Users and Security
Version 7.1.x
1.01 6/15/07 Changed password logic to not require Upper/Lower case. JRR
1.02 7/12/07 Added missing applications to the security check box matrix. JRR
1.03 7/13/07 Corrections to check box matrix. JRR
Version 2009.1.x
0.0 9/26/2008 Updated the application for the new release version 2009 under Mercury Instruments.

Audit.dll
Version 2009.1.x
0.0 9/26/2008 Updated the application for the new release version 2009 under Mercury Instruments.

DBAccess.dll
Version 2009.1.x
0.0 9/26/2008 Updated the application for the new release version 2009 under Mercury Instruments.

MiscUtil.dll
Version 2009.1.x
0.0 9/26/2008 Updated the application for the new release version 2009 under Mercury Instruments.

MtekUtil.dll
Version 2009.1.x
0.0 9/26/2008 Updated the application for the new release version 2009 under Mercury Instruments.

Pc7Print.dll
Version 2009.1.x
0.0 9/26/2008 Updated the application for the new release version 2009 under Mercury Instruments.

SysMsg.dll
Version 2009.1.x
0.0 9/26/2008 Updated the application for the new release version 2009 under Mercury Instruments.

5K/6K Config
Version 6.x.x
00 5/6/2002 Compiled with Centura 2000 JSP
01 3/4/2003 Fixed problems with license control system JSP
02 3/25/2003 Now will add the MTEK6000 device type to the DB on Start-up if not aleady there JSP
03 3/25/2003 Added IP Enabled JSP
04 4/23/2003 Fixed problem with adding an IP Enabled device causing a license violation on an unlimited License JSP
05 1/28/2004 Fixed problem with search button on main window JSP
06 1/29/2004 Fixed a problem with the main window not displaying all of the devices. Displayed blank rows at the top of the list.
Version 07.x.x
00 12/7/2004 Updated the security model to comply with the Sarbanes-Oxley Act. Password now must be 8 characters long, contain upper and lower case letters and include numbers.
01 04/27/2007 The Max Rows In Memory for the main window was incrrectly set to 0. This caused only a handful of units to be displayed in the main window dispite the number of units in the system
02 06/28/07 Support new database tables RU_MASTER_EXT and RU_INPUT_EXT JRR
Version 2009.1.x
0.0 9/26/2008 Updated the application for the new release version 2009 under Mercury Instruments.

5K/6K Defaults
Version 06.x.x
00 5/6/2002 initial version number - JSP
01 3/20/2003 Cleaned up alot of code (not all) and fixed some SQL handle errors JSP
02 3/25/2003 Now will add the MTEK6000 device type to the DB on Start-up if not aleady there, Also added version tracking JSP
03 2/26/2004 Fixed a problem with the app not deleteing unit types JSP
Version 07.x.x
00 12/7/2004 Updated the security model to comply with the Sarbanes-Oxley Act. Password now must be 8 characters long, contain upper and lower case letters and include numbers.
Version 2009.1.x
0.0 9/26/2008 Updated the application for the new release version 2009 under Mercury Instruments.

5K/6K Lists
Version 06.x.x
00 5/2/2002 initial version number - JSP
Version 07.x.x
00 12/7/2004 Updated the security model to comply with the Sarbanes-Oxley Act. Password now must be 8 characters long, contain upper and lower case letters and include numbers.
Version 2009.1.x
0.0 9/26/2008 Updated the application for the new release version 2009 under Mercury Instruments.

5K/6K Multi-Member Configuration
Version 06.x.x
00 5/2/2002 initial version number - JSP
Version 07.x.x
00 12/7/2004 Updated the security model to comply with the Sarbanes-Oxley Act. Password now must be 8 characters long, contain upper and lower case letters and include numbers.
Version 2009.1.x
0.0 9/26/2008 Updated the application for the new release version 2009 under Mercury Instruments.