WARNING! Backup your data often! BACKUP your log directory at the end of EVERY session! All that you need to backup and store in a safe place is the log database directory located in the ~/.config/cqrlog/database folder, or you can enable the autobackup function in Preferences. This autobackup function creates an ADIF file with a backup of your log.
 < Prev [Menu] Next >

CQRLOG for LINUX by OK2CQR & OK1RR

SQL Console

To enter the SQL Console, go to QSO list (Ctrl+O) and in the upper menu bar go to Filter -> SQL console.

The icons in the upper menu allow the following actions:

1st icon     Execute SQL statement
2nd icon    Previous SQL command
3rd icon    Next SQL command
4th icon    Load SQL command from a file
5th icon    Save SQL command to a file
6th icon    Export data to a csv or html file
7th icon    Get SQL command currently used in the main database. For example, if a filter is set, clicking this icon allows you to edit the SQL command created by the filter.

Tables in cqrlogXXX:


where XXX is numer of the log e.g. cqrlog001 for the first log.

cqrlog_main
   the main table with all QSO records

notes
   table containing the call sign related notes

profiles
   list of QTH profiles

db_version
   database version

award1 ... award5
   external tables used for memberships

zipcode1 ... zipcode3
   external tables used for zip codes

long_note
   a long note valid for the whole log

cqrlog_config
   configuration file

dxcc_id
   a list of DXCC countries

log_changes
   a list of changes made to cqrlog_main database filled by triggers (only when log upload function is enabled)

upload_status
   last IDs of uploaded QSO to online logs

call_alert    list of callsigns with mode and band for dxcluster alert function

freqmem    list of memories for fast frequency switching

view_cqrlog_main_by_callsign
   a view to show QSO sorted by callsign

view_cqrlog_main_by_qsodate
   a view to show QSO sorted by qsodate

Tables in cqrlog_common:


The common database used by all logs.
bands
   band limits (lower/upper end)

db_version
   database version

bandcn
   info if the country is worked and confirmed by a paper QSL or via LoTW

dxcc_ref
   the current DXCC reference table

dxclusters
   list of DX cluster nodes

iota_list
   IOTA reference list

log_list
   list of logs created in cqrlog

qslmngr
   list of QSL managers

Example:

Select from the database date, call sign, frequency and mode, where the QSO date is from timespan between Jan. 1. 2009 and Dec. 31. 2009 and the WAZ zone is 15.

SQL command:
SELECT qsodate, callsign, freq, mode FROM view_cqrlog_main_by_qsodate WHERE
qsodate >= '2009-01-01' and qsodate <= '2009-31-12' and waz = 15

The databases structures are listed here.


 < Prev [Menu] Next >