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
US- CQ Worked all Counties
Moderator: OE6CLD
- G4POP
- Log4OM Alpha Team
- Posts: 10748
- Joined: 21 Jan 2013, 14:55
- Location: Burnham on Crouch, Essex UK
Re: US- CQ Worked all Counties
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
.
.
.
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
Re: US- CQ Worked all Counties
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
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
- G4POP
- Log4OM Alpha Team
- Posts: 10748
- Joined: 21 Jan 2013, 14:55
- Location: Burnham on Crouch, Essex UK
Re: US- CQ Worked all Counties
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
Re: US- CQ Worked all Counties
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
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
- G4POP
- Log4OM Alpha Team
- Posts: 10748
- Joined: 21 Jan 2013, 14:55
- Location: Burnham on Crouch, Essex UK
Re: US- CQ Worked all Counties
Here it is again, it seems when we moved forum servers many files got corrupted
.
.
.
.
73 Terry G4POP
Re: US- CQ Worked all Counties
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
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
- G4POP
- Log4OM Alpha Team
- Posts: 10748
- Joined: 21 Jan 2013, 14:55
- Location: Burnham on Crouch, Essex UK
Re: US- CQ Worked all Counties
OKkc9lox 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
73 Terry G4POP
Re: US- CQ Worked all Counties
Terry,
Can I get a email address to send. And what file would you like sent?
Thanks again,
Todd-KC9LOX
Can I get a email address to send. And what file would you like sent?
Thanks again,
Todd-KC9LOX
- G4POP
- Log4OM Alpha Team
- Posts: 10748
- Joined: 21 Jan 2013, 14:55
- Location: Burnham on Crouch, Essex UK
Re: US- CQ Worked all Counties
My email address is on QRZ.com and it's the SQLite database filekc9lox wrote:Terry,
Can I get a email address to send. And what file would you like sent?
Thanks again,
Todd-KC9LOX
73 Terry G4POP