{"id":4071,"date":"2014-01-14T23:22:53","date_gmt":"2014-01-15T04:22:53","guid":{"rendered":"https:\/\/ecngx342.inmotionhosting.com\/~hcraor5\/\/?p=4071"},"modified":"2014-01-14T23:22:53","modified_gmt":"2014-01-15T04:22:53","slug":"helpful-dxlabs-tip-2156-572","status":"publish","type":"post","link":"https:\/\/hcra.org\/?p=4071","title":{"rendered":"Helpful DXlabs Tip #2156.572"},"content":{"rendered":"<p>Want to play in the ARRl Centennial QSO Party and work the W1AW\/? stations? Every week they are in two different states. It&#8217;s easy using SpotCollettor.<\/p>\n<p>Simply program one of the eight SQL buttons to do the hard work for you. Never done it before, here&#8217;s an example using the &#8220;SQL 1&#8221; button:<\/p>\n<p>1. Hold down the &lt;CNTL&gt; key, then left click the button labeled SQL 1 in the SpotCollector screen.<br \/>\n2. A new window will open called SpotCollector SQL Filter<br \/>\n3. On line 1, in the &#8216;Caption&#8217; field type W1AW (or whatever you want the button to say that makes sense to you).<br \/>\n4. In the &#8220;SQL&#8221; Field enter, Callsign LIKE&#8217;W1AW\/?&#8217; (The ? after the slash means you will get ANY listing of W1AW\/x. Tonight \/3 and \/0 are listed.<br \/>\n5. Close the SpotCollector SQL Filter Window<\/p>\n<p>Now in the SpotCollector main window click the new W1AW button you created. Yahoo, if you&#8217;ve done it right you will be rewarded with a listing of all W1AW\/x stations SpotCollector has heard. That&#8217;s the easy part, now go work them!<\/p>\n<p>Be careful, those are single quotes -&#8216;- before the W in W1AW and after the question mark, not double quotes -&#8220;-. If you make a mistake don&#8217;t fret, simply go back to the SQL window and fix your expression. Want to try some other ones, click on the &#8216;Help&#8217; button in SpotCollector. When the help screen opens scroll down and click on the\u00a0 &#8220;Filtering with SQL Expressions&#8221; link. Dave has given us a lot of examples to try.<\/p>\n<p>While you&#8217;re doing this take a moment to marvel at the power of DXlabs Suite, the fact that it&#8217;s available to everyone for free and the tremendous support the author Dave\/AA6YQ provides. If you like it, drop him a note of thanks or even better post a positive review on eHam.<\/p>\n<p>Haven&#8217;t tried DXlabs? Here ya go, download it and have fun:<\/p>\n<p><a href=\"http:\/\/www.dxlabsuite.com\/\">http:\/\/www.dxlabsuite.com\/<\/a><\/p>\n<p>Only 48more states to go&#8230;.<\/p>\n<p>Jim\/KK1W<\/p>\n","protected":false},"excerpt":{"rendered":"<p>Want to play in the ARRl Centennial QSO Party and work the W1AW\/? stations? Every week they are in two different states. It&#8217;s easy using SpotCollettor. Simply program one of the eight SQL buttons to do the hard work for you. Never done it before, here&#8217;s an example using the &#8220;SQL 1&#8221; button: 1. Hold [&hellip;]<\/p>\n","protected":false},"author":2,"featured_media":0,"comment_status":"open","ping_status":"open","sticky":false,"template":"","format":"standard","meta":{"footnotes":""},"categories":[8],"tags":[76,136,223,385],"class_list":["post-4071","post","type-post","status-publish","format-standard","hentry","category-contests","tag-arrl","tag-dxlabs","tag-logging","tag-w1aw"],"_links":{"self":[{"href":"https:\/\/hcra.org\/index.php?rest_route=\/wp\/v2\/posts\/4071","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/hcra.org\/index.php?rest_route=\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/hcra.org\/index.php?rest_route=\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/hcra.org\/index.php?rest_route=\/wp\/v2\/users\/2"}],"replies":[{"embeddable":true,"href":"https:\/\/hcra.org\/index.php?rest_route=%2Fwp%2Fv2%2Fcomments&post=4071"}],"version-history":[{"count":0,"href":"https:\/\/hcra.org\/index.php?rest_route=\/wp\/v2\/posts\/4071\/revisions"}],"wp:attachment":[{"href":"https:\/\/hcra.org\/index.php?rest_route=%2Fwp%2Fv2%2Fmedia&parent=4071"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/hcra.org\/index.php?rest_route=%2Fwp%2Fv2%2Fcategories&post=4071"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/hcra.org\/index.php?rest_route=%2Fwp%2Fv2%2Ftags&post=4071"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}