AirNav Systems Forum

AirNav Radar => AirNav Radar Discussion => Topic started by: mdobuk21 on February 26, 2009, 10:57:35 PM

Title: database editing
Post by: mdobuk21 on February 26, 2009, 10:57:35 PM
Hi

I would like to edit some of the airline names in the database to my own liking, i was wondering if there is a quick way of doing this? for example i want to change USA - Airforce, to AMC or ANG, as there are so many usaf mil aircraft in the database this would take me a while to do!!

cheers for any help

Mark
Title: Re: database editing
Post by: bearcat on February 27, 2009, 01:01:30 PM
Hi

I have done mass changes, for example, US- Airforce to USAF using SQL Browser which worked OK but I am not an expert in SQL. Not sure how you would easily change a lot of individual aircraft in one go though.

Regards

Stewart
Title: Re: database editing
Post by: Andy Frost on March 02, 2009, 10:56:44 AM
Mark, if you are still interested I've have got a small program that will replace multiple texts in the database. Though of course any new aircraft that your system detects will still be added to the database as "USA - Airforce".
Title: Re: database editing
Post by: mdobuk21 on March 02, 2009, 07:32:23 PM
cheers stewart and andy great help!! Andy , that program would be fantastic!

mark
Title: Re: database editing
Post by: Andy Frost on March 02, 2009, 10:14:08 PM
ok Mark, I've uploaded it to http://www.gfrost.co.uk/SquawkBox/DatabaseEditor.zip (http://www.gfrost.co.uk/SquawkBox/DatabaseEditor.zip). There's a ReadMe included in the zip. It needs the Microsoft .Net Framework to run. It's nothing special, no fancy interface, it just allows you to replace texts within a db3 database, that's all.
Title: Re: database editing
Post by: mdobuk21 on March 02, 2009, 11:48:34 PM
cheers Andy thats great