import/export DBF files (xBase/dBase format)

nicowang1 / google-refine

Automatically exported from code.google.com/p/google-refine

Other

0 stars 0 forks source link

import/export DBF files (xBase/dBase format) #186

Open GoogleCodeExporter opened 8 years ago

GoogleCodeExporter commented 8 years ago

Ability to open/import .dbf files from shapefile sets(.shp, .dbf, .shx, etc.), 
and ability to save back to/export as .dbf.

I've attached a sample shapefile set.

Eric Jarvies

Original issue reported on code.google.com by 7...@ericjarvies.com on 11 Nov 2010 at 7:33

Attachments:

cities.zip

GoogleCodeExporter commented 8 years ago

Is there anything specific about the dBase/xBase (DBF) files used in shapefile 
sets or the way that you'd use them?

If not, we can probably just convert this to a request for a generic xBase 
import/export capability.

Original comment by tfmorris on 11 Nov 2010 at 5:06

GoogleCodeExporter commented 8 years ago

A generic xBase import/export is the request.   Open the fileName.dbf, perform 
some 'refine' magic to the data, and write/save back to fileName.dbf so the 
shapefile set works as usual.  The first record in the .dbf file corresponds to 
the first record in the .shp and .shx files, so the GIS-refine user would need 
to make sure to pay attention not to delete rows or shift up/down rows, which 
would seldom be the case... mostly always ever need to edit the columns and the 
cell data itself.

Eric Jarvies

Original comment by 7...@ericjarvies.com on 11 Nov 2010 at 5:29

GoogleCodeExporter commented 8 years ago

Original comment by tfmorris on 11 Nov 2010 at 5:56

Changed title: import/export DBF files (xBase/dBase format)
Added labels: Type-Enhancement
Removed labels: Type-Defect

GoogleCodeExporter commented 8 years ago

Anyone used XBaseJ before? http://xbasej.sourceforge.net/
Would it be appropriate as an xBase parser we could wrap an importer around?

Original comment by iainsproat on 11 Nov 2010 at 6:05

Added labels: Component-Logic

GoogleCodeExporter commented 8 years ago

Haven't used it, but it looks like it'll work!
http://xbasej.sourceforge.net/
http://freshmeat.net/projects/javadbf/

Eric Jarvies

Original comment by 7...@ericjarvies.com on 11 Nov 2010 at 6:22

GoogleCodeExporter commented 8 years ago

I'm wondering if any progress has been made on this. This would be of huge 
benefit to a project I'm involved in..

Original comment by neale.st...@gmail.com on 25 May 2012 at 2:21

GoogleCodeExporter commented 8 years ago

Neale, it might be a long while.  You might want to use a copy of MS Access to 
import the DBF files and export those back out to CSV.  Another tool that could 
also accomplish this would be Talend Open Studio.

Original comment by thadguidry on 25 May 2012 at 4:15