Page 1 of 1

SQlite to MYSql database

Posted: 30 Jan 2022, 09:53
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

Re: SQlite to MYSql database

Posted: 09 Feb 2022, 21:13
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.