US- CQ Worked all Counties

Moderator: OE6CLD

kc9lox
Novice Class
Posts: 27
Joined: 26 May 2014, 14:40
Contact:

US- CQ Worked all Counties

Post by kc9lox »

Hello All,

I have a database of 1500 logged QSO's. Today I decided I had a interest in working on my CQ worked all counties. Is there a way to mass update to the award tab and show on the awards page listing? I have not figured out a way to do this without going into each and every qso and manually do it. Hope there is some help for me.

Todd-KC9LOX
User avatar
G4POP
Log4OM Alpha Team
Posts: 10748
Joined: 21 Jan 2013, 14:55
Location: Burnham on Crouch, Essex UK

Re: US- CQ Worked all Counties

Post by G4POP »

Hi Todd and anyone else that wants to update the US Counties award

Lele spent a lot of time devising 4 separate update quries which will update the QSO Awars field in Log4om using the data contained in the normal state and county fields.

Attached is a step by step 'how to' tutorial but if any user does not feel confident in doing this then I will do it for them

.
.
.
Attachments
Updating the US Counties award.zip
(40.01 KiB) Downloaded 420 times
73 Terry G4POP
kc9lox
Novice Class
Posts: 27
Joined: 26 May 2014, 14:40
Contact:

Re: US- CQ Worked all Counties

Post by kc9lox »

Thank you for the instructions Terry.

Is there a certain format that the counties field has to be in. I am seeing that I have some with the state abbreviation and then county, example such as WI,MONROE and some with just MONROE in the county field. What is the correct format for this?

Thanks again for the assistance in this.
Todd- KC9LOX
User avatar
G4POP
Log4OM Alpha Team
Posts: 10748
Joined: 21 Jan 2013, 14:55
Location: Burnham on Crouch, Essex UK

Re: US- CQ Worked all Counties

Post by G4POP »

The queries can accept a variety of conditions so the AZ, Maricopa or just Maricopa in a variety of cases are ok but you might like to do updates for any blank state or county fields
73 Terry G4POP
kc9lox
Novice Class
Posts: 27
Joined: 26 May 2014, 14:40
Contact:

Re: US- CQ Worked all Counties

Post by kc9lox »

Terry,

Can you re post the zip file with the instructions for updating the Worked All Counties. I have to redo my log4om log due to a file corruption. Seems the file is in the posts above, but my computer is showing as invalid. Thank you.

Todd-KC9LOX
User avatar
G4POP
Log4OM Alpha Team
Posts: 10748
Joined: 21 Jan 2013, 14:55
Location: Burnham on Crouch, Essex UK

Re: US- CQ Worked all Counties

Post by G4POP »

Here it is again, it seems when we moved forum servers many files got corrupted
.
.
Updating the US Counties award.zip
(40.17 KiB) Downloaded 422 times
73 Terry G4POP
kc9lox
Novice Class
Posts: 27
Joined: 26 May 2014, 14:40
Contact:

Re: US- CQ Worked all Counties

Post by kc9lox »

Terry,

Can I send you my log? I for some reason can not get the instructions to play nice and I'm unable to get my counties correctly done.
Could use some help on this one.

Thank you,
Todd-KC9LOX
User avatar
G4POP
Log4OM Alpha Team
Posts: 10748
Joined: 21 Jan 2013, 14:55
Location: Burnham on Crouch, Essex UK

Re: US- CQ Worked all Counties

Post by G4POP »

kc9lox wrote:Terry,

Can I send you my log? I for some reason can not get the instructions to play nice and I'm unable to get my counties correctly done.
Could use some help on this one.

Thank you,
Todd-KC9LOX
OK
73 Terry G4POP
kc9lox
Novice Class
Posts: 27
Joined: 26 May 2014, 14:40
Contact:

Re: US- CQ Worked all Counties

Post by kc9lox »

Terry,

Can I get a email address to send. And what file would you like sent?

Thanks again,

Todd-KC9LOX
User avatar
G4POP
Log4OM Alpha Team
Posts: 10748
Joined: 21 Jan 2013, 14:55
Location: Burnham on Crouch, Essex UK

Re: US- CQ Worked all Counties

Post by G4POP »

kc9lox wrote:Terry,

Can I get a email address to send. And what file would you like sent?

Thanks again,

Todd-KC9LOX
My email address is on QRZ.com and it's the SQLite database file
73 Terry G4POP
Locked