[Babase] final errors and prep of PPA update programs
kfenn
kfenn at princeton.edu
Wed Mar 7 11:59:41 EST 2007
Hi Karl,
Leah and I agreed that I would try and correct the last few ranks errors
this week and then give the database to her for 2006A updates this
weekend. At that time I will run the dumptext program like we discussed
on Fri. Does this sound OK? Is there any reason we can't run another
conversion this Thursday when I finish?
After this I'll be needing to work with you on the update programs for
PPA. Below is a summary of what I update and my current method in
FoxPro, just to get us started. Repstats/Cycstats, Members and Census
updates are already working, right? So maybe F Repro Cycles, and Demog
update programs are next ...?
Maturity (Puberty) date ( F)
entered manually directly into the BIOGRAPH table
Female reproductive cycles
'cycle' (mtd) dates entered into a .dbf table by group. Valcycle
and Upcycle used to validate and upload to Babase
Pregnancy (conception) dates
conception dates entered into a .dbf table. Dbf table manually
proofed and appended to PREGS
'New' individuals (infants, immigrant males, aborts/stillbirths)
All relevant BIOGRAPH field data entered into .dbf table, manually
proofed and appended to BIOGRAPH. (this includes immigrant male birthdates)
Death dates
entered manually directly into the BIOGRAPH table (relevant fields
are statdate, dcause, status)
Census data (for 5 primary groups)
entered into .dbf table by group. Validate using valcen, upload to
Babase using upcen.
Demography data
5 primary groups entered into one .dbf tables by group for the
entire 6 month period. Validate using valdemog, upload to Babase using
updemog
All other groups demog info entered one .dbf table for the 6 month
period. Validate using valdemog, upload using updemog
Maturity (Puberty) date (M)
entered manually directly into the BIOGRAPH table
Dispersal date (natal and immigrant M)
entered manually directly into the BIOGRAPH table
Update/Rebuild Cycstats/Repstats
do Makerep
Update/Rebuild Members
do buildmembers
Did I miss anything?
Tabby
--
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)
More information about the Babase
mailing list