[GRASS-user] ' v.in.db ' question

[Hamish]

Bulent Arikan wrote:
> I am trying to import an OpenOffice dbf into a wgs84
> PERMANENT Location. I did this several times in the past
> with older versions of GRASS. I enter all the necessary
> information (input table, column names for x, y, z and
> CAT#). The Connection tab shows "dbf" for the driver name
> and database name reads "
> $GISDBASE/$LOCATION_NAME/$MAPSET/dbf/ "
> 
> I get this message:
> 
> DBMI-DBF driver error:
> Table 'Iron_II_KNOWN_Sites' doesn't exist
> Missing column <CAT> in table <Iron_II_KNOWN_Sites>
> I will greatly appreciate any suggestions.

maybe it is case sensitive? try key=cat instead of key=CAT.  ???

[SQL defines column names to be case insensitive, yes?? Did we ever find
that in a spec somewhere?]


# if you have `dbview` installed, what does this say:
  dbview -e filename.dbf | head


Hamish