How to stop changing data

[DaveReid]

http://www.airnavsystems.com/download/anrb/databaseupdates/NavData.db3

It shouldn't really be any more complicated than that ...

[Marpleman]

http://www.airnavsystems.com/download/anrb/databaseupdates/NavData.db3

It shouldn't really be any more complicated than that ...

I'm getting a "dead" link on that page Dave???

[tarbat]

Is the central Airnav database now up-to-date with all these updates.  If so, think I'll have a go at writing a VB program that:
1. Goes through each aircraft record in navdata.
2. Takes the ModeS hex code (HHHHHH).
2. Calls http://www.airnavsystems.com/cgi-bin/ANLV_SV/ANLV_SV_user.exe?usgetphoto=0&usverify_name=PGANRB111111&usversion=ANRB301&modes=HHHHHH
3. Takes the returned CSV data, and updates the aircraft record.

[DaveReid]

http://www.airnavsystems.com/download/anrb/databaseupdates/NavData.db3

It shouldn't really be any more complicated than that ...

I'm getting a "dead" link on that page Dave???

My point exactly !

[DaveG]

Just for your info.  (also posted this in the other place)

The main database has currently 69637 records, and we have manually checked 31,025 to todays date, which leaves 38,612 still to check.

Majority of main production models within DB have been completed in this first push but still lots to keep us busy.

Dave

[DaveReid]

Is the central Airnav database now up-to-date with all these updates.  If so, think I'll have a go at writing a VB program that:
1. Goes through each aircraft record in navdata.
2. Takes the ModeS hex code (HHHHHH).
2. Calls http://www.airnavsystems.com/cgi-bin/ANLV_SV/ANLV_SV_user.exe?usgetphoto=0&usverify_name=PGANRB111111&usversion=ANRB301&modes=HHHHHH
3. Takes the returned CSV data, and updates the aircraft record.

Yes, but (correct me if I'm wrong) that won't populate the AT (ICAO type code) column in the Aircraft table.

By the way, you're cheating - that's 4 steps, not 3  :-)

[bratters]

I am sure I am not alone when I say I don't want to get involved with SQLite or any other, seemingly  "complex" PC centred work.

Understood.  But some of us are very happy to use a few commands to correct our local database.   I just wish Airnav would give us the choice.  They could issue a CSV file containing all updates after a certain date, for example.

With your knowledge and ability Tarbat so would I!

However my fear is that we could run the danger of establishing a two-tier community. Those (the few) who have up to date DBs in their RBs and those (the majority) who haven't.

As I see it, we are not discussing an optional add-on application here - this is about an integral and important part of RB operation and it has to be available to one and all.

[AirNav Support]

All,

We have amended the post below in our FAQ to answer some of the common questions about the database.

http://www.airnavsystems.com/forum/index.php?topic=2688.0

Work is ongoing on a update to the software so it can update records in the local database. We hope to have more news on this soon.

Please do not use method Tarbat has mentioned as that will overload the server with requests.

We apologise for the delay and we are doing our best that the software is rolled out as soon as possible and works 100%.

We want to keep everyone on the same page so we don't want to roll out csv's just yet. Though we may provide a navdata database with the latest entries from the AirNav database, we will look into that.

We also like to thank the database updates for there efforts so far.

[Chris11]

Thanks - That's the info I needed

[DaveReid]

We have amended the post below in our FAQ to answer some of the common questions about the database.

http://www.airnavsystems.com/forum/index.php?topic=2688.0

You could usefully update your description on the above page of how and why Mode S codes change:

Mode-S IDs can also change there [sic] link to registrations. Example G-EUUT could go out of service and then 401240 is assigned to G-ELLB (In rare cases, usually the Mode-S link to registration stays the same).

That's not a "rare case", it's an example that can't ever happen - Mode S codes never get reassigned to a different aircraft in the UK, and indeed Mode S-to-registration tieups rarely change in any part of the world.

[AirNav Support]

Its been changed, thanks, anything else you think will explain the process better please say.

[Chris11]

That's not a "rare case", it's an example that can't ever happen - Mode S codes never get reassigned to a different aircraft in the UK, and indeed Mode S-to-registration tieups rarely change in any part of the world.

Maybe in the first world - try 3rd world CAA government officials. :)