[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