[Babase] Re: fecal tables
Susan Alberts
alberts at duke.edu
Tue Apr 10 10:23:58 EDT 2007
Follow - up -- there is a section on importing tables from csv files
in the "SQL Language for Babase" booklet that Leah wrote, which is
now on the wiki.
Susan
On Apr 10, 2007, at 10:04 AM, Susan Alberts wrote:
> 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
>
>
>
> _______________________________________________
> 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/c2d0fa64/attachment-0001.html
More information about the Babase
mailing list