Re: [Dx4win] Confirmation totals

2018-02-07 Thread Lee Hallin
Hi Dave,

I don't know what you want to do once you find out which QSOs have either Cnfm 
flag set but if you just want to see "a list" (not make any mods) the following 
might get you an answer:

 1) Open the log in question (I'll use G3UEG in my scenario)
 2) Hit F8
 3) Set the Cnfm flag to Y
 4) Hit 
 5) Go to File -> Import/export -> DX4WIN9 -> File -> Export -> G3UEG_cnfm -> 
SAVE -> Yes (use filter) -> OK
 6) Click the Red X (to exit the Import/Export menu)
 7) Hit F8
 8) Set the LoTW Cnfm flag to Y
 9) Hit 
10) Go to File -> Import/export -> DX4WIN9 -> File -> Export -> G3UEG_lotw_cnfm 
-> SAVE -> Yes (use filter) -> OK
11) Click the Red X (to exit the Import/Export menu)
12) File -> NEW -> G3UEG_Cnfms -> OPEN
13) File -> Import/Export -> DX4WIN9 -> File -> Import -> G3UEG_Cnfm -> OK
14) File -> Import/Export -> DX4WIN9 -> File -> Import -> G3UEG_lotw_Cnfm -> 
OPEN -> select "Imported QSO is ignored" -> OK 
15) Note that the "xxx Duplicate QSOs were ignored" value is the number of QSOs 
with BOTH the cnfm and LoTW Cnfm flags set
16) Click OK
17) Click the Red X (to exit the Import/Export menu)
18) File -> Info (tells how many QSOs had one or both of the Cnfm flags set)

This should show you which QSOs have either Cnfm flag set.

Hope this helps (it is a lot of steps but shouldn't take very long to do)

73,
Lee  N7NU

P.S.  If you are not on DX4WIN version 9.x, use the highest DX4WINx format 
available in steps 5, 10, 13-14
>>> David Gould  1/31/2018 4:33 AM >>>
I have just upgraded from V7 to V9.

The QSO confirmation data has changed as I see it.

I can get those confirmed by card, those that are confirmed by LoTW, and 
also those that are confirmed by card **AND** LoTW.

How do I find those QSO that are confirmed by card **OR** Lotw?

73, Dave G3UEG
__
DX4WIN mailing list
Home: http://mailman.qth.net/mailman/listinfo/dx4win

Help: http://mailman.qth.net/mmfaq.htm

Post: mailto:DX4WIN@mailman.qth.net
Message delivered to hall...@lanecc.edu

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
Message delivered to arch...@mail-archive.com

This list hosted by: http://www.qsl.net
Please help support this email list: http://www.qsl.net/donate.html

Re: [Dx4win] Confirmation totals

2018-02-06 Thread Mike Cizek W0VTT
Hello Dave,

You can find those confirmed via LoTW on your LoTW page on the awards tab.
To find the QSOs in your log confirmed one way or the other, do a simple
search. In the QSO window, click F8, then Y on Cnfm for either Label (paper
card) or LoTW.

-- 
73,
Mike Cizek WØVTT

-Original Message-
From: dx4win-boun...@mailman.qth.net [mailto:dx4win-boun...@mailman.qth.net]
On Behalf Of David Gould
Sent: Wednesday, January 31, 2018 06:33
To: dx4win@mailman.qth.net
Subject: [Dx4win] Confirmation totals

I have just upgraded from V7 to V9.

The QSO confirmation data has changed as I see it.

I can get those confirmed by card, those that are confirmed by LoTW, and 
also those that are confirmed by card **AND** LoTW.

How do I find those QSO that are confirmed by card **OR** Lotw?

73, Dave G3UEG
__
DX4WIN mailing list
Home: http://mailman.qth.net/mailman/listinfo/dx4win
Help: http://mailman.qth.net/mmfaq.htm
Post: mailto:DX4WIN@mailman.qth.net
Message delivered to mgci...@gmail.com

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
Message delivered to arch...@mail-archive.com

This list hosted by: http://www.qsl.net
Please help support this email list: http://www.qsl.net/donate.html


[Dx4win] Confirmation totals

2018-02-06 Thread Bruce Blackley
A week ago or so David Gould sent an email to the reflector asking how to
query the database to extract all the confirmed contacts from the log via
card and LoTW together.  I lost the email so I don't have David's call or 
email address.  



I think I may have an answer to his question but it is a little hard to
answer in an email.  If David still wants help with this matter please call
me at 804-883-7733 and I would be happy to explain how I do this.



73



Bruce Blackley



WD4LBR

---
This email has been checked for viruses by AVG.
http://www.avg.com

__
DX4WIN mailing list
Home: http://mailman.qth.net/mailman/listinfo/dx4win
Help: http://mailman.qth.net/mmfaq.htm
Post: mailto:DX4WIN@mailman.qth.net
Message delivered to arch...@mail-archive.com

This list hosted by: http://www.qsl.net
Please help support this email list: http://www.qsl.net/donate.html


[Dx4win] Confirmation totals

2018-02-06 Thread David Gould

I have just upgraded from V7 to V9.

The QSO confirmation data has changed as I see it.

I can get those confirmed by card, those that are confirmed by LoTW, and 
also those that are confirmed by card **AND** LoTW.


How do I find those QSO that are confirmed by card **OR** Lotw?

73, Dave G3UEG
__
DX4WIN mailing list
Home: http://mailman.qth.net/mailman/listinfo/dx4win
Help: http://mailman.qth.net/mmfaq.htm
Post: mailto:DX4WIN@mailman.qth.net
Message delivered to arch...@mail-archive.com

This list hosted by: http://www.qsl.net
Please help support this email list: http://www.qsl.net/donate.html


Re: [Dx4win] Confirmation totals

2018-01-31 Thread WA7AA

On 31-Jan-18 04:33, David Gould wrote:
I can get those confirmed by card, those that are confirmed by LoTW, 
and also those that are confirmed by card **AND** LoTW.


How do I find those QSO that are confirmed by card **OR** Lotw? 


There is no way to do this from within DX4Win ("that I know of..." 
weasel clause), in the absence of ability to do SQL operations on the 
database. You can export the log and perform simple spreadsheet calcs in 
Excel, or if you want just the bottom line number, here's the way:


 [Card OR LoTW] = F8 Card + F8 LoTW - F8 (Card AND LoTW)


Sorry if it's too banal & 73,

Zoran WA7AA


__
DX4WIN mailing list
Home: http://mailman.qth.net/mailman/listinfo/dx4win
Help: http://mailman.qth.net/mmfaq.htm
Post: mailto:DX4WIN@mailman.qth.net
Message delivered to arch...@mail-archive.com

This list hosted by: http://www.qsl.net
Please help support this email list: http://www.qsl.net/donate.html

Re: [Dx4win] Confirmation totals

2018-01-31 Thread Chris Sauvageot

Sorry, NO

He ask for *OR* and you talk about *AND*

73 Chris
DL5NAM


Am 31.01.2018 um 13:47 schrieb Mike Cizek W0VTT:

Hello Dave,

You can find those confirmed via LoTW on your LoTW page on the awards tab.
To find the QSOs in your log confirmed one way or the other, do a simple
search. In the QSO window, click F8, then Y on Cnfm for either Label (paper
card) or LoTW.



__
DX4WIN mailing list
Home: http://mailman.qth.net/mailman/listinfo/dx4win
Help: http://mailman.qth.net/mmfaq.htm
Post: mailto:DX4WIN@mailman.qth.net
Message delivered to arch...@mail-archive.com

This list hosted by: http://www.qsl.net
Please help support this email list: http://www.qsl.net/donate.html