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

Login with username, password and session length
 


Author Topic: Query regarding updating database explorer  (Read 4956 times)

0 Members and 1 Guest are viewing this topic.

DAFO1711

  • New Member
  • *
  • Posts: 18
Query regarding updating database explorer
« on: March 04, 2009, 04:58:27 PM »
Hi everyone,

Can anyone help with this small query I have.

I have been on RB for a week or so now but cannot find an answer on the forum to this question:-

If I update my database with the details of a new aircraft or an amendment etc does this only update my own database or the central database as well.

I have tracked a number of aircraft which are displaying an old or out of date registration and operator.

I have changed the details within database explorer but what does what actually change.

Many thanks for your support.

Dave

Allocator

  • RadarBox24.com Beta Testers
  • Hero Member
  • *
  • Posts: 3568
Re: Query regarding updating database explorer
« Reply #1 on: March 04, 2009, 05:00:52 PM »
Dave,

It will only update the database on your PC.

DAFO1711

  • New Member
  • *
  • Posts: 18
Re: Query regarding updating database explorer
« Reply #2 on: March 04, 2009, 07:59:12 PM »
Allocator,

Only thanks, understand that bit now!
How then does new data get to my database.
For eg. Ryanair take receipt of a new 737-800, and hexcode for the aircraft is say400xxx, Who updates that 400xxx is aircraft EI-EBH. Is that downloaded from the server to my database??

Dave

Allocator

  • RadarBox24.com Beta Testers
  • Hero Member
  • *
  • Posts: 3568
Re: Query regarding updating database explorer
« Reply #3 on: March 04, 2009, 08:49:26 PM »
Dave,

I'll keep this short :-)

- The Gatwick Aviation Society (GAS) maintain an online database for free - nice people manually updating the database.  They try very hard, but it's never going to be 100% accurate for obvious reasons :-)

- RadarBox comes with a huge database built in, just in case you never connect to the internet. This is the NavData.db3 main database.

- Run RB without an internet connection and it's the data in DataBase.db3 you will see.  This data is also written to the separate MyLog.db3 database for when you use MyLog

- Of course, the NavData.db3 database was out of date the moment it was released - for just the same reason as the GAS database is never up to date - things change!

- If the aircraft details are not in NavData.db3 then the aircraft data line will be missing most of the details.

- If you run RB connected to the Internet and the aircraft details are missing from NavData.db3, and they are in the AirNav Server database - which is regularly populated by the GAS database - then NavData.db3 will be auto-populated and the aircraft details will appear.

- Disconnect from the internet, and all those new records in NavData.db3 are still available to you :-)

Clear as mud?

DAFO1711

  • New Member
  • *
  • Posts: 18
Re: Query regarding updating database explorer
« Reply #4 on: March 04, 2009, 09:43:23 PM »
Acutally mate thats pretty clear!!!

I was concerned that any tom dick or harry could update the main server database.

its good to know we are all in safe hands :-)

Thanks for your patience in explaining to me

Dave

Allocator

  • RadarBox24.com Beta Testers
  • Hero Member
  • *
  • Posts: 3568
Re: Query regarding updating database explorer
« Reply #5 on: March 04, 2009, 10:08:29 PM »
Dave,

My pleasure - there's no such thing as a silly question here as we're all still learning.

There is always room for improvement in any database and auto-populate system, but it can get very complicated.  A NavData.db3 aircraft record won't get overwritten if data is already present - a good thing if you've updated the record manually yourself, not good if the data is incorrect.  People have suggested all sorts of "rules" for the auto-populate, all good ideas, but a programmers nightmare!

All in all, it works very well :-)

DAFO1711

  • New Member
  • *
  • Posts: 18
Re: Query regarding updating database explorer
« Reply #6 on: March 04, 2009, 10:21:28 PM »
Alloator, one last thing

What happen if an airline is sold but retains the same HexCode?
Take my example with G-MIDK / G-OZBN - are we saying that my NavData.db3 file will be not be updated - which meas each user does his own datafile??

Gets confusing this !!!


Allocator

  • RadarBox24.com Beta Testers
  • Hero Member
  • *
  • Posts: 3568
Re: Query regarding updating database explorer
« Reply #7 on: March 05, 2009, 08:40:42 AM »
Alloator, one last thing

What happen if an airline is sold but retains the same HexCode?
Take my example with G-MIDK / G-OZBN - are we saying that my NavData.db3 file will be not be updated - which meas each user does his own datafile??

Gets confusing this !!!



If there is a valid (although possibly out of date) record in NavData.bd3, it will not be overwritten by auto-populate.

You have 2 choices - first you can manually update the record using Database Explorer - or, providing that the GAS database has been updated, you can delete the record in NavData.db3 and wait for it to auto-populate next time the aircraft is picked up.  I prefer the manual update route.

As an aside, if the aircraft is showing a valid Flight ID (callsign) then the company logo will always be correct, as this is displayed based on the Flight ID.  However, the company name in your example will be wrong until you update NavData.

mike L

  • Jr. Member
  • **
  • Posts: 61
Re: Query regarding updating database explorer
« Reply #8 on: March 05, 2009, 09:53:08 PM »
You have 2 choices - first you can manually update the record using Database Explorer - or, providing that the GAS database has been updated, you can delete the record in NavData.db3 and wait for it to auto-populate next time the aircraft is picked up.  I prefer the manual update route.

Hi
 I prefer the manual update but when i put the new info in (airline  or company)
and i am connected to; the internet when the plane is picked up the next time
my info is overwriten this is in the navdata.bd3 database ie ac changes to
a blank or untitled
what have i got wrong
PS is there a fix for M-XXXX being marked as RAF

mike L

abrad41

  • Guest
Re: Query regarding updating database explorer
« Reply #9 on: March 06, 2009, 10:39:33 AM »
Mike

I don't think you have nothing wrong - I have come across this myself, were details have been changed in Navdata file. There is people who say this do not happen, but it does.

Cheers

Andy

tarbat

  • ShipTrax Beta Testers
  • Hero Member
  • *
  • Posts: 4219
    • Radarbox at Easter Ross
Re: Query regarding updating database explorer
« Reply #10 on: March 06, 2009, 10:47:08 AM »
PS is there a fix for M-XXXX being marked as RAF

If you mean the flag, then yes.   See http://www.airnavsystems.com/forum/index.php?topic=1906.msg15294#msg15294

mike L

  • Jr. Member
  • **
  • Posts: 61
Re: Query regarding updating database explorer
« Reply #11 on: March 06, 2009, 11:38:48 AM »
Hi andy and tarbat
Thanks for that its not just me than
 
mike