
- #Planeplotter operator update
- #Planeplotter operator full
- #Planeplotter operator for android
- #Planeplotter operator software
- #Planeplotter operator series
Tells SQLITE that we are going to create a new It is done as a comma separated variable file Tells SQLITE that when data is written to a file Will be the column names from the database Tells SQLITE that when you extract the data andĬreate a file, the very first row of the file Name and database name you don't need the '', just the name
#Planeplotter operator full
(assuming that you have started SQLITE, you willīe at a black screen with a prompt SQLITE> )Ĭonnects to your database, give the full folder Registeredowners FROM aircraft ORDER BY modes ASC SELECT modes, registration, icaotypecode, type, Here's the sequence of commands that I use, and
#Planeplotter operator software
Perhaps the software allows for a macro or batchįile to enable future conversions of a database placed within a directory? Make the conversion, that would be great. If you could let me know the commands you use to Looks like SQLITE3 isįreely available from their website which is good. My intention would ultimately to be updating theĭatabase myself, yes. Graham, my JAERO database folder is actually empty, so I have yet to see one!

This email has been checked for viruses by AVG.Īndré, if you would be able to send me a copy of yours, that would be great. It sounds complicated, but once you have done it a few times it is quite easy. Let me know if you want me to expand upon anything. So, there's a few notes, and an idea about what is involved.
#Planeplotter operator series
To extract that data from your basestation.sqb you would need to use SQLITE3 (note: _not_ SQLIte Expert Personal!) and manually enter a series of commands to the Command Line Interface. Looking at the sample database in Jaero itĪnd these are the following columns from your PP basestation.sqb. So, from all that, it would seem to imply that you just need a CSV file with your data, and JAERO takes care of the importing and reformatting. csv file, then put it in the directory found in Setting>Look for "Database">Directory form then rename it to "new.aircrafts_dump.csv" "Now if you download the database again the aircraft database come in. I also had a response directly from Ky Anh Luong who said "To import a new db from a csv file create one called new.aircrafts_dump.csv and place it in the planes folder and JAERO will import it and rename it to aircrafts_dump.csv." I emailed Jonathon (the 'J' in JAERO) about the database, and his reply was. Within JAERO there are some notes (not particularly well explained, I must admit) that the aircraft database must have a specific name, be in a specific folder, and So that your database within JAERO is as up-to-date as possible. It is not a too complicated process, but since you'd be updating your internal PP basestation.sqb regularly (I hope!), it's a process that you need to repeat on a regular basis I suspect that you'd also need an 'okay' from NicĪnd/or Bev to allow you to copy the data from PP. Or if the db can't be converted for use in JAERO, is there another source a compatible database can be located?in theory, yes you can use the PP basestation in JAERO, but not directly, and you have to do some work yourself to make it suitable. It strikes me the PP sqb file would have the information the information that JAERO would want to look up. Unfortunately the default database download link within the JAERO settings page ( ) no longer appears to work as it seems it is no longer updated. Marker colour control for planes marked as "Interested" in user-provided BaseStation.Is it possible to utilise the PP basestation.sqb as a JAERO database? I assume it would need to be converted into another format, and carry a specific name.Support for user-provided BaseStation.sqb and FlightRoute.sqb files – see documentation!.
#Planeplotter operator update
#Planeplotter operator for android
Automatic update bug fixed for Android 4.1.2 and earlier.Clear aircraft after persistence time, even when no internet connection or when PP server is down.Server query management – rapid Map View panning / zooming result in minimum poll interval of 2 seconds.Added display of FLARM aircraft – controlled through Settings→Planes→FLARM.interaction updated again to latest API.Aircraft filters added for control over planes displayed in Map, Table and SkyAR View.Added App Permissions request dialog for Android M+.Improved performance on mobile internet connection.Updated to Nic Storey's PlaneSymbol v3 pack.Added support for streaming data from Radarcape server (Settings→Source).Added Map themes (Settings→Map→Map type).Fixed bug causing crash on open for some Samsung devices.Added all PP message sources (Inmarsat, etc.).
