"Mass repairs"

Need help? - Post here and we will find a solution for you.
Post Reply
User avatar
K0HB
Old Man
Posts: 112
Joined: 12 Jun 2013, 21:32

"Mass repairs"

Post by K0HB » 20 Aug 2013, 04:25

My log, about 60,000 contacts, was mostly generated in other logging programs, and imported into Log4OM as an ADIF when I adopted this as my new logging program.

All of those old QSO's had been sent to LoTW prior to import to Log4OM, but on import, the LoTW Sent Status seems to have been set to "R - requested". Now Log4OM wants to send ALL those Q's to LoTW. Of course they'll be duplicates, rejected by tQSL, and a major pain.

Is there a way to set all those old QSO's , in bulk, so the LoTW Sent Status is "Y - yes"?

Please? Pretty please with sugar on it?
DE Hans, KØHB
--
"Just a boy and his radio"
--
Superstition Trails ----> http://OldSlowHans.com

User avatar
DF5WW
Log4OM Alpha Team
Posts: 989
Joined: 02 May 2013, 10:49
Location: Höhr-Grenzhausen, Rhineland Palatinate, Germany
Contact:

Re: "Mass repairs"

Post by DF5WW » 20 Aug 2013, 05:18

Hi Hans,

a "Mass repair" is possible via the massive bulk editor. But first of all make a backup and second, don´t change all 60000 + QSO at once.

Open the Log4OM "QSO Archive"
Check the Box "Enable update"
Open "Search parameters" at the bottom of the "QSO Archive" - Window
Set the search string to "LOTW Sent status" =(equals) and write R in the Value field. Then hit the green plus button
Klick on the green sign left of the red X and close Search Parameters Window

Back on the QSO Archive Window hit search. 5000 QSO will be show´n. Select all. Click at "Field Update"
In the next window set "Field to update" to "LotW Sent status" and write Y in the Value field. Then click "Update" and first 5000 QSO´s will be changed.

Repeat this steps for the next block of 5000 .........

I like the work with the massive bulk editor, it helps to save time ;) ;)
73´s .. Juergen ... RedPitaya SDR 5 W, 20 mtr. indoor wireloop feeded with homemade ladderline (600 Ohms) ...

User avatar
IW3HMH
Site Admin
Posts: 2264
Joined: 21 Jan 2013, 15:20
Location: Quarto d'Altino - Venezia (ITA)
Contact:

Re: "Mass repairs"

Post by IW3HMH » 20 Aug 2013, 12:25

If you have SQL skills you can directly patch the database using the "SQL Update" function in the massive update.
The table is "LOG" and the field is "LOTWQSLSENT"

Something like:

Code: Select all

update log set lotwqslsent = 'Y'
in the SQL query field should do the trick in a second.
Make a backup, SQL queries directly on database are potentially Dangerous

73
Daniele
Daniele Pistollato - IW3HMH

User avatar
K0HB
Old Man
Posts: 112
Joined: 12 Jun 2013, 21:32

Re: "Mass repairs"

Post by K0HB » 20 Aug 2013, 18:26

Thanks.......!

No SQL skill, so using the inbuilt wizard.
DE Hans, KØHB
--
"Just a boy and his radio"
--
Superstition Trails ----> http://OldSlowHans.com

User avatar
DF5WW
Log4OM Alpha Team
Posts: 989
Joined: 02 May 2013, 10:49
Location: Höhr-Grenzhausen, Rhineland Palatinate, Germany
Contact:

Re: "Mass repairs"

Post by DF5WW » 23 Aug 2013, 20:39

Has the "wizzard" worked ?? ;) ;)

Think other users are like to know ;) ;)
73´s .. Juergen ... RedPitaya SDR 5 W, 20 mtr. indoor wireloop feeded with homemade ladderline (600 Ohms) ...

User avatar
IW3HMH
Site Admin
Posts: 2264
Joined: 21 Jan 2013, 15:20
Location: Quarto d'Altino - Venezia (ITA)
Contact:

Re: "Mass repairs"

Post by IW3HMH » 24 Aug 2013, 09:57

by the way, the solution proposed is universal, so i don't have added anything, but to be complete, there is another fast way to update QSL status (lotw, paper, eqsl) from QSL Manager.
Simply select all QSO you need to fix and then, in the proper screen (lotw in this case) set the date (fictious), the status and press the "disk" button to save.

73
Daniele IW3HMH
Daniele Pistollato - IW3HMH

Post Reply