vulcan xh558

[merlinflyer]

anyone picking up the vulcan she is over cambridgeshire at the moment
got her on radio but not on radar box

[BobR]

what freq you got her on?

[merlinflyer]

was on 297.8 and then 134.0500

[merlinflyer]

this is what  pickrd up
* 40109F                           G-VLCN  ...   Untitled             2008/09/04 18:33:21 

[testmonkey]

this is what  pickrd up
* 40109F                           G-VLCN  ...   Untitled             2008/09/04 18:33:21 

I picked it up again today - last seen 17:57:40

I can only assume your database needs updating as I get it displayed as

40109F   G-VLCN   VLCN   Avro 698 Vulcan B2   Vulcan To The Sky Trust

[merlinflyer]

i thought that i was automatic updated when it logs an aircraft or am i wrong

[testmonkey]

It only looks up and adds to the database for any ModeS code that you don't already have. This is to prevent changes that you've made being overwritten.

It also prevents AirNav's servers being hammered from requests for every aircraft we ever pick up :)

[merlinflyer]

just updated and now i should get the Silhouettes of the vulcan
thanks for the info testmonkey

[Paulc]

Does this update need to be done for every aircraft manually or is there an automatic method ?

[testmonkey]

It's all manual I'm afraid.

The closest you can get to an automated process within RB is to delete any 'non-complete' entries from your database. Next time the ModeS code is detected by your box RB will perform a lookup on the AirNav server. If you're lucky they'll have updated information for it. If not you're back to square one.

The alternative is to do your editing in an external SQLite application. This way you can export all of the records you need to change and do them in a single session. I tend to do mine by hand but I'm sure others will be along to tell you where / how you may be able to query an online resource in a batch process.

If you look in your Aircraft table you'll find a vast number (~36k) of ModeS codes that don't have any other details which are in the database by default. I removed them from mine so that on the off chance I do ever track them they'll hopefully retrieve more details but there's a possibility they are now defunct old codes. They may get re-assigned at some point though.

[tarbat]

There is a complicated way of doing batches of <100 corrections using an empty Basestation database, GAS RePopulate, and SQLite Maestro.  Described on this thread

[Paulc]

Testmonkey - thanks for the reply - will try the delete method as that suggested in the other thread is way beyond my knowledge.

[GM21]

Hi all, new user alert so be gentle if this sounds stupid. I am getting to grips with the database and how everything is refreshed and/or updated and have a query about how registrations are kept up to date. I had G-OHAJ recently going into EMA. On checking, this is not a current reg but i think should be G-TOYM (same frame but different reg). I am assuming from the previous posts that some form of database maintenance is essential? I have a database product that is well supported update wise so have a little faith i can use their lookup tool to get accurate code tie ups, but presume i need to be careful with the airnav database? Any further guidance on this subject would be appreciated.

[DaveReid]

Hi all, new user alert so be gentle if this sounds stupid. I am getting to grips with the database and how everything is refreshed and/or updated and have a query about how registrations are kept up to date. I had G-OHAJ recently going into EMA. On checking, this is not a current reg but i think should be G-TOYM (same frame but different reg). I am assuming from the previous posts that some form of database maintenance is essential? I have a database product that is well supported update wise so have a little faith i can use their lookup tool to get accurate code tie ups, but presume i need to be careful with the airnav database? Any further guidance on this subject would be appreciated.

The databases for both RadarBox and the competition are designed on the assumption that the relationship between airframe, registration and hex code doesn't change.

Unfortunately it does, so yes, regular database maintenance is essential.

[GM21]

Thanks for clarifying that Dave