[Babase] Results of comparetables on PREGS

Karl O. Pinc kop at meme.com
Thu May 31 16:21:23 EDT 2007


Hi,

Here's the Babase 1.0/Babase 2.0 comparison
for PREGS after I've fixed the conversion code.

This gets rid of the problem of "lost" Resume dates.

What's left seems to fall into two catagories:

New Ddates, which hopefully are the estimated
Ddates.

Places where the system has assigned a Resume
date but there was no Resume date in foxpro.

pregs.TXT
--- /var/tmp/foxsource.10955	2007-05-31 16:15:34.000000000 -0400
+++ /var/tmp/postsource.10955	2007-05-31 16:15:34.000000000 -0400
@@ -9,8 +9,8 @@
  ALI1 1 1981-06-11 1982-11-29
  ALI2 2 1984-06-23 1984-10-04
  ALI3 3 1985-03-05 1986-06-08
-ALT101 101
-ALT102 102
+ALT101 101 1968-01-05
+ALT102 102 1970-02-19
  ALT103 103 1972-12-23 1974-06-11
  ALT104 104 1974-06-29
  ASH1 1 1996-07-31 1997-09-23
@@ -40,8 +40,8 @@
  BRU1 1 1974-05-23 1974-12-11
  BRU2 2 1975-02-21 1977-01-02
  BRU3 3 1977-04-08
-BUN101 101
-BUN102 102
+BUN101 101 1983-03-07
+BUN102 102 1984-11-10
  CAB1 1 2004-03-07 2005-08-05
  CAB2 2 2006-06-18
  CAI1 1 2002-04-27 2003-10-22
@@ -70,7 +70,7 @@
  COB1 1 2001-03-06 2002-12-17
  COB2 2 2003-06-18 2005-04-01
  COB3 3 2005-06-15 2006-09-10
-DAD1 1 1985-07-08
+DAD1 1 1984-06-21 1985-07-08
  DAD10 10 1994-02-08 1994-12-11
  DAD11 11 1995-04-07 1996-02-20
  DAD12 12 1996-03-26 1997-04-23
@@ -157,14 +157,14 @@
  ENO4 4 1987-05-25 1988-10-09
  ENO5 5 1989-02-05 1989-11-22
  ENO6 6 1990-02-23
-EST101 101
+EST101 101 1970-01-04
  EST102 102 1972-01-05 1972-10-08
  EST103 103 1973-01-21 1974-06-19
  EST104 104 1974-10-21 1976-04-25
  EST105 105 1976-07-14 1977-12-23
  EST106 106 1978-01-06
-ETA101 101
-ETA102 102 1982-01-08
+ETA101 101 1975-07-26
+ETA102 102 1980-12-03 1982-01-08
  ETA103 103 1982-07-07 1984-12-07
  EVA1 1 2005-09-10
  FAC1 1 1998-01-26 1999-08-19
@@ -192,7 +192,7 @@
  FLA1 1 2002-02-22 2002-12-16
  FLA2 2 2003-05-14 2005-04-12
  FLA3 3 2005-09-25
-FLU101 101 1971-08-18
+FLU101 101 1970-02-19 1971-08-18
  FLU102 102 1971-12-23
  FUM1 1 1989-05-09 1990-12-10
  FUM2 2 1990-12-29 1992-05-02
@@ -270,7 +270,7 @@
  HYM1 1 2002-06-29 2003-12-10
  HYM2 2 2004-03-07 2005-06-01
  HYM3 3 2005-09-27 2006-12-01
-JAD101 101
+JAD101 101 1983-11-19
  JAD102 102 1985-03-27 1986-01-25
  JAD103 103 1986-02-04 1986-10-14
  JAD104 104 1986-12-15 1987-03-01
@@ -284,7 +284,7 @@
  JAD112 112 1993-10-26 1994-09-13
  JAD113 113 1994-11-26 1995-08-03
  JAD114 114 1996-02-25
-JAN101 101
+JAN101 101 1970-01-04
  JAN102 102 1972-07-15 1973-01-25
  JAN103 103 1973-03-01 1974-12-12
  JAZ1 1 1992-07-08 1993-10-17
@@ -362,8 +362,8 @@
  KPM3 3 1985-08-07 1986-12-23
  KPM4 4 1987-10-04 1989-05-20
  KPM5 5 1990-02-18
-KUP101 101
-KUP102 102
+KUP101 101 1977-04-29
+KUP102 102 1979-02-09
  KUP103 103 1980-09-15 1981-11-15
  KUP104 104 1982-04-01 1983-05-27
  KUP105 105 1983-07-17 1984-08-14
@@ -450,10 +450,10 @@
  LIN5 5 1993-06-11 1995-05-09
  LIN6 6 1995-08-23 1996-12-09
  LIN7 7 1997-02-03 1999-01-19
-LIS101 101
-LIS102 102
-LIS103 103
-LIS104 104 1981-08-18
+LIS101 101 1975-05-07
+LIS102 102 1977-04-28
+LIS103 103 1979-06-15
+LIS104 104 1980-06-15 1981-08-18
  LIS105 105 1981-11-16 1982-11-15
  LIS106 106 1983-04-25
  LIW1 1 2004-05-01 2004-11-30
@@ -467,7 +467,7 @@
  LOC3 4 2004-04-26 2005-06-13
  LOC4 3 2003-11-09 2003-12-07
  LOC5 5 2005-11-19
-LOI101 101
+LOI101 101 1977-07-16
  LOI102 102 1981-08-08
  LOL1 1 2002-08-02 2003-12-11
  LOL2 2 2004-03-19 2005-06-09
@@ -501,7 +501,7 @@
  LYE1 1 2005-02-06 2006-03-23
  LYE2 2 2006-08-02
  LYM1 1 2006-06-10
-MAL101 101 1985-02-25
+MAL101 101 1984-03-22 1985-02-25
  MAL102 102 1985-05-03 1986-04-12
  MAL103 103 1986-06-22 1987-04-06
  MAL104 104 1987-06-26 1988-06-29
@@ -530,7 +530,7 @@
  MOJ6 6 1989-05-14 1991-02-24
  MOJ7 7 1991-07-05 1993-04-13
  MOJ8 8 1993-07-30
-MOM101 101
+MOM101 101 1971-01-14 1972-08-20
  MOM102 102 1973-01-09
  MOM103 103 1974-06-25 1975-01-26
  MOM104 104 1975-02-16 1975-11-15
@@ -607,9 +607,9 @@
  NOB4 4 2004-05-04 2004-12-07
  NOB5 5 2005-02-15 2006-09-17
  NOO1 1 2006-01-12
-NUB101 101
-NUB102 102
-NUB103 103
+NUB101 101 1975-09-28
+NUB102 102 1977-09-22
+NUB103 103 1979-07-16
  NUB104 104 1980-11-23 1982-05-29
  NUB105 105 1982-10-10 1984-05-06
  NUB106 106 1984-08-16 1985-01-27
@@ -621,7 +621,7 @@
  NUT5 5 2005-08-09 2006-04-20
  NUT6 6 2006-09-28
  NYA1 1 1989-03-11 1991-04-07
-NYA2 2
+NYA2 2 1992-01-14
  NYA3 3 1994-05-02 1994-09-14
  NYA4 4 1995-02-08 1997-04-05
  NYA5 5 1997-07-10 1999-04-28
@@ -705,9 +705,9 @@
  PIC1 1 1986-03-19 1987-11-24
  PIC2 2 1988-05-11 1989-10-11
  PIC3 3 1990-01-01
-PIN101 101
-PIN102 102
-PIN103 103
+PIN101 101 1977-05-15
+PIN102 102 1978-02-09
+PIN103 103 1979-06-17
  PIN104 104 1980-10-10 1981-05-15
  PIN105 105 1981-08-09 1982-06-09
  PIN106 106 1983-01-21 1984-02-17
@@ -729,7 +729,7 @@
  POK2 2 2004-04-20 2005-02-01
  POK3 3 2005-04-01 2006-05-02
  POK4 4 2006-10-16
-PRE101 101
+PRE101 101 1971-02-09
  PRE102 102 1973-04-21
  PRE103 103 1975-01-17 1976-04-16
  PRE104 104 1976-09-05 1978-01-17
@@ -767,8 +767,8 @@
  RAH8 8 1995-11-10 1997-01-26
  RAH9 9 1997-04-17
  REG1 1 1988-10-18 1989-06-23
-REM101 101
-REM102 102 1985-05-11
+REM101 101 1982-01-07
+REM102 102 1984-03-19 1985-05-11
  REM103 103 1985-06-01 1986-07-18
  REM104 104 1986-08-14 1987-08-10
  REM105 105 1987-09-05 1988-09-02
@@ -785,17 +785,17 @@
  RIB2 2 1994-11-30 1995-10-11
  RIB3 3 1995-12-11 1996-12-01
  RIB4 4 1996-12-25
-RIN101 101
-RIN102 102
+RIN101 101 1968-01-05
+RIN102 102 1969-08-14
  RIN103 103 1971-11-07
  RIT1 1 1991-06-07 1992-06-07
  RIT2 2 1992-07-01 1993-08-15
  RIT3 3 1993-09-07 1994-08-30
  RIT4 4 1994-09-19 1995-10-02
  RIT5 5 1996-04-01 1997-08-02
-RUK101 101
-RUK102 102
-RUK103 103
+RUK101 101 1975-07-07
+RUK102 102 1977-04-29
+RUK103 103 1979-03-05
  RUK104 104 1980-10-25
  SAF1 1 1981-04-12 1982-08-08
  SAF2 2 1982-09-01 1983-11-30
@@ -828,7 +828,7 @@
  SCI3 3 1990-05-04 1991-09-25
  SCI4 4 1991-11-30 1993-01-03
  SCI5 5 1993-02-17
-SER1 1 1995-05-11
+SER1 1 1994-02-26 1995-05-11
  SER2 2 1995-08-10 1996-09-19
  SER3 3 1996-11-16 1997-11-20
  SER4 4 1998-01-21 1999-03-22
@@ -838,7 +838,7 @@
  SER8 8 2004-04-04 2005-06-02
  SID1 1 1991-09-22 1992-07-28
  SID2 2 1992-08-23 1993-10-10
-SID3 3
+SID3 3 1993-10-24
  SIK1 1 1985-01-05 1985-07-10
  SIK2 2 1985-10-06 1986-12-26
  SIK3 3 1987-06-08 1988-05-03
@@ -853,7 +853,7 @@
  SIS7 8 1989-02-06 1989-11-20
  SIS8 9 1990-03-31
  SIS9 7 1988-06-28 1988-12-18
-SKI101 101
+SKI101 101 1970-02-19
  SLI1 1 1974-06-08 1974-12-11
  SLI2 2 1975-01-01 1975-07-20
  SLI3 3 1975-08-11 1977-02-25
@@ -897,14 +897,14 @@
  TTX101 101 1971-08-01
  TTX102 102 1973-02-12
  TTX103 103 1974-04-14
-TWI101 101
+TWI101 101 1970-09-04
  UDI1 1 1989-07-25 1990-09-27
  UDI2 2 1990-10-31 1992-01-15
  UDI3 3 1992-06-08 1993-08-17
  UDI4 4 1993-09-24 1994-11-19
  UDI5 5 1995-04-12 1995-11-08
  UDI6 6 1995-12-04 1997-04-06
-UMB101 101
+UMB101 101 1983-05-07
  UMB102 102 1984-06-17 1985-03-28
  UMB103 103 1985-05-24 1986-03-17
  UMB104 104 1986-04-15 1987-01-16
@@ -1126,6 +1126,6 @@
  YAI2 2 2006-07-16
  YOG1 1 2005-02-05 2006-08-12
  YOG2 2 2006-12-20
-ZUM101 101
+ZUM101 101 1983-05-07
  ZUM102 102 1985-08-07 1986-02-14
  ZUM103 103 1986-07-08 1987-01-09



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