[Babase] ranker again

kfenn kfenn at princeton.edu
Mon Oct 9 10:38:07 EDT 2006


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)



More information about the Babase mailing list