[Dx4win] how I found STATE info for US calls!

[Tonno Vahk]

I was dreaming for some time of an automated way to get STATE info for all
the US calls in my DX4WIN log (c.a. 4000) and US calls in my TRMASTER.DTA
(some 22 000) for ARRL contest. I did not consider looking them up one by
one from QRZ.COM an option:)

I found that ane uptodate database of all current US calls is available from
FCC FTP site:
ftp://ftp.fcc.gov/pub/Bureaus/Wireless/Databases/uls/complete/
File named "l_amat.zip" contains a text file named "EN.txt" that has wide
range of information including STATE for about 850 000 US and possessions
calls. It's size is around 100 Megs.

I downloaded it, imported into ACCESS, sorted out necessary info (call and
state) and exported it into text file. Then I imported this text file into
DX4WIN - to my satisfaction it handled 850 000 QSOs quite well:) I removed
all the possession calls and changed DC into MD for WAS. I also removed
those calls that had no STATE info - there is a small number in the FCC
database. After that I changed the date of all those around 800 000 QSOs to
1990 - that is before any of my actual QSOs.

No I merged my old Log File (23 000 qsos) with the existing large FCC File
and did Multiple QSO Operations -> Set US States. There were only some 200
(5%) of my US calls that did not get STATE info. Mostly because they are
previous calls and not in FCC database any more.

No I thought the easiest way to get rid of the FCC calls would be to Filter
them out and Delete. Well, deleting 800 000 QSOs from the Log took c.a. 7-8
hours on 1066 MHz Pentium III:))) But I had some time so I let it do it
altough there might have been easier ways to get rid of those QSOs. So
Deleting was the only problem DX4WIN had when handling that kind of a QSO
count!

Now - how to get STATEs into TRMASTER? I imported TRMASTER US calls through
text file into an empty DX4WIN log File and set the QSO date after the QSO
date of the large FCC Log File. Then I merged the two and SET STATES for
TRMASTER calls. Then Filtered out TRMASTER calls and Exported them back to
text File with States. I added DC to 12 DC calls manually. No it was easy to
run POST.EXE and add this STATE info to TRMASTER.DTA as USER 2 info.

I hope that somebody finds my "discovery" and ideas useful:) At least I was
very thrilled and decided to let you know about the way I did it:)

73
tonno
es5tv