DBLog is a super handy logging program designed for radio amateurs. It uses a relational database, which makes it easy to log your QSOs and export them in ADIF format. Pretty cool, right?
The first step is to set up and test the database. The development was done using PostgreSQL, but no worries if you prefer MySQL or SQLite—they work too since they’re supported by Gambas.
When setting things up, I used the instruction "EXEC" instead of "FIND", but the SQL commands are pretty standard and should run smoothly on MySQL and SQLite as well. Just something to keep an eye on!
Create users and give them the right permissions. Then, make sure to create the tables for your database—let’s say you call it "LOG," but feel free to choose a name you like! Follow the instructions found in the subdirectory LOG.
You’ll want to ensure that cwdaemon starts without any errors. If you run into issues, check out /etc/defaults/cwdaemon. Personally, I use device ttyS0 with a priority of -3.
Once that’s sorted, launch Gambas, load up DBLog, and connect using your username and password. Enjoy logging!
In RUN mode, the QSO start time (time_on) updates automatically when you enter a call sign. In S&P mode, you'll need to hit "Start QSO" to get the timer going. If you forget that step, don’t worry; it’ll log with whatever time was set.
You can execute any SQL command in the SQL Request window—whether it's searching for something specific, modifying records, or deleting entries. Make sure to keep your SQL manual handy!
The ADIF export function remembers the last exported QSO number too! You can adjust which range of QSOs you'd like to export whenever necessary.
If you're not a fan of DMY date style, tweak the DataStyle subroutine as needed.
The CAT interface is optimized for an IC-706 MKIIG radio. If you're using a different model, just modify those commands and serial parameters accordingly.
Go to the Softpas website, press the 'Downloads' button, and pick the app you want to download and install—easy and fast!
SoftPas is your platform for the latest software and technology news, reviews, and guides. Stay up to date with cutting-edge trends in tech and software development.
Subscribe to newsletter
© Copyright 2024, SoftPas, All Rights Reserved.