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" <[EMAIL PROTECTED]> To: "DX4WIN reflector" <[email protected]> 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 | [email protected] | http://mailman.qth.net/mailman/listinfo/dx4win |
