PHP scripts |  Linux howtos |  c scripts |  hosting |  gallerys |  s2k 

  1.0 Home  
  2.0 PHP scripts  
  3.0 Other scripts  
  4.0 Pages hosted here  
  5.0 Personal gallery  

 

PHP script: dbf Converter
current version: 0.9
last update - apr.2002


dbfConverter is a PHP script that reads data from dbase files (dbf, dbt, fpt) and convert
them into the mysql or postgres tables. Initially, it create sql tables & insert data, and then
updates old data. It does not support index files converting jet.

version 0.9: fixed simple bug for inserting field 'Units'
                    added support for conversions to PostgreSQL
version 0.8: added all possible field types for xBase table files and memo files. I tested
                    this script only with clipper dbf's and dbt's, but i think this script should
                    also work with other dbase databases (FoxPro/FoxBase).
version 0.7: added support for memo files (dbt). Simply just copy dbt files in directory.
                    Script reads it automaticaly.
version 0.6: script work without php dbase functions! (now we can run it without compiling
                    php with '--enable-dbase' option)
Configurable feautures: - select target database (MySQL, PostgreSQL)
- join 2 or more dbf files in one mysql table (dbf's must have same Fields)
- add primary key id field
- support more same named dbf files from different locations
- transform characters or words in data
- updating sql tables with new data from dbf files in 2 modes
- filtering data which we dont need in mysql tables
 

view config file
view source code
view sql class

download source (zip 8,2 Kb)
download source (tar.gz 10,1 Kb)

download 5 demo databases (zip 486 Kb)
download 5 demo databases (tar.gz 484 Kb)


OLD:
[dbfConverterV0.8.tar.gz]   [dbfConverterV0.8.zip]
[dbfConverterV0.7.tar.gz]   [dbfConverterV0.7.zip]
[dbfConverterV0.6.tar.gz]   [dbfConverterV0.6.zip]
[dbfConverterV0.5.tar.gz]   [dbfConverterV0.5.zip]

tested on: linux, win & unix.