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

Notification

Icon
Error
Bulk QSL request status change
Options View
Previous Topic Next Topic
N5XZ
#1 Posted : Wednesday, August 28, 2024 9:29:24 AM(UTC)
Rank: Advanced Member

Groups: Registered, Beta Testers
Posts: 406
Location: Richmond, TX

Thanks: 35 times
Was thanked: 57 time(s) in 54 post(s)
I would like to change the 'QSL Sent' and 'QSL Rcvd' status from 'R' to [Blank] for an entire year at a time <and> if if the 'LOTW Rcvd' is = to 'F'

Can someone help me write an expression to do that?

Thanks,
73, Allen N5XZ
Back to top
Sponsor
Note: We receive a commission from Amazon when you purchase via this link. It does not affect your cost. Thank you!
Back to top  
N5XZ
#2 Posted : Tuesday, September 10, 2024 10:15:11 AM(UTC)
Rank: Advanced Member

Groups: Registered, Beta Testers
Posts: 406
Location: Richmond, TX

Thanks: 35 times
Was thanked: 57 time(s) in 54 post(s)
Would appreciate a response from Dennis
73, Allen N5XZ
Back to top
K8ZM
#3 Posted : Saturday, September 14, 2024 11:12:53 PM(UTC)
bwilliams

Rank: Advanced Member

Groups: Registered
Posts: 523
Location: Mentor, OH

Thanks: 122 times
Was thanked: 185 time(s) in 166 post(s)
Hi Allen,

There is an excellent YouTube video on how to do database mass changes Dennis did sometime ago. Take a look as it has a very easy from tool to create the commands (formulas) to make changes.

Database Mass Change

If you need some guidance or example commands/forumlas I can try to help.

73, Brad K8ZM
Back to top
WWW
 |  Edit by user
1 user thanked K8ZM for this useful post.
WN4AZY on 9/24/2024(UTC)
WN4AZY
#4 Posted : Tuesday, September 24, 2024 4:42:02 PM(UTC)
admin

Rank: Administration

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

Thanks: 997 times
Was thanked: 495 time(s) in 410 post(s)
Sorry for the delay.

OK, something like this:

USE LOG
replace qsl_sent with " " for LOTW_RCVD='F' AND BETWEEN(QSO_DATE,{^2024-01-01},{^2024-12-31})

Modify for previous years and qsl_rcvd

I just filled out the filter form to get this expression BTW.

Tnx & 73,


Dennis WN4AZY
Back to top
WWW
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.021 seconds.