RTTY
[Top] [All Lists]

[RTTY] RTTY via LoTW - WHO HAS WHAT?

To: Dick Kriss <aa5vu@sbcglobal.net>,rtty-contesting <rtty@contesting.com>
Subject: [RTTY] RTTY via LoTW - WHO HAS WHAT?
From: "k0bx@arrl.net" <k0bx@arrl.net>
Reply-to: k0bx@arrl.net
Date: Mon, 23 Jul 2007 05:50:28 -0700 (PDT)
List-post: <mailto:rtty@contesting.com>
Hi Dick, I was wondering the same thing.

But what I do takes a bit of programming.  I use
DXBASE for my station log.  After uploading from
DXBASE to LOTW then I can download the LOTW confirmed
file into DXBASE.  So all my confirmed LOTW Q's showup
in DXBASE.  I then wrote the below QUERY which said:

Give the prefix of the DXCC country only once, 
where the Mode is RTTY
and the LOTW confimed date is populated
and it is not a deleted country.

This is how I came up with my total of 169.  When I
was checking to make sure my total was correct, I made
a report giving me all the stations with date/time
that was rtty and LOTW.  This way I was able to check
the validity of my count.

It only took 25 years in Information Systems to come
up with this!!

Joe K0BX

SELECT DISTINCT [QSO-TAB].[QSO-PREFIX]
FROM [QSO-TAB] INNER JOIN [PREFIX-Pri] ON
[QSO-TAB].[QSO-PREFIX] = [PREFIX-Pri].PREFIX
WHERE ((([QSO-TAB].[QSO-MODE])="5") AND
(([QSO-TAB].[QSO-LOTWREC])>="") AND
(([PREFIX-Pri].[DEL-STATUS])=0));



--- Dick Kriss <aa5vu@sbcglobal.net> wrote:

> How do you check your RTTY status on LoTW?   I
> pulled up may LoTW account
> and was able to find my DXCC credits for RTTY but
> cannot seem to find how
> many are confirmed by LoTW vs QSL cards.
> 
> Where do you get the numbers used for the LoTW
> update?
> 
> Dick AA5VU

_______________________________________________
RTTY mailing list
RTTY@contesting.com
http://lists.contesting.com/mailman/listinfo/rtty

<Prev in Thread] Current Thread [Next in Thread>