Search found 37 matches

by hb9cat
27 Mar 2020, 13:46
Forum: User support
Topic: Award Statistics, wrong totals ?
Replies: 3
Views: 349

Re: Award Statistics, wrong totals ?

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...
by hb9cat
27 Mar 2020, 06:23
Forum: User support
Topic: Award Statistics, wrong totals ?
Replies: 3
Views: 349

Award Statistics, wrong totals ?

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...
by hb9cat
15 Jan 2020, 23:50
Forum: User support
Topic: Create and use MYSQL Database
Replies: 3
Views: 466

Re: Create and use MYSQL Database

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
by hb9cat
15 Jan 2020, 18:19
Forum: User support
Topic: Create and use MYSQL Database
Replies: 3
Views: 466

Create and use MYSQL Database

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...
by hb9cat
15 Jan 2020, 17:43
Forum: General discussions
Topic: Migration from Log4OM Version 1 - MySQL
Replies: 1
Views: 532

Migration from Log4OM Version 1 - MySQL

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
by hb9cat
04 Jan 2020, 15:02
Forum: General discussions
Topic: H26 (or other regional) Award handling
Replies: 2
Views: 1511

Re: H26 (or other regional) Award handling

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...
by hb9cat
04 Jan 2020, 10:20
Forum: General discussions
Topic: H26 (or other regional) Award handling
Replies: 2
Views: 1511

H26 (or other regional) Award handling

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...
by hb9cat
29 Dec 2019, 17:47
Forum: User Support
Topic: ADIF Import: use STATE field for regional Administrative subdivisions
Replies: 8
Views: 990

Re: ADIF Import: use STATE field for regional Administrative subdivisions

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
by hb9cat
29 Dec 2019, 08:49
Forum: User Support
Topic: ADIF Import: use STATE field for regional Administrative subdivisions
Replies: 8
Views: 990

Re: ADIF Import: use STATE field for regional Administrative subdivisions

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:...
by hb9cat
29 Dec 2019, 08:43
Forum: User Support
Topic: ADIF Import: use STATE field for regional Administrative subdivisions
Replies: 8
Views: 990

Re: ADIF Import: use STATE field for regional Administrative subdivisions

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