Activity
From 06/24/2006 to 07/23/2006
07/20/2006
- 08:44 PM Bug #2497: Denorm utility incorrect in order of statements (based on tables, not sequence)
- I have confirmed that this is indeed happening-- the ordering gets messed up because each table is run in the order o...
- 03:22 PM Bug #2497 (Resolved): Denorm utility incorrect in order of statements (based on tables, not sequence)
- I think the denorm utility updates after an XML load from table-to-table. This is incorrect. It should go in the or...
07/17/2006
- 12:27 PM Bug #2002: add VegBranch downloads to cache and fix infinite loop problem
- So far I have updated the LoadTreetoDatabase.java so that when a new xml document is uploaded and ingested into vegba...
07/07/2006
- 10:33 PM Bug #2064: add query to views, to search for data within a set of views
- done. Can now search easily for parties and projects. Other views can be easily added using the templates on those ...
- 10:32 PM Bug #2394: Make Search by person easier: filter by plots submitted and plots contributed to
- you can now search for people much more easily, from the party summary page:
http://aldo.vegbank.org/get/summary/par...
07/06/2006
- 12:48 PM Bug #2488: NPS-PLOTS import Growth Form Bug
- Half of this stuff is a problem in the custNPS_intGF12() function
- 12:30 PM Bug #2488: NPS-PLOTS import Growth Form Bug
- "unknown" gf should be "other/unknown" as in the list
- 12:13 PM Bug #2488: NPS-PLOTS import Growth Form Bug
- also update cover codes to round them to values of 6 digits past decimal
- 11:59 AM Bug #2488: NPS-PLOTS import Growth Form Bug
- remove dashes and spaces from case statements, add "forestwoodland"
- 11:52 AM Bug #2488 (Resolved): NPS-PLOTS import Growth Form Bug
- "forest, woodland"
- 11:33 AM Bug #2487 (New): NPS-PLOTS conversion utility: prefer exact slope/aspect
- make conversion utility prefer exact (numerical) slope and aspect if possible.
07/03/2006
- 04:48 PM Bug #2481: Fix Backup Strategy: where backups go
- colby has responded and backups will be easily done. We should definitely shift our strategy to putting the latest c...
- 10:36 AM Bug #2486 (Resolved): Certification Request form broken in Regions
- Regions do not store in the database correctly, or users didn't fill them out. In any case, none are displayed on th...
- 10:28 AM Bug #2457: Link to list of certified users, renew embargo screens
- Would be nice to link to the plots that a certified user has submitted from the list. Need a more compact list, too....
- 10:23 AM Bug #2457: Link to list of certified users, renew embargo screens
- Ceritifed user's registry is not viewable b/c there aren't enough users to make it worthwile to view:
http://aldo.ve... - 10:01 AM Bug #2457: Link to list of certified users, renew embargo screens
- renew embargo screen is linked through "MY Account"
http://aldo.vegbank.org/vegbank/general/account.html - 09:59 AM Bug #2484: add min cover % and max cover % to constancy table
- added these to SQL View, SQL Store, and JSP View. Need to make the js sorter smarter to deal with a top-top header a...
- 09:30 AM Bug #2478: Implement Nightly/Weekly Cron (SQL)
- I've come up with the SQL, but that's all I can do with this. Chad, can that be implemented with a Cron on a nightly...
- 09:29 AM Bug #2403: add accessionCode to more tables in db
- accomplished in bug 2303, testing done.
- 09:28 AM Bug #2306: change elevationAccuracy to meters, not %
- accomplished in bug 2303.
- 09:28 AM Bug #2305: Add fields to explicitly note that there are NO SPECIES on a plot, or no stems on a plot
- accomplished in bug 2303, testing to be dealt with there.
- 09:28 AM Bug #2303: TEST: Misc model changes
- changes script checked into /src/sql/vegbank-changes-1.0.5.sql
Now needs testing that
1) accessionCodes update (YES... - 09:25 AM Bug #2453: Empty DB created, add necessary population + verify
- Might we be able to get by with an update script from schema 1 to schema 2. Realistically, this will be needed as we...
06/28/2006
- 04:28 PM Bug #2303: TEST: Misc model changes
- all changes made to db_model_vegbank.xml except for field to explicitly state no species. Not yet checked in, however.
- 02:18 PM Bug #2303: TEST: Misc model changes
- Expert System is boolean, should be descriptive
Add Plot Rationale field: why was this plot sampled?
see also bug 230... - 02:47 PM Bug #2331: ensure NVC.doc standards doc matches what's in VegBank
- This is the standards document that Michael went through and commented on places that didn't align well with VegBank
- 02:44 PM Bug #2331: ensure NVC.doc standards doc matches what's in VegBank
- There were a few issues that were discovered.
"Practically speaking, these repeat visits (which should be document... - 02:36 PM Bug #2484 (Resolved): add min cover % and max cover % to constancy table
- please
- 02:16 PM Bug #2483 (Resolved): Link into site the new searchable data dictionary (and glossary?)
- We need a searchable data dictionary and glossary of terms. Perhaps the simplest thing would be to add a few tables ...
- 02:11 PM Bug #2481: Fix Backup Strategy: where backups go
- colby emailed 6/28/06 about this.
- 10:12 AM Bug #2481 (Resolved): Fix Backup Strategy: where backups go
- +++ This bug was initially created as a clone of Bug #2395 +++
We need to make sure that this backup is not just t... - 10:21 AM Bug #2478: Implement Nightly/Weekly Cron (SQL)
- OK, everything that can be done via SQL, including the VERY IMPORTANT VACUUM ANALYZE is now accomplished by "periodic...
- 09:03 AM Bug #2478: Implement Nightly/Weekly Cron (SQL)
- (In reply to comment #0)
Some of the following is done, some of it can be done with SQL, some of it can't.
> The URL... - 09:00 AM Bug #2478 (Resolved): Implement Nightly/Weekly Cron (SQL)
- The URL describes tasks needed for nightly, or perhaps weekly for VegBank. MLee should write the SQL that accomplish...
- 10:21 AM Bug #2482 (Resolved): automate caching of data for homepage -- replace ant function
- We need to automate the caching of data that is displayed on the homepage with a cron job. Currently, the caching is...
- 10:13 AM Bug #2395: Fix Backup Strategy -- delete extra backups from time to time
- This bug has been split. This portion of the bug now deals only with removing extra old backups in the /usr/vegbank/...
06/27/2006
- 11:41 AM Bug #2477 (New): Login forwarding problems
- I registered as a new user. Then I went to "submit data" link, put a file name into the box and pressed "continue." ...
- 11:32 AM Bug #2476 (Resolved): when you try to submit data without certification, you can get to the upload screen
- When uses click the "submit data" button on the header of any page in VegBank, they should be checked for certificati...
- 11:30 AM Bug #2475 (Resolved): If not certified, but logged in, should prompt to certify, not login
- when you try to load plots or do other certified-only activities, the system says:
"The page you tried to access r... - 11:28 AM Bug #2474 (Resolved): After users register, they need to know it worked
- when new users register at http://aldo.vegbank.org/vegbank/forms/RegisterNewUser.jsp
they are taken to the home page...
Also available in: Atom