[Babase] Interpolation checking
Catherine Markham
babase@www.eco.princeton.edu
Mon, 19 Sep 2005 13:01:42 -0400
Hi Karl,
Sounds good - I can start on it first thing tomorrow if it isn't
finished until late today.
Regarding your note about those dozen CENSUS rows... makes sense that
that's a problem. I did some querying to figure out where the errors
are. All are old rows (double checked a version of BaBase from
January). Catching them isn't part of the conversion errors? I
resolved some similar issues for different dates/individuals - these
particular ones weren't on the list of mistakes though. I'm confused as
to why some were caught and others not.
Catherine
Karl O. Pinc wrote:
> Cathrine,
>
> Some heads-up.
>
> I'm running (again) what I hope to be the final
> conversion in-so-far as interpolation is concerned.
> It takes > 4 hours to complete, so I don't know I'll
> get the final foxpro/postgres members comparison to you
> today in time for you to work on anything.
>
> On a related note, the conversion tells me there's
> half a dozen CENSUS rows that are M Status that
> are for the same individual/day/group as already existing
> CENSUS rows with A statuses. You're not allowed
> to have two census rows for the same individual in
> the same group on the same day. Sorry, I've already
> deleted the errors so I can't tell you which ones, but
> they'll come up again. These may result in differences
> between foxpro and postgres MEMBERS.
>
>
> Karl <kop@meme.com>
> Free Software: "You don't pay back, you pay forward."
> -- Robert A. Heinlein
>
> _______________________________________________
> Babase mailing list
> Babase@www.eco.princeton.edu
> http://www.eco.princeton.edu/mailman/listinfo/babase
--
Catherine Markham
Department of Ecology and Evolutionary Biology
Princeton University
Phone: (609) 258-6898
Fax: (609) 258-2712