Re: [Dx4win] Search For QSOs with Deleted Entities

Kostas SV1DPI Mon, 08 Aug 2022 01:26:34 -0700

If you ask a report (QSO window>Reports>DXCC) and check includeddeleted, you can go at the end where the deleted entities are, anddouble click on mixed, you will get all the QSOs of this entity. In caseyou have one of them checked you need to uncheck it to see but then Iassume that you don't need to see this one...

If you want to see all QSOs in each entity and not only Checked orconfirmed, etc you can create a temporary log where you can clearconfirmed QSLs and lotw, and clear also QSL date. Then the aboveprocedure should work for all QSOs (really with the same "value" QSOsbut value is now worked).

Because I am outside of the shack I can not check it but I remember thatworks 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<lhal...@comcast.net>
To: N5KM - Kris<n5kilom...@gmail.com>,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<n5kilom...@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@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

Reply via email to