[GRASSLIST:10823] Re: v.in.ascii error

[Stefan Istvan]

Hi!
I think your command should look something like this:

v.in.ascii input=/home/pierluigi/Desktop/zinc output=zinc format=point
fs=| columns='x double, y double, ppm double' x=1 y=2

I realised that the gui of v.in.ascii usually puts together the command
incorrectly, so I always use the cli to import ascii files.

Regards,
Istvan

On Wed, 2006-03-08 at 14:47 +0100, Pierluig De Rosa wrote:
> Dear GRASS users,
> 
> I need to import an ascii file into a point vector file, and I'm using 
> v.in.ascii command.
>  My ascii file have three columns (x coordinates, y coordinates, ppm value) 
> with fields separator "|" (pipe).
> the string command I used is:
> 
> v.in.ascii input=/home/pierluigi/Desktop/zinc output=zinc format=point fs=| 
> 'columns='\''x double precision, y double precision, ppm double 
> precision'\''' x=1 y=2 z=0 cat=0
> 
> but I have this error
> 
> DBMI-DBF driver error:
> SQL parser error in statement:
> create table zinc ( cat integer, 'x double precision, y double precision, ppm 
> double precision' )
> Error in db_execute_immediate()
> 
> 
> GRASS_INFO_ERROR(5553,1): Cannot create table: create table zinc ( cat 
> integer, 'x double precision, y double precision, ppm double precision' )
> 
> Can anyone tell me why I find this driver DBF error??
> Thanks
> Pierluigi
>