I changed to iCloud synced logbook. Did a few ADIF import from N1MM. Only a couple hundreds.
Not sure when it happened but all QSO's in the logbook are now duplicated.
Anyway to remove all duplicated records, 60K+ plus of them?
Also how do you backup a iCloud synced logbook? Any rollback functions?
/Conny
N5HC
Duplicated QSO's
Re: Duplicated QSO's
Exported the LogBook from the iCloud. Made a backup.
Ran the following SQL commands on the database:
Seems to have removed the duplicates.
/Conny
Ran the following SQL commands on the database:
DELETE FROM logbook
WHERE id NOT IN
(
SELECT MIN(id)
FROM logbook
GROUP by
[arrlcredit],
[band],
[callsign],
[clublog],
[cnt],
[county],
[cq],
[credits],
[date],
[datetime],
[dxcc],
[dxccadif],
[eqsl],
[iota],
[iotacredits],
[itu],
[locator],
[lotwqsl],
[manager],
[mode],
[name],
[note],
[power],
[prefix],
[qrg],
[qsl],
[qslindate],
[qsloutdate],
[qth],
[rstrx],
[rsttx],
[satmode],
[satname],
[satrxband],
[state],
[time],
[user_1],
[user_2],
[user_3],
[user_4])
Seems to have removed the duplicates.
/Conny
Re: Duplicated QSO's
See Menu-->QSO-->Show dupesAnyway to remove all duplicated records, 60K+ plus of them?
I would backup it as usual ADIF or *.rlog export.Also how do you backup a iCloud synced logbook?
73 and best dx de Tom, DL2RUM