This script imports DBASE/FoxPro files, located in a subdir, into a MySQL database. It can be used for reverse engeneering of FoxPro applications. For OS/X and Linux, I didn't find any usefull and working tool to do this automatically.
This script is based on:
- https://github.com/doofpot/DBFToMySQL
- http://stackoverflow.com/questions/14270236/php-script-to-convert-dbf-files-to-mysql
- http://www.ostalks.com/2009/12/31/import-dbf-files-to-mysql-using-php/
- Install php-xbase and this library from Github in the same directory. The dbase extension for PHP don't read MEMO data (or do it badly), so php-xbase is needed.
git clone https://github.com/hisamu/php-xbase.git
git clone https://github.com/jorgecasas/DBFToMySQL.git
-
Configure MySQL info and paths to directory where DBF/PFT files are located in configuration file config.php
-
Use it:
php dbf-import.php- if a date field is 0, then the the corresponding date with 0 is inserted (january first, 1970).
- the php-xbase thing is in the subdir "classes". As a ruby programmer, i didn't find how to make this separate whithin the day, I spent on solving this problem. If someone can help me with this problem.
MIT