<html xmlns:v="urn:schemas-microsoft-com:vml" xmlns:o="urn:schemas-microsoft-com:office:office" xmlns:w="urn:schemas-microsoft-com:office:word" xmlns:m="http://schemas.microsoft.com/office/2004/12/omml" xmlns="http://www.w3.org/TR/REC-html40">
<head>
<meta http-equiv=Content-Type content="text/html; charset=us-ascii">
<meta name=Generator content="Microsoft Word 12 (filtered medium)">
<style>
<!--
/* Font Definitions */
@font-face
        {font-family:Calibri;
        panose-1:2 15 5 2 2 2 4 3 2 4;}
@font-face
        {font-family:Tahoma;
        panose-1:2 11 6 4 3 5 4 4 2 4;}
/* Style Definitions */
p.MsoNormal, li.MsoNormal, div.MsoNormal
        {margin:0in;
        margin-bottom:.0001pt;
        font-size:12.0pt;
        font-family:"Times New Roman","serif";}
a:link, span.MsoHyperlink
        {mso-style-priority:99;
        color:blue;
        text-decoration:underline;}
a:visited, span.MsoHyperlinkFollowed
        {mso-style-priority:99;
        color:purple;
        text-decoration:underline;}
p
        {mso-style-priority:99;
        mso-margin-top-alt:auto;
        margin-right:0in;
        mso-margin-bottom-alt:auto;
        margin-left:0in;
        font-size:12.0pt;
        font-family:"Times New Roman","serif";}
span.EmailStyle18
        {mso-style-type:personal-reply;
        font-family:"Calibri","sans-serif";
        color:#1F497D;}
.MsoChpDefault
        {mso-style-type:export-only;}
@page Section1
        {size:8.5in 11.0in;
        margin:1.0in 1.0in 1.0in 1.0in;}
div.Section1
        {page:Section1;}
-->
</style>
<!--[if gte mso 9]><xml>
<o:shapedefaults v:ext="edit" spidmax="1026" />
</xml><![endif]--><!--[if gte mso 9]><xml>
<o:shapelayout v:ext="edit">
<o:idmap v:ext="edit" data="1" />
</o:shapelayout></xml><![endif]-->
</head>
<body lang=EN-US link=blue vlink=purple>
<div class=Section1>
<p class=MsoNormal><span style='font-size:11.0pt;font-family:"Calibri","sans-serif";
color:#1F497D'>Babase already says his matured date is 1997-05-01…?
How did this even throw an error about MCE’s when BOZ doesn’t have
a rnkdate? Shouldn’t it ignore males where there is no
rnkdate?? And females and juveniles for that matter since they don’t
have rnkdates… Karl does this SQL update statement do if there’s
no rnkdate? <o:p></o:p></span></p>
<p class=MsoNormal><span style='font-size:11.0pt;font-family:"Calibri","sans-serif";
color:#1F497D'><o:p> </o:p></span></p>
<p class=MsoNormal><span style='font-size:11.0pt;font-family:"Calibri","sans-serif";
color:#1F497D'>So two mounts in March 1996. Males are not supposed to get
mounts recorded until they are mature either, right? <o:p></o:p></span></p>
<p class=MsoNormal><span style='font-size:11.0pt;font-family:"Calibri","sans-serif";
color:#1F497D'><o:p> </o:p></span></p>
<p class=MsoNormal><span style='font-size:11.0pt;font-family:"Calibri","sans-serif";
color:#1F497D'>As for how it got in…wouldn’t this data have been
entered in FoxPro and converted to Babase, presumably without full Babase
controls in place? Maybe there wasn’t a rule to keep it from being
entered into FoxPro? If that’s the case then maybe we just need to
delete the erroneous mounts, yes? And fix the error message…
ha ha ha.<o:p></o:p></span></p>
<p class=MsoNormal><span style='font-size:11.0pt;font-family:"Calibri","sans-serif";
color:#1F497D'><o:p> </o:p></span></p>
<div style='border:none;border-top:solid #B5C4DF 1.0pt;padding:3.0pt 0in 0in 0in'>
<p class=MsoNormal><b><span style='font-size:10.0pt;font-family:"Tahoma","sans-serif"'>From:</span></b><span
style='font-size:10.0pt;font-family:"Tahoma","sans-serif"'>
babase-bounces@eeblistserv.Princeton.EDU
[mailto:babase-bounces@eeblistserv.Princeton.EDU] <b>On Behalf Of </b>Lacey
Maryott Roerish<br>
<b>Sent:</b> Monday, March 22, 2010 3:39 PM<br>
<b>To:</b> The Baboon Database Project<br>
<b>Subject:</b> Re: [Babase] Rankdate Changes in Babase<o:p></o:p></span></p>
</div>
<p class=MsoNormal><o:p> </o:p></p>
<p class=MsoNormal>I have now run into an even stranger error, which I think we
should try to integrate into a conference call. It looks like babase has a rule
that MCE's cannot occur before a male has reached testicular enlargment.
So, when I tried to move the dates, BOZ threw an error.<o:p></o:p></p>
<div>
<p class=MsoNormal style='mso-margin-top-alt:auto;mso-margin-bottom-alt:auto'><span
style='font-size:10.0pt;color:black'>update maturedates<br>
set matured = rnkdate(matured);</span><o:p></o:p></p>
<table class=MsoNormalTable border=0 cellpadding=0 style='background:#E6E6CC'>
<tr>
<td style='padding:0in 0in 0in 0in'>
<p class=MsoNormal style='mso-margin-top-alt:auto;margin-right:3.0pt;
mso-margin-bottom-alt:auto;margin-left:3.0pt'><b><span style='font-size:10.0pt'>SQL
error:</span></b><o:p></o:p></p>
<p class=MsoNormal style='mso-margin-top-alt:0in;margin-right:3.0pt;
margin-bottom:0in;margin-left:3.0pt;margin-bottom:.0001pt'><span
style='font-size:8.5pt'>ERROR: BOZ: 1997-05-01: Female's mounts,
consortships, and ejaculations must not come before the maturity date</span><o:p></o:p></p>
<p class=MsoNormal style='mso-margin-top-alt:auto;margin-right:3.0pt;
mso-margin-bottom-alt:auto;margin-left:3.0pt'><b><span style='font-size:10.0pt'>In
statement:</span></b><span style='font-size:10.0pt'><br>
update maturedates<br>
set matured = rnkdate(matured);</span><o:p></o:p></p>
</td>
</tr>
</table>
<p class=MsoNormal style='mso-margin-top-alt:auto'><span style='font-size:10.0pt;
color:black'> </span><o:p></o:p></p>
<p class=MsoNormal style='mso-margin-top-alt:auto;mso-margin-bottom-alt:auto;
background:#E6E6CC'><span style='font-size:10.0pt;color:black'>Lines 1-2:
ERROR: BOZ: 1997-05-01: Female's mounts, consortships, and ejaculations must not
come before the maturity date</span><o:p></o:p></p>
<div>
<p class=MsoNormal>At first I thought this was an issue with the function,
since the function is named rnkdate and we are messing with maturedates table.
However, BOZ doesn't even have a rankdate. He matured in May 1997, has NO
MCE in 1997. I looked back and he does have some M records in 1996. So, it
seems like what we are really catching here is the fact that someone data was
forced into babase and this particular error was missed later on.<o:p></o:p></p>
</div>
<div>
<p class=MsoNormal><o:p> </o:p></p>
</div>
<div>
<p class=MsoNormal>I'm also not sure why the error message is alerting us to a
problem with females havng these lines when BOZ is a male.<o:p></o:p></p>
</div>
<div>
<p class=MsoNormal><o:p> </o:p></p>
</div>
<div>
<p class=MsoNormal>Anyway, I think we did uncover another error and I think
it merits some discussion. I Am going to proceed to work on the
update until we can all talk about this. <o:p></o:p></p>
</div>
<div>
<p class=MsoNormal><o:p> </o:p></p>
</div>
<div>
<p class=MsoNormal>It looks like we already need to reschedule Thursday's as
Susan's schedule has a conflict...<o:p></o:p></p>
</div>
<div>
<p class=MsoNormal><o:p> </o:p></p>
</div>
<div>
<p class=MsoNormal>Let me know what you think<o:p></o:p></p>
</div>
<div>
<p class=MsoNormal>Lacey<o:p></o:p></p>
</div>
<div>
<p class=MsoNormal><o:p> </o:p></p>
</div>
<div>
<p class=MsoNormal>On Mon, Mar 22, 2010 at 11:00 AM, Jeanne Altmann <<a
href="mailto:altj@princeton.edu" target="_blank">altj@princeton.edu</a>>
wrote:<o:p></o:p></p>
<div>
<div>
<p class=MsoNormal style='mso-margin-top-alt:auto;mso-margin-bottom-alt:auto'><span
style='font-size:11.0pt;color:#1F497D'>Excellent, thanks Lacey</span><o:p></o:p></p>
<p class=MsoNormal style='mso-margin-top-alt:auto;mso-margin-bottom-alt:auto'><span
style='font-size:11.0pt;color:#1F497D'>jeanne</span><o:p></o:p></p>
<p class=MsoNormal style='mso-margin-top-alt:auto;mso-margin-bottom-alt:auto'><span
style='font-size:11.0pt;color:#1F497D'> </span><o:p></o:p></p>
<div style='border:none;border-top:solid #B5C4DF 1.0pt;padding:3.0pt 0in 0in 0in'>
<p class=MsoNormal style='mso-margin-top-alt:auto;mso-margin-bottom-alt:auto'><b><span
style='font-size:10.0pt'>From:</span></b><span style='font-size:10.0pt'> <a
href="mailto:babase-bounces@eeblistserv.princeton.edu" target="_blank">babase-bounces@eeblistserv.princeton.edu</a>
[mailto:<a href="mailto:babase-bounces@eeblistserv.princeton.edu"
target="_blank">babase-bounces@eeblistserv.princeton.edu</a>] <b>On Behalf Of </b>Lacey
Maryott Roerish<br>
<b>Sent:</b> Monday, March 22, 2010 10:59 AM</span><o:p></o:p></p>
<div>
<div>
<p class=MsoNormal><br>
<b>To:</b> The Baboon Database Project<br>
<b>Subject:</b> Re: [Babase] Rankdate Changes in Babase<o:p></o:p></p>
</div>
</div>
</div>
<div>
<div>
<p class=MsoNormal style='mso-margin-top-alt:auto;mso-margin-bottom-alt:auto'> <o:p></o:p></p>
<p class=MsoNormal style='mso-margin-top-alt:auto;mso-margin-bottom-alt:auto'>I
did some checking this morning and there don't seem to be glaring errors
between maturedates and rankdates tables. No maturedates occur after
rankdates(which was to be expected given babase contraints, but I just wanted
to check). All of the matdates falling in the middle of a month are equal to
their rankdates counterpart, or occur in different years, which would would
expect to see with the 'On' ranked dates.<o:p></o:p></p>
<div>
<p class=MsoNormal style='mso-margin-top-alt:auto;mso-margin-bottom-alt:auto'> <o:p></o:p></p>
</div>
<div>
<p class=MsoNormal style='mso-margin-top-alt:auto;mso-margin-bottom-alt:auto'>I
am going to go ahead and roll all maturedates back to the first, and then all
rankdates. From there we can pick at larger errors like rankdates and
ranktypes not matching up. This at least standardizes this part of it!<o:p></o:p></p>
</div>
<div>
<p class=MsoNormal style='mso-margin-top-alt:auto;mso-margin-bottom-alt:auto'> <o:p></o:p></p>
</div>
<div>
<p class=MsoNormal style='mso-margin-top-alt:auto;mso-margin-bottom-alt:auto'>Cheers<o:p></o:p></p>
</div>
<div>
<p class=MsoNormal style='mso-margin-top-alt:auto;margin-bottom:12.0pt'>Lacey<o:p></o:p></p>
<div>
<p class=MsoNormal style='mso-margin-top-alt:auto;mso-margin-bottom-alt:auto'>On
Sat, Mar 20, 2010 at 10:03 AM, Susan Alberts <<a
href="mailto:alberts@duke.edu" target="_blank">alberts@duke.edu</a>> wrote:<o:p></o:p></p>
<p class=MsoNormal style='mso-margin-top-alt:auto;mso-margin-bottom-alt:auto'>Most
maturedates that don't fall on the first of the month are 'by' dates but a
number are 'on' dates from earlier decades. These used to be done with dates
other than the first of the month -- there is nothing wrong with them, but they
can be changed.<br>
<br>
For rankdates, indeed most "on" dates are first of the month, but a
few are not. There were some instances where we actually saw the day on which
rank was attained, and entered those dates. All are from earlier decades and
all can be changed.<br>
<span style='color:#888888'><br>
Susan</span><o:p></o:p></p>
<div>
<div>
<p class=MsoNormal style='mso-margin-top-alt:auto;margin-bottom:12.0pt'><br>
<br>
On Mar 19, 2010, at 4:22 PM, Jeanne Altmann wrote:<o:p></o:p></p>
<p class=MsoNormal style='mso-margin-top-alt:auto;mso-margin-bottom-alt:auto'>Ah,
yes. I assume all of these are ‘by’ dates. If not. Something
more is wrong. Thanks for the update on progress.<br>
jeanne<br>
<br>
From: <a href="mailto:babase-bounces@eeblistserv.princeton.edu" target="_blank">babase-bounces@eeblistserv.princeton.edu</a>
[mailto:<a href="mailto:babase-bounces@eeblistserv.princeton.edu"
target="_blank">babase-bounces@eeblistserv.princeton.edu</a>] On Behalf Of
Lacey Maryott Roerish<br>
Sent: Friday, March 19, 2010 4:15 PM<br>
To: The Baboon Database Project<br>
Subject: Re: [Babase] Rankdate Changes in Babase<br>
<br>
Susan, Jeanne, Niki and Karl<br>
<br>
I am running into some problems with changing the rankdates to the
first of the month. There is a rule that the matured date has to be less
than or equal to rank date (With good reason). However, all of the maturedates
that also occur mid-month are throwing an error. So, it looks as though I will
have to roll those back as well. Will pick at this and try to fix all of the
maturedates before rolling the rankdates back.<br>
<br>
I spoke with Karl about this and there is a work-around that could
fix the majority while skipping the ones that violate this rule, but it kind of
seems like if I am going to be elbow deep in the data anyway, I should just fix
the whole problem at once. Does this fit with how princeton feels about
the timeline of this project? I expect I can have it all fixed my
mid-morning monday, I just want to do some cross-checking of maturedates and
rankdates and make sure there aren't any glaring errors before i change a whole
bunch of data in 2 tables.<br>
<br>
Let me know<br>
<br>
Lacey<br>
<br>
On Fri, Mar 19, 2010 at 3:25 PM, Jeanne Altmann <<a
href="mailto:altj@princeton.edu" target="_blank">altj@princeton.edu</a>>
wrote:<br>
<br>
<br>
-----Original Message-----<br>
From: <a href="mailto:babase-bounces@eeblistserv.princeton.edu" target="_blank">babase-bounces@eeblistserv.princeton.edu</a><br>
[mailto:<a href="mailto:babase-bounces@eeblistserv.princeton.edu"
target="_blank">babase-bounces@eeblistserv.princeton.edu</a>] On Behalf Of Karl
O.<br>
Pinc<br>
Sent: Friday, March 19, 2010 3:15 PM<br>
To: The Baboon Database Project<br>
Subject: Re: [Babase] Rankdate Changes in Babase<br>
<br>
On 03/19/2010 01:48:28 PM, Lacey Maryott Roerish wrote:<br>
> Susan, (et al)<br>
><br>
> Jeanne, Karl, Niki and I just finished discussing how
to handle<br>
> some<br>
> recent issues discovered in babase related to Rankdates. It can be<br>
> difficult to extract number of males on a given date if some males<br>
> rankdates<br>
> occur in the middle of the month. For this reason, I will be<br>
> changing all<br>
> rankdates (Both BY and ON) to the beginning on the month using a<br>
> function<br>
> Karl had previously developed. This will simply make querying<br>
> easier,<br>
> and<br>
> will also sync up rankdates data with actual rank data, which are all<br>
> recorded on the 1st of the month.<br>
<br>
We will also then put a rule in requiring that rankdates.rnkdate be<br>
on the first of the month. (Once Lacey let's me know she's done<br>
changing the data.)<br>
<br>
The problem has been that nobody ever uses the rnkdate() function,<br>
which sets a date to the first of the month, when comparing<br>
ranks.rnkdate with rankdates.ranked. They'll still have to use this<br>
function when doing arbitrary date comparisons against either<br>
ranks.rnkdate or, now, rankdates.ranked so we're not really<br>
making the problem go away, but are pushing it farther to the<br>
fringes. In any case the ranks.rnkdate/rankdate.ranked problem<br>
has been discussed every few years so it's clear there's a<br>
problem there that this change will make go away.<br>
<br>
<br>
Karl <<a href="mailto:kop@meme.com" target="_blank">kop@meme.com</a>><br>
Free Software: "You don't pay back, you pay forward."<br>
-- Robert A. Heinlein<br>
<br>
Agreed; it will remain a potentially valuable function that we need to<br>
remember the situations you note. However, with the proposed change, we<br>
will have the ranked-by date regularized, which is good, and we will<br>
make moot the most common use for the function. Thanks Karl for the<br>
patient reminder about the function and all for brainstorming on the<br>
various issues.<br>
<br>
jeanne<br>
<br>
_______________________________________________<br>
Babase mailing list<br>
<a href="mailto:Babase@www.eco.princeton.edu" target="_blank">Babase@www.eco.princeton.edu</a><br>
<a href="http://www.eco.princeton.edu/mailman/listinfo/babase" target="_blank">http://www.eco.princeton.edu/mailman/listinfo/babase</a><br>
<br>
_______________________________________________<br>
Babase mailing list<br>
<a href="mailto:Babase@www.eco.princeton.edu" target="_blank">Babase@www.eco.princeton.edu</a><br>
<a href="http://www.eco.princeton.edu/mailman/listinfo/babase" target="_blank">http://www.eco.princeton.edu/mailman/listinfo/babase</a><br>
<br>
<br>
<br>
-- <br>
- -<br>
Lacey K. Maryott Roerish<br>
Alberts Lab<br>
Department of Biology<br>
Duke University<br>
ph: 919-660-7306<br>
fax: 919-660-7293<br>
<a href="mailto:Lacey.Maryott@duke.edu" target="_blank">Lacey.Maryott@duke.edu</a><br>
_______________________________________________<br>
Babase mailing list<br>
<a href="mailto:Babase@www.eco.princeton.edu" target="_blank">Babase@www.eco.princeton.edu</a><br>
<a href="http://www.eco.princeton.edu/mailman/listinfo/babase" target="_blank">http://www.eco.princeton.edu/mailman/listinfo/babase</a><o:p></o:p></p>
<p class=MsoNormal style='mso-margin-top-alt:auto;mso-margin-bottom-alt:auto'> <o:p></o:p></p>
</div>
</div>
<div>
<p class=MsoNormal style='mso-margin-top-alt:auto;margin-bottom:12.0pt'>--------------------------------------------------------<br>
Susan Alberts, Dept of Biology, Duke University, Box 90338, Durham NC 27708,
919-660-7272 (Ph), 919-660-7293 (Fax)<br>
<br>
<br>
<br>
<o:p></o:p></p>
</div>
<div>
<div>
<p class=MsoNormal style='mso-margin-top-alt:auto;mso-margin-bottom-alt:auto'>_______________________________________________<br>
Babase mailing list<br>
<a href="mailto:Babase@www.eco.princeton.edu" target="_blank">Babase@www.eco.princeton.edu</a><br>
<a href="http://www.eco.princeton.edu/mailman/listinfo/babase" target="_blank">http://www.eco.princeton.edu/mailman/listinfo/babase</a><o:p></o:p></p>
</div>
</div>
</div>
<p class=MsoNormal style='mso-margin-top-alt:auto;mso-margin-bottom-alt:auto'><br>
<br clear=all>
<br>
-- <br>
- -<br>
Lacey K. Maryott Roerish<br>
Alberts Lab<br>
Department of Biology<br>
Duke University<br>
ph: 919-660-7306<br>
fax: 919-660-7293<br>
<a href="mailto:Lacey.Maryott@duke.edu" target="_blank">Lacey.Maryott@duke.edu</a><o:p></o:p></p>
</div>
</div>
</div>
</div>
</div>
<p class=MsoNormal style='margin-bottom:12.0pt'><br>
_______________________________________________<br>
Babase mailing list<br>
<a href="mailto:Babase@www.eco.princeton.edu" target="_blank">Babase@www.eco.princeton.edu</a><br>
<a href="http://www.eco.princeton.edu/mailman/listinfo/babase" target="_blank">http://www.eco.princeton.edu/mailman/listinfo/babase</a><o:p></o:p></p>
</div>
<p class=MsoNormal><br>
<br clear=all>
<br>
-- <br>
- -<br>
Lacey K. Maryott Roerish<br>
Alberts Lab<br>
Department of Biology<br>
Duke University<br>
ph: 919-660-7306<br>
fax: 919-660-7293<br>
<a href="mailto:Lacey.Maryott@duke.edu" target="_blank">Lacey.Maryott@duke.edu</a><o:p></o:p></p>
</div>
</div>
</body>
</html>