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 » 22 Mar 2015, 00:40

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
Moderator
Posts: 5770
Joined: 21 Jan 2013, 14:55
Location: Burnham on Crouch, Essex UK

Re: US- CQ Worked all Counties

Post by G4POP » 23 Mar 2015, 17:48

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 133 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 » 24 Mar 2015, 01:45

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
Moderator
Posts: 5770
Joined: 21 Jan 2013, 14:55
Location: Burnham on Crouch, Essex UK

Re: US- CQ Worked all Counties

Post by G4POP » 24 Mar 2015, 06:11

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 » 29 May 2015, 01:01

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
Moderator
Posts: 5770
Joined: 21 Jan 2013, 14:55
Location: Burnham on Crouch, Essex UK

Re: US- CQ Worked all Counties

Post by G4POP » 29 May 2015, 06:24

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 137 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 » 29 May 2015, 22:18

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
Moderator
Posts: 5770
Joined: 21 Jan 2013, 14:55
Location: Burnham on Crouch, Essex UK

Re: US- CQ Worked all Counties

Post by G4POP » 30 May 2015, 06:06

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 » 01 Jun 2015, 03:31

Terry,

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

Thanks again,

Todd-KC9LOX

User avatar
G4POP
Moderator
Posts: 5770
Joined: 21 Jan 2013, 14:55
Location: Burnham on Crouch, Essex UK

Re: US- CQ Worked all Counties

Post by G4POP » 01 Jun 2015, 04:37

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

Post Reply