1.0.70 - 10/24/2011 FIXED - TntTranslator issue where Find/Replace might cause last change to not be saved. CHANGE - Staff Portal: changed GCX/Key login url to use "https://thekey.me/cas". CHANGE - Solomon IV template modified to show advances as negative. CHANGE - GL Period is tracked after Financial Transactions data pump occurs. NOTE - Mac: Adapted Wine version reporting for CrossOver 10.1. NOTE - Mac/WINE: Refactored http/https DDE fix for shell execute. NOTE - Mac: Adapted for both Wineskin and WineBottler containers. NOTE - Mac: Added WinePrefix/packaging to reported system info. 1.0.69 - 9/7/2011 FIXED - Mac: "sharing violoation" when 2 errors occur within same second by writing to same log file. CHANGE - Must be a member of "Security Admin" to make changes to Data Sources and Data Pumps. CHANGE - Improved internal database field binding and metadata retrieval. CHANGE - Improved performance and reliability of inserting records to database. CHANGE - Mac: Added "Run Network Diagnostics" to "Connection Not Available". CHANGE - Improved layout of "Connection to Internet Not Available" dialog. CHANGE - Better detection of internet connection via dns test. CHANGE - Improved error report whan a directory can not be created. CHANGE - TestAuthenticationService.asmx checks for valid service ticket of "test_ticket". CHANGE - Mac: Added "Run Network Diagnostics" to "Connection Not Available". CHANGE - Updated English help manual. 1.0.68 - 8/26/2011 FIXED - Staff Portal: couldn't login if GetLogoutServiceTicketPrefix() returned empty string. FIXED - Managed Web Users: couldn't add a wildcard donor account without Assert error. FIXED - FK_Gift_PaymentMethod constraint errors when pumping Gifts. FIXED - FK_Gift_MotivationCode constraint errors when pumping Gifts. FIXED - Mac: Issue with using basic authentication over OpenSSL (by default only used over a proxy). CHANGE - Staff Portal: web.config allows GET/POST to GCX and Test Authentication web services. CHANGE - Staff Portal: DataQueryService.asmx has better comments on apis requiring trusted user. CHANGE - Holding down Shift key when pulling up Network Settings reveals TLS/SSL tab on Windows. CHANGE - Improved floating tool windows to preserve position on additional monitor. CHANGE - Improved layout of "Connection to Internet Not Available" dialog. CHANGE - Added "Run Network Diagnostics" to "Connection Not Available" for XP and Windows 7. 1.0.67 - 8/12/2011 FIXED - Removed prompt about Internet not being connected for background web requests. FIXED - Excel export issue where dates would appear formatted incorrectly in some locales. FIXED - Excel export issue causing "Field not found" in some locales. FIXED - Internal issue of overwriting freed memory w/ SOAP bug. FIXED - Mac: Removed "The .exe file is invalid" when opening some urls. CHANGE - Mac: Added "OpenSSL" tab to "Network Settings" dialog. CHANGE - Mac: Improved OpenSSL alternative to handle servers that respond w/ SSL3 only. CHANGE - German greetings are formal when the first name is not known. CHANGE - Slightly enhanced exception handing in TntMPD.DataServer.Run.exe. CHANGE - Staff Portal: web.config allows GET/POST to some web services. CHANGE - System Setup (TntMPD tab) option to disallow passive authentication for TntMPD clients. 1.0.66 - 5/18/2011 FIXED - Issue (intro in 1.0.63) causing "CheckCancel is not enabled" when pumping data. CHANGE - Added IsFCX to the GetSiteProperties() method of DataQueryService.asmx. CHANGE - Added Web User counts to the GetSiteProperties() method of DataQueryService.asmx. 1.0.65 - 5/10/2011 FIXED - Access Violation error when performing certain automatic table updates. FIXED - Mac: Issue where File|Open or File|New failed on Tiger or if too much time was taken. FIXED - Memory leak (intro in Delph XE) with each call made to a SOAP Web Service. FIXED - Issue where some list views might reset column sizes in certain conditions. 1.0.64 - 5/6/2011 FIXED - Issue with certain popup forms. 1.0.63 - 5/6/2011 CHANGE - Improved responsiveness while exporting to Excel. NOTE - Refactored: Threading, FlashMsg, feedback of progress. 1.0.62 - 4/29/2011 FIXED - "Access Denied" error when installing into a multi-user environment. FIXED - Issue causing the CPU usage to spike while waiting for a background thread. FIXED - Issue where a web request would sometimes not respond instead of responding with an error. FIXED - Issue where detection for existence of a network directory was incorrect. FIXED - Staff Portal: corrected error message when web user doesn't have any associated profiles. FIXED - Security issue where a non-securityadmin user could add/remove self/others from the role. FIXED - Issue where incorrect translation would sometimes be used. FIXED - Mac: Command-Click when adding to the current selection doesn't initiate menu mode. CHANGE - Added "Check All" and "Uncheck All" to the Export Current Group dialog. CHANGE - Slightly improved feedback of Excel export by indicating when a chart is being generated. CHANGE - Mac: A native Mac dialog is used to display error messages when X11 is broken. CHANGE - When an error message can not be displayed, a text file will be saved to the desktop. CHANGE - Export to Excel: improved performace, feedback and when to include charts. NOTE - Refactored: CheckListBox, RichEdit, SoapClient, WineFriendlyThemeServices. NOTE - Refactored: TntIntegerList, integer arrays, threading waits, WriteLn. NOTE - Refactored: DateTimePicker, string arrays, StringReplace, AdjustLineBreaks, TntMenus. NOTE - Refactored: CurrToStr, StrToCurr, FileGetAttr, FileSetAttr, FlashMsg. NOTE - Refactored: SQL Server Reconnect dialog. 1.0.61 - 4/12/2011 FIXED - Issue (intro in 1.0.59) when logging in, "Common connection is not available for NT-only". FIXED - "Multi-DB Web Application Updater" failed to setup new sync publications from scratch. CHANGE - Improved Albanian translation of Staff Portal. CHANGE - Synchronize dialog: Improved error message when detecting new settings. CHANGE - Synchronize dialog: improved handling of Cancel button. CHANGE - Synchronize dialog: improved message to reinit sync when new settings not detected. CHANGE - Edit Sync Relationship dialog: changed button caption "Set Defaults" to "Apply Defaults". NOTE - Improved error handling of delayed dll loading issues. 1.0.60 - 4/8/2011 FIXED - "No global message handlers to end" when applying an update. FIXED - Issue where "Multi-DB Web Application Updater" tool provided wrong subscription data text. CHANGE - Improved reporting of errors when auto-detecting new sync settings. CHANGE - Improved internal handling of disconnection from Citrix desktop in screen list paint code. 1.0.59 - 4/8/2011 FIXED - "Setup Web Synchronization" sets 32/64bit mode in IIS to avoid "Internal Server Error (500)". FIXED - Issue where disconnection from Citrix desktop caused Access Violation on screen paint code. FIXED - Issue where "Last Login" wasn't being set on login. CHANGE - Reduced some unnecessary background queries to improve performance. 1.0.58 - 4/7/2011 FIXED - Performance issue w/ logging in where DonorWise was checking for failed login attempts. FIXED - Issue with logging in to remote SQL Server where windows user wasn't what was expected. FIXED - Integer overflow issue when waiting for Snapshot agent to finish. FIXED - Security issue where a replication user could acquire sync info for another publication. CHANGE - "Multi-DB Web Application Updater" allows existing sync publications to be updated. CHANGE - Manage User screen changed display of "Failed Login Attempts" to "Last Login". 1.0.57 - 3/25/2011 FEATURE - "Multi-DB Web Application Updater" tool provides status of Web Sync setup. FEATURE - "Multi-DB Web Application Updater" tool provides right-click menus for Web Sync setup. CHANGE - Wine: Improved detection and install of MSXML6. This enables CrossOver 10.0 support. NOTE - Language override registry key changed from Borland to Embarcadero. NOTE - Removed some SOAP client patches resolved by Delphi XE. NOTE - Refactored: TntWindows LCID functions, TntSysUtils IsChar*() functions, NOTE - Refactored: TTntStringList.LastFileCharSet, FlashMsg, threading waits. NOTE - Refactored: MonthCalendar, DateTimePicker. 1.0.56 - 3/21/2011 FIXED - Data pumps were not installed w/ new templated data source unless a placeholder changed. CHANGE - Added 'URL to ping after a data pump:' setting to Portal tab of System Setup. CHANGE - Added SsoCode to the GetWebUserInfo() method of DataQueryService.asmx. CHANGE - Added NumberOfGifts to the GetSiteProperties() method of DataQueryService.asmx. 1.0.55 - 3/18/2011 FIXED - Issue where certain grid columns were too narrow when Windows themes were enabled. FIXED - "Integer Overflow" when starting program (in TTntFxDbPropLink.GetStrProp). CHANGE - Manage Web Users, renamed 'Translator' label to 'Trusted User (Translator, ...)'. CHANGE - Added GetWebUserInfo() method to DataQueryService.asmx (must be Trusted User). CHANGE - The installation program tries to preserve the position of the desktop shortcut. NOTE - Help & Manual 5.5.1 used. NOTE - Updated JCL to 2.2.1. NOTE - Compiled with Delphi XE Update 1. 1.0.54 - 2/23/2011 FIXED - Staff Portal error, "Access to the path 'C:\Windows\Local Application Data' is denied." 1.0.53 - 2/18/2011 FIXED - Staff Portal home page issue where a region had fixed height on Firefox. FIXED - Issue (intro in 2.1.47) where a check for beta updates checked for normal updates. FIXED - Mac: Issue where File|Open or File|New failed if X11 wasn't installed. FIXED - Installation issue, "Access Error", when running under a limited account. FIXED - TntTranslator: issue where sorting sometime was random and was causing errors on save. FIXED - TntTranslator: issue with (File|New) overwriting same .TntTranslator as what you're on. FIXED - Mac: User's home directory is now retrieved from the operating system. CHANGE - If OLE error occurs when exporting to Excel, an alternate export method is used. CHANGE - TntTranslator: added option to turn off Auto Translate of similar items. CHANGE - TntTranslator: added ability to "Find Previous/Next Translated Item". CHANGE - WINE/Mac: Option to "Create Desktop Shortcut" is hidden/removed from installation. NOTE - Refactored internal checks for "Wine Tricks". NOTE - Refactored installation to improve reusability of dialogs between projects. 1.0.52 - 2/3/2011 FEATURE - Added ability to specify multiple email addresses to receive message after auto-run. FIXED - Issue (intro in 1.0.44) where you can't right-click in query editor to insert a placeholder. FIXED - Issue (intro in 1.0.44) where you can't right-click on a password editor to "Show Password". CHANGE - Enhanced appearance of "Check for Updates" dialog. 1.0.51 - 1/18/2011 FIXED - Time parsing issue for lookups on date fields. CHANGE - Improved error message when some SQL commands fail. CHANGE - Improved German Full Name to treat "Eheleute" same as "Familie". CHANGE - TntTranslator has a new translation mode called "Pure XML". NOTE - Staff Portal: refactored some reading of settings in web.config. NOTE - Staff Portal: refactored tnttranslator.aspx and TntTrxWebContext.pas. NOTE - InstallAware 10.1 used. NOTE - Help & Manual 5.5.0 used. NOTE - Copyright now includes 2011. 1.0.50 - 11/30/2010 FIXED - Issue (intro in 1.0.49) where MS tables would cause empty database to not be recognized. CHANGE - TntTranslator: Improved translation of xml files with line breaks in text. CHANGE - Staff Portal: removed option to translate "StaffPortal.EN.TntTranslator" file. 1.0.49 - 11/23/2010 CHANGE - Improved performance of searching for databases from the login prompt. CHANGE - Staff Portal: added option to translate "StaffPortal.EN.TntTranslator" file. CHANGE - Staff Portal no longer converts CR/LF to #13/#10 in translated text. NOTE - Refactored some SQL Server handling code to assume SQL 2005 or newer. 1.0.48 - 10/27/2010 FEATURE - Under the "Help" menu, you can now "Check for BETA Updates". FIXED - Issue where searching for databases from login screen failed on offline databases. FIXED - Issue where searching for databases from login screen incorrectly handled errors. FIXED - Formatting of time values for SQL when hour was 12 AM or 12 PM. FIXED - Resolved a memory leak for exceptions that are raised twice. FIXED - Mac/WINE: Basic authentication over SSL+proxy. FIXED - Mac issue where a file could not be selected on Leopard (10.5). FIXED - Many issues with High Contrast mode for Accessibility. FIXED - Issue where grids sometimes displayed selected item with double thickness on Windows 7. CHANGE - Under the "Help" menu, "Check for Updates on the Web" changed to "Check for Updates". CHANGE - Enhanced error message when a file cannot be deleted. CHANGE - Improved error messages for internet connection issues. CHANGE - When exporting to Excel, an XLS/XLT file is generated instead of a CSV file. CHANGE - When exporting to Excel, a notification window is now displayed. CHANGE - Improved handling of currency fields with generic export grid. CHANGE - Improved error details for exceptions that are raised twice. CHANGE - Removed the link to Chat from the Community pane. CHANGE - Url parsing removes leading and trailing spaces. CHANGE - Staff Portal, modified a query to better handle no Payment Method or Motivation. CHANGE - Removed the "I agree" check box to the installation license agreement. CHANGE - TntTranslator: Ctrl-click on "Import Translation from GNU gettext PO File" to retranslate. CHANGE - Mac: Control-Click now simulates a right-click to pull up a context menu. CHANGE - Mac: Command-Click now adds to the current selection (like Control-Click on Windows). CHANGE - Mac: File Open/Save dialogs now use native Mac dialogs. CHANGE - Mac/WINE: Improved detection of Wine version. CHANGE - Mac/Wine: Issue where hovering mouse over a list view would change the selection. CHANGE - Mac/WINE: Issue where sending tech support email resulted in "%20" and no attachment. CHANGE - Mac/Wine: corrected height on most combo boxes. CHANGE - Mac/WINE: When detecting proxy, a notification window is now displayed. CHANGE - Mac/WINE: Improved how image, text, html and csv/xls files are opened using Finder. CHANGE - Mac/WINE: Improved how "callto:" and "skype:" urls are handled using Finder. CHANGE - Mac/WINE: Removed override of "HTTP/1.0" when downloading from web. CHANGE - Mac/WINE: Network Settings, added hidden option to "Allow Indy" by pressing Ctrl. CHANGE - Mac/WINE: Improved handling of some newer RTF tags in notes. CHANGE - Mac/WINE: LxForms.ToggleActiveMDIChild only happens if the Shift key is pressed. CHANGE - Mac/WINE: LxUtils.SetCompressedAttribute has no special handling under Wine. CHANGE - Mac/WINE: Removed Win32Check() on getting exit code from process w/ console output. NOTE - Mac/WINE: Refactored use is Is_WINE and Is_WINE_Tricks_On. NOTE - Mac/WINE: Modified Is_WINE_Tricks_On to optionally check max Wine version. NOTE - Mac/WINE: Enhanced system information to include if a WineTricks override is in place. NOTE - Mac/Wine: Added "Get AppleScript Results" to advanced context menu of System Info. NOTE - Mac/Wine: Added "Convert Dos Path" to advanced context menu of System Info. NOTE - Mac/WINE: Modified how temp files are handled. NOTE - Mac/WINE: False negatives are checked in ADO.Locate(). NOTE - Enhanced system information to include Word:mac version. NOTE - Improved reporting of Windows service pack version. NOTE - Refactored RecordCount test to improve general performance. NOTE - Internet requests now explicitly set the encoding to utf-8. NOTE - Internet response status codes are now checked for success ("200"). NOTE - Background internet requests are more silent over proxies needing authentication. NOTE - Reverted TTntClientTable to TTntADODataSetLX since additional features weren't used. NOTE - Refactored TntSysUtils Windows settings change notification code. NOTE - Refactored version handling code. NOTE - Refactored Internet connection code. NOTE - Refactored URL parsing code. NOTE - Refactored thread handling code. NOTE - InstallAware 9.1 SP3 used. 1.0.47 - 7/19/2010 FEATURE - Mac/WINE: Added feature to attempt autodetection of proxy from the Mac OS settings. FIXED - Issue with exporting dates to Excel 2010. FIXED - "The password does not meet Windows policy requirements" when creating user. FIXED - "The password does not meet Windows policy requirements" when resetting password. FIXED - Issue where "EStringListError" would be reported instead of the root issue. CHANGE - Improved integration w/ GCX-SSO for TntMPD clients. CHANGE - Simplified the options under the Security tab in the System Setup dialog. CHANGE - The "Unlock Server" button (Security tab) is hidden unless server was previously locked. CHANGE - Enhanced messages about server replication components to SQL Server 2005 "or newer". CHANGE - Mac/WINE: Export to Excel occurs through a csv text file since direct export is buggy. CHANGE - Mac OS version included in system info. NOTE - Hold down Ctrl key when displaying System Info to get advanced context menu. NOTE - Added error logging in background to help improve user experience. 1.0.46 - 6/29/2010 FIXED - "RichEdit line insertion error" w/ Tools | View Web Urls (intro in 1.0.44). CHANGE - Made "CasBase" configurable in GCXAuthentication's web.config. CHANGE - OpenOffice.org Writer version and Wine version included in system info. CHANGE - Mac/WINE: Added event log under "~/Library/Application Support" folder. CHANGE - Added "Launch in Notepad" to the context menu of the error details. NOTE - Added "How did I get here?" to the context menu of the error details when "Ctrl" is pressed. NOTE - Supressed logging of an intentional exception related to named threads. NOTE - Slightly refactored connection to Excel. 1.0.45 - 6/14/2010 CHANGE - Modified some internal validation checks to be case-insensitive. 1.0.44 - 6/11/2010 FEATURE - The error dialog now enables searches for solutions on the community. FEATURE - Export to Excel now works with Excel 2010. FIXED - TntMPD.DataServer.Run.exe didn't handle WebUser/*/Categories data pumps. FIXED - "Internal Error: The download url for version [X] was not returned.". FIXED - Issue where login using Windows authentication failed with Active Directory accounts. FIXED - Refactored TTntList to avoid a possible access violation when importing large CSV files. FIXED - "Range Check" error when an error is logged to the Windows Event Log. FIXED - Corrected auto-sizing logic for checkboxes on Classic Windows theme. FIXED - Corrected auto-sizing logic for radioboxes on Classic Windows theme. FIXED - Mac/WINE: Improved display height of most combo box controls. FIXED - Mac/WINE: Display issue encountered when switching between views. FIXED - Mac/WINE: Corrected auto-sizing logic for checkboxes. FIXED - Mac/WINE: Corrected auto-sizing logic for radioboxes. FIXED - Mac/WINE: Installation program correctly installs MDAC 2.8 SP1 on WINE. FIXED - Mac/WINE: Installation program correctly installs MSXML 6.0 on WINE. FIXED - Mac/WINE: Refactored LXComboBox controls to avoid "UnCastLxObject returned nil". FIXED - Mac/WINE: Removed the "OLE Error 0x80004001" error related to embedded web browser. FIXED - Mac/WINE: HTTPS (SSL) now works over a proxy (via OpenSSL). CHANGE - Improved some assertion errors when pumping data to be more descriptive. CHANGE - Improved error message when version of SQL Server is inadequate. CHANGE - Improved visual merging of status bar from child windows to main window. CHANGE - Corrected many occurrences of "can not" to be "cannot". CHANGE - Enhanced System Information dialog w/ "User Name" entry. CHANGE - Luxembourg now uses an address format like that of Germany. CHANGE - Supressed an "Access violation ..." message when logging into newly created database. CHANGE - Mac/WINE: Changed proxy configuration dialog to not refer to IE. CHANGE - Mac/WINE: Changed proxy configuration dialog to apply settings to IE also. CHANGE - Mac/WINE: Improved display when themes are enabled. CHANGE - Mac/WINE: Moved location used for AppData folder so it's outside of the bottle. CHANGE - Mac/WINE: Missing IE or MAPI will result in warning only. CHANGE - Mac/WINE: Added Wine version to system information. NOTE - Refactored TTntCustomRichEdit to remove "EmulatedCharPos()". NOTE - Removed some small memory leaks. NOTE - Improved system information to include loaded modules and more info. NOTE - All exceptions are now logged to the Windows event log. NOTE - Improved acuracy with call stack in error details. NOTE - Improved display of loaded modules in error details. NOTE - Inner exceptions are now captured and included in error details. NOTE - Mac/WINE: overridable via "TntWareWineTricks" reg value at "HKCU\Software\Wine". NOTE - Refactored Unicode, LX and TRX libraries to be cross-compilable w/ .NET. NOTE - Installation program no longer checks for MSI 3.1 as a prerequisite. NOTE - Installation program no longer checks for IE 6.0 SP1 as a prerequisite. NOTE - Installation now requires XP SP3, 2003 SP2, Vista or newer. NOTE - Windows XP SP2 is supported, but only on the x64 edition of Windows. NOTE - Support for Windows 2000 dropped. NOTE - Compiled with Delphi 2010 Update 5. 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.