US Worked All Counties CQ USA-CA) award - Printable Version +- Swisslog's Forum (https://www.swisslogforwindows.com/forum) +-- Forum: Swisslog version 5.x (https://www.swisslogforwindows.com/forum/forumdisplay.php?fid=3) +--- Forum: General discussion (https://www.swisslogforwindows.com/forum/forumdisplay.php?fid=4) +--- Thread: US Worked All Counties CQ USA-CA) award (/showthread.php?tid=845) Pages:
1
2
|
US Worked All Counties CQ USA-CA) award - JW6VDA - 08-01-2021 After finishing registering all the qsl cards from USA - also including LoTW confirmations - I want to generate a list of contacts as specified here https://cq-amateur-radio.com/cq_awards/cq_usa_ca_awards/cq_usa_ca_awards.html for the application How can I use Swisslog to generate such a list? 73 de Tom JW6VDA RE: US Worked All Counties CQ USA-CA) award - EA3GCV - 08-01-2021 Hello Tom, With Swisslog is possible to create any report you like but this requires skills handling the Power Query generator. I will take a look and I will try to create a query for this award. But please be patient. I will let you know here when I have created one. Best 73 RE: US Worked All Counties CQ USA-CA) award - JW6VDA - 08-01-2021 Thanks a lot. This is definitely not within my skill, so I\ll wait for your input I still have 19,5 kg of cards to process, so i\m not in a hurry! 73 de Tom JW6VDA RE: US Worked All Counties CQ USA-CA) award - EA3GCV - 09-01-2021 Hello Tom, Please find attached a report which automatically selects all QSOs having the US county and confirmed either by QSL card, LoTW or eQSL. Unzip then copy the US Counties.spq file in the QUERIES folder. Opern Swisslog and go to View / Logbook (select view) then load this query and perform the following steps:
RE: US Worked All Counties CQ USA-CA) award - JW6VDA - 24-01-2021 Fantastic, Jordi! I will check this out ASAP. I have another question related to this, and this is in connection with the discussion about HomeQTH: I am well on the way on bringing the existing Swisslog database for JW5E club station up to date by registering all the received qsl cards, a work that was unfortuately dicontinued when the qsl manager JW5NM was SK in 2009. 2000 cards processed, 8000 more to go. Because the bulk of the cards are from USA and Canada, checking the county and compare what the qsl card says, sometimes checking the ZIP code as well, and compare it to a lookup in the QRZ database is pretty tedious. For a lot of the cards received after the year 2000, QRZ provides data that are consistent with the card, but for the older cards I very often have to fill in State (Region) and County (SUBREGION) manually. When the holder of a callsign has moved, e.g. retired and moved to Florida, I have tried to create a new QTH name like for example "Miami, FL" for the new QTH, and e.g. "Flat Rock, MI" for the old stated on the card. Sometimes the holder of the callsign has changed, and I have to fill in all data manually, which is also the case when the callsign no longer exists in QRZ, and the holder apparently is SK. In your opinion, is this a sensible way of handling this, and do you think the situation where one callsign is assigned to several counties will be caught by your report? 73 de Tom RE: US Worked All Counties CQ USA-CA) award - EA3GCV - 24-01-2021 Hello Tom, You don't need to do anything manually. If you are changing any award field, Swislsog will automatically create a new Home QTH with the name of the award reference which has changed to maintain different HomeQTH profiles for the QSO partner. Simply edit the QSO, change the State or County and Swisslog will handle the QTH name field automatically. Best 73 RE: US Worked All Counties CQ USA-CA) award - JW6VDA - 25-01-2021 OK, Thanks! 73 de Tom RE: US Worked All Counties CQ USA-CA) award - JW6VDA - 28-01-2021 I don't find this county in Swisslog's internal lis of countiest. For ZIP code 23321, Chesapeake, VA: VA-PORTSMOUTH CITY 73 de Tom RE: US Worked All Counties CQ USA-CA) award - G3WPF - 28-01-2021 (28-01-2021, 09:44 AM)JW6VDA Wrote: I don't find this county in Swisslog's internal lis of countiest. Tom. I think you will find that Chesapeake and Portsmouth are Independent Cities. They both count for Isle of Wight county for USA-CA. Reg RE: US Worked All Counties CQ USA-CA) award - JW6VDA - 30-01-2021 Ok, Thanks Reg. I have been looking for a complete list of US Counties vs ZIP codes in a tabular form, but so far I haven't been able to find one. My incompetence, I suppose... 73 de Tom |