logo
Welcome Guest! To enable all features please Login or Register.

Notification

Icon
Error

mass deleting
W5GA
#1 Posted : Friday, February 17, 2012 10:04:11 AM(UTC)
Rank: Advanced Member

Groups: Registered
Posts: 395
Location: Missouri

Thanks: 72 times
Was thanked: 118 time(s) in 105 post(s)
Dennis, I have a large batch of duplicate qso's in the log (don't ask how they got there) that the deldupes program will not delete. All of them have a commonality in that (1) they are exact dupes - almost. (2) The calls are the same, as are the date/hour/minute, as in two qso's with W5GA, but some of the data is missing. Won't have freq or RST. (3) All of the bad data are missing the seconds in the time column.

Is there a way to do a mass deletion so that the routine compares the calls, and deletes the ones that are missing the seconds if both show the same date, hour and minute? Going through 12k or so QSO's line by line is hard on the fingers :-)

Thanks!

Doug
73 Doug W5GA
Sponsor
Note: We receive a commission from Amazon when you purchase via this link. It does not affect your cost. Thank you!
WN4AZY
#2 Posted : Sunday, February 19, 2012 11:15:14 AM(UTC)
admin

Rank: Administration

Groups: Administrators, Beta Testers
Posts: 3,097
Man
Location: Auburn, GA

Thanks: 997 times
Was thanked: 497 time(s) in 412 post(s)
From what you describe the utility should work (Be sure to tell it to IGNORE SECONDS).

What about OPERATOR? Is that the same in both?

Tnx & 73,

Dennis WN4AZY
W5GA
#3 Posted : Sunday, February 19, 2012 11:58:08 AM(UTC)
Rank: Advanced Member

Groups: Registered
Posts: 395
Location: Missouri

Thanks: 72 times
Was thanked: 118 time(s) in 105 post(s)
Aha! I think you found the issue....all the dupes have the wrong operator, as well, which must be why deldupes isn't picking up on it.

My log has 5 different operator calls in it, reflecting calls I've held since 1970. Is there a workaround for this?

Thanks!
Doug
73 Doug W5GA
WN4AZY
#4 Posted : Wednesday, February 29, 2012 6:00:58 PM(UTC)
admin

Rank: Administration

Groups: Administrators, Beta Testers
Posts: 3,097
Man
Location: Auburn, GA

Thanks: 997 times
Was thanked: 497 time(s) in 412 post(s)
Sorry for the delay in my response -- I overlooked this message.

Make a backup.

You can mass-change your old operators. Go to tools/advanced/database commands. There are menus to walk you thru all thism but just type these commands:

USE LOG
REPLACE OPERATOR WITH "WN4AZY" FOR OPERATOR="W4AZY "

In this example I am replacing W4AZY (wrong) with WN4AZY (correct)

Tnx & 73,

Dennsi WN4AZY
W5GA
#5 Posted : Thursday, March 1, 2012 5:10:58 AM(UTC)
Rank: Advanced Member

Groups: Registered
Posts: 395
Location: Missouri

Thanks: 72 times
Was thanked: 118 time(s) in 105 post(s)
Dennis, just replacing the operator won't work. Over the years, I've had several different calls. The issue is that many of these qso's are correctly logged with an old call, and the bad dupe has my current call. So, if I change the operator I'll end up with an even bigger mess.

Here's what I've done. I've separated my log into 4 different adif files based on operator. In the W5GA adif file, I've found 1280 bad entries based on using "OPERATOR='W5GA' AND QSO_DATE<={^2005-01-01}" as a report filter. This works because as of that date, I was N6AYW. So, any qso showing that early a date and W5GA as the operator is one of the bad dupes.

Is there a way to use that filter string in database commands, combined with a delete command to get rid of the bad entries?
73 Doug W5GA
WN4AZY
#6 Posted : Thursday, March 1, 2012 9:46:34 AM(UTC)
admin

Rank: Administration

Groups: Administrators, Beta Testers
Posts: 3,097
Man
Location: Auburn, GA

Thanks: 997 times
Was thanked: 497 time(s) in 412 post(s)

USE LOG
DELETE FOR OPERATOR='W5GA' AND QSO_DATE<={^2005-01-01}

Tnx &73,

DH
W5GA
#7 Posted : Thursday, March 1, 2012 8:30:36 PM(UTC)
Rank: Advanced Member

Groups: Registered
Posts: 395
Location: Missouri

Thanks: 72 times
Was thanked: 118 time(s) in 105 post(s)
That's got it, Dennis. Many thanks!
73 Doug W5GA
Users browsing this topic
Guest
Forum Jump  
You cannot post new topics in this forum.
You cannot reply to topics in this forum.
You cannot delete your posts in this forum.
You cannot edit your posts in this forum.
You cannot create polls in this forum.
You cannot vote in polls in this forum.

Powered by YAF 1.9.5.5 | YAF © 2003-2011, Yet Another Forum.NET
This page was generated in 0.038 seconds.