Karl,<div><br></div><div> I started trying to upload these and got this error:</div><div><span class="Apple-style-span" style="font-family: 'Times New Roman'; font-size: medium; "><em class="error" style="color: red; background-color: inherit; ">ERROR: INTERACT 829479: DS: 2009-08-11: 11:11:28: 11:11:28: Agonism and grooming start and stop times must be NULL when there's no Sid</em></span></div>
<div><span class="error" style="background-color: inherit; "></span><font class="Apple-style-span" color="#FF0000" face="'Times New Roman'"><span class="Apple-style-span" style="font-size: medium;"><i> <br></i></span></font><br>
</div><div>I can see why we would have set up this control.. but what do we do now? Susan, any input?</div><div><br></div><div>Cheers</div><div>Lacey</div><div><br><div class="gmail_quote">On Tue, Jun 29, 2010 at 8:39 PM, Karl O. Pinc <span dir="ltr"><<a href="mailto:kop@meme.com">kop@meme.com</a>></span> wrote:<br>
<blockquote class="gmail_quote" style="margin:0 0 0 .8ex;border-left:1px #ccc solid;padding-left:1ex;"><div class="im">On 06/29/2010 07:32:40 PM, Karl O. Pinc wrote:<br>
</div><div class="im">> On 06/29/2010 05:23:46 PM, Lacey Maryott Roerish wrote:<br>
</div><div class="im">> > The files I will be uploading have the following columns:<br>
> > date, actor, actee, act, start<br>
> ><br>
> > Should I add a stop column and just leave it blank?<br>
><br>
> My approach would be to add and stop column and copy (by<br>
> cell reference) the start column into it so they're always<br>
> the same. But I'd also want to at least consult with Susan.<br>
<br>
</div><div class="im">Ok. I was looking in the wrong place. If you look<br>
at the "initial description" of the INTERACT_DATA table<br>
you will see all the rules that have to do with more than<br>
one column or with relationships to other tables. In there<br>
it says that the start time must equal the stop time.<br>
<br>
So, that's what we should do.<br>
<br>
But, you'll have to do this manually per above. The<br>
view won't do it for you.<br>
<br>
<br>
<br>
</div><div><div></div><div class="h5">Karl <<a href="mailto:kop@meme.com">kop@meme.com</a>><br>
Free Software: "You don't pay back, you pay forward."<br>
-- Robert A. Heinlein<br>
<br>
<br>
_______________________________________________<br>
Babase mailing list<br>
<a href="mailto:Babase@www.eco.princeton.edu">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>
</div></div></blockquote></div><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">Lacey.Maryott@duke.edu</a><br>
</div>