I had the need to download a number of WSPR CSV files so I threw together a PowerShell script. If anyone has the same need here is the PowerShell code to use as is at your own risk. It goes out to the WSPR web site and downloads the month you specify unzips the file and then creates a CSV file with only spots containing the call specified, then it deletes the downloaded ZIP and associated CSV files leaving only a file by the name of the call specified .csv. This was coded for a quick project and DOES NOT have any type of error checking and it assumes you know what input parameters are needed. I named the script download.ps1 and it needs three parameters: the year, month and call. If you run the script multiple times using the same call the results will be concatenated into the one call file.

# Script to download WSPR spot file, unzip file and create a specified call file.
# By N9RO January 01, 2012
# To run program CD to the script's directory and type ./download.ps1 year month call in the
# PowerShell window. New call file will appear the the script's directory.
param($year,$month,$call)
$source = "http://wsprnet.org/archive/wsprspots-$year-$month.csv.zip"
echo "***** Downloading file: $source *****"
Get-Date -DisplayHint time
$destination = "c:\projects\wspr-adif\wsprspots-$year-$month.csv.zip"
$wc = New-Object System.Net.WebClient
$wc.DownloadFile($source, $destination)
echo "***** File Download Complete *****"
# Now unzip File
echo "***** Unzipping WSPR File *****"
Get-Date -DisplayHint time
$shell_app=new-object -com shell.application
$filename = "wsprspots-$year-$month.csv.zip"
$zip_file = $shell_app.namespace((Get-Location).Path + "\$filename")
$destination = $shell_app.namespace((Get-Location).Path)
$destination.Copyhere($zip_file.items())
echo "***** Unzip complete *****"
# Create Call file
echo "***** Creating WSPR Call File for $call *****"
Get-Date -DisplayHint time

I put together a simple WSPR monitor script in PowerShell (PowerShell is part of Windows 7) so I could watch for activity during a recent test. If you wish to try it out as is no warranty I have it on my web site www.n9ro.com see "Simple WSPR Monitor".

Let us see if this little thing works?