This is the new version of my old website. You can find the old website here: old.dl2sba.com. If you miss any information or you find bugs, please let me know by E-Mail

Inspired from some work found on the Internet and the full functionality of my U3S I've build an automatic spot collector. The spot collector pulls every 5 minutes my spots from WSPRnet.org and puts it into a MYSQL database for later analysis. See the schematic for this setup Wspr V3

The data is retrieved via the old database interface on WSPRnet.org. For this job, I've written a small C-application running on an already running RASPBERRY-PI used for my IoT sensors.

The application uses the well-know libraries CURL, XML2 and TIDY for processing the HTML response from WSPRNET. After the page is processed with CURL and TIDY, each spot retrieved from WSPRnet.org is inserted into an MYSQL database running on my SYNOLOGY DS213+ NAS.

Installing the MYSQL ODBC driver on my Windows10 desktop PC gives direct access to the spot data stored in the MYSQL database with i.e. a standard MS EXCEL sheet.

The data can be analysed via Microsoft Excel - check this post.


Stay tuned - more details will come soon ...

 

(c) Dietmar Krause, DL2SBA 2026 Impressum Datenschutz
Cookies user preferences
We use cookies to ensure you to get the best experience on our website. If you decline the use of cookies, this website may not function as expected.
Accept all
Decline all
Marketing
Set of techniques which have for object the commercial strategy and in particular the market study.
Quantcast
Save