Release Notes

From GRIN-Global Wiki

Jump to: navigation, search


Contents

Resources

Note: As of February 2010, the GRIN-Global team started using the trac project management system to manage their revision process and document the release notes, hence the release notes were not duplicated on this wiki page.

Release Notes (pdf version of this webpage)

Installer / Admin Tool / Search Engine Middle Tier

v1.5.1231 (May 21, 2010)

  • Database -- added a few more unique keys and made taxonomy.name field not nullable to support importing basic accession data
  • Admin Tool -- added checks to dataview editor when saving import_* dataviews, so import dataviews can be more easily created properly
  • Middle Tier -- multi-table dataview updates are working properly now when the appropriate options flags are passed (used by Import Wizard)
  • Import Wizard -- lots of bug fixes, none in Trac since it is so new. Can now import accession data, including accession_name records.
  • Updater -- Added app versions to the Tools | Options | System Info tab
  • Database -- extended accession_name.name column, associated table mappings. Dataview updates to some import_* dataviews.
  • Admin Tool -- few small fixes to button behavior
  • Import Wizard -- Now disables real-time search engine updates, prompts user to rebuild indexes afterwards (which is considerably faster when importing lots of data). Better error handling and more data scrubbing. Ability to edit just the data that failed to import on the first try. Auto-jumps to first error during validation. Added link to "Jump to next error" to cycle through all errors before clicking Import again.

v1.5.1220 (May 18, 2010)

  • Database -- added a few unique keys to support new import wizard app
  • Admin Tool -- fixed small dataview import problem. Now contains a "Maintenance" node for launching the Import Wizard
  • Import Wizard -- new app for quickly importing data into GRIN-Global
  • Updater -- Added the following to System Info tab: which process is using port 80 (if any), web app settings, curator tool url list

v1.5.1172 (April 9, 2010)

  • Search Engine -- config file fixed; no longer throws errors when searching inventory index
  • Database -- fixed dataview used by search web page, was causing issues because it was mapped with a primary key and should not have been
  • Updater -- minor tweaks to text on options form
  • Admin Tool -- fixed connection issue when password is not saved, added a "Connections" form to handle the case when no a connection request is canceled
  • Middle tier -- primary key columns now set only once on a data table emitted from GetData?, was previously doing it once for each column

v1.5.1102 March 16, 2010)

  • Ad-hoc Filters canceling code in the Middle Tier now works as intended
  • Groups can now be managed effectively in the Admin Tool. Permission calculation now works against both groups and users. Administrative rights determined not by a permission but by membership in the "Administrators" group.
  • Updater now works properly through HTTP proxies. IIS check that was performed before installing a web application has been removed as it was causing issues on non-English operating systems.
  • All Admin Tool and Updater forms and their installers now use the 'new' icon that isn't transparent
  • Web app administrator calculation code changed, as well as a couple of minor tweaks to the Downloads page to restrict showing files it shouldn't (.version files that are auto-created by the framework)

v1.5.1043 (February 25, 2010)

  • Phrase searches (words in quotes) should now return proper results. e.g.: "united states"
  • Added some fields to indexes as needed
  • Added the inventory_quality_status index
  • Field-specific searches now work properly. Can specify @tablename.fieldname ABC (to search only a specific table/field for value ABC), or just @fieldname XYZ (to search given field in all indexes selected by the "Area" checkboxes in the Search Tool for value XYZ). e.g.: @availability_status AVAIL or @inventory_quality_status.pathogen_code STEW_WILT
  • Boolean fields are now searchable. They should always contain Y or N as their true or false values. e.g.: @is_distributable Y
  • Admin Tool now displays almost all configuration and statistical data for Search Engine. Saving still not implemented properly.

v1.5.1034 (February 21, 2010)

  • Several small database schema changes and latest dataviews included. Contains database snapshot from DEV1 as of Sun Feb 21 at 7PM CST. Database installer no longer includes GUI settings or CT lists for any users.
  • Several new capabilities added to Admin Tool, including administering File Groups, Filters, Web Application, and Search Engine.
  • Search engine related enhancements: added/tweaked indexes, added cooperator resolvers, field-specific searching (e.g. "@order_number 6811")
  • All dataviews smoke tested for SQL Server, MySQL, and PostgreSQL. Oracle still pending.
  • Security wizard in CT should now be able to write records properly (still probably some issues surrounding security wizard, but base functionality is there)


v1.5.988 (February 8, 2010)

  • Updater should successfully install all software (including itself) even if a previous version of the same software is already installed.
  • Search engine Real Time Updates now work in all cases.
  • Dataviews for MySQL and PostgreSQL all pass smoke tests; we can begin testing GRIN-Global under these database engines now.
  • New image preview / thumbnail functionality on website
  • Admin tool has more search engine features -- can stop/start/restart service, rebuild/enable/disable indexes, view pending updates, etc. However, no per-index forms are properly implemented yet

v1.5.953 (January 31, 2010)

  • Installer code now works for four database engines -- SQL Server, MySQL, PostgreSQL, Oracle
  • Admin Tool now has preliminary support for Table Mappings and Search Engine Indexes
  • Can now remove the GRIN-Global Database software even if a connection to the database cannot be established. This also allows us to install a database to multiple database engines on the same machine (for testing purposes)
  • Updater will now perform an implicit uninstall of previously installed apps before installing new versions. This allows us to easily sidestep all the upgrade issues we were having before.
  • IIS detection includes per-component checks in addition to just the presence of IIS itself.
  • IIS install is now re-verified immediately after install. This is to prevent Updater from trying to install the web app after the IIS installation is canceled mid-process by the user.
  • Updater now has HTTP proxy support
  • Clicking Download / Install in Updater will prompt database login information one time
  • Updater now has two modes, "Default Install" and "Custom Install." "Default" invokes a passive install (show progress, use default answers for all prompts). "Custom" prompts user for everything (like it did previous to this release).
  • Initial mapping support was added to the website
  • Various dataview fixes for the website


v1.5.915 (January 15, 2010)

Main changes related to installation process:

  • Latest db schema and data from dev1 is now in the db installer
  • Regenerated search engine indexes from new data so they are in sync
  • Updater has an offline mode now. You can go to Tools | Options | Installer CD to download the cab file. Then extract it to a local folder (no need to actually burn a CD unless you want to). Then click the "Use Offline..." button in upper right to point Updater at the offline_install.xml file that was extracted from the cab file. Here's the direct link: http://grin-global-dev1.agron.iastate.edu/gringlobal/uploads/installers/beta3/gringlobal_cd.cab It's about 183 MB because it includes all the db data and search index data.
  • Updater has new prompt for user when no database engines are installed locally and the Database app is being installed. It is designed to help a user select, download, and install one of the 4 must-eventually-be-supported database engines.
  • Database connection prompt appears whenever an app is installed that requires touching the database. This includes Database, Search Engine, and Web Application (latter two must set the connection string properly in their respective configuration files). This allows the user to specify different credentials (database engine, server, port, instance, username, password, etc) if need be.
  • Search Engine installer now offers ability to Create Indexes Locally automatically after install should the user not want to download the prebuilt indexes.
  • Web Application should now set rights on uploads/ folder appropriately so image uploads work as intended and do not fail with an authorization problem
  • Database progress form should no longer appear to freeze (progress bar should move relatively consistently)
  • Search Engine and Web Application can now point at a remote database server instead of requiring it to be installed locally
  • All installer code now works with SQL Server, MySQL, and PostgreSQL. The database is created successfully (including tables, users, indexes, and constraints) and connection strings are written properly. However, the apps themselves currently do NOT work with MySQL or PostgreSQL. Several dataviews are defined with SQL Server-specific SQL so they need to have SQL added to them that works with MySQL and PostgreSQL.
  • Search engine real time updates should be working for all indexed data and should not peg the box at any time
  • Search engine performance for large keyword hits (such as the 140,000 hits associated with "PI" throughout all the indexes) should be considerably better now (i.e. searching for "PI 500000" -- note the space -- or "zea mays subsp. mays" should work significantly faster)
  • Search engine should kill off a query if the client disconnects before the query is completed. This is still in experimental phase so I am expecting there to be problems with it
  • Search engine performance should no longer dip noticeably when multiple users are hitting it simultaneously
  • Web App dataview editor now allows you to delete or reorder fields or parameters with a single click
  • Fixed middle tier issue with dataviews not allowing data to be updated properly in some instances
  • Fixed bug in admin tool when connecting to remote server on alternate port


(December 9, 2009)

  • Fixed detection of .NET registration in IIS on XP. Bug was introduced when .NET / IIS registration support was added for Vista Home Premium 64-bit (last Friday I believe)
  • Added splash dialogs to Updater when checking .NET registration in IIS, registering .NET in IIS, and starting / stopping search engine -- shows progress while the install actions take place
  • In Updater, when going to Tools | Options | Download Cache tab, the full path to root download cache folder is now shown as the text for the old "Open Download Cache Folder In Windows Explorer" link


v0.98 (July 23, 2009)

Fixes / Enhancements:

  • Crystal Reports prerequisite is now detected and installed properly upon installation of the Config Wizard
  • If SQL Server is not installed and you're just installing the Client portion, SQL Server will now be installed (as it should be)
  • accession_name schema change included (accession.accession_name_id field no longer exists, accession_name.name_rank field added with appropriate values)
  • Database data and search engine index snapshots generated from test1 as of roughly 2pm CDT
  • Small website changes to portions that are still under heavy development (read: no need to test the website itself)

Since the database data and search engine data changed (schema change), you'll need to at the very least reinstall the Database, Web Application, and Search Engine. No need to uninstall the Database Engine or its Tools.

Easiest way to do this is:

  1. Run the existing Config Wizard, uninstall Database, Web Application, Search Engine
  2. Exit Config Wizard
  3. Go to Add/Remove Programs and uninstall the Config Wizard
  4. Unzip the new installer
  5. Run the new Setup.exe
  6. Run the new Config Wizard
  7. Checkmark Database, Web Application, and Search Engine


v0.97 (June 24, 2009)

  • Fixed Invalid install parameter name error during database install when installing everything at once (related to registry keys missing before SQL Server is installed)
  • When Launch Configuration Wizard is checked at the end of installation of Config Wizard, should always launch regardless of installation source (i.e. CD)


v0.96 (June 24, 2009)

  • Includes latest Curator Tool (from 2009-06-18)
  • Includes data and search indexes from test1 server as of 2009-06-23
  • Adding rows should no longer give 'primary key cannot be null' type exceptions. This was caused by the db schema being generated from SQL Server instead of MySQL and primary key fields not being marked as being an IDENTITY (i.e. no auto incremented values were being created)
  • Config Wizard Installer progress bar more accurate
  • Should not prompt for system administrator password during db install/uninstall when SQL Server is the database engine and Use Windows Authentication is checked (default scenario)
  • Should prompt to end process holding lock on installer files, if any, during a reinstall instead of bailing with an "Access is denied" error


v0.95 (June 23, 2009)

  • Fixed Vista-specific issue causing problems for the Curator Tool writing to local database
  • Current user is now explicitly added as a SQL admin (prevents SQL Mgmt Studio from requiring user to 'run as admin' for it to work properly under Vista)
  • Fixed drop users not working properly, which would cause a database install / uninstall / reinstall to fail to give proper rights to all tables for all users


v0.94 (June 22, 2009)

  • Per request from Marty, added dialog box warning of Windows CD prompt if IIS is to be installed on XP
  • Fixed orange "?" after installation completed. Should now reflect current install state properly.
  • Fixed Config Wizard not auto-launching on VIsta. "Launch Configuration Wizard" checkbox added at end of config wizard installer in both XP and Vista to support this. I cannot show that selectively based on OS version.
  • Should not have as many command prompt dialogs showing during installation on Vista


v0.93 (June 21, 2009)

  • Removed "Copy to Hard Drive" and "Run From CD" option in Config wizard installer. Always runs from HD now.
  • Should experience no more path-related issues at all (file not found, missing directory, etc)
  • All zip-related items are now stored in cab files (thank you Mark for the suggestion), this functionality is much more reliable as built-in windows zip requires a logged in user (some of the installer code runs as NT AUTHORITY\SYSTEM, which is not a logged in user)
  • Config Wizard is not automatically launched after initial installation on Vista. After installing the Config Wizard, it must be launched manually by the user. I'm still trying to resolve this issue (related to msi installer running as NT AUTHORITY\SYSTEM and Config Wizard needs to be launched as logged-in user to work properly)


v0.92 (June 19, 2009)

  • Copy To HD should work for Database install now, even after uninstall / reinstall
  • Phantom "File Not Found" or missing directory types of errors should no longer occur
  • If Copy To HD, should be able to remove CD after installation of Config Wizard has completed


v0.9 (June 17, 2009)

  • Uninstall of GRIN-Global apps should now work regardless of version (i.e. if you installed a different version of Curator Tool than that which is bundled with the Config Wizard, uninstall should still work)
  • Should no longer give "Access Is Denied" when copying files to hard drive during install of Config Wizard
  • Several small code fixes unrelated to installer process -- just bugs in the middle tier Pete found
  • Included latest Curator Tool installer (from 6-11-09 instead of 6-2-09 -- same one that is downloadable from test1 server)


v0.8 (June 16, 2009)

  • Configuration Wizard should ask to jump to the foreground after running the initial Setup.exe (taskbar item for it will blink)
  • Data for loading the database and search engine are now stored separately from the MSI's which install them, meaning the initial load of the MSI itself should be much faster. Reinstalling either at a later date require the data folder to be accessible
  • SQL Server install should log a lot more data to the install_log.txt file (and show it in the Configuration Results form after installation). This is part of the Vista testing I've been doing, but will be left in for the final release.
  • Clicking 'Done' after install / uninstall is completed will take you back to the initial form instead of closing the wizard.
  • Fixed wrong engine being reported during uninstall of Database app if config wizard is uninstalled before Database app
  • Installed statuses for GRIN-Global apps should *always* be right now, even after install / uninstall / reinstall
  • Should now clean up temporary zip file copies after unzipping
  • ValidateLogin now throws exceptions only if database connectivity is an issue
  • Has been successfully unit tested on Vista!


v0.7 (June 7, 2009)

  • Fixed Database Tools install failure Gorm found on Friday (affected XP as well as Vista)
  • Config Wizard progress bar is now responsive during installation
  • Powershell is now auto-detected and selected as needed on Vista (required for SQL Server Tools)
  • Fixed Search Engine not showing real-time updates... At least partially. Calculated fields such as PI number (prefix + number + suffix) are not updated in the search indexes properly yet. However it is possible to search by PI number if there is a space between prefix/number/suffix. So a search for "PI 1234" will return the expected results, but "PI1234" will not. I'm still trying to devise a good approach to rectifying this.
  • I don't have a Vista license I can put on a Virtual PC instance yet (will buy one tomorrow), so I haven't been able to test Vista at all since Friday. I have added several checks and some code adjustments for it, but it's still not quite ready for full-blown Vista testing. If IIS is pre-installed before loading up the Configuration Wizard, there's a chance you may get everything to install successfully. Auto-installing IIS on Vista is very different from XP and I haven't been able to test it yet.


Curator Tool

v1.0.3707.37426 (February 24, 2010)

There is a new version of the Curator Tool available on Dev1…

Curator Tool

  • Enabled the ST Cooperator radio button (to resolve searches to cooperators)
  • Fixed disconnect between “All Areas” checkbox and “Crop Trait Area” checkbox in the ST
  • Enhanced screen refresh delays on the Login dialog box when performing a “Find Servers…” operation
  • Added a warning for LU tables that need to be updated (because the user has unchecked the Auto-Update checkbox for that LU Table)
  • Added a new checkbox option to the Options Tab that allows the user to disable/enable the Auto-Update warning check during startup
  • Added CTRL-C/CTRL-V key press handling in the Edit Mode data grid view
  • Added a new context menu to the Edit Mode data grid view (right now it only has copy and paste – looking for suggestions)
  • Fixed a bug that reset the data view Form settings when the Accession or Order Wizards were invoked
  • Added an icon to the LU Table Maintenance dialog for Auto-Update checkboxes
  • Added a “Refresh Data” button to the data grid view navigator bar to refresh the data grid view data (this has a place holder for an image – looking for suggestions)
  • Added an event handler for processing the “F5” key press to refresh the data grid view data
  • Added new functionality to the “Save Data” button processing to automatically refresh the data grid view data
  • Moved the WebServiceURL.txt file from the users app data directory to the All Users app data directory, and added processing to the CT startup code to copy the “All Users” copy of that file to the current users directory (to properly handle CT users that were not allowed to install the CT software themselves)
  • Added code to save Options Tab settings “Max Rows Returned” and “Query Page Size” to the user’s profile
  • Changed the LU Table Maintenance dialog default loading speed from “Low” to “High”


v1.0.3701.41550 (February 19, 2010)

There is a new version of the Curator Tool available on Dev1…

NOTE:

The business rules for the Wizards have not been finalized – Gorm/Pete/Mark are still working through those issues.

NOTE2:

You will need the new dataviews that Laura loaded on Dev1 to use the Security Wizard

NOTE3:

If you point your CT at Dev1, you might have to click through the message boxes for ‘missing’ get_accessions, get_orders, and get_order_items dataviews that are referenced in your profile on Dev1 (we have renamed these on Dev1 to get_accession, get_order_request, and get_order_request_item and even though I attempted to fix the entries in the sec_user_gui_setting table, it is possible that I missed some)

Curator Tool

  • Testing out new icons from Rachelle (Accession Wizard, Order Wizard, and CT application icon)
  • Added functionality to display the Accession Number | Taxonomy | Origin | Top Name on the Accession Wizard navigation bar
  • Fixed the ‘lingering red highlight’ when the user right clicked on a dataview cell and then chose to do nothing in the context menu (clicked anywhere but the menu)
  • Fixed the LU table refresh for the auto-update checkbox (it would periodically un-check previously checked LU tables)
  • Fixed the 17 message box prompts when LU tables were missing (typically on a fresh install) – it should now only prompt you with one message box indicating the number of missing LU tables
  • Fixed the bug that crashed the ST when the user hit the cancel button on the first search
  • Modified the CT code to use the new dataview names for get_accession, get_order_request
  • Modified the ST code to use the new dataview names for get_accession, get_order_request, get_cooperator
  • Renamed the Source/Habitat tab to Donated/Collected/Developed
  • Added Crop Trait Area to the ST
  • Fixed Pedigree tab on the Accession Wizard to properly process FK lookups
  • Fixed Narrative tab on the Accession Wizard to properly process FK lookups
  • Fixed IPR tab on the Accession Wizard to properly process FK lookups
  • Fixed Quarantine tab on the Accession Wizard to properly process FK lookups
  • Fixed Annotation tab on the Accession Wizard to properly process FK lookups
  • Fixed Citation tab on the Accession Wizard to properly process FK lookups
  • Fixed Voucher tab on the Accession Wizard to properly process FK lookups

v 1.0.3699 (February 16, 2010)

There is a new version of the Curator Tool available on Dev1/Dev2…

NOTE: The business rules for the Wizards have not been finalized – Gorm/Pete/Mark are still working through those issues.

  • Curator Tool:
  • Security Wizard displays message box when the CT connects to a server that does not have sec_perm, sec_perm_field, sec_table_field_relationship, sec_user, or sec_user_perm datviews on the middle tier
  • Added functionality to allow a Data Form to be associated with more than one dataview (this will show up in the Dataview Tab Properties dialog)
  • Modified Accession Form to associate with get_accessions, and get_accession
  • Modified Order Form to associate with get_orders, and get_order_request
  • Fixed bug that created an exception when clicking the Edit button with no rows in the datagridview


v 1.0.3692 (February 11, 2010)

Curator Tool:

  • Modified the CT project to only build 32-bit applications (including 32 bit Crystal Report installation during CT installation) – this needs to be thoroughly tested on the 64 bit systems
  • Fixed a bug that did not properly rename subfolders when the parent folder was renamed in the treeview
  • Added a button to the Options tab to allow the user to save user settings to the database without having to close the CT (normally the CT only saves user settings to the database on exit)
  • Added functionality to allow the CT to remember the column width, column order, which row was active, and which column was the left-most visible column when switching from Read-only Mode to Edit Mode (to help minimize the user’s disorientation when going in and out of edit mode)
  • Added support to handle decimal values imported in a mass load drag/drop or cut/paste operation (for example georef lat/long values)

Search Tool:

  • Added functionality to enable searching/returning Cooperators objects (disabled until the search engine has cooperator resolvers built)
  • Added an “All Areas” check box to the Areas section (to make selecting/deselecting all areas easier)
  • Added multiple-tab data viewer that allows the “found objects” to be viewed by Accession, Inventory, Orders, or Cooperators using the same data views as the Curator Tool
  • Added data view functionality that allows the user’s CT data view settings to be used in the ST (including column width, order, visibility, etc)
  • Added functionality to allow the user to re-order data view columns (NOTE: by design the column order changes in the Search Tool are not cascaded back to the Curator Tool data view’s column order)
  • Added a “Show All Columns” checkbox that when enabled shows all columns for the data view (effectively ignoring the hidden column setting from the Curator Tool)


v1.0.3660 (January 15, 2010)

  • Curator Tool now remembers the column width, column order, which row was active, and which column was the left-most visible column (to help minimize the user’s disorientation when switching from read-only mode to edit mode)
  • Curator Tool now has a button on the Options Tab that forces all settings for the Curator Tool to be saved to the database immediately (before the settings were only saved on program exit)
  • Curator Tool will now handle decimal values imported in a mass load drag/drop or cut/paste operation (for example georef lat/long values)
  • Search Tool can now request searches for a cooperator object type (this is currently grayed out until the cooperator resolvers are built into the search engine)
  • Search Tool now has an “All Areas” checkbox to select/deselect all areas with one mouse click
  • Search Tool now has a multi-tab data viewer that allows the “found objects” to be viewed by Accession, Inventory, Orders, or Cooperators using the same data views as the Curator Tool
  • Search Tool data views use the data view settings from the Curator Tool (including column width, order, visibility, etc)
  • Search Tool can now re-order data view columns (Note: by design the column order changes in the Search Tool are not cascaded back to the Curator Tool data view’s column order)
  • Search Tool has a “Show All Columns” checkbox that when enabled shows all columns for the data view (effectively ignoring the hidden column setting from the Curator Tool)


v1.0.3612.90 (November 21, 2009)

  • Added a work-around for handling users with overly severe permission constraints that that result in denial of access to core/system functions and features.
  • Fixed the bug so that now users can move/copy Accessions (and any other objects that have ‘virtual’ children) in the tree view.


v 1.0.3611.3404 (November 20, 2009)

  • Fixed bug where color of the spreadsheet rows were not properly saved when the user navigated to a new row in the same spreadsheet.
  • Fixed bug where copying a renamed folder to the same folder would create a new folder with the *original* name of the source folder instead of the new folder name.
  • Fixed bug to handle empty tables properly during Lookup Table Loading
  • Enhanced Lookup Table Loader to uncheck and disable the auto-update checkbox when a Lookup Table has not been loaded


v1.0.3608.40116 (November 17, 2009)

  • Lookup Picker no longer automatically highlights/selects the text in the filter textbox – this prevents the next key press from clearing the highlighted text in the filter textbox.
  • Improved the Lookup Table Loader to more accurately indicate which lookup tables are out of date – the title of the lookup table should now be highlighted in ‘Sandy Brown’ to assist the user in finding the tables that need attention.
  • Added a checkbox for each lookup table in the Lookup Table Loader dialog that indicates which lookup tables should be automatically updated and which ones the user would prefer to update manually.
  • Fixed a bug in the tree view that prevented new accessions (added through the spreadsheet interface) from getting the children inventory objects properly attached to the accession object in the tree view.
  • Slowed down the speed of the Activity Progress Bar on the Lookup Table Loader dialog.
  • Fixed a bug in the tree view that allowed duplicate folder names when performing a cut/paste operation.
  • WARNING… If you downloaded and installed version 1.0.3605 this week, you will need to manually delete the lookup_table_status table from Dev1 and Dev2 local databases (because I have added schema changes to that table to remember the Auto-Load checkbox in the Lookup Table Loader dialog).


v1.0.3605.4513 (November 14, 2009)

  • Fixed Hide/Show tabs on the Navigator Tree View pane – the new logic will allow you to delete/hide tabs until there is only one tab exposed – at that point it will always show the first tab in the ‘Show Tabs’ list. If there is only one tab in the list and the menu choices for hide/delete tab are grayed out
  • Fixed bug when adding a new Accession – the Tree View should now build the inventory children underneath it
  • Added code to capture the first keystroke of the user when attempting to edit a Foreign Key column in Edit Mode on the spreadsheet (Mark – you should not have to press the ‘Z’ key twice to get the list to filter for Zea on the Taxonomy Lookup Picker dialog
  • Lots of changes to the Lookup Table Loader dialog box. Please try this out and let me know what you would like to see done differently. WARNING: This build will force you to reload your lookup tables because the local status table schema is very different


v1.0.3598.1141 (November 7, 2009)

  • Added functionality for image loading for accessions and inventory (order images coming soon)
  • Added a new Form for the Inventory Images (to view uploaded thumbnail images)
  • Fixed bug that prevented tree-view from properly updating when the user selected a different Cooperator from the dropdown combobox
  • Add functionality to detect when a users list was not properly updated on the remote server (this would typically be the result of a user not having privileges to update the app_user_item_list table on the server). The CT should now properly detect when updates fail for the following scenarios: (all of these are separate methods in the CT and need to be tested separately)
  1. adding new objects to a list
  2. deleting objects from a list
  3. dragging spreadsheet rows from a dataview to a list folder
  4. deleting a folder
  5. adding a folder
  6. moving a folder
  7. renaming a folder
  • Changed method to rename a tree view list object. Double clicking the object will not put the list object in edit mode. To rename the list object you must right click on the item (folder, accession, inventory, order, cooperator) and choose ‘Rename’ from the context menu
  • Added a ‘Clear List’ choice to the tree view context menu (this will clear a folder of all contents and leave an empty folder)
  • Added the Cooperator ID as a forth type of tree view list object and modified some of the dataviews to take advantage of this new feature. The dataviews that are *currently* able to use the Cooperator ID object are: (Rachelle – we need a nicer icon for the Cooperator active and inactive status)
  • Accession dataview (get_accessions)
  • Orders dataview (get_orders)
  • Cooperators dataview (get_cooperators)
  • Added capability to dynamically add Inventory Items to an Accession list item in the tree view. These dynamically added Inventory Items *are not* added to your user-list that is saved to the remote database. They are dynamically generated each time a user clicks the plus (+) sign next to an Accession Item. Said a different way… The dynamic Inventory Items *are only* generated when a user clicks the plus sign on the Accession and are only available in that session of the Curator Tool. When the Curator Tool is closed by the user the dynamic Inventory Items are deleted. NOTE: If you would like Inventory Items to linger from session to session, you can still do that, because the tree view will still allow the user to add static Inventory Items and (same as before) the static Inventory Items will be saved to the database when the user closes the Curator Tool.

v1.0.3593.37876 (November 2, 2009)

  • Added functionality for image loading to accessions and inventory


v1.0.3586.35731 (October 26, 2009)

  • Have replaced the date/time picker with a simple textbox (because the built-in date/time picker could not handle NULL values properly). NOTE: the formatting of the data in the Form is a bit crude at the moment – I’m still working on it but thought you should see basics of the change now [Bug 200]
  • Data entry errors should be properly cleared now when re-submitting (re-Saving) edited data (after an unsuccessful first attempt to Save edit changes) [Bug 201]
  • Ctrl-‘ should be working with checkboxes again [Bug 202]
  • If the spreadsheet has multiple rows selected when the red ‘X’ button is clicked on the Navigator Bar only the last row selected is deleted and the remaining rows are deselected (sorry Mark this is the best I could do) [Bug 203]
  • The dropdown combo boxes in the Forms should be properly ‘popping’ the value into the textbox when data is entered by keyboard [Bug 196]
  • The non-Foreign Key textbox controls in the Forms should be properly connecting to the data in the spreadsheet again [Bug 194]


v1.0.3583.38354 (October 23, 2009)

  • User can now delete row(s) by selecting row(s) in spreadsheet and pressing Delete Key [Bug 197]
  • Taxonomy Lookup dataview definition has the is_accepted_name field restored for Dev1, Dev2, and Test1 [Bug 195]
  • Ctrl-D processes all of the highlighted cells (it no longer omits saving the edit of the last cell changed) [Bug 66]
  • Foreign Key lookups behave exactly the same in the Form and Spreadsheet now (because they now share a common Lookup Picker dialog) [Bug 196]
  • The Forms will now have all controls disabled if there are no rows in the dataview [Bug 194]
  • The CT installer now automatically puts a WebServiceURL.txt file in the Application Data directory


v1.0.3581.18793 (October 21, 2009)

  • Fixed the bug that allowed a treeview folder to have duplicate nodes
  • Moved the ‘Always on top’ checkbox closer to the radio buttons
  • The ‘Always on top’ checkbox is now hidden from view when the ‘Spreadsheet’ or ‘Form’ radio buttons are selected [Bug 192]
  • Fixed the bug that incorrectly put the drag and drop records in the original folder instead of the destination folder [Bug 191]
  • The initial view of the spreadsheet now shows all fields for the default Accession, Inventory, and Order tabs when logging in for the first time [Bug 193]


v1.0.3575.24985 (October 15, 2009)

  • The [Null] value in drag and dropped data is handled properly now
  • Moved the location of the WebServiceURL.txt file from the CT program directory to the users application data directory so that Vista would allow the file to be saved
  • Added a dropdown selection of available servers at the login dialog box
  • Added an auto-scan button to search a local subnet (class D address space only) for GG servers
  • Fixed the ‘changed rows’ counter to more accurately indicate the changed rows in the CT
  • Fixed the drag and drop bug that would improperly change any cells that were [Null] before the drag and drop operation even though the new data being dragged in was also [Null]
  • Changed the user settings from ‘Resultsets’ to ‘Dataview’
  • Added a new dataview properties menu item for dataview tabs
  • Renaming an accession/inventory/order node in the treeview works properly now
  • Added a new navigator bar on the spreadsheet dataview
  • Added 3 new Forms (Accession, Inventory, and Orders) to the CT with the ability to choose one of three data viewing options: 1) spreadsheet only, 2) form only, 3) spreadsheet and form (this choice is made from the dataview’s tab properties)
  • Adding and deleting rows is done from the Navigator bar now instead of the spreadsheet
  • Changed the dropdown columns property to always show the down arrow button on the spreadsheet viewer (when in Edit Mode)
  • Ctrl-C will now process properly when no rows are currently in the datagridview / form viewer
  • The Add (+) and Delete (X) buttons on the navigator bar are now properly disabled in read mode for both the Form and Spreadsheet
  • Adding a new row in the Form will properly add a new row to the table (this should be thoroughly tested – I did not test all scenarios)
  • The Crystal Reports should load properly from any subdirectory of the Curator Tool (not just the root of the CT application)
  • The application will load the Login Dialog even if a WebServiceURL.txt file is not there
  • Accession Prefix definitions are set properly on Dev1 and Dev2 so you won’t see the Prefix dropdown combobox any more in the Accessions dataview
  • Changed the default ‘Results Matching On’ radio button in the Search Tool from ‘Any Word’ to ‘All Words”

Notes: There is some mismatching on data types between the lookup table and the dataview column data (this only happens on edit because the read-only version of the view does not enforce strict typing). The fix (at this time) is to delete the local lookup table database from the SQL Server Management Studio and let the CT rebuild the tables from scratch. (Reloading the tables from the CT without first deleting the database in SQL Server Management Studio does not fix the problem.) Also, the User Settings were purged to properly handle the new properties of the dataview tabs.


v1.0.3509.18864 (August 10, 2009)

  • Added language support on the main Curator Tool. The users Test16 through Test20 are Spanish, French, Arabic, Russian, and Portuguese respectively. WARNING: This will work on Test1 because it has the language translations loaded – this will not work on your local version of GRIN-Global until you have upgraded your installed version. NOTE: The Search Engine is mostly in English at this point because it is still a work in progress to be released at a later date.
  • Changed the saving of user settings from local XML file to the database you are connected to. This should fix some of the weird resultset tab issues you were experiencing. WARNING1: this is not heavily tested so please look for problems. WARNING2: This will work on Test1 because it has an upgraded schema to support the saving of settings to the database – this will not work on your local version of GRIN-Global until you have upgraded your installed version.
  • Fixed bug that did not properly clear the tree-view list tabs (on the left side of the Curator Tool) when switching users or web services.
  • NOTE: Changed the last name of the Test1-Test20 users to Test1-Test20 to help reduce confusion with the testers.
  • Fixed a bug to gracefully handle resultset tabs that are ‘broken’ (i.e. an error on the resultset definition). Now the Curator Tool will indicate a problem to the user with a message box and return an empty dataset.


v1.0.3506.20398 (August 7, 2009)

available on Dev2 (not Test1)

  • Added language support on the main Curator Tool. On Dev2 users Test16-Test20 are Spanish, French, Arabic, Russian, and Portuguese respectively. WARNING: Until you put some SQL updates on to your localhost database do not expect this to work right on your local GRIN-Global system.
  • Changed the saving of user settings from local XML file to the database you are connected to. This should fix some of the weird resultset tab issues you were experiencing. WARNING1: this is not heavily tested so please look for problems. WARNING2: Until you put some SQL updates on to your localhost database do not expect this to save the setting on your local GRIN-Global system.
  • Fixed bug that did not properly clear the tree-view list tabs (on the left side of the Curator Tool) when switching users or web services.
  • Changed the order of the web services list to put the custom connections at the top instead of the bottom so that testers that always want to connect to a specific server (different than the default localhost) can now do so by adding the WebServiceURL.txt file to the Curator Tool program directory (it will connect to the *first* available web service in the list).
  • NOTE: Changed the last name of the Test1-Test20 users to Test1-Test20 to help reduce confusion with the testers.


v1.0.3504.42616 (August 6, 2009)

available on Dev2 (not Test1)

  • Added language support on the main Curator Tool. On Dev2 users Test16-Test20 are Spanish, French, Arabic, Russian, and Portuguese respectively. WARNING: Until you put some SQL updates on to your local host database do not expect this to work right on your local GRIN-Global system.
  • Changed the saving of user settings from local XML file to the database you are connected to. This should fix some of the weird resultset tab issues you were experiencing. WARNING this is not heavily tested so please look for problems.
  • Notice that I changed the last name of the Test1-Test20 users to Test1-Test20 to help reduce confusion with the testers.


v1.0.3497.37021 (July 29, 2009)

  • Enhanced/fixed visual color cues in the datagridview while in edit mode.
  • Modified ‘Active Web Service’ names to accurately reflect the URL in the status bar – and also to help differentiate between Test1 (the user) and Test1 (the web services server).
  • Added Block-Style datagridview updates for CTRL+C / CTRL+V key combination and Drag and Drop mouse operation. Marty… Block-Style updates are designed to handle the scenario where the user is updating the data in the datagridview without hints for the column headers to align the columns or primary keys (or optionally the unique compound key) to align the rows.
  • Added functionality to append "custom" entries to the Active Web Service. (See the attached text file for syntax. Drop this file in to the Curator Tool program directory and you will see Dev1 and Dev2 entries in the "Active Web Service" dropdown added. Just leave this file in the CT program directory and you should always have the dev servers available to you for testing.)

v1.0.3494.40847 (July 27, 2009)

  • Added Reports and Labels (Crystal Reports) to the datagridview context menu (for selected cells).
  • Modified the accession name functionality (this is a combination of data changes in the database and Curator Tool changes).
  • The Drag and Drop functionality has been improved to handle compound unique keys that are foreign keys or code/value lookups.
  • The key combinations of CTRL + D and CTRL + ‘ have been improved to handle foreign key and code/value lookups properly.


v1.0.3467.26181 (July 7, 2009)

  • Added new choice to the ‘Active Web Service’ dropdown list (on the ‘Other Options’ tab) to allow testers to test the new schema for handling Accession Names. The new choice on the dropdown list is ‘Accession Name Test’ and it points to the small computer in my office. NOTE: virtually all of the changes for the new Accession Name strategy are simple database entry changes – the only code change was to add the new entry to the dropdown list.


v1.0.3467.26181 (July 6, 2009)

  • Added new choice to the ‘Active Web Service’ dropdown list (on the ‘Other Options’ tab) to allow testers to test the new schema for handling Accession Names. The new choice on the dropdown list is ‘Accession Name Test’ and it points to the small computer in my office. NOTE: virtually all of the changes for the new Accession Name strategy are simple database entry changes – the only code change was to add the new entry to the dropdown list.


v1.0.3467.26181 (June 29, 2009)

  • Fixed drag ‘n drop exception bug when any of the lookup value cells in the dragged data contained null values (empty cells)
  • Fixed exception when using a column with lookup values to filter the data (improperly testing an integer against a string)
  • Dates, and numbers should be sorting properly when in read-only mode


v1.0.3463.15356 (June 25, 2009)

  • Should see a dialog box warning user if errors exist before saving data (clicking Yes aborts the save and returns to edit mode, clicking No overrides the warning)
  • Editing the cells with data errors should properly clear the error message
  • The annoying !Error! message for lookup fields that contain null values is now suppressed


v1.0.3462.33017 (June 25, 2009)

  • Creating a new row by using the CTRL + ‘ (which copies the cell above) should correctly process the dropdown lookup columns
  • Search Button is now anchored in its spot relative to the upper left hand corner of the application – should help with maintaining visibility when resizing the application – still looking for feedback on the location of this button
  • The datagridview color and text message cues should be working better especially when there are data entry errors during drag ‘n drop imports (and the visual cues should be more informative too)
  • Returned the “Local” database to the dropdown list of databases that the Curator Tool can use
  • Now providing better visual cues to the user when data could not be properly resolved during imports from Excel (or other text sources)


v1.0.3456.33275 (June 18, 2009)

  • Doing a ‘click-drag-select’ to the bottom row (the new-row row) in the data grid when in edit mode no longer creates lots of empty new rows
  • CTRL + ‘ should properly refresh data grid cells that are actually ‘lookup values’ (FK columns or code/value columns)
  • CTRL + ‘ should work on the new-row row at the bottom of the data grid in edit mode
  • Row edits that are rejected by the middle tier during a Save Data process now leaves you in edit mode and should properly display the errors for each row in the data grid. The edited rows that were successfully saved should return to normal display and will not be re-saved if the Save Data button is clicked again.
  • Search button has been moved again – looking for feedback on this one – is it better or worse?


v1.0.3449.22774 (June 11, 2009)

  • Lookup Table Picker list is sorted ascending
  • Lookup Table Picker dialog sets focus to the text box filter on initial loading
  • App will now check status of lookup tables when changing databases (instead of just at first login)
  • Reorganized the buttons under the gridview (the Edit, Save, Cancel, and Search buttons) – looking for feedback on this one – is it better, worse, the same but different?
  • NOTE: Remember that if you installed the application I posted this AM you will need to manually uninstall it to get this one to replace the older version (you can thank Microsoft Installer for that inconvenience).
  • Tomas found a bug this morning. If an invalid username and password are entered during normal login a system exception is thrown. This is due to changes in the middle tier webservices which normally Brock (lead developer on the webservices) would fix in a jiffy, but he is away from the office for the next couple of days so I have created a new version of the Curator Tool to patch this bug temporarily. I have uploaded the new version of the curator tool to Test1 for you to download. The latest version of the Curator Tool is now 1.0.3449.10465. If you installed the version of the Curator Tool I posted last night, you will have to manually uninstall it (using the control panel) before you can load this new version.


v 1.0.3449.10465 (June 11, 2009)

  • Work-around patch for invalid username/password error


v1.0.3448.28631 (June 10, 2009)

  • Auto check and warning when some lookup tables are missing data


v1.0.3448.19421 (June 9, 2009)

  • Autoloading code_value lookup table
  • Splash screen to indicate code_value table is loading (it needs to do this one time only for each new local database)
  • Fixed bug in Search Engine that crashed application if user clicked cancel during login


v1.0.3447 (June 8, 2009)

  • Refresh button is working on Lookup Picker dialog
  • Lookup Picker will default to the central database if lookup table is not downloaded locally
  • The multiple new-rows bug is fixed (the datagridview would create multiple new empty rows when beginning an edit on the new-row row)
  • The lookup tables resultsets have been revised on Test1 (to accommodate the new ‘Refresh’ button and default central database queries (when a lookup table is not stored locally).
Personal tools