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

[Roadrunner]

Hi egnx,

Thank you for sending the new app., as ANMER has said it looks good and I have got it to open and set up the locations etc. However, I am getting an error  message:-

                   "Column Image Key is constructed to be unique. Value 'FTL' is already present in the fn_DT_AddimagesGeneric"

I must say that I am a user on an SBS3 with data updates etc., done by PlaneBase, which I know does use a modified version of the standard Kinetic database. Will this be the cause of the error.

Best regards Mike

[egnx]

I don't think it is the size of the db that is the problem, it is more related to the number of rows in the Aircraft table being returned to the displayed grid.

Try filtering the records down with a Mode-S filter such as like 407%

[Anmer]

Try filtering the records down with a Mode-S filter such as like 407%

Great, that fixed it.

I'll take a thorough look later.  As I said, looks a very useful app.

[egnx]

Roadrunner, Is the error occuring when it is loading logos, if so which set, country flags or Type logos ?

I'm not sure how you would achieve this but it sounds like a duplicate file name maybe one as a jpg and one as a bmp ??

egnx

[Anmer]

Roadrunner, Is the error occuring when it is loading logos, if so which set, country flags or Type logos ?
I'm not sure how you would achieve this but it sounds like a duplicate file name maybe one as a jpg and one as a bmp ??

Maybe run BMPCHK against the OperatorFlags folder?  And the BMPFlags folder too.  It will highlight any unexpected files formats.

[Roadrunner]

Hi Guys,

Sorry for the long wait for a reply. I tried the BMP check and it showed a couple of errorsa which I fixed and also it mentioned a warning but gave no details?

The message was coming after I had set the paths on the relevant screens (in my case all files are in the C:\Aviation\Kinetic\Basestation folder. and pressed save.

When I selected some entries it did show what I have asked for.

Regards Mike

[Roadrunner]

Sorry, but just for completeness sake, I only tried the app while BaseStation was closed, as I assume that is necessary.

Regards

[Anmer]

Thanks Mike.

Have you set the paths to the relevant sub-folders in your C:\Aviation\Kinetic\Basestation folder, see attached. 

[attachment deleted reduce file load]

[Anmer]

Sorry, but just for completeness sake, I only tried the app while BaseStation was closed, as I assume that is necessary.

No it works with BaseStation running.

[egnx]

When I selected some entries it did show what I have asked for.

So does that mean it's now working ok for you ?

If not, I suggest using the references page, disable all the Images options, then do a query to see if something is shown and then repeat the process adding in one set of images at a time.

[Roadrunner]

I Have set the paths as per the instructions to the locations menyioned, plus on the main screen set the location of the sqb file to where it is in  my set-up.
.
It is when I have used the OK button on the flags page to ensure my changes have been accepted that I am still getting the message re FTL.

My set up, when run with anything is Not returning any information. However, I will try egnx's last comment.

May not get back today as I am off for my 2nd covid jab later and will have to see if I get the same reaction as i didto the 1st !

Regards Mike

[Roadrunner]

Right,

I started again from scratch this morning.
Loaded the program.
Changed the location of the baseStation.sqb file
Sett-up the locations for the Countries.dat, BMPFlags and OperatorFlags.
Runnin this via pressing SAVE generates the same error message as before which I have to say OK to twice then it clears and seems to run.
I can then select the whole database but the images I have for typeImage is very sparse. With imageType not shown but OperatorFlag is.
However when I sort  the full database of 7,621 records by the ICAO code all those A to F are populated, and everything from G to Z is not populated in the Image code or the OperatorFlag where the code is used for both.
I must have a problem with my OperatorFlag file (which has 4,049 entries)
All entries in the respective folders have the correct types shown and are the correct sizes.
If I close down the system and start again with using the task bar icon to gain access to the program, I have to go through the settings again or else nothing at all will show.

Think that is as thorough as I can be at moment as I need to go out soon.

Hope that is enough info to give a clue (I have also packed my database using the basestation tool for this.

Regards Mike

[Anmer]

Hi Mike

Try running on a sub-selection of your database.

For example, set Mode-S to "407%" and select "Like".  See attached.  % is a wild card.  This should return all Mode-S codes beginning with "407".

I did PM egnx with an offer to "deep test" his app but not had a response.

[attachment deleted reduce file load]

[Roadrunner]

Mike,

Back from the jab. I have just tried like AE% and it returns all US Military but anything with a ICAO code for type after F is blank in the typeImage.
However, all those with other than the ICAO type as the OperatorLog have been populated properly.
It is still not working until I have re-run setting after each restart. I have obviously some problem with an image/imagesstarting with the letter G which is precluding the full available images to load. I have no idea how to get round that but the program in genral is great if I am only looking for the OperatorFlag having the correct image in it.

Regards Mike

[Anmer]

Thanks Mike.

Try running BMPCHK again and grab a screenshot of the merssages you get and post it here.