Re: [OSGeo-Discuss] Shapefile's dfb editing

[Markus Neteler]

On Fri, Dec 12, 2008 at 5:11 PM, Silvia Franceschi
 wrote:
> Hi all,
> do some of you know how to edit a shapefile's dbf file?
> I tried with OpenOffice Calc but I have the following error:
> "Connection to file could not be established"
> I have to add some attribute that I have in an other file and they are a lot
> of data.

I have written up a small help text here:
http://grass.osgeo.org/wiki/Openoffice.org_with_SQL_Databases#DBF_files_.28OpenOffice.org_2.x.29

Hope it helps,
Markus
___
Discuss mailing list
Discuss@lists.osgeo.org
http://lists.osgeo.org/mailman/listinfo/discuss

Re: [OSGeo-Discuss] Shapefile's dfb editing

[Allan Hollander]

My usual trick for dealing with dbf files is to import them into R and 
manipulate them there. The read.dbf and write.dbf functions in the R foreign 
library (see http://cran.r-project.org/doc/manuals/R-data.html) seem quite 
robust. R is a programming environment for statistical computing; it's 
probably overkill to start learning R just to manipulate your dbf files, but 
R is an incredibly useful and powerful system, which by the way has a lot of 
spatial analysis capabilities (see 
http://cran.cnr.berkeley.edu/web/views/Spatial.html), including links to 
GRASS.

-- Allan Hollander

On Friday 12 December 2008 08:11:48 Silvia Franceschi wrote:
> Hi all,
> do some of you know how to edit a shapefile's dbf file?
> I tried with OpenOffice Calc but I have the following error:
> "Connection to file could not be established"
> I have to add some attribute that I have in an other file and they are a
> lot of data.
>
> Thanks in advance for help
>
> Silvia
> ___
> Discuss mailing list
> Discuss@lists.osgeo.org
> http://lists.osgeo.org/mailman/listinfo/discuss


___
Discuss mailing list
Discuss@lists.osgeo.org
http://lists.osgeo.org/mailman/listinfo/discuss

Re: [OSGeo-Discuss] Shapefile's dfb editing

[Silvia Franceschi]

Thanks to all!

The problem is in the length, but not in the column name but in the 
dimension of the "numbers" given in the column header. I really don't 
know exactly what they means... but it works!!

For example:
heigth,N,33,31
is not a valid length for an attribute column to be saved with OpenOffice.
If I change it into:
heigth,N,8,2
and in general if the sum of the last two numbers is less than 16 
(bytes...?) it works fine and I can save the edited dbf.


Thanks again for the attention,

Ciao

Silvia


M J wrote:
I don't know if this would matter but file name length could be 
something to look at.


Some dbf files that open in Excel won't open in Access unless renamed 
to 8 (I think) characters or less.


Maybe if you rename it shorter and try it might work.

Definitely be careful with a live shapefile dbf though - you should 
probably rename the shapefile to a shorter name and then try to open 
the dbf again.


Nif

On Fri, Dec 12, 2008 at 12:17 PM, Landon Blake > wrote:


Silvia,

I am surprised that Open Office couldn't open the DBF. Most open
source
desktop GIS programs like OpenJUMP can open and edit the attributes of
Shapefile. Is that an option?

If not, you could send me the file and I could see if I could open
it in
Microsoft Excel.

Landon
Office Phone Number: (209) 946-0268
Cell Phone Number: (209) 992-0658

-Original Message-
From: discuss-boun...@lists.osgeo.org

[mailto:discuss-boun...@lists.osgeo.org
] On Behalf Of Silvia
Franceschi
Sent: Friday, December 12, 2008 8:12 AM
To: discuss@lists.osgeo.org 
Subject: [OSGeo-Discuss] Shapefile's dfb editing

Hi all,
do some of you know how to edit a shapefile's dbf file?
I tried with OpenOffice Calc but I have the following error:
"Connection to file could not be established"
I have to add some attribute that I have in an other file and they
are a

lot of data.

Thanks in advance for help

Silvia
___
Discuss mailing list
Discuss@lists.osgeo.org 
http://lists.osgeo.org/mailman/listinfo/discuss


Warning:
Information provided via electronic media is not guaranteed
against defects including translation and transmission errors. If
the reader is not the intended recipient, you are hereby notified
that any dissemination, distribution or copying of this
communication is strictly prohibited. If you have received this
information in error, please notify the sender immediately.
___
Discuss mailing list
Discuss@lists.osgeo.org 
http://lists.osgeo.org/mailman/listinfo/discuss




___
Discuss mailing list
Discuss@lists.osgeo.org
http://lists.osgeo.org/mailman/listinfo/discuss
  

___
Discuss mailing list
Discuss@lists.osgeo.org
http://lists.osgeo.org/mailman/listinfo/discuss

Re: [OSGeo-Discuss] Shapefile's dfb editing

[M J]

I don't know if this would matter but file name length could be something to
look at.

Some dbf files that open in Excel won't open in Access unless renamed to 8
(I think) characters or less.

Maybe if you rename it shorter and try it might work.

Definitely be careful with a live shapefile dbf though - you should probably
rename the shapefile to a shorter name and then try to open the dbf again.

Nif

On Fri, Dec 12, 2008 at 12:17 PM, Landon Blake  wrote:

> Silvia,
>
> I am surprised that Open Office couldn't open the DBF. Most open source
> desktop GIS programs like OpenJUMP can open and edit the attributes of
> Shapefile. Is that an option?
>
> If not, you could send me the file and I could see if I could open it in
> Microsoft Excel.
>
> Landon
> Office Phone Number: (209) 946-0268
> Cell Phone Number: (209) 992-0658
>
> -Original Message-
> From: discuss-boun...@lists.osgeo.org
> [mailto:discuss-boun...@lists.osgeo.org] On Behalf Of Silvia Franceschi
> Sent: Friday, December 12, 2008 8:12 AM
> To: discuss@lists.osgeo.org
> Subject: [OSGeo-Discuss] Shapefile's dfb editing
>
> Hi all,
> do some of you know how to edit a shapefile's dbf file?
> I tried with OpenOffice Calc but I have the following error:
> "Connection to file could not be established"
> I have to add some attribute that I have in an other file and they are a
>
> lot of data.
>
> Thanks in advance for help
>
> Silvia
> ___
> Discuss mailing list
> Discuss@lists.osgeo.org
> http://lists.osgeo.org/mailman/listinfo/discuss
>
>
> Warning:
> Information provided via electronic media is not guaranteed against defects
> including translation and transmission errors. If the reader is not the
> intended recipient, you are hereby notified that any dissemination,
> distribution or copying of this communication is strictly prohibited. If you
> have received this information in error, please notify the sender
> immediately.
> ___
> Discuss mailing list
> Discuss@lists.osgeo.org
> http://lists.osgeo.org/mailman/listinfo/discuss
>
___
Discuss mailing list
Discuss@lists.osgeo.org
http://lists.osgeo.org/mailman/listinfo/discuss

RE: [OSGeo-Discuss] Shapefile's dfb editing

[Landon Blake]

Silvia,

I am surprised that Open Office couldn't open the DBF. Most open source
desktop GIS programs like OpenJUMP can open and edit the attributes of
Shapefile. Is that an option?

If not, you could send me the file and I could see if I could open it in
Microsoft Excel.

Landon
Office Phone Number: (209) 946-0268
Cell Phone Number: (209) 992-0658

-Original Message-
From: discuss-boun...@lists.osgeo.org
[mailto:discuss-boun...@lists.osgeo.org] On Behalf Of Silvia Franceschi
Sent: Friday, December 12, 2008 8:12 AM
To: discuss@lists.osgeo.org
Subject: [OSGeo-Discuss] Shapefile's dfb editing

Hi all,
do some of you know how to edit a shapefile's dbf file?
I tried with OpenOffice Calc but I have the following error:
"Connection to file could not be established"
I have to add some attribute that I have in an other file and they are a

lot of data.

Thanks in advance for help

Silvia
___
Discuss mailing list
Discuss@lists.osgeo.org
http://lists.osgeo.org/mailman/listinfo/discuss


Warning:
Information provided via electronic media is not guaranteed against defects 
including translation and transmission errors. If the reader is not the 
intended recipient, you are hereby notified that any dissemination, 
distribution or copying of this communication is strictly prohibited. If you 
have received this information in error, please notify the sender immediately.
___
Discuss mailing list
Discuss@lists.osgeo.org
http://lists.osgeo.org/mailman/listinfo/discuss

Re: [OSGeo-Discuss] Shapefile's dfb editing

[Paolo Cavallini]

Silvia Franceschi ha scritto:
> Hi all,
> do some of you know how to edit a shapefile's dbf file?
> I tried with OpenOffice Calc but I have the following error:
> "Connection to file could not be established"
> I have to add some attribute that I have in an other file and they are a
> lot of data.

If yuo open it directly it should work.
Beware, however, of not changing the order of rows.
Otherwise, there is a python plugin for qgis to do limited editing of
dbf tables.
All the best.
pc
-- 
Paolo Cavallini, see: * http://www.faunalia.it/pc *
http://gfoss.it
___
Discuss mailing list
Discuss@lists.osgeo.org
http://lists.osgeo.org/mailman/listinfo/discuss