Rank: Member
Groups: Registered
Posts: 19
Location: Hudson, NY
Thanks: 8 times
Was thanked: 1 time(s) in 1 post(s)
|
Is there a way to change the status of dozens of qsl's at once. When I make a contact I select "R" for request in the qsl sent box. I also upload the qso's to lotw. If I receive a confirmed qso via lotw, then I have no need to send a paper qsl and would like to change the qsl request to "x" not needed. Currently I do one qso at a time, is there a way to complete this step with all the qso's that meet this criteria?
Tnx
Kevin
KM2E
|
|
|
|
|
|
Note: We receive a commission from Amazon when you purchase via this link. It does not affect your cost. Thank you!
|
|
|
Rank: Administration
Groups: Administrators, Beta Testers Posts: 3,097  Location: Auburn, GA Thanks: 998 times
Was thanked: 497 time(s) in 412 post(s)
|
Sure. LOGic has a mass-change feature.
So you want to change QSL_SENT from R (Requested) to blank if LoTW_RCVD=F (fulfilled)?
Make a backup.
Go to tools/advanced/database commands. Type
USE LOG
REPLACE QSL_SENT WITH "" FOR LOTW_RCVD="F"
There are menu options to do all this, but this is the easy way when it comes to explaining how to do it hihi.
Tnx & 73,
Dennis WN4AZY
|
|
|
|
|
|
Rank: Administration
Groups: Administrators, Beta Testers Posts: 3,097 Location: Auburn, GA Thanks: 998 times
Was thanked: 497 time(s) in 412 post(s)
|
Ok!
Click the Open icon on the status bar at the bottom of the Database Commands form. A yellow folder with an arrow. Hunt for LOG.DBF. It is typically in the LOGDATA folder inside the install folder, but can be moved by the user.
Click DATABASE FILES on the top menu bar. Select Mass Change/Replace Field Contents.
REPLACE THIS FIELD is of course QSL_SENT
WITH is just an empty string -- two quotes ""
Click the filter button to the right of REPLACE ONLY WITH. Fill out the filter form as you normally would from the log form if you were looking for LOTW="F". Scroll down to LOTW_RCVD. The OPERATOR is =. The VALUE is F.
Sorry you asked ? :-)
It is pretty self-explanatory -- at any rate easier done than said hihi.
73,
Dennis
|
|
|
|
|
|
Rank: Member
Groups: Registered
Posts: 19
Location: Hudson, NY
Thanks: 8 times
Was thanked: 1 time(s) in 1 post(s)
|
Dennis,
Will this work for all future contacts?
tnx
Kevin
|
|
|
|
|
|
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.
