Python script to dumping dbf database files

dbf_dump.py

# -*- coding: utf-8 -*-

"""

This python script is used for dumping dbf database files

* python2.7

"""

import dbfpy.dbf
import pprint
import csv
import xlwt
import datetime

def dump_dbf(filename):
    print(filename)
    db = dbfpy.dbf.Dbf(filename)

    txt_o = open(filename+'_dump.txt', 'w+')

    csv_file = open(filename+'.csv', 'wb')
    csv_writer = csv.writer(csv_file)
    csv_writer.writerow(sorted(db.fieldNames))

    xls_workbook = xlwt.Workbook()
    xls_worksheet1 = xls_workbook.add_sheet('Sheet 1')
    xls_date_format = xlwt.XFStyle()
    xls_date_format.num_format_str = 'M/D/YY'

    print('- HEADER -----------------------------------------------------------------------')
    print(sorted(db.fieldNames))

    txt_o.write(pprint.pformat(sorted(db.fieldNames))+"\n")

    csv_writer.writerow(sorted(db.fieldNames))

    for i, value in enumerate(sorted(db.fieldNames)):
        print i, value
        xls_worksheet1.row(0).write(i,value)

    print('- BODY -------------------------------------------------------------------------')

    data = []
    for row_count, row in enumerate(db):
        print([(k,row[k]) for k in sorted(db.fieldNames)])
        data.append(dict((k, row[k]) for k in db.fieldNames))
        csv_writer.writerow([str(row[k]) for k in sorted(db.fieldNames)])
        for column_count, value in enumerate(sorted(db.fieldNames)):
            if isinstance(row[value], datetime.date):
                xls_worksheet1.row(row_count+1).write(column_count,row[value], xls_date_format)
            else:
                xls_worksheet1.row(row_count+1).write(column_count,row[value])

    #print(pprint.pformat(data))

    txt_o.write(pprint.pformat(data)+"\n")

    xls_workbook.save(filename+'.xls')

    print('--------------------------------------------------------------------------------')

if __name__ == '__main__':
    #dump_dbf('classes.dbf')
    #dump_dbf('master.dbf')
    #dump_dbf('members.dbf')
    dump_dbf('regconfi.dbf')