Hi there,

Introduction

for those of you who want to convert between the different qvocab file formats like "*.wdb" (old, outdated), "*.qvo" (new, standard) and the MySQL database tables, there are some programs that make life easier for you.

There is now also a program that will convert .qvo files to tab-separated ASCII lists which can be processed further, e.g. imported into other programs in order to print your vocabulary books. This has been successfully tested with quicklist (http://www.quicklist.org), but will hopefully work with other programs, too.

If you want to compile these converter programs, simply pass the ``--enable-converters'' option to the configure script. ``make; make install'' will then automatically compile and install them along with qvocab.

Files

If you don't have passed the --with-mysql-version flag to the configure script you only have ``wdb2qvo'' and ``qvo2txt''. Furthermore ``fileiodump'' is compiled, this will dump the old database format (".wdb") to stdout in a format the converter program can read, and ``fileionewdump'', which will do the same with the new .qvo file format.

If you have MySQL support compiled in, you'll have the following converter programs:

filiodump:              see above
fileionewdump:          see above
wdb2qvo:                see above
qvo2txt:                see above
qvo2mysql:              Reads a new ".qvo" file, creates a MySQL table in
                        the qvocab database and writes the words to it
mysql2qvo:              The other way round
wdb2mysql:              Reads an old ".wdb" file and writes its contents to
                        the MySQL database

Syntax

The syntax for all programs is pretty much the same. You'll just have to specify the file name or the table name (MySQL) as an argument:

./wdb2qvo name_of_wdb_file.wdb
./qvo2mysql name_of_qvo_file.qvo
./mysql2qvo name_of_the_table
./wdb2mysql name_of_wdb_file.wdb

qvo2txt accepts additional options; see ``qvo2txt --help'' for details.

Other file formats:

If you have existing vocabulary books you would like to have converted, feel free to drop me a line. I'll need a small portion of the format for reference.

Regards,
Joachim Wieland,
joe@seul.org
jwieland@gmx.de