MacLoggerDX

Add SOTAWatch to the DX Cluster list.

Andy (MM0FMF) supports a DXCLuster for SOTA spots. Topic on the SOTA DXCluster  – http://www.sotawatch.org/reflector.php?topic=8696#79117

You need to add this to the default DX Cluster nodes as loaded into the pop up list in the DXClusters button. This list is maintained in /Documents/MLDX_Logs/data_files/dxclusters.dat.

To customize this list, edit the dxclusters.dat file. Make a backup first just in case.  Ensure you save as a text file

Each list item has the following format: [Call sign][URL, with an option port number preceded by a colon][description]

Example file contents;

MM0FMF elgur.dtdns.net:7300 SOTA Cluster

K5NA k5na.net CW Skimmer

ZL2AQY-10 zl2aqy.ath.cx:9000 Auckland, New Zealand

Once saved, restart MacLoggerDX then you can enable auto tune to follow the spots as they come through. 

 

Script to create files for import into SOTAWatch.

I have a script used to gather data from MacLoggerDX database into files suitable to import into SOTAWatch. Currently uses month-year to select the data – “(strftime(“%m-%Y”,qso_start,’unixepoch’) = ’04-2014’);”. Any pointers as how to limit to the last two days or so would be appreciated.

Example Script for gathering data for April 2014. Files named getSOTA-042014.txt in this case;

.headers ON

.mode column

.output stdout

select “v2″,”VK3HRA/p”,trim(substr(my_sota,1,10)),strftime(“%d/%m/%Y”,qso_start,’unixepoch’),strftime( “%H:%M”,qso_start,’unixepoch’),rx_frequency,mode,call,trim(substr(sota,1,10)),’s’ ||rst_sent ||’ r’||rst_received from qso_table_v005 where (my_sota <>”” OR sota <> “”) and (strftime(“%m-%Y”,qso_start,’unixepoch’) = ’04-2014′);

.mode csv

.headers OFF

.output 04-2014-activate.csv

select “VK3HRA/p”,strftime(“%d/%m/%Y”,qso_start,’unixepoch’),strftime( “%H:%M”,qso_start,’unixepoch’),trim(my_sota),rx_frequency,mode,call,’s’ ||rst_sent ||’ r’||rst_received from qso_table_v005 where my_sota <>”” and strftime(“%m-%Y”,qso_start,’unixepoch’) = ’04-2014′;

 

.mode csv

.headers OFF

.output 04-2014-chase.csv

select “v2″,”VK3HRA/p”,trim(substr(my_sota,1,10)),strftime(“%d/%m/%Y”,qso_start,’unixepoch’),strftime( “%H:%M”,qso_start,’unixepoch’),rx_frequency,mode,call,trim(substr(sota,1,10)),’s’ ||rst_sent ||’ r’||rst_received from qso_table_v005 where (my_sota <>”” OR sota <> “”) and (strftime(“%m-%Y”,qso_start,’unixepoch’) = ’04-2014′);

.output stdout 

 

To use, go to the directory containing the files,

cd Documents/MLDX_Logs/

sqlite3 MacLoggerDX.sql

 

Execute the script,

sqlite> .read getSOTA-042014.txt

sqlite> .exit

You will be left with two files,

allen:MLDX_Logs allen$ ls -al 04-2014*

-rw-r–r–  1 allen  staff   7705 25 Apr 18:30 04-2014-activate.csv

-rw-r–r–  1 allen  staff  11392 25 Apr 18:30 04-2014-chase.csv

May need to open with Excel and sort by date and time if you have added out of sequence as SOTAWatch import not very happy when the dates are not sorted.

One response to “MacLoggerDX”

  1. David vk4mdx says :

    Fantastic. I have updated my dxcluster.dat

Leave a Reply

Fill in your details below or click an icon to log in:

WordPress.com Logo

You are commenting using your WordPress.com account. Log Out / Change )

Twitter picture

You are commenting using your Twitter account. Log Out / Change )

Facebook photo

You are commenting using your Facebook account. Log Out / Change )

Google+ photo

You are commenting using your Google+ account. Log Out / Change )

Connecting to %s

%d bloggers like this: