New Server Database Populate Routine

Started by AirNav Development, April 13, 2010, 01:29:12 AM

Previous topic - Next topic

0 Members and 1 Guest are viewing this topic.

[email protected]

having difficulty with network just wondered if server was offline as I cannot connect up to it

jannuh

Quote from: vonsmalhausen on April 13, 2010, 08:14:14 AM
Thanks Airnav, this sounds verry promessing and is what most of us just want, i hope this update can be expected soon.
in the meanwhile, is there a kind soul who can give me ( and i'm shure others ) a step by step guide for dummies how to clean up that NavData db ; i don't want to mess up my system by trying to refresh my data
Is it a good idea to start all over again, with db and photos??

Did a new start with V3.13, Dec. 10th, got 13.927 planes in Mylog again, so within a few months I could get more up to date data...

abrad41

QuoteThe next stages will be to have a database which has a update/refresh proceadure and also allow the certain rows to be marked so they are not updated or refreshed, incase a customer is adding data manually that is not in our central database.

I think I shell be waiting until the above is complete before doing anything with my Navdata file, I have done a lot of manual updating of my database.

Even GAS don't have all the details of everything, I use a combination of GAS, Airframes etc etc to get all of my information.

Airnav - Can I just say (From the statment above), there is no way I am knocking what you are doing, you are moving things in the right direction - Thank you for that. I just find the combination of all the sites helps me.

Andy

tarbat

#18
Quote from: DaveReid on April 13, 2010, 07:48:21 AMOK, though I was rather hoping for an answer that didn't include the word "guess" :-)

Sorry that wasn't good enough for you Dave, but I don't have any inside information from Airnav, so a "guess" is the best I could do.

gleff

Just by curiosity, where do the routes come from?

Say an aircraft comes into view that isn't in the database.  It gets populated by the GAS data.  Is the routes a manual job, or does that come from GAS as well?
http://www.flighttracker.gleff.com - based in Sydney, Australia

tarbat


gleff

#21
Quote from: tarbat on April 13, 2010, 03:40:01 PM
I think (yes, a guess), that routes come from http://www.flightstats.com

So does that mean it's something I have to do manually, or does the radarbox software automatically get that at the same time it gets the other info from GAS?

I'm assuming it's a manual job.

http://www.flighttracker.gleff.com - based in Sydney, Australia

tarbat

No, it's NOT a manual job.  Routes are automatically retrieved from the Airnav servers, and I think they get the routes from flightstats.

You can see what route data is retrieved using the instructions posted at http://radarspotters.eu/forum/index.php/topic,878.0.html

gleff

#23
Ahhh.. ok.. thanks.

Airnav.. can you advise how up to date the routes are from your servers?  Eg.  Do you get the information from Flightstats or where ever you get it from once a day, once a year, every lookup??? 

I'm just trying to gauge how up to date they'll be so I can determine if I should go through them and update them manually.  The other day I saw a flight that was very wrong but I'm not sure if it was a one off thing or not.  I didn't take note of the details.
http://www.flighttracker.gleff.com - based in Sydney, Australia

tarbat

#24
This looks like a bug in the new server routine.  This aircraft has the REGISTRATION populated with the aircraft type.





I then corrected this to the correct registration (ZG511) in Database Explorer, but Radarbox overwrote my changes again.

Runway 31

I know how to amend data on Database Explorer but how do you add data.  When I note a new aircraft which inst on the database, if I click the add record button and nothing happens?

RodBearden

Runway 31

When you click Add, a new row is added at the bottom of the table - click on the table then press Ctrl-End, and you'll find it.

Rod
Rod

Runway 31

Cheers Rod, I will have a look and try it out.

Thanks

Alan

abrad41

QuoteThis looks like a bug in the new server routine.  This aircraft has the REGISTRATION populated with the aircraft type.
QuoteI then corrected this to the correct registration (ZG511) in Database Explorer, but Radarbox overwrote my changes again.

Chris are you still downloading the photo's with this

Andy

tarbat

Andy, yes.  Just highlighting that the new server routine appears to be mixing up the AR and AN fields.