[Babase] [Fwd: Re: OFR error 9 feb]

kfenn kfenn at princeton.edu
Thu Feb 5 13:57:17 EST 2009


Just to keep me from doing something stupid...
could you also delete the row in babase_test so I can run my query there 
first?

Thanks,
Tabby

Lacey Maryott wrote:
> done
>
> kfenn wrote:
>> Lacey,
>>
>> Is this on your radar screen or 'to do' list?  Can you send me an 
>> email when the row is gone so I can make the changes to OFR 
>> statdate?  I'm worried I'm going to forget about it.
>>
>>
>> Thanks,
>> Tabby
>>
>> Susan Alberts wrote:
>>> I agree the Psion data for OFR that day should be deleted.
>>> Susan
>>>
>>> On Jan 27, 2009, at 11:08 AM, kfenn wrote:
>>>
>>>> Hi all,
>>>>
>>>> I just mentioned to Jeanne that this OFR issue had not been 
>>>> resolved (see below).  She feels the psion sample row should be 
>>>> deleted.  If Susan can give the final OK on this, Lacey can make 
>>>> the change and put this to rest.
>>>>
>>>> Thanks,
>>>> Tabby
>>>>
>>>> Karl O. Pinc wrote:
>>>>>
>>>>> On 12/10/2008 08:55:35 AM, Lacey Maryott wrote:
>>>>>> Hey Tabby,
>>>>>>
>>>>>> I'm sending this to the babase list because I'm honestly not sure 
>>>>>> if it can just be deleted.  I'm assuming it can.   Karl, is there 
>>>>>> a validation rule that is creating this error? Make sense that 
>>>>>> there would be.  If I can get the all clear from the powers that 
>>>>>> be (Susan, Karl, Jeanne if you are following this) I will go 
>>>>>> ahead and just delete these since I know there is no data other 
>>>>>> than that she was out of sight.
>>>>>>
>>>>>> Lacey
>>>>>
>>>>> (FYI This quoting style make it hard to tell who said what.)
>>>>>
>>>>>>
>>>>>> Thanks for the lookup, Lacey.
>>>>>> Are you allowed to delete the sample?  I can't update the 
>>>>>> statdate to her true deathdate because the validation rules are 
>>>>>> telling me that she can't be recorded as dead the same day she 
>>>>>> has a row in SAMPLES....?  Probably a new (and rare) problem with 
>>>>>> the validation rules.
>>>>>>
>>>>>>
>>>>>> Tabby
>>>>>>
>>>>>> Lacey Maryott wrote:
>>>>>>> Hey  Tabby,
>>>>>>>
>>>>>>>  I just looked at this, and OFR was out of site for the whole 
>>>>>>> sample on 9 Feb. That just means they had her picked to sample 
>>>>>>> that day, but when she wasn't there, they just went through her 
>>>>>>> 10 minutes entering that she was out of site, presumably incase 
>>>>>>> by chance she rejoined the group. Hope this helps!
>>>>>>>
>>>>>>> Lacey
>>>>>>>
>>>>>>> kfenn wrote:
>>>>>>>> Hi Lacey,
>>>>>>>>
>>>>>>>> I'm not even going to attempt to explain how I found this 
>>>>>>>> screwy thing, but I need your help to correct it so I can 
>>>>>>>> update the statdate.
>>>>>>>>
>>>>>>>> OFR (Omo's) has a demog note for 9 Feb 2008 that says she was 
>>>>>>>> not found during the census.  However, she has row in SAMPLES 
>>>>>>>> for this date (it didn't throw an error for you because I put 
>>>>>>>> the demog note in so Babase assumed she was really in the 
>>>>>>>> census that day.).
>>>>>
>>>>> Yes, putting a demog note in for an individual makes them present
>>>>> on that day.  Right now there is no provision for having
>>>>> a demography note for an absent individual.  If we
>>>>> want to do that I could make some changes.
>>>>>
>>>>> One way around this is to mark them absent (A) in
>>>>> CENSUS on that day, but _not_ mark the census row
>>>>> CEN column TRUE, so it'd be a census row that's
>>>>> _not_ there because of a census.  Right now,
>>>>> when a demography note goes in and there's an
>>>>> absence recorded in census, the demography note
>>>>> changes the absence to a D, indicating presence
>>>>> due to demography note.  It could check the CEN
>>>>> column and only make the change when the CENSUS
>>>>> row was input as part of a census.  That way you
>>>>> could manually put an 'A' in and it would "stick"
>>>>> when you put a demography note in.  (We'd also
>>>>> have to have the manual "A" automatically removed
>>>>> when the demography note was removed -- I think.)
>>>>>
>>>>>>>>
>>>>>>>> Can you check on this and let me know what we ought to do?  
>>>>>>>> Deleting the SAMPLES row would make sense it unless OFR was 
>>>>>>>> actually there that day.  In that caseI need to change the 
>>>>>>>> census from absent to present.
>>>>>>>>
>>>>>>>>
>>>>>>>> Tabby
>>>>>>>>
>>>>>>>
>>>>>>
>>>>>> -- 
>>>>>> Tabby Fenn
>>>>>> Research Assistant
>>>>>>
>>>>>> Dept of Ecology and Evolutionary Biology
>>>>>> 401 Guyot Hall
>>>>>> Princeton University
>>>>>> Princeton, NJ  08544
>>>>>>
>>>>>> 609 258-6898 (Ph)
>>>>>> 609 258-2712 (Fx)
>>>>>>
>>>>>>
>>>>>>
>>>>>> -- 
>>>>>> Lacey Maryott
>>>>>> Alberts Lab
>>>>>> Department of Biology
>>>>>> Duke University
>>>>>> ph: 919-660-7306
>>>>>> fax: 919-660-7293
>>>>>> Lacey.Maryott at duke.edu
>>>>>> _______________________________________________
>>>>>> Babase mailing list
>>>>>> Babase at www.eco.princeton.edu
>>>>>> http://www.eco.princeton.edu/mailman/listinfo/babase
>>>>>>
>>>>>
>>>>> Karl <kop at meme.com>
>>>>> Free Software:  "You don't pay back, you pay forward."
>>>>>                 -- Robert A. Heinlein
>>>>>
>>>>> _______________________________________________
>>>>> Babase mailing list
>>>>> Babase at www.eco.princeton.edu
>>>>> http://www.eco.princeton.edu/mailman/listinfo/babase
>>>>
>>>> -- 
>>>> Tabby Fenn
>>>> Research Assistant
>>>>
>>>> Dept of Ecology and Evolutionary Biology
>>>> 401 Guyot Hall
>>>> Princeton University
>>>> Princeton, NJ  08544
>>>>
>>>> 609 258-6898 (Ph)
>>>> 609 258-2712 (Fx)
>>>>
>>>> _______________________________________________
>>>> Babase mailing list
>>>> Babase at www.eco.princeton.edu
>>>> http://www.eco.princeton.edu/mailman/listinfo/babase
>>>
>>> --------------------------------------------------------
>>> Susan Alberts, Dept of Biology, Duke University, Box 90338, Durham 
>>> NC 27708, 919-660-7272 (Ph), 919-660-7293 (Fax)
>>>
>>>
>>>
>>>
>>> _______________________________________________
>>> Babase mailing list
>>> Babase at www.eco.princeton.edu
>>> http://www.eco.princeton.edu/mailman/listinfo/babase
>>
>

-- 
Tabby Fenn
Research Assistant

Dept of Ecology and Evolutionary Biology
401 Guyot Hall
Princeton University
Princeton, NJ  08544

609 258-6898 (Ph)
609 258-2712 (Fx)



More information about the Babase mailing list