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.