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

Hi,

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.

BÜLENT ARIKAN
SHESC-ASU

Bulent Arikan wrote:

Hi,

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

Stupid question: is Iron_II_KNOWN_Sites.dbf in " $GISDBASE/$LOCATION_NAME/$MAPSET/dbf/ " or in a different folder?

Bulent Arikan wrote:

The file is on my Desktop!

which is usually
/home/<username>/Desktop/
on Linux
and usually
C\:Documents and Settings\<username>\Desktop\
on Windows

Neither of these is the same like $GISDBASE/$LOCATION_NAME/$MAPSET/dbf/, you must set database=<Desktop folder>, otherwise v.in.db can't find the table.

On Apr 22, 2009, at 12:53 AM, Markus Metz wrote:

Bulent Arikan wrote:

Hi,

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

Stupid question: is Iron_II_KNOWN_Sites.dbf in " $GISDBASE/$LOCATION_NAME/$MAPSET/dbf/ " or in a different folder?