[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