DBFFile

Summary

Modification with add new feature based in original library project develop by paypac

Read and write .dbf (dBase III) files in Node.js:

• Supports C (string) , N (numeric) , I (integer) , L (logical) and D (date) field types
• Can open an existing .dbf file
  • Can access all field descriptors
  • Can access total record count
  • Can read records in arbitrary-sized batches
  • Supports very large files
• Can create a new .dbf file
  • Can use field descriptors from a hash of from another instance
• Can append records to an existing .dbf file
  • Supports very large files
• All operations are asyncronous and return a promise

Installation

npm install @mugan86/dbffile

Example: reading a .dbf file

var DBFFile = require('@mugan86/dbffile');

DBFFile.open('[full path to .dbf file]', '[encoding]')
    .then(dbf => {
        console.log(`DBF file contains ${dbf.recordCount} rows.`);
        console.log(`Field names: ${dbf.fields.map(f => f.name)}`);
        return dbf.readRecords(100);
    })
    .then(rows => rows.forEach(row => console.log(row)))
    .catch(err => console.log('An error occurred: ' + err));

Example: writing a .dbf file

var DBFFile = require('@mugan86/dbffile');

var fieldDescriptors = [
    { name: 'fname', type: 'C', size: 255 },
    { name: 'lname', type: 'C', size: 255 }
];

var rows = [
    { fname: 'Joe', lname: 'Bloggs' },
    { fname: 'Mary', lname: 'Smith' }
];

DBFFile.create('[full path to .dbf file]', fieldDescriptors, '[encoding]')
    .then(dbf => {
        console.log('DBF file created.');
        return dbf.append(rows);
    })
    .then(() => console.log(rows.length + ' rows added.'))
    .catch(err => console.log('An error occurred: ' + err));

API

The module exports two functions and a class, as follows:

/** Open an existing DBF file. */
function open(path: string): Promise<DBFFile>;


/** Create a new DBF file with no records. */
function create(path: string, fields: Field[]): Promise<DBFFile>;


/** Represents a DBF file. */
class DBFFile {

    /** Full path to the DBF file. */
    path: string;

    /** Total number of records in the DBF file (NB: includes deleted records). */
    recordCount: number;

    /** Metadata for all fields defined in the DBF file. */
    fields: { name: string; type: string; size: number; decs: number; }[];

    /** Append the specified records to this DBF file. */
    append(records: any[], encoding: string): : Promise<DBFFile>;

    /** Read a subset of records from this DBF file. */
    readRecords(maxRows = 10000000, encoding: string): Promise<any[]>;
}