http://fileformats.archiveteam.org/api.php?action=feedcontributions&user=Pwenzel&feedformat=atomJust Solve the File Format Problem - User contributions [en]2024-03-28T19:46:28ZUser contributionsMediaWiki 1.19.2http://fileformats.archiveteam.org/wiki/DBase_IIIDBase III2015-12-09T20:20:50Z<p>Pwenzel: Added link to PHP XBase</p>
<hr />
<div>{{DISPLAYTITLE:dBase III}}{{FormatInfo<br />
| subcat = Databases<br />
| extensions = {{ext|dbf}}<br />
| pronom = {{PRONOM|x-fmt/9}}<br />
}}<br />
'''dBase III''' is a database program.<br />
<br />
This article describes how to export data out of a dBase III Table File (*.dbf). <br />
<br />
== Opening the data with Libre Office ==<br />
It is possible to import *.dbf files into Libre Office (or Open Office) Calc or Base: http://help.libreoffice.org/Calc/Importing_and_Exporting_dBASE_Files . <br />
<br />
Libre Office will try to recognize the character encoding of the data and preselect this option in the import window. Once a file imported, it can be saved in/exported to a variety of different formats. <br />
<br />
== Importing the data directly into a mySQL database ==<br />
Alternatively the data can directly be imported into a running mySQL database using the linux program <code>[http://manpages.ubuntu.com/manpages/lucid/man1/dbf2mysql.1.html dbf2mysql]</code>. Importing the data directly however could cause some problems with the character encoding for non ASCII characters.<br />
<br />
If the mysql server is already running, the following commands will import the data:<br />
user@linux:~$ mysql -u root -p<br />
mysql> create database database_name;<br />
mysql> exit<br />
user@linux:~$ sudo apt-get install dbf2mysql<br />
user@linux:~$ dbf2mysql -vvv -c -f -d database_name -U root -P password DATA_FILE.DBF <br />
<br />
The data can then be exported using <code>mysqldump</code><br />
user@linux:~$ mysqldump -u root -p database_name > data_export.sql<br />
<br />
== Specifications ==<br />
<br />
* [http://www.dbase.com/Knowledgebase/INT/db7_file_fmt.htm dBase version 7 file header format]<br />
<br />
== Metaformat files ==<br />
<br />
* [https://www.synalysis.net/Grammars/dbase.grammar Synalysis grammar file] (for Hexinator / Synalize It!; [[Synalysis grammar file|more details]])<br />
<br />
== See also ==<br />
* [[dBase programming language]]<br />
<br />
== Additional Weblinks ==<br />
* [http://en.wikipedia.org/wiki/DBase Wikipedia article about dBase]<br />
* [http://www.nationalarchives.gov.uk/pronom/x-fmt/9 dBase III entry in PRONOM]<br />
* [http://www.digitalpreservation.gov/formats/fdd/fdd000325.shtml dBase entry at digitalpreservation.gov]<br />
* [http://www.dbf2002.com/dbf-file-format.html DBF File structure]<br />
* [http://www.dbase.com/Knowledgebase/INT/db7_file_fmt.htm dBase File Structure at dBase knowledge base]<br />
* [http://www.clicketyclick.dk/databases/xbase/format/index.html Xbase file format description]<br />
* [http://www.dbase.com/ Current dBase product]<br />
* [http://www.textfiles.com/programming/FORMATS/dbasefil.inf dBase III file structure]<br />
* [http://stackoverflow.com/questions/14008534/opening-and-searching-dbase-iii-dbf-databases-in-python Opening and searching dBase III (DBF) databases in Python]<br />
* [https://github.com/hisamu/php-xbase PHP XBase - A parser for dbf files using PHP]</div>Pwenzel