Activity

From 05/22/2006 to 06/20/2006

01:38 PM Bug #1861: fix denorm SQL approach: I've attempted to create a trigger system for updating the denorm fields when observation is updated. This seems to ... Chad Berkley

01:43 PM Bug #1861: fix denorm SQL approach: the SQL that denormalizes fields is in:
vegbank/src/sql/denorm
2 files, one has SQL to update everything, and one jus... Michael Lee
12:05 PM Bug #2457 (New): Link to list of certified users, renew embargo screens: in general, some pages are orphaned in the system and need to be linked to directly somehow. Michael Lee

10:17 AM Bug #2405: Logout is broken: This actually works with a normal install. It just doesn't work on vegbank.org. I have successfully logged out and ... Chad Berkley
10:07 AM Bug #833: Management page needed with full ability to modify accounts: The delete plots functionality was already implemented, but you had to type in the plot ids of the plots you wanted t... Chad Berkley

10:59 AM Bug #833: Management page needed with full ability to modify accounts: you can now do the actions with the X next to them.
X view all users
X certify users
delete plots
X delete users
res... Chad Berkley

12:39 PM Bug #2434: Profiling of XML Loader's Performance: Typo fixes for the last comment...oops.
(In reply to comment #5)
1) **Change the** SAX parser parse and load per ob... Chad Berkley
12:34 PM Bug #2434: Profiling of XML Loader's Performance: I've been looking at possible ways to speed the loader up even more than we already have for the last 2 days. Basica... Chad Berkley

01:24 PM Bug #2434: Profiling of XML Loader's Performance: I've finished my analysis of the observation insertion part of LoadTreeToDatabase.insertVegbankPackage(). It is stil... Chad Berkley

02:55 PM Bug #2434: Profiling of XML Loader's Performance: Michael pointed out that the accessionCode field in several tables gets hit a lot. Since the field is pretty static,... Chad Berkley
01:44 PM Bug #2434: Profiling of XML Loader's Performance: It seems a lot of time is being spent in the LoadTreeToDatabase.insertTaxonObservations() method. For a run of the s... Chad Berkley

02:23 PM Bug #2434: Profiling of XML Loader's Performance: I inserted a timer into the loading code. Below are the results for a very small xml file. A 0 in the timer means i... Chad Berkley
02:21 PM Bug #2283: Email to user does NOT work after load: using Hyperion!: changed to mail.nceas.ucsb.edu. the property can be changed in build.properties if installed outside nceas. Chad Berkley
12:59 PM Bug #2453: Empty DB created, add necessary population + verify: Also need a DROP script so we don't have to use a dropdb to start with a fresh schema. Chad Berkley
12:55 PM Bug #2453 (Resolved): Empty DB created, add necessary population + verify: Currenty, the sql scripts, both generated and static, do not properly build the database. It is currently impossible... Chad Berkley
09:48 AM Bug #2442: Create a "request new AccessionCode" function for VegBranch in VegBank: http://aldo.nceas.ucsb.edu/vegbank/views/getNewRequestID.jsp?tablename=observation&recordcount=4
creates 4 new obser... Michael Lee
09:39 AM Bug #2442: Create a "request new AccessionCode" function for VegBranch in VegBank: database.accession.key.preassign=VBAldoPre
is also added to build.properties in the /vegbank/ directory. Michael Lee

10:37 AM Bug #2402: Strategy to update denormalized data, cache, pages: We might be able to use triggers to handle all the denorms. Then it's out of sight and out of mind. Update anything... Michael Lee

12:02 PM Bug #2401: Switch default mapping from Yahoo to Google: fixed in datacart view Michael Lee

06:18 PM Bug #2423: Upgrade to v2 for google maps on VegBank site: not too difficult. Now adding more mapping will go through version 2 and we won't have to do this but once. Michael Lee
11:58 AM Bug #2444 (Resolved): user passwords are stored in clear text in the database: User's passwords stored in the usr.password table/column are stored in clear text. This allows a system administrato... Chad Berkley

09:54 AM Bug #2424: new feature: Create "find plots by area" using google maps: exactly the same
*** This bug has been marked as a duplicate of 2404 *** Michael Lee
09:54 AM Bug #2404: Evaluate: Let users define bounding box with Google Maps, then show plots in that area: *** Bug 2424 has been marked as a duplicate of this bug. *** Michael Lee
09:46 AM Bug #2423: Upgrade to v2 for google maps on VegBank site: also useful: http://www.google.com/apis/maps/documentation/reference.html Michael Lee

12:23 PM Bug #2442: Create a "request new AccessionCode" function for VegBranch in VegBank: this XML was successfully imported:
http://www.unc.edu/~mikelee/Misc/testImportXML2.xml Michael Lee
11:45 AM Bug #2442: Create a "request new AccessionCode" function for VegBranch in VegBank: Confirm for newly issues confirmation codes should be some random string, as we won't know "diddley" about the actual... Michael Lee
11:38 AM Bug #2442: Create a "request new AccessionCode" function for VegBranch in VegBank: I'd imagine this working on the VegBank side as a new table called "issuedAccessionCode"
A client would be able to r... Michael Lee
11:32 AM Bug #2442 (Resolved): Create a "request new AccessionCode" function for VegBranch in VegBank: This will allow users to request GUIDs from VegBank.org from ANYWHERE. This makes bug 1859 and bug 1828 unneeded, i... Michael Lee

Also available in: Atom

VegBank