anything
AirNav RadarBox
Welcome, Guest. Please login or register.
Did you miss your activation email?

Login with username, password and session length
 


Author Topic: Reporter function in version 2.0  (Read 4299 times)

0 Members and 1 Guest are viewing this topic.

John Racars

  • Hero Member
  • *****
  • Posts: 801
Reporter function in version 2.0
« on: September 06, 2008, 09:12:22 AM »
Hello All,

Analysing my reports since version 2.0 I understand that every Aircraftreg will be reported once a day. This while many of de same Aircraftregs make more different flights during the day in my area of reception. So it looks that the programm overwrite the forgoing flight of a specific Aircraftreg.

When it is the intention of the Reporterfunction to report Aircraftregs only then it looks all normal. But I was hoping that it should report all different flights as well.

So I am asking me or all this is normal or is this a problem that should be solved?

I am verry interested in how other members look to this.
Best Regards from the Netherlands, John Racars
13 NM East of EHAM
-
ANRB:
Version: 3D - 5.00.072
Antenna: outside WiMo GP-1090 (with ECOFLEX 10 cableconnection)
PC: Windows 7 SP 1 - 64 bit
-
RadarBox24 station: EHAM4

belgianguy

  • New Member
  • *
  • Posts: 38
Re: Reporter function in version 2.0
« Reply #1 on: September 07, 2008, 07:14:35 AM »
Hi,

It's correct that the reporter function only makes a list of aircraft contacted that day or the day before. It doesn't show you how many times the aircraft was seen.

If you want to make a report for other days or only for a certain airline, then you should use the filters in the grids of MyLog and then you need to make a report via the "tools" menu.

Also via that way you would only see a single line for an aircraft and not how many times the aircraft was seen that day.

It would be interesting to have the possibility to make a report for a certain aircraft or a certain airline to see how many times they came over our heads.

tarbat

  • ShipTrax Beta Testers
  • Hero Member
  • *
  • Posts: 4219
    • Radarbox at Easter Ross
Re: Reporter function in version 2.0
« Reply #2 on: September 07, 2008, 07:32:23 AM »
You could run something like this in SQL:

SELECT DISTINCT
  Aircraft.LastTime,
  Aircraft.ModeS,
  Flights.Callsign,
  Flights.Route,
  Aircraft.Registration,
  Aircraft.AircraftTypeSmall,
  Aircraft.Airline,
  Flights.EndTime
FROM
 Aircraft
 LEFT OUTER JOIN Flights ON (Aircraft.ModeS=Flights.ModeS)
WHERE
  (Aircraft.LastTime >= "2008/09/06")
ORDER BY
  Aircraft.ModeS

John Racars

  • Hero Member
  • *****
  • Posts: 801
Re: Reporter function in version 2.0
« Reply #3 on: September 07, 2008, 07:56:22 AM »
Hi,

Thank you all for your reaction. Highly appreciated!

But, how more I analyse the reports how more "strange things" I see.

Yesterday evening the totalnumbers of seen aircraft of saturday, september 6th, was about 2700. Now this morning, when I generate the same report, it was decreased to round about 2000. Also 700 aircrafts gone. The same happens the day before.

Verry striking also is the disappear of almost all (also NOT all) KLM Airbusses A332 from  the reports. Yesterday evening when I looked to the report 10 KLM Airbusses where seen. This morning, when I generate the same report only two left. The day before yesterday the same happens as well.

For your further information: I have NO filters on!!

Until sofar I do not see where I made wrong settings in the programm. Any help will be verry welcome.
Best Regards from the Netherlands, John Racars
13 NM East of EHAM
-
ANRB:
Version: 3D - 5.00.072
Antenna: outside WiMo GP-1090 (with ECOFLEX 10 cableconnection)
PC: Windows 7 SP 1 - 64 bit
-
RadarBox24 station: EHAM4

tarbat

  • ShipTrax Beta Testers
  • Hero Member
  • *
  • Posts: 4219
    • Radarbox at Easter Ross
Re: Reporter function in version 2.0
« Reply #4 on: September 20, 2008, 02:17:41 PM »
A modification to my report, so that it always shows YESTERDAY's flights:

SELECT DISTINCT
  Aircraft.ModeS,
  Flights.Callsign,
  Flights.Route,
  Aircraft.Registration,
  Aircraft.AircraftTypeSmall,
  Aircraft.Airline,
  Flights.EndTime,
  date('now','-1 day') AS FIELD_1,
  substr(Aircraft.LastTime,1,4)||"-"||substr(Aircraft.LastTime,6,2)||"-"||substr(Aircraft.LastTime,9,2) AS FIELD_2
FROM
 Aircraft
 LEFT OUTER JOIN Flights ON (Aircraft.ModeS=Flights.ModeS)
WHERE
  (FIELD_1 = FIELD_2)
ORDER BY
  Aircraft.Registration,
  Aircraft.ModeS