ILGRadio Database Import into DBF Manager - NEW RECOMMENDATION
ILGRadio Database "A" or "B" Import into DBF Manager Software
You can simply use ILGradio dBASE files with this Viewer Software along with various index funcions, data field selection and filter options
This ILGRadio Database gives a lot of details which cannot be displayed within various software which is available.The ILGRadio databse includes also many data fields or data sets you do not want to see on the screen.
That's why I recommend the DBF Manager and so I do not need to invent the wheel new again by creating my
own ILGRadio reader software.
This DBF Manager is very easy to understand and to handle ILGRadio data with INDEX and FILTER functions.
Manual to use the DBF Manager with ILGRadio database (e.g. ILGRadio "A" and "B" version):
Download the dBASE reader software "DBF Manager" (trial version) here:
LINK:
https://dbfmanager.com/de/download/
Software Information:
LINK:
https://dbfmanager.com/en/
USAGE DBF MANGER WITH ILG DATABASE:
1.
Create a directory for the ILGRadio file ("A" Version) ilgadata.dbf (ilgbdata.dbf) in dBASE Format.
2.
start the DBF Manger and click "File" and "Open" and select the ILGRadio file
3.
Check the letter type:
click "Tools" and "Options"
in Grid Font the "Courier New" must be selected. The background color can also be selcted here.
4.
You see now the ILGRadio database with all the data fields.
You can also change the size of the column or you can move as it is known in the Microsoft EXCEL software.
click picture for zoom view
4.
If you click the name of the column starting with "Freq" ... you can set the index, e.g. Location etc.
5.
If you want to go to e.g. 11685 khz click on "Search" on the top.
In window "Find data" mark "FREQ" and give "9500".
Verify with "FIND". Now you have the 11685 khz range and you can scroll up and down.
RESULT:
LEFT VIEW OF DATABASE
click picture for zoom view
RIGHT VIEW OF DATABASE
click picture for zoom view
6.
Various fields are not important for you and therefore you can suppress the display of selected fields
Go to "Tools" and "Columns Settings".
In the window "Table Columns" mark out those fields you do not want to see. If software will start later this selection remains!
click picture for zoom view
To change selection of fields click in "Table Colums" the button "Check All" and start the selection new again.
7.
You see the whole 24 hour range which may give still too much data on the screen.
Click on Top "Set" and "set Filter On".
In the window click the line "Click here to add condition".
Click the name "Freq" and a new window opens.
You want to see only transmissions on air between 1700-1800 UTC.
Select e.g. "G17".
Click on "contains" and select "does not contain"
Click on "<?>" and put in here ". " (dot and blank) and
select "Auto Update" and the green arrow.
Verify with "OK"
It is only possible to set a proper filer to one hour
using the fields G00 (0000-0100 UTC) ... G23 (2300-2400 UTC).
Now you can see all selected data of 1700 - 1800 UTC:
click picture for zoom view
8.
Special data fields for Geographic Coordination.
In the field "GC" (on far right side of data sets) you can find the exact transmitter site position with the coordinates, compatible to Google Earth or Google Maps.
In LONGI and LATI fields data are give in approx.ITU format with further details.
click picture for zoom view
9.
Filter Function with Language and UTC Time (1700 hour) selection
Here you can see the language filter function with FARSI language schedules in UTC time order with a selection of various data fields:
click picture for zoom view
10.
Set Filter Function to identify UTILITY Station with "ALE MIL-STD 188-141" type signal with call "465" on a new frequency
Here is the result and it clearly indicates that this signal is comming from China.
Signal target to other sites with further calls are also displayed on right side column
click picture for zoom view
11.
In the case you do not wish to work with frequencies e.g. lower than 5800 khz you can select data sets to delete:
Mark one data set in the first column and the other end of the selected range with SHIFT and the mouse click.
Click on "Edit" and "Cut" and verify with "OK"
Than go to "Edit" and click "Pack" and again "OK"
ATTENTION here in "Edit" the selection "Zap" means to delet all data sets !!!
click picture for zoom view
12.
If you felle the letter size is too small you can change the current size
Example with larger letter size:
click picture for zoom view
There are a lot of further functions you can test out.
- Edit Function
- Replace Function
- Import and Export Function
- Printing
- Printing Pre-View
- Skip, Go to first record or last record function
- Background Color
In the free software version (trial version) some functions are limited.
Full version with license is available for 44.95 Euro
If you have made further tips or comments please let me know
Have a fun with this software.