[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