National File Browser
Added search fields capability
The fields in the national file table display are now searchable using the same technique associated with other list displays.
Rare GPF fault fixed
Under some rare circumstances, a GPF could occur in the internal handling of "bookmarks" when a data record was imported. This has been fixed.
Unable to open file problem fixed
If the same file was opened twice in a row with the second being opened by finding the file by name, the ASCII table representing the national file was never closed. This has been fixed.
People View
Address Tab Bug fix - Occasional key violation error.
On rare occasions, inserting a new address record could result in the next address key and the actual address table keys getting out of sync. This has been fixed.
People list searching
Added search button to the upper address list speed button panel.
Corrected minor memory leak in address search.National File Browser
Added search fields capability
The fields in the national file table display are now searchable using the same technique associated with other list displays.
Places View
People list searching
Added search button to the upper address list speed button panel.
Corrected minor memory leak in address search.File utilities
Internal changes.
Additional exception handling has been added for some file utilities, resulting in a more robust implementation.
Address assignment problem
Improper assignment of a new person to an existing address
On rare occasions a new person would be linked to someone else's address and the new address would not enter the system. This obscure but serious problem has been fixed. An additional benefit is that National file reading and importing is faster.
Maintenance release
DB Merge
Good data flagged as bad in error
Additional checks for good data introduced in version 0.17 also introduced an error. Some of the fields database were flagged as invalid when they were not and thus were rejected. This problem has been fixed.
Too many cursors error
The "Too many open cursors" error has reappeared. It occurs when there are many bad fields. It should not be a problem with this release. If it is, increase the database MAXFILEHANDLES parameter in the Database Configuration tool to 64. If the problem keeps reappearing, keep increasing the value to a limit of 255. If you encounter this problem, contact CSI and we will investigate the problem further. Inspection of the code seems to indicate that cursors are getting freed properly, but there may be some subtle problem that may need further investigation
Maintenance release
Start Up
Upon start up of a new installation, the program will ask for a default region name and number. Be careful to enter the correct region name and number as since the database is not started yet, no checking is done. (See the Controller edit options menu commands below).
Controller
Edit->Options
Global program options can now be changed by using the main menu and clicking the Edit and Options selections. Currently the only global option that is modifiable from the options dialog box is the default region name and number.
National file reading
Additional data and file integrity checks have been added along with enhanced error trapping.
Table operations
Error trapping for table errors upon closure have been added.
Controller
DB Merge
You can now merge a selected database into the database that is currently opened in Member View. Pressing the DB Merge button on the system section of the Controller will pop up a Dialog that will allow you to select the database to merge and to set certain defaults. Database merging behaves in a manner similar to the National File reading function. This operation is currently very slow, due to the necessity of checking for variations of names and addresses. The process can be interrupted however, so if you have something else that you must do, you may pick up the database merge at a later time. Database merging is an interactive process and is difficult to automate entirely. We have some ideas that may make the operation much quicker, but these will take some time to explore.
People View
Import Monitor Systems "drivers.dat" files
The importing of Monitor Systems "Drivers.dat" files is now supported via a selection in the import menu.
Filter by mailing list
A new "speed button" and a new "Select" menu item choice have been added to allow filtering of the person list by a selected mailing list name.
Filter selection in menu
Selecting a filter using the "Select" menu items will now depress the appropriate filter speed button (located below the person list).
Address abbreviations
The address selected on the address tab can be abbreviated or un- abbreviated.
Edit addresses and names
Name and address editing has been added to the main menu.
Mailing List Tab
A vertical "splitter" has been added between the upper and lower list boxes.
Right click menu for mailing list names
Right clicking on the mailing list definition list displays a pop up menu from which to select "Edit", "New" or "Delete".
Window resizing has been improved so that space is more efficiently used.
Mailing List View
New menu command "List"
New menu commands "List" and "Duplicate" have been added. These commands allow you to crate a new list from an existing list. Use this function, for example, to create a mailing list for the annual banquet from the regional publications list. First duplicate the list and then remove those few people who are not to receive invitations.
National file reading
Region number
Regardless of the source, region numbers are now padded with leading zeros so as to be three characters long. In prior versions, it was possible to import region numbers that were one or two digits long, resulting in the program reporting that the region name was unknown or undefined.
Data "cleaning"
New heuristics that "clean" the input data more thoroughly have been added to National Data and Monitor file readers. Common abbreviations are detected allowing the number of erroneous duplicate addresses.
The first time you read a new file into your existing database you may encounter quite a few address changes. You should replace the appropriate address with the new address unless you know the new address is incorrect.
Phone Change Dialog
An "abort" button has been added. Press this button to cancel file reading.
Addresses
Addresses are now abbreviated or expanded according to US Post Office standards. (except for street <-> St as it not possible to distinguish St meaning Street from St meaning Saint without considering context. Context is not considered at this time due to performance considerations).
Buttons
Buttons that are not appropriate are now hidden. The Repair indexes button now displays the proper label, namely "Repair Indexes".
History table
A national file reading "History table" is now maintained by the system. The table includes the date the file was read, the date of the file, the file path name and whether the read was completed or not. Browse NF view will display a dialog showing the table. Selecting a row will allow you to "browse" the data in the selected national file. Direct editing of the history table is implemented in Controller menu edit.
Database Maintenance
Copy DB
The Copy DB function will copy an entire database to another directory or database alias. At present it doesn't check for disk space, so be sure that you have enough before you actually press the copy button on the Copy DB dialog box. Most databases will be too big to copy to a floppy disk, but should easily fit on Zip or Jazz disks.
Index repair
We had a crash that scrambled the main membership index (our first!) and found that the database engine wouldnt let the program close a database with an open corrupted index, and the corrupted index wouldnt close, a genuine "Catch 22". We have developed a way around this problem that allows you to get to the index repair facility, or to shut the program down without problem.
Resource leak fix
When a view was opened and then closed the resources for the view were not freed. If views were opened and closed many times an out of resources fault would result.
Places - new view
A new view "Places" has been implemented. This view allows browsing the addresses, showing information about the people who are at the address and abbreviating, un- abbreviating all addresses or the selected address. The names of people at the address are color coded to indicate status.
Browse NF - New View
Open and browse the national file
This new view allows the user to browse a national file. A history list of files that have been read by the program is maintained. You import the selected entry into Member View.
Entrants - New View
Car definition data tables
New tables are included that contain car definitions arranged by manufacturer, model and class. These have been culled from various sources, including the 1997 run offs results. Feel free to update the tables and send them back.
Entrants tab
This tab implements user entry of entrant information
Maintain Cars
This tab implements single table maintenance of the cars database. Unless you have a compelling reason why you prefer this method over that in the Manufacturers tab, it will probably be removed in the next release.
Manufacturers
This tab implements another method for maintaining cars.
To be added
Medical information tab, event relationships including sanction numbers and race group management.
Install/Upgrade program
Changes to the installation
The upgrade installation program now will create/recreate the Member View Beta program group properly, there may be duplicate entries. If duplicate icons are produced, you may delete the duplicates from the start menu group.
Tables
Status table field changed
Status string length change -The status string has been increased from seven characters to thirty two characters. This impacts any table that uses the status string as well as any of the membership information screens. Run the table conversion program to update your system.