<div class="gmail_quote">On Fri, Jan 8, 2010 at 2:35 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><div></div><div class="h5">On 01/08/2010 01:27:48 PM, Lacey Maryott Roerish wrote:<br>
> On Fri, Jan 8, 2010 at 2:22 PM, Karl O. Pinc <<a href="mailto:kop@meme.com">kop@meme.com</a>> wrote:<br>
><br>
> > On 01/08/2010 10:56:06 AM, Lacey Maryott Roerish wrote:<br>
> > > Karl,<br>
> > ><br>
> > > Susan and I did a little poking together and found some<br>
> > > problems.<br>
> > > One<br>
> > > is that the 'decided' column doesn't seem to be computed<br>
> correctly.<br>
> > > It<br>
> > > is<br>
> > > TRUE for everything... So that will need to be fixed.<br>
> ><br>
> > This is because MPIACTS.Decided is true for every row<br>
> > that ever appears as the first interaction in the<br>
> > multi-party interaction collection. This needs<br>
> > to be fixed in the data - you and I got it wrong<br>
> > somehow.<br>
> ><br>
> This doesn't make sense. I thought that 'decided' was only true if<br>
> the<br>
> interaction was initiated by a decided interaction (Only AS OS or<br>
> DS).<br>
> and<br>
> that for any MPI that was initiated by a VS or anything else, this<br>
> would be<br>
> false. is that what you are saying here and I am just dense?<br>
<br>
</div></div>That logic is fine, but that's not what the MPIACTS.Decided<br>
column values say. The data needs to be fixed.<br></blockquote><div>Right, the data in the DB is definitely wrong.. This isn't a value we manually enter, it is computed. So will that just get fixed before we do the real upload into babase, or should we empty and reload test once to make sure the program is properly interpreting the data and calculating the correct values?</div>
<div> </div><blockquote class="gmail_quote" style="margin:0 0 0 .8ex;border-left:1px #ccc solid;padding-left:1ex;">
<div class="im">><br>
> ><br>
> > I do see one problem. Do we have a rule that when the<br>
> > sequence number is one the MPIACTS code must all be<br>
> > the same? I think not, and maybe we don't care.<br>
> > But, if any one of the sequence number 1 MPIACTS codes<br>
> > have TRUE in the Decided column then the corresponding<br>
> > MPI_EVENTS.Decided column will also be true.<br>
> ><br>
> > Please think about if we want such a rule and if<br>
> > we want MPI_EVENTS.Decided to behave this way.<br>
> ><br>
> I guess I am really confused about the 'decided' information.<br>
> In terms of the MPIACTS codes matching for sequence 1... I Am also<br>
> confused.<br>
> If there are two lines sharing sequence one, the act would be the<br>
> same by<br>
> default since the program splits out those lines and not the person<br>
> entering<br>
> the data right? So the only way to have different acts in two<br>
> sequence 1<br>
> rows would be if the program screwed up... I think?<br>
<br>
</div>The upmpi program is not the only way to get the data into the<br>
database. Data can be entered manually in ppa, or with SQL statements,<br>
or changed once entered.<br></blockquote><div><br></div><div>Gotcha! It seems that we should definitely have the rule that lines sharing a sequence number must have the same act. If it isn't the same thing happening, it doesn't seem to warrant a shared sequence number. Good Call :)</div>
<div><br></div><div>Lacey</div><blockquote class="gmail_quote" style="margin:0 0 0 .8ex;border-left:1px #ccc solid;padding-left:1ex;">
<div class="im"><br>
><br>
> ><br>
> > > Also, (you may already know this but just in case) the links<br>
> > > built<br>
> > > into<br>
> > > the MPI_events documentation page (ie context_types) are broken.<br>
> They<br>
> > > currently don't go anywhere.<br>
> ><br>
> > Goes to the docs for the MPIS.Context_types column for me.<br>
> > Maybe you need to reload the page to clear the browser cache?<br>
> ><br>
><br>
> Hmm went fine on my computer. I Wonder if this is another Mac<br>
> thing.<br>
> Susan, want to re-try on your computer?<br>
<br>
</div>It's a browser thing.<br>
<div><div></div><div class="h5"><br>
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>