[Babase] UPLOAD pregs error
kfenn
kfenn at princeton.edu
Fri Jan 4 13:56:18 EST 2008
Hi again Karl,
So can we rename the database Hydrabase 2.0? Every time I try to fix a
problem I have two more grow in it's place.
>
> What goes in the pregs table are Cpids (CYCPOINTS keys), not
> Cids (CYCLES keys). I suspect you put in a Cpid of a CYCPOINTS
> that belonged to LYE.
Yes, I was using the cid, although I really though I had copied the
dcpid from mtd_cycles. Thanks for the fix.
Here's my latest issue:
So let's review what I've been doing:
I tried to update the census table.
But I can't load new individuals until they appear in Biograph.
So I tried to load new baboons into Biograph.
But I couldn't load them in until I had loaded the pregs from which they
came.
So I tried to load the pregs.
But I can't load the pregs until I have the cycles loaded.
So I tried to load the cycles.
But I can't load the cycles until I insert the maturedates.
So I tried to load the maturedates.
But I can't load the maturedates becaues they all fall after the last
census days and seen ti violate some date rule.
So I tried to update the census table.....ooops I seem to be at the top
of my list again.
I think I'm going to have to do the update in two stages....one for old
individuals and one for new ones because of the loop. I don't have a
grand plan at the moment...so I'll work on this and you can weigh in
with anything that might be helpful.
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