H26 (or other regional) Award handling
Posted: 04 Jan 2020, 10:20
All,
My intent was to use Log4Om's Award functionality to check the status of a Swiss Award (H26); it is already defined by default in the customized awards (H26).
No record was shown initially, so I first worked on getting the Regional identifier (Swiss Canton) in the "State" field of the dB through ADIF, see this thread:
viewtopic.php?f=6&t=4302
The Next step is specific to a Log4OM MySQL Database, I do not know if it works the same on a local database.
We need to populate the "QsoAward" field based on the required format: "H26@<canton ID>"; I did that through a MySQL statement applied through the QSO archive / Field update / Execute custom update query.
I entered the following MySQL statement:
UPDATE `log4om2`.`log` SET QsoAwards = CONCAT('H26@', State) WHERE (country="Switzerland") AND (state<>'');
In your case you may have to check if the MySQL Database name is different than "log4om2" I am using and change the above statement accordingly.
I can now use Log4OM's native H26 award statistics, see picture enclosed
Marco HB9CAT
My intent was to use Log4Om's Award functionality to check the status of a Swiss Award (H26); it is already defined by default in the customized awards (H26).
No record was shown initially, so I first worked on getting the Regional identifier (Swiss Canton) in the "State" field of the dB through ADIF, see this thread:
viewtopic.php?f=6&t=4302
The Next step is specific to a Log4OM MySQL Database, I do not know if it works the same on a local database.
We need to populate the "QsoAward" field based on the required format: "H26@<canton ID>"; I did that through a MySQL statement applied through the QSO archive / Field update / Execute custom update query.
I entered the following MySQL statement:
UPDATE `log4om2`.`log` SET QsoAwards = CONCAT('H26@', State) WHERE (country="Switzerland") AND (state<>'');
In your case you may have to check if the MySQL Database name is different than "log4om2" I am using and change the above statement accordingly.
I can now use Log4OM's native H26 award statistics, see picture enclosed
Marco HB9CAT