I run CQRLOG with my own instance of MySQL that's running all the time on my box. I do this so that I can plug into the DB during times when CQRLOG may not be running. For example, I've got a small perl script that allows me to quickly query the DB to determine if I've worked someone before. I'm now working on a script that takes the ADIF file from JT65-hf and imports it into the DB. So far, I've got callsign, freq, etc (all the fields that are in the JT65 ADIF) importing fine into the DB. However, if I go to edit the QSO in CQRLOG, CQRLOG complains about not having waz and itu filled in. Seems like these values are calculated somehow during the ADIF import in CQRLOG.
Any ideas how I could replicate this behavior outside of CQRLOG? Basically I want something that'll import my JT65 log and get a new ADIF file started on a regular basis.
Sun, 2012-10-14 20:10
#1
ITU and WAZ calculation.
ITU and WAZ zones are not calculated, they are taken from the country files. CQRLOG employs rather complex algporithm to assign countries and zones to a particular call sign because there is a half dozen of different schemes used by local authorities for prefixes AND suffixes used in different areas. It took ~20 years to collect all the info and develop the algorithm. So, I doubt that a simple Perl script would help...
If you use your own script, I suppose it won't recognize the country from callsign, right? After the import please run Rebuild DXCC statistic function from QSO list window - Statistics -> DXCC statistic. It should add right zones and countries.
73 Petr
--
http://HamQTH.com/ok2cqr
https://ok2cqr.com