[Babase] planning for Babase demog update
Karl O. Pinc
kop at meme.com
Wed Apr 25 14:07:18 EDT 2007
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
More information about the Babase
mailing list