[Babase] stumped in biograph 07a update

kfenn kfenn at princeton.edu
Wed Jan 2 11:48:48 EST 2008


Karl O. Pinc wrote:
>
> On 12/20/2007 03:08:45 PM, kfenn wrote:
>> Hi Karl,
>>
>> My first attempt to upload demog update data has met with total failure.
>>
>> I need to update the Biograph table in order to enter the census data.
>> If I try to use your Upload program to enter a series of new records, 
>> the system complains that the bioid cannot be null.
>> I get the same complaint if I use the import button in the column 
>> browse window for the biograph table.
>
> Do you have a bioid column in the data you're trying to upload?
> If you do then you're specifying a (NULL) data value and the system
> does not like it.

I do have a bioid column.  I can't remember how I was doing things 
before, but this morning I'm not getting a complaint about the bioid 
column.  Instead I get... Invalid input syntax for integer "" .  (I 
think its complaining about the bstatus column).  I have tried 
formatting as TEXT, NUMERIC (0 decimal places) and GENERAL in excel 
(then saving to text, of course,) but it doesn't like any of those.   
Any other ideas?  The postgres docs didn't help much, just reinforced 
the idea that an integer data types won't accept inputs with decimals.


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