[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