[Babase] planning for Babase demog update

Lacey Maryott lacey.maryott at duke.edu
Wed Apr 25 13:53:03 EDT 2007


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. 

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 



More information about the Babase mailing list