[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