<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:11.0pt;
        font-family:"Calibri","sans-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.MsoListParagraph, li.MsoListParagraph, div.MsoListParagraph
        {mso-style-priority:34;
        margin-top:0in;
        margin-right:0in;
        margin-bottom:0in;
        margin-left:.5in;
        margin-bottom:.0001pt;
        font-size:11.0pt;
        font-family:"Calibri","sans-serif";}
span.EmailStyle18
        {mso-style-type:personal;
        font-family:"Calibri","sans-serif";
        color:windowtext;}
span.EmailStyle20
        {mso-style-type:personal-reply;
        font-family:"Calibri","sans-serif";
        color:#1F497D;}
.MsoChpDefault
        {mso-style-type:export-only;
        font-size:10.0pt;}
@page WordSection1
        {size:8.5in 11.0in;
        margin:1.0in 1.0in 1.0in 1.0in;}
div.WordSection1
        {page:WordSection1;}
 /* List Definitions */
 @list l0
        {mso-list-id:88042884;
        mso-list-type:hybrid;
        mso-list-template-ids:1681177914 67698705 67698713 67698715 67698703 67698713 67698715 67698703 67698713 67698715;}
@list l0:level1
        {mso-level-text:"%1\)";
        mso-level-tab-stop:none;
        mso-level-number-position:left;
        text-indent:-.25in;}
@list l0:level2
        {mso-level-tab-stop:1.0in;
        mso-level-number-position:left;
        text-indent:-.25in;}
@list l0:level3
        {mso-level-tab-stop:1.5in;
        mso-level-number-position:left;
        text-indent:-.25in;}
@list l0:level4
        {mso-level-tab-stop:2.0in;
        mso-level-number-position:left;
        text-indent:-.25in;}
@list l0:level5
        {mso-level-tab-stop:2.5in;
        mso-level-number-position:left;
        text-indent:-.25in;}
@list l0:level6
        {mso-level-tab-stop:3.0in;
        mso-level-number-position:left;
        text-indent:-.25in;}
@list l0:level7
        {mso-level-tab-stop:3.5in;
        mso-level-number-position:left;
        text-indent:-.25in;}
@list l0:level8
        {mso-level-tab-stop:4.0in;
        mso-level-number-position:left;
        text-indent:-.25in;}
@list l0:level9
        {mso-level-tab-stop:4.5in;
        mso-level-number-position:left;
        text-indent:-.25in;}
ol
        {margin-bottom:0in;}
ul
        {margin-bottom:0in;}
-->
</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=WordSection1>

<p class=MsoNormal><span style='color:#1F497D'>Jeanne thinks 1 is best.&nbsp; (2 is
clunky and 3 is bad)<o:p></o:p></span></p>

<p class=MsoNormal><span style='color:#1F497D'><o:p>&nbsp;</o:p></span></p>

<p class=MsoNormal><span style='color:#1F497D'>If that&#8217;s okay by Susan as well,
Karl please remove the not-null constraint on the comment column in demog.&nbsp;
Then the upload can commence.<o:p></o:p></span></p>

<p class=MsoNormal><span style='color:#1F497D'><o:p>&nbsp;</o:p></span></p>

<p class=MsoNormal><span style='color:#1F497D'>Thanks!<o:p></o:p></span></p>

<p class=MsoNormal><span style='color:#1F497D'>Niki<o:p></o:p></span></p>

<p class=MsoNormal><span style='color:#1F497D'><o:p>&nbsp;</o:p></span></p>

<div>

<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>Niki
Learn<br>
<b>Sent:</b> Friday, September 03, 2010 4:26 PM<br>
<b>To:</b> 'The Baboon Database Project'<br>
<b>Subject:</b> [Babase] Update trouble - Demog notes cannot have no note (no
nulls allowed)?<o:p></o:p></span></p>

</div>

</div>

<p class=MsoNormal><o:p>&nbsp;</o:p></p>

<p class=MsoNormal>I am working on the upload in test and have just come to the
demography notes portion.&nbsp; Demography notes also include census entries
and other groups notes entries on nonstudy groups, where often the &#8220;note&#8221; would
just consist of &#8220;so-and-so is present in such-and-such group&#8221;.<o:p></o:p></p>

<p class=MsoNormal><o:p>&nbsp;</o:p></p>

<p class=MsoNormal>At the joint lab meeting we talked extensively about some
revisions to how we enter demography notes and what actually counts as a
demography note.&nbsp; One of the things we discussed was that these notes
should be as un-wordy as possible and that the ones that just say things like
&#8220;so-and-so is present in such-and-such group&#8221;, which is already captured in the
census record the demography note creates, that we didn&#8217;t have to have any
words because they were redundant.&nbsp; So I implemented that for this upload
and, just on the first group, got this error 9 times:<o:p></o:p></p>

<p class=MsoNormal><o:p>&nbsp;</o:p></p>

<p class=MsoNormal>CAUTION -- This error may not be real; prior row(s) of the
uploaded file were rejected:<br>
Line 17: <em><span style='font-family:"Calibri","sans-serif"'>ERROR: null value
in column &quot;comment&quot; violates not-null constraint<o:p></o:p></span></em></p>

<p class=MsoNormal><em><span style='font-family:"Calibri","sans-serif"'><o:p>&nbsp;</o:p></span></em></p>

<p class=MsoNormal><em><span style='font-family:"Calibri","sans-serif";
font-style:normal'>So, the note can&#8217;t be blank&#8230;&nbsp; I see three possible
options<o:p></o:p></span></em></p>

<p class=MsoNormal><em><span style='font-family:"Calibri","sans-serif";
font-style:normal'><o:p>&nbsp;</o:p></span></em></p>

<p class=MsoListParagraph style='text-indent:-.25in;mso-list:l0 level1 lfo2'><![if !supportLists]><span
style='mso-list:Ignore'>1)<span style='font:7.0pt "Times New Roman"'>&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;
</span></span><![endif]>Remove the rule saying that the comment column (the
actual note) cannot be null.&nbsp; (This seems simplest.)<o:p></o:p></p>

<p class=MsoListParagraph style='text-indent:-.25in;mso-list:l0 level1 lfo2'><![if !supportLists]><span
style='mso-list:Ignore'>2)<span style='font:7.0pt "Times New Roman"'>&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;
</span></span><![endif]>Go back to &#8220;so-and-so is present in such-and-such
group&#8221;.&nbsp; (Perhaps preferred &nbsp;for some reason?)<o:p></o:p></p>

<p class=MsoListParagraph style='text-indent:-.25in;mso-list:l0 level1 lfo2'><![if !supportLists]><span
style='mso-list:Ignore'>3)<span style='font:7.0pt "Times New Roman"'>&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;
</span></span><![endif]>Or I could enter those other groups entries the way we
enter census data &#8211; it just might have a lot of &#8220;N&#8221; entries in the file I
upload (but babase reads &#8220;N&#8221; as &#8220;don&#8217;t create a record for this animal on this
date&#8221; so it wouldn&#8217;t create extra records or anything like that).&nbsp; The
downside there being that if there were actual demography notes to go with any
of them I would need a census record and a demography note but it comes out the
same in babase.&nbsp; Also, entering them as demog notes tells you the
reference source (i.e., is there an actual census sheet in the other groups
binder or is it an other groups note within one of the study group binders and
which study group is it with).<o:p></o:p></p>

<p class=MsoNormal><o:p>&nbsp;</o:p></p>

<p class=MsoNormal>Thoughts?<o:p></o:p></p>

<p class=MsoNormal><o:p>&nbsp;</o:p></p>

<p class=MsoNormal>Thanks,<o:p></o:p></p>

<p class=MsoNormal>Niki <o:p></o:p></p>

<p class=MsoNormal><o:p>&nbsp;</o:p></p>

<p class=MsoNormal><o:p>&nbsp;</o:p></p>

</div>

</body>

</html>