Project

General

Profile

Activity

From 01/18/2007 to 02/16/2007

02/15/2007

03:30 PM Bug #2778 (Resolved): Need better markers for empty plot vs no stems here.
Need better linking between forms, including options for saying "no natural stems sampled" (change to level 1) or "no... Michael Lee
03:19 PM Bug #2776: Need some queries to help us summarize issues for contractors
better for project summary pasting into a new document (text):
SELECT [projectName] & " (ID " & [entry_projectCode] ...
Michael Lee
01:00 PM Bug #2777 (Resolved): add to interface: Coordinates need more metadata
VegBank appears to lack a place for saying what kind of coordinates are in AuthorE and AuthorN. I thought this was s... Michael Lee

02/14/2007

04:10 PM Bug #2776: Need some queries to help us summarize issues for contractors
Might be nice to have a query that reads out in English what the problems are and where with errors so I can more eas... Michael Lee
02:33 PM Bug #2776 (Resolved): Need some queries to help us summarize issues for contractors
Need a naming scheme (qa_quick)?
A simple summary by project:
SELECT project.projectName, project.entry_projectCo...
Michael Lee

02/13/2007

03:44 PM Bug #2774: RETEST: errors in individual stem migration
retested migration and it works to my satisfaction. Michael Lee

02/12/2007

06:02 PM Bug #2774: RETEST: errors in individual stem migration
(In reply to comment #0)
>
> FIXED: Diameter was reduced by 0.5, something that is only needed with the classes.
>
...
Michael Lee
05:21 PM Bug #2774: RETEST: errors in individual stem migration
*** Bug 2761 has been marked as a duplicate of this bug. *** Michael Lee
05:16 PM Bug #2774 (Resolved): RETEST: errors in individual stem migration
There are errors!
Diameter was reduced by 0.5, something that is only needed with the classes.
Damage didn't mi...
Michael Lee
05:49 PM Bug #2772: DBA: doesn't read planted stems when calculating plots without data
chk_lackdata_stems new SQL:
SELECT observation.PROJECT_ID, entry_plots_stems.plotID, observation.authorObsCode AS Pl...
Michael Lee
04:39 PM Bug #2772 (Resolved): DBA: doesn't read planted stems when calculating plots without data
plots without data need ot really have no data: no planted and no natural stems. Michael Lee
05:45 PM Bug #2773: function attempt to update nulls badly
better yet, If Not IsNull(!ObsBasalArea) Then
doens't even run sql if null then.
Michael Lee
04:46 PM Bug #2773 (Resolved): function attempt to update nulls badly
these functions try to update nulls to values that can be null, throwing off the SQL:
sas_updateTaxonImportanceCalcF...
Michael Lee
05:22 PM Bug #2760: add Quick fix for common errors
back to new, not assigned Michael Lee
05:21 PM Bug #2761: DBA screens not working well with smaller stems
oops, added this twice. Though it is a large enough error that it could justify two bugs.
*** This bug has been mar...
Michael Lee
02:35 PM Bug #2771 (Resolved): implement more sanity Checks : herbs
More sanity checks will ensure that herbs migrated as we thought they would. This currently exists more for stems, b... Michael Lee
02:33 PM Bug #2770 (Resolved): Finish the export DB function for level 5 data
A preliminary export function exists that creates a new database after migration of level 5 data in the Entry databas... Michael Lee

02/11/2007

09:33 PM Bug #2754: X-IL record does not appear on map; Need category for misc records

1. The X-IL record appears in specimens but not on the map.
Robert Peet
09:28 PM Bug #2767 (Closed): Adjust colors on maps
Current colors New colors
Red Dark: 255-0-0 (0-100-100) OK
Red Light: 255-128-12...
Robert Peet
08:40 PM Bug #2684: Miscellaneous literature records for distribution
We need for orange and green check boxes by the maps, a generic category for the many possible small but important li... Robert Peet
08:16 PM Bug #2602: Document concept references in Weakley flora
Jess Long has now completed matching the letters with references. As soon as Alan resolves the problematic case Bob ... Robert Peet
08:13 PM Bug #2766: Add simple and full reference details and eliminate letter codes
This bug will allow us to exploit the resolution of bug 2602, which is now nearly complete owning to the work of Jess... Robert Peet
01:25 PM Bug #2766 (Closed): Add simple and full reference details and eliminate letter codes
Redesign the website so that the uninformative letter-code references to literature is replaced by a simple reference... Robert Peet

02/08/2007

09:34 AM Bug #2763 (Closed): Misplaced determiniation data for specimens
When one examines the details of a specimen, the information on determinations appears under the heading of cultivate... Robert Peet

02/07/2007

07:28 AM Bug #2609: Erroneous assignment of ambiguous status
I seem to have expressed myself poorly in comment #5. I will try again so summarize the situation.
This is largely ...
Robert Peet

02/06/2007

07:53 PM Bug #2757: Concept relationships in county clickover need reordering
fixed
please check it.
xianhua liu
06:04 PM Bug #2639: Inferred relationships too broad
Fixed
1. changed the inferring rule to allow C.g. (Weakley) < C.g. (FNA) and other relationships under the similar s...
xianhua liu
05:21 PM Bug #2639: Inferred relationships too broad
[As an aside, another and more difficult problem is the inferred relationship
C.g. (Weakley) < C. ovalis (nominal)
Th...
xianhua liu
04:59 PM Bug #2609: Erroneous assignment of ambiguous status
Why NCSU Acer negundo specimens are ambiguous?
1) Acer negundo Weakley < Acer negundo nominal
2) NCSU follows...
xianhua liu

02/05/2007

10:00 PM Bug #2762 (Resolved): Add "Ignore this Error" to logical error checking
When you check for errors, there can be some warnings or extenuating circumstances under which you can live with cert... Michael Lee
09:39 PM Bug #2759: Importing from self causes big problems
rereleasing 2.0.4 since I havent told anyone about it anyway. Michael Lee
09:31 PM Bug #2759: Importing from self causes big problems
fix:
If Dir(strDBLoc) <> "" Then
'have a database, import data into this
'check to be sure it isn't THIS d...
Michael Lee
03:47 PM Bug #2759 (Resolved): Importing from self causes big problems
Importing from same database is possible, but shouldn't be. Michael Lee
04:10 PM Bug #2761: DBA screens not working well with smaller stems
individual stem plots are not unfolding into the archive properly either. Need to pull in the unique species over to... Michael Lee
04:06 PM Bug #2761 (Resolved): DBA screens not working well with smaller stems
the sanity checks are only working for larger stems, not indiv. Michael Lee
03:54 PM Bug #2760: add Quick fix for common errors
fix no date in stems:
UPDATE entry_plots_stems INNER JOIN observation ON entry_plots_stems.plotID = observation.OBSER...
Michael Lee
03:53 PM Bug #2760: add Quick fix for common errors
Fix negative long:
UPDATE observation SET observation.authorE = "-" & [authorE]
WHERE (((Left(Trim([authorE]),1))<>"-...
Michael Lee
03:50 PM Bug #2760 (New): add Quick fix for common errors
need a quick fix for longitude is positive
also for filling in default of 10cm for minimum stem size.
Michael Lee

02/04/2007

09:08 PM Bug #2753: Apostrophe in specimen list appears as &apos;
fixed Robert Peet
09:08 PM Bug #2741: more clearly separate the ambiguous records
fixed Robert Peet
09:07 PM Bug #2740: Add ispecies link to other sources tab
fixed Robert Peet
09:07 PM Bug #2654: Selection box for sources for county records
fixed Robert Peet
09:07 PM Bug #2654: Selection box for sources for county records
fixed Robert Peet
09:04 PM Bug #2640: Identify USDA species without county distribution where other spp in genus have distribution
reassign to Bob Peet to resolve based on data being collected by Jeff Ott. Robert Peet
09:00 PM Bug #2757 (Closed): Concept relationships in county clickover need reordering
Note that if you map Dendrolycopodium hickeyi and then click on Jackson county, you get:
NCU: Lycopodium hickeyi:...
Robert Peet
08:53 PM Bug #2754: X-IL record does not appear on map; Need category for misc records
I tired and it seems to have failed.
The one IL taxon I know is Lycopodium hickeyi. I see two problems.
1) I searc...
Robert Peet
08:44 PM Bug #2639: Inferred relationships too broad
We are making progress, but new problems keep appearing. Let's continue with the Carya glabra example.
There is an ...
Robert Peet

02/02/2007

03:22 PM Bug #2750: Emails not getting to @unc.edu
Grant has sent me his bounce message, but not with full headers. Now we need to know the IP info from him. I emaile... Michael Lee

01/29/2007

03:19 PM Bug #2751: Error checking caused out-of-sync error that led to instability
added a command that refreshes all open forms before trying to reset the errors field to null or resolved.
also requ...
Michael Lee

01/28/2007

11:51 AM Bug #2754: X-IL record does not appear on map; Need category for misc records
I added "X-IL" as a new data source to the map. Please try this on the new collections from this new source.
We have...
xianhua liu
11:33 AM Bug #2753: Apostrophe in specimen list appears as &apos;
fixed xianhua liu
11:25 AM Bug #2752: commit atlas to cvs
Bob:
Here are some options about the place on the CVS for SEFlora sources.
1. At the root: /seflora
2. In VegBank:...
xianhua liu

01/26/2007

03:48 PM Bug #2751: Error checking caused out-of-sync error that led to instability
done: need to add to general error checker that if this error comes up (3167 or
-2147467259) to suggest compact and r...
Michael Lee
03:20 PM Bug #2751: Error checking caused out-of-sync error that led to instability
the memo field "headerrors" on entry_plots_stems was corrupted and was valued #Deleted and access couldn't do anythin... Michael Lee
01:09 PM Bug #2751 (Resolved): Error checking caused out-of-sync error that led to instability
Forbes was error checking all plots (from the QA tab) and somehow got an out-of-sync error. Error checking needs to ... Michael Lee
02:18 PM Bug #2754 (Closed): X-IL record does not appear on map; Need category for misc records
We need a way to collect a number of small piles of collections into one group for purposes of mapping. The current ... Robert Peet
02:12 PM Bug #2753 (Closed): Apostrophe in specimen list appears as &apos;
Take a look at the collections of Lycopodium hickeyi from Jackson County NC and you see the placename "Devil's" rende... Robert Peet
02:04 PM Bug #2752 (New): commit atlas to cvs
SEEK policy is to deposit our software in cvs.ecoinformatics.org. Moreover, we are now considering a collaboration w... Robert Peet
12:59 PM Bug #2750 (Resolved): Emails not getting to @unc.edu
Someone is having problems getting emails to cvs at unc.edu. A UNC help ticket has been established (UNC-CH Remedy T... Michael Lee
11:34 AM Bug #2749: Soil errors in legacy data: Mg truncated
From Bob's email 1/26/2007:
I have not yet gone back to check, but it could be that the way the
the total exchangeab...
Michael Lee
11:34 AM Bug #2749: Soil errors in legacy data: Mg truncated
Does this problem possibly apply to other fields besides Mg? What kind of range
of Basal Saturation are we looking f...
Michael Lee
11:34 AM Bug #2749 (New): Soil errors in legacy data: Mg truncated
Email from Bob 1/25/2007:
Elizabeth Marx discovered that soils for plot 20-7-340-8 have mg ppm as 2,
which is inc...
Michael Lee

01/22/2007

04:59 PM Bug #2745: When I import data from another database, the reset woody fails
now reset checks for invlaud values in the species list before resetting. Michael Lee
04:57 PM Bug #2745: When I import data from another database, the reset woody fails
Importing from another database fixed.
still need to check values when I reset field.
Michael Lee
04:42 PM Bug #2745 (Resolved): When I import data from another database, the reset woody fails
resetting woody data fails when importing from another database. Should either change that field when importing (pro... Michael Lee
04:53 PM Bug #2744: on release, make sure we add error handling to rc
done since I found another flaw in 2.0.4 Michael Lee
04:40 PM Bug #2744 (Resolved): on release, make sure we add error handling to rc
maintenance code needs to check for error handling (but require that db be called something rc to do it). Michael Lee
04:50 PM Bug #2743: Message warning about compacting says the wrong thing
found other bugs in 2.0.4 so I fixed this too. Michael Lee
04:39 PM Bug #2743 (Resolved): Message warning about compacting says the wrong thing
The message you get is:
"You can't exit" MS Access now, but my message box says:
"Cannot close" MS access now.
...
Michael Lee
01:28 PM Bug #2739: Species name doesn't appear if not woody
fixed.
CVS_EEP_DataEntry_v204p9.mdb
Michael Lee
01:20 PM Bug #2739: Species name doesn't appear if not woody
added an under-cover scientfic name box that will show its contents even if the picklist is empty. When you select a... Michael Lee

01/21/2007

03:12 PM Bug #2741: more clearly separate the ambiguous records
fixed xianhua liu
12:17 PM Bug #2740: Add ispecies link to other sources tab
fixed xianhua liu

01/20/2007

10:31 AM Bug #2741 (Closed): more clearly separate the ambiguous records
I think we need to more clearly separate the ambiguous records for the unambiguous ones. Toward this end I think we ... Robert Peet
10:23 AM Bug #2740 (Closed): Add ispecies link to other sources tab
Let's add a link to ispecies
http://darwin.zoology.gla.ac.uk/~rpage/ispecies/
The syntax for queries looks pretty...
Robert Peet

01/19/2007

06:49 PM Bug #2654: Selection box for sources for county records
fixed. Please wait for server side classes being updated. xianhua liu
04:58 PM Bug #2739: Species name doesn't appear if not woody
Fix by adding not enabled, locked text box underneath the picklist that displays the species name always. If user cl... Michael Lee
04:56 PM Bug #2739 (Resolved): Species name doesn't appear if not woody
Tree data form can get tricky if species is picked from list that isn't woody. Need to incorporate woodiness there a... Michael Lee
04:54 PM Bug #2736: import from other db fails with ordering and when tables aren't there
fixed in v204p8 on bioark and my computer. Michael Lee
01:34 PM Bug #2736 (Resolved): import from other db fails with ordering and when tables aren't there
The following code helps fix this:
If Not .BOF Then .MovePrevious
Do Until .BOF Or .EOF
'go from ...
Michael Lee
 

Also available in: Atom