On Feb 22, 2025, at 9:51?PM, Phill Hardstaff via groups.io <phill@...> wrote:

Hi all, been meaning to raise this one for a while now.

?

I get some weird results for QSO by continent, for example if I do QSO by Continent with no other filters I get figures that don't make sense. AF and AS show zero and it seems these are bundled up into the EU number? as you can see below it's not showing an AS at all. Probably at least half my contacts would be AS.

?

<Screenshot from 2025-02-23 15-38-53.png>

?

but if say show me for 15m it's looks about right and shows AS, which doesn't correlate with the above.?

?

<Screenshot from 2025-02-23 15-44-34.png>

?

30m and 10m I get same weird results where there is no AS but the AS numbers seem to be added to the EU numbers. For example for 10m it is saying I have 8,000 EU contacts which I most certainly do not have (I wish) It also says I have zero AS.

?

Any ideas. More than half the contacts here have been logged in QLOG and I am sure the continent filed is OK as for certain bands the data looks good.

?

73 Phill C21TS / FK1TS

?

?

?

?

Hi Michael, I'm not so sure, if I sort by continent, I only have 2 QSO with no continent (D1 calls) Also in the first screen shot it is saying I have no AS contacts at all, but the total number of contacts is right (or very close to total QSO 85K) However in the second screen shot for 15 meters it is saying I have 7K AS QSO? yet zero in the first. So in the first screenshot it is totaling AS with EU. Make sense? Although I am looking at what's in the "Continent" field as shown by the program and not looking at the database. I did however take a look at the contacts table with Beekeeper Studio and still only see 2 null values there also (same 2 QSO) All other continent fileds look ok.

?

73 Phill C21TS

On Feb 23, 2025, at 3:53?AM, ok1mlg via groups.io <ok1mlg@...> wrote:

Hi Phill,

The behavior you describe is quite strange.

Would it be possible to send me your db file directly to my private email ? You will probably have to zip it or send me a temporary link to this file. Don't worry, no passwords are stored here.

Regards

Ladislav

ne 23. 2. 2025 v?9:54 odes¨ªlatel Phill Hardstaff via <phill=[email protected]> napsal:

Hi Michael, I'm not so sure, if I sort by continent, I only have 2 QSO with no continent (D1 calls) Also in the first screen shot it is saying I have no AS contacts at all, but the total number of contacts is right (or very close to total QSO 85K) However in the second screen shot for 15 meters it is saying I have 7K AS QSO? yet zero in the first. So in the first screenshot it is totaling AS with EU. Make sense? Although I am looking at what's in the "Continent" field as shown by the program and not looking at the database. I did however take a look at the contacts table with Beekeeper Studio and still only see 2 null values there also (same 2 QSO) All other continent fileds look ok.

?

73 Phill C21TS

Here is for my log:

Here is the SQL Query from db browser:

Here is what it looks like with the change I made in code:

I tried to create a user filter to find them in QLog and couldn?€?t.? I just used if CONT not equal toe AF, AS etc.? It just would show the MM contacts in the ?€????€? Group.? I needed to do the SQL Query to find them.? Here is the ADI I imported that created the NULL values for a couple of the contacts.

With the first NULL entry it shifts the columns over when the chart is generated.? I couldn?€?t filter to find the entries in QLog. ?

Michael, AA5SH

On Feb 23, 2025, at 3:53?€?AM, ok1mlg via <ok1mlg=[email protected]> wrote:

Hi Phill,

The behavior you describe is quite strange.

Would it be possible to send me your db file directly to my private email ? You will probably have to zip it or send me a temporary link to this file. Don't worry, no passwords are stored here.

Regards

Ladislav

ne 23. 2. 2025 v?9:54 odes??latel Phill Hardstaff via <phill=[email protected]> napsal:

Hi Michael, I'm not so sure, if I sort by continent, I only have 2 QSO with no continent (D1 calls) Also in the first screen shot it is saying I have no AS contacts at all, but the total number of contacts is right (or very close to total QSO 85K) However in the second screen shot for 15 meters it is saying I have 7K AS QSO? yet zero in the first. So in the first screenshot it is totaling AS with EU. Make sense? Although I am looking at what's in the "Continent" field as shown by the program and not looking at the database. I did however take a look at the contacts table with Beekeeper Studio and still only see 2 null values there also (same 2 QSO) All other continent fileds look ok.

?

73 Phill C21TS