Plane Plotter Report

Plane Plotter Report with text output

This is a toolkit of programs and a command script to produce and e-mail daily mode-S logs from Plane Plotter automatically.  The default single-date/time format is acceptable to Alexis's Robot for log checking hex => registration purposes.

You need to make Plane Plotter create daily reports in SQLite format.

  • Menu: File => Report => Setup report format
  • Set: Automatic reports at intervals of 0 minutes
  • Check: Create daily first/last database
  • Check: Report only local aircraft
  • Click: OK

These reports will appear in the designated Plane Plotter Log Files directory, and will have file names such as: pp_report2016100300.sqb (previously: pp_report20140612.sqb)

As this is free software, support is via a self-help group:

Download:  (remember to right-click, Properties, Unblock after download)

V2.0.0 2012-Feb-20 More user-friendly format, splits Hex/Callsign/Reg into separate fields.
V2.1.0 2012-May-29 Update for Plane Plotter, report name changed from pp_report20120527.sqb to pp_report2012052800.sqb
V2.1.1 2013-Feb-27 Add example of multiple e-mail recipients.
V2.2.0 2014-Jan-28 Add option for both first and last times.
Uncomment: set PPReportBothTimes=Y
2014-Apr-13 Note what directory to use for "Start in".
2014-Jun-13 Add note about using SSL for e.g. gmail servers.
V2.2.1 2016-Oct-03 Make date string more user-friendly.
V2.2.2 2016-Nov-09 Ignore hex codes with "?", likely satellites.
The program SplitFields.exe has been updated

But I want to make reports for days other than "yesterday"

In the script, the command  GetYesterday  can take a parameter specifying the number of days offset from today, which by default is -1, giving "today-1" i.e. yesterday, so making the line:

for /f "tokens=*" %%i in ('GetYesterday -2') do set YESTERDAY=%%i00

would look for a report for the day before yesterday and so on.  Note the space between the  GetYesterday  and the  -2.  You could try  +0  for today's report (untested).  Alternatively, putting:

set YESTERDAY=2013072200

after the GetYesterday line would force a fixed date of 20130722 (don't forget to add the "00" to match the report .sqb name).

I do suggest turning off the mailing part of the script before you try this!

Plane Plotter Report with Web output

Dave Giffney writes:

Bev has been in contact and with a little of his help the script is better, and now v2.

The Web outputted page now has the column data correctly separated and formatted.  As a by-product of this, have tweaked your text output to use new .vbs file so the first column also is split into three separate columns.

Download:  (remember to right-click, Properties, Unblock after download)


You may need to make the change for the new log naming convention when using the above, as it hasn't been updated by the author.  If you like to update your own copy by hand, it's a simple edit to change:

for /f "tokens=*" %%i in ('GetYesterday') do set YESTERDAY=%%i


for /f "tokens=*" %%i in ('GetYesterday') do set YESTERDAY=%%i00

at or around line 40. I.e. add "00" (two zero characters) after the "%%i".


Coverage and 1.09 GHz RF filter notes

For my coverage and 1.09 GHz RF filter notes please see this page.

Copyright © David Taylor, Edinburgh   Last modified: 2016 Nov 09 at 12:09