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
