WARNING! Backup your data often! BACKUP your log file at the end of ANY session! All what you need to backup and store in a safe place is the main log database cqrlog.fdb located in the /log_data folder.
 < 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 allowing following actions:

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

Tables:

cqrlog_main
   the main table with all QSO records

remarks
   table containing the call sign related notes

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

ref_dxcc
   the current DXCC reference table

exceptions
   list of strings to be ignores if such string appears in the call sign after a slash

bands
   band limits (lower/upper end)

profiles
   list of QTH profiles

version
   program version

dxclusters
   list of DX cluster nodes

ambiguos
   list of ambiguos prefixes

iota_list
   IOTA reference list

award1 ... award5
   external tables used for memberships

zipcode1 ... zipcode3
   external tables used for zip codes

long_note
   a long note valid for whole log

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, call, freq, mode FROM cqrlog_main WHERE qsodate >= '2009-01-01' and qsodate <= '2009-31-12' and waz = 15

The databases structures are listed here.


 < Prev [Menu] Next >