Project

General

Profile

Activity

From 07/29/2006 to 08/27/2006

08/26/2006

04:52 PM Bug #2528 (Resolved): Import from VegBank doesn't work for VegBranch
There are new fields and new tables to digest (and a new number of fields (75)) Michael Lee
04:05 PM Bug #1862: treat plantConcept and commConcept matching accCodes differently
sure, I'll take a shot at this Michael Lee
04:04 PM Bug #2002: add VegBranch downloads to cache and fix infinite loop problem
Also, if we have time, it would be great to add a new field to dba_xmlCache called vegbranchCSV which is just a style... Michael Lee
03:40 PM Bug #2002: add VegBranch downloads to cache and fix infinite loop problem
We have a slight problem in the caching system as plots with soilTaxon Records don't cache because of an infinite loo... Michael Lee
04:01 PM Bug #2522: XML comments should be turned off
Note, though that download will still have comments in them as they are read from the xml cache. I manually deleted ... Michael Lee
04:00 PM Bug #2522: XML comments should be turned off
comments turned off (these are part of autogenerated files, so change was in xsl) Michael Lee
03:50 PM Bug #2521: XML needs to reference new xsd
Done, with a new series of variables, properties, filters and constants. Michael Lee
03:38 PM Bug #2435: Store XML file's AccessionCodes in userDatasetItem
no longer needed, as accessionCodes from VegBranch are generated on VegBank! Michael Lee
01:59 PM Bug #2453: Empty DB created, add necessary population + verify
ant dbVerify now validates default values and also checks that certain tables are prepopulated. Michael Lee
11:22 AM Bug #2527: Plots don't load if missing project, coverMethod, stratumMethod
they are now required in the XML (beefy version) but aren't in the VegBranch version... but VegBranch requires them t... Michael Lee

08/25/2006

07:33 PM Bug #2527 (Resolved): Plots don't load if missing project, coverMethod, stratumMethod
So we either need to require those in the XML (and we need to require PK's, too), or we need to make the loader add p... Michael Lee
07:32 PM Bug #2526 (Resolved): Denorms run 26 times on XML Loading
When I load a simple XML file to Aldo, the denorms run through the complete cycle of denorms, in order, but they run ... Michael Lee
07:28 PM Bug #2303: TEST: Misc model changes
yes, all the new fields get added successfully to the database! Michael Lee
11:40 AM Bug #2453: Empty DB created, add necessary population + verify
dbVerify now validates sequences and views. Last bit that would be nice to check is to see that certain tables (dba ... Michael Lee
02:39 AM Bug #2453: Empty DB created, add necessary population + verify
ant dbverify that Chad did is now working to create all tables and ant dbVerify verifies that they have been created ... Michael Lee
01:50 AM Bug #2453: Empty DB created, add necessary population + verify
aux_role is now properly populated in the vegbank_populate_configtables.sql
This is also called with the build scrip...
Michael Lee
02:41 AM Bug #2515: Loader gets sequence values when loading old data
not anymore!
Loader now doesn't get the new PK value until it is SURE it is a new record (i.e. not already in XML, a...
Michael Lee
01:30 AM Bug #2523: We need a mechanism to require properties to be set in build.properties
Added a set of
<fail unless="[propertyName]" message="'[propertyName' is required in build.properties" />
statemen...
Michael Lee
01:01 AM Bug #2524: keywords not generating: ambiguous referencE_ID
added sql views and now we don't see an error about ambiguous reference_ID Michael Lee
12:11 AM Bug #2524 (Resolved): keywords not generating: ambiguous referencE_ID
keywords are not generating due to some complexity in gathering info on the extras (I assume). This is probably best... Michael Lee
12:21 AM Bug #2525 (Resolved): implement "request accessionCode" that is now available on VegBank
Use URLs like so: http://aldo.vegbank.org/vegbank/views/getNewRequestID.jsp?tablename=reference&recordcount=4
to get...
Michael Lee
12:20 AM Bug #1860: XML Loader: need to read incoming accessionCodes from user and check to see if already loaded to VegBank
no longer needed as bug 2442 is now resolved, making this unneeded. Michael Lee
12:19 AM Bug #1859: XML Loader: need receipt for VegBranch to update user's local AccessionCodes
this is no longer needed as I fixed bug 2442 Michael Lee
12:18 AM Bug #2442: Create a "request new AccessionCode" function for VegBranch in VegBank
Works now. New data that are loaded into VegBank accept accessionCodes that are in the dba_preassignAccCode table. ... Michael Lee

08/24/2006

11:41 PM Bug #2523 (Resolved): We need a mechanism to require properties to be set in build.properties
We used to compare build.properties with build.properties.compare and anything that was in the latter but not the for... Michael Lee
07:00 PM Bug #2521: XML needs to reference new xsd
http://vegbank.org/vegdocs/xml/vegbank-data-ver1.0.5-full.xsd now exists, as referencing in the above description/com... Michael Lee
06:46 PM Bug #2521 (Resolved): XML needs to reference new xsd
At the top of our XML documents, we have a declaration:
<VegBankPackage xmlns:xsi="http://www.w3.org/2001/XMLSchema-...
Michael Lee
06:52 PM Bug #2522 (Resolved): XML comments should be turned off
currently the XML is created with a lot of debugging statements inserted. While these aren't horrible, it would be a... Michael Lee
06:44 PM Bug #2520 (Resolved): XML Doesn't validate: DateTime invalid
In our XML stream, we have tons of date fields that are now being output like so:
<observation.obsStartDate>2001-1...
Michael Lee
02:46 PM Bug #2519: Tracking bug for upgrade of vegbank
-possibly add a link on the vegbank homepage describing how one would get the vegbank software if they wanted it. Chad Berkley
02:39 PM Bug #2519: Tracking bug for upgrade of vegbank
-install awstats Chad Berkley
01:09 PM Bug #2519: Tracking bug for upgrade of vegbank
-tag cvs for the release Chad Berkley
01:08 PM Bug #2519: Tracking bug for upgrade of vegbank
-Send a message to users that vegbank will be down for a day or two while we get this done. Chad Berkley
12:46 PM Bug #2519 (In Progress): Tracking bug for upgrade of vegbank
Tasks that need to be done on vegbank for the upgrade (in no particular order):
-modify backup procedures so that ...
Chad Berkley
11:59 AM Bug #821: Notes: add new note form, link from views of things to note
changing the milestone Chad Berkley
11:43 AM Bug #2002: add VegBranch downloads to cache and fix infinite loop problem
The xml cache is now working as far as I can tell. xml cache items get created upon upload to the system. If an ite... Chad Berkley
11:41 AM Bug #1975: Iteratively query to narrow or broaden query results
changing milestone Chad Berkley
11:40 AM Bug #1860: XML Loader: need to read incoming accessionCodes from user and check to see if already loaded to VegBank
changing milestone and reassigning to mlee Chad Berkley
11:39 AM Bug #1859: XML Loader: need receipt for VegBranch to update user's local AccessionCodes
changing the milestone and re-assigning to mlee Chad Berkley
11:36 AM Bug #833: Management page needed with full ability to modify accounts
I'm going to close this bug because I don't think there is anything else left to do with it. Restarting tomcat from ... Chad Berkley

08/17/2006

01:31 PM Bug #2497: Denorm utility incorrect in order of statements (based on tables, not sequence)
the denormutility now builds a vector of all of the keys in the sqlStore.properties file and sorts them by the sort v... Chad Berkley

08/15/2006

03:31 PM Bug #2515 (Resolved): Loader gets sequence values when loading old data
The XML Loader appears to get the next sequence value for each element it encounters, even if the element is not adde... Michael Lee

08/14/2006

04:50 PM Bug #2481: Fix Backup Strategy: where backups go
colby has confirmed that this is working. //vegbank/usr/vegbank/backup/latest is being backed up to tape with NCEAS ... Michael Lee
04:49 PM Bug #1862: treat plantConcept and commConcept matching accCodes differently
I don't think this would be all that complex for new commClasses of an observation -- it's just one table to look up ... Michael Lee
04:47 PM Bug #1946: try to use "commTypeID" for Z_USER_I
not needed at all. Can change label of field if that's helpful Michael Lee
04:46 PM Bug #1352: choose which comms from commInterpretation - higher level obs summary
allow std view of plots to be configurable as to which comms to see (most recent, best fit, original) and what names ... Michael Lee
04:45 PM Bug #2406: Automate homepage map- color by number of plots per state
now that we have no more funding after August, we need this to be done. Matt Jones has been emailed to try to get id... Michael Lee
04:44 PM Bug #2468: show error estimates of mapped plots
Error is estimated using colored icons. Michael Lee
04:42 PM Bug #675: Evaluate Tutorial
Lots has changed since the tutorial was written. Probably needs to be updated. But is this a good format for it? Michael Lee
04:41 PM Bug #2402: Strategy to update denormalized data, cache, pages
I think we decided against triggers as they proved to be slow and potentially circular. This bug remains of high imp... Michael Lee
04:40 PM Bug #2483: Link into site the new searchable data dictionary (and glossary?)
Mlee can do this after Chad leaves if need be. Michael Lee
04:40 PM Bug #2435: Store XML file's AccessionCodes in userDatasetItem
will not be needed if we can get bug 2394 working. Michael Lee
04:39 PM Bug #2282: Confirm that "taxonAlt" loads via XML Loader
yup, it does. Michael Lee
04:39 PM Bug #2002: add VegBranch downloads to cache and fix infinite loop problem
So when does the bootstrapper function? Does it search the DB periodically? What if we update a plot- how/does the ... Michael Lee
04:38 PM Bug #1860: XML Loader: need to read incoming accessionCodes from user and check to see if already loaded to VegBank
will not be necessary if we can get bug 2394 working! Michael Lee
04:37 PM Bug #1859: XML Loader: need receipt for VegBranch to update user's local AccessionCodes
will not be necessary if we can get bug 2394 working! Michael Lee
04:36 PM Bug #2484: add min cover % and max cover % to constancy table
donE! Michael Lee
04:35 PM Bug #2482: automate caching of data for homepage -- replace ant function
Very important! Perhaps we could set a cron job to run the right ant task to get this done? Or somehow else just ge... Michael Lee
04:34 PM Bug #2478: Implement Nightly/Weekly Cron (SQL)
caching of homepage data is CRITICAL that it be done somehow without ant.
Perhaps we could set a cron-job to run ant...
Michael Lee
04:32 PM Bug #2442: Create a "request new AccessionCode" function for VegBranch in VegBank
getPKFromAccessionCode() needs to be modified to look for the accessionCode in the "lookup table" if it isn't already... Michael Lee
04:08 PM Bug #2453: Empty DB created, add necessary population + verify
aux_roles need to be prepopulated, as the loader doens't allow new ones (correct behaviour) Michael Lee
04:02 PM Bug #1877: Alvar data: denorms, keywords, xml cache
This dataset is now ready to go, and has been loaded onto Aldo as a test. It can be loaded to VegBank after the rein... Michael Lee

08/09/2006

11:31 AM Bug #2444: user passwords are stored in clear text in the database
The email password function now works. It creates a random password and emails that the the user asking him/her to c... Chad Berkley

08/08/2006

03:42 PM Bug #2444: user passwords are stored in clear text in the database
I've altered the password system so that it now accepts and stores MD5 digests instead of clear text passwords. I've... Chad Berkley
 

Also available in: Atom