I use Winlog32 as my station electronic logbook. This program is freeware provided by G0CUZ And can be downloaded from his site. The registered version of the program provides excellent maps.

My web site runs on the Linux operating system with Apache as the web server. My database of choice is MySQL because of its excellent support of Linux. MySQL is a powerful relational database that stores data in separate tables rather than putting all the data in one big storeroom. This adds speed and flexibility. The tables are linked by defined relations making it possible to combine data from several tables on request. The SQL part of ``MySQL'' stands for ``Structured Query Language'' - the most common standardised language used to access databases. MySQL software is Open Source. Open Source means that it is possible for anyone to use and modify. Anybody can download the MySQL software from the Internet and use it without paying anything. Anybody so inclined can study the source code and change it to fit their needs.

I choose PHP as the language for the dynamic web pages because of excellent support of both Linux and MySQL. PHP is a widely-used general-purpose scripting language that is especially suited for Web development and can be embedded into HTML.

Winlog32 creates Microsoft Access databases (.mdb files) for maintaining the logbook and many of the specialized databases such as IOTA, CQ Zones, US counties and DXCC. Unforutately, MS Access and standard SQL are NOT directly compatible (Welcome to the land of Bill Gates, don't you just love it!). Fortunately though, thanks to Cynergi (portugese only) there is a Visual Basic script that can be run as an Access module to "convert" the databases to MySQL. What the script actually does is create a textfile containing SQL commands that creates the appropriate table than populates the table with data from the Access database. For a detailed description and to download the script you should see the Cynergi exportsql web site (English). I have a copy of the script here but it may not be up to date. However, this script contains excellent instructions. The first page or two is the only guide available.

After "converting" the databases, it is a simple matter to create (or periodically update) a MySQL database (see MySQL documentation) and execute the SQL commands in the textfile. The command below is an example of using the "Test" text file on the Example database

mysql -D Example < /mnt/floppy/Test.txt

This example assumes a great detail concerning user ID's etc but it does give the general idea that populating the MySQL database is very straight forward.

If you have difficulty setting up your own on-line logbook I will respond to e-mails. I am not an Access nor Visual Basic expert but I can help with the Linux end and at least help repeat the steps that I found successful.