H26 (or other regional) Award handling

General discussions about Log4OM features
Post Reply
hb9cat
Advanced Class
Posts: 35
Joined: 12 May 2014, 05:57

H26 (or other regional) Award handling

Post by hb9cat » 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
Attachments
Screen Shot 01-04-20 at 11.15 AM.PNG
Screen Shot 01-04-20 at 11.15 AM.PNG (62.83 KiB) Viewed 270 times

User avatar
IW3HMH
Site Admin
Posts: 2542
Joined: 21 Jan 2013, 14:20
Location: Quarto d'Altino - Venezia (ITA)
Contact:

Re: H26 (or other regional) Award handling

Post by IW3HMH » 04 Jan 2020, 11:33

Hi Marco,
good job. In future with V2 you can create an award and instruct it to search references in a specific database field.
As example you can configure the H26 award to monitor state field or address field and automatically extract references from there, if any.

Using that technique i was able to automatically fill (with a good percentage of success) my italian provinces award searching into the address for province code.

Is there a reference list for that award somewhere?
Daniele Pistollato - IW3HMH

hb9cat
Advanced Class
Posts: 35
Joined: 12 May 2014, 05:57

Re: H26 (or other regional) Award handling

Post by hb9cat » 04 Jan 2020, 15:02

Thanks Daniele,

interesting V2 functionality, looking forward to it.
I was just indeed considering the lookup as a next step: extract the regional identifier from data available from external databases ( for ex. zip code), or possibly also from the QTH locator (for 2m QSOs).

I'll check and let you know for the specific case of Switzerland.

Marco HB9CAT

Post Reply