Re: [GRASS-user] v.in.ogr fails on dbf with long column names

2008-01-11 Thread Daniel Victoria
On Jan 11, 2008 10:42 AM, Craig Leat <[EMAIL PROTECTED]> wrote: > > BTW the dbf is too big (94,000 rows) to load into OpenOffice Calc. > How about OpenOfice Base? It appears to open dBase files. I don'f have a dbf file here to test it but the web page says it does. Daniel _

Re: [GRASS-user] v.in.ogr fails on dbf with long column names

2008-01-11 Thread Richard Greenwood
On Jan 11, 2008 5:42 AM, Craig Leat <[EMAIL PROTECTED]> wrote: > > Hi > > I have a shapefile and attributes in a dbf file. The dbf has two columns > where the first ten characters of the column names are identical. The dbf > driver appears to only consider the first ten letters of the name and so >

RE: [GRASS-user] v.in.ogr fails on dbf with long column names

2008-01-11 Thread Patton, Eric
>there are already several bug reports about problems (bad experiences) with the >10 characters limit in dbf. A simple solution is to use sqlite instead. >Regards, > Otto And even if you aren't an sqlite guru, you just have to install it on your system and use the gui-based sqlitebrowser, which

Re: [GRASS-user] v.in.ogr fails on dbf with long column names

2008-01-11 Thread Craig Leat
Wow! Lots of advice flooding in. Thanks to all. v.in.ogr Still fails to import the dbf even if sqlite is my internal database. I solved the problem by using the cnames option to v.in.ogr. Regards Craig Patton, Eric wrote: there are already several bug reports about problems (bad experience

Re: [GRASS-user] v.in.ogr fails on dbf with long column names

2008-01-11 Thread Martin Landa
Hi, 2008/1/11, Craig Leat <[EMAIL PROTECTED]>: > I have a shapefile and attributes in a dbf file. The dbf has two columns > where the first ten characters of the column names are identical. The dbf > driver appears to only consider the first ten letters of the name and so > v.in.ogr fails reporti

Re: [GRASS-user] v.in.ogr fails on dbf with long column names

2008-01-11 Thread Otto Dassau
Hi Craig, there are already several bug reports about problems (bad experiences) with the 10 characters limit in dbf. A simple solution is to use sqlite instead. Regards, Otto On Fri, 11 Jan 2008 06:04:05 -0700 "Richard Greenwood" <[EMAIL PROTECTED]> wrote: > On Jan 11, 2008 5:42 AM, Craig Lea