[Babase] VIV sexskin not uploading due to missing mdate
kfenn
kfenn at princeton.edu
Mon Jun 1 09:09:30 EDT 2009
nlearn at Princeton.EDU wrote:
>
> *On Fri 29/05/09 6:31 PM , "Karl O. Pinc" kop at meme.com sent:*
>
>
> I think Tabby nailed the problem: The automatic mdates were
> not updated when a pregnancy (PREGS row) was deleted.
>
> The next step is to fix the database. Either we need to
> remember all the pregnancies that have been deleted
> and manually make changes or we need to schedule a time
> for me to temporarily turn off all the data validation
> and rebuild the automatic Mdates.
>
> I should be able to figure out what other pregnancies have been
> deleted if that is the safer way to do this.
>
>
I was going to suggest that Karl turn the validations off and rebuild
the auto Mdates. It seems more thorough and probably not unsafe as long
as we are not update the database at all. Karl, how do you feel about it?
Otherwise you can look for missing mdates and see that they always match
a conceive date, esp from the last 2-3 years, but I'm not sure that the
old demography summary sheets will always make it obvious when a preg
has been changed...it might be clear, but I'm not that confident.
Tabby
--
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