[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