dbfUtils for Developers: Quick Reference and Examples

dbfUtils: A Practical Guide to Managing DBF Files

What is dbfUtils?

dbfUtils is a lightweight toolkit for reading, writing, and manipulating DBF (dBase) database files common in legacy systems and GIS data exchanges. It provides simple command-line utilities and programmatic APIs to convert, validate, and transform DBF files without requiring the original dBase environment.

When to use dbfUtils

• Migrating legacy databases to modern formats (CSV, SQLite, Parquet).
• Cleaning and validating DBF files before import into GIS or accounting systems.
• Automating batch conversions and schema inspections in ETL pipelines.
• Repairing corrupted DBF headers or recovering truncated files.

Key features

• Read/write support for common DBF variants (dBase III/IV, Visual FoxPro).
• Field-level type detection and conversion (strings, numbers, date, logical).
• Batch conversion to CSV, JSON, SQLite, and Parquet.
• Schema inspection and summary reports (field counts, nulls, unique values).
• Header repair tools and integrity checks.
• Command-line interface and bindings for popular languages (Python/Node.js).

Installing dbfUtils

• Using pip (Python package):
  1. Ensure Python 3.8+ is installed.
  2. Run:

     bash
     Copy CodeCopied
     pip install dbfutils 

• Using npm (Node.js wrapper):

  bash
  Copy CodeCopied
  npm install -g dbfutils 

Basic command-line usage

• Inspect schema:

  bash
  Copy CodeCopied
  dbfutils inspect data.dbf 

• Convert to CSV:

  bash
  Copy CodeCopied
  dbfutils convert data.dbf –format csv –out data.csv 

• Convert multiple DBFs to a single SQLite DB:

  bash
  Copy CodeCopied
  dbfutils bulk-convert.dbf –format sqlite –out dbfarchive.sqlite 

bash
 ffON2NH02oMAcqyoh2UU MQCbz04ET5EljRmK3YpQ CPXAhl7VTkj2dHDyAYAf” data-copycode=“true” role=“button” aria-label=“Copy Code”>Copy CodeCopied
dbfutils convert old.dbf –format csv –out old.csv –encoding cp1252 

bash
Copy CodeCopied
dbfutils repair damaged.dbf –backup damaged.bak.dbf 

bash
Copy CodeCopied
dbfutils transform data.dbf –cast “price:decimal,qty:int” –out datafixed.dbf 

bash
 ffON2NH02oMAcqyoh2UU MQCbz04ET5EljRmK3YpQ CPXAhl7VTkj2dHDyAYAf” data-copycode=“true” role=“button” aria-label=“Copy Code”>Copy CodeCopied
dbfutils merge –in files/*.dbf –out merged.dbf 

python
Copy CodeCopied
from dbfutils import DBF 
db = DBF(‘data.dbf’, encoding=‘cp1252’)
print(db.fields)           # schema
for rec in db:
    print(rec[‘ID’], rec[‘NAME’])
db.to_csv(‘data.csv’)