[Gvsig_english] Re: Gvsig_internacional Digest, Vol 30, Issue 25

Juan Lucas Dominguez Rubio jldominguez at prodevelop.es
Tue Jul 29 09:04:02 CEST 2008 

Hello, Steven.
 
So you cannot use gvSIG's field calculator?
 
Perhaps you can use Ms Access or OpenOffice Base to edit that DBF file. If you place your file filename.dbf in the folder c:\fordername, you can connect to that database from OpenOffice Base by indicating that the database is located at c:\fordername, and a table called filename will be automatically added. Then you can edit or remove the 26th field.
 
When you open a shapefile, the correspondence between the shapes and the attributes is based on the order, so you have to make sure that you don't reorder the rows when you edit it that table.
 
If you make that dbf file available, perhaps we can help you more.
 
Regards,
 
 
Juan Lucas Domínguez Rubio
Prodevelop SL, Valencia (España)
Tlf.: 96.351.06.12 -- Fax: 96.351.09.68
http://www.prodevelop.es <http://www.prodevelop.es/> 

________________________________

De: gvsig_internacional-bounces at runas.cap.gva.es en nombre de Steven Drake
Enviado el: mar 29/07/2008 4:35
Para: gvsig_internacional at runas.cap.gva.es
Asunto: [Gvsig_english] Re: Gvsig_internacional Digest, Vol 30, Issue 25


Juan, 
 
I've checked the first few rows of the dbf and did not find the string '***********'. The only thing that seems odd is the 25th column (0 base) has mixed empty (not 0.0) and double numbers. I did some additional checking and noticed attempting to filter that particular field produces a similar error. So it's a safe assumption the shapefile is the problem. 
 
Any suggestions on how to get the empty values to 0.0? The file is too large for Excel. Doesn't seem like gvSIG can calculate until those arefilled in. 
 
Steven
 

	------------------------------
	
	Message: 4
	Date: Mon, 28 Jul 2008 10:19:19 +0200
	From: "Juan Lucas Dominguez Rubio" <jldominguez at prodevelop.es>
	Subject: RE: [Gvsig_english] trouble exporting a shapefile
	To: "Users and Developers mailing list"
	       <gvsig_internacional at runas.cap.gva.es>,
	       <gvsig_internacional at runas.cap.gva.es>
	Message-ID:
	       <E43C32BC5843E34FB4C00CDFAAAAF7D85BFDD3 at australia.prodevelop.local>
	Content-Type: text/plain; charset="iso-8859-1"
	
	Hello, Steven,
	
	Field type 8 is the DOUBLE type, so that error message means that gvSIG has found the string '***********' where it should have found a valid double value. That seems to be happening in the 26th field (o-based index = 25) of the first row.
	
	Can you check if your DBF file has some strange value in that position?
	
	Regards,
	
	
	
	Juan Lucas Domínguez Rubio
	Prodevelop SL, Valencia (España)
	Tlf.: 96.351.06.12 -- Fax: 96.351.09.68
	http://www.prodevelop.es <http://www.prodevelop.es/>  <http://www.prodevelop.es/>
	
	________________________________
	
	De: gvsig_internacional-bounces at runas.cap.gva.es en nombre de Steven Drake
	Enviado el: dom 27/07/2008 20:16
	Para: gvsig_internacional at runas.cap.gva.es
	Asunto: [Gvsig_english] trouble exporting a shapefile
	
	
	Hello,
	
	I've had trouble exporting a large polygon shapefile (+450,000 polygons) but no trouble exporting smaller size shapefiles. I don't know if the problem is the shapefile or its' size. The shapefile has exported OK with other GIS software so there might be something going on inside gvSIG itself. Using version 1.1.1 build 1022.
	
	Any idea what is going on, and if there is a work-around? I can make the shapefile available if needed.
	
	If it helps any, the Information Console displays the message below:
	
	null
	com.hardcode.gdbms.engine.data.driver.DriverException: Bad Field Value: '****************' (rowIndes: 0 fielId: 25 fieldType: 8 )
	   com.iver.cit.gvsig.fmap.drivers.dbf.DBFDriver.getFieldValue(Unknown Source)
	   com.hardcode.gdbms.engine.data.file.FileDataSourceAdapter.getFieldValue(Unknown Source)
	   com.hardcode.gdbms.engine.data.DataSourceCommonImpl.getRow(Unknown Source)
	   com.hardcode.gdbms.engine.data.AutomaticDataSource.getRow(Unknown Source)
	   com.iver.cit.gvsig.fmap.layers.SelectableDataSource.getRow(Unknown Source)
	   com.iver.cit.gvsig.ExportTo$WriterTask.run(Unknown Source)
	   com.iver.andami.PluginServices$1.construct(PluginServices.java:400)
	   com.iver.utiles.swing.threads.SwingWorker$2.run(Unknown Source)
	   java.lang.Thread.run(Unknown Source)
	null
	com.hardcode.gdbms.engine.data.driver.DriverException: Bad Field Value: '****************' (rowIndes: 206 fielId: 25 fieldType: 8 )
	   com.iver.cit.gvsig.fmap.drivers.dbf.DBFDriver.getFieldValue(Unknown Source)
	   com.hardcode.gdbms.engine.data.file.FileDataSourceAdapter.getFieldValue(Unknown Source)
	   com.iver.cit.gvsig.fmap.operations.arcview.ArcJoinDataSource.getFieldValue(Unknown Source)
	   com.hardcode.gdbms.engine.data.DataSourceCommonImpl.getRow(Unknown Source)
	   com.hardcode.gdbms.engine.data.AutomaticDataSource.getRow(Unknown Source)
	   com.iver.cit.gvsig.fmap.layers.SelectableDataSource.getRow(Unknown Source)
	   com.iver.cit.gvsig.ExportTo$WriterTask.run(Unknown Source)
	   com.iver.andami.PluginServices$1.construct(PluginServices.java:400)
	   com.iver.utiles.swing.threads.SwingWorker$2.run(Unknown Source)
	   java.lang.Thread.run(Unknown Source)
	null
	com.hardcode.gdbms.engine.data.driver.DriverException: Bad Field Value: '****************' (rowIndes: 0 fielId: 25 fieldType: 8 )
	   com.iver.cit.gvsig.fmap.drivers.dbf.DBFDriver.getFieldValue(Unknown Source)
	   com.hardcode.gdbms.engine.data.file.FileDataSourceAdapter.getFieldValue(Unknown Source)
	   com.hardcode.gdbms.engine.data.DataSourceCommonImpl.getRow(Unknown Source)
	   com.hardcode.gdbms.engine.data.AutomaticDataSource.getRow(Unknown Source)
	   com.iver.cit.gvsig.fmap.layers.SelectableDataSource.getRow(Unknown Source)
	   com.iver.cit.gvsig.ExportTo$WriterTask.run(Unknown Source)
	   com.iver.andami.PluginServices$1.construct(PluginServices.java:400)
	   com.iver.utiles.swing.threads.SwingWorker$2.run(Unknown Source)
	   java.lang.Thread.run(Unknown Source)
	null
	com.hardcode.gdbms.engine.data.driver.DriverException: Bad Field Value: '****************' (rowIndes: 0 fielId: 25 fieldType: 8 )
	   com.iver.cit.gvsig.fmap.drivers.dbf.DBFDriver.getFieldValue(Unknown Source)
	   com.hardcode.gdbms.engine.data.file.FileDataSourceAdapter.getFieldValue(Unknown Source)
	   com.hardcode.gdbms.engine.data.DataSourceCommonImpl.getRow(Unknown Source)
	   com.hardcode.gdbms.engine.data.AutomaticDataSource.getRow(Unknown Source)
	   com.iver.cit.gvsig.fmap.layers.SelectableDataSource.getRow(Unknown Source)
	   com.iver.cit.gvsig.ExportTo$WriterTask.run(Unknown Source)
	   com.iver.andami.PluginServices$1.construct(PluginServices.java:400)
	   com.iver.utiles.swing.threads.SwingWorker$2.run(Unknown Source)
	   java.lang.Thread.run(Unknown Source)
	null
	com.hardcode.gdbms.engine.data.driver.DriverException: Bad Field Value: '****************' (rowIndes: 0 fielId: 25 fieldType: 8 )
	   com.iver.cit.gvsig.fmap.drivers.dbf.DBFDriver.getFieldValue(Unknown Source)
	   com.hardcode.gdbms.engine.data.file.FileDataSourceAdapter.getFieldValue(Unknown Source)
	   com.hardcode.gdbms.engine.data.DataSourceCommonImpl.getRow(Unknown Source)
	   com.hardcode.gdbms.engine.data.AutomaticDataSource.getRow(Unknown Source)
	   com.iver.cit.gvsig.fmap.layers.SelectableDataSource.getRow(Unknown Source)
	   com.iver.cit.gvsig.ExportTo$WriterTask.run(Unknown Source)
	   com.iver.andami.PluginServices$1.construct(PluginServices.java:400)
	   com.iver.utiles.swing.threads.SwingWorker$2.run(Unknown Source)
	   java.lang.Thread.run(Unknown Source)
	
	Thanks!
	
	Steven
	-------------- next part --------------
	An HTML attachment was scrubbed...
	URL: http://runas.cap.gva.es/pipermail/gvsig_internacional/attachments/20080728/5c8bd99b/attachment-0001.htm
	
	

-------------- next part --------------
An HTML attachment was scrubbed...
URL: http://runas.cap.gva.es/pipermail/gvsig_internacional/attachments/20080729/20246684/attachment.htm

More information about the Gvsig_internacional mailing list