RE: [OSGeo-Discuss] Shapefile's dfb editing
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
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 lbl...@ksninc.com 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
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 lbl...@ksninc.com mailto:lbl...@ksninc.com 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 [mailto: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 mailto: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 mailto: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 mailto: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
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
On Fri, Dec 12, 2008 at 5:11 PM, Silvia Franceschi silvia.frances...@gmail.com 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