View Single Post
  #3   Report Post  
Old July 5th 05, 10:01 PM
Hank Oredson
 
Posts: n/a
Default

I have here a QSL from 1Z4NG (Norhday Island) ...
another from 9S4BN (Saar) ...
and also I1BNU (Trieste) ...
and DL1DX (Germany) ...
and Y32AB (East Germany) ...
and VK9TW (Now C2) ...
and ...

DL1, in particular, did not work right, turned up CE9, FO/m and GM/s.

Prefix to country lookup requires a date, for many callsigns.
This might be an optional input on the form.

Here is how I did it, in an Access database, 4 tables.

Hierarchy of lookup:

Call, a table of "unique and unusual calls".
Prefix, from the specific callsign prefix gives the generic prefix.
Region, from the generic prefix, e.g. UA2 is not Russia.
Entity, from the generic prefix.

Each entry in the call, prefix, region, entity tables has a start and end
date.

I use the current country.dat as a starting point, but it does not
cover some situations, and does not go back far enough in time for me.

Also wanted would be state (province / canton / prefecture) information,
grid square, county, IOTA, QSL manager, email address, etc.

Would be very nice to have a central database of such information.

QRZ has a lot of the data, but there is not (to my knowledge) a
simple means to make a realtime query, e.g. via XML.

--

... Hank

http://home.earthlink.net/~horedson
http://home.earthlink.net/~w0rli
"Zed Zed" wrote in message
.. .
Thank you for all the help and let me know how this works.

The updated version is now running.
http://www.onlinehamfest.com/search.htm

tnx es 73
Zed Zed

To reply to this message by email, please remove the X's.