Loading A Database

Load (Import) one or more databases from the internet into your own database in SDR Console.

Import

The same window is used for all databases. The second file is only used with HFCC, for other databases it is disabled.

1. Select the file to be imported,
2. Press Load. The load status will be shown, for example Loaded 4,257 definitions.
3. Press Add to Database. Either:
   • Add the definitions (all current definitions are kept), or
   • Replace existing definitions for the current database.
4. When the definitions have been added close this window.

The status at the bottom of the options window shows the definitions count for each database.

Aoki

Home: http://www.geocities.jp/binewsjp/

Select the most recent database (ZIP format), unpack the contents to a folder on your computer. The main text file is used, for example in ncb17.zip the file is ncb17.txt .

EiBi

Home: http://www.eibispace.de/

Download the CSV database to a folder on your computer.

FMLIST

Home: http://fmscan.org/index.php then select Tools (userlist etc.), this should take you to http://fmscan.org/tools.php.

Set your location.

Select Userlists for Perseus / ELAD / Winradio / Stationlist / SDR Console, then on of:

• FM+ (Tropo)
• FM+ (Meteor Scatter)
• Sporadic E

CSV separator:

• Semicolon

You should see the text "The CSV format is a text file with: khz / country / language / program / modulation / location / latitude / longitude / power towards receiver / maximum power ERP / main transmitter beam / distance / azimuth / dB / RDS PS / RDS PI / pol / ID".

Download userlist1.csv to a folder on your computer.

HFCC

Home: http://www.hfcc.org/

Select Files in Standard Format, this should take you to http://www.hfcc.org/data/. Download the most recent ZIP archive, for example a18allx2.zip and extract the contents to a folder on your computer.

Two files will be used:

• A18all00.txt (name depends on the ZIP archive),
• Broadcas.txt

ILGRadio

Home: http://www.ilgradio.com/

Note: ILGRadio is a commercial website, the database is very comprehensive - an ILGRadio subscription is recommended. The database format used is CSV, save this file (usually ILGCDATA.CSV) to a folder on your computer.

MWLIST

Home: http://fmscan.org/index.php then select Tools (userlist etc.), this should take you to http://fmscan.org/tools.php.

Set your location.

Select Userlists for Perseus / ELAD / Winradio / Stationlist / SDR Console, then:

• LW/MW/SW (0-30 MHz)

CSV separator:

• Semicolon

You should see the text "The CSV format is a text file with: khz / country / language / program / modulation / location / latitude / longitude / power towards receiver / maximum power ERP / main transmitter beam / distance / azimuth / dB / target area / times / days / offset in Hz / beacon details / ID".

Download userlist1.csv to a folder on your computer.

Custom CSV

Add your own database using the custom csv file layout. To see the custom csv layout definition:

• Select the Save As... CSV option, this creates a csv file.
• Open the csv file with a text editor, for example Notepad.
• The column headers are shown in the first row after the comments.

You can either edit this file, or create a new file using these column headers.

• Rows starting with # are comments
• The column headers must start with Frequency, all other columns are optional.
• The Frequency value is in either Hertz or kilohertz (option selected when file is loaded),
• Each row of data must have a value for each column, even if the value is empty. If you have just 8 columns (first column is Frequency) then you must have 8 fields in each row of data.

Another way to create a file is to use Excel and use the Save As, CSV option.

Import your new file with the Custom CSV option.

Fields

October 29th, 2019 The column titles correspond to the fields in the database. The easiest way to get a list of the fields is by selecting Show As... CSV which creates and ediatble CSV file.

Frequency, Station, CallID, Language, Site, TX_Country, Time_On, Time_Off, Days, Target, Notes, Pwr, Azi, M, Org_Country, Lat, Lon, Dist, ITU, Locator, RDS_PS, RDS_PI, Polarity, Source, Date

Example 1

Frequency,Station,Pwr
3185000,"Blue Ridge Communications, Inc.",100
3195000,"Blue Ridge Communications, Inc.",100
3195000,"WNQM, Inc.",100
3195000,"WNQM, Inc.",100
3195000,"WNQM, Inc.",100
3195000,"WNQM, Inc.",100
3195000,"WNQM, Inc.",100
3195000,"WNQM, Inc.",100
3200000,Trans World Radio,25
3200000,Trans World Radio,50
3200000,Trans World Radio,50
3215000,"WNQM, Inc.",100
3215000,"WNQM, Inc.",100
3215000,"WNQM, Inc.",100
3215000,"Blue Ridge Communications, Inc.",100
3215000,"Blue Ridge Communications, Inc.",100
3215000,"Blue Ridge Communications, Inc.",100

This example has just three columns, available here [link].

• Three columns, first column is Frequency
• Each row has three values
• File created with Excel

Example 2

Frequency,Station,Pwr,Azi,M,Org_Country,Lat,Lon,Dist,Town
3185000,"Blue Ridge Communications, Inc.",100,,,WRB,,,,TownA
3195000,"Blue Ridge Communications, Inc.",100,,,WRB,,,,TownB
3195000,"WNQM, Inc.",100,,,WCR,,,,NoTown
3195000,"WNQM, Inc.",100,,,WCR,,,,NoTown
3195000,"WNQM, Inc.",100,,,WCR,,,,NoTown
3195000,"WNQM, Inc.",100,,,WCR,,,,NoTown
3195000,"WNQM, Inc.",100,,,WCR,,,,NoTown
3195000,"WNQM, Inc.",100,,,WCR,,,,NoTown
3200000,Trans World Radio,25,,,MAN,,,,NoTown
3200000,Trans World Radio,50,,,MAN,,,,NoTown
3200000,Trans World Radio,50,,,MAN,,,,NoTown
3215000,"WNQM, Inc.",100,,,WCR,,,,NoTown
3215000,"WNQM, Inc.",100,,,WCR,,,,NoTown
3215000,"WNQM, Inc.",100,,,WCR,,,,NoTown
3215000,"Blue Ridge Communications, Inc.",100,,,WRB,,,,NoTown
3215000,"Blue Ridge Communications, Inc.",100,,,WRB,,,,NoTown
3215000,"Blue Ridge Communications, Inc.",100,,,WRB,,,,NoTown

This example is the based on Example 1, available here [link].

• Has more columns,
• Empty values supplied where there is no data,
• The Town column is invalid and is ignored.