[Babase] Re: fecal tables

kfenn kfenn at princeton.edu
Tue Apr 10 09:45:52 EDT 2007


Karl,

These are tables that should become part of Babase, but this integration 
is not a high priority right now.  If we could just can put them in a 
schema, or Laurence's schema, temporarily, that would be sufficient.  
She uses these tables as a starting point for most of her queries.  The 
most efficient way for her to learn the new system is to be able to play 
with data she knows well.  Eventually, she will also need this to do 
some checking on the integrity of tables like cycles, cycstats, and 
repstats.

I am attaching the tables, as well as a little protocol info I found for 
data entry.  When it comes time to doing documentation, you will 
probably have to work directly with Laurence to interpret the tables 
because I don't know much about the hormone data.


Thanks,
Tabby


Karl O. Pinc wrote:
>
> On 04/09/2007 03:46:30 PM, kfenn wrote:
>> Hi Karl,
>>
>> I thought I send you an email about updating fecal tables for 
>> Laurence in the online babase....but I can't seem to find it in my 
>> SENT box.   I'm thinking I did something weird and never sent it.  
>> Did you get anything like that from me last week...?  If not, I will 
>> pose the question again here...
>
> I don't recall anything.
>
>>
>> How difficult is it to add some tables to babase that are Laurence 
>> has maintained in FoxPro....there are two tables and they don't link 
>> to anything but themselves, I think.
>
> There's some way to export them out of foxpro as text, but I forget
> the details.  Try looking up SELECT INTO in the foxpro docs?
> You'll want either tab delimited or csv data, not just
> sql's SELECT output.  Or maybe there's some other foxpro
> command, like COPY?
>
> I can also convert dbf to text on papio, but I'd prefer to
> convert _all_ the dbf's to text in one huge run than to work
> piecemeal.
>
> If you want them to be part of the official babase then I'd like
> to look at the table layout, document it, etc.  If all you want
> is access from papio then you can either put the tables into
> the sandbox schema yourself or I can make a schema just for
> the two tables.  The latter is probably best.  IIRC, Leah asked
> me to do the same for some of Susan's data and we created
> several schema for various hunks of data.
>
> We should really:
>
> Document those schema in the wiki.
>
> Show you and Lacey how to use your babase_admin superpowers
> to make schema for cases like this.  Oh, and then
> document that on the wiki.  :-)
>
> If it's just Laurance's stuff you can help her make tables
> in her own schema.
>
> Karl <kop at meme.com>
> Free Software:  "You don't pay back, you pay forward."
>                  -- Robert A. Heinlein
>
> _______________________________________________
> Babase mailing list
> Babase at www.eco.princeton.edu
> http://www.eco.princeton.edu/mailman/listinfo/babase

-- 
Tabby Fenn
Research Assistant

Dept of Ecology and Evolutionary Biology
401 Guyot Hall
Princeton University
Princeton, NJ  08544

609 258-6898 (Ph)
609 258-2712 (Fx)



More information about the Babase mailing list