[Babase] stumped in biograph 07a update

Lacey Maryott lacey.maryott at duke.edu
Wed Jan 2 11:51:26 EST 2008


Tabby,

   do you have any accidental spaces after characters in th bstatus 
column? sometimes it gets mad about that and puts blank spaces within 
quotations.  or if you have a blank field.


Lacey

kfenn wrote:
> 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
>

-- 
Lacey Maryott
Alberts Lab
Department of Biology
Duke University
ph: 919-660-7306
fax: 919-660-7293
Lacey.Maryott at duke.edu 



More information about the Babase mailing list