Ok Terry, you're obviously right, I did not formulate my question correctly: I am looking for the DX Challenge statistics, so the sum of all the band countries. I did: - View > Award statistics - Award: DXCC - Predefined config: Challenge - then I looked at the statistics tab What the right way to s...

Award Statistics > DXCC > Statistics Tab shows nicely a table the amount of worked/confirmed etc. qsos per band. The issue is that the rightmost column showing Totals per confirmation level is not calculating the totals properly, example: WORKED 80 99 187 135 233 121 145 48 83 55 290 CONFIRMED 68 75...

You're right, I didn't save the configuration correctly; I guess I just did save & exit

Now I see 127.0.0.1:3306 bottom right with a green dot, and the ADIF Import is working.

Thanks !
Marco

I have created the new MySQL Database, log looks OK: 2020-01-15 18:05:50.8834 INFO: [DbMysql] : MYSQL deploying database log4omnext START 2020-01-15 18:05:50.8944 INFO: [DbMysql] : Connection string: Server=127.0.0.1;Port=3308;User ID=hb9cat;Password=teresina;Pooling=false;SslMode=None 2020-01-15 18...

Hello,

the user guide clearly states that SQLITE databases can not be migrated, well understood.
What about MySQL ? there's no equally clear statement that it wouldn't work.

Marco HB9CAT

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 k...

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 throug...

For DXlog.net users: adding this

ADIF_KEYS=STATE;$VALUE.RecInfo.Substring(0,2)

to the contest definitions file will create the STATE entry in the ADIF file, it can then be imported into Log4OM

Marco HB9CAT

Thank you Terry, you're right, using STATE does indeed work: - I cleared an undeeded _space_ in my file - Imported the file: no change to the existing records - delete all those records from the Database - imported: it works, I do the the STATE field filled in correctly Which raises another concern:...

Indeed Terry, the standard defines the state as being a function of the DXCC field's value, there are enumerations for the following countries (not just U.S.): Enumeration for Country Code 1 (Canada) Enumeration for Country Code 5 (Aland Is.) Enumeration for Country Code 6 (Alaska) Enumeration for C...