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

[Nick Jachowski]

Wow, thanks, problem solved!

It seems the problem had to do with using single quotes when I declared the
db path:
db.connect driver=dbf database='~/grassdata/latlong_coral/PERMANENT/dbf/'
Deleting the quotes, then running chmod 777 on the dbf folder made it work.

-Nick


On Fri, Mar 11, 2011 at 1:49 PM, Markus Neteler <neteler at osgeo.org> wrote:

> Hi Nick
>
> Odd. Please check the permissions of
> the ../dbf/ directory.
>
> There is nothing special to install
> for DBF support.
>
> Markus
>
> On 3/11/11, Nick Jachowski <njachowski at gmail.com> wrote:
> > Thanks for the help Markus, but when I try it on my computer I still get
> the
> > same error message:
> > -----------------------------
> > GRASS 6.4.0RC5 (latlong_coral):~/grassdata/latlong_coral > 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
> > DBMI-DBF driver error:
> > Cannot create dbf database: ~/grassdata/latlong_coral/PERMANENT/dbf/
> >
> >
> > WARNING: Unable to open database
> <~/grassdata/latlong_coral/PERMANENT/dbf/>
> >          by driver <dbf>
> > ERROR: Unable to open database <~/grassdata/latlong_coral/PERMANENT/dbf/>
> >        by driver <dbf>
> > -----------------------------
> > I'm a complete newbie to the db part of GRASS; was I supposed to do
> anything
> > special during the installation to allow the dbf driver to work?
> >
> > I've tried this on two separate machines and have the same error message
> in
> > both, one is running GRASS 6.4.0RC5 on Ubuntu 9.10 the other is running
> > GRASS 6.4.0 on Ubuntu 10.04 in a vm.
> >
> > Sorry to bother the list again!
> > Nick
> >
> >
> > On Fri, Mar 11, 2011 at 12:13 AM, Markus Neteler <neteler at osgeo.org>
> wrote:
> >
> >> 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
> >>
> >
>
-------------- next part --------------
An HTML attachment was scrubbed...
URL: http://lists.osgeo.org/pipermail/grass-user/attachments/20110311/d7ca6f0a/attachment-0001.html