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

Notification

Icon
Error

eQSL and old QSO's
K1VC
#1 Posted : Sunday, February 5, 2017 9:35:36 AM(UTC)
Rank: Advanced Member

Groups: Registered
Posts: 294
Location: CT

Thanks: 9 times
Was thanked: 68 time(s) in 61 post(s)
Now that I have a 'working eQSL' account, what's the best way to go back and place a check mark on all my QSO's for eQSL request (Rcvd and Sent)?

I have so many eQSL's in my account waiting for a confirmation, I don't want to go through each one individually. Some QSO's go back to my novice time (1980's).

I think there is a 'batch' command but I can't remember.

Thanks.
Vin

Sponsor
Note: We receive a commission from Amazon when you purchase via this link. It does not affect your cost. Thank you!
w2zi
#2 Posted : Sunday, February 5, 2017 1:28:40 PM(UTC)
Rank: Advanced Member

Groups: Registered
Posts: 180
Man
Location: Daytona Beach, Florida

Thanks: 48 times
Was thanked: 67 time(s) in 62 post(s)
Vin,
Usual disclaimers about doing a backup first.

Tools > Advanced > Database commands

use log
replace EQSL_SENT with .T. for QSO_DATE<{^1970-01-01}


Modify the date as suits your needs.

73s,
Don
1 user thanked w2zi for this useful post.
WN4AZY on 2/6/2017(UTC)
K1VC
#3 Posted : Monday, February 6, 2017 7:34:10 AM(UTC)
Rank: Advanced Member

Groups: Registered
Posts: 294
Location: CT

Thanks: 9 times
Was thanked: 68 time(s) in 61 post(s)
Thank you Don !
WN4AZY
#4 Posted : Monday, February 6, 2017 9:59:05 AM(UTC)
admin

Rank: Administration

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

Thanks: 997 times
Was thanked: 496 time(s) in 411 post(s)
To put R in QSL_RCVD, just fill out the MASS CHANGE/REPLACE FIELD CONTENTS screen as per the attached screen shot.

This results in the following command:

replace qsl_rcvd with "R" for QSL_RCVD<>' ' AND QSO_DATE>={^1970-01-01}

Ok, this does only QSOs on or after Jan 1 '70. Don's example does only QSOs before Jan 1 '70. Not sure what you want, but you get the idea hihi.

Tnx & 73,

Dennis WN4AZY
File Attachment(s):
Untitled.png (29kb) downloaded 41 time(s).
K1VC
#5 Posted : Monday, February 6, 2017 10:22:12 AM(UTC)
Rank: Advanced Member

Groups: Registered
Posts: 294
Location: CT

Thanks: 9 times
Was thanked: 68 time(s) in 61 post(s)
Hi Dennis,

I'm assuming if there is already an "R", "F", "I" or "X" in the field, it will not change it to "R", right?

Or do I enter "R" in the second box where it says "Replace only if: (blank to replace all)"

Thanks,
Vin
WN4AZY
#6 Posted : Monday, February 6, 2017 1:32:26 PM(UTC)
admin

Rank: Administration

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

Thanks: 997 times
Was thanked: 496 time(s) in 411 post(s)
Quote:
I'm assuming if there is already an "R", "F", "I" or "X" in the field, it will not change it to "R", right?
Right. If there is anything in there other than a blank, ( <> " ") it will not change it.

If you want to do it the hard way, you could do this:
replace qsl_rcvd with "R" for QSL_RCVD<>"R" AND QSL_RCVD<>"F" AND QSL_RCVD<>"I" AND QSL_RCVD<>"X" AND QSO_DATE>={^1970-01-01}


Quote:
Or do I enter "R" in the second box where it says "Replace only if: (blank to replace all)"

You could do this if you want to make it even harder.

replace qsl_rcvd with "R" for QSL_RCVD<>"R" AND QSL_RCVD<>"F" AND QSL_RCVD<>"I" AND QSL_RCVD<>"X" AND QSL_RCVD<>"R" AND QSO_DATE>={^1970-01-01}

But it would just save a little disk activity because it won't rewrite an R where there is already one as the preceding example does.

73,

DH
K1VC
#7 Posted : Monday, February 6, 2017 6:37:11 PM(UTC)
Rank: Advanced Member

Groups: Registered
Posts: 294
Location: CT

Thanks: 9 times
Was thanked: 68 time(s) in 61 post(s)
Worked great...thank you !!!!!

UPDATE: I spoke too soon. The mass change entered "R" for all QSO's, even if there was an "R", "F", "I" or "X" in the field prior to the mass change. Sad

Vin
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.047 seconds.