1.0.43 - 3/4/2010 FEATURE - When exporting to Excel, a Pie chart and Bar chart are added as extra worksheets. FIXED - "Invalid object name 'Property'" issue that might occur while a database is upgrading. FIXED - Issue where setting proxy override of blank didn't override IE's proxy with no proxy. CHANGE - Modified TntTranslator to treat a blank TranType as generic text, not "resourcestring". NOTE - Began refactoring code in preparation for Delphi 2007/2010 cross compilation. 1.0.42 - 2/11/2010 FEATURE - Enable increment operaions on placeholder. $P$ enables $P-1$ and $P+1$. FIXED - Improved compatibility with SQL Server 2008 when creating "tntware-common". FIXED - Improved compatibility with Windows 7 when setting up web application. CHANGE - Improved OPTIGEM template by providing balance adjustments at beginning of year. CHANGE - Improved import of .po files by making context = "RESOURCESTRING". 1.0.41 - 2/10/2010 FEATURE - DonorWise 2.0 template to support ministry path for designation category. FEATURE - Added financial information to the Optigem template. FIXED - Issues causing Web Server Setup Console to not work on Windows 7 or 2008 R2. FIXED - "query uses non-ANSI outer join operators ("*=" or "=*")." issue when logging in. FIXED - Staff Portal: Issue with logging in when ServiceName is more than 256 characters. FIXED - Query designer issue where a field might be mapped to twice. CHANGE - Added "Copy (Ctrl+C)" and "Select All (Ctrl+A)" to the error message prompt. CHANGE - .TntTranslator files are opened from temp directory instead of IE cache dir. CHANGE - TntTranslator: "Tools | Convert PO File to TntTranslator File" menu added. CHANGE - TntTranslator: Improved export of .po files. CHANGE - The Opgitem template now rescans all gifts within the current year. NOTE - EXEs are now signed w/ signtool.exe from Windows 7 SDK. NOTE - SQL Server 2005 or newer is now checked when logging in. 1.0.40 - 1/6/2010 FIXED - Optigem template now imports new donors who have never been changed. CHANGE - Optigem template now uses optigemxp.mdw instead of optigem.mdw. 1.0.39 - 1/4/2010 FIXED - Issue when creating a new database: Incorrect syntax near 'CONSTRAINT'. NOTE - Updated year on copyright label to include 2010 in Help|About. 1.0.38 - 12/18/2009 FEATURE - Staff Portal now provides XLS and CSV(;) export options. FIXED - Issue where a web browser issue prevented a user from logging in to database. FIXED - Issue where a custom translation of the Staff Portal couldn't be deleted. CHANGE - Better error message when opening or creating a database with "." in name. CHANGE - Updated German translation of Staff Portal. CHANGE - Updated Spanish formatting of full name and address. CHANGE - Updated Ecuador formatting of full name. CHANGE - Enhanced error message/handling of translatable lists when opening database. CHANGE - TntTranslator supports "_prefix" or "_suffix" on special Help and Manual items. CHANGE - Enhanced the subject used in error reporting emails. NOTE - Online translation uses CRC for change tracking for better future consistency. 1.0.37 - 11/21/2009 FIXED - "File does not exist" error when auto-updating program. FIXED - Installation program wasn't checking prereqs in Repair mode. FIXED - Installation program sometimes didn't clean up a temp directory. FIXED - Installation program would sometimes set the IE timeout to 10 seconds. 1.0.36 - 11/12/2009 FIXED - "[Url] was an empty string" error when auto-updating program. CHANGE - Internal improvement to community integration. NOTE - Slightly modified two labels in the setup program. 1.0.35 - 11/2/2009 FEATURE - Added Community integration pane with tntware.com. FEATURE - Error reporting for registered users is now direct to forum (no email required). FEATURE - Windows authentication is now an option when logging in to database. FEATURE - Installation program provides options for online/offline preferences. FEATURE - Installation program downloads offline help files upon demand. FEATURE - Installation program supports translation into other languages. FIXED - Error message when clicking on "Search for Databases" when logging in. FIXED - Issue where partial seconds were not supported in time based scan codes. FIXED - "General Network Error" when first creating user after installing SQL Express. CHANGE - Web Users w/ access to "(All Accounts)" desigs can now see all donors as well. CHANGE - Updated Albanian translation of the Staff Portal. CHANGE - Updated Spanish translation of the Staff Portal. CHANGE - Login and New Database screens more effectively set focus when displayed. CHANGE - Installation program improved to fully support x64 versions of Windows. CHANGE - Installation supports SQL Server 2005 SP3 install of Express Edition. CHANGE - Installation supports SQL Server 2005 SP3 install of Mgmt Studio Express. CHANGE - Installation requires Windows XP SP3 on XP when installing SQL Server Express. CHANGE - Installation program now supports SQL Server 2005 SP3 install of SQL-DMO. CHANGE - TntTranslator auto saves a .Translation.CSV when saving a .TntTranslator file. CHANGE - TntTranslator now supports translating InstallAware resources. CHANGE - When automated data pump sends email, it's reduced in size if no errors occur. CHANGE - Enhanced error message when setting up web app and IIS not installed. CHANGE - Enhanced error message when setting up web app and ASP.NET not registered. NOTE - InstallAware 9.0.6 used. NOTE - Installation program now requires MSXML 6.0 as a prerequisite. NOTE - Cleaned up names of neutral languages used in setup. NOTE - Refactored automated release scripts. NOTE - Refactored the installation program. 1.0.34 - 9/22/2009 FIXED - Issue with /autorun where the system locked up on the initial login. CHANGE - Web application doesn't log a web user's login any more than every 5 minutes. CHANGE - Web application doesn't log encountered portal urls more than every 5 minutes. NOTE - Refactored CRC32 code to work with TStream. NOTE - Hold Ctrl key to see "Decode Instruction Pointer" on System Info dialog. 1.0.33 - 9/10/2009 FEATURE - Added option to save log only on error for unattended data pumps. FEATURE - Added option to email log only on error for unattended data pumps. FIXED - Issue w/ "Configure Auto-Run Settings" dialog on Vista as non-admin. FIXED - Issue where setting up web sync didn't complete, yet no error was reported. FIXED - Issue where SQL Server Mgmt Studio 2008 wasn't detected during install. CHANGE - Enhanced feedback when pressing "OK" to create a new database CHANGE - Export to Excel enhanced to better handle "OLE error 800A03EC" error. CHANGE - When creating new database, "syncinfo.aspx" is checked for new settings. CHANGE - Updated German translation of the Staff Portal. 1.0.32 - 9/3/2009 CHANGE - Setup web sync generates "syncinfo.aspx" to assist clients w/ migrating server. CHANGE - When syncing to web w/ error, "syncinfo.aspx" is checked for new settings. CHANGE - When syncing to web w/ error, option is provided to adjust sync settings. 1.0.31 - 8/30/2009 FIXED - Issue (introduced in 1.0.27) where the Staff Portal wouldn't run on a x64 server. FIXED - "Cannot delete file" error when upgrading web application. FIXED - "Range check error" when reporting error details. CHANGE - TntMPD.DataServer.Run.exe now logs error messages to Windows Event Log. CHANGE - Web app setup only creates one application pool per database. CHANGE - Web app setup assigns "dataserver" virtual directory to default application pool. CHANGE - Web app doesn't need SSL for base url path beginning with "http://localhost:". CHANGE - Web sync setup assigns "websync" virtual directory to default application pool. NOTE - Improvement of error message for TntShFileOp() internal function. 1.0.30 - 7/17/2009 FIXED - Issue w/ Solomon template introduced in 1.0.29. FIXED - TntTranslator H&M error "...tran ids are no longer translated...". CHANGE - TntTranslator error "...tran ids are no longer translated..." treated as warning. NOTE - TntTranslator H&M changed to use CRC32 for internal ids. 1.0.29 - 7/16/2009 FEATURE - Added System Setup option to add donation "Memo" field to the Staff Portal. FIXED - Export to Excel corrected to avoid "Old format or invalid type library." error. CHANGE - Solomon template enhanced so that financial accounts are used as categories. CHANGE - Address format for Portugal reversed city and postal code. CHANGE - Enhanced error when restoring a backup from a newer version of SQL Server. NOTE - Updated copyright on about box to include 2009. NOTE - Refactored code that handles http requests. NOTE - Refactored code that handles multithreading. NOTE - Improved graphics used in installation program. NOTE - InstallAware 9.0.4 used. 1.0.28 - 5/5/2009 FEATURE - Added an Albanian translation of the Staff Portal. FIXED - Provided a way to get past "This scanner is already associated with..." error. CHANGE - When restoring from newer version of SQL Server, error message is enhanced. CHANGE - Updated Spanish translation of the Staff Portal. NOTE - Export to Excel enhanced to exclude hidden fields. NOTE - Modified internal linked tables to delay auto-refresh until out of edit mode. 1.0.27 - 3/18/2009 FIXED: Staff Portal error "There is no gift information in the database" with only one gift. FIXED - Issue with error dialog where a period was sometimes added when not necessary. FIXED - "Truncation Error" issue w/ Raiser's Edge template on some country codes. FIXED - TntTranslator: Help and Manual, issues with using uncompressed .hmxp format. FIXED - TntTranslator: Help and Manual, issue with opening a translation "new tranid...". CHANGED: Staff Portal improves calendar interface in "Change Date and Other Options". CHANGE: Help | Online User Guide: http://www.tntware.com/tntmpd.dataserver/help/ CHANGE - TntTranslator: Help and Manual, "Press the button." supported. CHANGE - TntTranslator: Ctrl-click on "Import Translation from CSV File" to retranslate. CHANGE - TntTranslator: auto-translates items with same English when first is translated. CHANGE - TntTranslator: Improved importing of items ending with "...". CHANGE - TntTranslator: Help and Manual, "Exercises:", "Exercise:", "Tutorial:" supported. CHANGE - TntTranslator: H&M, "Reference Guide:", "Tip:", "Note:" supported. CHANGE - TntTranslator: H&M, "Example:", "Checkbox:" supported. CHANGE - TntTranslator: H&M, "X Tab", "X Screen", "X View", "X Dialog" supported. CHANGE - TntTranslator: fixed issue English didn't show as the reference language. CHANGE - TntTranslator: Help and Manual, "Menu Path:" and "Read More >" supported. CHANGE - TntTranslator: Help and Manual, topic titles and keywords only appear once. CHANGE - TntTranslator: Help and Manual, removed unnecessary items for translation. CHANGE - TntTranslator: Importing dictionary can now handle "Menu Path" items natively. CHANGE - Staff Portal: tnttranslator.aspx adds "Go" button next to custom filter text box. NOTE - Enhanced internal release tool. NOTE - Internal release process modified to regenerate the help file (CHM) on demand. 1.0.26 - 2/19/2009 FEATURE - DonorWise template adds placeholder: $ANONYMOUS_MOTIVATION_CODE$. FIXED - Staff Portal: tnttranslator.aspx issue: translation csv couldn't be downloaded. FIXED - Staff Portal: tnttranslator.aspx issue where new languages could not be added. 1.0.25 - 2/17/2009 CHANGE - Staff Portal: tnttranslator.aspx now had "Sort by English" checkbox. CHANGE - Staff Portal: tnttranslator.aspx now has a custom filter text box. CHANGE - Staff Portal: tnttranslator.aspx now has the ability to "Work Offline". CHANGE - Staff Portal: tnttranslator.aspx has improved performance. CHANGE - Staff Portal: tnttranslator.aspx corrects map w/ .NET and Win32 culture codes. CHANGE - Staff Portal: tnttranslator.aspx better handles incompatible format strings. CHANGE - Staff Portal: tnttranslator.aspx header area updated with new layout. CHANGE - TntTranslator added "Tools | Export Languages to CSV File" menu item. CHANGE - TntTranslator "Save to Web" improved to be compatible with tntware.com CHANGE - TntTranslator improved performance for building and importing dictionaries. CHANGE - TntTranslator is registered with Windows to open .TntTranslator files. CHANGE - TntTranslator prompts to save pending changes before exporting translation. CHANGE - TntTranslator now has "Save to Web" for special .TntTranslator files. CHANGE - TntTranslator refactored to support additional translation type validations. CHANGE - TntTranslator now supports validation for additional translation types. CHANGE - TntTranslator now has menu items for import/export to/from TntTranslator files. CHANGE - TntTranslator now has menu item to export to .Properties file. CHANGE - TntTranslator reorganized the import/export options under File menu. CHANGE - TntTranslator has new icon. NOTE - TntTranslator removes Spanish language "ESP" which is ambiguous w/ "ES" in .NET. NOTE - TntTranslator refactored so that TShortCutTranType no longer uses Menus.pas. 1.0.24 - 1/29/2009 FIXED - Installation issue, "unable to copy installation data to local folders". CHANGE - Renamed "SAGE Comptabilité 100" template file to ascii avoid installation issues. CHANGE - Optimized performance of data pumps. CHANGE - Enhanced status bar to keep displaying updates during long running operations. CHANGE - Staff Portal: tnttranslator.aspx enhanced to work better with multiple users. CHANGE - Staff Portal: tnttranslator.aspx enhanced to work better browser navigation. CHANGE - Staff Portal: tnttranslator.aspx now has separate links for import and download. CHANGE - Staff Portal: no longer uses "SmartNavigation" for IE users. CHANGE - TntTranslator: Removed ability to change reference language. NOTE - TntTranslator: Improved overall performance. NOTE - TntTranslator: Uses "Context" field in place of "DictTranID" in csv translation files. NOTE - TntTranslator: Refactored internal code structure. NOTE - Improved performance of some list view controls. NOTE - Staff Portal: tnttranslator.aspx refactored to improve internal code structure. 1.0.23 - 1/13/2009 FIXED - Staff Portal: Issue with importing CSV translations (introduced in r22). CHANGE - Staff Portal: Removed 777 unnecessary items from translation system. 1.0.22 - 1/9/2009 FEATURE - Added a Spanish translation of the Staff Portal. FIXED - Issue on "Manage Web Users" screen with renaming existing profiles. FIXED - Staff Portal issue with detection of built-in languages. CHANGE - Updated name/address format for Belize. CHANGE - Removed many unnecessary system error messages from translation system. CHANGE - TntTranslator now separates programmer comments from translator comments. CHANGE - TntTranslator can now export XRS files. CHANGE - CSV export is now as UTF-8 to better support international characters. CHANGE - TntTranslator improved "Export Translation As CSV Text" dialog and process. CHANGE - TntTranslator auto-detects new languages when selecting from language list. CHANGE - TntTranslator improved its detection of form resources. CHANGE - .TntTranslation now saved as .Translation.csv for .TntTranslation masters. CHANGE - TntTranslator has additional filter options. CHANGE - Staff Portal translation screen refactored to allow more generic use. NOTE - Improved TntTranslator and StaffPortal tnttranslator.aspx load time. NOTE - Refactored CSV parsing to support UTF-8 files. NOTE - Refactored quoted text extraction. NOTE - Corrected the name of "Chinese (Traditional, Taiwan)" to "Chinese (Traditional)". NOTE - Fixed internal memory leak based on reading ADO connection string. NOTE - Refactored some Trx and Lx code to improve .NET compatibility. NOTE - Removed TntWindows Tnt_ functions for MSLU-like functionality no longer needed. NOTE - Updated icon for setup program. NOTE - SignTool.exe now used instead of SignCode.exe for Authenticode. 1.0.21 - 11/12/2008 FIXED - Error when importing to Excel if sheet title was more than 31 characters. FIXED - Export to Excel uses explicit locale identifiers to avoid "OLE error 800A03EC" error. FIXED - Issue where some dialogs might appear to pop-under the main window. FIXED - Staff Portal: Issue where TntMPD data sync file had incorrect decimal point. FIXED - "Scheduled Tasks" button in the "Configure Auto-Run Settings" dialog on Vista. CHANGE - Improved the "Truncation Error..." message by providing more detail. CHANGE - Added Serbia and made several minor updates to the internal country database. CHANGE - TntTranslator: Help & Manual translation now removes unneeded text divisions. NOTE - Staff Portal: Refactored code for redirecting to SSO login. NOTE - Removed all TAnimate controls as they are deprecated in Vista. NOTE - Refactored TntFormatStrUtils to not use pointers so it's .NET compatible. NOTE - Put in checks for EmptyParam validity. 1.0.20 - 10/11/2008 CHANGE - Excel export now names the worksheet appropriately. CHANGE - Help | Online Support Center: http://www.tntware.com/tntmpd.dataserver/ CHANGE - Staff Portal now displays monetary values with a thousands separator. 1.0.19 - 9/5/2008 FIXED - Web Server Setup Console now provides error message if not running as Admin. FIXED - "Multi-DB Web Application Updater" tool now gives error message if not Admin. FIXED - "Multi-DB Web Application Updater" incorrectly detected and queried empty dbs. CHANGE - "Multi-DB Web Application Updater" will prompt to run as Admin on Vista. CHANGE - Solomon IV template now enforces transaction dates are consistent with period. CHANGE - Improved error on tnttranslator.aspx when upload/import on undefined file. CHANGE - 7zips path: http://download.tntware.com/tntmpd.dataserver/redist/. CHANGE - 7zips path: http://download.tntware.com/tntmpd.dataserver/redist/legacy/. NOTE - "Multi-DB Web Application Updater" now includes a Vista-compatible manifest. 1.0.18 - 8/25/2008 FEATURE - Added and tested compatibility with SQL Server 2008. FIXED - Translation issue introduced in 1.0.17 w/ TntJclUtils refactoring. 1.0.17 - 8/22/2008 FEATURE - Enhanced support for running on 64-bit Windows and using 64-bit SQL Server. FEATURE - IIS 7.0 web server is now supported and tested on Windows Vista. CHANGE - Improved installation to handle installing SQL-DMO on Windows x64. CHANGE - Local x64 instances of SQL Server are not detected and listed when logging in. CHANGE - Added 5 sec pause when setting up distribution db is SQL Agent is starting. CHANGE - Web Synchronization setup requires that the URL start with "https://". CHANGE - DonorWise template now uses "Memo (internal)" instead of "Memo (for receipt)". CHANGE - Solomon template no longer limits transactions that are from the "GL" module. CHANGE - Solomon template now uses Module instead of Year for financial transaction ids. CHANGE - TntTranslator can now translate Java .properties files. FIXED - Staff Portal issue where total donations on home page might omit 1st of month. FIXED - Issues with setting ups Web Synchronization against SQL Server x64. FIXED - Issue with NT-only authentication detection of local x64 instances of SQL Server. FIXED - Issue on "Web Server Prereqs" screen where SSL was required for "localhost". NOTE - Updated logo and icon. NOTE - Refactored TntJclUtils. NOTE - Updated Jedi JCL library to version 1.102. NOTE - InstallAware 8.0 used. 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 Updater" 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.