CODEWITHSUNDEEP
phpcsvexport-to-csvdbf
Kohjah Breese
Kohjah Breese

Reputation: 4136

Convert DBF to CSV

I have a number of DBF database files that I would like to convert to CSVs. Is there a way to do this in Linux, or in PHP?

I've found a few methods to convert DBFs, but they are very slow.

Upvotes: 1

Views: 7033

Answers (3)

soyayix
soyayix

Reputation: 175

Try soffice (LibreOffice):

$ soffice --headless --convert-to csv FILETOCONVERT.DBF

Upvotes: 6

arod
arod

Reputation: 14042

Using @Kohjah's code, here an update of the code using a better (IMHO) fputcsv approach:

// needs dbase php extension (http://php.net/manual/en/book.dbase.php)

function dbfToCsv($file) 
{
    $output_path = 'output' . DIRECTORY_SEPARATOR . 'path';
    $path_parts = pathinfo($file);
    $csvFile = path_parts['filename'] . '.csv';
    $output_path_file = $output_path . DIRECTORY_SEPARATOR . $csvFile;

    if (!$dbf = dbase_open( $file, 0 )) {
        return false;
    }

    $num_rec = dbase_numrecords( $dbf );

    $fp = fopen($output_path_file, 'w');
    for( $i = 1; $i <= $num_rec; $i++ ) {
        $row = dbase_get_record_with_names( $dbf, $i );
        if ($i == 1) {
            //print header
            fputcsv($fp, array_keys($row));
        }
        fputcsv($fp, $row);
    }
    fclose($fp);
}

Upvotes: 0

Kohjah Breese
Kohjah Breese

Reputation: 4136

Change the files variable to a path to your DBF files. Make sure the file extension matches the case of your files.

set_time_limit( 24192000 );
ini_set( 'memory_limit', '-1' );

$files = glob( '/path/to/*.DBF' );
foreach( $files as $file )
{
    echo "Processing: $file\n";
    $fileParts = explode( '/', $file );
    $endPart = $fileParts[key( array_slice( $fileParts, -1, 1, true ) )];
    $csvFile = preg_replace( '~\.[a-z]+$~i', '.csv', $endPart );

    if( !$dbf = dbase_open( $file, 0 ) ) die( "Could not connect to: $file" );
    $num_rec = dbase_numrecords( $dbf );
    $num_fields = dbase_numfields( $dbf );

    $fields = array();
    $out = '';

    for( $i = 1; $i <= $num_rec; $i++ )
    {
        $row = @dbase_get_record_with_names( $dbf, $i );
        $firstKey = key( array_slice( $row, 0, 1, true ) );
        foreach( $row as $key => $val )
        {
            if( $key == 'deleted' ) continue;
            if( $firstKey != $key ) $out .= ';';
            $out .= trim( $val );
        }
        $out .= "\n";
    }

    file_put_contents( $csvFile, $out );
}

Upvotes: 1

Related Questions