1.0.16 - 6/30/2008 FEATURE - "Packed Date" derived field which accepts a field and returns YYYYMMDD. FEATURE - "Auto ID" derived field which accepts a field and returns unique 10 character id. FIXED - Issue with "Web Users" data pump where default reg code was not imported. FIXED - Solomon IV template now limits to the "GL" module the transactions that it pulls. CHANGE - Added support for Help and Manual version 5 to TntTranslator. NOTE - 7-Zip Command line version 4.42 (stand-alone edition) is installed w/ application. 1.0.15 - 5/23/2008 FEATURE - Enhanced the Solomon IV template to enabled accounts to track advances. FEATURE - Added a German translation of the Staff Portal. FIXED - Raiser's Edge template where it included incorrect gift types. FIXED - Issue where non-scrollable queries are processed by the data pump. FIXED - Issue with adding all financial accounts to a profile on Manage Web users screen. FIXED - Sort indicator on grids on Staff Portal. FIXED - An issue where one translatable item was not working on the Staff Portal. FIXED - Enabled the GCX SSO adapter to better handle passwords with spaces in them. CHANGE - Enhanced the GCX SSO adapter to auto-lowercase the email if it's ALL CAPS. NOTE - Improved internal encoding of URLs on Staff Portal. NOTE - Enabled better debug diagnostics for error reporting. NOTE - Compiled with Delphi 2007 (Apr 2008 Hotfix). 1.0.14 - 4/25/2008 FEATURE - Added ability to display "GL Account" column on Staff Portal: Account Report. CHANGE - Added "Display 'GL Account' column ..." option to "Portal" tab of "System Setup". 1.0.13 - 4/24/2008 CHANGE - Enhanced "Reinitialize Subscription" option in "Edit Synchronization Relationship". 1.0.12 - 4/17/2008 CHANGE - Added "Translation Status" to "Multi-DB Web Application Update" tool. FIXED - Issue w/ prompting for a backup file on Vista. 1.0.11 - 4/2/2008 FIXED - Issue where tnttranslator.aspx couldn't detect and display format specifier errors. FIXED - Issue where DonorWise template failed when fiscal year is behind calendar year. CHANGE - Scan ranges are now reset when built-in data pump templates is modified. CHANGE - Improved feedback about use of "http://localhost/" as base url for web apps. 1.0.10 - 3/19/2008 CHANGE - "http://localhost/" is allowed as the base url w/o SSL for web application setup. CHANGE - Improved help map authoring mode to include handling of .aspx topic files. CHANGE - Improved help map authoring by reporting misconfigured HelpMapAuthoring.txt. CHANGE - Guyana now uses "and" for the and word. CHANGE - Jamaica now uses "and" for the and word. CHANGE - Trinidad now uses "and" for the and word. CHANGE - Suriname now uses "&" for the and word. 1.0.9 - 3/18/2008 FEATURE - Added a "Multi-DB Web Application Update" tool to upgrade multiple websites. FIXED - "Failed to set calendar date or time" when adding/editing a task on Thai Windows. FIXED - Issue where circular reference w/ derived fields produced strange error message. CHANGE - Warning when dropping user from server role if user has access to other dbs. CHANGE - Brazil now uses "e" for the and word. CHANGE - Jamaica now uses same name format as USA. 1.0.8 - 2/25/2008 FIXED - "Staff Portal" issue w/ adding a Chinese (Traditional) translation. FIXED - Window focus issue where some new windows appeared to "pop-under". FIXED - Issue with TestAuthentication SSO Provider redirecting to wrong login.aspx page. CHANGE - Added "SSO Provider" to "Setup Web Application" dialog. CHANGE - DataQueryService.asmx now implicitly trusts itself as a "trusted portal". NOTE - Added "crossdomain.xxl" file to enable Flash access to DataQueryService.asmx. 1.0.7 - 2/14/2008 FEATURE - Custom timeout settings for data pump queries. FIXED - Issue (in 1.0.5) where splash screen obscured login screen when typing password. CHANGE - Improved translatability of login.aspx in Staff Portal. NOTE - TntTranslator now supports Help & Manual XML files. NOTE - TntTranslator now supports .TntTranslator files. NOTE - TntTranslator now supports multiline editing. NOTE - TntTranslator now exports GNU gettext PO files. NOTE - TntTranslator saves an extra "AutoSave" file as an additional backup. NOTE - Refactored TntTranslator and most code related to translation. NOTE - InstallAware 7.5 used. 1.0.6 - 1/28/2008 FIXED - A display issue with the column sort indicator on the Staff Portal on Firefox. CHANGE - Made the Staff Portal more translatable. CHANGE - Added support for a logout callback with Single SignOn (SSO). NOTE - Updated year on copyright label to include 2008 in Help|About. 1.0.5 - 1/23/2008 FEATURE - Added "Last Login" label to the "Manage Web Users" screen. FEATURE - Added a "Logout" button to the Staff Portal. FIXED - Display issues with the Staff Portal on Firefox. FIXED - Login issue where NT-only authentication detection was initially skipped. CHANGE - Removed the "Items To Be Marked As Translated" filter from tnttranslator.aspx. CHANGE - The initial login screen now has a corresponding button in the Windows taskbar. NOTE - Compiled with Delphi 2007 (Dec 2007 Update). 1.0.4 - 11/16/2007 FIXED - Staff Portal now allows Account Report when no donations are present. FIXED - Issue where "System Setup" could not be displayed for more than one session. CHANGE - "Sync Relationship" settings dialog now has option to reinitialize without upload. CHANGE - On Staff Portal, renamed "Expense Report" to "Account Report". CHANGE - Improved the internal process used to normalize server names when logging in. CHANGE - Removed installation warning about Windows users w/ single quotes in name. 1.0.3 - 11/7/2007 FIXED - Import translation issue on tnttranslator.aspx (broke in 1.0.2) CHANGE - Improved general performance of Staff Portal website (client image caching). 1.0.2 - 11/7/2007 FEATURE - Added "StaffPortalUrl" property to Query.ini to be used by TntMPD 2.0 r44+. CHANGE - Improved general performance of Staff Portal website (viewstate). 1.0.1 - 11/6/2007 FIXED - Issue where Staff Portal would consider future gifts when figuring current month. FIXED - Issue where "Last Login" label would appear incorrectly on "Manage Web Users". CHANGE - Improved general performance of Staff Portal website (SQL query tuning). 1.0.0 - 11/1/2007 FEATURE - "Staff Portal" website for viewing donation, donor and income/expense info. FEATURE - Auto-registration of Web users by assigning their SSO login/email as reg code. FEATURE - Added ability to associate designations with category filter with a staff profile. FEATURE - Added "Last Login" field to better analyze web user traffic. FEATURE - SSO (GCX) Email is auto-captured when staff log in. FEATURE - Added #TEMP_ACCESS_MDB# placeholder for a temporary Access database. FEATURE - Added "Donor" web user profiles (for use in a future "Donor Portal"). FEATURE - Added "Email Password" field to Web Users for future email encryption option. FIXED - Issue where pressing cancel during a data pump left unexpected status messages. FIXED - Issue w/ setup up NTFS folder permissions for Web synchronization. CHANGE - Extended the time-out to 10 minutes for doing backups of large databases. CHANGE - Added support for filtering the TntMPD web query for donors by date changed. CHANGE - Added support for returning total balances for multiple accounts to TntMPD. CHANGE - Refactored "Staff Portal" authentication to be configurable for non-GCX orgs. CHANGE - Refactored "Staff Portal" to be based on a Web service for querying data. CHANGE - Added "Restore Default" context menus to "Manage Web Users" screen. CHANGE - Renamed "index.aspx" to "staffportal/default.aspx". CHANGE - Renamed "validateuser.aspx" to "staffportal/login.aspx". CHANGE - Refactored database inserts to improve performance and avoid duplicate ids. CHANGE - Added "Receipt Code/ID" target field for Gifts. CHANGE - Updated DonorWise template to support "Receipt Code/ID" target field for Gifts. CHANGE- Renamed"Desig.OrganizationPath" column to "Category". CHANGE- Added "Donor.Category" column. CHANGE - Added "FinancialAccount.Category" column. CHANGE - Enhanced "Delete Publication" to turn off "replicationdboption" if deleting last. CHANGE - Added "Translator" check box to "Manage Web Users" screen. CHANGE - Refactored TTntTransTable to better accomodate reuse in .NET. CHANGE - ASP.NET web application is now distributed in a 7z archive. NOTE - 7-Zip Command line version 4.42 (stand-alone edition) is installed w/ application. 0.3.10 - 8/7/2007 FIXED - Error when closing program, "An unhandled win32 exception occurred ...". FIXED - ASP.NET issue with sending non-ANSI characters. FIXED - ASP.NET error, "Deleted row information cannot be accessed through the row.". 0.3.9 - 8/6/2007 FIXED - Installation program issue where SQL Server 2005 Express SP2 wasn't installing. FIXED - Issue where derived fields might not import. FIXED - Issue where changing the base URL wasn't reflected in the "View Web Urls" dialog. CHANGE - Added the ability to manually specify the proxy server to use during replication. CHANGE - Enhanced CSV export in ASP.NET to handle space, comma and quotes. CHANGE - Installation program "ready to install sql server" screen now has correct color. CHANGE - Enhanced Excel export to be more picky about what it considers to be a date. NOTE - InstallAware 7.01 used. 0.3.8 - 5/17/2007 FEATURE - Support for scheduled automatic pumping of data and syncing to the web. FEATURE - Added "Configure Auto-Run Settings" under the "Tools" menu. FIXED - Error message: "The property 'SubscriberLogin' must be set before initializing ...". CHANGE - Refactored data pump code to improve upon performance and stability. CHANGE - Partial data pump success allowed and no longer in single database transaction. CHANGE - Allow manual mapping of country names from the "Manage Data Pumps" screen. NOTE - Delphi 2006 with Hot Fix Rollup 2 applied. 0.3.7 - 4/27/2007 FEATURE - Added support for "SAGE Comptabilité 100" (French accounting system). FEATURE - Added support for "Logefica" (French contact manager). FIXED - Issue causing importing from certain ODBC providers to not be possible. CHANGE - Failure while checking for failed login attempts will not prevent login. CHANGE - Korean and Chinese address formats now have COUNTRY on the end. NOTE - Added more detailed locale information to the system information text. NOTE - InstallAware 6.50 used. 0.3.6 - 4/11/2007 FEATURE - Added ability to subscribe to new merge replication publication. FEATURE - Added ability to auto-suggest new merge replication publication. CHANGE - Removed ability to auto-suggest new publication to republishing subscribers. CHANGE - Ensured that local user account is used when setting up Web Synchronization. CHANGE - Allow default directories for web synchronization prerequisites. 0.3.5 - 4/6/2007 FEATURE - Added ability to cross-ref unrecognized countries when importing donors. FIXED - Issue that prevented the deletion of target records with a blank code/id. FIXED - "Access violation" login error on computers without SQL Server installed locally. CHANGE - Verification of .bak files is done sooner in process of restoring to new database. CHANGE - Improved infrastructure for context-sensitive help. CHANGE - Improved the display of tool bars on XP or Vista with themes enabled. CHANGE - Installation now only warns of single quotes in the Windows user account name. NOTE - InstallAware 6.42 used. 0.3.4 - 2/28/2007 FEATURE - Added context-sensitive help (just press F1). FEATURE - Installation includes option for SQL Server 2005 Express Edition SP2. FEATURE - Installation includes option for SQL Server Management Studio Express SP2. FEATURE - Installation includes the ability to create shortcuts for just the current user. FEATURE - Local instances of SQL Server are now auto-detected when logging in. FIXED - "'.00' is not a valid date and time" error when exporting to Excel a column of zeros. FIXED - Issue on the "Manage Web Users" screen where the user tree view was editable. FIXED - Issue related to date formatting w/ embedded SQL on non-US SQL Servers. FIXED - Issue where Synchronize button was enabled after all subscriptions were dropped. FIXED - Issue where repairing a good installation might uninstall capicom.dll. FIXED - Issue where restoring a new database from a backup used old file names. FIXED - Issue a database couldn't be restored if it had replication settings. FIXED - Excel export issue where a column of months (1-12) would be expored as hours. CHANGE - Server box is better initialized when logging in to a new workstation. CHANGE - New database dialog improved for for servers that doesn't support replication. CHANGE - Installation Welcome screen hides some options behind Advanced button. CHANGE - The login prompt won't happen when starting app until first login done manually. CHANGE - Improved error message when restoring from drive SQL Server can't see. CHANGE - Installation program skips checking of requirements when uninstalling. NOTE - InstallAware 6.31 used. NOTE - Installation script has had a major rework. NOTE - Installation raises requirements of Windows Installer from 2.0 to 3.1. NOTE - Installation raises requirements of MDAC from 2.8 to 2.8 SP1. NOTE - Installation installs SQL Server 2005 Backward Compatibility Comps. (SQL-DMO) NOTE - Installation requires and provides Internet Explorer 6.0 SP1. NOTE - Installation requires and provides Microsoft .NET 2.0. NOTE - Installation raises requirements of Windows: 2000 SP4, XP SP2, 2003 SP1 or Vista. 0.3.3 - 2/7/2007 FEATURE - Added auto-trimming of trailing space characters when pumping data. FEATURE - Added ability to restore from backup when creating new database (File|New). FIXED - Solomon IV 4.x template issue where beginning balance was not read correctly. FIXED - Issue where pumping financial data would incorrectly update account descriptions. FIXED - Vista: Issue where pressing the "Alt" key would make some controls disappear. CHANGE - Corrected layering of main and other non-modal windows with other apps. CHANGE - Excel export better handles date/time values. CHANGE - Improved error message when trying to backup to a drive SQL Server can't see. NOTE - Added diagnostic to error messages related to property table update errors. NOTE - InstallAware 6.24 used. 0.3.2 - 1/31/2007 FEATURE - Added "Repair Installation" under the "Help" menu. FIXED - Removed icon flicker in Windows task bar when program starts up. FIXED - Vista-only: "Elevated permissions" error when trying to auto-upgrade. FIXED - Vista-only: Issue causing glass/aero display to auto-disable. CHANGE - Renamed "Manage Data Targets" to "Manage Data Pumps". CHANGE - Vista-only: Added security shield icon to all UI elements that invoke installation. CHANGE - Vista-only: Updated the file open/save dialogs to use the new style. NOTE - Added Vista-aware manifest to TntMPD.DataServer.exe and TntTranslator.exe. NOTE - InstallAware 6.22 used. NOTE - Authenticode signature applied to all modules. NOTE - Authenticode time stamp provider changed to Verisign. 0.3.1 - 1/16/2007 FEATURE - Added option to repair installation when starting program if files are missing. FEATURE - Added "Repair Installation" under the "Help" menu. FIXED - Issue where "Ignore Duplicates" option caused OLEDB query to import no data. FIXED - Issue where OLEDB source query options would not display correctly in designer. FIXED - Issue where login dialog displayed a blank user name for NT Authentication mode. FIXED - Window focus issue when modal dialogs are displayed and user clicks on main form. FIXED - The "Time left" display when generating snapshots after a database upgrade. CHANGE - Improved "About" box. NOTE - Refactored the splash screen. NOTE - InstallAware 6.14 used. 0.3.0 - 12/1/2006 FEATURE - Added "Custom Designation/Donor Relationships" data target. FEATURE - Added "Default Registration Code" target field to "Web Users". FEATURE - Added "Organization Path" target field to "Designations". FEATURE - Added "Derived Fields" tab to Query Designer. FEATURE - Added option to check Web for upgrade when is required to open database. FEATURE - Added "Copy (Rendered)" to context menu of SQL in Query Designer. FIXED - Issue where "Profile Code" was required in Web User/Profile/* data targets. FIXED - Corrected how the preferred language is detected from installation. CHANGE - Enhanced Query Designer to better visualize field mapping. CHANGE - Removed a language/codepage disparity warning that only occurred on Win9x. CHANGE - Modified how source query settings are saved (not backward compatible). CHANGE - Modified Raiser's Edge template to auto-truncate LAST_NAME field to 25 chars. CHANGE - Added several database indexes to improve query performance. CHANGE - Replication of source scanner configuration now uses column-level tracking. CHANGE - Improved merge publication creation by waiting for snapshot agent to complete. CHANGE - Added database version check to ASP.NET application. CHANGE - Added database upgrading check to ASP.NET application. NOTE - Added "DesigDonor" table and "DesigDonorView" view. NOTE - Added "Desig.OrganizationPath" column. NOTE - Added compiler version checks to the automated build process. NOTE - Many refactorings in installation program with no change in functionality. NOTE - Many refactorings in Query Designer with no change in functionality. NOTE - Updated Jedi JCL library to version 1.97. NOTE - InstallAware 6.0.9 used. 0.2.14 - 10/11/2006 FIXED - Raiser's Edge template now filters out non-real gifts such as pledges. FIXED - "Ticket ST-... not recognized" error when refreshing "validateuser.aspx" page. FIXED - Issue where "ASPNET" was removed from "db_datareader" and "db_datawriter". CHANGE - "SQLEXPRESS" instance name automatically suggested in login screens. CHANGE - Installation now only applies machine-level registry settings. CHANGE - Environment variables are now included in system info. 0.2.13 - 9/16/2006 FIXED - Several issues related to setting up a Web server application on Windows 2000. 0.2.12 - 9/13/2006 FEATURE - Added a screen to view Web User Registration URL and TntMPD Query URL. FIXED - Corrected display order of versions in "Setup Web Application" screen. CHANGE - Improved error messages when verifying data source validity. CHANGE - Improved descriptions of code/id target fields. CHANGE - Removed the ability to attempt replication when not using SQL Server 2005. CHANGE - Added ability to disable Web Sync buttons in Web Server Setup Console. 0.2.11 - 9/11/2006 FIXED - "EOleException: Undefined Error" when pulling up "Web Server Prereqs" screen. CHANGE - Enhanced "Base URL:" label of "Web Server Prereqs" screen. CHANGE - Error message when attempting "Web Synchronization Prereqs" on SQL Express. CHANGE - Enhanced The Raiser's Edge template in regards to donor phone numbers. NOTE - Changed a case where I was calling First on a Forward-Only cursor. 0.2.10 - 9/1/2006 FEATURE - Added support for The Raiser's Edge (tested against version 7.8). FIXED - An unnecessary prompt to sync to the Web server, even if not configured. CHANGE - DonorWise template to better handle potential donors that later become donors. CHANGE - Secure display of placeholders that have the text "password" in their name. CHANGE - Latin name formats better manage couples with the same last name. CHANGE - The default country will be used in the "Organization" tab of System Setup. CHANGE - Feedback provided while refreshing sample data in query designer. CHANGE - Feedback provided while testing query in query designer. CHANGE - Target field info can be displayed when clicking on field mapping grid. CHANGE - Improved display of table information in Table/Fields helper dialog. 0.2.9 - 8/18/2006 FIXED - Issue causing error "The ID '647673355' was not found in the Views collection". CHANGE - Made detection of NT-only authentication work only for a local server. CHANGE - Removed "File|New Synchronized Database...". CHANGE - Added a page to the new database wizard to enter synchronization data text. CHANGE - Clicking on "Search for Databases" in the login screen updates the MRU list. CHANGE - If Internet is not available, a configured modem will be prompted to dial in. 0.2.8 - 8/8/2006 CHANGE - Modified currency validation to only require 3 characters. CHANGE - Added "Synchronizing..." status display to the Synchronize screen. 0.2.7 - 7/29/2006 FEATURE - Improved template for DonorWise 1.3 and newer. FEATURE - Manage Web Users allows email addresses to be entered for web users. FEATURE - Auto-split feature uses "and" words from default and mailing from country. FEATURE - Ability to control working offline from the Internet (File|Work Offline). FEATURE - Ability to create synchronized database (File|New Synchronized Database). FEATURE - Added Web Server management tools for setting up web site applications. FEATURE - Added Web Server management tools for setting up web synchronization. FEATURE - Built-in support for synchronizing to the Web database (File|Synchronize). FIXED - Issue where managed templates were not upgrading automatically. FIXED - Issue where combo boxes were too short when using "Large Fonts" in Windows. FIXED - Issues related to the "Edit" menu (Cut/Copy/Paste) on certain controls. FIXED - Issue where invalid login attempts on SQL 2005 were reported multiple times. CHANGE - Updated installation to install SQL-DMO 2000-8.5 (used to be 2000-8.0). CHANGE - Modified installation to install CapiCom 2.1 when installing application. CHANGE - Improved management of popup windows and modal dialogs. CHANGE - Improved handling and error reporting of internet connection issues. CHANGE - Manage Web Users better handles allowing of non-scanned data to be edited. CHANGE - Improved translatability. CHANGE - Improved application startup performance. CHANGE - Improved startup of "Manage Users" screen. CHANGE - Initial support added for Windows Integerated authentication. CHANGE - Enhanced error message when anti-virus blocks program from automating Excel. NOTE - Changed wininet.dll back to static linking. NOTE - Fixed a minor issue with multi-line Unicode hints. NOTE - Internal refactoring of some code libraries and the release builder tool. NOTE - Began using NTSet 1.15b components for Delphi 2006. NOTE - Changed LXAdoDataSet to use FieldNo instead of FieldName for getting metadata. NOTE - Internally refactored module management system and much internal coding. NOTE - InstallAware 6.0 used. 0.2.6 - 6/8/2006 FEATURE - Added query attribute "Results may be subset" to supress deletion errors. FIXED - Auto-documentation feature to correctly handle hidden fields. CHANGE - Improved OPTIGEM template by adding a scancode/date to donors. CHANGE - Improved "Manage Data Targets" screen by auto-sizing the columns. 0.2.5 - 6/8/2006 FIXED - Small memory leak related to using threads. CHANGE - Improved OPTIGEM template. CHANGE - Updated country formatting information. 0.2.4 - 5/10/2006 CHANGE - Updated "and" word for Germany, Switzerland and Austria to be "und". CHANGE - Added test in installation program for quotes in username. NOTE - Compiled with Delphi 2006 Update 2, InstallAware 5.31. 0.2.3 - 4/18/2006 FEATURE - Added Min/Max Scan Range as templateable properties. FEATURE - Added #MIN_SCAN_RANGE_PLUS_ONE_YEAR# built-in placeholder. FEATURE - Added "Ignore Duplicates" to the SQL Query Designer. FEATURE - Automatic filling of Donor.FullName if left blank. FEATURE - Installation option added to generate and display an installation log. FIXED - Issues related to using a non-English SQL Server. CHANGE - Removed "Just Me" installation option. CHANGE - ISO 3166 Country numbers are now also recognized as a country code. CHANGE - Added more feedback while synchronizing. CHANGE - The Data Source placeholder tab will show by default if placeholders exist. NOTE - Some performance improvements. 0.2.2 - 4/12/2006 FEATURE - Added FirstName_AutoSplit for importing donors from systems with one field. FEATURE - Added Mininum Scan Code Range to prevent rescanning archived data. NOTE - Compiled with Delphi 2006 Update 1, InstallAware 5.31. 0.2.1 - 4/10/2006 FEATURE: Added a way to perform backups (under Tools menu). FEATURE: Added a way to extract documentation automatically for data targets. CHANGE: Improved support for merge replication fields. CHANGE: Dropped WebUser.Description. Added EmailPassword and ExtendedProps. CHANGE: Added options tab for defining organization info for the Web. CHANGE: Improved "Edit Placeholder" dialog. 0.2.0 - 3/24/2006 NOTE: Major implemenation complete for all modules. 0.1.1 - 1/17/2006 FEATURE: Added Contact Module for built-in country information. FEATURE: Added Data Pump Module. FEATURE: Added Donation Module. FEATURE: Added Financial Module. FEATURE: Added Web Admin Module. 0.1.0 - 11/25/2005 FEATURE: Security Module FEATURE: Translation Tool FEATURE: Windows Installer compatible installation program.