Project

General

Profile

Activity

From 05/07/2006 to 06/05/2006

06/05/2006

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

06/02/2006

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

06/01/2006

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

05/26/2006

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

05/25/2006

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

05/24/2006

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

05/22/2006

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

05/16/2006

08:35 AM Bug #2436 (New): Evaluate: Map plots with one click from plot-result-set
I was interested in poissible deeplinks to maps of plots with taxa. Can this be done? I
do a search for Quercus al...
Michael Lee

05/09/2006

08:20 AM Bug #2435 (Resolved): Store XML file's AccessionCodes in userDatasetItem
When XML is being loaded into the database, accessionCodes exist in the user's XML document that come from the user's... Michael Lee
08:15 AM Bug #2434 (Resolved): Profiling of XML Loader's Performance
During the week of 5/8/2006, the XML Loader should be profiled to see why it takes as long as it does and whether the... Michael Lee
08:09 AM Bug #2282: Confirm that "taxonAlt" loads via XML Loader
Michael should check to see if this is potentially still a problem Michael Lee

05/08/2006

11:25 AM Bug #2405: Logout is broken
changing your password also doesn't work Michael Lee
10:23 AM Bug #2395: Fix Backup Strategy -- delete extra backups from time to time
Colby needs to be the one to do this. Chad Berkley
 

Also available in: Atom