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

Notification

Icon
Error

Builk database change using a selection
WD4ASP
#1 Posted : Wednesday, February 2, 2022 8:31:49 PM(UTC)
Rank: Advanced Member

Groups: Registered
Posts: 50
Man
Location: Manassas, Va

Thanks: 1 times
Was thanked: 10 time(s) in 9 post(s)
I am getting ready to print out QSL labels for the first time and would like PSE or TNX to print out on the contact line. It appears in order to get PSE to print out, the QSL_RCVD field needs to have an R in it. Likewise QSL_RCVD needs to have an 'F' in it for TNX.

What I would like to do, using the selection that is being use to select the QSOs for labels, is use that same selection to set the QSO_RCVD field to 'R'. I would set the QSL_RCVD field to 'F' prior to the label selection.

Below is an example selection statement.
LOTW_RCVD<>'F' AND (MODE='SSB' or mode='USB' or mode='LSB') AND QSO_DATE>={^2000-01-01} AND NOT EMPTY(VIA) AND QSL_RCVD<>'F'

Is there a way to do this automagically or does it need to be done manually.

Thanks,

Fred

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 : Thursday, February 3, 2022 4:52:32 PM(UTC)
admin

Rank: Administration

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

Thanks: 969 times
Was thanked: 484 time(s) in 399 post(s)
Hi--

So do I understand correctly that you want to change some QSL_RCVD fields en masse?

Your select statement looks good. In English, No QSL or LOTW QSL Rcvd, QSO DATE in this millenium, VIA is not blank, and MODE is sideband.

MAKE A BACKUP!!!

Go to tools/advanced/database commands. Type (or copy and paste)

USE LOG

REPLACE QSL_RCVD WITH "R" FOR LOTW_RCVD<>'F' AND (MODE='SSB' or mode='USB' or mode='LSB') AND QSO_DATE>={^2000-01-01} AND NOT EMPTY(VIA) AND QSL_RCVD<>'F'

There is a video here:
https://youtu.be/5d5gyJVFQEs

Pse subscribe to our Youtube channel while you are there.

Tnx/73,

Dennis WN4AZY
WD4ASP
#3 Posted : Thursday, February 3, 2022 8:05:51 PM(UTC)
Rank: Advanced Member

Groups: Registered
Posts: 50
Man
Location: Manassas, Va

Thanks: 1 times
Was thanked: 10 time(s) in 9 post(s)
Dennis,

Thanks for getting back to me so quickly. I tried to use the Database files->Mass change->Replace field contents and pasted in my selection criteria:

LOTW_RCVD<>'F' AND (MODE='SSB' or mode='USB' or mode='LSB') AND QSO_DATE>={^2000-01-01} AND NOT EMPTY(VIA) AND QSL_RCVD<>'F'

However there appears to be a length limit because only the following got pasted in:

LOTW_RCVD<>'F' AND (MODE='SSB' OR MODE='USB' OR MODE='LSB') AND QSO_DATE>={^2000-01-01} AND NOT EMPTY(VIA) AND QSL_RCVD<

This is 120 bytes and I need at least 124.

I wanted to use the Replace field contents so I could verify the number of records that would be changed and also look at them like in the video.

Thanks,

Fred
1 user thanked WD4ASP for this useful post.
WN4AZY on 2/6/2022(UTC)
WN4AZY
#4 Posted : Sunday, February 6, 2022 9:11:52 PM(UTC)
admin

Rank: Administration

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

Thanks: 969 times
Was thanked: 484 time(s) in 399 post(s)
Ok, I will increase the size of this field in the next update.

In the meantime, just use the command box as per my first response to this thread.

Let me know.

Tnx & 73,

Dennis WN4AZY
WD4ASP
#5 Posted : Tuesday, February 8, 2022 11:22:50 PM(UTC)
Rank: Advanced Member

Groups: Registered
Posts: 50
Man
Location: Manassas, Va

Thanks: 1 times
Was thanked: 10 time(s) in 9 post(s)
Dennis,

Followed your suggestions and they worked like a champ.

Thanks,

Fred
1 user thanked WD4ASP for this useful post.
WN4AZY on 2/9/2022(UTC)
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.025 seconds.