Using routes from your Planeplotter database

[tarbat]

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]

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]

Just tried it and it worked fine for me :)

Many Thanks.