[Babase] Re: fecal tables
Susan Alberts
alberts at duke.edu
Tue Apr 10 10:04:55 EDT 2007
Tabby, you will find that you won't be able to send attachments to
the babase mailing list. Perhaps attach in a separate email to Karl.
FYI, Leah did this for me for a number of tables last year -- I had
several old foxpro databases (paternal sisters behavior, male
behavior, etc) that needed to be imported into postgresql. She (or
Karl) made a schema for each one in the babase database (called
sca_mbehav_8791, patsis_ksmith, and malepace, you can see them
there). Then I believe she just exported them from foxpro as
delimited files (tab or csv), and created tables in the new schemas
into which she imported them. It just took a few minutes. The fecal
tables could go in LG's schema or have a new schema.
Susan
On Apr 10, 2007, at 9:51 AM, kfenn wrote:
> Oh, yeah...the attachment
>
> 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)
>
> <Babase_fecal.zip>
> _______________________________________________
> Babase mailing list
> Babase at www.eco.princeton.edu
> http://www.eco.princeton.edu/mailman/listinfo/babase
-----------------------------------------------
Susan Alberts, Dept. Biology, Duke University, Durham NC 27708. Phone
919-660-7272, Fax 919-660-7293. alberts at duke.edu
-------------- next part --------------
An HTML attachment was scrubbed...
URL: http://www.eco.princeton.edu/pipermail/babase/attachments/20070410/aed89cad/attachment.html
More information about the Babase
mailing list