Radarspotting

Mode-S Software => Basestation => Topic started by: AlanT on May 12, 2021, 07:08:58 AM

Title: Deleting Mode-S codes
Post by: AlanT on May 12, 2021, 07:08:58 AM
Gents

Is there any way of deleting mode-s codes en-block for redundant airframes, thinking of the likes of RAF Harriers, tornadoeos, tristars etc etc, rather than have to felete each one individually.

I do not have much computer knowledge so anything technical is probably out of my comfort zone.

Thanks
Alan


Title: Re: Deleting Mode-S codes
Post by: reheat101 on May 12, 2021, 08:00:04 AM
Morning Alan,

Sounds like you have a pretty old SQB there ?,

I'm pretty sure you cannot do a bulk delete of mode-s code's in Basestation Reporter, or any other populating software, I could be wrong,
maybe check out Planebase.biz,

Why not start fresh with s92driver's SQB which you can download from here along with corresponding operator logos.

Regards,

Lee.
Title: Re: Deleting Mode-S codes
Post by: Anmer on May 12, 2021, 08:48:17 AM
SBS-1 Populate has the option to bulk delete aircraft types.

Alternatively you can use an SQL editor such as SQLite Expert Personal.  SBS-1 Populate looks to be the easier option which you can download using the link in this post:

https://radarspotting.com/forum/index.php?topic=12732.msg52335#msg52335:



[attachment deleted reduce file load]
Title: Re: Deleting Mode-S codes
Post by: egnx on May 12, 2021, 09:25:17 AM
Be aware that you can only remove a mode-s code that doesn't have any existing associated Flights in the BaseStation.sqb

So if the mode-s you want to delete has associated flights those have to be removed from the Flights table first before the Aircraft record can be deleted.

I don't know what the SBS-1 Populate does in these circumstances ?

egnx
Title: Re: Deleting Mode-S codes
Post by: Anmer on May 12, 2021, 11:00:27 AM
Quote from: egnx on May 12, 2021, 09:25:17 AM
I don't know what the SBS-1 Populate does in these circumstances ?

It deletes the associated sessions too.

Just, successfully, deleted all TOR types.

[attachment deleted reduce file load]
Title: Re: Deleting Mode-S codes
Post by: AlanT on May 13, 2021, 02:07:57 PM
Thanks gents will give SBS-1 Populate a try

Alan