[Babase] ranker again

Susan Alberts alberts at duke.edu
Mon Oct 9 12:02:38 EDT 2006


Maybe we (me, Jeanne, Tabby, Leah) should just have a 5-minute phone  
call so that we can describe this to you -- it is much simpler than  
it sounds!

Jeanne, Leah and Susan are all here in one place and we could  
possibly just do this within the next 30-60 minutes if that works for  
all of us. I will check with Jeanne and Leah, Tabby please advise.

Susan
On Oct 9, 2006, at 10:38 AM, kfenn wrote:

> Catherine is correct.  She trained me to use Ranker for the latest  
> female rank update.  I am comfortable running it in the old FoxPro  
> version.....I was just not following a lot of the dialogue about  
> defining the "master-slave" relationships, and the need to manually  
> update the queries.  It sounds like a lot of the assumption and  
> inputs underlying the program are changing from the version I just  
> learned on.  Is this the case or are you just trying to get it  
> working so a version can be created for use in PPA?
>
> Tabby
>
> Catherine Markham wrote:
>> Hi all,
>>
>> I thought I'd chime in and say that I do feel comfortable using  
>> the ranker program.  Tabby and I did one full year together  
>> (updating both ALF and ADF ranks), and I did the same on my own  
>> for the previous calendar year.  Also, I did try to document the  
>> practical "how-to" in the Princeton Database Manager's Guide -  
>> hopefully that'll come in handy.
>>
>> If it is a question of how to actually use ranker and things are  
>> lacking with the write-up, just let me know and I can try to  
>> explain what was done for the past two years.
>>
>> Hope that helps,
>> Catherine
>>
>>
>>
>> Susan Alberts wrote:
>>> Karl, Leah, Tabby,
>>>
>>> There is the concern here that neither Leah nor Tabby have ever  
>>> really worked with ranker. For a long time we couldn't get ranker  
>>> to work at Duke so all of it was done at Princeton. I gather that  
>>> the last time females were done in Princeton, Catherine did them.  
>>> I don't believe that we used ranker for the males at Duke the  
>>> last time we did them -- they were done for us at Princeton, but  
>>> we have not yet (sorry to admit this) done the 2005 male ranks so  
>>> its been a while even if we did do them.
>>>
>>> I think perhaps the best thing is if Leah and Tabby get together  
>>> and see what they do and don't understand about ranker.  
>>> Presumably and hopefully ranker is well documented and presumably  
>>> Catherine and Tabby did some work on this together so we are not  
>>> starting from scratch. Given that Leah is leaving soon and we  
>>> still don't have a replacement for her, I am not sure how best to  
>>> optimize her time. Perhaps she and i can sit down today and talk  
>>> about this. We envisioned that we would have substantial overlap  
>>> but this will not happen. So, first the two of you should talk  
>>> and then Leah and I should talk and then we should go from there.
>>>
>>> Susan
>>>
>>>> Hi Susan,
>>>>
>>>> I'll go with whatever Leah says.  I've worked with ranker  
>>>> exactly once and have never considered the rules behind it and  
>>>> am only understanding about 1/4 of these emails.  If she thinks  
>>>> it's fine, then I'm sure I can learn whatever I need to learn,  
>>>> but I really don't know enough about this to give a real  
>>>> answer.  Sorry!
>>>>
>>>>
>>>> Tabby
>>>>
>>>> Karl O. Pinc wrote:
>>>>>
>>>>> On 10/06/2006 11:56:07 AM, Susan Alberts wrote:
>>>>>> Karl, should you update the rnktypes table with the new types  
>>>>>> and remove FYM or can Leah/Tabby do this at this point? I  
>>>>>> think that you need to update the definition queries? I am not  
>>>>>> sure what these are.
>>>>>
>>>>> Leah/Tabby can do it, and they can update the queries after
>>>>> each conversion run too, although I could do it also if you  
>>>>> want me
>>>>> to for some reason.
>>>>>
>>>>> By way of example, here's the old and new RNKTYPES.Query for ALF:
>>>>>
>>>>> Old:
>>>>> SELECT DISTINCT biograph.sname
>>>>>  FROM biograph, members
>>>>>  WHERE biograph.sname = members.sname
>>>>>        AND members.date >= %s
>>>>>        AND members.date <= %f
>>>>>        AND members.grp = %g
>>>>>        AND biograph.sex = "F"
>>>>>        AND NOT(EMPTY(matured))
>>>>>        AND matured <= %f
>>>>>
>>>>> New:
>>>>> SELECT DISTINCT biograph.sname
>>>>>  FROM biograph, members, maturedates
>>>>>  WHERE biograph.sname = members.sname
>>>>>        AND members.date >= '%s'
>>>>>        AND members.date <= '%f'
>>>>>        AND members.grp = %g
>>>>>        AND biograph.sex = 'F'
>>>>>        AND maturedates.sname = biograph.sname
>>>>>        AND maturedates.matured <= '%f';
>>>>>
>>>>> (Note that I have gone ahead and put some of the %
>>>>> substitutions inside single quotes because I believe
>>>>> this makes more sense and is simpler for the ranker
>>>>> program to deal with because it won't have to think
>>>>> about what datatype things are and whether or not
>>>>> it needs to put quotes around things.  The final
>>>>> design is up to Jun and Dongdong.)
>>>>>
>>>>> 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
>>>
>>>
>> _______________________________________________
>> 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. Biology, Duke University, Durham NC 27708. Phone  
919-660-7272, Fax 919-660-7293. alberts at duke.edu





More information about the Babase mailing list