Navigation: REVISION HISTORY AND BUGS / FEATURES >
Revision History - Latest Version
For anyone that is interested in seeing the list of future work that we are considering doing, a read-only login to our internal project management system is available. Please contact us by email for the login information, if you would like to get access to that.
Release 4.56b (July 5, 2021):
•(This was actually added in release 4.56.) When you click a Save PDF button or equivalent menu option for a report, receipt, or mail-merge letter, and you choose to save it to a file that already exists, you now get an option to Append the new PDF to the existing file, as well as the previous options to replace the previous file, or cancel the save.
•In release 4.56b, do not offer that Append option for Save PDF if it is a receipt, to avoid any risk that you will append a PDF of one donor's receipt to an existing PDF of a different donor's receipt, and then send them both to one of those donors!
Release 4.56 (July 5, 2021):
•Added Automated Reports Running Scripts, run through Reports ⇒ Run Reports Script, which allow you to write fairly simple scripts in a text file, to do automated jobs including running one or more reports, filtering them, sorting them, saving them to various file formats, and emailing those saved files to anyone.
•In the Maintenance ⇒ Receipt Options window, allow the selection of Letter versus Legal paper size (or A4 for users in countries other than Canada or the USA).
•Made 3 changes to the Donation fields list in the Custom Reports window:
oChanged "Month # Received", which just gave the month of the date received as a number (1 to 12), to "Month Received", that gives it as values "01 - January" through "12 - December".
oChanged "Quarter # Received", which just gave the quarter number of the date received (1 to 4), to "Quarter Received", that gives it as values "Q1" through "Q4".
oAdded "Year Received", which just gives the year number of the date received. This could be used in multi-year reports, although using the controls in the Multiple Year Totals area of the Custom Reports window is an alternative way to do that.
•Fixed a bug in the Report Browser: DONATION REPORTS ⇒ Current Donor ⇒ All Years Details was incorrectly printing the same report as DONATION REPORTS ⇒ Current Donor ⇒ Current Year Details.
•For OnDemand version users, fixed a weakness that you weren't being notified, and shown this Revision History page, when the program had been upgraded since you last used it. (Unlike all other versions, we do the upgrades to your OnDemand version programs when they are available, so you don't have to.)
•Fixed a bug that happened if you were emailing mail-merge letters or receipts, and the Name of a donor included a double quote mark ("). It would give an error message about the name not being found in the merged document, and fail to email.
Release 4.55b (June 11, 2021):
•Made some important fixes in the importing option for users switching from the PowerChurch Plus program into DONATION, that was introduced in the previous release.
•Various routines for conversion from other programs, or importing data, used to show any errors or issues you would need to fix in the Notepad text editor program. Now they are shown in a window within DONATION, which makes things a little simpler.
•Fixed a few menu options in the mail-merge editor, such as Insert ⇒ Table, which if they were the only changes you made, would allow you to close the editor without being prompted to save your changes.
•Added some details about the requirements for PCI compliance if you use the Abundant online donation system.
Release 4.55 (June 7, 2021):
•Added an importing option for users switching from the PowerChurch Plus program into DONATION.
•Users of the OnDemand version can now be given an access level of "No Access" to a database, in the Administer All Users window. This would be helpful for OnDemand clients with multiple databases, where some users should only have access to some of the databases.
•Users of the Remote Database version will now receive a message, each time they start the program, telling them how many days are remaining until that version is discontinued (on August 1, 2021), before which they have to switch to the Standard or OnDemand version.
•Fixed a weakness for users switching from later versions of Membership Plus into DONATION. It needed to download and install an extra component (an ODBC driver) for this conversion to be done, but when the program tried to run that downloaded installer, it would fail, and you would have to run it manually. Now it should run automatically.
•Fixed a crash in the mail-merge editor, if you used the Insert ⇒ Table menu option. It would crash with an error about "Error at line 7 in open event of w_base".
Release 4.54e (May 26, 2021):
•Changed the Database ⇒ Import ⇒ Donations menu option and the Database ⇒ Import ⇒ Donors and Donations menu option to handle French dollar amounts, which could have the dollar sign at the end, spaces for thousands separators, commas instead of periods for the decimal point, and semicolons instead of commas separating fields, when Excel files are saved to CSV for importing.
•Added links to see the US$ and C$ transaction processing fees into the Abundant Overview help page.
•Undid a change in release 4.52e that could create error messages such as "Internal error: trying to add the key ... a second time to an nvo_keyvalue object." While the change that caused those messages is not known to have affected the behaviour of any functionality in the program, it could possibly have done so.
Release 4.54d (May 18, 2021):
•Changed things so that license key requests for Organization Names with non-Roman characters, such as Chinese or Hebrew, should work properly.
•This note is primarily for Software4Nonprofits staff to know when we made this change - it should not affect users! When the Remote Database version is downloading its database to become a local database, permissions are no longer granted by the program to the database usernames that the Standard and other versions use, but the Remote Database version does not use. That is because the process of doing the backup on the server, that gets downloaded to the local PC, grants those permissions instead.
•Added a section to the Abundant Overview help topic about setup for users with multiple databases.
Release 4.54c (May 10, 2021):
•Corrrected the name of ByTheBook's Roll Call, that DONATION can convert from - we had been spelling it "RollCall", without the space.
•Fixed a crash in the Lite version, if you tried to use any feature that is not included in it, which should have brought up a window explaining about that. The bug was introduced in release 4.53.
Release 4.54b (May 7, 2021):
•Fixed a change in release 4.53, which caused Bank Deposit transactions exported to QuickBooks (QB) to fail to be imported. It turns out that the transaction type field in the exported .IIF file for QB has to be "DEPOSIT", even though such deposits get shown with the type "DEP" after importing. In addition, the "NAME" field in those .IIF files, which we understood would go into the PAYEE field in QB, was being ignored. We have added a "MEMO" field, with the same value (such as "Deposit from DONATION") that will get imported so that you can see what it is. (It is not clear that there is a way to get QB to import a PAYEE when it is importing deposit transactions.)
Release 4.54 (May 6, 2021):
•Added an importing option for users switching from the Roll Call program into DONATION.
•Corrected an error in the initial setup of the Abundant online donation system.
•Fixed a bug where changes made in the Maintenance ⇒ Organization Info window didn't show up in various places (including receipts) until you exited the program then restarted it.
Release 4.53b (May 3, 2021):
•Changed a place where the new feature that can add automatically take a screenshot of unexpected messageboxes, and then prompt to email them to us after you click a button on them, was being set incorrectly. The effect of that was that the next regular (not unexpected) messagebox included the text saying it was going to take the screenshot and offer to email it to us, when it should not have done so. Also changed the text added to the messagebox in the unexpected cases, explaining that a screenshot will be taken, to be entirely bold, to make it more obvious.
Release 4.53 (April 30, 2021):
•The Abundant online donation system is now tightly integrated into DONATION. The integrated features include launching the setup of Abundant from DONATION, importing automatically downloaded daily donation batches, and creating the bank deposit accounting transactions for those batches.
•Most windows in the program now have a small camera icon in some corner of the window. Clicking on it automatically saves a screenshot of that window to a file, then brings up a window that allows you to email the screenshot to us, with your comments. Some technical messageboxes also have a similar mechanism for emailing them to us. See Screenshots for Tech Support for full details.
•When Bank Deposits are exported to files for importing into ACCOUNTS or QuickBooks, the transaction type had always been "DEPOSIT", which is different from the standard transaction type that both of those programs use for deposits, which is "DEP". It has now been changed to "DEP" in those exported files.
•The Maintenance ⇒ Email Sending Configuration window now allows you to use Port 587 or 465 with the Security option None (after warning you that it is unusual), if it is allowed by your email provider.
•Fixed a bug in the One Date Batch Entry Options window, where if you don't have "Include existing donations for the specified date" checked, the Batch Description gets filled in as "All" instead of the time, and then that isn't accepted when you click OK.
•Some users have been having problems with updated versions of the helper file HtmlMessageBox.dll not being installed when they do upgrades, likely due to interference from their anti-virus software. (We can assure you there is nothing wrong with that file!) The program now checks on startup that that file is present, and is as up-to-date as it should be.
Release 4.52e (April 9, 2021):
•Fixed a problem causing selecting and editing of logo and signature images to fail, with an error such as "It appears that a 3d-party Image Viewer control installed with DONATION, that is needed for this feature, needs to be reinstalled". Reinstalling did not fix the problem, but updating the program to the current release does fix it.
Release 4.52d (March 24, 2021):
•Changed a lot of places in the program that accessed web pages or utilities (such as for requesting license keys) on our website, that were using insecure web pages (http://...), to instead access the same pages securely, with https://... addresses.
•Fixed a technical problem where some stored procedures in any new databases created recently were not absolutely correct. This problem would have been very unlikely to affect any users, but for technical reasons it was important to fix it.
Release 4.52c (March 4, 2021):
•Fixed a bug in the Maintenance ⇒ Recurring Donations window: If there was a row there with the name "MISSING DONOR!", which means it was for a donor that has been deleted from the current year, or not copied forward from a previous year, and you clicked Edit, you got an error message and the program crashed. Now you get a message explaining the situation, and recommending that you delete that row.
Release 4.52c (March 4, 2021):
•Prevented a harmless error when switching to a different database, with the Database ⇒ Switch Databases menu option for the first time after upgrading to release 4.52 or higher, that said "Internal error inserting row into CONSTANT_TEMP table ...". This error could also come up after restoring a database backup made by an earlier release.
•Made a correction to the validation of the Username field in the main Maintenance ⇒ Email Sending Configuration window that was previously allowing various sorts of invalid email addresses and parts of email addresses. (What's supposed to be in that field is either an email address, or the part of an email address prior to the "@" sign.)
•Fixed an error in the window for associating accounting accounts with donation categories (part of configuring bank deposits) that could give an error message that starts with text like "The donation category NAME is set to be allowed for online donations via Abundant, but you have not specified an accounting Account for it." That will be part of an upcoming feature, which offers a tightly integrated online donation system called Abundant for use with DONATION, but was not supposed to be active code yet.
Release 4.52b (Feb 26, 2021):
•Fixed a bug introduced by Release 4.52, where you could not create a new year for the first time in the Maintenance ⇒ Change Year window, even when you were using a single-user version of the program (Lite or Standard) or were the only simultaneous user in a multi-user version.
•When you are editing your SMTP settings in the Maintenance ⇒ Email Sending Configuration window, there are now additional validations done and warning messages that can appear if the settings you have entered do not match our best knowledge of the correct settings for your email address' domain (the part after the "@" sign) or your entered SMTP Server value.
Release 4.52 (Feb 25, 2021):
•Recurring donations can now be bi-weekly (every 2 weeks) in addition to weekly and monthly.
•Further improvements for users of the OnDemand version who have been trying to open files from, or save files to, the C: drive, which is the OnDemand server's drive. Your local computer's C: drive shows up as J: under OnDemand, with subsequent drives like USBs showing up as K: or L:. All File Open or File Save type dialog boxes now give you warning messages if you navigate to a folder on the C: drive, telling you to use J: etc. instead, and prevent you from clicking Open or Save if you are in a folder on the C: drive.
•Message boxes that have a Help button on them now work in a more convenient way: the Help file is opened immediately, and you can switch between it and the program. Previously, you had to close the Help file that was opened, before you could resume working in the program.
•Fixed the fact that the Help button in the Database ⇒ Import ⇒ Donors and Donations menu option was not going to the right Help page.
•Fixed a bug in the versions that allow for simultaneous users (Local Network, OnDemand and Remote Database) where if you created receipts but didn't print them, save them to PDF, or email them, they were still saved back to the database, despite a message saying that they were not being saved! This bug was apparently introduced in Release 4.39, in September 2020.
Release 4.51d (Feb 17, 2021):
•Put in a better fix (than the one in release 4.51c) to a problem introduced by release # 4.51b, where a small number of users doing updates got error messages about not being able to create a Global Temporary Table. If that problem is encountered, the program now prompts you through automatically backing up and restoring your database, which fixes the problem.
•For the Standard, Lite, Local Network Server, and OnDemand versions of DONATION, if your database file does not exist when the program starts, it will now be created by copying from an empty database installed with the program. (This is particularly for new users of OnDemand, to ensure that they get an up-to-date empty database to start with.)
•Users of the OnDemand version who try to save files such as backups, PDFs, data exports etc. to the C: drive, which is the OnDemand server's local drive, not their own computer's local drive, are now given a message about that not being allowed, and asked to try again. (Under OnDemand, your local computer's C: drive shows up as J:, and additional local drives, like USB memory keys, show up as subsequent letters like K: etc.) There's also a message warning you about that before you try to do any database restores.
•If you start the program and your licensing file donsl.txt is not present in the program's Data Directory, it is now automatically created, with data in it that starts a 60-day evaluation period starting on the current date. This is particularly for the OnDemand version, to make sure that new users start with an appropriate evaluation period, because their setups never have that licensing file pre-installed.
Release 4.51c (Feb 12, 2021):
•Fixed a problem introduced by release # 4.51b, where a small number of users doing updates got error messages about not being able to create a Global Temporary Table. If that problem is encountered, you now instead get a detailed message telling you what to do to fix it, which is basically making a database backup then immediately restoring that backup.
Release 4.51b (Feb 12, 2021):
•Fixed a problem in the mail-merge editor, where when you used the Insert ⇒ Page Break menu options, the visible page break text and line that appears on your screen also appeared when you printed or saved to PDF, at least for some users who did that recently. If you have that problem in an existing mail-merge template, please write to us for a fix.
Release 4.51 (Feb 10, 2021):
•In the Reports ⇒ Custom Reports window, renamed "Batch" in the Donation fields list to "Batch Description" to be clearer what it means. That field is only shown if you have checked "Use Batch Descriptions" in the Donations tab of the Maintenance ⇒ Main Window Options window.
•When you are using the Database ⇒ Import ⇒ Donors menu option or the Database ⇒ Import ⇒ Donors and Donations menu option, if you have donors with two email addresses in the Email field, separated by semi-colons, and you choose the option to use the Email address as the unique donor identifier, a single email address being imported can now match either of the two existing addresses.
•Made some changes in the OnDemand User Management Help page to reflect some changes to the User Management application.
•The Tools ⇒ Check for Updates window now has a Print button when an update is available and thus revision history is being displayed, to print that revision history.
•Fixed a bug where if the donation Description column was being shown with a drop-down arrow for the appraiser, and you used the Correct button, the Description field in the window that came up had a black background so you couldn't see anything you typed into it.
•Fixed a bug in the Database ⇒ Import ⇒ From GiftWorks menu option: if you chose a GiftWorks backup file (one ending in ".gbf"), it would give an error during the extraction and renaming process and could not continue. (The error involved duplicating the path that it was stored in.)
•Fixed a bug where using the «DetailsTableAllCategories:...» merge field on a pledge letter (with pledge type Annual with Start Date and Category) for a donor with a pledge but no donations in the current year makes the entire resulting merge be blank in Letters ⇒ One Letter. It can also cause error messages when such donors are encountered in Letters ⇒ Mass Mailing.
•Put in some code to hopefully prevent an occasional error when exiting the mail-merge editor, with wording like "... cannot convert any in Any variable to boolean. Possible cause: uninitialized value".
Release 4.50h (Jan 27, 2021):
•Some improvements to the OnDemand help topics.
•In the OnDemand Administer All Users window, user names are now forced to upper case, to match the User Management application. (Logins can still be done wit the user name in any case, though passwords have to be in the right case.)
Release 4.50g (Jan 22, 2021):
•Fixed a bug in One Date Batch Entry: if you are showing Batch Descriptions, have already done one batch for a given date, and have "Include existing donations for the specified date" unchecked, and then you do another batch for that date, with a different Batch Description, it was instead incorrectly adding the donations you enter to the first batch for that date. Now it correctly puts it in a new batch with the description you entered.
Release 4.50f (Jan 13, 2021):
•Fixed a bug introduced by release 4.50e, where when you were creating a bank deposit, and clicked the Export button, you would get an error "Error at line 112 in clicked event of cb_export...".
Release 4.50e (Jan 13, 2021):
•Changed the program to default to using Chrome, when it is present, for generating PDFs from mail-merge documents (including in order to email them). It uses that instead of the novaPDF printer driver. (OnDemand versions already always used Chrome.) In case you experience any problems with this change, it can be turned off, except for the OnDemand version, with a new checkbox in the Maintenance ⇒ Receipt Options window.
•Fixed a bug: when you are using the Donors Only password (or are a Donors Only user of the Remote Database or OnDemand versions) the layout of the main window was not correct, with a large blank area at the bottom of the window.
•For OnDemand, when it has to convert Excel files to CSV (for various importing features), some users were encountering error messages. This release uses a different external program to do that conversion.
Release 4.50d (December 26, 2020):
•Fixed a problem causing editing of signature images to fail, with an error that starts "It appears that a 3d-party Image Viewer control installed with DONATION, that is needed for this feature, needs to be reinstalled". Reinstalling did not fix the problem, but updating the program to the current release does fix it.
•For users of the cloud-based OnDemand Version, added a warning when they are backing up, if they choose to back up to the J: drive, which is their local C: drive. This is similar to the warnings given to other users if they back up to their C: drive, that if it dies, they could lose all of their data.
•Technical point mostly for our internal memory: If you chose "Run DONATION" from the last screen of the installation program, it used to run it with elevated Administrator privileges, the same way the installer itself ran. That was different from how DONATION was normally run, and could cause some unusual errors during that first run done directly from the installer. Now if you do that, DONATION is run with your normal user privileges.
•Put in a fix in the Tools ⇒ Check for Updates window, that may prevent an error message about "Error ... in destructor event of ole_web" when the program is being closed in order to run the downloaded installation program.
Release 4.50c (December 17, 2020):
•Added a couple of further places explaining about our licensing and payment rules for multiple user with multiple databases, like the existing information about that here.
•Added a check when the program starts up that it has all of the expected database permissions. There was a potential problem about that with our initial version of the instructions on the website for switching from the Remote Database version to the OnDemand version. (Those instructions have been changed to avoid the problem.)
Release 4.50b (December 15, 2020):
•Added instructions for automatic logins with the OnDemand client program to the Command Line Arguments page.
•Various additions and improvements to the OnDemand help pages.
Release 4.50 (December 14, 2020):
•This release introduces the entirely cloud-based OnDemand Version, which runs on a server, through a small remote-control client program, and does not require installation of the DONATION program itself. Like the Remote Database Version, multiple users can access the same database at the same time, each with their own login, but it is much faster than the Remote Database Version.
•When you get errors configuring emails in Maintenance ⇒ Email Sending Configuration, the technical log file that is generated is now shown to you in a special window with a button on it that allows you to email it to us for our suggestions.
•In the Database ⇒ Merge Duplicate Donors menu option, fixed an oversight that would have caused Customer IDs belonging to the donor being merged into the other donor to be deleted, rather than being moved to the other donor as they should have been.
•Made a fix that should prevent an error that came up to a few users occasionally, that said "Error at line 22 in wf_display_donations_header event of w_donation: Error accessing external property business_name ...". (Restarting your computer seemed to always make that error go away.)
•When you are associating accounting account names to your donation categories as part of configuring bank deposits, it does not work in either ACCOUNTS or QuickBooks if you precede the name by its account number. The program now warns you if it appears you are doing that.
Release 4.40b (November 17, 2020):
•Fixed a bug where on new installations, the mail-merge letter and receipt templates would not be loaded properly into the program's database, and thus could not be used.
Release 4.40 (November 14, 2020):
•The Easy Tithe online donation system now has a special Software4Nonprofits export format for importing into DONATION. See Importing Donors and Donations from Easy Tithe for full details on doing that export from Easy Tithe and import into DONATION.
•Backups can now always back up to mapped network drives, and also to UNC paths (\\computername etc.), except for the Local Network Client version. Restores can now always restore from mapped network drives, and also from UNC paths.
•All users of the Remote Database Version can now use the Maintenance ⇒ User Administration ⇒ Administer All Users menu option. However, only users who are Administrators can make changes in the window that comes up - everyone else can just see the information about the users.
•Fixed a bug that can cause an error message "Common Dialog Error: Error Number 65535" to come up when you use certain parts of the program that bring up a window for selecting a file to open, or specifying a file to save, if certain other parts of the program that also do that have been used first.
•Removed the Backup/Restore ⇒ Restore Old Database (DONATION3.DB) menu option, because it was only needed for conversion from version 2.70b or earlier of DONATION (released in 2007 or earlier), and almost no users should still need that. If you need that, contact us and we can do the conversion for you.
Release 4.39c (October 13, 2020):
•Fixed a small bug introduced by Release 4.38: If you pressed F2 (or used File ⇒ Edit New Donation) before you had actually entered or edited any donations, it did nothing.
•Fixed an inappropriate error message when installing the Local Network Client version, where it would say "Could not copy file ... DONATION4.EMPTY ... Source file(s) does not exist...". (There was more text where the "..."s were.) Clicking Cancel on that messagebox would allow the install to complete successfully.
•Fixed an error in installs of the Local Network Server version, on computers on which it had never been installed before, that could prevent the Local Network Client installs from succeeding. That error could be fixed by copying the file DONATION4.EMPTY on the Local Network Server computer, from the directory in which the program files had been installed, to the Data subdirectory of the program's Data Directory.
Release 4.39b (October 11, 2020):
•Made a change that would prevent an error that started in release 4.39: If you used Tools ⇒ Check for Updates, and then when it prompted you to make a database backup before the update you answered Yes, it could give an error like "Error at line 12 in uf_decode_mapped_drive_file ...". If you are getting this error, and you want to make a backup before updating, please do it separately, then answer No when Check for Updates asks you about making a backup.
•The same error may have been able to come up if you did Database ⇒ Validate, or answered Yes if the program prompted you to validate your database as you were exiting the program, and also if you were restoring a database backup.
Release 4.39 (October 8, 2020):
•There are now special features for importing donations from the Vanco online donation service, including:
oA new option to allow working with Customer IDs (3rd-party identifiers for donors) in the Show Fields checkboxes of the Donor Details tab of Maintenance ⇒ Main Window Options.
oOnce that option is selected, the following other features become visible:
oAn IDs button in the row of buttons in the Donor Details area of the main window, for maintaining the Customer IDs for the currently displayed donor.
oA new report, Reports ⇒ Donor ⇒ Customer IDs, displaying all such IDs that have been stored in the program.
oA new Database ⇒ Import ⇒ Vanco Donations menu option for importing export files in a special "Software4Nonprofits" export format that you can ask Vanco to send you daily or weekly.
•Fixed a bug introduced in release 4.13: built-in receipts that should have been encrypted to allow them to be viewed and printed, but prevent them from being modified etc., were not encrypted. Mail-merge receipts were encrypted properly.
•A few releases ago, all Database ⇒ Import menu options that used to save Excel files that you specified as tab-separated text files before importing them, were changed to save them as CSV (comma-separated value) files before importing them. (We failed to record that in that release's points below.)
•Fixed an error that could be caused by that change to saving Excel files as CSV. It was trying to save as Unicode CSV files (ones that would handle many types of non-English characters), and much older versions of Excel could not do that. Now if a save from Excel to a Unicode CSV file fails, the program silently saves it as plain-text CSV instead.
Release 4.38b (September 23, 2020):
•Fixed a bug: In new databases created with new installs since the Middle Initial field was added as an option to the program, or additional databases created with Database ⇒ Switch Databases menu option, mail-merge letters could give error messages about missing the MIDDLE_INITIAL field.
Release 4.38 (September 22, 2020):
•Added a new Database ⇒ Import ⇒ Donors and Donations menu option that imports files with both donor and donation information on the same line. Completely revised our previous help topic on this (pointed to by the "menu option" link in the previous sentence) that required using both the Database ⇒ Import ⇒ Donors menu option, and the Database ⇒ Import ⇒ Donations menu option in turn to achieve that same effect.
•In the Database ⇒ Import ⇒ Donors menu option, and the Database ⇒ Import ⇒ Donations menu option, if you are importing CSV files, there would be a problem if quoted fields in the input file were broken up over multiple lines of the file. (We saw this occurring in the MESSAGE TO CHARITY field in files exported from CanadaHelps.) That is now fixed - multi-line fields in CSV files are now treated as if they were on one long line. This change also applies to the new Database ⇒ Import ⇒ Donors and Donations menu option.
•In the Database ⇒ Import ⇒ Donations window, the extra window for associating new donation category values with existing donation categories, or creating new categories for them, no longer comes up if the import is merely using previously saved conversions of such values. It only comes up if there are new categories that have not previously been converted to existing ones.
•There is a new Maintenance ⇒ Imported Category Conversions menu option that allows you to make edits to previously saved and remembered conversions of imported donation categories.
•Fixed a bug that can happen when you have the Sort Order on the Donations tab of Maintenance ⇒ Main Window Options set to "Oldest to Newest". If you make a change on the new empty donation row on the main window (which appears at the bottom of the list with that option), but don't fill in the Amount, and you also make a change on the previous row, then click Save, you get a techie error like "validation error for column DONATION.TOTAL_AMOUNT, value **null**", and you cannot save your changes.
•Fixed two small bugs in validating the entry of a new donor with a name that was the same as an existing donor's name, which should cause the program to ask you if it's OK to add them despite the duplicate name. First, it wouldn't check that if the current donor selected on the Donor List was the one with the same name. Second, if the other donor with the same name had nothing in Address Line 1, instead of getting a proper confirmation message, you would get a messagebox just saying "NULL" and asking you to answer Yes or No!
•Made a change in the Database ⇒ Import ⇒ PAR Donations window, that could prevent occasional crashes in the program after the import was finished. (Any such crashes would have been harmless - the import still completed successfully.)
•Fixed a bug: if you have selected an option, on the Donations tab of Maintenance ⇒ Main Window Options, to allow display of previous-year donations on the main window. The bug was that you could click the Correct button on a displayed receipted donation from a working year other than the current one, in which case you would get a techie error message and the program would crash. Now if you click Correct, you get an appropriate message if the donation is not in the current working year, telling you to switch to the required year if you need to correct it.
Release 4.37d (September 11, 2020):
•Fixed a crash in the program introduced by Release 4.36, with text like "Cannot create storage structure to hold mail merge data ...". It occurs in the Letters ⇒ One Letter menu option or Letters ⇒ Mass Mailing menu option, when choosing the type Pledge Information and clicking Merge, but only if your Pledge Type on the Pledges tab of Maintenance ⇒ Main Window Options is anything other than "Simple Annual Pledge".
Release 4.37c (August 12, 2020):
•The drop-down list for the Cheque # / Paid By field for donations now includes a row for "<Add New>". If you select that, you are immediately put into the Maintenance ⇒ Donation Paid By Values window, with its New button already clicked, to add a new value to the drop-down list. If you do add one or more values while you are in that window, the last one added will be immediately inserted into the Cheque # / Paid By field when you return from that window. (This feature was added because many users were asking us if we could please add things to that list, who had not discovered the menu option that allowed them to do it themselves.) See Entering New Donations for more details.
Warning: If you do not have a Default Paid By value, so that the Cheque # / Paid By field comes up blank for new donations, do not just use the down arrow key to navigate through the list of options without actually dropping down the list by clicking the drop-down arrow. If you do that, because the first item on the list is always "<Add New>", that will immediately select that item, and then pop up the window for adding another Paid By value! Just using the arrow keys to navigate through the list of options is not efficient in any case: dropping down the list and using your mouse to make selections, or typing the first letters of your desired selection until it comes up, are both far easier.
•There was already a similar "<Add New>" option for the donation Category field, but it was not enabled on the window for correcting receipted donations. Now you can also use it there (as well as on the main window, and on the Batch Entry window).
•Added a Help topic on making Screenshots for tech support emails.
Release 4.37b (August 7, 2020):
•Fixed a small bug caused by our fix to the last bullet point below for Release 4.37. The bug could cause two users sharing a database, both of whom had Release 4.37, to not see any changes each other made to the email Subject lines or Body when emailing receipts.
Release 4.37 (August 6, 2020):
•When you are emailing receipts or letters, you can now optionally add an additional attachment (in addition to the PDF receipt or letter) to those emails. That is done with a new Optional Attachment option on the window for specifying the email.
•The Letters ⇒ Email Everyone and Letters ⇒ Email Newsletters menu options have been merged into one Letters ⇒ Email Donors menu option, that handles either requirement: emailing donors with or without an attachment.
•Added a new Help topic HTML in Emails to Donors which has some simple instructions for doing that in the Body of the emails you send when emailing receipts or mail-merge letters, or using Letters ⇒ Email Donors.
•Fixed two small bugs: When you drill down into a summary field in a report (such as in Reports ⇒ Donor ⇒ Donation Info ⇒ Sort by Name) to see the details making up that summary amount, then you use the details report's Back button to come back, the paging controls (the icon buttons for First Page, Previous Page, Next Page, and Last Page) were not necessarily re-enabled or disabled properly based on whether or not the main report you returned to had multiple pages. Now they are. Similarly, if you create or change a Filter in a way that changes the report from one page to many, or vice-versa, those paging controls are now appropriately enabled or disabled. (The controls are disabled when there's only one page.)
•Made it clearer when those report paging controls are enabled by adding a solid black border around them in that case. When they are disabled (when the report is only one page) their border is grey.
•Fixed a bug in the Letters ⇒ Mass Mailing window: If you checked the checkbox for "I want to just export the data to a file", and picked any of the types in Section 1 of the window other than Individual Donation Information or Total Donations Information, you would get an error message such as "Error at line 320 in wf_retrieve_data event of w_merge_group. Name not found accessing property receiptable ...", and the program would crash.
•Fixed an obscure bug: if you have "Email receipts, letters and statements only to yourself, for testing" set in the Maintenance ⇒ Receipt Options window, generate a receipt, then only Email it (to yourself, for testing), it is not supposed to be saved back to the database. However, if during that emailing you changed the Subject or Body of the email to be sent, the receipt did get saved back to the database.
Release 4.36b (July 31, 2020):
•Fixed a crash in the program introduced by Release 4.36, with text like "Cannot create storage structure to hold mail merge data ...". It occurs in the Letters ⇒ One Letter menu option or Letters ⇒ Mass Mailing menu option, when choosing the type Total Donations Information or Pledge Information and clicking Merge.
Release 4.36 (July 30, 2020):
•Added a new Groups and Committees feature, that allows you to set up a list of the groups or committees within your organization (with Maintenance ⇒ Groups / Committees) and then specify which donors are members of each one (in the new Donor Details field Groups / Committees). You can hide that new field, if you are not interested in it, with a checkbox on the Donor Details tab of the Maintenance ⇒ Main Window Options window.
•Added a Help topic on Importing Donors and Donations from QuickBooks.
•Fixed a weird (and unlikely) problem with pledges. If you had chosen a pledge type other than Simple Annual Pledge, given a donor a more complex pledge, then decided to switch back to the Simple Annual Pledge type, that donor's pledge would end up uneditable.
Release 4.35 (June 26, 2020):
oChanged the order of the sections in the Mass Mailing window.
oFor Donor Information Only, Current Donation Information or Individual Donation Information, and Total Donations Information type merges, added a Receiptable merge field, that indicates whether the donor and/or the donation is receiptable. (See Mail Merge Fields for full details on what that field means for each type.)
oFor Total Donations Information merges, added a Receiptable field to the fields available to be displayed in the DetailsTable.
oAdded a checkbox for filtering the donations to be included with the donor, which is only enabled for Total Donations Information merges. If you do that and you restrict the donations to be included, that will affect the TotalAmount, EligibleAmount and AdvantageAmount totals fields, as well as the contents of the DetailsTable and SummaryTable. Uses of this might be to restrict the donations to only one donation category, or to only receiptable, or only non-receiptable, donations.
•In the Mail Merge Editor, when you are editing original templates (rather than completed merged documents), the fields in the "Insert Field" drop-down list are now just the names of the fields themselves, rather than being surrounded with "«" and "»" (the way they get inserted into the template). This makes them easier to read, and also means that if you are in that list and press the first letter of a field name repeatedly, it will cycle through the fields that start with that letter.
•In the Database ⇒ Import ⇒ Donors menu option, imported Phone values like 1234567 will now be reformatted and saved as 123-4567, and values like 1234567890 will be saved as (123) 456-7890. Also, matching on email addresses is now case-insensitive (upper or lower case don't matter).
•In the Database ⇒ Import ⇒ Donations menu option, if negative values are found in the Total Amount field, you are now given a choice of just ignoring input file lines like that, instead of that being an error that causes the import fail. Also, matching on email addresses is now case-insensitive (upper or lower case don't matter).
•Broke up the new Help page on Importing Donors and Donations from One File into three. The main page contains the general information. A new page contains the information about Importing Donors and Donations from CanadaHelps that was previously in the main page. And there's a page of new information on Importing Donors and Donations from PayPal.
•Changed the Database ⇒ Change Date of Donations menu option to allow the From date to be in a different working year from the current one.
Release 4.34b (May 29, 2020):
•Added some tests to the Tools ⇒ Network Client Information menu option (which is only in the Local Network Server Version). The tests check for some of the things that would prevent the Local Network Client Version installation from working. If any of them are detected, you will be given a message and told to contact us.
Release 4.34 (May 28, 2020):
•Significantly redesigned the Check for Updates window, including now displaying the changes since your last update on the window itself. The program also now always prompts you to check for updates once a month, to encourage you to get the latest features and bug fixes. (Previously you could opt out of those once a month checks, with an option on that window.)
•Several improvements to the Database ⇒ Import ⇒ Donors window:
oAdded "Skip Column(s)" to the list of Donor Fields on the left (though it isn't really a donor field!). Picking it prompts for a number of columns in the input file to skip, adds "Skip N Columns" (with "N" replaced by your entered number) to the Fields to Import list on the right, and leaves it there on the left.
oAdded an option of using an Email Address field as a unique identifier for matching input file rows to existing donors, in addition to the existing option of using the Member/Envelope Number for that purpose.
oAdded an option to ignore lines in the input file matching an existing donor. (The matching is based on your selected Unique ID field.)
oAdded an option to ignore lines in the input file matching a previous line in the input file. (The matching is based on your selected Unique ID field.)
oAdded the ability to drag and drop rows in the Fields to Import list up and down, to re-order the list, in addition to the existing Move Up and Move Down buttons for that purpose.
oFixed a bug: The feature that prompted to allow you to continue if there were more columns in the input file than specified in your Fields to Import only worked if you specified that there were 0 header rows. If there were 1 or more header rows specified, you would just receive an error message about this and not be able to proceed.
oEntirely blank lines in the input file are now ignored, rather than causing an error that would stop the import.
•Several improvements to the Database ⇒ Import ⇒ Donations window:
oAllowed the columns to be imported in whatever order you want, by using an interface like in Database ⇒ Import ⇒ Donors, with a list of Donation Fields at the left, and a list of Fields to Import at the right. You can move columns between the lists, and move columns up and down in the Fields to Import list.
oAllowed there to be no Cheque # / Paid By field in the import file.
oAdded the Advantage Description field as an importable field.
oAdded "Skip Column(s)" to the list of Donation Fields on the left (though it isn't really a donation field!). Picking it prompts for a number of columns in the input file to skip, adds "Skip N Columns" (with "N" replaced by your entered number) to the Fields to Import list on the right, and leaves it there on the left.
oAdded an option of using an Email Address field as a unique identifier for matching input file rows to the donors for whom the donation is to be recorded, in addition to the existing option of using the Member/Envelope Number for that purpose. Exactly one of those two fields must be included in the Fields to Import.
oYou are now prompted to allow continuing with the import if there are more columns in the input file than specified in your Fields to Import list.
oEntirely blank lines in the input file are now ignored, rather than causing an error that would stop the import.
oAdded an option Import "Pre-Receipted" into the Cheque # / Paid By Field, for cases when what you are importing is donations that have already received tax receipts from another charity. (This would apply to imports from CanadaHelps.org, for instance, which is a charity and issues its own receipts.)
oIf there are new Category field values found, you will be prompted with an option to associate them with existing categories (in case they are just different names for the same category). In that window that comes up, you can also specify how to shorten new Category values longer than 20 characters (the maximum length for them in DONATION). The window also comes up if previously-used associations of longer categories to existing categories are being used.
•Added a new Database ⇒ Merge Duplicate Donation Categories menu option and window, for changing all donations with one category into another category, and then deleting that first category.
•Added a Help topic on Importing Donors and Donations from One File. These instructions can be used if you need to import files containing both donor and donation information on the same line. This would often be because they were exported from online donation processing services, such as CanadaHelps.org.
•In the Database ⇒ Merge Duplicate Donors window, changed the sort on the displayed donors to be case-insensitive, to match the order in the main window's Donor List. (Previously a donor with a last name starting with a lower-case letter would sort to the bottom of the list on this window.)
•Made a fix that should prevent problems that a few users were having, who were using the built-in rather than mail-merge receipts. It occurred when they used certain Receipt menu options. If they were somehow able to quickly close the main window after the print (for Current Donor Original Quick Print) or after closing the window displaying the receipt for other options, the program could crash with a message about "Null object reference at line ... in ue_..._receipt of object w_donation". Fortunately even when that happened the receipt was both printed (for Current Donor Original Quick Print) and saved OK!
•Fixed an unintentional limitation to deleting donors. The rule is that you cannot delete a donor who has donations in the current year. However, if you chose an option on the Donations tab of Maintenance ⇒ Main Window Options to display further years of donations on the main window, and the selected donor had displayed donations in other years (but none in the current year) you were still prevented from deleting it. Now that is allowed, as it should be, with a message explaining that this does not affect the donor in other years.
•For Canadian users, if you enter or edit what the Canada Revenue Agency calls a donation with advantage (one where you enter both a Total Amount and an Eligible Amount), and the donation is receiptable, and the advantage (the difference between those two amounts) is more than 80% of the Total Amount, you will now receive a warning saying that the donation should probably be marked non-receiptable. You will not receive warnings about previously entered donations where this is an issue, unless you edit them.
•For Canadian users, if you enter a Gift in Kind that has a value of at least $1,000, and have not entered appraiser information (which may be required by the Canada Revenue Agency), you will now be prompted to do that.
•For users in countries other than Canada or the U.S.A. who checked Use A4 Paper in the Maintenance ⇒ Receipt Options window, fixed seven built-in reports, plus Custom Reports in some cases (if they were printed in Portrait mode). They were cutting off a tiny bit at the right edge, and/or printing extra blank (or almost blank) pages after each page.
Release 4.33b (April 28, 2020):
•Made a technical change that should prevent a problem that a few users were having where they were shown a log file saying that the Chilkat function UnlockBundle needed to be called.
Release 4.33 (April 24, 2020):
•Made some improvements to both the messaging in the program, and the relevant Help topic about Gmail problems, when you are configuring email sending for a Gmail account and it doesn't work at first. Also improved the Help and the program's messaging about email configuration problems for several other email services, which either need or might need you to set up a special "application password" for use only with this program.
•Added a capability to the «if:FIELDNAME» mail-merge field, which included the following text (up to an «else» or «endif») only if the value of that named field was non-empty, or for amount-type fields, not $0.00. You can now also specify it as «if:FIELDNAME=VALUE», which will include the text only if the value of the field is exactly the same as the value you enter after the equals sign. (For amount-type fields, that value has to be shown in your standard currency display format, such as $100.00.)
•Fixed a possible problem when you are displaying multiple years of donations on the main window (as set by an option on the Donations tab of Maintenance ⇒ Main Window Options). If the current donor had donations in other years for which the donation categories were not present in the current year (for instance, because you deleted them), they would show up as just a number, not their description. Now the description will always show up properly in such cases.
•Fixed a bug for users logging in with the Limited User Password, running the Reports ⇒ One Date Donation report: if the Donation Details checkbox was unchecked, checking it would cause a techie error message and the program would crash.
Release 4.32c (April 16, 2020):
•Prevent a techie error message, that starts with "Getting lastmodified date and time for file ... failed" in mail-merge activities, including using either the Edit or Merge buttons in Letters ⇒ One Letter or Letters ⇒ Mass Mailing, if a file is not in an expected directory. (Fortunately that message was harmless and the process continued successfully in any case.)
Release 4.32b (April 10, 2020):
•Fixed a bug in the new Batch Entry features that allow for multiple batches on the same day. If you had already saved one batch with a description, then went back to update further on that same date, but left the In Batch drop-down showing the default of "All", then if you entered any new donations in the main batch entry window that comes up, it would fail on a Save, with an error about "violation of FOREIGN KEY constraint".
•Changed the default for the In Batch drop-down in the Batch Entry options window for a given date that already has had batches saved for it to be the last batch saved, rather than "All". Made the same change to the default Batch shown in the options window for Reports ⇒ One Date Donation, to also show the last batch saved. Explained all of this better in the Help topics for Batch Entry and for those reports.
Release 4.32 (April 9, 2020):
•Renamed two of the versions of DONATION to better describe them: the Standalone version is now called Standard, and the Web Network version is now called Remote Database. This does not affect their features in any way, just their names!
•Fixed a bug in the new Batch Entry features that allow for multiple batches on the same day, each with its own Description. Somehow if you created more than one named batch, it was erroneously merging the 2nd and further ones on a day into the first one, ignoring the fact that you had given them new Descriptions. The 2nd and further Descriptions were not saved at all.
•Fixed a problem that was causing every new release to reload the original mail-merge templates provided with the program, whether or not they had been updated. (That reload would not affect any of your edited templates.) However, the fix will actually only take effect starting on the next release after you install this one (or after the next one you install).
•Fixed a problem that could cause incorrect error messages when installing the Local Network Client version, where the installation program could give an incorrect message about needing to upgrade the Local Network Server version first, when it had already been upgraded.
•Organization Names with leading or trailing spaces in the name can cause problems with license keys not matching properly, so we made a couple of small changes to prevent and/or fix that.
•Added a message to the installation programs, to give an error message and ask for confirmation if you were trying to install an older version on top of a newer version. However, that will only take effect if the older version being installed on top of the newer one is this version or later.
Release 4.31c (March 14, 2020):
oThey can be memorized and replayed again.
oOnes memorized in releases prior to 4.31 can be replayed again.
oWhen you replay memorized ones, the options window will show up with the correct options selected, and with all of the checkbox options greyed out so that they cannot be changed. That ensures that you are replaying the report with the same options that you originally memorized.
oThe one thing that could not be fixed is that ones memorized using exactly release 4.31 will likely not work properly, because they did not correctly memorize the desired options in the new options window. They will always try to replay the simplest Details-only report with no additional columns.
Release 4.31b (March 10, 2020):
•Fixed bugs about the One Date Donation reports:
oOne bug prevented them from working from the Reports Browser, after the changes made in release 4.31. They did work from the main Reports ⇒ One Date Donation menu option.
oAnother bug was that previously memorized One Date Donation reports would have crashed the program. Now you get a message saying that that memorized report can no longer be used, and you should recreate it or just run your desired One Date Donation report directly.
oThe final problem is that if you memorized new One Date Donation reports, they would not necessarily display the same report when you tried to replay them, and any Sort or Filter saved with them might not work, because the options in the new options window for those reports are not saved. So those reports can no longer be memorized. (That restriction was eliminated in the next release, but this was the only quick fix available to eliminate this potential problem.)
•Removed an apparently incorrect restriction (added in release 4.24b) stopping the Local Network Server version from backing up to mapped network drives. The Local Network Client version still cannot write to mapped drives on the server (which is making the backups), for technical reasons. Also, trying to do that now gives a nice error message explaining that that doesn't work, rather than a techie error window.
•Prevented a way where you could end up with a database that thinks it is working on year number 0 (rather than the current calendar year) when you first set up a new database.
•That previous fix also prevented a very obscure and unusual problem where on a startup to the program, you get a message "Cannot update CONSTANTS table with your working year number". In addition, if this problem had already happened, there is a fix in this version that handles it.
•Eliminated all of the sub-menu options under Reports ⇒ One Date Donation. Clicking that menu option now brings up a window that allows you to pick various options, to indicate which sections of the report you want included, and which additional columns you want included.
•Added two new versions of reports under Reports ⇒ One Date Donation, that were not previously available. They are ones with both a Details section and a Summary section, that show the donation Description column.
•Changed the Email field in the Donor Details area of the main window to allow multiple semicolon-separated emails to be included in that field. The same change was made in the Email field in the window for sending emails to arbitrary people (used for emailing backups, for emailing reports saved with the Save As button, and a few other places). For instance, "email@example.com;firstname.lastname@example.org", without the quotes, would now be a valid entry. When entries like that are used, any emails sent to the the people listed in that field will go as one email, with the To line for the email including both email addresses. That includes when you are emailing receipts or letters to donors, and when you right-click on a Donor's email field on the main window and pick Send Email from the pop-up menu.
•Updated the Help topic Move the Program from One Computer to Another to include a much shorter simplified instructions section to cover the simplest cases.
•Added some messages to help catch weird situations that have happened to a few users, where their database was messed up in a way that making a backup then immediately restoring that backup would fix. (Please do not try that yourself unless we advise you to do so.)
•Added the capability to give names to batches entered with Batch Entry. That will be of particular interest to churches who have multiple services on one day and want to be able to report on them separately. That affects the Batch Entry windows, and also the One Date Donation reports which now allow you to select a batch on a given date. A Batch field was also added to the Donation fields column in Custom Reports. If you don't want to use this feature, you can turn it off by unchecking "Use Batch Descriptions" in the Donations tab of the Maintenance ⇒ Main Window Options window.
•In the built-in receipts, and template mail-merge receipts, the heading "Summary by Category" above that summary table at the end of the receipt now has the donor's name added, so it will read for instance "Summary by Category for John Smith".
If you are using mail-merge receipts and have edited that template, you would have to make that change yourself by editing the template accordingly, for instance by adding "for «Name»", without the quotes, after where it says "Summary by Category".
•For the built-in Canadian receipts for with Advantage (including ones for Quebec), we have removed the Summary by Category section at the bottom of the section for the donor to keep. There was no benefit to that, because such receipts are always for only one donation, and the Details Table that is still included in those receipts has the same details. (Our mail-merge templates for such receipts did not include the Summary by Category table.)
•Changed the Database ⇒ Copy Addresses menu option to also copy email addresses as well as the 4 fields for the postal address.
•If you have the Local Network Version of DONATION, and you have multiple databases, and an Organization Short Name in the Database ⇒ Switch Databases window on the Local Network Server version contains a non-ASCII character (such as an accented character), the Local Network Client version was previously unable to use that same menu option to switch databases. Making any small change then re-saving the entries in the Local Network Server version may now fix this. If not, the message that the Local Network Client version now gives when you try that is much more informative and tells you what the problem is and how to fix it.
•Fixed a bug in the Database ⇒ Copy Missing Donors menu option: it wasn't copying the Middle Initial field.
•The Help ⇒ Email Software4Nonprofits.com menu option now gives a choice between using your default Windows email program to send the email (which is what it always did prior to this) or using a plain-text form within the program to do so.
•Fixed a bug in the Database ⇒ Import ⇒ Donations window, where if a donor was not found with a given Member/Envelope # from the first column of the import file (which cancels the import), the error message said the error was on line 0 of the input file, rather than stating the correct line number.
•Improved some messaging around the automatic retrieval versus manual requesting of license keys. Also changed the Evaluation and Licensing window to normally automatically close after a successful request of a license key or of an evaluation extension.
•Each page of this Help now has a footer that tells when it was last updated. However, for technical reasons, all pages will initially show as December 10, 2019 if they have not been updated after that.
•Fixed a bug: if you are using mail-merge receipts, using Receipt ⇒ Current Donor Sample will fail to display the "Sample Only" watermark on, which is needed to make it clear it is a sample and should not be sent to the donor.
•When you are displaying a report and click Print, the printer dialog box gives you an option to select only a range of pages to print. If you do that, and when that is done, click Save PDF, previously it would automatically only save the same range of pages to your PDF file. Now it will ask you whether you want to save the same range, or all pages.
•Made a change to the installation program that should fix the very infrequent errors where the program cannot properly access 3rd-party controls installed with it, leading to error messages such as "Cannot connect to global object in ChilkatAx-9.5.0-win32.dll ...".
•Clarified the wording of the windows prompting for the receipt issued date when you run the Reports ⇒ Receipt ⇒ Mailing Labels report or the Reports ⇒ Receipt ⇒ Envelopes report. Also, in both of those windows, the displayed date will now default to the latest issued date of receipts for the current working year, and they will verify that any other date you enter is a date on which receipts were issued, in the current working year.
•Prevented a possible but infrequent crash of the program when using the Receipt ⇒ Current Donor Original Quick Print menu option with mail-merge receipts, with a message like "Error at line 10 in mf_adjust_menus event of m_web_browser ...", appearing after the receipt has printed.
•Fixed a problem introduced by version 4.28 where after the installation, when you first ran DONATION, you could get errors like "Cannot open loaded HTML file ... for writing. Access is denied."
•Resolved problems with mail-merge templates into which images were pasted directly with Cut or Copy and then Paste, rather than being inserted with the Insert menu option in the editor. Such pasted-in images could cause the program to crash. Any such images will now be replaced with "IMAGE REPLACED", and you will be given a message explaining that and what to do about it.
•Changed Reports ⇒ Donation ⇒ Summary by Dollar Ranges to bring up an extra prompting window that allows you to change the dollar ranges it reports on.
•Added some additional warnings in a number of help topics about the fact that exporting reports to formatted Excel (with the Save As button) can be imperfect.
•Made it clear in the text of the Letters ⇒ Mass Mailing window, and in the Help for that window, that the checkbox that allows filtering the data before merging or exporting also allows sorting it.
•Made it clear in the Help on the Receipt ⇒ Filtered Donors window that matches on the Other Info fields are case-insensitive (upper or lower case doesn't matter) and that they search within the field contents (they don't have to match the entire field).
•Fixed a completely harmless problem in the full installation programs (for versions other than Lite) where if you repeatedly ran the same installer, each time you ran DONATION after the install it might tell you it was loading new or updated original letters files. (Reloading them was harmless, and would not overwrite any versions of those letters that you had edited.)
•Made a change in the full installation programs so that a reinstall will fix things, if you get a message "Error at line 50" and then the program crashes when you click the Select Logo and Signature button (or messages about licensing at some points after that) in Maintenance ⇒ Receipt Options. (We think that problem can happen after certain major Windows Updates.)
•Made some changes in many original mail-merge receipt templates delivered with the program (specifically, ones for Canada - English, French or Bilingual), that will mean that the box border around the Eligible Amount merge field still looks right if you change the font size of that field.
•For the full installers other than for the Lite version, added in the installation of a file needed for conversion of databases from newer versions of Membership Plus, in case it is needed. Previously, if you needed to do such a conversion, DONATION would prompt you to download and install that file, which could be error prone.
•Revised the Help topics on Exporting Data from the Program, Generating Mailing Labels or Envelopes using Microsoft Word, and Doing Mail Merges using Save As from Reports.
•Improved the wording of the email sent with Email Backups about how to restore the backup.
•Fixed a bug when copying data to a new year with the Maintenance ⇒ Change Year menu option: If you were entering Middle Initials in their own field (using the new capability to do that, first available in release 4.18), they were not copied from the previous year's donor details to the new year's donor details. If you already did that copy to the new year, and you had been entering Middle Initials in their own field already, there are two ways that you can fix that:
a.If you had not yet made any changes to donor or category information in the new year, and had not yet entered any donations in the new year, just delete that new year with the Database ⇒ Delete Latest Year menu option. Then upgrade to this release, if you have not already done so, and redo the creating of the new year in Maintenance ⇒ Change Year.
b.If that option will not work for you, and it is the year 2020 that didn't get Middle Initials copied into it, please contact us for a SQL Updating Password and SQL statement and instructions for fixing the problem, by copying Middle Initials from 2019 to 2020.
•Fixed a problem that a few users had encountered where they could see an error about "Error retrieving a donor's latest donations" in the Batch Entry window, which could lead to new donations entered there not being saved.
•Made more changes to new signature editing possible from the window reached by clicking Select Logo and Signature on the Maintenance ⇒ Receipt Options window, to correct some positioning calculations if you scroll the image. It also now allows for snipping images 15 or 20 times the minimum desired size (previously only up to 10 times was available). Also improved some of the Help for the signature image, particularly the paragraph specifying how to scan a signature image.
•The following changes were actually parts of Release 4.17 and 4.19, but we failed to note them in the Help until now. The Database ⇒ Import ⇒ All Data menu option now expects two additional fields in the file for importing donations, the Title and Middle Initial, coming after the First Name field. And it expects one additional final field in the file for importing donations - the Description. (Those points were also not mentioned in the Help topic for that menu option until now.)
•Made a small improvement to the new signature editing possible from the window reached by clicking Select Logo and Signature on the Maintenance ⇒ Receipt Options window, to better handle things if your initial signature image to be edited is actually already quite small.
•Fixed a problem introduced by release 4.26 where the program could crash when you clicked Select Logo and Signature on the Maintenance ⇒ Receipt Options window.
•Added new features in the window for selecting Logo and Signature Images, for automatically fitting logos into an appropriate image size, and snipping signatures out of a scan you have made, at an appropriate image size. In almost all cases, this should eliminate the need to use graphics editing programs for those purposes.
•Fixed a bug in many original mail-merge receipt templates delivered with the program, that could push the signature image and name, and any text under them, too far to the right so they get cut off a bit when printed or saved to PDF. Also when existing edited templates are loaded for editing or running a merge to create a receipt, if they have the same problem, it will likely be fixed automatically.
•When running reports (other than to print actual envelopes), your paper size will now always be set to Letter, unless A4 paper size was set in the Maintenance ⇒ Receipt Options window, in which case it will be A4. This will override any default paper size set for your printer in Windows.
•For users in countries other than Canada or the U.S.A. who have selected A4 Paper in the Maintenance ⇒ Receipt Options window, fixed a bug that caused printing of Envelopes (as with Reports ⇒ Donor ⇒ Envelopes) to print on A4 paper instead of #10 envelopes.
•Added the function "IF" to the function selection box for complex sort expressions, and added an explanation of to that Help topic.
•Fixed a bug: For users in countries other than Canada or the U.S.A., the text in a built-in receipt that said things like "Official receipt for the year 2019" could have half of the last character ("9" in this case) cut off when you saved it to PDF, including if you emailed it.
•Did a complete spelling and grammar check of this Help file, and made lots of small corrections.
•Added a checkbox in the Database ⇒ Merge Duplicate Donors window, to allow you to only do the merging in the current working year, rather than the usual default of doing it in all years in which those donors appear in your database.
•Fixed a further unlikely but possible way (beyond what was fixed for Release 4.24d) where users in Canada or the U.S.A. could incorrectly have their printing (and saving to PDF) using the A4 paper size instead of Letter. (A4 is a size used in many countries other than Canada and the U.S.A.) If you are in a country with that A4 paper size, you can set it yourself as an option in the Maintenance ⇒ Receipt Options window.
•Improved the message you get on startup, if the program thinks your screen resolution may not be sufficient to show the program's main window and other windows.
•Fixed a bug in an internal function in the program that determined whether you were running the Local Network Client version, that could think that was the case if you were running the Remote Database Version. The only place we are aware this affected is when you used the Tools ⇒ Check for Updates menu option in the Web Network Version - it would ask you an inappropriate question about whether you had first updated the Local Network Server version.
•Made some changes to the logic about when revised mail-merge letter and receipt files are loaded into the database, where they are actually stored for use.
•Added a "Hide SQL Text on Next Window" checkbox to the Custom Reports window, which causes the next window that comes up to hide the generated SQL rather than displaying it as usual.
•Added a new section to the end of the Help topic Generating Receipts using Mail Merge, titled "Generating Receipts with Multiple Mail-Merge Template Files".
•Fixed a bug that a few users were encountering where they were trying to use a mail-merge letter or receipt, and they got a message such as "The original HTML file ... has not yet been stored in database." Now as long as that file actually exists, it should be stored in the database for you in that situation, and the program will be able to use it.
•Fixed a bug in the Mail Merge Editor, where the Insert ⇒ Page Break sub-menu options would either appear to not work at all, or might make all or part of the existing document disappear.
•Fixed another bug in the Mail Merge Editor, where sometimes if you edited with an external editor (such as the option to do so with Notepad), when you returned to the editor and it prompted you to reload the changed document, there could be odd messageboxes or error messages after you answered Yes to that.
•Changed all original mail-merge letter and receipts files in a way that clicking Ctrl+Home in the editor would get you to the outside of the table at the top of the document, rather than inside it. That way you could press Enter, and then add something above that table. Previously the only way to get something at the top was with the Insert ⇒ Page Break ⇒ At Start of Document menu option, which might not be what you wanted (a page break), or by using an external editor. These updated original versions will only be installed by full installation programs downloaded from the DOWNLOAD web page, not if you use Tools ⇒ Check for Updates in the program.
•Corrected an error when new databases are being initialized (either for a first install, or if you are creating them for Switching Databases) where the program incorrectly decided to default your paper size for reports to A4 instead of Letter. (A4 is a size used in many countries other than Canada and the U.S.A.) If you are in a country with that A4 paper size, you can set it yourself as an option in the Maintenance ⇒ Receipt Options window.
•Corrected the fact that the version 4.24c installation programs, excluding the full Standalone installer, were accidentally not "code signed". As a result, when you downloaded them, your browser and/or anti-virus software might be more suspicious of them, saying they are from an "unknown vendor". or words to that effect. (They were still OK though!)
•This version was created with a new version of the script used by our installation program builder. (This is primarily a note to ourselves. The new version is "daAll.suf".)
•Corrected an error if you downloaded a Web Network Version database to become a local database, with the Upload/Download ⇒ Download Web Database to Local menu option, as part of converting back to a local version such as Standalone. This version fixes that, even if the download has already been done and you have switched to Standalone.
(Technical details for our internal memory: It had failed to grant appropriate permissions to a newish database stored procedure named sp_generate_name, and to a new database table MEMORIZED_DONATIONS, which could lead to error messages about those objects, and perhaps crashes of the program, likely harmless.)
•The program has never been able to successfully restore a backup from a mapped network drive. Now it has a clear error message about that, with instructions of what to do about it (copy the file to your local computer then restore it), rather than a more technical one that just says it cannot open the backup file to be restored. Also changed the previous messaging and Help file information for if you were trying to use a UNC path (like \\othercomputer\c\...) to also state that you have to copy the file to your local computer in order to restore it.
•Updated a number of Help pages, including Multiple User Options, to reflect the fact that we are discontinuing the one simultaneous user Web Network Version option. (The five simultaneous user Web Network Version will still be available.) We are doing this because we believe that when you only need one user at a time accessing a shared database, the Standalone version with the Cloud Storage Service is a much better option than the Web Network Version, because it is much faster, and potentially cheaper.
•Made a minor revision to the Database ⇒ Validate menu option so that for the Web Network Version, there is not a significant delay caused by reloading the main window when the validation is finished. A similar coding change was made to the Backup/Restore ⇒ Backup Database menu option, which will not be obvious to users because that menu option is not needed (or available) in the Web Network Version.
•Added a new feature allowing you to memorize recurring donations, for automatic insertion on a weekly or monthly schedule.
•The Database ⇒ Copy Missing Donors menu option now has another option, to just copy the currently selected donor in the current year to one or more other years, if it is missing in those years. Previously the only option was to copy all missing donors.
•The Maintenance ⇒ Receipt Options window now has an option, that applies to all emailing of receipts, letters or emails to donors, "Bcc: to yourself". If you check that, all emails sent to donors will have a Bcc (blind copy) to your email address that the emails are sent from, so you can have a copy of each email.
•Prompts for dates or date ranges for reports now have different messages if you enter a date outside of the current working year (or fiscal year, where appropriate). The new messages tell you to use Maintenance ⇒ Change Year to see reports for a different year.
•Made a change to the mail merge editor (which is behind the scenes an Internet Explorer web browser window) that may allow more modern HTML to work in documents, if you edit them manually (for instance with the Edit in Notepad option in the editor).
•Fixed a bug in Database ⇒ Import ⇒ Donors: problems with the lengths of fields, that could be truncated (shortened) to fit into the program's allowable field lengths, were being treated as errors preventing the import, rather than just information. Now those types of errors can still allow an import to be done.
•Fixed a few things that users starting the program with the Limited User Password had been allowed to do, but should not have been allowed to do: Use the Correct button for donations, and edit the Advantage Description column for existing donations, if it was being displayed.
•Fixed the fact that the Help button in the Calculator window didn't go the right help page.
•Did a significant re-write of some common program code shared between our two programs DONATION and ACCOUNTS, leading to related changes in the code that is unique to each program. This is not intended to change any program behaviour. (This note is primarily for our own memory of when this was done, since this should not affect users of the software. The technical change was to stop injecting global variables into program objects.)
•The Cloud Storage Service now requires an email address for notifications to be set on each computer running DONATION, which should be the email address of the main user DONATION on that computer. You will be prompted for it when you first use this (or a later) version, if it has not yet been set up, and it can also be set or changed in the Backup/Restore ⇒ Backup Frequency and Options window.
•Release 4.22 used a significantly re-written installation program. Various problems were found with it since then, and new versions of the installers were uploaded between these releases. This release includes fixes for all known problems so far.
•Added Reports ⇒ Fiscal Year ⇒ Non-Receiptable and Pre-Receipted Donations and Reports ⇒ Fiscal Year ⇒ Unreceipted Donations, which are just like Reports ⇒ Donation ⇒ Non-Receiptable and Pre-Receipted and Reports ⇒ Donation ⇒ Unreceipted, respectively, but for the current fiscal year.
•Fixed a bug in Batch Entry: for full users who aren't displaying the Member/Envelope # field, or for Limited users who can't see donor names, the "Count Cash" button that should have been at the bottom left was either invisible, or moved so far left that only the last two characters, "sh", were visible on it.
•Fixed a bug: If Canadian users used the Report Browser to run the DONATION REPORTS ⇒ Unreceipted report, they did not get the correct version of it that included the Notes column, as they would do if they ran it with the menu option Reports ⇒ Donation ⇒ Unreceipted. (That column isn't needed for non-Canadian users.)
•Simplified the installation of the Local Network Client version of the program: you no longer have to enter the full pathname to the database file. Also improved error handling on connection errors when running that version. Those improvements include now having the option to prompt for a changed Local Network Server computer name from the program itself, which could previously only be done by re-installing the Local Network Client.
•Added a new control Show Donations on the Donations tab of Maintenance ⇒ Main Window Options, with the options "Only Current Year", "Also One Prior Year", or "All Years". This determines how many years of donations are shown with each donor on the program's main window. Until now the behaviour has always been the same as the default option, "Only Current Year". If additional years are shown, they are only for your information: you cannot edit them or delete them there.
•Moved Reports ⇒ Donation ⇒ Current Donor and Reports ⇒ Donation ⇒ Current Donor History to be on a new Reports ⇒ Donation ⇒ Current Donor sub-menu, with the previous Current Donor report now named Current Year Details on that sub-menu, and the previous Current Donor History report now named History (Annual Totals). Added a new 3rd report All Years Details to this new sub-menu. It lists all donations for the current donor in all years.
•Added Reports ⇒ Fiscal Year ⇒ Receipted Donations, which lists all receipted donations for a range of dates within your fiscal year.
•For Custom Reports with retrieval parameters (ranges of dates and optionally a category), or for SQL Selects where the codes for those retrieval parameters are used, if you are displaying the report in the standard Normal report style (not Grid), there is now an extra line in the report's header, showing the values of the retrieval parameters you entered (for instance, "Donations between Jan 1, 2019 and Dec 31, 2019 for the category General").
•Fixed two bugs in receipts introduced in release 4.18: both Quebec (French only) regular receipts, and Quebec (bilingual) Gift in Kind receipts with Advantage (Eligible Amount entered) would fail, with errors including saying that there was no column named "donor.NAME_W_MIDDLE".
•Improved the messaging if you have a memorized report that you memorized after using the Save SQL button to save its SQL to a file, editing that SQL, then reloading it with the Load SQL button, and then when you run the memorized report the saved SQL no longer works. (That would most likely because we have changed the definition of that built-in report in a newer release of the program.) Also improved the error messages if you are just viewing a non-memorized report and use Save SQL, edit, and Load SQL, and the loaded SQL doesn't work.
•Fixed a problem where the Load SQL button failed if there were any double quotes (") in the SQL.
•Changed the installation program so it will no longer install on Windows XP (which Microsoft stopped regular support for in 2009) or Windows Server 2003 (which Microsoft stopped regular support for in 2010). Because of this lack of support for security fixes, we do not feel it is at all safe to continue using these versions of Windows, and in addition, some time back we started using some functions in the program that do not exist in those versions. The program can be installed on all later versions of Windows: Vista, 7, 8, 8.1, 10 or later, or Windows Server 2008 or later.
•Added the menu option Receipt ⇒ Current Donor Original Quick Print. It is just like Current Donor Original, but it immediately prints the receipt to your default printer and closes the receipt-viewing window, without letting you look at it first. The only messaging is to tell you the receipt number and that it has sent it to your default printer. This is particularly useful for high-pressure situations in which you have to do a lot of data entry of individual donations and create each receipt immediately after making the entry.
•Made two improvements to Custom Reports:
oThere is a new Include All Donors checkbox above the Donor columns list. If you check that, and you are including both Donor and Donation fields, your resulting report will include any donors that have no associated donations, where previously, or if you do not check that, only donors with donations were included.
oReports that include either the Envelope # column (which might alternatively be called Member #) or a full Name column (not just individual partial name fields like First Name) will be sorted on that Member/Envelope # if it was selected, or else the donor's reversed name (like "Smith, John"). Previously except in very limited circumstances Custom Reports were not sorted at all initially.
•Changed all of Reports ⇒ Donation ⇒ Receipted, Reports ⇒ Donation ⇒ Non-Receiptable / Pre Receipted, and Reports ⇒ Donation ⇒ Unreceipted to also show the Eligible Amount values if that field is being shown in your Donation Details area (as specified in the Donations tab of the Maintenance ⇒ Main Window Options window).
•When you run a report that has selection criteria (such as a range of dates) and get the message "There is no matching information for this report", you now get an additional message telling you that you can click the Rerun button to try again with different criteria.
•Fixed an unintentional recent change to the sort orders in Reports ⇒ Donor ⇒ Donation Info ⇒ Sort by Member/Envelope #, Reports ⇒ Donor ⇒ Addresses by Member/Envelope Number, and Reports ⇒ One Date Donation ⇒ Details with Member/Envelope # (and the variations of that one with an added Summary or Description). Previously in those reports, all donors with Member/Envelope numbers came first in the report, in order by that number, then all of them with no such number, in alphabetical order. That had accidentally been changed to put all of the ones with a number last, instead of first. That is now fixed.
•In a number of reports (and mail-merge tables) that list donation details, added the donation category name to the sort order, after the existing sort orders. So for instance if before this release a report was sorted by Name then Date, and could thus end up randomly sorted within one name and date by Category, now it is sorted by Name, Date and Category.
•Made some fixes for computers with a 2nd monitor attached:
oFor the windows that remember their last-used size and position when you next use them (including the program's main window and reports-viewing window), if you had moved the window to that 2nd monitor, it will again come up there when you next open it.
oIt takes care of the case where you last had such a window on the 2nd monitor, then unplugged that 2nd monitor from your computer and used the window again: it puts the window back onto your main screen.
oIt could still be a problem if you last had such a window on the 2nd monitor, then turned off that monitor and forgot to turn it back on. In that case, the program will still think it can put the window on that 2nd monitor, since Windows cannot detect that the monitor is attached but turned off. So the window will just appear to not come up, and the program may appear to be hanging!
•Put back a missing helper file (msvcp100.dll) which had somehow gone missing from the installation programs for the Lite and Local Network Client versions.
•Fixed the width of the Add Donor window, accessed from the Batch Entry window, to accommodate the new Title and Middle Initial fields. Also fixed the fact that it wasn't properly hiding them in that window if you had chosen in Main Window Options not to have them showing.
•Changed all of Reports ⇒ Donation ⇒ Receipted, Non-Receiptable/Pre-Receipted, and Unreceipted to show the Eligible Amount column if you have selected to have it displayed in the Donations tab of Main Window Options.
•This release uses a new version of PowerBuilder, the program we use to build DONATION.
•Made some adjustments to converting / importing routines from other vendors' databases, given that we now have separate Title and Middle Initial fields in the donor details:
oFor converting from Membership Plus, the Middle Initial was previously added at the end of the First Name, but will now go into its own field. The Title was previously not being imported, and now is being imported into the Title field.
oFor converting from GiftWorks, the Title was previously being ignored, and is now being imported into the Title field.
oFor converting from Geminon, the Title was optionally being imported at the start of the First Name, but is now being imported into the Title field.
oFor converting from Church Assistant, no changes were made because it did not have fields for Middle Initial or Title.
oFor importing from files exported from Viansoft, no changes were made because it did not have fields for Middle Initial or Title.
•Fixed a bug introduced by release 4.18, where if you hide all three of the "Member/Env #", "Title" and "Middle Initial" columns in the Maintenance ⇒ Main Window Options window, a empty space appears in the main window between the First Name and Last Name fields.
•Fixed a bug introduced by release 4.18, where a database update fails, with an error message like "Column Unknown d1.middle_initial...", if you are updating from a release that is quite a few years old.
•Added two new Donor Details fields: Middle Initial (abbreviated on the main window as "Mid.Init") and Title. If you don't want to use them, you can turn them off in the Maintenance ⇒ Main Window Options window's "Show Fields" section.
•Moved the First Name field to be above the Last Name field in the Donor Details area on the main window. Previously it was below it. The Title field, if you are showing it, appears on the same line as the First Name, and the Middle Initial field, if you are showing it, appears on the same line as the Last Name. That way if you read those four fields from left to right and top to bottom, they will come out in the normal order, like Title First Middle Last. Example:
•Added a checkbox on the Maintenance ⇒ Main Window Options window for "Include Title in Names for Letters and Receipts". If that is checked, anything you enter in the new Title field will be automatically included in the donor's name in all receipts, all mail-merge letters, when Emailing Newsletters or Everyone, and also in the two statement-like reports, Reports ⇒ Donation ⇒ Details, One Page per Donor and Category Totals, One Page per Donor.
•Added a checkbox on the Maintenance ⇒ Receipt Options window for "Include Middle Initial in Donor Names in Receipts". If that is checked, all receipts showing the donor's name will automatically include any Middle Initials you have entered. That option defaults to checked for users in Canada, because the Canada Revenue Agency requires donors' middle initials to be included on receipts.
•Added additional merge fields for mail-merge letters (but not mail-merge receipts) for the Middle Initial and versions of the Name fields including the Middle Initial. (Those additional fields are not included in mail-merge receipts because the checkbox mentioned in the previous point controls whether or not the Middle Initial is automatically included.)
•Added additional Donor fields in Custom Reports for the Middle Initial and Title, and variations of the Name fields including one or both of them.
•Changed the two statement-like reports, Reports ⇒ Donation ⇒ Details, One Page per Donor and Category Totals, One Page per Donor, to show the donor's address as well as their name.
•Added the ability to import the Title and Middle Initial in the Database ⇒ Import ⇒ Donors window.
•Did not at this point add the ability to import any separate Title or Middle Initial fields from any other programs that DONATION has specific importing or conversion routines for, such as Membership Plus or GiftWorks. That will be investigated and added, as appropriate, in a later release.
•Added some extra messages in the program if you are using the Maintenance ⇒ Email Sending Configuration menu option, for handling new issues we have become aware of for configuring Apple-supplied email addresses (@me.com or @icloud.com).
•Changed the installation programs so that they don't try to put the uninstallation program in a C:\Windows\Donation folder, which some users may not have permission to write files to.
•Corrected a few places in the Help where filter conditions were shown using the old-style filter expressions, to instead show the fill-in-the-blanks values used in the new Simple Filter window introduced in release 4.15.
•Added an Edit ⇒ Select All menu option to the mail-merge editor, which selects (highlights) all of the text in the document (same as pressing Ctrl+A).
•Put back in the Backup/Restore ⇒ Restore Old Database (DONATION3.DB) menu option. Although it was only needed for conversion from version 2.70b or earlier of DONATION (released in 2007 or earlier), and almost no users should still need that, it was still occasionally coming up.
•Fixed several mailing label reports that had accidentally been changed to be sorted in order of first name then last name, instead of last name then first name like they were supposed to be.
•Changed a number of reports that showed a name with the last name first (like "Smith, John") to call that field "reversed_name" instead of just "name", in the Sort or Filter windows, for clarity. (A field called "name" should be first name first.)
•Fixed a bug where if you were viewing a report that showed the sort order in the header, clicked Sort, then clicked Cancel or pressed ESC on the sort window, the sort order would disappear from the header of the report. Also fixed a couple of other very subtle minor bugs in that window.
•Fixed a bug introduced by release 4.15, where using the Email/Print button after running Reports ⇒ Donation ⇒ Details, One Page per Donor or Category Totals, One Page per Donor would give an error message about the donornum and the program would exit.
•Made some further improvements to field names for filtering and sort orders on reports, as in the changes for release 4.15.
•Changed the font size of most of the text in this Help file from 10pt to 11pt, to make it easier to read on screen or if you print out topics. (On screen, you can also zoom the help text to read it more easily, by holding down Ctrl and scrolling your mouse wheel up, or pressing Ctrl with +.
•Various small updates and improvements to the automatic configuration available for various email addresses, by using the 2nd option on the first window that comes up for the Maintenance ⇒ Email Sending Configuration menu option.
•Fixed a bad bug in full installers downloaded from the website (but not updates done with Tools ⇒ Check for Updates) that would cause errors such as "Internal error: Internal donor [or donation] number not updated after save ...".
•Fixed some issues in release 4.15 that could make it more likely for anti-virus programs to object to the installation. (In fact, there was absolutely nothing bad in it. We had just accidentally omitted what is called "code signing" that makes anti-virus programs trust installations more.)
•Reviewed all of the field names in reports available for filtering. Changed some to be clearer, and removed some that it wouldn't make sense to filter on.
•Improved sorting in most reports to prevent a problem where you add a filter, then remove that filter, and then the report ends up out of sort order.
•Added the Database ⇒ Copy Addresses menu option, for copying all addresses from one year to one or more other years. This is for use if they have been updated in the one year's donor records and you need them to be the same in other years.
•In the Web Network Version, the Database ⇒ Switch Database menu option now allows editing, such as creating a new row with a different database extension, which previously it didn't allow. The only obvious purpose for this would be if you had access to two remote databases, and wanted to switch back to a different version like Standalone, and needed to download the remote databases to two different local databases.
•When you are creating receipts and there are no receiptable donations matching what the menu option you are using is looking for, the messaging has been improved to be clearer. Also fixed one bizarre problem that one user was having where there was a receiptable Gift in Kind donation but using Receipt ⇒ Gift in Kind Receipts ⇒ Current Donor Original said there weren't any, and would not generate the receipt.
•Changed Reports ⇒ Bank Deposit ⇒ Summary List so you can click on a date, and drill-down to the One Deposit Details report for that row's bank deposit.
•Changed Reports ⇒ Donation ⇒ Summary by Dollar Ranges to prompt for a range of dates within the year, as well as the optional category it already prompted for, so that you can report on part of each of the current and prior years.
•Fixed Reports ⇒ Administrative ⇒ User Login History which except for the Web Network Version, was never displaying anything in the User column. Now it correctly shows the Windows username of the user who was running it.
•Fixed a crash when starting the program for the first time if you clicked the Register Now button (in versions other than the Web Network Version).
•Fixed a problem that prevented successful Web Network Version registrations from its Log In window, or if you are prompted to register as a first time user, for users that were not previously using another version.
•Fixed some potential problems printing Help topics with screen shots that could be too wide for the page.
•Improved the messaging and options for Web Network Version registrations from the program to help prevent multiple independent registrations for the same organization which could cause duplicate databases. The change also allows for additional registrations for different organizations.
•The program now detects when the current version of the licensing.dll file has not been properly updated by an update, and sends users to the DOWNLOAD page on the website to download and re-install their current version, which fixes the problem.
•A number of users had problems running the program after doing updates to the latest versions, because the file licensing.dll was not being updated. We are unfortunately not sure why that was happening, and this update will not necessarily fix it, but at least it may give a more informative error message if appropriate, and encourage you to send us a screen shot of that message.
•Prevented a possible repeating error message, that you cannot get out of, in a very unusual circumstance when trying to make or restore a backup, if the last-used backup directory was on the C: drive and could be found or recreated for some reason.
•Fixed a problem where non-English characters could not always be successfully saved to and retrieved from the program's settings file DONATION.INI, including if they were part of things like the last-used backup directory.
•Fixed a problem when you run Reports ⇒ One Date Donation ⇒ Details, and it has more than one page. At that point, the VCR-like buttons for First Page, Prev Page, Next Page and Last Page are enabled. If you used the button at the bottom of the last page to switch to the Summary report, then used the button at the bottom of that to switch back to the Details report, the VCR-like buttons did not get re-enabled like they should have been.
•Fixed a bug in the built-in receipts for users selecting either Australia option, or New Zealand, or Other, in the Maintenance ⇒ Receipt Options window, if they also checked the new checkbox for "Use A4 Paper". The bug was that the area for the logo at the top right of the receipt had a border around it, so either it would show your logo with an extra border, of if you hadn't specified a logo, it would show an unwanted rectangle there.
•When exiting the program to install an update downloaded by the Tools ⇒ Check for Updates menu option, avoid some of the normal extra prompts that can come up when you exit the program, such as to backup, validate your database, even check for updates itself!
•Fixed a bug when Importing Donations. If you imported a new category, donations with that category would just show a number instead of the name of that category, until you exited and restarted the program. Also, if donations were imported for the current donor, they were not displayed until you switched to another donor then back to the current one.
•Mail-merge letters emailed to donors, which are sent as attachments, now have the filename "letter.pdf" instead of "report.pdf".
•Added some code, when emailing mail-merge letters, receipts or reports, to catch and prevent a weird case where the previous saved PDF file cannot be deleted or overwritten, leading to a risk of sending the wrong letter or receipt to the wrong person.
•Added to the information that can be displayed to you when trying to configure emailing with Maintenance ⇒ Email Sending Configuration, or do emailing, if there are various sorts of problems encountered.
•Added a section on handling Donations in Multiple Currencies to the Help topic on Entering New Donations.
•Enhanced a number of error messages about bad date entry, to now show what the acceptable Short Date style from the Region settings in Windows Control Panel is (such as MM/DD/YYYY).
•When using the Database ⇒ Copy Missing Donors menu option, either directly or from a Custom Report, and the copy goes forward multiple years, the program now copies first from the most recent year to the target year, then works backwards. Previously it started copying from the earliest year to the target year, then worked forwards. That change means that you are more likely to get the most up-to-date version of missing donors in the year you are copying to.
•When using the Maintenance ⇒ Email Sending Configuration menu option, fixed the fact that the "Determine the setting from your default email program" option in the initial configuration window wasn't working if that default email program was a recent version (such as 16) of Outlook.
•Improved the handling and messaging in the situation where you run DONATION and it says that another instance of DONATION is already running.
•Renamed the mail-merge editor and viewer window's File ⇒ Page Setup menu option to File ⇒ Page Setup and Margins, to make it clear that you could set the margins there (which you always could do). Also added a couple of entries about Margins (for mail-merge receipts and letters, and for mailing labels) to the Index of this Help.
•Fixed a bug in Database ⇒ Import ⇒ Donations: importing of CSV files was broken (it tried to treat them as tab-separated files, and gave a message about only having 1 column instead of the desired number).
•Fixed a bug when you click the Retrieve Donations button in the Maintenance ⇒ Create Bank Deposit window, if you left the new Acct # field blank, that could in some cases give you incorrect messages about bank deposits already existing for the same date.
•Fixed a bug when creating a new database in the Database ⇒ Switch Databases menu option, that could cause the new database to get the same Unique ID for Internet Backups as the one you are switching from.
•For Canadian users, when generating receipts (either regular, or Gift in Kind), if there are no receiptable donations of the desired type that have not yet been included in receipts, but there are receiptable donations of the other type (out of regular, and Gift in Kind), the messages about that are now clearer, telling you which menu option to use to generate those other ones.
•Corrected Reports ⇒ Donation ⇒ By Donor by Category to include donation totals from donors in the prior year that are not present in the current year's Donor List.
•Changed most of the reports under Reports ⇒ Fiscal Year, namely Donor Totals, Sort by Name, Donor Totals, Sort by Amount, Donor Totals, Sort by Member/Envelope #, Donation Details, Sort by Name, and Donation Details, Sort by Date, to all allow you to specify a range of dates within the current fiscal year, as well as an optional category, for the report. Previously all of them always worked for the entire current fiscal year.
•The program now prompts you to validate your database once a month, if you haven't done so in the last month. This is the same action that is done by the Database ⇒ Validate menu option.
•In the Reports ⇒ Custom Reports window, the radio buttons for doing the report for a Fiscal Year, which previously always did the report for the entire fiscal year, have been changed to say "For a fiscal year date range" etc., and they now prompt for a range of dates within the current fiscal year when you run the report from the following SQL Select window.
•In the Database ⇒ SQL Select window, the special codes :FISCAL_START_DATE and :FISCAL_END_DATE, which used to just force the results to be for the entire current fiscal year, now cause prompting for a range of dates within the current fiscal year.
•Removed the option "Authorize DONATION" for authorizing sending emails from the program from a Gmail address. We did that because Google recently added a lot of complex criteria to allow software companies to do that, which unfortunately seemed prohibitively complicated for Software4Nonprofits to satisfy. Instead you can use the other option, "Allow less secure applications".
•For users in countries other than Canada or the U.S.A., added an option in the Maintenance ⇒ Receipt Options window to specify that you are using A4 paper. If you choose that, both reports and built-in receipts should then fit on A4 paper, including if you save them to PDF. For comments and instructions about making this work for mail-merge receipts and letters, see this new section of the Receipt Options help page. (Note to users who use Letter size paper: some reports were changed to be a bit narrower, so they would also work on A4 paper, which is only 8 1/4" wide rather than the 8 1/2" width of Letter size paper.)
•Re-wrote the internal processing in the Database ⇒ Import ⇒ Donors menu option and the Database ⇒ Import ⇒ Donations menu option. Users shouldn't see many differences in the behaviour, except for a few small things:
oA "fix file" is no longer created if fixes are made for problems like too-long field values. Instead, it just displays information about the fixes in a file shown to you in Notepad.
oThat file shown to you in Notepad now contains information about both unfixable errors and warnings about things it fixed, clearly separated out into two sections if both types are present.
oIt should completely resolve the problem mentioned in the Revision History for Release 4.11d, where you are importing donations from Excel, and it can stop you because the formatting of the Amount column would have caused the numbers to erroneously be imported as $0. Now such formatting issues should not cause any problems.
•Fixed a couple of related bugs when turning on the Cloud Storage Service: if you had previous Internet backups, and the program prompted you that they appeared to be newer than your current database, and encouraged you to download the latest backup first, it would not necessarily properly do what you asked it to do (either downloading that, or not downloading that).
•Fixed a bug related to settings saved in the database: In the Tools ⇒ View Saved Settings menu option, when showing Current Database settings stored in the Database, each setting could show twice. (And the underlying problem that caused that could potentially have caused some other subtle problems with settings as well.)
•Fixed a bug when viewing mail-merged receipts or letters: If you did File ⇒ Print Preview or File ⇒ Page Setup, and then after that did File ⇒ Save PDF (or clicked the Save PDF toolbar button), it would print to the real printer instead of saving a PDF, and the little "Printing to PDF File ..." window would appear and never go away. (You could close it by clicking on the "X" at the top right!) Now, it just tells you that you cannot do a Save PDF if you already did a Print Preview or Page Setup. Previous versions already prevented you from doing a Save PDF if you did a regular Print first, again because it would fail.
•Fixed a bug introduced in release 4.12 to Letters ⇒ One Letter and Letters ⇒ Mass Mailing, where sending Donor Information Only, Totals Donations Information or Pledge Information letters could cause the program to crash when you chose to Print the created letter or save it to PDF.
•A few users have been having problems requesting license keys over the Internet. This seems to be due to an internal programming change made (but not noted below) in Release 4.12, that should not have affected anything, but obviously did. Undid that change so it should work for everyone.
•A few users have been having problems requesting license keys over the Internet. This release may not fix that, but it will hopefully give them (and thus us) more informative error messages about the problem.
•Previously, if DONATION was already running, you could not start a restore of a database backup or emailed backup, by opening or double-clicking such files. Now those actions do work if DONATION is already running.
•When you create bank deposits, you can now specify the Account Number for the Bank Account, and it will print on both the report and the deposit slip.
•For multi-user versions (Local Network Version, and Web Network Version with more than one simultaneous user allowed), previously when one user was creating a receipt, no other user could do so, to prevent problems with inconsistent or missing receipt numbers. Now, as soon as that first user has printed the receipt, saved it to PDF, or emailed it, another user can get in to create other receipts. (If the first user does none of those things, other users are still blocked until the first user exits the window where they are viewing the receipt.)
•Fixed a few cases when you have turned off the display of both the Details Table and the Summary Table in the Maintenance ⇒ Receipt Options window, where it would always print a blank 2nd page. The only remaining problem like this is for the Quebec (Bilingual) receipts, which at this point unfortunately we cannot fix. (For those Quebec users who don't want either table, switching to the mail-merge version of the receipts, and editing the receipt template to remove those sections, may allow you to have it be just one page with no blank page.)
•If you have displayed the Report Browser once, then make some changes to memorized reports (in the Memorized Reports window, or with the Memorize button in the report-viewing window or the SQL Select window), previously if you then went back to the Report Browser, and looked at the memorized reports there, they would not be changed appropriately based on what you had done. Now that is fixed.
•Fixed a bizarre bug in Reports ⇒ One Date Donation ⇒ Details with Member / Envelope # and Summary: If you added a Sort to it, or a Filter (which would only affect the details section, not the summary section), one or both of the summary sections at the bottom might get cut off.
•Fixed a bug where Amount values being imported by the Database ⇒ Import ⇒ Donations menu option can be erroneously imported as $0, if they were being imported from Excel, in a column formatted as Currency or Accounting. In that case, the program tells the user to instead format that column as Number and try again.
•Fixed a bug where if you clicked on various places in the data of Reports ⇒ One Date Donation ⇒ Summary (and perhaps areas of some other reports that don't show as blue hyperlinks) it would crash after a techie error message.
•Fixed a bug for the Web Network Version: The menu option Upload/Download ⇒ Download Web Database to Local was failing with an error message. (That menu option was normally only needed if you decided to switch back from the Web Network Version to another version such as Standalone.)
•Fixed a bug for the Web Network Version: If it was an Evaluation version, or your payment had expired, it could prompt you to retrieve a license key from our server, even though that version does not need and cannot use license keys.
•Fixed an obscure and unlikely bug. (This note is mostly for ourselves, as the bug is very unlikely to occur to users!) If you are running the Web Network Version and download your remote database to local, then switch to a local version (likely Standalone), then re-restore the backup file that was stored as part of that download process, the program will halt with an error about not being able to execute sp_validate_connection. You subsequently cannot open the program, because it keeps getting that same error.
•When a new user with a so-far empty database was trying to start by restoring an Internet Backup from a previous user in their organization, the window that came up to prompt them for the Unique ID for Internet Backups didn't allow typing or directly pasting into the entry field for that value. (You had to use a Paste ID from Clipboard button.) Now you can directly type or paste into that field, to avoid confusion.
•Limited users are now allowed to change their own passwords. For users of the Web Network Version, that is done with the Maintenance ⇒ User Administration ⇒ Edit Your Login menu option. For all other versions (other than the Lite version, which doesn't allow the use of a Limited User Passwords) it is done with the Maintenance ⇒ Change Password ⇒ Limited User Password menu option.
•Fixed a bug introduced in release 4.11b: restoring backups, and the Database ⇒ Validate menu option, would fail with a technical error message if you upgraded from a previous version to 4.11b by using the Tools ⇒ Check for Updates menu option. Now Tools ⇒ Check for Updates is fine.
•Fixed a bug introduced in release 4.10. It occurs when you are saving receipts to PDF, or emailing them, but only if in the Maintenance ⇒ Receipt Options window you are using the built-in receipts, and have selected to not include the Details Table, or not include the Summary Table, or both. The bug was that the excluded table(s) would correctly be omitted when displaying the receipt on the screen or printing it, but would still appear (overlaid on top of the other table!) when saved to PDF or emailed.
•Fixed a bug that gave an error message and prevented the creation of receipts, when you have specified in the Maintenance ⇒ Receipt Options window that they are for Quebec (French-only, or bilingual) and that you should Skip Lines between sections of the receipt, when you are receipting donations with Advantage.
•Restoring database backups is now done in a new way internally. (You should not see any difference.) With this change, users of the BitDefender anti-virus software, who have its SafeFiles module turned on, will no longer have to turn off that module to be able to successfully restore.
•A similar change was made to the Database ⇒ Validate menu option, doing it in a new way that should not cause problems if BitDefender anti-virus has its SafeFiles module turned on. Also, that menu option is now allowed for the Local Network Client version.
•Added drill-down capability for fields in many reports that include summary donation totals by donor. Values in those reports are shown in blue and you can click on them. Clicking on them shows a detail report of the donations included in the displayed total for the donor whose total you clicked on. A Back button at the top-left corner of the detail report takes you back to the original report.
•Made a change to the Database ⇒ Import ⇒ Donations menu option's processing, that can speed things up (especially for users of the Web Network Version) after the import is completed. That may also fix problems that a couple of users experienced where the program seemed to hang, or exit, after the import was completed.
•Fixed a problem in the Database ⇒ Import ⇒ Donors menu option, which could cause the program to crash, or to not display any added donors, after a successful import. (They would still have been successfully imported, and would be displayed if you exited the program and restarted it, or restarted it after a crash.)
•Fixed a bug in both Letters ⇒ One Letter and Letters ⇒ Mass Mailing where using a mail merge template designed for one type of merging (for instance, for receipts) was used for the wrong type of merging selected in section 1 of the window (for instance, Donor Information Only). That could give a technical error message and then crash the program, rather than correctly giving some warning messages and showing "FIELD IS MISSING" in a lot of places in the merged document, where there were merge fields that didn't belong to that type of merging.
•Both Reports ⇒ One Date Donation ⇒ Details and Summary and Details with Member/Envelope # and Summary now include a Summary by Paid By section, as well as the previously included Summary by Category section. So now those reports include everything that would otherwise need to be seen with two separate reports on that Reports ⇒ One Date Donation sub-menu: Details (or Details with Member/Envelope #) and Summary.
•Fixed a problem where the Help button in the two Email Sending Configuration windows opened to the Introduction Help page instead of the correct page.
•This version was created with a new release of the program we use to create DONATION, called PowerBuilder 2017 R3.
•Saving built-in receipts (but not mail-merge ones) to PDF, and emailing them, now uses the PDF facility built into PowerBuilder, the program we use to build DONATION, rather than the 3rd party PDF printer novaPDF that is included with DONATION. NovaPDF is still used for saving mail-merge receipts and letters to PDF and emailing them.
•Especially for users of the 5 simultaneous user Web Network Version, made some changes that may speed up some activities that read program settings from the database. However, they also mean that if another simultaneous user changes certain settings, your program may not "see" those changes until you exit and restart it.
•Fixed a very odd and obscure problem: If you created a Custom Report, then used the Save As button to save it to formatted Excel, and closed the Excel program after working with it and before you closed the report-viewing window, then you cannot close the report-viewing window, and are stuck. (You can then only exit DONATION by killing it with Windows Task Manager.)
•Removed all restrictions on the minimum dollar amount of pledges, as long as the annual pledge amount (or total pledge amount for multi-year pledges) is greater than zero.
•For multi-year pledges, individual years' pledge amounts can now $0, though the total still has to be at least $50. (This was in fact partly true previously, except that if the amount in the current year was $0, you could not save changes to the Donor on the main window.)
•Added the Tools Menu option Explore Temp Directory, which can be helpful in some tech support situations.
•Fixed a bug introduced recently, for Local Network Version and perhaps also Web Network Version users: even though your license key said you could have 5 simultaneous users, if you tried to run the program for a 2nd simultaneous user, it would stop you, with a message that you were only allowed to have 1 simultaneous user.
•In both the Database ⇒ Import ⇒ Donors menu option and the Database ⇒ Import ⇒ Donations menu option, if you use the Browse button to select a file, the default file type showing has been changed to "Microsoft Excel Documents". You can still change that, with the file type drop-down near the bottom right of the file selection window, to the previous default, "tab-separated File", or to "comma-separated Value File".
•Fixed a strange problem that started in version 4.05 where a couple of users were missing a table (CONNECTIONS) in their database that should have been created many versions of DONATION ago, causing error messages when the program was run after the update.
•Fixed a bug in the Database ⇒ Import ⇒ All Data menu option. In many cases if you were unable to run the process in that window because you didn't have the right inputs available, the Close button would not be enabled, so it would be hard to exit the window. That option is little-used because we strongly recommend instead using the simpler and more flexible Database ⇒ Import ⇒ Donors menu option and Database ⇒ Import ⇒ Donations menu option instead, if they will be sufficient.
•Fixed a problem introduced by version 4.05 where in the Standalone version, in some places in the program (including when switching databases, or after making a database backup) you could get a message that didn't make sense, like: "You are using the Standalone version of DONATION, but your license key is not authorized for that. Rather, it is authorized for the normal Standalone version ...".
•In the Batch Entry / One Date Donation window, the Copy Prev button is now active even if there is only one donation for the current donor on the last date on which donations were entered for them. Previously there had to be at least two.
•There's some new behaviour in date fields, in addition to the existing keyboard shortcuts for them: When you enter a date field, normally its first component (before the first slash or dash) will become selected (highlighted). Pressing the left or right arrow keys or the forward slash key (/) will cycle through the three components of the date field (month, day and year, in whatever order they are displayed on your computer). That can make it easy to just change one of those components, for instance the day of the month. Once it is highlighted, just type what you want to replace it with - there's no need to delete what is there first.
•Fixed a bug in the update installation program for the Web Network Version, when you use Tools ⇒ Check for Updates: you would get an error message like "On Post Install ... Attempt to concatenate global pwd1 (a nil value) ...". Although that message should not have come up, it did not actually indicate any problem with the update.
•Fixed a problem that could occur when registering from the program, if your Windows username included a space (like "Dan Cooperstock"), and your default web browser was not Internet Explorer or Microsoft Edge. In those cases, the registration could fail. This same problem could also affect certain other cases where the program opens web-type files that are on your local computer.
•Fixed a problem where the new automated license key retrieval could try to get a license key that was already older than the version of DONATION that you are running, which would not have been appropriate.
•Added a validation to the rarely-used Database ⇒ Import All Data menu option to ensure that the CONSTANT.TXT file has exactly one line of data in it.
•Made another correction to the new feature in release 4.04b where entering any arithmetic operator (+, -, *, /, or an opening parenthesis) in the field, other than a leading minus sign, popped up the Calculator window. It also popped up if you typed an x or X for times, which was intended, but unfortunately it also popped up if you typed Ctrl+X or Alt+X, which was not intended, and has been corrected.
•The following change was actually made in either release 4.01c or 4.02 (we are not sure which), but we forgot to record it in that version's revision history. Previously when users of versions that allow simultaneous users (Local Network, or Web Network with an appropriate payment level) wanted to create receipts, no other user could be logged in at the same time. Now other users can be logged in - they just cannot also be creating receipts at the same time. As soon as the user creating receipts exits from viewing the receipt (and possibly printing it, emailing it etc.), another user can create receipts.
•Made a correction to the new feature in release 4.04b where entering any arithmetic operator (+, -, *, /, or an opening parenthesis) in the field, other than a leading minus sign, popped up the Calculator window. It should have popped up only when you had actually just typed one of those characters, but instead, it would pop up any time you typed any character at all, if one of those arithmetic operators was contained in what you had already typed.
•Like the change to the Web Network Version made in Release 4.03b, if you are using the Cloud Storage Service and you leave the program inactive - not doing anything in it - for two hours, you will be disconnected, so as to not block other users from using it. The best practice if you will not be using it for a while is to exit the program, and restart it when you wish to use it again.
•The Maintenance ⇒ User Administration ⇒ Administer All Users window for the Web Network Version now allows Administrators to reset passwords for other users, and unlock other users who have become locked out by too many unsuccessful login attempts.
•Many fields for entering currency amounts will now open a new Calculator window, if you enter any arithmetic operator (+, -, *, /, or an opening parenthesis) in the field, other than a leading minus sign.
•For users of the Standalone and Local Network versions, the software licensing has been changed. Now in most cases, if you have an Internet connection, new or updated license keys can be retrieved directly and instantly from our server, rather than having to send an email request to Software4Nonprofits and wait for a person to send you the key.
•Creation of new empty databases (for instance during an initial install of the program, or with the Database ⇒ Switch Databases menu option) is now done by copying from the empty database file DONATION4.EMPTY, rather than by doing a database restore from the database structure backup file DONATION4.metadata. That should solve some problems caused by some anti-virus programs, that prevent certain writing to directories under C:\Users\Public, which is where the program's Data Directory is created.
•Changes to your Organization Name in the Maintenance ⇒ Organization Info window no longer require licensed users of the Standalone or Local Network versions to request an updated license key. Instead, the changed name will automatically be written into your license key file.
•In the Web Network Version, if you leave the program inactive - not doing anything in it - for two hours, you will be disconnected, so as to stop using up server resources and not block other users from using it. The best practice if you will not be using it for a while is to exit the program, and restart it when you wish to use it again.
•Web Network Version users with Read-Only permissions can now change their login passwords, and other information for themselves, with the Maintenance ⇒ User Administration ⇒ Edit Your Login menu option. Previously the User Administration menu under Maintenance wasn't even visible for Read-Only Web Network Version users. Also, if Read-Only users use Maintenance ⇒ User Administration ⇒ Administer All Users, while they cannot use that window, the program offers to show them a list of the Administrators, who can use the window.
•In the Batch Entry window, added a limitation to typing at most 50 characters in the Description field, if you are choosing to display that field. Previously if you entered more than that, you would receive a techie error message and would not be able to save the batch.
•Adjusted a change made in version 4.02e: now when you make the program's main window or Batch Entry wider, there is a maximum width the Description field will widen to (enough for about 50 capital letters), if it is displayed. With the previous change it could expand to ridiculous widths, for instance if you maximized those windows.
•Any action in the program that needs Internet access now first checks that you are connected to the Internet, and if not, gives you a chance to connect and try again.
•Fixed a bug for users upgrading for the first time from a release prior to version 3.80 (released in April 2016), where it could not do a required minor update to the database structure.
•Fixed a bug when using the Web Network Version - its Upload/Download ⇒ Download Web Database to Local menu option gave an error message "Your backup file on the server that was created for this download process could not be deleted ...". In fact the message was incorrect - there was no problem with the download process.
•The installation program is now digitally signed with what is called an "Extended Validation Code Signing Certificate", which may help prevent things like Microsoft's SmartScreen Filter or Windows Defender from incorrectly objecting to downloads - which have nothing wrong with them.
•Removed the Create ID button from the Backup/Restore ⇒ Backup Frequency and Options window for the versions other than the Web Network Version (which doesn't have that menu option). Now, various options in the program, including registering, requesting a license key, and turning on Internet Backups in the Backup Frequency and Options window, automatically generate a Unique ID if you don't already have one, so that button is no longer needed.
•Changed Backup/Restore ⇒ Backup Database so that if you choose to back up to a USB memory key, it does the backup directly to there in one step, as long as there seems to be sufficient space on the USB. Previously it always first did the backup to the Backup subdirectory of the program's Data Directory, then copied it from there to the USB.
•Added a small section on getting Yahoo email accounts configured for successful email sending in the Email Sending Configuration help page.
•Fixed a bug that crashed the Lite version if you tried to use the Reports ⇒ Report Browser menu option.
•Fixed a bug introduced in version 4.02, which for some users was causing it to not be able to do a needed conversion to the MEMORIZED_REPORTS database table.
•Fixed a problem with registrations done within the program, which weren't always working properly when they were forwarded to the website. Also removed a step from this process, so you no longer have to also click Submit on a web page to complete the registration, when it is started within the program.
•Improved the management of connections to the server database in the Web Network Version.
•Fixed a error that some users could encounter when upgrading to release 4.00 or later, with messages about failure to update the memorized reports.
•Changed the wording of version numbers, like this 4.02e, to "Release #4.02e", to avoid confusion with how we use the same word "version" for the named versions of the program - Lite, Standalone, Local Network and Web Network Versions.
•In the Web Network Version, any of the following changes will now invisibly send an email to us, to make sure we keep our contact information for your organization up to date: Changing the Organization Name in Maintenance ⇒ Organization Info, changing your name or login email address in Maintenance ⇒ User Administration ⇒ Edit Your Login, or any additions or deletions of users or changes of user access levels in Maintenance ⇒ User Administration ⇒ Administer All Users.
•When you make the program's main window wider now, when possible the Description field will widen along with the window, if it is displayed. The same applies to the Batch Entry window if you are displaying the Description in it.
•For users of the Web Network Version, if a Program Entry Password had been set in a previous version, don't still prompt for it after doing the Web Network Version login.
•Changed the default sort order of donations on the main window, for new users, to "Newest to Oldest". That shows the most recent donations, and the blank line for entering donations, at the top. This can also be changed in the Maintenance ⇒ Main Window Options window, on the Donations tab.
•Added a section to the Help topic "Generating Charitable Receipts" about printing on A4 paper.
•Fixed a possible bug for users whose Windows usernames are longer than 8 characters, where backup or restores might fail.
•Further fixed the fix in version 4.02 about potential problem data in Donor Comments fields that could allow your database to be backed up, but not restored, with the new version of the Firebird database software.
•Added a new version of DONATION, the Web Network Version, that is still installed on your Windows computer but has its database on a Software4Nonprofits server. See Multiple User Options for the pros and cons of using this version.
•The program is now using a newer version of the Firebird database software. This means that if you are sharing the same database between multiple users, all of the computers running DONATION must be upgraded. Otherwise, when you transfer a database from a program running the new versions of DONATION and Firebird to one running the older versions of both, the database will not be able to be restored.
•Renamed the existing Network Versions of DONATION to be called the "Local Network Versions", to more clearly distinguish them from the Web Network Version.
•Changed the fix made in version 4.01c, to a problem where some users of the Cloud Storage Service found that their computers could not communicate with it, and got a message that said incorrectly that they might not be connected to the Internet or might need to make a rule in their firewall to allow access. This is now done in a better way.
•Added Reports ⇒ Administrative ⇒ User Login History, which shows all dates and times that any user logged on or off of the program, in descending date order (latest first), for any range of dates.
•Added an option "Seconds to Pause between Emailing Receipts" to the Maintenance ⇒ Receipt Options window, for the occasional user whose email provider won't let them send more than one email every some number of seconds, without stopping them due to concerns about spamming.
•All importing and converting of data from other programs has been changed to show progress, by counting up the number of rows saved back to the database, after every 10 rows. This includes Importing All Data from text files, and converting from Membership Plus, GiftWorks, Geminon, or Wincrafters Church Assistant.
•A progress bar is also now shown during the save operations in the Database ⇒ Import ⇒ Donors menu option, the Database ⇒ Import ⇒ Donations menu option and the Database ⇒ Reassign Envelope Numbers menu option.
•Removed the Backup/Restore ⇒ Restore Old Database (DONATION3.DB) menu option, because it was only needed for conversion from version 2.70b or earlier of DONATION (released in 2007 or earlier), and almost no users should still need that. See Converting Data from Prior Versions if you do need that.
•When using the Database ⇒ Import ⇒ From Church Assistant menu option, the program will now give you an option to import the data even if it is two or more years old. Previously it would refuse to do that.
•Fixed potential problem data in Donor Comments fields or Memorized Reports contents, that could allow your database to be backed up, but not restored, with the new version of the Firebird database software.
•Fixed a bug in the Database ⇒ Import ⇒ Donations menu option where if you used the "Adjust to Current Month" or "Adjust to Last Month" checkboxes, but the month they adjusted to was not in the year you were working on in the program, the import could still happen, putting donation dates into that working year that were not actually in that year.
•Fixed a bug in Receipt ⇒ Duplicate/Corrected by Number, where if you enter a receipt number that doesn't exist in the current year's data, you get an inappropriate error message saying "Error retrieving receipts information from the database". Now it properly tells you that there is no such receipt number.
•Fixed a bug when entering or editing donors: if you entered just spaces in the Business Name field, that would still cause the program to think there was a business name, and end up displaying nothing on the row for it in the Donor List, and on some reports.
•Fixed a bug in Receipt ⇒ Current Donor Sample: If you create a sample mail-merge receipt with it, then use the Maintenance ⇒ Receipt Options window to switch back to using the non-mail-merge receipts, and use Receipt ⇒ Current Donor Sample again, it will not have the "SAMPLE" watermark on it that it should have.
•Fixed a bug in the new Correct button on the main window, for correcting already receipted donations. Previously it would allow you to make a change to a donation that made it be non-receiptable, but when you then printed the corrected receipt, that donation would still be included. Now you are prompted to confirm that you want to change the donation to be non-receiptable, and if you confirm that, the receipt number is removed from that donation so that it is no longer included when print the corrected receipt.
•If you have specified logo and/or signature images, previously they were loaded from the database every time you started the program. Now they are only loaded when they are needed, for instance if you are creating receipts or mail-merge letters. (This should make no difference, except for saving time during the start-up of the Web Network Version.)
•A few users reported instances of emailed receipts having the message "You created this PDF from an application that is not licensed to print to novaPDF printer" on the bottom of the page, although DONATION is indeed licensed. Added a bit of further diagnosis that will pop up a message and stop the emails from being generated if the passing of the license information from DONATION to novaPDF fails, which would cause that behaviour.
•Fixed a problem where some users of the Cloud Storage Service found that their computers could not communicate with it, and got a message that said incorrectly that they might not be connected to the Internet or might need to make a rule in their firewall to allow access.
•Fixed a bug introduced by version 4.01: Many users couldn't save reports to PDF with the Save PDF button in the report-viewing window.
•Fixed another bug introduced by version 4.01, if you used the Receipt ⇒ Current Donor Duplicate/Corrected or Duplicate/Corrected by Number menu options (or for Canadian users, the same menu options under Receipt ⇒ Gift in Kind Receipts). If you chose "Also include any unreceipted donations for the same donor" in those windows, it would fail, with a message about "Cannot save receipt number information back to the donation records in the database" and some SQL error details.
•Fixed another bug introduced by version 4.01: various fields in the Tools ⇒ Register Online window wouldn't allow long-enough entries, particularly the Email Address field, which gave an error message saying that what you entered wasn't a valid email address, if it was longer than 13 characters!
•Fixed another problem in the Tools ⇒ Register Online window: if you had previously registered, and then went to that window, then clicked Cancel rather than Submit, then the next time you ran DONATION you would get the window prompting you to register or to say that you had already done so.
•Fixed another long-standing bug with the startup window prompting you to register or to say that you had already done so: if you chose to Register from there, the same window would still be displayed the next time you started the program, and would keep being displayed unless you clicked the "Already registered" button. Now it won't, if you click to Register Now and do Submit the registration.
•Changed the validation of email addresses you enter in the program to allow for the final part after the last period to be up to 18 characters long (the previous limit was 8, and one user encountered an email address that was valid but that DONATION wasn't allowing).
•Added a Correct button above the rows of donations, which can be used to make corrections to already receipted donations, and then immediately create a corrected receipt including that corrected donation. See Editing a Donation for details.
•Added a right-click popup menu on donation fields on the main window, with options Delete and Correct, that do the same things as those buttons in the row of buttons above the donation details.
•We recently found out that for what they call donations with Advantage, the Canada Revenue Agency requires that a description of the advantage be printed on the receipts. Many changes were made to the program to accommodate that, for Canadian users. See Donations and Receipts with Advantage for full details. However, the following a few of the changes for Canadian users:
oAdded a new optional donation field Description of Advantage (also sometimes called Advantage Description) where you can enter that description. (For non-Gift in Kind receipts, you can alternatively enter that description of the Advantage in the existing Description field).
oAdded alternate versions of all Canadian English and French receipts - both the built-in ones and the mail-merge ones - for donations with Advantage, that print the description. Such receipts are always one receipt per donation, because of the fact that they have to include the description of the advantage.
oWhen you create receipts and there are receiptable donations both with and without advantage, the program will ask you which ones you want to create receipts for - you cannot mix such donations (with and without advantage) on the same receipts or in the same batch of receipts.
oNew checkboxes in Maintenance ⇒ Receipt Options, Letters ⇒ One Letter and Letters ⇒ Mass Mailing to allow you to edit and/or merge with the special templates for receipts for donations with advantage.
oIn mail-merge letters for individual donations, or for receipts with advantage (including Gift in Kind ones) include a new merge field «AdvantageDescription».
oThe Reports ⇒ Custom Reports window now includes the Description of Advantage in the fields that can be selected for Donations, as long as you are displaying that field.
oThe first time Canadian users run the program after upgrading to this version (or to a later version, from an earlier one), if you have any receiptable donations that are missing descriptions needed to create receipts for them, you will be given a message informing you of that fact.
oFor Canadian users, added a new Notes column to Reports ⇒ Donation ⇒ Unreceipted, which can show "Missing Description" for donations where a description is needed to be printed on the receipt, but has not been entered. This applies to both Gifts in Kind and donations with Advantage.
•Added another way to access Reports ⇒ Donation ⇒ Unreceipted, through the new menu option Receipt ⇒ Unreceipted Donations Report.
•All Canadian receipts show the new web address (URL) for the Canada Revenue Agency's pages about charities: www.canada.ca/charities-giving in English, or www.canada.ca/organismes-bienfaisance-dons in French. However, if you use mail-merge receipts and have edited their contents, you will have to make the changes to those web addresses yourself, by editing them with the button in the Maintenance ⇒ Receipt Options window.
•Similarly, for Canadian users, if you use mail-merge receipts and have added text to them (such as a cover letter) and will be doing any of the new receipts for donations with Advantage, you will have to make those same changes as you made in the existing receipt template to the new templates for receipts with Advantage.
•Added Reports ⇒ Donation ⇒ All Donations ⇒ Sort by Date, All Fields, which is visible only if you are displaying the donation Eligible Amount field. As well as fields displayed on other reports on that sub-menu, it also displays the Eligible Amount and Advantage Description fields.
•Corrected both the Help on the Reports ⇒ Fiscal Year sub-menu and the text in the Report Browser to show that its reports Donation Details, Sort by Date and Donation Details, Sort by Name can be selected to be restricted to one donation category, if you wish. (That could also have been done with the Filter button, of course.
•Corrected a bug when creating a multi-year pledge for organizations with a fiscal year different from the calendar year, where it could calculate the End Date to be a fiscal year end prior to the Start Date. In fact, multi-year pledges are currently only allowed to be for calendar years, so the End Date is now calculated based on calendar years rather than your fiscal year, eliminating this bug.
•Saving reports to PDF uses a new facility for doing that which is built into PowerBuilder, the program we use to build DONATION, rather than the 3rd party PDF printer novaPDF that is included with DONATION. NovaPDF is still used for saving receipts and mail-merge letters to PDF and emailing them.
•Added a section to the Multiple User Options help topic on the upcoming Web Network Version of DONATION.
•Changed the installation program to automatically fix problems that a few users were having, where for some reason it could not overwrite files in the program's installation directory, so the install failed.
•This version uses a newer version of PowerBuilder, the program we use to create DONATION, and as such we are giving this release a new main version number (4.00).
•When converting from Membership Plus databases, added handling for two never-before seen problems in the Membership Plus data: too-large internal Fund IDs (a number you don't see) that don't fit in the internal donation category numbers in DONATION (that you also don't see), and missing funds (donation categories) for donations. The donations with missing funds will be assigned your first donation category.
•Fixed a very unusual problem when creating Bank Deposits, where you click the Deposit Slip button and it won't do it because it says the total cash from the donations being deposited doesn't match the Cash Count, even though it says the amounts are the same!
•Fixed the Membership Plus conversion so it can now work with Membership Plus version 5.0d, which has an internal version number of 4.93, which made the program think it wasn't at least version 5 (the minimum version it knows how to convert).
•Added both Custom Reports and a section listing all of your Memorized Reports at the end of the list in the Report Browser, unless you are using the Lite version that doesn't include Custom or Memorized Reports.
•Memorized Reports can now have optional Descriptions added to them, in addition to their name. The Descriptions can be added when you are memorizing them, or on the Memorized Reports window itself.
•Added some details about a couple of powerful free WYSIWYG (what you see is what you get) HTML editors that you can use from our internal mail-merge editor, for things that cannot be done in the internal editor, to the page Configuring an Alternate HTML Editor.
•Fixed a bug in the Database ⇒ Switch Databases window where uses of the Browse button always gave a message that the selected file wasn't in the correct directory.
•In the Reports ⇒ Memorized Reports window, after running a report, and closing the window(s) doing that took you to, you return to the Memorized Reports window. (Those other windows can be the main Reports window, or the SQL Select window.) Fixed a weakness where the information about the list of reports in the Memorized Reports window is not updated on that return. That could be necessary if you made changes and re-memorized the report in one of the windows you were taken to. Without this fix, re-running the same memorized report immediately would ignore those changes. Also, any new memorized reports with new names would not have appeared on the list in this window when you returned to it.
•Fixed a bug when you use the Delete button In the Memorized Reports window, where you got an error message and the report didn't disappear from the list. (It actually was deleted though.)
•When converting Membership Plus databases into DONATION, the program now allows for two previously unseen problems in the Membership Plus data: duplicate Fund IDs, and organization Members with no name fields filled in at all.
•For Australian DGR recipients, one line of the built-in receipt was too wide on A4 paper, so adjusted that some.
•The rules for determining whether a donor or donation is non-receiptable have been changed to be case-insensitive, so for instance the value "NON-RECEIPTABLE" will now also work for a Cheque # / Paid By or donor or donation Category value, and Category values will work that start with "nr " or end in " nr", to make the donor or donation non-receiptable.
•You can now enter the Receipt Password in place of the Program Entry Password when you start the program, if both are set up. If you do that, you will not also be prompted for that Receipt Password if you use any of the Receipt menu options that normally require it, during that run of the program. (The Help page on Passwords in the Program has always stated that this was allowed, but either that was never correct, or we accidentally broke that capability at some point - we're not actually sure which!)
•Fixed a bug in the «DetailsTable» field for Pledge mail-merge letters, if the Pledge type set in the Pledges tab of Maintenance ⇒ Main Window Options was one with a Start Date: donations made exactly on that Start Date, that were part of the pledge, were omitted from the results of the «DetailsTable».
•The program does not display properly if you have Windows 10 and have set your display into Tablet Mode, so if that is the case, you now get an error message with instructions for turning off Tablet Mode, and the program exits. You can restart it after turning off Tablet Mode.
•Changed the messages that come up if you try to backup or restore using a UNC path (such as \\computername\path\...). Previously that never (or at least almost never) worked, and you got a hard to understand techie error message from the Firebird database software. Now you get a clearer message, earlier, directly from the program. (This change was actually in version 3.85, or perhaps 3.85b, but we forgot to mention it before this.
•Added a section warning about ways you can print mail-merge receipts that will cause them to not be saved back to the databases, in the Help topic on Generating Receipts using Mail Merge. Also added a message about that problem if you go into File ⇒ Print Preview when viewing a mail-merge receipt, because that print preview window has a Print button that the program cannot detect the use of, and thus causes the receipt to not be saved.
•When saving reports to files with the Save As button, there is now an option to open reports saved as HTML in Excel, in addition to opening them in your default web browser. However, that is likely to come out worse in most cases than if you save them directly as Excel.
•Reorganized the Tools ⇒ Register Online window, splitting the fields up into groups for Organization Information, Contact Person, and Other Comments.
•When using Batch Entry, previously it would allow you to enter a Gift in Kind without a Description. Now it won't. (Normally it makes more sense to enter Gifts in Kind on the program's main window anyways.)
•Fixed a problem when you are doing Email/Print on receipts, if you choose to do the Print part to the "novaPDF Pro v7 for DONATION" printer to get a PDF containing all of the ones that are to be printed rather than emailed. It would previously give you the message "You created this PDF from an application that is not licensed to print to novaPDF printer" at the bottom of each page of the PDF. Now it doesn't. For normal built-in receipts, you would choose that printer with the Print Setup button, print to clicking Email/Print. For mail-merge receipts, you get to select the desired novaPDF printer in the Printer dialog box that comes up.
•If you are using the Cloud Storage Service, and you enter a different Internet Backup Password on program startup from the last one you used, the message asking you to confirm whether or not you actually want to change the password to a new one is clearer, and you are asked a 2nd time to confirm it, if you answer that you really do want to change it. This should help to prevent accidental changes to the password.
•Fixed a rare problem in the editor/viewer for mail-merge letters and receipts, where you get a message about "Null object error in of_focus event" and the program crashes.
•When you are editing donor details, when there are empty address lines with a filled-in line following them, they are moved up. For instance, if Address Line 1 is empty but Address Line 2 is filled, in line 2 is moved up into line 1, and similarly with lines 2 and 3. (This change was actually made in version 3.82, but we failed to mention it in the revision history for that version until adding it in there, and here, now.)
•When you are Importing Donors, empty address lines have following filled-in address lines moved up into them, just like when you are editing donor details as described in the previous point.
•If you are emailing just a single receipt or letter, and there is a problem sending that email, the error message you receive should now be more informative. Other emailing error messages will also now be more informative, and the email log file that it may offer to show you should also now always be correct. (Previously sometimes it was not showing the log file from the actual error that was relevant.)
•Many reports that included donation category names would not print the entire name if it was long, especially if a lot of capital letters were used. Most of those reports should be fixed now to work with virtually any donation category name that you can enter. (They are a maximum of 20 characters long.)
•Fixed a problem that could prevent database schema updates from version 20 or 21 to the current version to fail, with error messages about an unknown column named BANK_DEPOSIT_DATE.
•Sometimes the Tools ⇒ Fix novaPDF Problems menu option would not succeed because DONATION was running while the fix program was running. Now you are prompted to allow DONATION to exit prior to running the fix.
•In the selection window for Reports ⇒ Donor ⇒ Contact Information, you can choose between reporting on all donors, or only donors with donations within a specified date range. However, the heading text of that window previously said you could also select it only for the currently selected donor, which was not correct. That incorrect wording was removed.
•Made a correction to the fix in the Cloud Storage Service made in version 3.84g, to not mess things up if the user's Windows username has a space in it.
•Increased the warning wording in both the program and this Help file about the fact that editing mail-merge receipts or letters in Microsoft Word can damage them, causing merge fields to not merge. Also added a messagebox explaining how to identify and fix merge fields that did not merge because the file was damaged by editing it in Word.
•In the Bank Deposits window, changed the way deleting a retrieved existing bank deposit works, to fix a bug where the delete failed if not all the donations that were originally in the deposit were retrieved into the details area of the window. (That could happen, for instance, if the donation category of one of those donations was changed to one without an associated accounting program income account.)
•In the Maintenance ⇒ Change Password ⇒ Internet Backup Encryption Password menu option, it now allows passwords of length up to 20 characters (previously only 10), and only accepts a change if the password is sufficiently strong (see Passwords for Email and Internet Backups for details).
•In the Database ⇒ Delete Old Data menu option, corrected it to behave as described in the Help, namely to allow deletion of data up to the year three years before the current calendar year (for instance, deleting up through 2014 if it is now 2017). Previously, due to a programming error, it forced you to retain one more than that.
•Added several references in various Help pages to the use of the phrase "contribution statement" in the U.S.A. to refer to what the program always calls "receipts".
•Made a fix to the Cloud Storage Service so that if the user's Windows username has accented characters in it, they do not cause problems, which previously they did.
•Added a bit to the Help topic on Importing Donations about importing multiple years of donations when you first start using the program.
•Made some improvements to the Help topic Year End Procedures to add further clarity.
•Further improvements to the changes in version 3.84e.
•Fix a problem where some users were observing that if they had Internet Backups configured, after the normal backup was done, and it prompted for the Internet Backup Encryption password, the focus would be in the main window instead of that window prompting for the password.
•Changed how the program updates the database structure, so that if some updates have somehow been missed in the past, the program can go back and do them, rather than exiting because a later update cannot be done.
•When you are Importing Donations with Database ⇒ Import ⇒ Donations, previously if there was a donation category in the import file that wasn't already on the list of such categories in the program, the import would stop with a message that you needed to add that category manually. Now the import routine will automatically add any new categories for you.
•Further fix in the Deposit Slip report introduced in version 3.84, to separate out lines for cheques on different dates, if you have not entered a Cheque # / Paid By value for them at all. (With the fix in version 3.84c, would already separate them out correctly, whether they were on the same or different date, as long as the Cheque # / Paid By values were different.)
•In the new Deposit Slip report introduced in version 3.84, if a cheque was split into several donation lines because it was for multiple donation categories, it will now be summed up into one line in the list of cheques in the report. Previously there would have been one line for each donation line.
•Fixed a bug that caused version 3.84 to crash for users with the Cloud Storage Service turned on.
•Multiple changes related to allowing for counting cash and creating bank deposit slips in the program:
oAdded a new "Word for Cash" field in the Donations tab of Maintenance ⇒ Main Window Options to specify the word you use in the Cheque # / Paid By field for cash donations (defaults to "Cash"). It is needed to identify which donations in Batch Entries or Bank Deposits are considered to be cash.
oYou can now print a report that may be usable as a deposit slip from the Bank Deposit window, with a new Deposit Slip button.
oOn the Bank Deposit window, changed the previous Print button to read Report. It displays the existing bank deposit details report.
•In the Reports ⇒ Bank Deposit ⇒ One Deposit Details report, moved the Summary by Category and Summary by Paid By sections of the report to be side by side, to save room.
•Added a new Help topic on the main window.
•When DONATION exports Excel files to text files for importing in various places (for instance in the Database ⇒ Import ⇒ Donors menu option) it now exports to Unicode rather than ANSI text, which means that characters in various other languages should now be imported correctly.
•Fixed a bug when re-retrieving an existing bank deposit in Maintenance ⇒ Create Bank Deposit. If there were further donations that matched the retrieval conditions, that weren't already saved in that bank deposit, previously they would come up with "Include" checked, and the Save button would be disabled (greyed out), so you couldn't save that, unless you unchecked then checked one of the checkboxes. Now those additional donations come up with "Include" unchecked, so you can decide whether or not to include them (possibly by clicking the Select All button) and then Save your change.
•Fixed a bug when importing donors. If a Category1 or Category2 value being imported contained a single quote (such as "John's Bookkeeping"), and there was more than one occurrence of it, the import would fail with a technical message that indicated it was trying to insert duplicate values into the database. Plus, one copy of that category value would actually already have been imported into the appropriate Donor Category table in the database (viewed with Maintenance ⇒ Donor Category 1 or 2) but modified to include a tilde character before the single quote (like "John~'s Bookkeeping").
•Fixed a bug in the Letters ⇒ Mass Mailing menu option: If you chose to just Export the data instead of merging it, the LastYearAmount column would always be empty.
•Corrected several places in this Help file (all in pages about Importing) that said that a Member/Envelope Number could be 10 digits long. It can actually only be 9 digits long.
•For Canadian users, using distinct receipt formats for Gift in Kind donations is now enforced by the program, because it is required by the Canada Revenue Agency (CRA). Previously it was an option. The "Use different receipts for Gifts in Kind / Non-Cash Gifts" checkbox previously shown on the Maintenance ⇒ Receipt Options window for Canadian users was thus removed.
•Canadian users of the free feature-limited Lite version can now also create distinct Gift in Kind receipts, since they are required by the CRA, and can enter Description fields and appraisals for donations. (Those donation fields were previously also not allowed in the Lite version, because they were most often needed only for Gift in Kind receipts.)
•For Canadian users, when doing Receipt ⇒ Reprint Range or Receipt ⇒ Gift in Kind ⇒ Reprint Range, if some or all of the receipts in the range to be reprinted are of the wrong type (Gift in Kind versus regular) you will now get appropriate warning messages about that.
•Changed Database ⇒ Copy Missing Donors to bring up a window that allows you to copy donors and categories from any year (and any intervening years) to any other year, instead of having two sub-menu options for copying forward or back one year.
•When you use the Reports ⇒ Custom Report menu option and do a report over a range of more than 2 years, if there are donors in prior years included in the report that are not in the last year, previously they would be excluded from the report. Now, in that situation you are prompted with an option to do the equivalent of Database ⇒ Copy Missing Donors, in order to get all required donors into the last year for the report, to make sure none are missed.
•Added Reports ⇒ Donor ⇒ Non Donors, that lists all donors in the current year's list that have never donated, with the number of years they have been in the system for.
•Added Reports ⇒ Bank Deposit ⇒ All Donations with Deposit Status, which shows every donation with a range of dates that you specify, with whether they have already been included in a bank deposit, or will be omitted from a new bank deposit, and if so why, or would be included in a new bank deposit. This report can be used to help figure out why donations that you think should be included in a bank deposit aren't being retrieved when you try to create a new bank deposit.
•Made several small improvements to the Maintenance ⇒ Change Password menu options:
oYou now cannot set up a Limited User or Read Only password if the Program Entry and Internet Backup passwords are identical. (That's because all users should know the Internet Backup password, if one is set up, but then the more limited users would also know the Program Entry password.)
oYou now can't set the Program Entry and Internet Backup passwords to be identical if a Limited User or Read Only password is already set up, for the same reasons.
oYou now can't set any of the Program Entry, Receipt, Limited User or Read Only passwords to be identical to each other.
•Both Reports ⇒ Donor ⇒ Addresses and Addresses by Member/Envelope Number now include a field for the total amount given by the donor in the current year, which can be filtered on, but is not actually displayed on the report.
•In the Database ⇒ Import sub-menu options for importing data from Membership Plus, GiftWorks and Geminon, negative amounts can now be imported. Previously they would be omitted from the conversion. (This change was possible due to the change in version 3.80 to allow turning on an "Allow Negative Amounts" option in the Donations tab of Maintenance ⇒ Main Window Options.)
•Added the Help ⇒ Search by Topic or Keyword menu option, that actually just brings up a messagebox giving you instructions for how to do that, but also has buttons that take you either to the Help file where you can use the Index for searching, or to the How to Use Help help page for further instructions.
•Changed Help ⇒ Contents and Index so that it always opens on with the Index showing, which we believe is the most commonly helpful option. Previously it would show whichever of the Contents, Index, Search or Favorites tabs that you had last been on when you used the Help file.
•If you select the pledge type "Annual with Start Date and Category", there is a new Pledge information letters mail-merge field: «TotalAmountAllCategories». It gives the total of all donations for the year, whether or not they are for the pledge category. It will always be the total of the donations listed in the «DetailsTableAllCategories:...» field.
•For users who are not in Canada (based on the setting in the Maintenance ⇒ Receipt Options window), you are now allowed to leave donors' Address Line 1 fields empty. For Canadian users it is still required, because the Canada Revenue Agency requires a donor's complete address to be printed on receipts. When importing donors from files, or converting from other software systems, there are new messages and behaviours for Canadian users when a donor to be imported is missing an Address Line 1 value.
•When you are editing donor details, when there are empty address lines with a filled-in line following them, they are moved up. For instance, if Address Line 1 is empty but Address Line 2 is filled, in line 2 is moved up into line 1, and similarly with lines 2 and 3.
•Added a new Help topic, Handling Anonymous Donations, which is something people often ask us about.
•Resolved a problem when Converting from Membership Plus databases, where the import would fail if there were Member rows in the Membership Plus database with no internal Member ID field value. (That should not be possible, but was happening with one user's data.) Now such rows are ignored. We are quite sure they could not have had associated donations, so that should not be a problem.
•There is a new Tools ⇒ Fix novaPDF Problems menu option, which downloads and runs a program from our website to uninstall and reinstall the novaPDF PDF printer, to fix problems that sometimes come up (for instance if you uninstall the printer driver, or delete some of its files). The program is also using a newer version of novaPDF.
•When you are installing a license key or evaluation extension key, the program now removes unexpected characters (which might be invisible!) from the lines before doing anything else, to correct unusual errors in the copy and paste process of putting the key into that window. It also checks the lengths of those lines of the keys after that, and doesn't proceed if they are an unexpected length.
•For the statement-type reports, Reports ⇒ Donation ⇒ Details, One Page per Donor and Reports ⇒ Donation ⇒ Category Totals, One Page per Donor, if you emailed them, the text body of the email that you specified should have been saved and redisplayed for you to use the next time you emailed them. But it wasn't - now it is.
•The Receipt ⇒ Filtered Donors window (and Receipt ⇒ Gift in Kind Receipts ⇒ Filtered Donors if you are using separate Gift in Kind receipts) now allows you to also filter the donations on a range of donations' Dates Received. This could be used to generate receipts for all donations for an event where the donations are all recorded on the same date, if there wasn't already a distinct donation category you could filter on for that. It could also be used to receipt just one receiptable donation for a donor with multiple unreceipted donations, as long as you also enter a donor criterion to restrict the receipts to that one donor. It could also, of course, be used for an actual range of dates (not just one date).
•You can now give your own names to the Donor Category 1 and Category 2 fields, in the Maintenance ⇒ Main Window Options window. Doing so also changes the names of relevant menu options, text on reports, etc.
•In the Database ⇒ Import ⇒ Donors window and the Database ⇒ Import ⇒ Donations window, the option to not review the data to be imported before completing the import has been removed. Now you will always be shown the window on which you can review that data.
•In the Database ⇒ Import ⇒ Donors window, you are now warned if it appears that donors to be added have the same names as existing donors, which could mean that the import would create duplicate donors.
•Fixed a bug in the new checkbox for "Allow updating existing donors, matching on the Member/Envelope Number" in the Database ⇒ Import ⇒ Donors window. When you were updating existing rows, it could fail with a techie error about a violation of a foreign key constraint, when trying to delete a row from the DONOR table that had donations. (The import feature doesn't ever actually delete any rows, but it was trying to update an existing row by deleting it then re-inserting it.)
•The Database ⇒ Import ⇒ Donors window now has a new checkbox for "Allow updating existing donors, matching on the Member/Envelope Number".
•In the Maintenance ⇒ Receipt Options window, you can now choose to include both the Cheque Number and the Description in the Details Table for the built-in (non-mail-merge) receipts. You could always do that for mail-merge receipts. Previously you could only choose to include one or the other for the built-in receipts. The default is still to include neither.
•There is a new option on the Donations tab of Maintenance ⇒ Main Window Options, "Allow Negative Amounts". Although for issues like cheques that have been entered into DONATION then come back NSF we recommend just deleting that donation, some users prefer to enter a separate "donation" that has a negative Amount, to reverse the original donation. Checking this new checkbox allows for that.
•Fixed a bug that did not allow an Eligible Amount of a donation to be $0 if you had not checked the "Allow $0" checkbox on the Donations tab of Maintenance ⇒ Main Window Options.
•If you select the pledge type "Annual with Start Date and Category", there is a new Pledge information letters mail-merge field: «DetailsTableAllCategories:...». Unlike «DetailsTable:...» for such pledge letters, which only lists donations towards the pledge, the new field lists all donations in the current year, whether or not they are toward the pledge.
•If you select the pledge type "Multiple Year", there was a bug when editing Pledge information mail-merge letters: if you inserted the field «DetailsTableAllYears:...» with the Insert button, it should have prompted you for which Donation fields to include, but it didn't. That has now been fixed.
•When you are creating a bank deposit, if you have donations with an eligible amount different from the total amount (split receipting) you can no longer set the Bank Account and the Advantage Account to be the same account name, which would have been an error. The Advantage Account must be an income account in your accounting program.
•In Custom Reports, you were not supposed to be able to select both a regular amount field (Total Amount or Eligible Amount) and a summary field (a Sum or count), because that really doesn't make any sense, but it was not preventing that as it should.
•Also in Custom Reports, you can no longer select both the Donor Comments field and a summary field (a Sum or count) because that generated SQL that would not work.
•If you start by installing the free feature-limited Lite version, then install one of the full-featured versions (Standalone, Network Server or Network Client) on top of that, previously your 60-day evaluation period would count as starting when you installed the Lite version, and thus the evaluation period might already be over. (In that case you would have to get an evaluation extension to continue evaluating that full version, unless you paid immediately.) Now doing this upgrade restarts your evaluation period. In the unusual case where you had previously had a paid licensed copy of a full version, switched to Lite, and then switched back to a paid version, this will also remove your saved license key from the licensing file, so you will have to reinstall the key (if you still have it and it is up to date) or re-request it (if your payments are up to date).
•In the Maintenance ⇒ Paid By Values window, there is an obscure way to cause it to have two rows with "Cheque" or "Check" in them, which should not be allowed, and prevents you from making any other changes. Now if that is the case, when you close that window, it will detect the problem and delete the duplicate row.
•If you enter an incorrect password in the program (such as a Program Entry password), the message you get now includes the Organization Name from the database you are trying to access. That can be helpful if you have multiple databases, and might be putting in a password for the wrong one. It's also helpful if you forget your password and we have to give you a temporary one to get in, because it is based on the exact Organization Name, which you can then tell us.
•Fixed a bug introduced by version 3.79, if you are trying to install an evaluation extension: the program exits, after giving a message "Internal error: licensing object not passed when opening w_new_eval_date".
•Changed the Maintenance ⇒ Receipt Options window, to separate out checkboxes for including the Details Table and Summary Table for the built-in (not mail-merge) receipts. This allows you to omit both of them. This may allow built-in receipts with the Receipt Style / Location of "Quebec (French only)" to fit on one page, when they otherwise went to two pages. Unfortunately receipts for "Quebec (bilingual French and English)" still print a blank page even if you omit both tables, a bug which we have not been able to eliminate so far.
•Fixed a bug where when you printed sample mail-merge receipts (or saved them to PDF, or emailed them) created with Receipt ⇒ Current Donor Sample: the "SAMPLE ONLY" watermark might not appear. (This was supposedly previously fixed in version 3.73d, but I think the fix only worked with older versions of Internet Explorer.)
•Fixed another bug with the built-in (not mail-merge) sample receipts, where if you emailed them with the Email/Print button (which for sample receipts always goes only to yourself, for testing), the Details Table and Summary Table disappeared in the emailed PDF file (and on-screen, after the emailing).
•Users have been having trouble configuring email sending with Gmail in the Maintenance ⇒ Email Sending Configuration window. There are now two different solutions available in the program for that. Details are in the Help page Gmail Configuration.
•In the first Maintenance ⇒ Email Sending Configuration window, made the figuring out of the settings from an account in Microsoft Outlook work for newer versions of Outlook (Office 2016 and 2015). Also included details so it could directly figure out settings for @me.com addresses.
•Added Reports ⇒ Donor ⇒ Duplicate Member/Envelope Numbers for finding donors in the same year with the same member / envelope number, which should not normally be able to happen, but could occasionally happen, most commonly by using the Database ⇒ Copy Missing Donors menu option.
•Found the places in the program that would allow duplicate member/envelope numbers to be added, and changed all of them to either report on it after the fact, or prevent if if appropriate.
•Fixed a bug when using the Lowest Unused Member/Env. # option to assign a number to a donor, where if there were donors with duplicate member/envelope numbers, it could try to give the first duplicated number to yet another donor!
•Fixed a problem in the date formatting for receipts. It was supposed to use the format "d mmm yyyy" either if the long date format in Control Panel started with a code for the day number, or if your Receipt Style / Location was one for Quebec, and the format "mmm d, yyyy" otherwise. Now it does.
•Added a new Receipt Style / Location option, New Zealand, in the Maintenance ⇒ Receipt Options window. There are new customized built-in and mail merge receipts for New Zealand. If you were previously using the Receipt Style / Location "Other", and had customized the Other mail-merge receipt for your use, it will be copied to become a customized New Zealand receipt for you to use.
•The built-in receipts for Canada (English), both types of Australia, New Zealand, and Other, should all fit in #10 window envelopes now, as long as there are no separate lines shown for the total amount and eligible amount (split receipting). Unfortunately the same change could not easily be made for the mail-merge version of the receipts - we recommend that you continue using Receipt Mailing Labels if you are using them.
•For mail merge receipts with a «DetailsTable:...» field (and other mail merge letters that can include that field), if ";2column" is included to cause it to have two columns of donations across the page in the table, but there is only one donation to be included in the table, then only one set of column headers is now displayed in the table. Previously two sets of column headers were displayed even when there was only one included donation.
•Those two new fields are used to change the wording for such Receipt Style / Locations to say that the receipt is for the year ending on the fiscal year end, when you have changed the current year to use fiscal year receipting. The same wording changes were made on the built-in receipts for those locations.
•Clarified in the Help for Batch Entry that even if you check "Include existing donations for the specified date", donations that have already been receipted are not displayed. That is because receipted donations cannot be edited, and the only reason to bring them back up on this window would be to edit them. If you just want to see them again, use a report, such as one of the Reports ⇒ One Date Donation reports.
•Added some improvements to how the program figures out how to launch Microsoft Word or Excel, for some users where those Microsoft programs were present on the system but not being found by DONATION.
•Fixed a harmless bug where after certain types of actions you could get a "Null object reference in nvo_receipt" message when exiting the program.
•Eliminated a techie error message (which doesn't actually harm anything) when you try to Memorize a report with no title or subtitle, like mailing labels or envelopes.
•Some aspects of the program code have been significantly re-organized to allow us to share more code between this program and our ACCOUNTS bookkeeping program.
•Fixed a bug where errors communicating with the Software4Nonprofits.com website, like when using the Tools ⇒ Check for Updates menu option, could cause the program to crash with a techie error message about nvo_http.
•Fixed a problem some users were having with emailing where they got messages saying it failed when it shouldn't have, particularly with messages about components not being unlocked.
•Fixed a bug introduced in version 3.77, where Canadian English or Quebec French or Bilingual mail-merge Gift in Kind receipts were failing with an error message about incorrect SQL. Regular (non-mail-merge) Gift in Kind receipts, and non-Gift in Kind receipts, and receipts for any other location (like U.S.A.) were not affected by this bug.
•Added a section on Specific Gmail Problems to the Help page on the Maintenance ⇒ Email Sending Configuration menu option, because a lot of users are having problems with that when their email address are Gmail addresses.
•Made some improvements to the messaging for the unusual cases where there is something wrong with the program's licensing file, to allow you to better understand what is wrong and what to do about it. If it is necessary to re-download and install the program the fix such problems, the program will give you an option to go to the DOWNLOAD page on the website to do that.
•The program now comes with a newer composite version of the 3rd-party controls that used to be separated, for sending emails (Chilkat Mail), for communication with websites (Chilkat Http) and for extracting files from compressed files (Chilkat Zip).
•Fixed a problem where users with Microsoft Excel version 16 might not be able to get it to open files from the program, for instance from the Save As button for reports.
•When uploading Internet Backups to the server (as part of making regular backups, or when you exit the program as part of the Cloud Storage Service) the progress indicator is now reasonably accurate. (Previously it just went across the screen once or more, but didn't correctly indicate the percentage of the upload that was done.)
•Introduced an option for Using Fiscal Year Data Entry and Receipting, for users in countries like Australia, New Zealand and the United Kingdom, where the tax receipting year is not the calendar year. It's turned on by a new checkbox in the Maintenance ⇒ Organization Info window.
•Renamed the "Receipt Style For" field, found both in Maintenance ⇒ Organization Info and in Maintenance ⇒ Receipt Options, to "Receipt Style / Location", for clarity.
•In many places in the program, if you entered data in a field that was not allowed, the error message about that would come up in a message box using a very small font, with the title "Data Entry Error". Now most of those messages use our normal larger font message boxes.
•Fixed a bug when creating bank deposits, where if you have used a bank account name that included double quotation marks, the program crashes when you enter the window for creating another bank deposit. The same problem may have also applied to other fields, like the Advantage Account.
•Fixed a bug in the Maintenance ⇒ Change Year window, where if you select a new year that doesn't yet exist in the database, answer No when prompted to confirm changing to it, and then just close the window by pressing ESC or clicking Cancel, you are still prompted about creating the new year.
•Added a Letters ⇒ Email Newsletters menu option that allows you to send an email to all or filtered donors with email addresses, with an attachment.
•Corrected an inconsistency in receipts for Canada (English) where the displayed Donation Date (for receipts containing only one donation) was in a different format from the receipt date.
•The Maintenance ⇒ Receipt Options window has been slightly re-arranged, and has a new option that only applies to mail-merge receipts and letters: "Use Windows short dates for Details sections". This is mostly intended for users in countries using languages other than English or French, and applies to both the table of donation details and the DonationDateOrYr field, when the receipt is only for a single donation.
•The Receipt Options window also now allows editing of the Receipting Person (the name of the person who signs the receipts), which can still also be edited in the Maintenance ⇒ Organization Info window (where it could always be edited before). This should make this field easier to find.
•Renamed File ⇒ New Member/Env. # and the corresponding popup menu on the "Member/Env. #" Donor Details field to Next Higher Member/Env. #, and added File ⇒ Lowest Unused Member/Env. #, which automatically fills in that field with the number that is the first gap in the sequential numbering (or 1 if that hasn't yet been assigned to any donor).
•On the Donor tab of the Maintenance ⇒ Main Window Options window, added a field for "Lowest Member/Env. # for automatic assignment", that applies to the menu options in the previous point, and is also used as the default starting point for a new "Starting Env. # for assignment" field on the Database ⇒ Reassign Envelope Numbers window.
•Added a "magic" mail-merge field MultipleDonations for use in receipts, that can be used in sections such as "«if:MultipleDonations»text related to multiple donations«else»text related to single donations«endif»" to include variable text based on how many donations are included in each receipt.
•When you switched to a new year for the first time, it was supposed to ask you whether to skip copying donors who didn't have any donations in the last 2 years, but it was not doing that, so it always copied all donors from the previous year. That is now fixed, and the question is being asked again.
•The Cloud Storage Service is now available, which is an improved way for users with DONATION on multiple computers (not on a local network) to transfer their data between computers, using Internet backups, but without having to worry about whose turn it is to have control of the database, because it takes care of that for you.
•In the Database ⇒ Switch Databases window, if you choose a different database in the Current column of checkboxes, the default button now becomes the Switch button, so you can just press Enter to do the switch rather than having to click on it.
•Added comments at various places in this Help file explaining that you should not try to move your database to a 3rd-party cloud storage location like Dropbox, Google Drive, Microsoft OneDrive etc.
•You can now force languages other than English and French to be used in the headings of the «DetailsTable», «DetailsTableAllYears» and «SummaryTable» mail-merge fields in mail-merge receipts or letters, by adding lines with the correct wording into the DONATION.INI file in the program's Data Directory.
•Fixed a bug: If you do Reports ⇒ Bank Deposit ⇒ One Deposit Details (or the same report from Reports ⇒ Report Browser) when there have not yet been any bank deposits in the current year, it first tells you that there are no bank deposits and then when you click OK to that message, the program crashes with a further error message.
•Fixed a bug: If a donor has a business name with a comma in it, like "Smith, Jones and Company" then the heading for the donation details area on the main window becomes reversed (as if it was a person's name), so for instance this example would be displayed as "Jones and Company Smith".
•Fixed another bug: If a donor category field is empty, you change it to "<Add New>", then don't add anything in the popup window and close that window, the category value stays showing "<Add New>". If you then Save, you get a techie error message and you cannot save. The fix is that when you do that, the category now automatically reverts back to the blank (empty) one.
•In both the French and Bilingual Quebec built-in version of the receipts, make the amount move up on the 2nd copy (the one for the provincial tax form) if it's not "split receipting" (no need for lines about the total amount, advantage, and eligible amount). That makes the two copies look more identical.
Version 3.74b (December 3, 2015):
•Fixed Total Donations information mail-merge letters: the «TotalAmount» and other totals fields were wrong (way too high) in the merged letters, for any donors with previous year donations, because of incorrect SQL used to add the «LastYearAmount» field in version 3.74.
•Also, in the Donor Information, Current Donation (or Individual Donations) Information and Donation Totals Information letters, if there was no pledge for a donor, the «Pledge» field in a merged letter was empty, fixed that to display $0.
•Changed Tools ⇒ Register Online, and the Register page on the website, so that the field for the organization's website address allows up to 70 characters (previously 50).
•Provided an option in the Maintenance ⇒ Configure Bank Deposits window, for QuickBooks users to change the date format in the export files from MM/DD/YYYY to DD/MM/YYYY, if they are having problems with importing those dates into QuickBooks on a computer with a Short Date Format like DD/MM/YYYY.
•Fixed a bug where if you try to install an expired license key, the error message you get states an incorrect date as being the expiry date of that license key.
•In the mail merge editor, added an Actions ⇒ Zoom menu option, which actually just puts up a message box telling you how to zoom with keyboard or mouse actions.
•Added a Glossary page to this Help file.
•Fixed a bug in Letters ⇒ One Letter or Mass Mailing, where if you Show Advanced Actions and then Edit Copy, you can get an error message "Error re-retrieving drop-down list of Letters to include new copy."
•Fixed a bug when using Receipt ⇒ Current Donor Sample if you have chosen to use mail merge receipts: the "SAMPLE ONLY" watermark was not necessarily showing up.
•Corrected the description in this Help file of Reports ⇒ Fiscal Year ⇒ Donor Totals, Sort by Name to no longer incorrectly say that it reports on two fiscal years. It only reports on the current fiscal year, like all other Fiscal Year reports. Also corrected this in the description in the Report Browser.
•Added some logging on successful email sends from the program, to help us be able to debug extremely rare problems reported by users where the program says an email was sent successfully, but nothing is ever received. (The log is in the file mailLog.txt in the program's Data Directory.) Also changed the logging on email sending errors from being an XML file to be a plain text file, which is easier to read.
•Fixed an obscure bug in the Reports window. If you had put on a Filter, then removed that Filter, then clicked the Rerun button and re-run the report, you got an inappropriate couple of messages about something being invalid and having to re-save the memorized report. (And it wasn't even a memorized report in the first place!)
•Fixed a very unusual potential problem where in the Database ⇒ SQL Select window, if you are given a password by Cooperstock Software to allow you to do some form of data updating in that window, that password could fail to work because it had an unprintable character in it.
•Fixed a small weirdness in the Maintenance ⇒ Create Bank Deposit window, where if you retrieve an existing deposit, and it doesn't include any donations with an advantage (see Split Receipting), the Delete Deposit button that appears is in the wrong position (too low, partly overlaying the list of included donations).
•The program will refuse to create mail merge letters or receipts, or to do several other functions, if the Windows Control Panel's long date format gives dates that are longer than 20 characters, because for technical reasons this causes problems. Previously the program only told you about that, and gave a longish message saying how to fix that format. Now it gives you an option for the program to try to fix it for you.
•Added a new Help topic Titles in Donor Names, explaining why there is no separate field for titles in the Donor Details area, and some ways to work around that if you do want to record them.
•Hid a few Reports menu options for limited users, that were accidentally shown.
•Improved the clarity of messages you can receive if you run a Network Version of DONATION but only have a license key for the Standalone version. Previously those messages referred to the fact that you were using the Firebird Server, which most users wouldn't understand - now it just refers to the Network Version of the program.
•Added the ability to have two bank deposits to the same bank account on the same date, through a trick.
•Added an option to delete an existing bank deposit after retrieving it.
•Receipts for Quebec that use French dates have a new date format for the receipt date, composed of the day number, a 3-5 letter abbreviation for the month, and the year. For instance, "31 juill. 2015" for July 31, 2015.
•Made a fix in the installation program so it will work on the upcoming Microsoft Windows version 10.
•In the Backup/Restore ⇒ Backup Frequency and Options window, added an option for you to be reminded to backup the program every time you exit it.
•In the Reports ⇒ Custom Reports window, there are two new fields you can select in the Donation fields list: Month # Received and Quarter # Received.
•Also in Reports ⇒ Custom Reports, if you select the # Donations field, and a range of years, and Separate Totals, there will be one # Donations field column for each year in the report, as was previously done for the Sum(Total Amount) and Sum(Eligible Amount) fields.
•In Reports ⇒ Bank Deposit ⇒ One Deposit Details, fix a tiny bug: the bank name could be cut off in the header of the report if it was at all long.
•Fixed a very unusual problem when you are updating from a version prior to 3.72, where if you had two bank deposits done on the same date but as part of different years' data (such as in early January of some year), a database conversion step as part of that upgrade failed.
•In the Database ⇒ SQL Select window, more types of SQL statements (beyond the normal SELECT statement) are now allowed, with the provision of a SQL updating password from Cooperstock Software, than were previously allowed. This will allow our support people to fix certain types of rare problems in users' databases without having to have those databases sent to us by email backup, fixed here, and sent back for restoring.
•Fixed a problem where certain complex numeric expressions (that aren't for currency amounts) get formatted as currency when they shouldn't, in Database ⇒ SQL Select.
•Fixed a rare but bad bug in emailing receipts, letters or statements: If you were using mail-merge receipts or letters, and you edited the merged documents, and they were for more than one donor, and then you chose to email them, you would be prompted for whether to save the edited changes before continuing. If you answered Yes, the documents for all donors would be included in the PDF attachment to the first donor receiving an email (a bad privacy violation!). Fortunately this had only happened to one user, to the best of our knowledge, because it's a fairly unusual combination of steps! (This could also happen with unusual merge documents even if you didn't edit the merged documents before trying to email them - that is also prevented by this fix.)
•All backup filenames now have a time component as well as a date component, such as DONATION-YYYY-MM-DD.HH.MM.SS.DB.GBK, where YYYY-MM-DD is the date the backup was made, and HH.MM.SS is the time.
•There was a weakness in the handling of bank deposits, in that you couldn't have deposits to two different banks on the same date, and when doing reports on old bank deposits with Reports ⇒ Bank Deposit ⇒ One Deposit Details, it always showed them as being done on the bank that you last did a bank deposit on. That has been fixed for bank deposits recorded after installing this version. (Reports on bank deposits made before installing this version will still all show up as being on the last-used bank before this upgrade.)
•When you start DONATION with an empty database (on a first install, or re-install on a new or rebuilt computer) the DONATION Initial Startup window now has an additional option to restore from an Internet backup, if you have one, and know your Unique ID for Internet Backups and the Backup Encryption Password you were using for such backups. (This change actually appeared in version 3.71c, but we forgot to note that fact at the time.)
•On the Reports ⇒ Donor sub-menu, the report options Mailing Labels, Mailing Labels with Member/Envelope # and Envelopes all now have a new option to print only for the currently selected donor on the main window.
•Fixed a minor bug: the paging buttons in the Reports viewing window were being disabled for Reports ⇒ Donation ⇒ Details, One Page per Donor, and Reports ⇒ Donation ⇒ Category Totals, One Page per Donor, when there really were multiple pages. Now they are enabled in that case.
•In the Help topic for Finding a Donor, clarified that accented characters cannot be found by the normal method of just typing in the Donor List. Instead you have to use the Ctrl+F Find Donor window to do that.
•Fixed a bug when doing Receipt ⇒ Duplicate/Corrected by Number, where if all of the donations included in that receipt had been deleted, so it should have been reprinted with a new amount of $0, the program could crash.
•Fixed a bug introduced in version 3.71 - if you were registering for the first time with Tools ⇒ Register Online, and you hadn't previously set up an email address with Maintenance ⇒ Email Sending Configuration, the email address field would be both empty and uneditable, and you would not be able to submit the registration because the program would ask you to enter an email address!
•Fix a bug added recently: If you are using the evaluation version, and from the Evaluation and Licensing window that comes up when you start the program, you click "Request License Key" or "Request Key for Extension of Evaluation Period", the program crashes with an error message. (Those both still worked if you went into the program with the Continue button, and called up that window from the Tools ⇒ Request or Install License Key menu option.)
•Some improvements to the messaging if you try to do a backup or restore on a drive letter that is not available (e.g. a USB memory key). Also improvements to various other bits of messaging in the program.
•Added a Copy Prev button to the One Date Batch Entry window. For donors who give the same amount each time they donate, that allows you to quickly copy in that amount (including for donations split between multiple donation categories) as the current date's donation.
•Also on the One Date Batch Entry window, changed the hotkey for Split All from Alt+T (which didn't work, because it was already the hotkey for the Totals by Category button) to Alt+P.
•Added a Database ⇒ Import ⇒ From Geminon menu option, for importing data directly from a Geminon database file. (Geminon is a Canadian church software program that went out of business several years ago and is no longer supported.)
•Added a menu option Maintenance ⇒ Change Password ⇒ Read Only Password, that allows you to set a Read Only Password. Entering DONATION with that password means you can view data and reports, and create letters etc., but not change any data, generate receipts (other than sample ones) etc.
•The top sub-report in Reports ⇒ Bank Deposit ⇒ One Deposit Details, showing the details, had somehow become too narrow, causing longer values in the Cheque # / Paid By field to be cut off. Made it the proper width again so that would not happen.
•Fixed some problems that can happen in the installation program if you are installing into a non-standard location for the program files, or re-installing to one location when a prior install went to a different location.
•Fixed a bug where if you move or resize the main window after it opens, and then do something that causes the data in the main window to be re-retrieved (like changing the working year, or restoring a backup) the window goes back to the position and size it was when it first opened.
•When you are emailing receipts, letters or statements (but only mail-merge receipts, not the regular built-in ones), or emailing newsletters, you now have the option of inserting merge fields into the Subject line and text Body of the emails, as well as in the merged document (for receipts, letters and statements) that is being attached as a PDF. That lets you personalize those emails.
•Also when you are emailing receipts, letters or statements, or emailing newsletters, you can send the Body of the email as HTML, if you are very familiar with it, by having "<html>" (without the quotes) as the very first thing in the Body, and ending it with "</html>". Of course, other appropriate changes have to be made to make it valid HTML that will display well! HTML body text can be viewed in a web browser with a new Show in Web Browser button that appears if the body starts with "<html>".
•In the mail-merge editor, the default template documents installed by the program now show thin grey dotted borders around all table cells, to help you see how the document is structured and assist in any editing you do. Those borders disappear when you print the merged document, save it to PDF, or email it - they are only visible on the screen. For existing edited documents where those borders are not shown, they can be added with a new menu option Edit ⇒ Show Table Borders on Screen.
•Fix a bug where if a mail-merge template document is over 32K in size, any merge codes after that point are ignored when you do the merge.
•For reports that prompt for something (like a date, or range of dates) added a Rerun button to the report-viewing window, that lets you respecify those prompted-for values, and redisplay the report with your new values.
•Made the report viewing window resizable.
•For Canadian (English, French only and bilingual) corrected or duplicate/replacement receipts, that create a new receipt with a new number and reprint the existing one with a $0 amount, the new receipt is now displayed first, before the reprinted replaced original. That should avoid some confusion.
•If you were correcting or replacing a receipt for Canada, and you told it not to change the receipt status, and you had changed the number of donations included in the receipt from one to more than one or vice versa, there was a bug. The bug was that it didn't change the wording "Date of donation: [date]" to "Year of donations: [year]" or vice versa as the number of included donations changed. ("Date of donation" is only supposed to be used when exactly one donation is included in the receipt.)
•In Reports ⇒ Donor ⇒ Addresses and Address by Member/Envelope Number, added the email address to the report.
•Added Reports ⇒ Donor ⇒ Contact Information, that shows the name, phone number and email address for each donor, or each donor with donations within a specified range of dates.
•Fixed a bug: The French-only built-in receipts had a number printing at the top right of the page that did not belong there.
•Fixed a bug in the Bank Deposit details report (available from the Maintenance ⇒ Create Bank Deposits window, or via Reports ⇒ Bank Deposit ⇒ One Deposit Details). The bug was that the Summary by Paid By sub-report within the report could include amounts for donations that should have been excluded, because their donation category had no configured matching accounting account.
•Fixed a subtle bug that appeared in three reports under Reports ⇒ Donor: Mailing Labels, Mailing Labels with Member/Envelope #, and Envelopes. The bug was that they had an invisible field total_amount, which could be filtered on or exported, which was always the total donations for that donor in the current year. It should have been the total donations within the selected range of dates, if you chose to only generate labels or envelopes for donors with donations within a selected range of dates. That has been corrected.
•Added a Save SQL button to the reports-viewing window, which can be used in the process of Loading and Saving SQL for Reports.
•Fixed a problem introduced by version 3.69b, where if the program tries to send an email and is unsuccessful, if it offers to show you a log with the error, that log may not be informative (because it was actually the log of the wrong action).
•Fixed an inconsistency between the program itself and the installation program about how they find the program's Data Directory - a couple of users were finding that the different methods used, which we thought always gave the same answer, did not do so.
•Improved the wording in the Evaluation and Licensing window (accessed via Tools ⇒ Request or Install License Key) when you are already licensed. If it tells you that your eligibility for support and upgrades has expired, and you need to pay to renew that, it makes it clear that this is "according to your most recently installed license key", which may or may not be correct. (You might have paid more recently, but just not requested, received and installed an updated license key yet.)
•Fixed a bug in Letters ⇒ Email Newsletters, where the program would crash after a successful set of emails, if you answered "Yes" when it reported on how many emails it sent and asked you whether to close that window now.
•In the One Date Batch Entry window, in the Category drop-down, moved "<Add New>" to be above the empty row, so if you have no default 2nd or 3rd donation categories set in the Options window for batch entry, you use Split Donor, and you try to use the down arrow on your keyboard to move to your desired category, it doesn't immediately find "<Add New>" and pop up the window for adding a donation category. (Selecting categories by their first letter is faster anyways: see Keyboard Shortcuts.)
•Added some content to the Help page on the Data Directory, to avoid possible confusions about the Data Directory itself versus its Data subdirectory, and about the "Documents" versus "Public Documents" subdirectory under C:\Users\Public in recent versions of Windows.
•Hopefully fixed a problem that occurred very occasionally (we believe on 64-bit computers) when the installation program tried to install the novaPDF PDF printer, and it would not install, giving the message "Error 1 installing novaPDF".
•Fixed a bug that only occurred on a few reports where the VCR-style paging controls could be disabled on multiple-page reports. (They are only supposed to be disabled on reports that are only one page long.)
•Enhanced an error message for a rare situation where the novaPDF printer can't write to its settings file, to explain how to resolve the problem.
•In the internal mail-merge editor, split the Insert ⇒ Page Break menu option into three sub-menu options under that: At Start of Document, At Current Cursor Position, and At End of Document. This was done because in some mail-merge documents, particularly receipts, inserting the cursor at the apparent start or end of the document and using the existing Insert ⇒ Page Break menu option didn't always work properly at all.
•Improved the messages you receive if the program tries to send an email and is unsuccessful, to be clearer and more helpful about what the problem likely is, and how to fix it. (This applies whether you are doing so from the Test button in the Maintenance ⇒ Email Sending Configuration window, or trying to actually email a letter, receipt, report or database backup.)
•Made a number of improvements to the File ⇒ One Date Donation Entry (Batch Entry) window:
oThe Options window has new drop-down lists for First split donor category and Second split donor category, that control the donation categories for rows for donors added by the Split Donor button.
oThere is a new Split All button on the actual data entry window, that brings up a prompt to select a donation category, and then adds one row for each displayed donor, with an empty Amount and the selected Category.
oThe Add Donor button now works, bringing up a window on which you can add a new donor and then continue entering the batch of donations.
oAll controls on the Options window now have accelerators (underlined letters, so you can select that control with Alt plus that letter).
•Added a note in the Help topic Non-Receiptable Donors and Donations to clarify that the codes that can make donors and donations not be included in receipts are case-sensitive, so for instance while "Non-Receiptable" works, "Non-receiptable" or "non-receiptable" would not work.
•In the Help topic Pledges in Donation, added a new sub-section on "Entry of Donations towards Pledges" to clarify that aspect.
•Added the ability to specify a range of dates to report on in Reports ⇒ Donation ⇒ Summary by Date and Category.
•Made an improvement in Reports ⇒ Donation ⇒ Summary by Dollar Ranges so that adding a Filter doesn't run the risk of breaking the report by making the dollar ranges get out of order and sometimes be duplicated.
•With the new ability to configure an alternate HTML editor, with some external editors the file format could be somewhat damaged, causing merges to not work properly, if you returned to the built-in editor after saving changes in the external editor, and then did not make any further changes in the internal editor and save them. That has been fixed.
•The program was making a check on startup that it could find a unique identifier for your computer, and giving a message to you if it could not do so. (This was going to be needed for an upcoming feature.) A few users were getting that message, so some additional code was added to find other sorts of unique identifiers if the original version wasn't working.
•The built-in and template mail-merge receipts for the U.S.A., and the built-in receipt for English Canada, were all re-arranged to make them fit better into standard #10 single-window envelopes. (The template mail-merge receipt for English Canada already seemed to be fine.)
•Added a section to the Help page on Emailing Newsletters about handling unsubscribes. Also added a sentence that mentions unsubscribing, to the default text body to be sent with the email newsletter, which you are prompted with as a suggested starting point the first time you send one.
•In the mail-merge editor, when you use the menu options Insert ⇒ Logo Image or Insert ⇒ Signature Image, if they are a multiple of the standard suggested sizes, the program now gives you an option, to choose between inserting them at their actual size, or scaling them down to that standard suggested size.
•All signatures embedded in the template mail-merge receipts and other letters installed by DONATION are now sized to the official size for the signature image, 166 x 39 pixels.
•Changed the way logo and signature images are inserted into the HTML of mail-merge letters and receipts to be more proper modern HTML, so that they would work better in some external HTML editors.
•Added a new Actions ⇒ Configure Alternate HTML Editor menu option in the internal editor for mail-merge letters and receipts, that allows you to configure another external editor to be used. Doing that configuration causes a new Actions menu option and toolbar item to appear, for editing with that editor.
•In the Help section on the Details Table in the Help page on Mail Merge Fields, added a sub-section "Changing the Font Size for the Details and Summary Tables", because obvious ways of doing that do not work, so you need detailed instructions if you need to do so.
•Fixed a small problem where some of the mail-merge template files installed with the program could come up incorrectly in certain external editors due to an incorrect character set code.