[Babase] New conversion run

Karl O. Pinc kop at meme.com
Fri Dec 22 15:06:08 EST 2006


On 12/22/2006 01:17:00 PM, kfenn wrote:
> 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.

I think you and I can work them out and Susan does not need to
review them.

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

  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”...?

Buildmembers builds the members table from census, but does not
update biograph.statdate.  The only thing that updates
biograph.statdate is upcen, and only then (I think)
if the newly input census rows are after the existing statdate.

So, you'll need to manually set the right statdate.

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

The problem is that foxpro has no "by" date for rankdate.
So, we long ago made a separate file containing the desired
"by" dates.  This was not updated (obviously).

I've updated the entry for WAR.  Here's a copy of the
updated file for your review.  (The change won't appear in the
conversion running now so we're getting the same error until the
_next_ time we run the conversion.)

SNAME   RANKED
ABE     25/03/1996
ALY     04/04/1978
AMA     17/04/1996
AMI     24/08/1994
AMO     19/05/2003
ANU     04/01/1992
APH     23/12/1996
APO     18/11/2003
ARS     07/02/2004
BAR     01/01/1977
BEA     01/09/1996
BEN     01/01/1975
BJX     01/07/1971
BLA     15/06/1977
BLU     14/07/2001
BON     19/12/1982
BOR     17/02/1983
CHI     01/08/1973
CLE     12/06/1983
COW     01/07/1971
CRE     01/07/1971
CUI     28/10/1986
DAL     07/11/1998
DAR     19/12/1982
DEN     28/12/1990
DEP     14/02/2001
DES     10/10/1994
DIS     14/09/1989
DIX     25/09/1984
DOB     29/04/1988
DOG     01/01/1979
DOR     30/11/1982
DOW     09/03/1997
DUT     01/07/1971
EBA     21/10/2003
EDW     24/08/1994
EVE     01/01/1975
FAT     12/08/1988
FAV     01/05/1990
FIM     01/03/2002
FUP     02/12/1989
GAN     07/12/2004
GAS     19/10/1996
GOD     24/08/1992
GOL     26/06/1986
GYP     24/11/2003
HAP     10/09/2001
HAR     01/09/1980
HEN     05/08/1996
HIT     01/07/1972
HOB     05/09/1989
HUX     05/08/1988
HYR     18/08/2000
IAG     25/12/1998
IBI     06/01/1979
ICA     20/10/1998
ICO     05/06/1999
IMA     19/08/1998
IND     06/05/1999
IPO     03/02/1999
ISA     20/11/1985
ISR     19/05/2003
IVA     01/07/1971
JAG     06/10/2003
JIT     28/09/1992
KAA     20/11/1984
KAD     02/04/1991
KAK     01/06/1987
KAR     06/04/1991
KEI     09/02/1991
KHA     08/10/1999
KIL     04/12/1999
KIM     17/02/1984
KIR     11/06/1985
KOJ     04/04/1980
KON     22/04/1981
KRA     19/11/2002
KUS     25/12/1978
LEM     01/02/1990
LEO     18/02/1982
LER     13/09/1980
LIP     01/01/1977
LUG     25/07/2001
MAN     06/08/1984
MAX     01/07/1971
MCC     26/04/1985
MIK     01/06/1982
MLI     03/12/1986
MLO     07/10/1995
MOR     08/10/1997
NAV     24/01/2001
NEC     30/07/1977
NEL     02/11/1986
NGU     25/09/1984
NOA     27/08/1996
NOL     08/10/1982
NUG     25/09/1984
NUM     27/07/2003
OBR     09/01/2004
OME     07/12/1980
ORB     26/12/1997
ORN     13/05/2003
PAS     30/09/1992
PET     01/07/1971
PIS     28/05/1996
PIU     03/01/1991
PLA     27/01/1997
POL     01/08/1990
QUA     19/01/2004
RAD     25/09/1984
RED     11/08/1975
REX     11/09/2000
ROC     21/12/1993
RUS     11/12/1975
SAW     26/07/2002
SEK     01/01/1977
SHE     12/03/1988
SHO     17/02/1984
SHY     21/12/1999
SIN     01/07/1971
SLA     02/08/1986
SLK     01/09/1980
SLM     01/09/1973
SPY     03/10/1992
STB     01/07/1971
STU     01/06/1976
STY     29/09/1981
SUJ     19/09/2000
TAL     28/09/2000
TET     29/04/1978
THO     09/04/1987
TIN     11/03/1999
TOT     01/01/1978
TUL     25/09/1984
TUZ     12/07/1992
TYC     20/12/1987
VAZ     03/10/2002
VEC     01/09/1987
VEG     17/06/1996
VIL     21/10/2001
WAR     19/01/1977
WEU     02/12/2003
WID     01/01/2001
WLK     06/06/1980
WYM     01/09/1980
XEN     23/05/1978
YOY     18/05/1999
ZAI     14/11/1999
ZAP     11/10/1999
ZEN     23/11/1996
ZIG     23/12/2002
ZIN     05/10/1999
ZIO     01/03/2002
ZUK     14/11/1999

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

Karl <kop at meme.com>
Free Software:  "You don't pay back, you pay forward."
                  -- Robert A. Heinlein



More information about the Babase mailing list