Configuring SpotCollector's Spot Database

SpotCollector Online Help Contents

The Spot Database tab contains 8 panels.

 

Spot Database File panel

Pathname Specifies the full pathname of the Spot Database
Select Displays a file selector that can be used to specify a Spot Database pathname
Open After modifying the Pathname, click this button to open the Spot Database in that Pathname

 

Combination Criteria panel

Each incoming spot of a station is compare with existing Spot Database entries for that station. If, with respect to an existing Spot Database entry, the incoming spot lies within the time window and frequency range specified below, then the existing Spot Database entry is updated to reflect the incoming spot; otherwise, a new Spot Database entry is created.

Maximum separation in time (minutes) Specifies the time window, in minutes, into which an incoming spot must fall in order to be combined with an existing Spot Database entry
Maximum separation in frequency (kHz) Specifies the frequency range, in kHz., into which an incoming spot must fall in order to be combined with an existing Spot Database entry

 

Controls panel

Maximum age of valid incoming spots (minutes) Incoming spots whose age exceeds this value are not considered for entry in the Spot Database; a spot's age is computed as the difference between the time at which it was received (using your PC's UTC time) and the time at which it was sent (using the sender's UTC timestamp)
Frequency Filter panel

 

When the Frequency filter is activated, all Spot Database entries whose frequencies lies outside the specified range or are older than the specified age are hidden

Need Filter panel Determines whether the Spot Database Need filter hides entries for all but unworked DXCC entities, or hides entries for all but unworked or unconfirmed DXCC entities

 

Format panel

This panel's Dates and times textbox lets you specify the format of dates and times that appear in the Spot Database's FirstTime, LastTime, and RcvdTime fields. The default format is 

ddddd hhnn 

Which uses your system's short date format and a four-digit time; the following characters may be used to specify the format:

:

the system-defined time separator

/ the sysem-defined date separator
d Display the day as a number without a leading zero (1 – 31).
dd Display the day as a number with a leading zero (01 – 31).
ddd Display the day as an abbreviation (Sun – Sat).
dddd Display the day as a full name (Sunday – Saturday).
ddddd Display the date as a complete date (including day, month, and year), formatted according to your system's short date format setting. The default short date format is m/d/yy.
dddddd Display a date serial number as a complete date (including day, month, and year) formatted according to the long date setting recognized by your system. The default long date format is mmmm dd, yyyy.
w Display the day of the week as a number (1 for Sunday through 7 for Saturday).
ww Display the week of the year as a number (1 – 54).
m Display the month as a number without a leading zero (1 – 12). If m immediately follows h or hh, the minute rather than the month is displayed.
mm Display the month as a number with a leading zero (01 – 12). If m immediately follows h or hh, the minute rather than the month is displayed.
mmm Display the month as an abbreviation (Jan – Dec).
mmmm Display the month as a full month name (January – December).
q Display the quarter of the year as a number (1 – 4).
y Display the day of the year as a number (1 – 366).
yy Display the year as a 2-digit number (00 – 99).
yyyy Display the year as a 4-digit number (100 – 9999).
h Display the hour as a number without leading zeros (0 – 23).
hh Display the hour as a number with leading zeros (00 – 23).
n Display the minute as a number without leading zeros (0 – 59).
nn Display the minute as a number with leading zeros (00 – 59).
s Display the second as a number without leading zeros (0 – 59).
ss Display the second as a number with leading zeros (00 – 59).
ttttt Display a time as a complete time (including hour, minute, and second), formatted using the time separator defined by the time format recognized by your system. A leading zero is displayed if the leading zero option is selected and the time is before 10:00 A.M. or P.M. The default time format is h:mm:ss.
AM/PM Use the 12-hour clock and display an uppercase AM with any hour before noon; display an uppercase PM with any hour between noon and 11:59 P.M.
am/pm Use the 12-hour clock and display a lowercase AM with any hour before noon; display a lowercase PM with any hour between noon and 11:59 P.M.
A/P Use the 12-hour clock and display an uppercase A with any hour before noon; display an uppercase P with any hour between noon and 11:59 P.M.
a/p Use the 12-hour clock and display a lowercase A with any hour before noon; display a lowercase P with any hour between noon and 11:59 P.M.
AMPM Use the 12-hour clock and display the AM string literal as defined by your system with any hour before noon; display the PM string literal as defined by your system with any hour between noon and 11:59 P.M. AMPM can be either uppercase or lowercase, but the case of the string displayed matches the string as defined by your system settings. The default format is AM/PM.

 

Size Limit panel

The only limit to the growth of SpotCollector's Spot Database is the amount of free storage on its storage volume. Using facilities on this panel, you can either "prune" the Spot Database's older entries, or you can clear it completely.

Prune entries older than this age (days) All Spot Database entries older than this will be deleted by the Prune command, or when SpotCollector starts if you have the Prune Spot Database on startup box checked
Prune Deletes all Spot Database entries older than the specified age
Prune Spot Database on startup If checked, the Spot Database is pruned when SpotCollector starts; all Spot Database entries older than the specified age are deleted.
Prune Spot Database hourly If checked, the Spot Database is pruned when at the beginning of each hour; all Spot Database entries older than the specified age are deleted.
Clear Spot Database on startup If checked, the Spot Database is cleared when SpotCollector starts
Clear Deletes all Spot Database entries regardless of age

 

Web Server panel

Enabled If checked, enables the web server to respond to incoming requests
Port Specifies the TCP port used by SpotCollector's web server
  • most web browsers assume port 80 unless the URL includes an explicit port
  • use a port other than 80 if you are already running a port 80 web server on your PC
Spots per page SpotCollector's web server displays the most recent N Spot Database entries, where N is specified by this parameter
Refresh interval (minutes) SpotCollector's web server provides updates every N minutes, where N is specified by this parameter
Restart Restart SpotCollector's web server, e.g. after a network outage

 

Spot Statistics panel

Update interval Specifies the interval (in minutes) at which spot statistics are updated to reflect spots which are more than 60 minutes old

 

Log file referenced for award progress

Use Log last opened by DXKeeper

consult the log file that was last opened by DXKeeper, and automatically switch to any new log opened in DXKeeper

Use Log in specified pathname specify a log file to be consulted independently of what log file was last opened in DXKeeper
Query operator when DXKeeper Log changes ask the operator to choose when a log is opened in DXKeeper that is different than the one currently being consulted by SpotCollector