www.dl2rum.de

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

Exported the LogBook from the iCloud. Made a backup.
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

Anyway to remove all duplicated records, 60K+ plus of them?

See Menu-->QSO-->Show dupes

Also how do you backup a iCloud synced logbook?

I would backup it as usual ADIF or *.rlog export.