[GRASSLIST:5644] AW: Re: v.in.ascii Grass6.0

[Jan Bartholdy]

Thanks, Moritz,

v.in.ascii input=/home/Jan_Bartholdy/cities.dat output=cities format=point
fs=| columns='x double, y double, name string' x=1 y=2 z=0 cat=0

has printed the error:

WARNING: DOS text format found, attempting import anyway
Maximum input row length: 42
Maximum number of columns: 1
Maximum number of columns: 1
ERROR: ycol > minimum last column number

?




On Fri, February 4, 2005 15:31, Jan Bartholdy said:
> Dear All,
> here ist he error log from the import with v.in.ascii What is wrong? The
> line was created by tcltkgrass (d.m respectively)
>
> v.in.ascii input=/home/Jan_Bartholdy/cities.dat output=cities format=point
> fs=| 'columns='\''x double, y double, name string'\''' x=1 y=2 z=0 cat=0

I don't think you need the '\', and they seem to be the problem as

> Cannot create table: create table cities2 ( cat integer, 'x double, y
> double, name string length: 15' )

shows that they are still there and this does not look like correct sql.


So try:

v.in.ascii input=/home/Jan_Bartholdy/cities.dat output=cities format=point
fs=| columns='x double, y double, name string' x=1 y=2 z=0 cat=0

(as in the examples on the v.in.ascii man page)

Moritz


Cannot create table: create table cities2 (
> cat integer, 'x double, y double, name string length: 15' )
> DOS text format found, attempting import anyway
> Maximum input row length: 42
> Maximum number of columns: 3
> Minimum number of columns: 3
> column: 1  type: double
> column: 2  type: double
> column: 3  type: string  length: 15
> DBMI-DBF driver error:
> SQL parser error in statement:
> create table cities2 ( cat integer, 'x double, y double, name string
length:
> 15' )
> Error in db_execute_immediate()
>
>
> Cannot create table: create table cities2 ( cat integer, 'x double, y
> double, name string length: 15' )
>
> Here are the data (19 lines like these)
>
> 14.51666667|-22.98333333|Walvis Bay
> 15.16666667|-26.63333333|Lüderitz
> 16.5|-28.66666667|Alexander Bay
> 18.35|-32.31666667|Elands Bay
>
>
> Thanks, Jan
>
>
> ____________
> Virus checked by G DATA AntiVirusKit
>
>


____________
Virus checked by G DATA AntiVirusKit