Total countries ....

Update and distribution of news relating to awards

Moderator: OE6CLD

Post Reply
oe2gen
Novice Class
Posts: 3
Joined: 08 Feb 2021, 07:54

Total countries ....

Post by oe2gen » 08 Feb 2021, 10:41

Hi Team!

The new version looks very good.

SQLite is a little slow to calculate the statistics (DXCC) at around 100,000 QSO's.

I am currently using UCXLOG and I am considering switching.

First, everything working fine, but with a little problem! LOTW in/out, WSJT x input and the cluster interface, great!!

But I dont' find a way to show in the "Awards" all my worked/confirmed countries in the "Total Table".

I see only always the ARRL valid "340" countries, but have worked and confirmed 350 countries.

The deleted countries are marked but only the 340 are in the "TOTAL table" displayed.
In the table, however, I see the 10 deleted countries marked differently in color.

It would be nice to see all my worked countries in the "total" table.
This means that all of my countries would also be calculated correctly in the statistics.

73, Gerald
OE2GEN, ....

User avatar
G4POP
Log4OM Alpha Team
Posts: 8165
Joined: 21 Jan 2013, 14:55
Location: Burnham on Crouch, Essex UK

Re: Total countries ....

Post by G4POP » 24 Feb 2021, 10:28

Regarding speed as you have 100K plus QSO's I would suggest that you use a MySQL database instead of SQLite

Regarding totals not including deleted entities this is a known issue and is on our Mantis list
73 Terry G4POP

oe2gen
Novice Class
Posts: 3
Joined: 08 Feb 2021, 07:54

Re: Total countries ....

Post by oe2gen » 24 Feb 2021, 18:59

Oh nice, to hear from you!

Yes, it's a little bit tricky with SQLite an >100K QSOs for a satisfied speed bout of statistic and so on ..
But I have a full license of MS SQL-Server and want to install this version of SQL-Database!

.. total countries would be nice, hopefully it work's in one of the next updates?

looking forward ...

73, Gerald
OE2GEN, ....

CT2HUU
Novice Class
Posts: 11
Joined: 10 Jul 2020, 14:43

Re: Total countries ....

Post by CT2HUU » 25 Feb 2021, 15:07

Hi
I have a similar problem.
Log4OM says that I have more countries validated that what LoTW says?! How is that possible?
diferença entre LoTW e Log4OM.JPG
diferença entre LoTW e Log4OM.JPG (230.02 KiB) Viewed 137 times
Tks
73
CT2HUU
Bruno

oe2gen
Novice Class
Posts: 3
Joined: 08 Feb 2021, 07:54

Re: Total countries ....

Post by oe2gen » 25 Feb 2021, 16:45

Hi Bruno!

Click in ARRL-LOTW-Awards "Select DXCC Award Account" (your Call) "View Award Credit Matrix"!
With 97 countries it's not so alot of work to check and compare with the log of LOG4OM.

73, Gerald
OE2GEN, ....

Post Reply