AirNav Systems Forum

AirNav RadarBox and RadarBox24.com => AirNav RadarBox and RadarBox24.com Discussion => Topic started by: virtualradar on July 31, 2008, 07:18:53 PM

Title: Auto Populate
Post by: virtualradar on July 31, 2008, 07:18:53 PM
I was wondering if there is a auto populate programme for AirNav. If there is (which i hope there is) can someone tell me were to get it.
thanks
Colin
Title: Re: Auto Populate
Post by: tarbat on July 31, 2008, 07:46:46 PM
If you mean the equivalent of autopopulate from GAS, then it's built into Radarbox.  Radarbox automatically retrieves details of aircraft registration, etc. from the Airnav servers.
Title: Re: Auto Populate
Post by: markb on August 01, 2008, 01:12:19 AM
Open up your log, select tools and there's an option for populate there.....
Title: Re: Auto Populate
Post by: Allocator on August 01, 2008, 08:46:56 AM
Open up your log, select tools and there's an option for populate there.....

Autopopulate runs in the background all the time you are connected to the internet, updating the main NavData.db3 database.

The Populate option in MyLog only populates the records in MyLog.db3 using the data in NavData.db3.

For example, you pick up a new Live or Network aircraft with RadarBox.  There are no aircraft details in the list.  Autopopulate finds the details on the AirNav server and fills in the details.  If you look at the Aircraft in MyLog, the aircraft details will probably be missing, as the record was saved to MyLog.db3 before Autopopulate downloaded the details to NavData.db3.  Use Populate in MyLog and the details will be grabbed from NavData.db3 and filled in.

Fantastic, no mucking around with 3rd party programs, RadarBox does it all :-)
Title: Re: Auto Populate
Post by: Jetcos on September 22, 2008, 12:20:55 AM
Wondering about the populate feature. My aircraft total is slowly building and I do remember it constantly changing as it populated the aircraft. Now it just keeps getting bigger and bigger. Is there something I need to have on or a feature clicked?

Thanks,

Steve
Title: Re: Auto Populate
Post by: Allocator on September 22, 2008, 09:13:30 AM
Wondering about the populate feature. My aircraft total is slowly building and I do remember it constantly changing as it populated the aircraft. Now it just keeps getting bigger and bigger. Is there something I need to have on or a feature clicked?

Thanks,

Steve

Steve,

I don't really understand what the problem.  What just keeps getting bigger?  Is this the total number of aircraft in MyLog, or are you talking about the size of the NavData.db3 file?  In either case, what is the problem and what do you want to see or not see here?  I'm sure we can answer you question if we know what you are trying to achieve :-)
Title: Re: Auto Populate
Post by: tarbat on September 22, 2008, 11:00:47 AM
I see the same "problem".  The number of aircraft it attempts to populate (TOOLS - POPULATE) is now 79, and is increasing.

However, I don't think this is a problem.  This is simply the number of aircraft that ANRB is unable to find on GAS.  Although it may indicate that the GAS lookup process is not working again :(

If you sort your Log by Registration number, I bet you'll see a lot with blank registrations.
Title: Re: Auto Populate
Post by: Jetcos on September 22, 2008, 11:16:54 AM
Hi Guys,

If I go to My Log and then Populate the box comes up about how long it will take and then the box comes up with the total number of aircraft that will/may be populated. That number has never gotten amy lower, it keeps climbing. With the older version the number was (for example) 26 then when it was done it may be down to 5. Now it is almost 300 aircraft, this tells me that the populate feature is not working for me. I am on the internet when I am running RB at home, as I am using Flightaware also to help tie up the aircraft that are not on the map.

Thanks again,

Steve
Title: Re: Auto Populate
Post by: Allocator on September 22, 2008, 11:51:04 AM
Steve,

As I understand it - and I may be wrong - all the Populate function in MyLog does is to populate the records of aircraft you have already picked up and are recorded in the totally separate MyLog.db3

I think that it works like this:

- When you are connected to the internet and a new aircraft is picked up, the details are autopopulated from the AirNav Server.  These details are written to the main source database NavData.db3

- At the same time, live aircraft are written to MyLog.db3 as a record of what you have picked up via your antenna

- If it was a new aircraft with no details, and it was written to MyLog.bd3 before it autopopulated, then you will also have the details missing in MyLog

- If you use Populate in MyLog, the MyLog.db3 database is compared to the NavData.db3 database and any details missing in MyLog are populated from NavData

I've just used Populate in MyLog, and the first time the number of aircraft to populate was 99.  Did it a second time and it's 64, next it was 59 - so my records are being populated OK. I've got a total of 4883 aircraft in MyLog which was restarted with RB 2009.  You're never going to get a zero figure.

So, this is a fairly simplistic explanation of how I think the MyLog Populate function works.  Can anybody add to this?





Title: Re: Auto Populate
Post by: RodBearden on September 22, 2008, 12:03:25 PM
I think your general description of the process is correct, Allocator, but when you populate MyLog, the process seems to take much longer than it should if it was just locally interrogating NavaData.db3, and we get the same message as when RB is asking the AirNav server for Photo/Info requests for aircraft new to NavData.

I suspect that there's more going on here!

Rod
Title: Re: Auto Populate
Post by: Allocator on September 22, 2008, 12:07:37 PM
You could be right Rod.  The Processing Photo count doesn't tie in with the number of aircraft to populate though - 59 to populate, 22 photos being processed.

It does sound like Steve isn't getting the normal autopopulate for some reason if his MyLog populate figure is never decreasing.
Title: Re: Auto Populate
Post by: Bethsalem on September 23, 2008, 09:23:58 PM
I'm getting the same problem as Steve using v2.0, any ideas for a workaround or fix?
Title: Re: Auto Populate
Post by: AirNav Support on September 23, 2008, 09:27:20 PM
Whats happening is that is tried to populate those aircraft but finding no information. The proccesing just shows which ones its going through at that time.
Title: Re: Auto Populate
Post by: Allocator on September 23, 2008, 09:32:16 PM
I'm getting the same problem as Steve using v2.0, any ideas for a workaround or fix?

It's not a RadarBox problem otherwise we'd all be having the same problem.  

- What version of RB are you using?

- If you are using 2009, do you do an upgrade or a fresh install?

- What version of Windows are you using - Vista?

- Can you see Network traffic OK - thinking about Firewall issues here

- Do aircraft without details in the MyFlights and Network lists autopopulate as they appear?

This might give us an idea of what your problem is.
Title: Re: Auto Populate
Post by: Bethsalem on September 24, 2008, 08:49:42 PM
Allocator, I'm using RB 2009, XP Service Pack 3, and can see Network traffic with no problems.  The answer to your last question is not always.  I'm sure that if I reinstall RB 2009 the problem will disappear.  Which is something I will get around to doing when I get a moment :)  Thanks for your help.
Title: Re: Auto Populate
Post by: Allocator on September 24, 2008, 09:16:51 PM
Bethsalem, it autopopulate is working some of the time, then you should be OK :-)

You are never going to get all aircraft populating, as this depends on them being in the Gatwick Avaition Society database - used by RB to autopopulate.

If I want details on a specific aircraft that doesn't autopop, then I look it up at airframes.org - if it's not there either, then you're probably out of luck.
Title: Re: Auto Populate
Post by: Jetcos on October 27, 2008, 12:57:09 AM
Bumping this back up again,

I still don't think the Auto Populate is working, the number is climbing and not sure what the issue is. Any ideas out there?  Using RB 2009 and re-installed the full version.

TIA

Steve

Title: Re: Auto Populate
Post by: Paulc on October 27, 2008, 06:33:51 AM
Jetcos,

is the number of aircraft you get in 'database explorer' increasing ? I am having similar problems with autopopulate not doing what it should, having done 2 clean reinstallations. The routes seem to populate ok - just not the number of aircraft which is stuck at 80136. I have no problem wih seeing network aircraft and I currently have my firewall turned off to see if it was that causing the problems.
I am also using XP with service pack 3 which i noticed on another thread seems to have caused a few issues with unsigned drivers but I get no messages to that effect.
Title: Re: Auto Populate
Post by: Jetcos on October 27, 2008, 04:15:24 PM
Will look at the database explorer to see if it is increasing. I remember the previous versions doing the Auto Populate and coming back with a few that it couldn'y do (not in the GAS database yet etc) and the number would be lower. Now (as before) the Auto Populate number just keeps climbing.

I am running Windows XP with the SP 3 as well, Firewall is off.

Thanks,

Steve
Title: Re: Auto Populate
Post by: gsholland on November 05, 2008, 08:38:54 PM
I'm new to Airnav and having the same problem as the database is not auto populating.  Is there a fix?

Also I intend to take my box to places where I don't have an internet connection, is there any way I can upload a full up-to-date database file?

Thx/Greg
Title: Re: Auto Populate
Post by: Allocator on November 05, 2008, 10:08:25 PM
Greg,

What version of the RadarBox software are you running?

What makes you think that the autopopulate function isn't working?

When you are not connected to the Internet, RadarBox will use the included database so you will still get aircraft details unless it is a newly detected aircraft that isn't in the database.

Title: Re: Auto Populate
Post by: gsholland on November 05, 2008, 10:58:38 PM
Hi Allocator,

I am running the 2009 software.  I have lots of aircraft that that are not giving the reg details and the database has stayed static at 80139 records.

One example...  Hexcode 4059E4 is G-FDZJ and was delivered in April, so I would expect that to appear.  There are lots of other examples.

Thanks for any help.

Cheers/Greg
Title: Re: Auto Populate
Post by: Allocator on November 05, 2008, 11:07:33 PM
Greg,

Are you getting the photo thumbnails downloading?  Once again, the number of photos in the /Photo directory should increase as new aircraft are detected.

Can you see Network traffic OK when connected to the internet?
Title: Re: Auto Populate
Post by: gsholland on November 05, 2008, 11:58:29 PM
Hi,

I have switched on the photos and it all works now.  I had the photos off to save bandwidth.

Would it be possible in the next version of having the ability to upload your own csv file or even better allow you to update the database fully, so when you are offline you do not miss the data?

Thx/Greg
Title: Re: Auto Populate
Post by: tarbat on November 06, 2008, 08:02:08 AM
Would it be possible in the next version of having the ability to upload your own csv file or even better allow you to update the database fully, so when you are offline you do not miss the data?
You can already update the database using the Database Explorer, on the File menu.  Just select the Aircraft table.
Title: Re: Auto Populate
Post by: Paulc on November 07, 2008, 01:28:15 PM
Surely you should not need to update the database manually (with new aircraft) if the GAS database is kept up to date (relatively speaking) Airnav have told me that they update each day and so the info received from Airnav should be the latest available.

I note above that turning off photos was causing a problem with autopopulate - I also turn the pictures off to save processing power + do not really need them but I may have to turn them back on if it resolved my problem with autopopulte not working.
Title: Re: Auto Populate
Post by: AirNav Support on November 07, 2008, 02:08:53 PM
Turn on photos, you can select so it download one photo.

Photo downloading and showing does not affect the processing too much.

The main items for processing are:

- Refresh time
- Network
- Uploading to a server
Title: Re: Auto Populate
Post by: gsholland on November 08, 2008, 02:36:05 PM
Guys,

This is all fine and dandy if you are connected to the web.  But I bought my Airnav to be used "on the go" and don't want to have to wait until I get home to tie-up hexcodes.  Surely it should be possible to download the whole database, so you don't have to be relient on being connected to the net when a newish aircraft appears?

My point about uploading an csv is that it is alot easier to export a personal database as .csv than as a .sqb.  This would mean that people could load their own data, exactly as they want it.

I hope these points are put into action as lots of spotters want to use their boxes on the go an not at home.

Greg

Title: Re: Auto Populate
Post by: tarbat on November 08, 2008, 02:55:22 PM
Surely it should be possible to download the whole database, so you don't have to be relient on being connected to the net when a newish aircraft appears?

It depends on what you mean by the whole database.  Aircraft are constantly getting ModeS codes allocated, so it's a constantly moving target.

You could try converting one of the SBS-1 databases that are available for download - see my previous post on this at http://www.airnavsystems.com/forum/index.php?topic=1279.msg9511#msg9511 (http://www.airnavsystems.com/forum/index.php?topic=1279.msg9511#msg9511).  But they're out-of-date as soon as you download them.    And they're big!!  A CSV extract from the Aerodata database (>90000 aircraft), which only contains ModeS, Registration, and ICAO Type is over 2mb.

My point about uploading an csv is that it is alot easier to export a personal database as .csv than as a .sqb.

Get hold of a copy of SQLite Maestro, and you can import .csv files into the databases.
Title: Re: Auto Populate
Post by: Paulc on November 08, 2008, 08:48:50 PM
Tried using my system with photo's being downloaded and it looks as if it is populating the aircraft now as well - the number of aircraft has increased considerably. However having checked the aircraft database I have found some obvious aircraft are still not included. ie Flybe have several Emb195's- G-FBEA, B etc - now A & b are listed but no others which is a concern considering all of the remaining ones are in the GAS database and some were delivered over a year ago. Airnav have told me that they update on a daily basis from GAS yet these (and no doubt others) aircraft are still missing from the database.
Title: Re: Auto Populate
Post by: tarbat on November 08, 2008, 10:41:09 PM
Paulc, glad you've got autopopulate working okay now, by enabling photos.  Maybe this needs an FAQ, since it's not something I realised about Radarbox.

Yes, it's dissapointing if aircraft aren't getting populated from GAS promptly.  I use my own SQL routines to populate from GAS on a weekly basis, and I've got a full(ish) set of Flybes from GAS.
Title: Re: Auto Populate
Post by: Paulc on November 09, 2008, 08:24:05 AM
Me too - people do need to be made aware of this.

It is a shame that updates from GAS are not more prompt but to have aircraft delivered over a year ago and still not be in the system is imo poor and does let the system down badly.
Title: Re: Auto Populate
Post by: Allocator on November 09, 2008, 08:42:49 AM
Paulc, glad you've got autopopulate working okay now, by enabling photos.  Maybe this needs an FAQ, since it's not something I realised about Radarbox.

The only time I remember an autopoulate/photo download problem was way back in one of the early versions of RB.  I'll try this today and see what happens.
Title: Re: Auto Populate
Post by: AirNav Support on November 09, 2008, 01:03:05 PM
PaulC,

Please note its not ALL aircraft which have that issues. The A380s and other new aircraft appear fine in the database from GAS. However certain types have trouble getting past across (we are looking at this)

However regardless if you want a 99.9% updated database you will need to do some manual work as the complexity behind such a ever changing database is enormous.
Title: Re: Auto Populate
Post by: Paulc on November 09, 2008, 04:59:01 PM
Can you say which types have problems so I can possibly add those details manually? I am guessing that Embraer & Bombardier types are a particular problem which is a pity as that is all (pretty much) that ever uses my local airport.

Accept that it is never going to be 100% up to date but still maintain that if an aicraft is in GAS then it should be in airnav.

Title: Re: Auto Populate
Post by: Allocator on November 09, 2008, 05:32:20 PM
Tried using my system with photo's being downloaded and it looks as if it is populating the aircraft now as well - the number of aircraft has increased considerably. However having checked the aircraft database I have found some obvious aircraft are still not included. ie Flybe have several Emb195's- G-FBEA, B etc - now A & b are listed but no others which is a concern considering all of the remaining ones are in the GAS database and some were delivered over a year ago. Airnav have told me that they update on a daily basis from GAS yet these (and no doubt others) aircraft are still missing from the database.


I think that these aircraft are in the database - are you looking at MyLog or are you using Database Explorer to check the main NavData database?

There is a problem though in that the DH8D, RY85 and E160 aircraft in the database have the short type as "..." and this stops the record from being overwritten wwith the correct type name and it also stops the silhouettes showing.  I've got the whole G-BFE* series showing when I use Database Explorer.  I don't think that I've put these in manually, although I have probably manually corrected the short name.
Title: Re: Auto Populate
Post by: Paulc on November 09, 2008, 05:55:13 PM
am using database explorer to look for them and having looked about an hour ago were not there but having just looked they appeared since - perhaps my system is still playing catchup
Title: Re: Auto Populate
Post by: gzerovti on November 11, 2008, 02:12:26 PM
I am also having problems with the auto populate function.

I have just tracked two flights in Myflights an Egypt Air and an Emirates. Neither flight has shown up in Mylog even after I have used the populate function in Tools.

Both aircfaft were tracked at about 1304 and 1330 respectively but at 1411 have not shown up??

I am using Vista and V 2009 software.

Terry
Title: Re: Auto Populate
Post by: Allocator on November 11, 2008, 05:52:28 PM
They will be in MyLog, but maybe they are not populated with the aircraft details?

Did they have full details in MyFlights, or just the Mode S code?

How are you trying to find the aircraft in MyLog?