Keyword Listings

Top  Previous  Next

The Keyword Listings allow you to search for Keywords on a selected mode, band(s) and time period. Keywords can be freely assigned to logged records by the user in order to flag the QSO for later retrieval for special awards or competitions of various kinds. There are certain rules to be followed in defining keyword files. More information is given in the paragraph on Userkey since this is the logging field designed for collecting all keywords in TurboLog 4.


One of the most important benefits of this facility is to track your achievements with respect to the IOTA awards. But there are other important competitions, such as collecting US-Counties, ZONES, WAS, WAB, DOK and the like. For ease of operation TurboLog 4 is equipped with some of the most popular keyword files, ready for instant use.


If the database query yields a match to the particular search conditions the keywords found will be displayed in a dedicated data listing. The results of this operation cannot just be brought to screen but printed or exported into different data formats.


The Keyword Listings facility is accessed via the Options --->Lists and Reports menu and selecting the sub menu item of this very name. This action will result in displaying the following default screen:


click to expand/collapse

Figure 336:   Keyword Listings Display: IOTA Example


The default parameters for this display were chosen as to yield a fast response even on slow machines. Starting from this screen you can now create your search query of interest by selecting the particular items from the drop down boxes. After you clicked the Go button the computation will be started. Depending on the complexity of the query, size of your log and clock rate of your machine this may take up to 10 seconds of time before the results show up. The time used is displayed on the status bar of the frame. The bottom line of the display shows summarizing counts for the number of keyword entries found and the time consumption.


The rationale in Keyword based Listings is primarily to display the number of entries found for a particular query. Results for Band and Mode are just of secondary interest. Thus, complementary search items such as 'QSL received' and 'QSL not received' will add up to the result of 'Worked all Time' with QSL Status 'Any status' for the total number of entries only and necessarily not for a distinct Band.


The following items are available for queries:





Keyword File:


The user can select the keyword file of interest from a file select box. The box shows all available keyword files in the ...\TL4DATA directory with file designator UID, either provided by TurboLog Communications or user defined:


Figure 337:   Select Keyword File

Figure 337:   Select Keyword File


For the time being the start-up default is set on IOTA.UID. However, the last keyword definition file in use will be remembered for the next start of the keyword listings facility.



Filter Options:


Country Status:


The drop down box offers the following choices with respect to the country's DXCC status:


Current= List of the current DXCCentries.
Deleted= List of the deleted entries.
DXCC= List of current plus deleted entries.
Non DXCC= List of non DXCCentries.
All= List of all fore standing categories.


The number of keywords found with assignment to these countries and with respect to these categories will be displayed in the frame's status bar. The default is set to All.



You can select the modes from this drop down box which you earlier defined in the DXCC menu. In addition to these modes there is a choice for Mixed ... the default ... which will bring up all keywords regardless of any particular mode.




This drop down box allows you to control the number of rows in the listing that contain the keywords of interest. You can select from the following choices:


All Keywords:  

Regardless whether there is information for a particular keyword or not the complete list of keywords will always be displayed.

Worked Keywords:

The display will only contain those keywords which contain information with respect to the other filter options selected.

Not Worked Keywords:

This option displays only those keywords from the list which were not worked before. The grid will be empty, of course.

Worked all Bands:

Only keywords which have been worked on all of the displayed bands will show up on the list.    

The default is on Worked Keywords.


QSL Status:


This drop down box offers the following choices:


Any( ... this is the default )
QSL sent( ... you have printed/sent a QSL )
QSL received( ... you received a QSL even if you might not have sent one.)
QSL sent and not received( ... you have sent your QSL but did not receive a QSL for the logged QSO )
QSL accepted( ... by DXCC desk. )


The rationale behind each item is explained in the bracketed text.


Worked Status:


This drop down box allows you to further specify your query with respect to the time period which was defined in the DXCC menu. For ease of operation the start of period is displayed in the top banner line of the frame.


Worked this period:

Selects anything later than the period specified. This is the default.

Worked previous period:

Selects anything before the period specified.

Worked all time:

Selects anything regardless of the period specified.

New this period:

Selects anything new with respect to band and mode, etc. from later than the period specified.


Please note:  

The user can select from DisplayQSL Status and Worked Status a total of 80 combinations of queries. Among those are a couple of meaningless, for example 'Not Worked' and 'QSL received' and ... . Please always make sure you are composing a meaningful query task. Garbage in will just yield garbage out. There is not much use blocking the very many combinations against each other.



Award Applications:


Ticking this check box will allow you to list calls fulfilling the filter conditions ... set as described above... instead of displaying simple counts. Thus, this facility can be used to prepare award applications, e.g. for the IOTA-Award, WAS, WAZ, DOK etc..


In accordance with typical award conditions there are two subsequent options available if the check box is ticked:


First for Keyword:

This option will only display one call per entry line. The call on display is the very first record assigned to the referenced keyword in timely order. Later records in the log with the same keyword assignment are ignored. This is the typical requirement for an application for the IOTA award.


First all bands:

This option will yield a display of calls matching the First for Keyword condition on every single band.


The following is a typical example of a First for Keyword listing:


click to expand/collapse

Figure 338:   Keyword Award Application Display


Since most award applications require contacts to be confirmed the QSL Status is on QSL received by default for these operations. However, all Filter options can be selected as to fulfill other purposes a user may have.


Needless to mention that this kind of flexible award survey can be applied to all the other Keyword Definition files as well. Besides the ready-to-use examples in the TurboLog 4 package the user can define keyword regimes on his own as long as the necessary boundary conditions are respected.



Radio Buttons


The following radio buttons are available:



Clicking the Go button or pressing ALT+G will start processing the selected query. The button will remain inactive (=grey) as long as the query parameters are left unchanged.



Clicking the Print button or pressing ALT+P will convey all grid data to the print routines. Before rendering the displayed data and graphics as a report the user can control its layout by means of the Print Preview facility. Before the Print Preview screen opens, however, the printer setup is called in order to allow you to select a printer, page size, page orientation and the like. In view of the total width the page default is set to "portrait" for the print.



Clicking the Export button or pressing ALT+E will start the Print Preview facility which contains a special menu item for export control. Before the Print Preview screen opens, however, the printer setup is called in order to allow you to select a printer, page size, page orientation and the like. For the time being TurboLog 4 offers export to:



Text file export  ( ASCII )




Please note: 

In order to receive a meaningful output on export operations the header of the print preview template must be as simple as possible. Weird results may be obtained on EXCEL exports in particular due to multiple rows of header information. Thus, EXCEL exports should only be started from the Export Buttons in TurboLog 4's data grid screens (... as this one). This assures automatically loading a special export template into the Preview Page.


If you export in EXCEL-CSV  format ( Comma Separated Variables ) the default separator will be a " ; " . This is no bias for further processing since you can always change the separator if you open the file to be imported by means of the OPEN FILE menu item in EXCEL.  



This button allows you to create customized print outputs of virtually any format. However, this facility is for the more experienced user only.  



Active Commands:



ALT+PStart printing.
ALT+EStart exporting.
ALT+GGo! Start search/computation.









Clicking arrow in country headerSort in reversed alphabetical order.
Drag separator of band columsArrange width of columns.


This topic was last edited on  Thursday, 17-Jun-2021,  at  10:49