[Babase] planning for Babase demog update

Lacey Maryott lacey.maryott at duke.edu
Wed Apr 25 14:10:04 EDT 2007


Ok, I gotcha, sorry I understand what is happening.  The update 
statement was sent to me, and I was just waiting to talk with Leah about 
backing up or something.  This is something I would feel much more 
comfortable doing with Leah around then flying solo! Sorry for the 
misunderstanding on my end!   I Was referring to grooming.

sorry again,

Lacey

Karl O. Pinc wrote:
>
> On 04/25/2007 12:53:03 PM, Lacey Maryott wrote:
>> Karl,
>>  I think we miscommunicated, dates from 11-1993  to 09-1999 (sorry i 
>> said 1994-1998) will already all be  entered on the first.  but 
>> before 11-1993 and after sept 1999 through dec 2005, everything with 
>> the exception of Psion should be forced to the first.  Right?  I'm 
>> sorry if I communicated that unclearly over the phone.
>
> I'm primarly interested in what rules to give the new Babase.
> I'd like you folks to be in charge of the data.  I _can_ have
> the conversion program do the data fiddling, but I'd rather
> just work with you so you can change the data as desired.
> There's lots of reasons, including recordkeeping, backups, and so
> forth.  If you need my help to come up with an update
> statement to force all the dates to the first of the
> month let me know.  (I recall working with somebody
> to come up with the right statement, but I don't remember
> who, when, or if it was on the list so we can just do
> it again need be.  Anybody besides me recall this?)
>
> You're talking grooming above, right?  If so then
> we've got our date ranges right and are just talking
> about who does what.  Yes?
>
>> Lacey
>>
>> Karl O. Pinc wrote:
>>>
>>> On 04/25/2007 10:29:16 AM, Karl O. Pinc wrote:
>>>>
>>>> On 04/25/2007 09:59:59 AM, kfenn wrote:
>>>>> ...  One more conversion after we make corrections, and I think 
>>>>> will we have the clean database we need to transition to doing 
>>>>> updates in PPA.  Does this sound correct or am I missing some pieces?
>>>>
>>>> I need the final word on when grooming must be the first of the
>>>> month and when not.
>>>
>>> Just spoke with Lacey.  For the record, here's the final word.
>>>
>>> Pision data:
>>> Regardless of whether it's agnonism or grooming, the date
>>> is exact.  The rules below apply only to non-psion data.
>>>
>>> Grooming:
>>> Before 1996-01-01 the database will require the dates to be the
>>> first of the month.  On or after that day they can be any date.
>>>
>>> Agonisim:
>>> Before 1995-01-01 the database will require the dates
>>> to be the first of the month.  On or after that day they
>>> can be any date.
>>>
>>> You guys will have to update the dates in the foxpro
>>> database to conform to the rules or we'll get gobs of
>>> conversion errors.  You should be able to easily
>>> do this with an update statement.
>>> (Don't forget to keep a backup!)
>>>
>>> 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
>>>
>>
>> --Lacey Maryott
>> Department of Biology
>> Duke University
>> ph: 919-660-7306
>> fax: 919-660-7293
>> Lacey.Maryott at duke.edu
>> _______________________________________________
>> Babase mailing list
>> Babase at www.eco.princeton.edu
>> http://www.eco.princeton.edu/mailman/listinfo/babase
>>
>
> 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
>

-- 
Lacey Maryott
Department of Biology
Duke University
ph: 919-660-7306
fax: 919-660-7293
Lacey.Maryott at duke.edu 



More information about the Babase mailing list