Hi, How do I go about deleting duplicate records from my log? I have uploaded a log from another logging program and there are now many duplicates in my CQRLog. Can't see an easy way in the manual.
Regards and Happy New Year.
Grant VK4JAZ
Tue, 2012-01-03 23:30
#1
Deleting duplicates
Hello Grant.
Open the SQL-console (by first opening QSO-list CTRL-O, menu-filter,sql-console)
Enter the query:
select callsign,qsodate,time_on,band,mode,count(*) Number_of_records from cqrlog_main group by qsodate,time_on,callsign,band,mode having count(*)> 1
and execute it.
This will show You the records where the callsign,qso-date/time/band/mode are the same (dupes).
You can then sort Your log, or filter each callsign, and manually delete the lines needed.
It is possible to make a script delete dupes, but I will let the author do it his way in a later version.
73 de Børge/LA4VGA
ERROR::Error execting query: Cannot truncate a table referenced in a foreign key constraint (`cqrlog001`.`log_changes`, CONSTRAINT `log_changes_ibfk_1` FOREIGN KEY (`id_cqrlog_main`) REFERENCES `cqrlog001`.`cqrlog_main` (`id_cqrlog_main`))
I have not managed to try a newer version owing to there not being one for my distribution (Mint 13). Will I have to build a binary? The downloadable binary for 1.9.0 has failed dependencies on Mint 13.
Many thanks
Tim G0ETP.
any help on dupes ????
ERROR: : Error executing query: Cannot truncate a table referenced in a foreign key constraint (`cqrlog001`.`log_changes`, CONSTRAINT `log_changes_ibfk_1` FOREIGN KEY (`id_cqrlog_main`) REFERENCES `cqrlog001`.`cqrlog_main` (`id_cqrlog_main`))
Frank
KF4CQ
Same notice as KF4CQ. 1.9.0 CQRLog in use.
Hi,
please open QSO list window, go to Online logs menu and click to Mark QSO as uploaded to all logs. That should help. It's a bug, there shouldn't be this error message.
73 Petr
--
http://HamQTH.com/ok2cqr
https://ok2cqr.com