[Dx4win] Search For QSOs with Deleted Entities
Hi All, Is there a way to search/filter a log for QSOs with deleted entities? I can see those QSOs in the DXCC report with Deleted selected but I'd like to see them as part of a database query. Thanks. 73, Kris N5KM __ DX4WIN mailing list Home: http://mailman.qth.net/mailman/listinfo/dx4win Help: http://mailman.qth.net/mmfaq.htm Post: mailto:DX4WIN@mailman.qth.net This list hosted by: http://www.qsl.net Please help support this email list: http://www.qsl.net/donate.html
Re: [Dx4win] Search For QSOs with Deleted Entities
On Thu, Jul 21, 2022 at 3:28 PM asked: > Is there a way to search/filter a log for QSOs with deleted entities? > I can see those QSOs in the DXCC report with Deleted selected but > I'd like to see them as part of a database query. Thanks. Not that I know of. Maybe in a future release (?), Paul could add a field to the Logbook window to indicate whether the QSO is with a deleted DXCC entity. I realize that doesn't solve your problem today. -- Jim Reisert AD1C, , https://ad1c.us __ DX4WIN mailing list Home: http://mailman.qth.net/mailman/listinfo/dx4win Help: http://mailman.qth.net/mmfaq.htm Post: mailto:DX4WIN@mailman.qth.net This list hosted by: http://www.qsl.net Please help support this email list: http://www.qsl.net/donate.html
Re: [Dx4win] Search For QSOs with Deleted Entities
Hi Kris, I think I have a way to find QSOs with deleted countries but it involves some work. The following involves many steps but once you do a section once, repeating it for other prefixes should be faster. Basically, you get a list of deleted DXCC countries that you have worked (Reports -> check "include deleted" -> OK). Then for each deleted country (indicated by a D in the column with "D" in the heading) that you have worked, note each "prefix". For EACH of those prefixes, do the following: 1) While on the QSO screen 2) Click Filter 3) Click "Cancel filter" 4) Hit F8 5) Hit the TAB key (or click in the Prefix box) 6) Enter a prefix you want to search for 7) Hit Enter 8) Click File 9) Click Import/Export 10) Click the highest DX4WIN format (Ex. DX4WIN8) listed 11) Click File 12) Click Export 13) Enter a file name for the .DXQ/.DXN file to be created (I used the prefix with any slashes changed to dashes -- OK/D would have filename OK-D) 14) Click SAVE 15) Click YES when it prompts with "Filter active, use it for export?" 16) For each prefix you extract, note the count of how many QSOs were exported. This will help you verify counts later -- after you make a log from all the exported files. 17) Click OK (after the export is done) 18) Click File 19) Click Exit Once you have created a export file (.DXQ/.DXN) for each of the deleted prefixes in your log: 20) Click File 21) Click NEW (create a NEW DX4WIN log file) 22) Navigate to the directory where the Export files were created 23) Specify the name of the log file that will contain all your exported data For each prefix file that you exported above, do the following: 24) Click File 25) Click Import/Export 26) Click the DX4WIN export version number that you used in step 3 above 27) Click File (on "Import / Export Filters" screen) 28) Click Import 29) Enter the export file name (Prefix?) that you used earlier 30) Click Open 31) On "Options for duplicate QSOs" screen, click OK 32) Click OK (after the import summary) 33) Click File 34) Click Exit If you have more prefixes to Import, go to step 24 Once you have Imported all your Prefix files: 35) Click File 36) Click SAVE (to save this log to disk) 37) Click File 38) Click Info In theory, the "Nr QSOs" value should equal the sum of the Imported QSOs counts in step 16 above One caveat I am aware of (might be others that my test file didn't find), I entered prefix of KZ5 which resulted in 60 QSOs. However, only ONE of the 60 QSOs actually had a prefix of KZ5 -- all the others had prefix of "K". To catch this situation, I suggest after you do an "export" of a prefix, verify that all selected QSOs have the "prefix" that you were after. Sorry this was so long. If anything doesn't make sense, contact me and I'll see what I can do to make it clearer. 73, Lee N7NU > On 07/21/2022 2:28 PM N5KM - Kris wrote: > > > Hi All, > > Is there a way to search/filter a log for QSOs with deleted entities? > I can see those QSOs in the DXCC report with Deleted selected but > I'd like to see them as part of a database query. Thanks. > > 73, > > Kris N5KM > __ > DX4WIN mailing list > Home: http://mailman.qth.net/mailman/listinfo/dx4win > Help: http://mailman.qth.net/mmfaq.htm > Post: mailto:DX4WIN@mailman.qth.net > > This list hosted by: http://www.qsl.net > Please help support this email list: http://www.qsl.net/donate.html __ DX4WIN mailing list Home: http://mailman.qth.net/mailman/listinfo/dx4win Help: http://mailman.qth.net/mmfaq.htm Post: mailto:DX4WIN@mailman.qth.net This list hosted by: http://www.qsl.net Please help support this email list: http://www.qsl.net/donate.html
Re: [Dx4win] Search For QSOs with Deleted Entities
That's quite the process, but it will work. Two comments: 1 If you do "Listing Worked" instead of just "Listing", it eliminates all the blank spaces and is a little easier to read. 2. If you type "KZ5" into the Prefix box, that filter should ONLY list Canal Zone stations. Any others that appear in that search are logged improperly. (KZ5 was my first deleted country) 73, Mike Cizek W0VTT -Original Message- From: dx4win-boun...@mailman.qth.net On Behalf Of LEE HALLIN Sent: Monday, 1 August, 2022 01:57 To: N5KM - Kris ; dx4win@mailman.qth.net Subject: Re: [Dx4win] Search For QSOs with Deleted Entities Hi Kris, I think I have a way to find QSOs with deleted countries but it involves some work. The following involves many steps but once you do a section once, repeating it for other prefixes should be faster. Basically, you get a list of deleted DXCC countries that you have worked (Reports -> check "include deleted" -> OK). Then for each deleted country (indicated by a D in the column with "D" in the heading) that you have worked, note each "prefix". For EACH of those prefixes, do the following: 1) While on the QSO screen 2) Click Filter 3) Click "Cancel filter" 4) Hit F8 5) Hit the TAB key (or click in the Prefix box) 6) Enter a prefix you want to search for 7) Hit Enter 8) Click File 9) Click Import/Export 10) Click the highest DX4WIN format (Ex. DX4WIN8) listed 11) Click File 12) Click Export 13) Enter a file name for the .DXQ/.DXN file to be created (I used the prefix with any slashes changed to dashes -- OK/D would have filename OK-D) 14) Click SAVE 15) Click YES when it prompts with "Filter active, use it for export?" 16) For each prefix you extract, note the count of how many QSOs were exported. This will help you verify counts later -- after you make a log from all the exported files. 17) Click OK (after the export is done) 18) Click File 19) Click Exit Once you have created a export file (.DXQ/.DXN) for each of the deleted prefixes in your log: 20) Click File 21) Click NEW (create a NEW DX4WIN log file) 22) Navigate to the directory where the Export files were created 23) Specify the name of the log file that will contain all your exported data For each prefix file that you exported above, do the following: 24) Click File 25) Click Import/Export 26) Click the DX4WIN export version number that you used in step 3 above 27) Click File (on "Import / Export Filters" screen) 28) Click Import 29) Enter the export file name (Prefix?) that you used earlier 30) Click Open 31) On "Options for duplicate QSOs" screen, click OK 32) Click OK (after the import summary) 33) Click File 34) Click Exit If you have more prefixes to Import, go to step 24 Once you have Imported all your Prefix files: 35) Click File 36) Click SAVE (to save this log to disk) 37) Click File 38) Click Info In theory, the "Nr QSOs" value should equal the sum of the Imported QSOs counts in step 16 above One caveat I am aware of (might be others that my test file didn't find), I entered prefix of KZ5 which resulted in 60 QSOs. However, only ONE of the 60 QSOs actually had a prefix of KZ5 -- all the others had prefix of "K". To catch this situation, I suggest after you do an "export" of a prefix, verify that all selected QSOs have the "prefix" that you were after. Sorry this was so long. If anything doesn't make sense, contact me and I'll see what I can do to make it clearer. 73, Lee N7NU > On 07/21/2022 2:28 PM N5KM - Kris wrote: > > > Hi All, > > Is there a way to search/filter a log for QSOs with deleted entities? > I can see those QSOs in the DXCC report with Deleted selected but I'd > like to see them as part of a database query. Thanks. > > 73, > > Kris N5KM > __ > DX4WIN mailing list > Home: http://mailman.qth.net/mailman/listinfo/dx4win > Help: http://mailman.qth.net/mmfaq.htm > Post: mailto:DX4WIN@mailman.qth.net > > This list hosted by: http://www.qsl.net Please help support this email > list: http://www.qsl.net/donate.html __ DX4WIN mailing list Home: http://mailman.qth.net/mailman/listinfo/dx4win Help: http://mailman.qth.net/mmfaq.htm Post: mailto:DX4WIN@mailman.qth.net This list hosted by: http://www.qsl.net Please help support this email list: http://www.qsl.net/donate.html __ DX4WIN mailing list Home: http://mailman.qth.net/mailman/listinfo/dx4win Help: http://mailman.qth.net/mmfaq.htm Post: mailto:DX4WIN@mailman.qth.net This list hosted by: http://www.qsl.net Please help support this email list: http://www.qsl.net/donate.html
Re: [Dx4win] Search For QSOs with Deleted Entities
Lee, Thanks for your effort coming up with that solution. However, I came up with an easier solution that worked for me. I created a new Custom Award that I call DLTD in the custawds.txt file. I search for the deleted prefixes one at a time, as you suggest. Then I use the Multiple QSOs operations to Set Custom Award to the DLTD award. I did this for each deleted prefix. Now I can Filter my log for Custom Award = DLTD. Voila! All deleted QSOs are retrieved. Note: This method won't work if any of the deleted entity QSOs already have an award assigned unless you don't mind overwriting the existing award. 73, Kris N5KM --- Date: Sun, 31 Jul 2022 23:57:18 -0700 (PDT) From: LEE HALLIN To: N5KM - Kris , dx4win@mailman.qth.net Subject: Re: [Dx4win] Search For QSOs with Deleted Entities Message-ID: <49128311.38244.1659337038...@connect.xfinity.com> Content-Type: text/plain; charset=UTF-8 Hi Kris, I think I have a way to find QSOs with deleted countries but it involves some work. The following involves many steps but once you do a section once, repeating it for other prefixes should be faster. Basically, you get a list of deleted DXCC countries that you have worked (Reports -> check "include deleted" -> OK). Then for each deleted country (indicated by a D in the column with "D" in the heading) that you have worked, note each "prefix". For EACH of those prefixes, do the following: 1) While on the QSO screen 2) Click Filter 3) Click "Cancel filter" 4) Hit F8 5) Hit the TAB key (or click in the Prefix box) 6) Enter a prefix you want to search for 7) Hit Enter 8) Click File 9) Click Import/Export 10) Click the highest DX4WIN format (Ex. DX4WIN8) listed 11) Click File 12) Click Export 13) Enter a file name for the .DXQ/.DXN file to be created (I used the prefix with any slashes changed to dashes -- OK/D would have filename OK-D) 14) Click SAVE 15) Click YES when it prompts with "Filter active, use it for export?" 16) For each prefix you extract, note the count of how many QSOs were exported. This will help you verify counts later -- after you make a log from all the exported files. 17) Click OK (after the export is done) 18) Click File 19) Click Exit Once you have created a export file (.DXQ/.DXN) for each of the deleted prefixes in your log: 20) Click File 21) Click NEW (create a NEW DX4WIN log file) 22) Navigate to the directory where the Export files were created 23) Specify the name of the log file that will contain all your exported data For each prefix file that you exported above, do the following: 24) Click File 25) Click Import/Export 26) Click the DX4WIN export version number that you used in step 3 above 27) Click File (on "Import / Export Filters" screen) 28) Click Import 29) Enter the export file name (Prefix?) that you used earlier 30) Click Open 31) On "Options for duplicate QSOs" screen, click OK 32) Click OK (after the import summary) 33) Click File 34) Click Exit If you have more prefixes to Import, go to step 24 Once you have Imported all your Prefix files: 35) Click File 36) Click SAVE (to save this log to disk) 37) Click File 38) Click Info In theory, the "Nr QSOs" value should equal the sum of the Imported QSOs counts in step 16 above One caveat I am aware of (might be others that my test file didn't find), I entered prefix of KZ5 which resulted in 60 QSOs. However, only ONE of the 60 QSOs actually had a prefix of KZ5 -- all the others had prefix of "K". To catch this situation, I suggest after you do an "export" of a prefix, verify that all selected QSOs have the "prefix" that you were after. Sorry this was so long. If anything doesn't make sense, contact me and I'll see what I can do to make it clearer. 73, Lee N7NU > On 07/21/2022 2:28 PM N5KM - Kris wrote: > > > Hi All, > > Is there a way to search/filter a log for QSOs with deleted entities? > I can see those QSOs in the DXCC report with Deleted selected but > I'd like to see them as part of a database query. Thanks. > > 73, > > Kris N5KM __ DX4WIN mailing list Home: http://mailman.qth.net/mailman/listinfo/dx4win Help: http://mailman.qth.net/mmfaq.htm Post: mailto:DX4WIN@mailman.qth.net This list hosted by: http://www.qsl.net Please help support this email list: http://www.qsl.net/donate.html
Re: [Dx4win] Search For QSOs with Deleted Entities
If you ask a report (QSO window>Reports>DXCC) and check included deleted, you can go at the end where the deleted entities are, and double click on mixed, you will get all the QSOs of this entity. In case you have one of them checked you need to uncheck it to see but then I assume that you don't need to see this one... If you want to see all QSOs in each entity and not only Checked or confirmed, etc you can create a temporary log where you can clear confirmed QSLs and lotw, and clear also QSL date. Then the above procedure should work for all QSOs (really with the same "value" QSOs but value is now worked). Because I am outside of the shack I can not check it but I remember that works something like this, or not? 73 Kostas SV1DPI Στις 2/8/2022 22:56, ο/η N5KM - Kris έγραψε: Lee, Thanks for your effort coming up with that solution. However, I came up with an easier solution that worked for me. I created a new Custom Award that I call DLTD in the custawds.txt file. I search for the deleted prefixes one at a time, as you suggest. Then I use the Multiple QSOs operations to Set Custom Award to the DLTD award. I did this for each deleted prefix. Now I can Filter my log for Custom Award = DLTD. Voila! All deleted QSOs are retrieved. Note: This method won't work if any of the deleted entity QSOs already have an award assigned unless you don't mind overwriting the existing award. 73, Kris N5KM --- Date: Sun, 31 Jul 2022 23:57:18 -0700 (PDT) From: LEE HALLIN To: N5KM - Kris,dx4win@mailman.qth.net Subject: Re: [Dx4win] Search For QSOs with Deleted Entities Message-ID:<49128311.38244.1659337038...@connect.xfinity.com> Content-Type: text/plain; charset=UTF-8 Hi Kris, I think I have a way to find QSOs with deleted countries but it involves some work. The following involves many steps but once you do a section once, repeating it for other prefixes should be faster. Basically, you get a list of deleted DXCC countries that you have worked (Reports -> check "include deleted" -> OK). Then for each deleted country (indicated by a D in the column with "D" in the heading) that you have worked, note each "prefix". For EACH of those prefixes, do the following: 1) While on the QSO screen 2) Click Filter 3) Click "Cancel filter" 4) Hit F8 5) Hit the TAB key (or click in the Prefix box) 6) Enter a prefix you want to search for 7) Hit Enter 8) Click File 9) Click Import/Export 10) Click the highest DX4WIN format (Ex. DX4WIN8) listed 11) Click File 12) Click Export 13) Enter a file name for the .DXQ/.DXN file to be created (I used the prefix with any slashes changed to dashes -- OK/D would have filename OK-D) 14) Click SAVE 15) Click YES when it prompts with "Filter active, use it for export?" 16) For each prefix you extract, note the count of how many QSOs were exported. This will help you verify counts later -- after you make a log from all the exported files. 17) Click OK (after the export is done) 18) Click File 19) Click Exit Once you have created a export file (.DXQ/.DXN) for each of the deleted prefixes in your log: 20) Click File 21) Click NEW (create a NEW DX4WIN log file) 22) Navigate to the directory where the Export files were created 23) Specify the name of the log file that will contain all your exported data For each prefix file that you exported above, do the following: 24) Click File 25) Click Import/Export 26) Click the DX4WIN export version number that you used in step 3 above 27) Click File (on "Import / Export Filters" screen) 28) Click Import 29) Enter the export file name (Prefix?) that you used earlier 30) Click Open 31) On "Options for duplicate QSOs" screen, click OK 32) Click OK (after the import summary) 33) Click File 34) Click Exit If you have more prefixes to Import, go to step 24 Once you have Imported all your Prefix files: 35) Click File 36) Click SAVE (to save this log to disk) 37) Click File 38) Click Info In theory, the "Nr QSOs" value should equal the sum of the Imported QSOs counts in step 16 above One caveat I am aware of (might be others that my test file didn't find), I entered prefix of KZ5 which resulted in 60 QSOs. However, only ONE of the 60 QSOs actually had a prefix of KZ5 -- all the others had prefix of "K". To catch this situation, I suggest after you do an "export" of a prefix, verify that all selected QSOs have the "prefix" that you were after. Sorry this was so long. If anything doesn't make sense, contact me and I'll see what I can do to make it clearer. 73, Lee N7NU On 07/21/2022 2:28 PM N5KM - Kris wrote: Hi All, Is there a way to search/filter a log for