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

Login with username, password and session length
 


Author Topic: 1000 up  (Read 37677 times)

0 Members and 1 Guest are viewing this topic.

Squad 701

  • Jr. Member
  • **
  • Posts: 51
Re: 1000 up
« Reply #30 on: May 31, 2009, 10:51:19 PM »
Hi Glyn,
Your officially an A-Lister now.
You passed the 2500 mark by 16.
I bow my hat to you :-)
Your the Man.

Have to agree with you on the Midnight UTC thing,
very annoying, roll on version 2.1

John Racars

  • Hero Member
  • *****
  • Posts: 801
Re: 1000 up
« Reply #31 on: June 01, 2009, 07:48:39 AM »
Hi All,

Here the results of my 24 hrs listening yesterday, may 31th. I do not believe this numbers are reliable. This because the "strange" reporting of "My Log":

yesterdays intermediate scores:

09:38 - 1197 Aircraft Logged;
18:20 - 2747 Aircraft Logged;
18:38 - 2769 Aircraft Logged;
23:11 - 2886 Aircraft Logged;

Now when I get the total report of yesterday "My Log" says:

2092 Aircraft Logged. Unbelievable.

I think there is for the time being no sense to make reports like this any more; it should be made better in next coming version(s).

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

AirNav Support

  • AirNav Systems
  • Hero Member
  • *****
  • Posts: 4124
Re: 1000 up
« Reply #32 on: June 01, 2009, 08:15:13 AM »
John,

This has been explained dozens of times now. Please read our message earlier in this thread regarding it.
Contact Customer/Technical support via:
http://www.airnavsystems.com/contact.html
[email protected]

John Racars

  • Hero Member
  • *****
  • Posts: 801
Re: 1000 up
« Reply #33 on: June 01, 2009, 08:36:06 AM »
This has been explained dozens of times now. Please read our message earlier in this thread regarding it.
OK Support, thank you and verry sorry for the inconvenience,

I will do as you recommend in this message (using the SQLite software):

http://www.airnavsystems.com/forum/index.php?topic=2395.msg20129#msg20129
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

John Racars

  • Hero Member
  • *****
  • Posts: 801
Re: 1000 up
« Reply #34 on: June 01, 2009, 09:19:37 AM »
Hi All,

Now I have analysed "MyLog" > "Flights"-database with the beautiful SQLite software. This becomes an impressiv new number of logs.

I filtered out the records of yesterday that gives this result:

Sunday, may 31th 2009 from 00:00 - 23:59 UTC: 4273 Aircraft Logged.

If you are interested in the list, please let me know and I will sent it to you.
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

John Racars

  • Hero Member
  • *****
  • Posts: 801
Re: 1000 up
« Reply #35 on: June 01, 2009, 09:41:35 AM »
Hi Support,

Any chance that "Aircrafttype" will displayed in the "MyLog" > "Flights" table in the next new coming version(s) as well?
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: 1000 up
« Reply #36 on: June 01, 2009, 10:51:20 AM »
John,

Aircrafttype is in the Aircraft table, so just do a " LEFT OUTER JOIN Aircraft ON (Flights.ModeS=Aircraft.ModeS)" to join the tables, and you can then pull data from the Aircraft table as well.

John Racars

  • Hero Member
  • *****
  • Posts: 801
Re: 1000 up
« Reply #37 on: June 01, 2009, 11:10:55 AM »
Thank you Tarbat!

I will give it a try the next coming hours!
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

John Racars

  • Hero Member
  • *****
  • Posts: 801
Re: 1000 up
« Reply #38 on: June 01, 2009, 11:59:08 AM »
Aircrafttype is in the Aircraft table, so just do a " LEFT OUTER JOIN Aircraft ON (Flights.ModeS=Aircraft.ModeS)" to join the tables, and you can then pull data from the Aircraft table as well.

Hi Tarbat,

I did not have any succes with this until sofar. Can you, or some other SQL specialist, give me the SQLite syntaxes for this routine?

Thank you in advance!
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: 1000 up
« Reply #39 on: June 01, 2009, 12:03:04 PM »
SELECT 
  Flights.Route,
  Flights.Callsign,
  Flights.EndTime,
  Flights.ModeS,
  Flights.MsgCount,
  Flights.Registration,
  Flights.Session,
  Flights.StartTime,
  Flights.StartPosition,
  Flights.EndPosition,
  Flights.StartAltitude,
  Flights.EndAltitude,
  Flights.StartGS,
  Flights.EndGS,
  Aircraft.Comment,
  Aircraft.LastTime,
  Aircraft.FirstTime,
  Aircraft.AircraftTypeLong,
  Aircraft.AircraftTypeSmall,
  Aircraft.Airline,
  Aircraft.ModeS,
  Aircraft.ModeSCountry,
  Aircraft.Registration,
  Aircraft.ADSB
FROM
 Flights
 LEFT OUTER JOIN Aircraft ON (Flights.ModeS=Aircraft.ModeS)

John Racars

  • Hero Member
  • *****
  • Posts: 801
Re: 1000 up
« Reply #40 on: June 01, 2009, 12:17:51 PM »
Thank you verry much Tarbat!

No succes yet: SQL Error: near "LEFT": syntax error

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: 1000 up
« Reply #41 on: June 01, 2009, 12:26:09 PM »
Strange, works okay for me.

Can you post the SQL you're using.

John Racars

  • Hero Member
  • *****
  • Posts: 801
Re: 1000 up
« Reply #42 on: June 01, 2009, 12:34:47 PM »
Can you post the SQL you're using.

I am using SQLiteMaestro version 8.11.0.1
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

malc41

  • RadarBox Beta Testers
  • Hero Member
  • *
  • Posts: 586
Re: 1000 up
« Reply #43 on: June 01, 2009, 12:38:51 PM »
Shouldn't make any difference that is what I use as well?
15 Miles East of EGNJ

tarbat

  • ShipTrax Beta Testers
  • Hero Member
  • *
  • Posts: 4219
    • Radarbox at Easter Ross
Re: 1000 up
« Reply #44 on: June 01, 2009, 12:58:24 PM »
I am using SQLiteMaestro version 8.11.0.1

Okay, I also use SQLite Maestro.   Query should look something like this in Maestro.

Post the SQL you're using, and we can maybe see what's going wrong for you.