Displaying current logos, country flag and silhouette in the sqb database

[Anmer]

I've tried opening BaseStation.sqb in the virtual store as suggested but still get the same error message.

I have BaseStation installed in its own folder, well away from the Virtual Store.  But I get the same error message when setting a new sqb path.  However when I close the error message window, the app sets the new path and I can view the data in the new sqb file.

If I set another new location, I get the same sequence of error messages but the app still manages to set the new path when I close the error message using Close Program.

I've attached screenshots of the sequences and error message.

Note that I start with the sqb file location:

I:\Kinetic BaseStation\basestationPP.sqb

I click on the BaseStation button and am offered the opportunity to locate a new BaseStation.sqb.  I then choose a new sqb, in my case:

I:\Kinetic BaseStation\BaseStationPPTest.sqb

This invokes the error message.  But when I select Close Program, the app remains active and the new sqb is shown the path window.  And if I select List, it finds the records from the new sqb file.

In essence, it sets the new path despite messages to the contrary.

[attachment deleted reduce file load]

[Nigel]

Thanks Mike

When I click on 'Close Program' it closes the app. I notice that the program initially reads from your I: drive. How did you get it to do that. When I start the program it defaults to: C:\Program Files\Kinetic\BaseStation\Basestation.sqb

egnx: I've tried putting copies of the BaseStation.sqb in different folders but get the same error when I select to open them.

Thanks

[Anmer]

When I click on 'Close Program' it closes the app. I notice that the program initially reads from your I: drive. How did you get it to do that. When I start the program it defaults to: C:\Program Files\Kinetic\BaseStation\Basestation.sqb

I'll have to start from scratch (which I will be doing to "test" this very useful app for egnx) but, from memory, when I first installed the app I changed the path (as we've been discussing) and closed the error message and Program and found it still worked.

The install sets the BaseStation.sqb to a default location of:

C:\Program Files\Kinetic\BaseStation\Basestation.sqb

This invokes, for me, an error message that the BaseStation db cannot be found, which is correct.  So I then changed the path.

I can understand why the app deafults to a Program Files location but even then it's not going to work for those using X64 bit systems where the default should be Program Files (x86)

This is a very useful app and I'm sure egnx will fix these issues.  I will be doing some deep testing this week and provide direct feedback to egnx.

[Roadrunner]

I have changed the path for mine and it goes to that one on every restart.

I have resorted the file list so that those not needed are at the right hand side and off screen.

I am finding that using User tag (e.g. $T) is the most convenient for me although using a specific type works well also.



[attachment deleted reduce file load]

[egnx]

I have resorted the file list so that those not needed are at the right hand side and off screen.

If you right click on the data grid a context menu is displayed and you can select/deselect which columns are displayed. Make sure when you have chosen the desired columns you scroll to the bottom of the list and click on the RESET option.

[egnx]

Nigel, in the folder where you installed ModeS Tweaker is a file named "MT_Settings.xml"   This is an XML file that holds all the configuration settings you set when using the app, this file must have read/write properties for you.

If you open that file using an XML editor or Notepad, but not Word, you should see that line 6 of that file looks like this:-

  <BaseStationDb>C:\Program Files\Kinetic\BaseStation\Basestation.sqb</BaseStationDb>

Change the location between the tags to match the actual location of your BaseStation.sqb  I would suggest at this point you use one of your copied locations, not the one in the virtual store.

So if you had a copy of your BaseStation.sqb in the same location as Anmer it would look like this:-

  <BaseStationDb>I:\Kinetic BaseStation\BaseStationPPTest.sqb</BaseStationDb>

Save the file, close it and then run the Tweaker app and let us know what happens.

[Nigel]

Hi egnx

That seems to have worked. The app has opened with the location of the BaseStation.sqb as I set in the MT_Settings.xml file following your instructions, and I have carried out some data queries successfully.

Many thanks

Nigel

[Oblivian]

Seems to be a query logic builder.
Saving you from knowing 'select from' sql queries and using things like Sqlite Expert manager. So you may not be able to throw every term at it you can think of, but have to be selective with how much data it's going to pull in one ask (or could break logic )

If you have entries without a type field populated using $t, and interested in military. Knowing some of the various military HEX ranges come in handy as they're usually separate from commercial/GA allocation. Can get examples of those from countries.dat

[Anmer]

Our member egnx has just released an updated version of Mode-S Tweaker with a number of improvements.  It's also available for download from the forum's Software download section.

Thanks to egnx for developing and sharing this very useful addon for viewing and editing a BaseStation.sqn file.

[Roadrunner]

Having used this very useful tool since its release. I can continue to sing its praises. I am also learning how to use it and get the most of the program.

I must say that I use PlaneBase to record all my data and I believe they use addition al coding in the UserString 4 and 5 columns that may not be available to other users but wanted to make more people aware of how useful the Mode-S Tweaker is.

I have been investigated what some of the columns can give and the ones I use, apart from the obvious ICAO codes, are the User codes $A to $Z,  as used by PlanePlotter. But I was looking to cover, say all the Bizz jets in one go, and this can be done by User String 5 value B. Change the value to G and you get all all General Aviation, to H for all Helicopters, to J for all Jetliners , T all turbos, and P all piston.
Change the UserString to 4 with code M which generates all Military in the database. Other values used in Userstring 4 include E for Jeriner Executives, plus X and V which I have not worked out yet.

Finally I would say that my database only has aircraft picked up by me SBS3 so is not that large, currently having just over 10.000 entries.

I hope some of you may find this interesting and not teaching more computer versed people than me to suck eggs.

Best regards

Mike

[Anmer]

I hope some of you may find this interesting and not teaching more computer versed people than me to suck eggs.

Thanks Mike for the helpful feedback which I found useful.

Mode-S Tweaker is a great app for anyone using a BaseStation.sqb file and I thoroughly recommend it, even if just to evaluate its many features.

Download from here