[GRASS-user] v.in.ascii: DBMI-DBF driver error

[Markus Neteler]

On Thu, Mar 10, 2011 at 3:45 PM, Nick Jachowski <njachowski at gmail.com> wrote:
> Hi all,
> I'm trying to use v.in.ascii and I'm getting a "DBMI-DBF driver error."
> -------------------
> GRASS 6.4.0RC5 (latlong_coral):~/grassdata/latlong_coral > v.in.ascii
> input=kyy.csv out=kyy skip=1 fs=, columns='x, y, cat int' cat=3
                                                         ^^^^^^^^^^^^^^^

... this cannot work since you did not specify the types for x and y.

Doing so, I get:

v.in.ascii input=kyy.csv out=kyy skip=1 fs=, columns='x double
precision, y double precision, cat int' cat=3
Scanning input for column types...
Maximum input row length: 86
Maximum number of columns: 9
Minimum number of columns: 8
Column: 1 type: double
Column: 2 type: double
Column: 3 type: integer
Column: 4 type: string length: 3
Column: 5 type: string length: 3
Column: 6 type: double
Column: 7 type: double
Column: 8 type: double
Column: 9 type: double
WARNING: Table <kyy> linked to vector map <kyy> does not exist
ERROR: Number of columns defined (3) does not match number of columns (9)
       in input

Of course all the other columns need to be defined as well.
Or just use the auto-detector:

v.in.ascii input=kyy.csv out=kyy skip=1 fs=, cat=3
Scanning input for column types...
Maximum input row length: 86
Maximum number of columns: 9
Minimum number of columns: 8
Column: 1 type: double
Column: 2 type: double
Column: 3 type: integer
Column: 4 type: string length: 3
Column: 5 type: string length: 3
Column: 6 type: double
Column: 7 type: double
Column: 8 type: double
Column: 9 type: double
Importing points...
 100%
Populating table...
Building topology for vector map <kyy>...
Registering primitives...
23 primitives registered
23 vertices registered
Building areas...
 100%
0 areas built
0 isles built
Attaching islands...
Attaching centroids...
 100%
Number of nodes: 23
Number of primitives: 23
Number of points: 23
Number of lines: 0
Number of boundaries: 0
Number of centroids: 0
Number of areas: 0
Number of isles: 0
v.in.ascii complete.

...
> It seems a lot of people get this error (according to google...), but I
> haven't seen a solution.

I doubt this statement :)

Hope this helps,
Markus