[Dx4win] Search For QSOs with Deleted Entities
Mike Cizek W0VTT
mgcizek at gmail.com
Mon Aug 1 07:37:32 EDT 2022
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-bounces at mailman.qth.net <dx4win-bounces at mailman.qth.net> On
Behalf Of LEE HALLIN
Sent: Monday, 1 August, 2022 01:57
To: N5KM - Kris <n5kilomike at gmail.com>; dx4win at 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 <n5kilomike at gmail.com> 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 at 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 at mailman.qth.net
This list hosted by: http://www.qsl.net
Please help support this email list: http://www.qsl.net/donate.html
More information about the DX4WIN
mailing list