anything
AirNav RadarBox
Welcome, Guest. Please login or register.
Did you miss your activation email?

Login with username, password and session length
 


Author Topic: Using routes from your Planeplotter database  (Read 4365 times)

0 Members and 1 Guest are viewing this topic.

tarbat

  • ShipTrax Beta Testers
  • Hero Member
  • *
  • Posts: 4219
    • Radarbox at Easter Ross
Using routes from your Planeplotter database
« on: November 14, 2011, 03:42:32 PM »
If, like me, you maintain a separate database of routes in Planeplotter, then this little routine will export all these routes, and import them into your Radarbox database.

1. Download the attached ZIP file, and unzip anywhere.

2. Close down Radarbox, and wait for it to completely close and stop processing.

3. Take a backup of your navdata.db3 database, in case something goes wrong.

3. EDIT the routecopy.bat file, using something like Windows Notepad.
  • Edit the first line to point towards your Planeplotter installation folder where the flightroute.sqb file is located.
  • Edit the second line to point towards your Radarbox installation folder where the navdata.db3 file is located.

4. Run routecopy.bat

Depending on how big your Planeplotter flights database is, this process can take a LONG time - and I mean an hour or more!!!

EXPLANATION - All this process does is:
  • Runs an SQL query against the Planeplotter flights database to create a file called inserts.sql, containing lines like this:
    INSERT OR REPLACE INTO Routes VALUES ('WZZ0169','EPKT','LEMD','','20111114090000');
  • Executes these SQL statements against the navdata.db3 database

tarbat

  • ShipTrax Beta Testers
  • Hero Member
  • *
  • Posts: 4219
    • Radarbox at Easter Ross
Re: Using routes from your Planeplotter database
« Reply #1 on: November 15, 2011, 09:09:08 AM »
I see several people have downloaded the scripts, and I wondered if they worked okay.  I use this process about once a week to use the Planeplotter flights database that I populate from http://groups.yahoo.com/group/PP-logs-and-routes/files/   Latest load had over 80,000 up-to-date routes.

Rotorsport

  • New Member
  • *
  • Posts: 14
Re: Using routes from your Planeplotter database
« Reply #2 on: November 15, 2011, 10:49:35 PM »
Just tried it and it worked fine for me :)

Many Thanks.