[Babase] [Fwd: Re: more information that I need]
Leah Gerber
lgerber at duke.edu
Wed Aug 30 11:18:18 EDT 2006
-------- Original Message --------
Subject: Re: more information that I need
Date: Fri, 25 Aug 2006 12:39:03 -0400
From: Leah Gerber <lgerber at duke.edu>
To: patchu at itsyourturn.com
References: <HNEJJMICBFCMONFLODLEEEEHIEAC.patchu at itsyourturn.com>
I just spoke with Susan and she is inclined to not have checks at this
level as it will be duplicated with the triggers (to the best of our
understanding). If for some reason the triggers do not end up working as
we believe they are set up to then we may want these checks inserted at
a later time. Thanks
Leah
Patrick Chu wrote:
> The reason for a list of 3-letter codes is that I can flag an invalid
> 3-letter code as a "mistake" before the insert attempt is make. But it's
> probably unlikely that TWO people would enter the same mistake? Still, it
> might save the verifier some time if we were to show the baboon's full name
> next to the 3-letter codes, right on the verification page.
>
> Just a thought, not strictly necessary.
>
>
> -----Original Message-----
> From: Leah Gerber [mailto:lgerber at duke.edu]
> Sent: Friday, August 25, 2006 10:44 AM
> To: patchu at itsyourturn.com; alberts >> Susan Alberts
> Subject: Re: more information that I need
>
>
> Patrick Chu wrote:
>
>> Leah,
>>
>> If those other files come in, please email them to me. You can email me
>>
> old
>
>> files too if you have them around.
>>
>>
> I will try to enter a few for you. We delete the B copy when we are done
> with them so no old ones are lying around.
>
>> Is there a list of all valid three-letter codes for each baboon somewhere
>>
> in
>
>> the database?
>>
>>
> There is no specific list of three letter names. The BIOGRAPH table has
> one row for every baboon so that is the easiest way to pull out all of
> the names.
> Just curious why you would need this. This list changes every few
> months, so we would not want this set in the program. I can send you a
> semi recent list if you want it. Also, for the acts, I am wondering why
> we would need this information in the compare procedure when the
> triggers are all set up in the database already. I exported the ACTS
> support table from the database and attached it as an excel file. This
> one is unlikely to change. I just thought of one thing, the grooming
> file I gave you does not have a column for act "G". We had planned on
> incorporating this but Karl's import program needed to be changed before
> we could. So, if it is easier for you we can easily add an act column to
> grooming. All of the rows will be "G". Let me know if you need more
> information. I will gladly extract the baboon names if it is necessary
> and makes sense to use them.
>
>> Also, could you summarize the input formats of the 3 types of Excel files,
>> and where that information gets inserted into which tables? I have some
>> sketchy notes here.
>>
>> I have the letters A, G, E, M, and C. Can you tell me the labels for each
>> letter? I know the A = agonisms and G = grooming.
>>
>> Also, can you give me a list of the codes for the possible acts? Is this
>>
> in
>
>> a database table somewhere?
>>
>> Can you tell me if the act codes and baboon IDs are in the database
>> somewhere? If so, is it possible to get a full or partial copy of those
>> tables? Exporting it to a text file (any format) is sufficient, although
>>
> an
>
>> Excel file would be even better.
>>
>> Thanks for your help.
>>
>>
>>
>
>
>
More information about the Babase
mailing list