[Babase] New conversion run

kfenn kfenn at princeton.edu
Fri Dec 22 14:17:00 EST 2006


Oh, Yeah. Those are two I need Susan to review, but I waited too long 
and Jeanne said she was away from the data this week. Anyway, here they 
are for Susan when the data is accessible again.

Karl, you may want to look at my notes on the errors too because each 
has a little programming piece I don't fully understand.


Tabby

psql:<stdin>:2109: ERROR: MCC: 1990-01-29: Statdate of live individuals 
must be = 1993-09-30, the last census date

Known error waiting for Susan’s review

I can only find a single paper record of McCoy around the time of the 
error. He shows up in Kojack’s group census dated 1990-01-05. After 
that, I can’t find any paper records for Kojack’s group at all, although 
in the census table, he continues to show up in Kojack’s group until 
1993-09-30. This is what is generating the error

The census table has a transition between a status of S (SUSAN) to a 
status of E (Ending date) on the census day 1990-01-05. *This seems to 
be a question that only Susan can resolve. *According to the* 
*documentation for “Data Management Systems”, the data in Census marked 
S come from Susan’s DISPERSE database. By running the program 
“buildmembers” in FoxPro, the statdate should have been automatically 
updated from the census table to biograph, I believe. However, perhaps 
there is a programming rule to prohibit this update when the status is 
something other than “C” or “A”...?


psql:<stdin>:126: ERROR: WAR: BIOGRAPH.Statdate cannot be less than 
(before) RANKDATES.Ranked

Known error waiting for Susan’s review

Susan said to give him a ranked by date = 1977-01-19, the day he 
immigrated. There is no record of him in the Ranks table and no data 
filled in for the “RANKED” column in the Biograph table....so how the 
statdate be less than a non-existent rank date? I’m not sure what to 
make of this error. There are other individuals who have no ranking and 
no rankdate, but they did not show up as errors.

*Karl may have to take a look at this if it doesn't make sense to Susan 
either. *

Note that Jeanne still needs to confirm this male was an adult at the 
time monitoring began.






Karl O. Pinc wrote:
> FYI: Here's the (good) error messages so far.
>
> ### Add 5359253 to the error messages' source line number
> psql:<stdin>:2109: ERROR: MCC: 1990-01-29: Statdate of live 
> individuals must be = 1993-09-30, the last census date
> ### Add 5366036 to the error messages' source line number
> psql:<stdin>:126: ERROR: WAR: BIOGRAPH.Statdate cannot be less than 
> (before) RANKDATES.Ranked
>
> 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

-- 
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