SQlite to MYSql database

Post Reply
User avatar
PA7RA
Advanced Class
Posts: 45
Joined: 30 Jul 2018, 17:15
Location: Bergen op Zoom

SQlite to MYSql database

Post by PA7RA »

Good morning,

Today I went from SQLITE to MYSQL database in LOG4OM.
That worked, only when I look at my DXCC score I see that not all Grandet qso's are more grandet after I downloaded them LOTW.
And so too with the IOTA score.
So I went back to SQLite because the score is correct there.
Is that normal when you switch to MySQL from SQLite?
Or did I do something wrong during the import of the old adif log?
Greeting
Rien, PA7RA
User avatar
NN7D
Log4OM Alpha Team
Posts: 816
Joined: 19 Feb 2014, 19:44

Re: SQlite to MYSql database

Post by NN7D »

Rien,

I use MySQL DB and have no issues with Granted. Something apparently went astray with ADIF import.

To correct, open QSL Manager, select LotW, Search, then click Download confirmation. Select Date range to include all your records in LotW (way back), then click Retrieve Credited SQL's. This will take a while, but should update your Granted status on all QSO's. This is provided you have told ARRL to join your previous paper QSL granted records to your LotW data.

Let us know how this goes. 73.
Doug - NN7D
Gig Harbor, WA, USA
Post Reply