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

2008-01-11 Thread Craig Leat
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 v.in.ogr fails reporting that two columns have the same name. Is there a w

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