Added Note - 9th August 2023.
Please note that the dutchradar.nl database server hasn't been available for at least a year so don't expect SBS-1 Populate to work for remote data lookups.
Hello all members,
- Today - GREAT NEWS -
We from www.dutchradar.nl (https://www.dutchradar.nl/) and the hard work of the owner of www.dutchradar.nl (https://www.dutchradar.nl/) Michel can announce that:
SBS-POPULATE Is back online and running. At this moment there are +/- 450.000 hex-codes inside the database which are accessible by the SBS-populate software.
We are also working in the coming month (February - March) to release the website so users can add new hex-codes. So that the database will be up2date.
We test it with SBSPopulate v 1.64.0.13c and it is working great.
Download link: https://dutchradar.nl/download/sbspopulatedb_1.64.0.13c.zip (https://dutchradar.nl/download/sbspopulatedb_1.64.0.13c.zip)
So everyone can re-use the app to auto populate there basestation.sqb file.
For more info and tips: info@dutchradar.nl (info@dutchradar.nl)
Thanks for letting us know of this development and posting the links.
I have downloaded the 64 bit version of SBSPopulate from the DutchRadar.nl site and can confirm it is working with its database. I never had the 64 bit version of SBSPopulate so mine was a fresh install.
If you have a 64 bit version already installed, you may need to remove it and download the updated version from DutchRadar.nl.
Whilst this will be a welcome development, I do have some concerns which others may share.
SBSPopulate was developed by the late Gary Jones in association with The Gatwick Aviation Society.
The updated version retains the original version number - 1.64.0.13 - and displays Gatwick Aviation Society.
The Help -> About clearly shows the Copyright belongs to The Gatwick Aviation Society.
Unless the Copyright has passed to DutchRadar.nl or it's been granted a licence to distribute SBSPopulate, I'm reluctant to add a link to the new download as requested.
[attachment deleted reduce file load]
What i know is that the domain / website was free to register for use, and Michel bought that domain. The plan is in the future that he is going to find a person that can write in .net software to make it free from GAS name and be more linked to Dutchradar.nl, for this moment he is using the old sbspopulate tool to let it work for others.
Thanks, I understand.
There may not be an issue but it might be a good idea to check with GAS that this is OK?
The 64 bit original GAS file and the downloadable file are identical.
Suggests that someone has reverse engineered the program and set up a server to feed sbspopulate while working on a revised version. Or the source code was provided to allow this. If a sum of money has passed between the interested parties following an agreement, a good outcome.
Otherwise?
[Edit]
QuoteWhat i know is that the domain / website was free to register for use, and Michel bought that domain.
While the website may have been free to register, that does not mean the software from the website was included UNLESS a deal has been agreed with the software copyright holder. Copyright does not lapse on death of author.
My understanding is SBSPopulate has not been updated and earlier versions should work, including 32 bit (I can't test this myself).
I'm told DutchRadar.nl has acquired the original SBSPopulate domain and built an aircraft database to match the original.
So, instead of accessing a GAS database, SBSPopulate now accesses an identical one, albeit operated by DutchRadar.nl.
DutchRadar.nl has "intercepted" the server requests from SBSPopulate. Innovative and neat.
But that doesn't, in itself, negate the issue of copyright.
Just to query in basic daftness non tekky speak..
Does this mean the SBSPOP i have installed already should work.. if i hit the autopop button the data comes from DutchRadar.nl. and will update any items not listed in my sqb file ?? or thats the theory..
Ta,
Smudger.
Quote from: Smudger98 on February 02, 2021, 09:08:19 AM
Does this mean the SBSPOP i have installed already should work.. if i hit the autopop button the data comes from DutchRadar.nl. and will update any items not listed in my sqb file ?? or thats the theory..
If you have an existing 64 bit version (Maybe someone with a 32 bit can test?) it should work as before. I haven't tested all the features but, as you say, that's the theory.
Quote from: Smudger98 on February 02, 2021, 09:08:19 AM
Just to query in basic daftness non tekky speak..
Does this mean the SBSPOP i have installed already should work.. if i hit the autopop button the data comes from DutchRadar.nl. and will update any items not listed in my sqb file ?? or thats the theory..
Ta,
Smudger.
The database has +/- 450.000 hex-codes so it would populate your sqb if a encodes is not listed. We are looking to keep database up2date with a release of a website that users can add missing hex-code info (like operator, aircraft-type, registration etc).
Thanks chaps,
My single updates are done by ADLite with data from Airframes or rzjets, but if the auto now works on SBSPop then it is indeed good news..
Im running the 64 version on my current install..
Quote from: Smudger98 on February 02, 2021, 09:25:14 AM
My single updates are done by ADLite with data from Airframes or rzjets,
You can do the same using SBSPopulate. Or use it to lookup the code on the DutchRadar.nl server and Update your sqb file:
Enter hex Code -> GAS Load -> Update
Easier than using ADLite and manually entering the data from Airframes etc.
Ok.. so i had sbspop running as autopop, the update option was set to update from gas..
Buuutttt had 42449C, VQ-BWS Boeing 747-467 /F B744 LGT - Longtail Aviation blipped up and would not auto pop - worked fine when i run it as a single record.. am i being too keen and expecting too much yet..? :-\
Smudger.
Auto Populate is working - sometimes, see attached. But some records are being overlooked.
I tried running ADLite to see if that was working with the new server database. But it ins't.
[attachment deleted reduce file load]
Im not getting the populated ones shown.. or the 1 i know of.. it says auto is running but not seemingly to update..
As I mentioned earlier, Auto Populate is working for me. But I can't be sure it's working for all unknowns.
Do you see the window "Populated this A-P Session" window?
Mine now shows three populated aircraft.
Have you set the database path correctly?
[attachment deleted reduce file load]
The path looks ok.. C-KINETIC-BASESTATION
But im not getting the A-P Session" window part.. There was only the one so far..
[attachment deleted reduce file load]
Quote from: Smudger98 on February 02, 2021, 12:14:34 PM
The path looks ok.. C-KINETIC-BASESTATION
And is that the correct path and location for your Basestation.sqb file?
For me the record 406F77 returns an ICAO Operator code of "BAW-B787" from the Dutch server. Yours shows "BAW789"?
Methinks you have all the recent aircraft codes already populated. Your data is different to the server.
[attachment deleted reduce file load]
I have 8 populated this A-P Session, I have checked 4 of those and they have been populated in Basestation Reporter. They have not been populated in my usual style and dont match my logos, so I dont know how useful the program would be to me. I was a big fan of Active Display Pro but I never used Populate in the past.
Paul
Quote from: paulm on February 02, 2021, 01:42:30 PM
They have not been populated in my usual style and dont match my logos, so I dont know how useful the program would be to me. I was a big fan of Active Display Pro but I never used Populate in the past.
Same here. For the ICAO Operator code field I either use the ICAO type code (for silhouettes) or an airline ICAO code for logos. With a few exceptions.
I never did use Auto Populate in SBSPopulate or AD.
But for updating individual records, SBSPopulate is better than a manual lookup and filling in the details into ADLite to update the sqb file.
This way I have control over the data fields and what goes in them.
Quote from: Anmer on February 02, 2021, 01:39:28 PM
Methinks you have all the recent aircraft codes already populated. Your data is different to the server.
I like to keep up to date where possible and yes my codes are different fron the dutch version.. BAW789 for me denotes a 787-900 series etc.
Im thinking single changes are my best option and not autopop..
If members here are willing to help to sent us some ""Export major Fields" so we can update the database with those info. How more we are getting from around the world would be great to make the database grwoing and growing.
To do this (for users new to sbspopulate:
Start sbspopulate (best is to shut down basestation), then select File -> Export Major fields, Then save the txt file with Your Country + Date, then maybe upload it to Dropbox or Google Drive and email me the download url add danny@dutchradar.nl.
We will convert that data to fit inside the database, the more fields we have how nicer the database would be.
And we are working on the ICAO Operator input that it only shows the 3 letter code for the airline.
(https://postimg.cc/jncpgZv0%5D%5Bimg%5Dhttps://i.postimg.cc/jncpgZv0/Export-major-fields-1.png)
(https://postimg.cc/2LCp7PQ7%5D%5Bimg%5Dhttps://i.postimg.cc/2LCp7PQ7/Export-major-fields-2.png)
Quote from: Smudger98 on February 02, 2021, 02:18:06 PM
Im thinking single changes are my best option and not autopop..
Are the Single Records pulling data from the Dutch server? When you enter a code and then hit "GAS Load"?
Quote from: Pipo on February 02, 2021, 02:28:09 PM
If members here are willing to help to sent us some ""Export major Fields" so we can update the database with those info.
This assumes the local database has the latest, correct data. And what do you do when the same hex code has different data from different databases? How do you spot this and determine which is correct, if any?
The big challenge is maintaining a global, up-to-date database. GAS knew that, as does FlightAware, FlightRadar24, PlaneFinder, Planebase etc.
Accessing the database and downloading the data is great as long as the data is correct.
Quote from: Anmer on February 02, 2021, 02:35:33 PM
Quote from: Pipo on February 02, 2021, 02:28:09 PM
If members here are willing to help to sent us some ""Export major Fields" so we can update the database with those info.
This assumes the local database has the latest, correct data. And what do you do when the same hex code has different data from different databases? How do you spot this and determine which is correct, if any?
The big challenge is maintaining a global, up-to-date database. GAS knew that, as does FlightAware, FlightRadar24, PlaneFinder, Planebase etc.
Accessing the database and downloading the data is great as long as the data is correct.
Michel is using een tool to find hexcodes with double data and this is filter out to check online what the correct info is. How this is done is in hands of Michel
Here's a good example, one I just picked up on my SBS.
The ICAO Type code is F2TH, not F2EX.
The Type should read Dassault Falcon 2000EX. EASy is a marketing "add on".
The Operator is Bank of Utah Trustee, as per FAA.
The ICAO Operator should also be F2TH.
The Dutch server holds, in my view, four incorrect data fields.
I'm sure it will improve if the community works together. But someone has to be the final arbiter.
[attachment deleted reduce file load]
Quote from: Anmer on February 02, 2021, 02:54:50 PM
Here's a good example, one I just picked up on my SBS.
The ICAO Type code is F2TH, not F2EX.
The Type should read Dassault Falcon 2000EX. EASy is a marketing "add on".
The Operator is Bank of Utah Trustee, as per FAA.
The ICAO Operator should also be F2TH.
The Dutch server holds, in my view, four incorrect data fields.
I'm sure it will improve if the community works together. But someone has to be the final arbiter.
Slowly we will make improvement on the database and yes with help and input from community. We have also contacted S92Driver if he want to help keep the database up2date, this contact is be twin Steve and Michel (Michel is control of the server). maybe we can ask steve to make the fields correct for the populate.
Quote from: Anmer on February 02, 2021, 02:54:50 PM
Here's a good example, one I just picked up on my SBS.
That data is from PlaneBase - see attached image. They use a non-standard "ICAOTypeCode" field for some types, which of course means it's not an ICAO TypeCode!
Tim
[attachment deleted reduce file load]
Thanks Tim.
I rarely "accept" available data at "face value". If in doubt I hunt around on official listings, where available, tracking sites, latest photos and, if all else fails, Google. I often try matching flight IDs/callsigns, if possible. Then I make a judgement call before updating my personal sqb file.
Estimates of "in service" civilian aircraft range wildly between 25,000 and 40,000. My sqb file has 60,000 records, including military. Some of these are no longer flying and I have data going back 16 years.
I've also read there are over 200,000 "general aviation" aircraft in the USA which makes me think the earlier estimates are for "commercial" aircraft.
s92driver's populated sqb file (via Planebase) has 330,000 records!
Whatever the global number of aircraft, keeping a database up-to-date and correct is a major challenge. I'll just focus on my little corner of the globe.
The other 2 boxes that dont seem to be on GASPop are the user tag & the interested boxes which to me actually are fundamental, again not wishing to nit pick but it seems that i still seem to be doing most of the work after finding the missing code..
[attachment deleted reduce file load]
Quote from: Smudger98 on February 03, 2021, 07:53:58 AM
The other 2 boxes that dont seem to be on GASPop are the user tag & the interested boxes
Were they ever there?
I don't think they were and, as mentioned earlier, the SBSPopulate app is the same as before.
Quote from: Anmer on February 03, 2021, 08:46:31 AM
Quote from: Smudger98 on February 03, 2021, 07:53:58 AM
The other 2 boxes that dont seem to be on GASPop are the user tag & the interested boxes
Were they ever there?
I don't think they were and, as mentioned earlier, the SBSPopulate app is the same as before.
In which case that puts the kybosh on using that to populate the sqb.. :(
Quote from: Smudger98 on February 03, 2021, 09:16:17 AM
In which case that puts the kybosh on using that to populate the sqb.. :(
So what were you using before?
Quote from: Smudger98 on February 03, 2021, 09:16:17 AM
In which case that puts the kybosh on using that to populate the sqb.. :(
No it doesn't!
You just add them yourself:
Settings>>User Fields.
They are then in the main screen ready for you to use. See attached.
Tim
[attachment deleted reduce file load]
Thanks Tim. I never use those fields so hadn't even explored that option.
That should help Smudger98 (and others).
Well done that man.
Quote from: Anmer on February 03, 2021, 09:32:52 AM
Quote from: Smudger98 on February 03, 2021, 09:16:17 AM
In which case that puts the kybosh on using that to populate the sqb.. :(
So what were you using before?
ADL for the updates.. now manuel ADL..
Quote from: Triple7 on February 03, 2021, 09:35:01 AM
Quote from: Smudger98 on February 03, 2021, 09:16:17 AM
In which case that puts the kybosh on using that to populate the sqb.. :(
No it doesn't!
You just add them yourself:
Settings>>User Fields.
They are then in the main screen ready for you to use. See attached.
Tim
Cheers Tim.. just the ticket..
Quote from: Smudger98 on February 03, 2021, 09:45:25 AM
ADL for the updates.. now manuel ADL..
Perhaps DutchRadar.nl should take a look at AD too?
Quote from: Anmer on February 02, 2021, 06:16:35 PM
s92driver's populated sqb file (via Planebase) has 330,000 records!
The last sqb contained 460,000.
Note the similarity between my total and the DutchRadar total - I did ???
A big thank you for bringing back a program like this!!
Is the new Dutch SBS-populate compatible with AD-Lite, I have AP selected, but It's not populating, if not could our Dutch friends please look into this please?
Thanks for your efforts
Terry
Quote from: terrywadeairbus on February 13, 2021, 03:23:42 PM
Is the new Dutch SBS-populate compatible with AD-Lite, I have AP selected, but It's not populating, if not could our Dutch friends please look into this please?
When I last checked, No:
https://radarspotting.com/forum/index.php?topic=12732.msg52400#msg52400
Quote from: terrywadeairbus on February 13, 2021, 03:23:42 PM
Is the new Dutch SBS-populate compatible with AD-Lite, I have AP selected, but It's not populating, if not could our Dutch friends please look into this please?
Thanks for your efforts
Terry
We first want to let sbs-pop work and we are looking to make Ad work in future on the same server. Every thing is in the pipe-line but step by step we hope to make every app work.
Hi Pipo
That's great news, thank you. A big ask please, any possibility of getting AD PRO working again to
show my routes on my SBS?
Thanks
Terry
Whilst I welcome the DutchRadar.nl initiative, here's a good example of the challenge in maintaining a quality database.
The first image is what gets returned from the server, the second my corrections.
When GAS was active, the manufacturer's name preceeded the Type which always used the correct ICAO designation. I can't say this is true of the Dutch database.
I appreciate errors will always occur but I find too many compared to Airframes.org and usually need to check and make corrections before updating my Basestation.sqb.
[attachment deleted reduce file load]
Here's another example, this time with the incorrect ICAO Type Code.
Should be B738.
Does DutchRadar.nl need volunteers to reveiw the database? Especially key fields like this example?
[attachment deleted reduce file load]
We are looking for these issue at the moment, Why we have called Type B747 instead of Boeing 747, because the Airbus serie is named A320 not Airbus 320. But we are going to change this. Al the other feed back i will sent to Michel to look in to it.
If someone here has any knowledge in html, and server programming, we are looking for people that can help make the sbspopulate server better and better
Quote from: Pipo on February 21, 2021, 06:34:16 PM
Why we have called Type B747 instead of Boeing 747, because the Airbus serie is named A320 not Airbus 320.
Perhaps you should adopt the official ICAO designations and not make up your own?
See attached.
I think you need to clean up the database. If not, it won't get used, no matter what you do to improve SBS-1 Populate.
[attachment deleted reduce file load]
As i mention we are changing the type to the correct version as the icao type codes, but the data base is not that little
Quote from: Pipo on February 21, 2021, 06:51:31 PM
As i mention we are changing the type to the correct version as the icao type codes, but the data base is not that little
Are you manually editing the database, one record at a time?
Here's another example of the database quality.
And the absence of the manufacturer is an on-going issue.
I'm always having to check the data with other sources and correct it before updating the BaseStation.sqb file.
SBS-1 Populate doesn't have a Manufacturer data field and GAS always appended it to the Type, for example:
Bombardier BD-700-2A12 Global 7500
[attachment deleted reduce file load]
Quote from: Anmer on February 24, 2021, 05:08:45 PM
Here's another example of the database quality.
And the absence of the manufacturer is an on-going issue.
I'm always having to check the data with other sources and correct it before updating the BaseStation.sqb file.
SBS-1 Populate doesn't have a Manufacturer data field and GAS always appended it to the Type, for example:
Bombardier BD-700-2A12 Global 7500
I have save the screenshot, and sent it to Michel he is going to correct it.
Quote from: Pipo on February 24, 2021, 06:50:16 PM
I have save the screenshot, and sent it to Michel he is going to correct it.
The SBS-1 Populate server has been returning "Website Retrieval Errors" for the last few days.
Do you know if the server is now permanently off-line?
Once again, the SBS-1 Populate server has been returning "Website Retrieval Errors" for the last few days.
Does anyone know if the server is now permanently off-line?
Good news, the server is back online.
Mike,
I notice last week the you made a comment in the Chat Box and also in the Active Display thread about SBS Populate being back on.
I had a quick look and followed the links and installed SBS POP back onto my computer apon running everything thing seemed to be working.
it accessed the first hit and showed the details as can be seen by the screen shot i have posted.
This is as far as SBS POP goes, just this one record.
The program seems to be searching as the Bar is moving, but unpopulated aircraft are showing on my SBS and nothing shows in the SBS POP screen only this one Jet 2 record.
Even after shutting down and trying the next day, the same Jet 2 aircraft record populates in SBS POP just like before and everything seems to be doing the same.
Do we know for sure that SBS POP is working 100% or is there an issue with it still.
Cheers Mike for any Info on this Subjuct
[attachment deleted reduce file load]
Have you mapped SBS Populate to your "active" sqb file, possibly in the Virtual Store?
Thanks Mike,
Was 100% sure it was pointing at the correct folder, but to be sure I re-pointed to make sure and it all seems to be running OK now.
Great news about this.Being able to run SBS without a internet conection,then populate unknowns,is good for me.
David,
Quote from: Harpic on August 30, 2021, 12:34:09 PM
Thanks Mike,
Was 100% sure it was pointing at the correct folder, but to be sure I re-pointed to make sure and it all seems to be running OK now.
I had the exact same problem, but the path was correct. It was solved by starting Basestation.exe as administrator.
best regards
I'm hoping someone at DutchRadar.nl reads this and will correct some of the ICAO Type codes?
I can understand data being missing or showing the incorrect aircraft or operator. But surely all aircraft records should use the correct ICAO Type Code and not fictional ones?
The attached are from the last two days.
G350 should be GLF4
G400 should be GLF4
G450 should be GLF4
G550 should be GLF5
F9LX should be F900
Using the wrong ICAO Type Code can cause issues with logos and silhouettes, as well as being factually incorrect.
Updating the database to conform with the published ICAO Type Designators should a quick and easy fix:
https://cfapps.icao.int/doc8643/reports/Part2-By%20Type%20Designator(Decode).pdf
[attachment deleted reduce file load]
This is caused by using the PlaneBase database which uses these fictional codes. I can't call them ICAO Type Codes because they are not the official codes. I know why the PB team have done this but it would have been much better to use one of the other fields in the SQB file for this purpose and ensure the correct - official ICAO Type Codes are entered in the correct SQB field.
The full list (as far as I am aware) of these inaccurate codes is as follows:
CL61 should be CL60
CL64 should be CL60
CL65 should be CL60
CL85 should be CRJ2
EA55 should be EA50
F2DX should be F2TH
F2EX should be F2TH
F2LX should be F2TH
F2TS should be F2TH
F5EX should be FA50
F9DX should be F900
F9EX should be F900
F9LX should be F900
G100 should be ASTR
G200 should be GALX
G300 should be GLF4
G350 should be GLF4
G400 should be GLF4
G450 should be GLF4
G500 should be GLF5
G550 should be GLF5
G650 should be GLF6
GL6T should be GLEX
H750 should be H25B
H850 should be H25B
H900 should be H25B
KC10 should be DC10
E.&O.E.
As a PlaneBase member, I get these codes in my SQB regularly. I therefore run the following SQB commands at regular intervals to tidy things up. Perhaps the DutchRadar.nl guys might like to run this on their master DB as well :)
Update Aircraft Set ICAOTypeCode = "CL60" Where ICAOTypeCode like "CL61";
Update Aircraft Set ICAOTypeCode = "CL60" Where ICAOTypeCode like "CL64";
Update Aircraft Set ICAOTypeCode = "CL60" Where ICAOTypeCode like "CL65";
Update Aircraft Set ICAOTypeCode = "CRJ2" Where ICAOTypeCode like "CL85";
Update Aircraft Set ICAOTypeCode = "EA50" Where ICAOTypeCode like "EA55";
Update Aircraft Set ICAOTypeCode = "F2TH" Where ICAOTypeCode like "F2DX";
Update Aircraft Set ICAOTypeCode = "F2TH" Where ICAOTypeCode like "F2EX";
Update Aircraft Set ICAOTypeCode = "F2TH" Where ICAOTypeCode like "F2LX";
Update Aircraft Set ICAOTypeCode = "F2TH" Where ICAOTypeCode like "F2TS";
Update Aircraft Set ICAOTypeCode = "FA50" Where ICAOTypeCode like "F5EX";
Update Aircraft Set ICAOTypeCode = "F900" Where ICAOTypeCode like "F9DX";
Update Aircraft Set ICAOTypeCode = "F900" Where ICAOTypeCode like "F9EX";
Update Aircraft Set ICAOTypeCode = "F900" Where ICAOTypeCode like "F9LX";
Update Aircraft Set ICAOTypeCode = "ASTR" Where ICAOTypeCode like "G100";
Update Aircraft Set ICAOTypeCode = "GALX" Where ICAOTypeCode like "G200";
Update Aircraft Set ICAOTypeCode = "GLF4" Where ICAOTypeCode like "G300";
Update Aircraft Set ICAOTypeCode = "GLF4" Where ICAOTypeCode like "G350";
Update Aircraft Set ICAOTypeCode = "GLF4" Where ICAOTypeCode like "G400";
Update Aircraft Set ICAOTypeCode = "GLF4" Where ICAOTypeCode like "G450";
Update Aircraft Set ICAOTypeCode = "GLF5" Where ICAOTypeCode like "G500";
Update Aircraft Set ICAOTypeCode = "GLF5" Where ICAOTypeCode like "G550";
Update Aircraft Set ICAOTypeCode = "GLF6" Where ICAOTypeCode like "G650";
Update Aircraft Set ICAOTypeCode = "GLEX" Where ICAOTypeCode like "GL6T";
Update Aircraft Set ICAOTypeCode = "H25B" Where ICAOTypeCode like "H750";
Update Aircraft Set ICAOTypeCode = "H25B" Where ICAOTypeCode like "H850";
Update Aircraft Set ICAOTypeCode = "H25B" Where ICAOTypeCode like "H900";
Update Aircraft Set ICAOTypeCode = "DC10" Where ICAOTypeCode like "KC10";
Tim
Thanks Tim.
I have no problem with PlaneBase (or any other entity) using whatever it chooses.
But promulgating an "edge case" Type Code implementation to a wider audience is crazy and, in my opinion, dilutes the value of the data and the application.
I really don't understand why DutchRadar.nl doesn't do as you suggest.
Quote from: Triple7 on September 17, 2021, 05:38:38 PM
...I therefore run the following SQB commands at regular intervals to tidy things up...
This can be automated by using a trigger on the ICAOTypeCode field. Then the database itself immediately corrects the ICAOTypeCode field. I've just entered the trigger below and untill now it doesn't seem to impact the database's performance that much. You can try this if you want to by running the following query to create the trigger (
please make a backup of your database first!):
--Trigger: Aircraft.ICAOTypeCodeCorrection
CREATE TRIGGER ICAOTypeCodeCorrection
AFTER UPDATE OF ICAOTypeCode
ON Aircraft
BEGIN
/* Insert trigger body here */
UPDATE Aircraft
SET ICAOTypeCode = 'CL60'
WHERE
ICAOTypeCode LIKE 'CL61'
OR
ICAOTypeCode LIKE 'CL64'
OR
ICAOTypeCode LIKE 'CL65';
UPDATE Aircraft
SET ICAOTypeCode = 'CRJ2'
WHERE
ICAOTypeCode LIKE 'CL85';
UPDATE Aircraft
SET ICAOTypeCode = 'EA50'
WHERE
ICAOTypeCode LIKE 'EA55';
UPDATE Aircraft
SET ICAOTypeCode = 'F2TH'
WHERE
ICAOTypeCode LIKE 'F2DX'
OR
ICAOTypeCode LIKE 'F2EX'
OR
ICAOTypeCode LIKE 'F2LX'
OR
ICAOTypeCode LIKE 'F2TS';
UPDATE Aircraft
SET ICAOTypeCode = 'FA50'
WHERE
ICAOTypeCode LIKE 'F5EX';
UPDATE Aircraft
SET ICAOTypeCode = 'F900'
WHERE
ICAOTypeCode LIKE 'F9DX'
OR
ICAOTypeCode LIKE 'F9EX'
OR
ICAOTypeCode LIKE 'F9LX';
UPDATE Aircraft
SET ICAOTypeCode = 'ASTR'
WHERE
ICAOTypeCode LIKE 'G100';
UPDATE Aircraft
SET ICAOTypeCode = 'GALX'
WHERE
ICAOTypeCode LIKE 'G200';
UPDATE Aircraft
SET ICAOTypeCode = 'GLF4'
WHERE
ICAOTypeCode LIKE 'G300'
OR
ICAOTypeCode LIKE 'G350'
OR
ICAOTypeCode LIKE 'G400'
OR
ICAOTypeCode LIKE 'G450';
UPDATE Aircraft
SET ICAOTypeCode = 'GLF5'
WHERE
ICAOTypeCode LIKE 'G500'
OR
ICAOTypeCode LIKE 'G550';
UPDATE Aircraft
SET ICAOTypeCode = 'GLF6'
WHERE
ICAOTypeCode LIKE 'G650';
UPDATE Aircraft
SET ICAOTypeCode = 'GLEX'
WHERE
ICAOTypeCode LIKE 'GL6T';
UPDATE Aircraft
SET ICAOTypeCode = 'H25B'
WHERE
ICAOTypeCode LIKE 'H750'
OR
ICAOTypeCode LIKE 'H850'
OR
ICAOTypeCode LIKE 'H900';
UPDATE Aircraft
SET ICAOTypeCode = 'DC10'
WHERE
ICAOTypeCode LIKE 'KC10';
END;
Should you wish to remove the trigger you can execute
DROP TRIGGER Aircraft.ICAOTypeCodeCorrection;
After the trigger is made (or deleted) BaseStation Reporter should be restarted otherwise you'll get an error
Hello Everyone..
It was silence from my side about SBS-Populate because i was very busy with other private things.
But now I've got more time to do some updates like the ICAO Type codes.
Do you have more things to be changed?
And who wants to update the database or be one of the administrators?
All records are stored in a MariaDB/MySQL database, so it is possible to create a page where you van add/update a single aircraft.
An export via SBS-Populate is also possible (File -> export major fields) which can be sent to info @ dutchradar.nl
Quote from: phmlr on November 21, 2021, 09:36:18 AM
And who wants to update the database or be one of the administrators?
Welcome and thanks for updating us on SBS-1 Populate.
I use it everyday and would welcome the opportunity to"update" records as I find new aircraft or changes.
Can we host a database "edit" data submission page on this forum?
From my usage, there are two things to consuider:
1. Preceeding the Type with the manufacturer name. For example I have to change "Falcon 7X" to "Dassault Falcon 7X".
2. Only use official ICAO type codes in the ICAO Type field.
"Can we host a database "edit" data submission page on this forum?"
Yes possible i can give the radarspotting.com IP access to the database with also a user account.
Can you create a page for it with my details ?
"1. Preceding the Type with the manufacturer name. For example I have to change "Falcon 7X" to "Dassault Falcon 7X"."
Best way is to have some guidelines for database to get a default database which everyone can use.
"Only use official ICAO type codes in the ICAO Type field."
Yes.. agree https://www.icao.int/ for checking the exact code
Quote from: phmlr on November 21, 2021, 04:01:04 PM
Best way is to have some guidelines for database to get a default database which everyone can use.
Whilst I agree, there is a limiting factor - SBS-1 Populate.
SBS-1 Populate has only 8 data fields to update a BaseStation.sqb database. These fields edit the one shown in the sqb database
Code- > ModeS
Registration -> Registration
Serial Number ->SerialNo
ICAO Type Code -> ICAOTypeCode
Country -> ModeSCountry
Type -> Type
Operator -> Operator
ICAO Operator -> OperatorFlagCode
Although the sqb database has a Manufacturer column, SBS-1 Populate doesn't address this. And my sqb file which was first populated in 2005, only has 8 records witrh data under Manufacturer.
With the demise of Airframes, there's now an opportunity to "fill the gap" but it requires some development. To progress this, maybe we can continue this dialogue offline? If any members can assist please send me a PM. In the meantime I'm exploring what tools are available for use with the forum software.
[attachment deleted reduce file load]
I really don't understand what's going on at Dutchradar.nl? Its data is becoming even more "corrupt".
Over the last week or so I'm seeing the ICAO Operator (OperatorFlagCode) field being populated with invalid data, see attached example.
For the vast majority of Basestation.sqb users, this field is either populated with the operator's ICAO code or the aircraft ICAO Type code. Not both!
So what gives with this data?
[attachment deleted reduce file load]
Quote from: Anmer on November 24, 2021, 08:10:24 AM
I really don't understand what's going on at Dutchradar.nl? Its data is becoming even more "corrupt".
Over the last week or so I'm seeing the ICAO Operator (OperatorFlagCode) field being populated with invalid data, see attached example.
For the vast majority of Basestation.sqb users, this field is either populated with the operator's ICAO code or the aircraft ICAO Type code. Not both!
So what gives with this data?
The problem is the databases from other people, they want to use the OperatorFlagCode to display a logo with the exact plane model and operator.
Will empty the database for now to prevent more corrupted data.
Thank you.
My view is you should clearly define the parameters for each of the fields SBS-1 Populate supports. These parameters should be unambiguous, rational and acceptable to the majority. You cannot please everyone.
For example:
Code- > ModeS currently assigned to the aircraft
Registration -> Current registration
Serial Number -> Serial number
ICAO Type Code -> The ICAO Type Designator
Country -> Current country of registration
Type -> The manufacturer and model.
Operator -> The current aircraft owner/operator. This can be tricky as the owner might be a leasing company, in which case the current operator may be more appropriate.
ICAO Operator -> Either the ICAO Operator Code or ICAO Type Designator
For ICAO Type Designator I would use:
https://www.icao.int/publications/doc8643/pages/search.aspx
I've got an update page in Dutch for to search and update single aircraft, can translate it to English and add extra select boxes.
Let say i want to update/add a Registration like F-HBLK or ModeS 39856A.
You can use search to see if it exists in the database or fill in the boxes and send the update.
ModeS and Registration must be inputted manually, but the Type and ICAO type must be selected from a list like the ICAO.int database.
Operator is manual and Operator ICAO code selected from a list like the ICAO Type code
What you get in SBS-1 Populate from my server is:
Code- > ModeS currently assigned to the aircraft
Registration -> Current registration
Serial Number -> Serial number
ICAO Type Code -> The ICAO Type Designator
Type -> The manufacturer and model.
Operator -> The current aircraft owner/operator.
ICAO Operator -> ICAO Operator Code
ICAO SubOperator -> Not visible in SBSpopulate but it wants it in the request to the server.
Quote from: phmlr on November 24, 2021, 09:51:38 AM
I've got an update page in Dutch for to search and update single aircraft, can translate it to English and add extra select boxes.
I've sent you an email and Personal Message. But no reply?
Quote from: Anmer on November 25, 2021, 09:08:22 AM
Quote from: phmlr on November 24, 2021, 09:51:38 AM
I've got an update page in Dutch for to search and update single aircraft, can translate it to English and add extra select boxes.
I've sent you an email and Personal Message. But no reply?
Response is comming ;) almost done with the email last evening but due to a incident outside of my house i was not able to finish it.
You will get the response in a few hours, first have to do some things at my work..
Quote from: phmlr on November 25, 2021, 09:17:38 AM
Response is comming ;) almost done with the email last evening but due to a incident outside of my house i was not able to finish it.
You will get the response in a few hours, first have to do some things at my work..
Thanks. I wasn't sure you'd received the messages.
Maybe it's just me, but none of the hex codes entered into SBS-1 Populate return any data from the Dutchradar server?
Yes i have removed every row, database has now 4265 rows (Only Dutch aircraft).
I'm creating some scripts for different kind of solutions, if everything is working the database will be loaded again with a big amount of data.
Will also share a page where people can search and upload/date single aircraft.
Thanks for the update.
Hi,
Thanks for trying to get this program up and running once more.
I have been away from the hobby for a while, since the demise of GAS and my database getting corrupt, its been a right pain in the backside updating entries.
Do you know when this will be working again??
Cheers
Andy
Quote from: moonie31 on December 31, 2021, 03:10:26 PM
Hi,
Thanks for trying to get this program up and running once more.
I have been away from the hobby for a while, since the demise of GAS and my database getting corrupt, its been a right pain in the backside updating entries.
Do you know when this will be working again??
Cheers
Andy
Hi Andy,
If you're interested, I could run in an update to your SQB. It will not touch your logs and I can ensure any particular fields you might want to protect are also not updated e.g. OperatorFlagCode field if you have manually modified entries.
pm me your email address if you'd like to give it a go.
Steve
Thanks for the offer, but that .SQB file is long in the bin.
I used the file that was on my laptop (it was about a year old) and im just updating that as and when required.
The updates are getting less and less now, but would be nice to have GAS (or the new dutch one) back up and running.
i miss active display!!!!!
Andy
Hello there, was just wondering if sbs populate is working correctly? reason i ask is mine has not been populating any planes for well over a month now. It was all working fine when it came back alive last year but all of a sudden a few month ago it just stopped updating codes. ive made sure the database is located to the virtual store but as i had not changed anything im sure it wasnt something i had done.
Thanks
Quote from: webmonkeyuk on January 07, 2022, 04:44:48 PM
Hello there, was just wondering if sbs populate is working correctly?
The application works but the remote server doesn't have any data. Consequently the app can't populate a local sqb file.
See the earlier post in this thread.
https://radarspotting.com/forum/index.php?topic=12732.msg83862#msg83862
When I checked yesterday there was still no data on the server.
SBS-1 Populate is like a car without fuel!
ah thanks for the info. strangely when i ran it all day yesterday it looked like it was working again and had actually populated about 13 codes but today its just come up with some error. guess just hope it will eventually get fixed sometime.
many thanks
Just checked and there still doesn't appear to be any data on the Dutchradar.nl server.
Please Note.
If you're using SBS-1 Populate be aware that if you run Populate, Auto Populate, Re Populate or Flag Populate, it may appear to be "working". But what you usually see is the data you already have in your local Basestation.sqb file. Most likely it's not data retrieved from the Dutchradar.nl server's database. So the app "works" but more often than not there's no data available from the server to update records in your sqb file.
SBS-1 Populate will first attempt to retrieve data from the server but if there's none available it will retrieve it from the sqb file.
To demonstrate this, wait until your receiver picks up a new aircraft. When it does, make a note of the hex code and select the Single Records tab and enter the code. Then click "GAS Load".
SBS-1 Populate will try and retrieve the data from the server and will show a message that data has been retrieved. But more often than not you won't see any data being populated as there's none to retrieve.
There is some data on the server but not much. All my recent attempts to populate a Single Record have failed.
Perhaps we can get a status update from Dutchradar.nl?
Yes, the database is filled with around 28K of rows but will have some errors/wrong info.
There are multiple things on my to-do list which have priority for now.
For the database i have created an area on my website where you can search and update the database, and yes i like clean html/css code instead of crappy smooth making scripts.
This "website" is still in progress, but you can update the database already.
The updates will go to a sub database to be checked, if everything is correct i need to run a manual script to move it to the main DB.
Later there will be an option for database administrators to send it to the main DB.
Link: https://dutchradar.nl/Database/index.php (https://dutchradar.nl/Database/index.php)
Quote from: phmlr on January 13, 2022, 08:32:25 AM
Yes, the database is filled with around 28K of rows but will have some errors/wrong info.
Thank you for the update.
To put the 28k rows into perspective, s92driver's Populated SQB file has 470k of aircraft rows. So SBS-1 Populate is accessing around 6% of available data.
Quote from: phmlr on January 13, 2022, 08:32:25 AM
There are multiple things on my to-do list which have priority for now.
I offered to help but we didn't get very far!
I'm not going to use s92driver's Populated SQB/Planebase, because the DB is not used the correct fields like operator code.. (the error's)
The database will not only usable for Basestation/VRS databases.
The most things on my list are private things and when i got time i can work on the website, when this is completed i will give you the database administrator rights.
28K is not much, but everyone can send updates ;) .
Quote from: phmlr on January 13, 2022, 09:04:47 AM
I'm not going to use s92driver's Populated SQB/Planebase, because the DB is not used the correct fields like operator code.. (the error's)
The database will not only usable for Basestation/VRS databases.
I wan't suggesting you use this database and understand your reasons for not doing so. I was only trying to show how many aircraft records exist in other databases.
Hi Guys, i use SBS, to run with my AERODATA database, i get alerts via their own 'alert program' ,
i used to use ACTIVE DISPLAY to populate my SBS , which worked great when i was abroad ( US / UAE etc ),
does this program here - do the same , what do i do to get it running ? just run the program file ? - will it loate my SBS - SQB file automatically ?
thanks for any help ?
SBS-1 Populate can be used to manually update an sqb record or auto-populate. BUT......
Auto-populate needs a remote database and this is no longer available. Dutchradar.nl gave up!
I use SBS-1 Populate to update single records, entering the missing data from various sources.
If you're happy to do this, just download the app using the link on the first post in this thread. You'll have to tell it where your active sqb file is located.
Thankyou for the reply. what you suggest is what i am currently doing.
i thought it was a program that autofilled again
no probs
thanks
Quote from: YORKIESI on June 22, 2022, 04:16:52 PM
i thought it was a program that autofilled again
It did - for a short while!
was just wondering if anyone would give me a few pointers, I'm trying to reinstall sbs populate and just can't seem to get it going.
I've downloaded the the program and extracted it to a new folder on the desktop, I run the setup application and it installs but a program compatibility assistant pops up saying it might not of installed correctly. I just click its installed correctly and the program starts. at the bottom it then says error reading ini file 53 and cannot find a file located in the virtual store. I've tried to update the database path to both program files x86 and in the virtual store but it still says same. and if I try to run auto populate it just says AP22 DB read failed.
and after I've Installed it there is also no short cut to run the program so I'm not sure how to restart it after I close it? I dont remember having similar issues with my old laptop. not sure what I'm doing wrong
thanks
From where did you download SBS-1Populate and was it it a 32 or 64 bit version?
Is your desktop a different processor bit speed to your laptop?
I downloaded it from here on the First page, not sure what version it is though. I've got it installed and set the database to the "Basestation" in the virtual store which seems to get it running fine. only thing I've noticed though is there's no short cut still but ive made one myself. up to now it seems to run fine, I left it running last night and it populated over 30 aircraft.
thanks for replying
Sounds like you're OK now?
SBSPopulate - Where is it located on the computer? I downloaded it yesterday and it worked. Closed it down and now can't find it. I tried a re-install but it says SBSPopulate can not be installed it is already installed in another location.
What version of Windows are you using?
Windows 10 Pro. I've searched in all the "usual' places, Program Files, Program Files (x86), Kinetic Folder, Virtual Store, Users. I just can't find it!
Click the Windows Start icon and scroll down for:
Gatwick Aviation Society
..and then the down arrow to expose:
SBSPopulate
Right Click to Pin to Start or More to Open File Location from where you can create a desktop Shortcut.
Thanks.
I did actually find it in C:\Users\David\AppData\Local\Apps\2.0\TNDNDV17.5WA\W7MLA8GZ.6NC
But your way is much easier...DOH!
Yes, that's where it's installed but I thought my way would be easier ;)
Evening all, I need some help please. I have downloaded the 64 bit software, and upon trying to add the path to my sqb file, the folder doesnt show my sqb file in the Basestation folder. Any ideas?
Ray
What's the folder path for your Basestation install? If it's in Program Files(X86), the active sqb file will be in the Virtual Store?
Also check your Explorer View options. Are Hidden files checked as "Don't Show" and Protected files as "Hide"?
Quote from: Anmer on September 07, 2022, 09:20:20 PM
What's the folder path for your Basestation install? If it's in Program Files(X86), the active sqb file will be in the Virtual Store?
Also check your Explorer View options. Are Hidden files checked as "Don't Show" and Protected files as "Hide"?
my basestation folder is in C: Tools > Basestation. The sqb file is there, but doesnt show when I follow the database trail.
Ray
Sorry, I forgot SBS-1 Populate only shows the database folders, not the files.
So you select the folder in which the sqb file is located.
You can easily confirm by entering a known Code (hex) record and select "Get from SBS DB".
SBS-1 Populate should then retrieve and display the record from the sqb file.
ah, I was trying to put the path to my sqb, but all I had to do was Tools > Basestation, now seems to be working
Ray
Morning all, the GAS populate seems to be working ok, but isnt refreshing my actual sqb, ive tried F5, to no obvious avail. Am I still missing something?
Ray
Quote from: REACHhunter on September 08, 2022, 07:47:30 AM
Am I still missing something?
Yes, one has to also "refresh" the database:
Basestation -> Aircraft -> Refresh DB Data for All
Just to mention that the SBS-1 Populate Auto-populate doesn't work. It might appear to work but it's returning existing data from the sqb. It does this by default if the remote server isn't available.
One has to manually complete the relevant fields and select "Update".
Quote from: Anmer on September 08, 2022, 08:57:49 AM
Just to mention that the SBS-1 Populate Auto-populate doesn't work. It might appear to work but it's returning existing data from the sqb. It does this by default if the remote server isn't available.
One has to manually complete the relevant fields and select "Update".
im pretty sure I just havent got this working correctly. I cant see a single update to my DB. I am just running populate unknowns, it says 154 updated so far, but every field that showed was just hex and country, so as far as I can see, nothing has been added
Ray
Ah, I just run Auto populate, and it said 4BB869 was populated, so I then double clicked on that code on SBS and pressed refresh, and hey presto, it was updated. So its working somewhere lol. Not sure how often I want to do that though. cheers
Ray
Thanks for the update.
I just launched Basestation with a new, empty sqb file and then SBS-1 Populate's Auto Populate. And sure enough it seems to be working again, accessing a remote server and database.
I assume the dutchradar.nl is back online?
Having said that, the data quality hasn't improved! See attached.
N321SD is a GLF4, s/n 4023 registered to GULFSTREAM LEASING LLC
G350 isn't an ICAO aircraft type.
[attachment deleted reduce file load]
I suspect my SQB is being used as the database.
However I intend that my next SQB update, at the end of September, will remove the "made up" ICAO codes and replace them with the official version.
Evening folks,
After happily using the re-born version of SBS Populate for the last three years to easily keep my SQB file up to date as I want it to be without issue, the latest Windows Update seems to have ruined all that .... The app will not launch now and I get the following error message - I am not a computer expert but does this mean anything to anyone ?
PLATFORM VERSION INFO
Windows : 10.0.19045.0 (Win32NT)
Common Language Runtime : 4.0.30319.42000
System.Deployment.dll : 4.8.4654.0 built by: NET48REL1LAST_B
clr.dll : 4.8.4645.0 built by: NET48REL1LAST_B
dfdll.dll : 4.8.4654.0 built by: NET48REL1LAST_B
dfshim.dll : 10.0.19041.30000 (WinBuild.160101.0800)
SOURCES
Deployment url : file:///C:/Users/Horne/OneDrive/Desktop/SBSPopulate.appref-ms%7C
ERROR SUMMARY
Below is a summary of the errors, details of these errors are listed later in the log.
* Activation of C:\Users\Horne\OneDrive\Desktop\SBSPopulate.appref-ms| resulted in exception. Following failure messages were detected:
+ Downloading file:///C:/Users/Horne/AppData/Local/Temp/Temp2_sbspopulatedb_1.64.0.13c.zip/SBSPopulateDB.application did not succeed.
+ Could not find file 'C:\Users\Horne\AppData\Local\Temp\Temp2_sbspopulatedb_1.64.0.13c.zip\SBSPopulateDB.application'.
+ Could not find file 'C:\Users\Horne\AppData\Local\Temp\Temp2_sbspopulatedb_1.64.0.13c.zip\SBSPopulateDB.application'.
+ Could not find file 'C:\Users\Horne\AppData\Local\Temp\Temp2_sbspopulatedb_1.64.0.13c.zip\SBSPopulateDB.application'.
COMPONENT STORE TRANSACTION FAILURE SUMMARY
No transaction error was detected.
WARNINGS
There were no warnings during this operation.
OPERATION PROGRESS STATUS
* [10/08/2023 22:28:37] : Activation of C:\Users\Horne\OneDrive\Desktop\SBSPopulate.appref-ms| has started.
ERROR DETAILS
Following errors were detected during this operation.
* [10/08/2023 22:28:37] System.Deployment.Application.DeploymentDownloadException (Unknown subtype)
- Downloading file:///C:/Users/Horne/AppData/Local/Temp/Temp2_sbspopulatedb_1.64.0.13c.zip/SBSPopulateDB.application did not succeed.
- Source: System.Deployment
- Stack trace:
at System.Deployment.Application.SystemNetDownloader.DownloadSingleFile(DownloadQueueItem next)
at System.Deployment.Application.SystemNetDownloader.DownloadAllFiles()
at System.Deployment.Application.FileDownloader.Download(SubscriptionState subState, X509Certificate2 clientCertificate)
at System.Deployment.Application.DownloadManager.DownloadManifestAsRawFile(Uri& sourceUri, String targetPath, IDownloadNotification notification, DownloadOptions options, ServerInformation& serverInformation)
at System.Deployment.Application.DownloadManager.DownloadDeploymentManifestDirect(SubscriptionStore subStore, Uri& sourceUri, TempFile& tempFile, IDownloadNotification notification, DownloadOptions options, ServerInformation& serverInformation)
at System.Deployment.Application.DownloadManager.DownloadDeploymentManifest(SubscriptionStore subStore, Uri& sourceUri, TempFile& tempFile, IDownloadNotification notification, DownloadOptions options)
at System.Deployment.Application.ApplicationActivator.ProcessOrFollowShortcut(String shortcutFile, String& errorPageUrl, TempFile& deployFile)
at System.Deployment.Application.ApplicationActivator.PerformDeploymentActivation(Uri activationUri, Boolean isShortcut, String textualSubId, String deploymentProviderUrlFromExtension, BrowserSettings browserSettings, String& errorPageUrl, Uri& deploymentUri)
at System.Deployment.Application.ApplicationActivator.PerformDeploymentActivationWithRetry(Uri activationUri, Boolean isShortcut, String textualSubId, String deploymentProviderUrlFromExtension, BrowserSettings browserSettings, String& errorPageUrl)
--- End of stack trace from previous location where exception was thrown ---
at System.Runtime.ExceptionServices.ExceptionDispatchInfo.Throw()
at System.Deployment.Application.ApplicationActivator.PerformDeploymentActivationWithRetry(Uri activationUri, Boolean isShortcut, String textualSubId, String deploymentProviderUrlFromExtension, BrowserSettings browserSettings, String& errorPageUrl)
at System.Deployment.Application.ApplicationActivator.ActivateDeploymentWorker(Object state)
--- Inner Exception ---
System.Net.WebException
- Could not find file 'C:\Users\Horne\AppData\Local\Temp\Temp2_sbspopulatedb_1.64.0.13c.zip\SBSPopulateDB.application'.
- Source: System
- Stack trace:
at System.Net.FileWebRequest.EndGetResponse(IAsyncResult asyncResult)
at System.Deployment.Application.SystemNetDownloader.DownloadSingleFile(DownloadQueueItem next)
--- Inner Exception ---
System.Net.WebException
- Could not find file 'C:\Users\Horne\AppData\Local\Temp\Temp2_sbspopulatedb_1.64.0.13c.zip\SBSPopulateDB.application'.
- Source: System
- Stack trace:
at System.Net.FileWebResponse..ctor(FileWebRequest request, Uri uri, FileAccess access, Boolean asyncHint)
at System.Net.FileWebRequest.GetResponseCallback(Object state)
--- Inner Exception ---
System.IO.FileNotFoundException
- Could not find file 'C:\Users\Horne\AppData\Local\Temp\Temp2_sbspopulatedb_1.64.0.13c.zip\SBSPopulateDB.application'.
- Source: mscorlib
- Stack trace:
at System.IO.__Error.WinIOError(Int32 errorCode, String maybeFullPath)
at System.IO.FileStream.Init(String path, FileMode mode, FileAccess access, Int32 rights, Boolean useRights, FileShare share, Int32 bufferSize, FileOptions options, SECURITY_ATTRIBUTES secAttrs, String msgPath, Boolean bFromProxy, Boolean useLongPath, Boolean checkHost)
at System.IO.FileStream..ctor(String path, FileMode mode, FileAccess access, FileShare share, Int32 bufferSize, FileOptions options, String msgPath, Boolean bFromProxy)
at System.Net.FileWebStream..ctor(FileWebRequest request, String path, FileMode mode, FileAccess access, FileShare sharing, Int32 length, Boolean async)
at System.Net.FileWebResponse..ctor(FileWebRequest request, Uri uri, FileAccess access, Boolean asyncHint)
COMPONENT STORE TRANSACTION DETAILS
No transaction information is available.
Interestingly another member mentioned something similar in the Chat box yesterday. He did a Windows restore to get SBS-1 working again and then suggested his VPN was the culprit. No corroboration of that yet.
What version of Windows do you use and do you know the update reference?
Morning Anmer,
Thank you for the reply. I am using Windows 10 22H2, I am not sure what the update reference is but it will have been the last one a couple of days ago.
The good news is ... In the cold light of day, I downloaded and reinstalled the program again and fingers crossed ... It is working again !
IanH654
Quote from: IanH654 on August 11, 2023, 08:18:35 AMThe good news is ... In the cold light of day, I downloaded and reinstalled the program again and fingers crossed ... It is working again !
Great. That was going to be my next suggestion!
Thanks Anmer,
Hopefully the other person on the forum had similar luck with a re-installation.
Cheers,
IanH654
Quote from: IanH654 on August 11, 2023, 12:40:10 PMThanks Anmer,
Hopefully the other person on the forum had similar luck with a re-installation.
There are a few of us here who might think he wouldn't ;)
hey guys my sbs-populate has stopped running and i get the error
I have un installed it and when I attempt to install it again I get
Application cannot be started. Contact application vendor.
The programs starts to install and looks like its scanning then the error pops up
I am running Windows 10 64 bit 22H2 (and it worked ok up to the last windows update)
Anybody any idea please
I use it for updating my data base
The details of the failure are below
Many thanks
Kev S
PLATFORM VERSION INFO
Windows : 10.0.19045.0 (Win32NT)
Common Language Runtime : 4.0.30319.42000
System.Deployment.dll : 4.8.9176.0 built by: NET481REL1LAST_B
clr.dll : 4.8.9167.0 built by: NET481REL1LAST_B
dfdll.dll : 4.8.9176.0 built by: NET481REL1LAST_B
dfshim.dll : 10.0.19041.30000 (WinBuild.160101.0800)
SOURCES
Deployment url : file:///C:/Users/Kevin/Desktop/GAS%20Populator%2064bit%20Install%20&%20Zip/SBSPopulateDB.application
Application url : file:///C:/Users/Kevin/Desktop/GAS%20Populator%2064bit%20Install%20&%20Zip/SBSPopulateDB_1_64_0_13/SBSPopulateDB.exe.manifest
IDENTITIES
Deployment Identity : SBSPopulateDB.application, Version=1.64.0.13, Culture=neutral, PublicKeyToken=1e579edb8ae38d8a, processorArchitecture=msil
Application Identity : SBSPopulateDB.exe, Version=1.64.0.13, Culture=neutral, PublicKeyToken=1e579edb8ae38d8a, processorArchitecture=msil, type=win32
APPLICATION SUMMARY
* Installable application.
ERROR SUMMARY
Below is a summary of the errors, details of these errors are listed later in the log.
* An exception occurred while determining trust. Following failure messages were detected:
+ Value does not fall within the expected range.
* Activation of C:\Users\Kevin\Desktop\GAS Populator 64bit Install & Zip\SBSPopulateDB.application resulted in exception. Following failure messages were detected:
+ Value does not fall within the expected range.
COMPONENT STORE TRANSACTION FAILURE SUMMARY
No transaction error was detected.
WARNINGS
There were no warnings during this operation.
OPERATION PROGRESS STATUS
* [11/08/2023 16:55:51] : Activation of C:\Users\Kevin\Desktop\GAS Populator 64bit Install & Zip\SBSPopulateDB.application has started.
* [11/08/2023 16:55:51] : Processing of deployment manifest has successfully completed.
* [11/08/2023 16:55:51] : Installation of the application has started.
* [11/08/2023 16:55:51] : Processing of application manifest has successfully completed.
* [11/08/2023 16:55:52] : Found compatible runtime version 2.0.50727.
* [11/08/2023 16:55:52] : Detecting dependent assembly Sentinel.v3.5Client, Version=3.5.0.0, Culture=neutral, PublicKeyToken=b03f5f7f11d50a3a, processorArchitecture=msil using Sentinel.v3.5Client, Version=3.5.0.0, Culture=neutral, PublicKeyToken=b03f5f7f11d50a3a, processorArchitecture=msil.
* [11/08/2023 16:55:52] : Detecting dependent assembly System.Data.Entity, Version=3.5.0.0, Culture=neutral, PublicKeyToken=b77a5c561934e089, processorArchitecture=msil using System.Data.Entity, Version=3.5.0.0, Culture=neutral, PublicKeyToken=b77a5c561934e089, processorArchitecture=msil.
ERROR DETAILS
Following errors were detected during this operation.
* [11/08/2023 16:55:52] System.ArgumentException
- Value does not fall within the expected range.
- Source: mscorlib
- Stack trace:
at System.Deployment.Internal.Isolation.IDefinitionAppId.EnumAppPath()
at System.ActivationContext.CreateFromNameAndManifests(ApplicationIdentity applicationIdentity, String[] manifestPaths)
at System.Deployment.Application.ActivationDescription.ToActivationContext()
at System.Deployment.Application.ApplicationActivator.DownloadApplication(SubscriptionState subState, ActivationDescription actDesc, Int64 transactionId, TempDirectory& downloadTemp)
at System.Deployment.Application.ApplicationActivator.InstallApplication(SubscriptionState& subState, ActivationDescription actDesc)
at System.Deployment.Application.ApplicationActivator.PerformDeploymentActivation(Uri activationUri, Boolean isShortcut, String textualSubId, String deploymentProviderUrlFromExtension, BrowserSettings browserSettings, String& errorPageUrl, Uri& deploymentUri)
at System.Deployment.Application.ApplicationActivator.PerformDeploymentActivationWithRetry(Uri activationUri, Boolean isShortcut, String textualSubId, String deploymentProviderUrlFromExtension, BrowserSettings browserSettings, String& errorPageUrl)
--- End of stack trace from previous location where exception was thrown ---
at System.Runtime.ExceptionServices.ExceptionDispatchInfo.Throw()
at System.Deployment.Application.ApplicationActivator.PerformDeploymentActivationWithRetry(Uri activationUri, Boolean isShortcut, String textualSubId, String deploymentProviderUrlFromExtension, BrowserSettings browserSettings, String& errorPageUrl)
at System.Deployment.Application.ApplicationActivator.ActivateDeploymentWorker(Object state)
* [11/08/2023 16:55:52] System.ArgumentException
- Value does not fall within the expected range.
- Source: mscorlib
- Stack trace:
at System.Deployment.Internal.Isolation.IDefinitionAppId.EnumAppPath()
at System.ActivationContext.CreateFromNameAndManifests(ApplicationIdentity applicationIdentity, String[] manifestPaths)
at System.Deployment.Application.ActivationDescription.ToActivationContext()
at System.Deployment.Application.ApplicationActivator.DownloadApplication(SubscriptionState subState, ActivationDescription actDesc, Int64 transactionId, TempDirectory& downloadTemp)
at System.Deployment.Application.ApplicationActivator.InstallApplication(SubscriptionState& subState, ActivationDescription actDesc)
at System.Deployment.Application.ApplicationActivator.PerformDeploymentActivation(Uri activationUri, Boolean isShortcut, String textualSubId, String deploymentProviderUrlFromExtension, BrowserSettings browserSettings, String& errorPageUrl, Uri& deploymentUri)
at System.Deployment.Application.ApplicationActivator.PerformDeploymentActivationWithRetry(Uri activationUri, Boolean isShortcut, String textualSubId, String deploymentProviderUrlFromExtension, BrowserSettings browserSettings, String& errorPageUrl)
--- End of stack trace from previous location where exception was thrown ---
at System.Runtime.ExceptionServices.ExceptionDispatchInfo.Throw()
at System.Deployment.Application.ApplicationActivator.PerformDeploymentActivationWithRetry(Uri activationUri, Boolean isShortcut, String textualSubId, String deploymentProviderUrlFromExtension, BrowserSettings browserSettings, String& errorPageUrl)
at System.Deployment.Application.ApplicationActivator.ActivateDeploymentWorker(Object state)
COMPONENT STORE TRANSACTION DETAILS
No transaction information is available.
Did you uninstall SBS-1 Populate before trying a fresh install?
The most recent Windows update is Pending on my PC. I'll see what gives when I run it :-\
Latest Windows Update installed and SBS-1 Populate working as normal.
No need to do a fresh install.
Windows 10 64 bit:
August 8, 2023âKB5029244 (OS Builds 19044.3324 and 19045.3324)
August 8, 2023-KB5029649 Cumulative Update for .NET Framework 3.5, 4.8 and 4.8.1 for Windows 10 Version 22H2
Successfully installed on â11/â08/â2023
same updates as mine.
Do you have a link for the 64 bit GAS populator so i will try a fresh version
kev
I've uploaded three versions of SBS-1 Populate:
1.32.0.13 GAS (https://radarspotting.com/forum/index.php?action=tportal;sa=download;dl=item625)
1.64.0.13 GAS (https://radarspotting.com/forum/index.php?action=tportal;sa=download;dl=item624)
1.64.0.13 dutchradar.nl (https://radarspotting.com/forum/index.php?action=tportal;sa=download;dl=item626)
I don't know which version you had installed. Mine is the dutchradar version.
When do you get the error? When you load SBS-1 Populate or when you use it? And how do you launch it?
No joy on those exactly the same failure message.
This is what i do
1) download wib zipped file
2) extract to a seperate file
3) Run set up (either as administrator or not)
4) it pops up showing its starting to install
5) I then get the error I mentioned
Any ideas ?
Kev S
Hi Kev
Did you uninstall previous version?
This may help:
https://stackoverflow.com/questions/1166233/clickonce-error-value-does-not-fall-within-the-expected-range
Cheers for the ongoing help
Found the folders in app data removed them all rebooted and re-tried , and got the same error
Downloaded the MS Clean removal tool and cannot find any entries for gatwick /GAS / sbs populator
So no joy from that .net url that was sent
Kev S
Did you uninstall SBS Populate using Windows "Apps and Features"? Check if it still shows as an installed app?
Nothing in : Control Panel\All Control Panel Items\Programs and Features
Nothing showing in Registry either under local user - software or local machine - software
Kev S
Before trying the following, maybe close and restart Windows and try a reinstall again?
If that doesn't work, using File Explorer with Options set to:
Show hidden files, folders and drives - checked
Hide protected operating system files (Recommended) - Unchecked
Navigate to Users -> your login name -> AppData -> Local -> Apps.
Expand each and every subfolder and look for any files referencing SBSPopulate. There may be more than one such folder.
Copy any of these folders and files to another location, such as a USB or SD stick/card as a backup. Make a note of the folder name containing these subfolders and files as you may need to retore to that location.
Be careful with the next step and only delete the folder and files referencing SBSPopulate. Do not delete any folders or files that you haven't copied as a backup.
Please do not attempt the above if you have any concerns and do so at your own risk!
No issues with getting this in depth mate
Followed instruction backed up files
There was a few folders in there that mentioned sbs deleted as requested
What was left was empty folders
Re-launched installer package and same issue.
Looking in the folder there was a 2.0 folder installed and a few other blank foders
Have attatched screen clips
Kev S
Thanks Kev.
Sorry, my posts always assume basic IT experience/knowledge ;)
If you've cleared and deleted all the folders that had any SBSPopulate data I've run out of suggestions.
Years ago the late Gary Jones suggested this approach when there was a malformed SBS-1 Populate install. But I can't find the email which was about 15 years ago!
Sorry, I'm at a loss!
Cheers for all so far.
Removed all those files to a USB stick so the folder was empty
Re-booted re-ran the isntaller
Same error
I am betting its a registry entry but what and where i have no idea
Kev S
One thing Gary Jones did tell me (and I think it also applies to SBS-1 Populate):
Don't fiddle with the registry, AD has nothing there and it is all controlled by .NET and upsetting .NET is terminal.
it seems like it part installs and errors ....Can see it being an active domain issue.
Kev S
Maybe uninstall and reinstall .Net?
just tried that rebooted and re-installed no joy
kev
Sorry Kev, that's me cleaned out of suggestions :-[
appreciated see if anybody else has any suggestions :(
kev S