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

[PY2YP]

Hi Tonno et al,

Many thanks for the nice tip. I�ve saved a zipped DXL file with all those US
calls. The file size is 2.371 Mbytes. If anyone has a site to host it please
drop me a line, I can send it.

73 DX de PY2YP - Cesar

----- Original Message -----
From: "Tonno Vahk" <tonno.vahk@mail.ee>
To: "DX4WIN reflector" <dx4win@mailman.qth.net>
Sent: Tuesday, February 25, 2003 11:13 AM
Subject: [Dx4win] how I found STATE info for US calls!


| 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
|
| _______________________________________________
| Dx4win mailing list
| Dx4win@mailman.qth.net
| http://mailman.qth.net/mailman/listinfo/dx4win
|