Welcome to Radarspotting. Please login or sign up.

May 03, 2024, 12:12:46 PM

Login with username, password and session length

New Members

New Members

You should get an activation email when you join.  If not, please use the Contact option.

Importing Bulk Data to the Basestation.sqb

Started by Anmer, January 28, 2023, 08:46:07 AM

Previous topic - Next topic

0 Members and 1 Guest are viewing this topic.

Anmer

A forum member asked for help importing selective data from an Excel file into a Basestation.sqb.

Another member, Faramir offered to help and has developed a small app callled SQBMerge.

SQBMerge imports and merges data from a comma-delimited csv file into a Basestation.sqb.  The primary record is a hex code which SQBMerge will validate for format and allocation against a copy of the Countries.dat file.

I have tested SQBMerge and it has been successfully used by the member who asked for help.

Faramir has kindly "donated" SQBMerge to the forum for use by other members.

At this time only four data fields can be imprted:

  • Hex Code
  • Registration
  • Type
  • OperatorFlagCode
However, Faramir is open to suggestions for extending the data to be imported.

My sincere thanks to Faramir for helping develop SQBMerge and supporting me in the testing.

SQBMerge can be downloaded from the Software section and there's an accompanying User Guide.

Feedback and suggestions are most welcome.
Here to Help.