[GRASSLIST:9507] Re: dbf - v.in.ascii import

[Markus Neteler]

On Thu, Dec 15, 2005 at 02:06:45PM +0100, Francesco Mirabella wrote:
> hi to all,
> I have a problem with importing ascii points into grass:
> I need to import a vector ascii map into grass, grass is connected to a
> .dbf database. Following the manpage, it seems that the v.in.ascii
> command is the same whatever is the database I want to connect to, so I
> type:
> 
> #############################################
> v.in.ascii input=ascii_file.txt output=prova_dbf fs=tab columns='cat integer, x double precision, y double precision, cdp_number varchar(20), line_name varchar(20), acquisition_year varchar(20)' x=2 y=3  cat=1
> #############################################
> 
> but I get:
> #############################################
> DBMI-DBF driver error:
> Incompatible value type.
> Error in db_execute_immediate()
> 
> ERROR: Cannot insert values: insert into prova_ar_dbf values ( 1,
>        11.919589, 43.679116, 101, 'ar315', 1981)

I think that cdp_number and acquisition_year are of integer type, not varchar.
At least they are not quoted.

Markus



> GRASS 6.0.1 (fogli_geo):~ >
> #############################################
> 
> I think it is related to the names that I want for the columns of the
> table, but I can't see what to do.
> 
> can someone help??
> 
> cheers,
> Francesco
>