[Babase] how to - 07a update in Babase 2.0
kfenn
kfenn at princeton.edu
Tue Dec 18 13:43:01 EST 2007
Hi Karl,
I'm in the final stages of culling data from our binders for the 2007a
demography update. I will be doing the update for the first time in
Babase 2.0 and will be making everything up as I go along since there is
no set protocol yet. Below I've outlined everything we did in FoxPro
system, the order in which we did it, and the programs/process we used.
I'm assuming the order of input has to be maintained, unless you tell me
otherwise. Now I need a new method for all the different inputs in
Babase 2.0. I've outline the input methods I think I should use, and
I'll need your feedback on whether I've got it right or not, or in some
cases you'll have to fill in the blanks for me. A phone call on all this
in probably needed, but I thought composing this would give us a good
starting point.
Reproductive Cycles data
Prepare cycles sub-tables ( Ex:Vcyc06a) (Bb 2.0 - prepare excel sheets
and export into csv or tab delimited format for upload)
Manually enter puberty dates into BIOGRAPH table (Bb 2.0 - use UPDATE
command for each record in biograph?)
Validate cycles sub-table (do Valcycles) (Bb 2.0 - cannot validate
before upload, but UPLOAD program will give error messages?)
Upload cycles sub-table to master CYCLES table (do Upcen) (Bb 2.0 use
UPLOAD program to append to mtd_cycles view?)
Pregs data
Once cycles are loaded, cids are available for each pregnancy so
Fill in cids for all Z dates on summary sheets (Bb 2.0 - I think the
cids are now the tcpids and dcpids in the mtd_cycles view)
Prep pregs sub-tables leaving Resume field blank (Ex:Vp06a) (Bb 2.0 -
prep excel table and export to csv or tab delimited)
Append sub-table to master PREGS table (Bb 2.0 - use UPLOAD program to
append to pregs table?)
Biograph data
Prep sub-table with ‘new’ entries births, immigrant M, aborts
(Ex:Vbr06a) (Bb 2.0 - prep excel table and export to csv or tab delimited)
Append sub-table to master BIOGRAPH table (Bb 2.0 - use UPLOAD program
to append to biograph table)
Manually enter Death data to BIOGRAPH fields: statdate, Dcause, status
(Bb 2.0 - use UPDATE command for each record in biograph?)
Census data
Enter census (5 primary groups) data to sub-tables (Vn0106, Vn 0206,
Vn0306, Vn0406, Vn0506, Vn0606)
Enter demog notes for the group to subtable (Ex:Vd06a)
Enter Other Group census into a single subtable (Ex:Gd06a)
Validate census for 5 primary groups (Bb 2.0 - UPLOAD program should
catch errors and report them?)
Upload census for 5 primary groups (Bb 2.0 - prep in excel, export as
tab delimited, use CENSUS program to append to the census table
Validate demog info for 5 primary groups
Update demog info for 5 primary groups
Validate & update Other Group info
Cycstats, Repstats, Members
Rebuild Cycstats and Repstats manually (Do Makerep)(Bb 2.0 - not sure of
new procedure, but I think its in documentation...Help!)
Members may be automatically rebuild or require manual (do Buildmembers)
(Bb 2.0 - Help again!)
Biograph: Matured dates for males
Manually enter matured dates for natal & immigrant males to BIOGRAPH (Bb
2.0 - use UPDATE command for each record)
Biograph: Dispersal dates
Manually enter dispersal dates for natal & immigrant males to BIOGRAPH
(Bb 2.0 - use UPDATE command for each record)
Thanks,
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