phpbar.de logo

Mailinglisten-Archive

[php] FW: DBASE->MYSQL

[php] FW: DBASE->MYSQL

Cyrill Schumacher webmasterbhs_(at)_bluewin.de
Fri, 24 Nov 2000 08:54:14 +0100


hättest du mal im listenarchiv hier nachgeschaut,
dann hättest du lesen können, dass ich
so ein komisches windows tool habe mit dem man
bequem DBF dateien in MySQL importieren kann.

wer an dem ding interessiert ist, kann mir ja ne mail schicken
und ich schicke euch das 370 KB große teil zu.

kiri

                              DBF2MySQL
                        Version 1.0a freeware
                  Copyright (C) by Alexander Eltsyn
                 E-mail: ae_(at)_nica.ru, a.eltsyn_(at)_usa.net
                     WWW: http://www.nica.ru/~ae


  The program is also the subject of following copyrights:

  - Copyright (C) T.c.X. DataKonsult AB
  - Copyright (C) 1998 Justin P. Yunke <yunke_(at)_productivity.org>
  - Copyright (C) 1998 Ken Kyler
  - Copyright (C) Bob Silva <bsilva_(at)_umesd.k12.or.us>


                            WHAT IS THIS?

     DBF2MySQL is Win32 application to transfer data from FoxPro .DBF
files into MySQL server. To use this program you need an TCP/IP stack
installed and configured.


                            KEY FEATURES:

  * it requires no ODBC or other special clients to access MySQL and .DBF
    tables;
  * editable "CREATE TABLE" queries;
  * column names substitution/exclusion;
  * "batch" table transfer mode;
  * .dbf tables preview


                         BATCH TABLE PROCESSING

     If you need to transfer periodically a constant set of .dbf tables,
this feature is for you. First of all, the "batch script" is to be created.
Then you may give it as a command line argument for DBF2MySQL.exe.
     Batch script format is described below.


                      BATCH SCRIPT FORMAT DESCRIPTION

     Each line of the batch script contains instruction for one .DBF table.

Script line format (all parameters may be quoted with `"`):


<dbf_file_name>,<mysql_table_name>,<recreate>,<delete_rows>{,<dbf_field_name
>=<mysql_field_name>}

 Where:
  <dbf_file_name>      - file name to transfer data from
  <mysql_table_name>   - table name to transfer data to
  <recreate>           - Recreate MySQL table structure. Possible values:
                         0: leave table structure unchanged
                         1: drop table and create new trable structure
                            according to .DBF file.

  <delete_rows>        - empty table before data transfer. Values:
                         0: append .DBF data into table
                         1: delete all existing data before data transfer

  <dbf_field_name>=<mysql_field_name> - associate DBF field name
                         with mysql field name. Empty value of
                         <mysql_filed_name> means, that field should
                         not be transfered


Example of script lines:

".\db\abit.dbf", abit, 1, 1, lock=""
db\stud.dbf, stud, 0, 1, "Field"="Fld"






php::bar PHP Wiki   -   Listenarchive