bertspaan/README.md

## README.md

      
    Raw
  

              README.md
            
          
    Python script to convert DBF database file to CSV


First download dbfpy: http://sourceforge.net/projects/dbfpy/files/latest/download?source=files
Then install: sudo python setup.py install

To convert DBF file to CSV:
./dbf2csv database.dbf


## dbf2csv.py
#!/usr/bin/python

import csv
from dbfpy import dbf
import os
import sys

filename = sys.argv[1]
if filename.endswith('.dbf'):
    print "Converting %s to csv" % filename
    csv_fn = filename[:-4]+ ".csv"
    with open(csv_fn,'wb') as csvfile:
        in_db = dbf.Dbf(filename)
        out_csv = csv.writer(csvfile)
        names = []
        for field in in_db.header.fields:
            names.append(field.name)
        out_csv.writerow(names)
        for rec in in_db:
            out_csv.writerow(rec.fieldData)
        in_db.close()
        print "Done..."
else:
  print "Filename does not end with .dbf"
	#!/usr/bin/python

	import csv
	from dbfpy import dbf
	import os
	import sys

	filename = sys.argv[1]
	if filename.endswith('.dbf'):
	print "Converting %s to csv" % filename
	csv_fn = filename[:-4]+ ".csv"
	with open(csv_fn,'wb') as csvfile:
	in_db = dbf.Dbf(filename)
	out_csv = csv.writer(csvfile)
	names = []
	for field in in_db.header.fields:
	names.append(field.name)
	out_csv.writerow(names)
	for rec in in_db:
	out_csv.writerow(rec.fieldData)
	in_db.close()
	print "Done..."
	else:
	print "Filename does not end with .dbf"