File Release Notes and Changelog
Release Name: v2.0
Notes: Installation instructions for VisibleResults and can be found in README.txt. Please download and read this file before continuing. You will need to install Firebird 1.0 and InterClient 2.01 before using VisibleResults. For more details please email support@sundayta.com
Changes: CHANGELOG 2.0.10, 15 September 2003 ------------------------------------------------------------------------ isql.bat and gbak.bat now use localised "Program Files" directory. ALL direct mail CSV files are now in Latin 1 encoding. (bug 761814) Don't show incorrect addresses as blank values in direct mail CSV files. (bug 776234) 2.0.9, 7 July 2003 ------------------------------------------------------------------------ Direct mail CSV files are now in Latin 1 encoding. (see bug 761814) 2.0.8, 28 May 2003 ------------------------------------------------------------------------ Fixed merge problem if first contact dates are null. (bug 726795) 2.0.7, 15 April 2003 ------------------------------------------------------------------------ Accepts both version 50 (for dialect 1) and 51 (for dialect 3) databases - these have identical table structures. Includes dialect 3 versions of the sample/basic databases. Distribution no longer includes visibleresults.gdb to avoid this ever being overwritten. Restore the visibleresults.gbk backup instead. Include isql.bat and gbak.bat that can be used to run the Firebird programs from their default installation directory. 2.0.6, 27 March 2003 ------------------------------------------------------------------------ Fixed sample database so that the 1000+ gifts will not produce thank you letters. Prevent editing of a project thank you letter that doesn't exist. Corrected description of "number of gifts" selection rule. Correct field has focus when editing a project. Made Danish direct debit dialog enabled and modal (bug 562246) Giro import now respects the "allocate requested gifts to project" option. (bug 698713) Fixed insert/edit/delete rule buttons on selection form. (bug 698664) Fixed letter group selection rule. (bug 689982) Show previous contact status/type and date of last changes on donor tab (bug 562245) 2.0.5, 3 February 2003 ------------------------------------------------------------------------ Added option to exclude contacts from a direct mail if they have requested not to receive mailings during a range of dates (bug 542442) Show a blank date instead of 1 Jan 1970 on the Person History report (fixes bug 562254) Show the number of contacts listed in the people form. Fixed contact source selection rule (bug 678234) Disabled automatic upgrading of databases older than version 46 - this is too error prone. No longer list depreciated projects are no on the Project Membership form (fixes bug 621768) 2.0.4, 14 August 2002 ------------------------------------------------------------------------ Fixed NPE bug on startup that caused 2.0.3 to fail. Includes new Swedish AutoGiro system (Layout D). Swedish PostGiro now gets the serial number from the contents of the file. AutoGiro now gets the serial number from the ame of the file that is uploaded. The serial number has also been temporarily removed from the upload form as it is not being used yet. Fixed ambiguous column error editing addresses/phone numbers. Fixed ambiguous column editing batches or viewing gifts from a given contact. (bug 591607) Fixed ambiguous column bug editing families (bug 562253) Fixed various ambiguous column / SQL errors when generating a selection set. (including bug 591445) Editing users is now fixed. (bug 562232) Web pages are now shown in UTF-8 correctly. Giro system is now accessible from the application in normal user mode. 2.0.3, 29 July 2002 ------------------------------------------------------------------------ This is a minor release containing mostly bug fixes, including many errors involving ambiguous columns in the database. Enabled changing of an organisation's language (bug 562270) Fixed changing a person's language (bug 562239) Fixed ambiguous column error in gift entry (bug 560989) Fixed ambiguous column error in direct mail generation (bug 560056) Contact report works even if there are no gifts at all (bug 560060) Fixed ambiguous column error when editing organisations (bug 556750) Fixed ambiguous column error when editing people (bug 559572) Removed defunct customer parameters editing screen (bug 562237) 2.0.2, 7 May 2002 ------------------------------------------------------------------------ Database version is now 50. There are no structural changes, this corrects some errors caused by the upgrade to database 47. Upgraded XML handling libraries (those with JDom 1.0 beta 8). Deleted channels are no longer shown (bug 551837) You can no longer change the bank account of a batch to one with a different currency (in response to bug 551348) Filtering people based on old/non donor state now works (bug 532479) List of people now shown in the correct order (bug 544111) Able to save multiple gift allocations in gift entry (bug 547021) 2.0.1, 19 April 2002 ------------------------------------------------------------------------ Includes Swedish giro system. Fixed editing of people during gift entry (bug 545703) 2.0.0, 12 April 2002 ------------------------------------------------------------------------ Running the java application no longer starts up a DOS window. Removed the Giro option from the menu and toolbar. Added new contact report. Added new merge implementation. 1.9 beta 15, 11 April 2002 ------------------------------------------------------------------------ Database version is now 49. This includes a small change to the ContactSnapshots table to handle contacts that no longer exist because they have been merged with another contact. Removed the "Project report with filter and date selection", in response to bug 443756. Java application now uses "log.directory" in the properties file to determine where to write the logs. This is used by iVr as well. It falls back to capture.stdout/capture.stderr if necessary. "All" now works from the people filter (bug 541970) Added an initial contact report. 1.9 beta 14, 5 April 2002 ------------------------------------------------------------------------ Using iVr as the "new" web server. Giro support has been temporarily removed until it is ported to iVr. Changes to the JAR files - vr1lib now contains all the JAR files needed to run the Java application (including vrapp.jar). lib contains the jar files to run jetty, and also interclient.jar. Everything else is now in webapps/visibleresults.war. Database version is now 48. This adds some changes to the way contacts' names are stored internally. Changes to batch files. These are no longer in the bin directory, although the old ones there still exist and call the new ones in the base directory. Lots of bug fixes. Details below. Removed the asterisks from the java application where there is no translation support. Translation support will only be developed for iVr. Fixed some bugs that caused buttons to be enabled/disabled at the wrong times. Fixed SQL bug loading personal text items. Fixed saving of an organisation's contact person (bug 441021) Filtering based on contact state now works (bug 532479) When adding a new organisation the default letter group, contact type etc are now highlighted automatically (bug 440989) Replaced the GiftCounts report with one that refreshes (bug 535203) and does not include reversed gifts/reversals. After inserting a new project, the tree is now refreshed (bug 440998) Added the option to include/exclude dead people and those with incorrect addresses when generating a direct mail. The default is to exclude them. Note that they are still included as part of the selection set. (bug 438495) In gift entry, prohibits saving a second gift allocation if the contact for the second allocation is different from the first (bug 536210) After inserting/updating a person, they are left selected in the list. 1.9 beta 13, 22 March 2002 ------------------------------------------------------------------------ Added support for selecting between different giro file types. Various giro improvements - dates are now picked up correctly - corrected default bank account/payment types - added transaction/pass/fail counts to the report Tidied up application menus and removed unused items, including recalculation. Saving "Don't mail before/after" dates now works (bug 532987) Removing email addresses now works (532480) Checkbox column in people list now correctly shows whether a contact is a current donor (bugs 532977 and 553041) Added identification no (social security no) to direct mail output. New day check report now works (bug 444032) 1.9 beta 12, 15 Mar 2002 ------------------------------------------------------------------------ Fixed a bug that prevented saving people (prefixed wrong table name in some SQL). Giro implementation is now fixed to Swedish PostGirot. Fixed some bugs in the parsing of Postgirot files. Removed javascript errors from the giro upload page. 1.9 beta 11, 6 Mar 2002 ------------------------------------------------------------------------ Main implementation of inserting gifts in web site, including improved handling of multiple currencies (although this is currently hardcoded to a 1:1 exchange rate). Main implementation of giro system including user interface. This is currently fixed to the Swedish AutoGiro. Web server now displays pages in UTF-8. Disabled web server login temporarily as this server will normally be accessed by automatically firing up the browser. There is no need to log in twice. 1.9 beta 10 ------------------------------------------------------------------------ Fixed bug saving social security number for people, this is now referred to as identification number in contacts. Speed improvements to application. Bug fixes regarding SQL aliases and where clauses. 1.9 beta 9, 28 Jan 2002 ------------------------------------------------------------------------ Added giro code column to Swedish direct mail output Fixed bug 509563 (users with no password could not log in or be edited)/ 1.9 beta 8, 16 Jan 2002 ------------------------------------------------------------------------ Database version is now 46. This adds support for currencies to contain exchange rates, although full application support is not yet complete. There is also no support for a dynamic exchange rate yet. Added support for a default currency. The database upgrade code uses the number of batches in each currency to determine which currency should be the default. Windows version of VR application now runs under JRE 1.3.1. Replaced the currency "symbol" column with "prefix" and "suffix" strings. Batch screen now displays totals in two currencies. Improved notification that a database upgrade is necessary when first accessing the web server. A link to the upgrade servlet page is provided. Added support for launching Mozilla on Linux. Fixed bug 498499 (embedded browser now follows links only when the mouse button is clicked). Generated thank you letters now contain the currency symbol automatically. There is no need for this in the project letter text. NB: any hardcoded currency symbols need to be removed from the text of each project letter. Added contact number to direct mail output. 1.9 beta 7, 20 Dec 2001 ------------------------------------------------------------------------ Corrected the classpath in the Windows batch files, this prevented thank you letters from being generated. No change to the Linux version. 1.9 beta 6, 18 Dec 2001 ------------------------------------------------------------------------ Fixed bug preventing the deletion of users. Added David's speed improvements from Denmark visit December 2001. Fixed bug 494552 (deceased people selection rule). 1.9 beta 5, 17 Dec 2001 ------------------------------------------------------------------------ Altered the Windows batch files so that they do not use any variables, avoiding the dreaded "Out of environment space" message. 1.9 beta 4, 10 Dec 2001 ------------------------------------------------------------------------ Letter Group now shown on the read-only donor screen. Application now tries to create directory for the log files, although it does not fail if it can't do this. Changed references to "Payment Type" into "Paper Type" on the thank you letter generation screen. Clear button on the people filter now clears the contact number (bug 489821). Depreciated letter groups are now hidden in list (bug 489824). Changed "Donor Count" to "Contact Count" on letter group form, and corrected it (bug 489825). Added a vr1report.bat batch file to start the VR applications' report server. 1.9 beta 3, 30 Nov 2001 ------------------------------------------------------------------------ Web site now no longer requires a password to log in. (this was not working anyway) Changed the locale definition in the properties file, using these keys: locale.default.language locale.default.country locale.default.variant The old application still finds the old values, the web site does not. Added initial implementation of inserting gifts in web site, (although this has not been tested and is not available for use yet). Added initial implementation of Swedish Giro system. Fixed some SQL bugs in database upgrade code, as Firebird is now stricter about ambiguous column names in joins. Added a "please wait" page that refreshes when you first access a page after starting the web server. Moved the database upgrade code to a separate servlet, accessible by a different URL. This also has a "please wait" message that refreshes. You can now only upgrade to database version 44 using the old application, after that you must use the web site to upgrade. The notes tab is now refreshing correctly (bug 471313) Fixed filtering of people by addresses (bug 459475) Fixed a bug that prevented viewing batches. Control panel in web site is temporarily disabled, as it was trying to load all contacts at startup. 1.9 beta 2, 8 Nov 2001 ------------------------------------------------------------------------ Fixed some direct mail problems (bugs 444086/430809) Editing of donors now seems more stable (bugs 444090/444072) Depreciated projects now not showing up in the project reports (bug 437317) Fixed the new Day Check report (bug 444032) Fixed the Selection report (bug 444058) Fixed the totals in the Month Summary report (bug 459476) The default country is now highlighted by default in the people filter (bug 471315) Added a Visible="yes"/Visible="no" attribute to the <Box> tag in thankyou letter templates. This allows you to hide the address. Web site now fails a bit more gracefully if something is missing from the properties file. Web site login now fails if the username/password is wrong!
