[Dxbase] The Curious Case of the Missing QSOs

Sun Jan 23 22:21:35 EST 2005

Ron,
Your comments made great sense to me. I promptly ran to the computer
and tried them. Unfortunately, it came out with the wrong answers. The
first QSO in my database (K2SX.MDB) is #1 and the last one is #133560. 
I did as u suggested using Selection Wizzard. With nothing checked off,
I got a response of 133,569 Log Records Read and the same for QSO
Records. I tried it with "Valid for DXCC" checked and got 133,560 Log
Records Read and 133,520 QSO records which is about right for the QSOs I
have marked as NG for DXCC. I couldn't find a way to do a sum of QSOs
submitted for LoTW. 
Looks like the QSOs are still missing.
Dennis, K2SX
-----Original Message-----
From: dxbase-bounces at mailman.qth.net
[mailto:dxbase-bounces at mailman.qth.net] On Behalf Of Ron Stordahl
Sent: Sunday, January 23, 2005 5:45 PM
To: Dennis McAlpine
Cc: Dxbase at mailman.qth.net
Subject: Re: [Dxbase] The Curious Case of the Missing QSOs
You say 'According to DXBase, I have 133,000 records.' Where are you 
getting that number? If you are getting it from the "REF#' column in 
DXBase as the number for your last QSO, then click on that column header
and it should sort by number. You will find that it does not start at 
1. In my log I have about 21,000 q's, but the REF# starts at 5190 and 
ends at 26328, which seems about right.
You can tell exactly how many Q's you have in your log by using the 
Selection Wizard. Set it for 'Test Only' and deselect most everything 
but 'Valid for DXCC' (you can even deselect that if you wish). Then run
it, and I would guess you will get about 109,000.
Ron, N5IN
Dennis McAlpine wrote:
>I went back and checked all 24 of the submissions that I made which
>includes one large file which inadvertently got sent five times. Each
>of the submissions said they had been "successfully processed",
>"entered" with "no errors encountered." The total unduplicated of all
>QSOs submitted was indeed 109K as LoTW said.
>>I did receive a response that said that DXBase keeps a record number
>even though a QSO might be deleted. I have been using DXBase since
>DXB97 so I have had a number of deletions and did have one period when
>there were a bunch of duplicates that I had to delete. I would be
>surprised if there were 20K deletions but maybe that is possible. I
>haven't checked yet to see if there is a way of counting the actual
QSOs
>in the database rather than the number of records. So far, this seems
>to be the most likely answer to the case of the missing QSOs.
>>Tnx to all for the input.
>>73,
>>Dennis, K2SX
>>-----Original Message-----
>From: FireBrick [mailto:w9ol at billnjudy.com] 
>Sent: Sunday, January 23, 2005 12:51 PM
>To: Dennis McAlpine
>Cc: Dxbase at mailman.qth.net
>Subject: Re: [Dxbase] The Curious Case of the Missing QSOs
>>>During the 'signing process' were there any 'error reports'.
>>Then go to the LoTW page, select 'Your Account', 'Your Activity', and
>click on the 
>'Result'.
>>If any submissions were rejected due to duplicates, or other reasons,
it
>should be noted 
>there.
>>>Let us know what you find please.
>>----- Original Message ----- 
>From: "Dennis McAlpine" <vze323tn at verizon.net>
>To: <ARRL-LOTW at yahoogroups.com>
>Cc: <Dxbase at mailman.qth.net>
>Sent: Sunday, January 23, 2005 11:39 AM
>Subject: [Dxbase] The Curious Case of the Missing QSOs
>>>>>>I just finished uploading all but about 1000 of my DXBase 2005 QSOs
>>>>>into
>>>>LoTW. According to DXBase, I have 133,000 records. But, according to
>>LoTW I only have 109K in their files. I went back to DXBase and did a
>>select wizard on all QSOs not submitted to LoTW and that showed about
>>>>>5
>>>>that had not been sent out (other than the 1000 that I know about) so
>>this would seem to indicate that all 133K QSOs have been uploaded.
>>Checked the submissions on record at LoTW and it showed that I had
>>>>>sent
>>>>all of the QSOs. So somewhere 33K QSOs seem to have disappeared.
>>>>>Does
>>>>anyone have any ideas where they went? Any thoughts on differences in
>>counting techniques?
>>>>73,
>>Dennis, K2SX
>>>>______________________________________________________________
>>Dxbase mailing list
>>Home: http://mailman.qth.net/mailman/listinfo/dxbase
>>Help: http://mailman.qth.net/mmfaq.htm
>>Post: mailto:Dxbase at mailman.qth.net
>>>>>>>>>______________________________________________________________
>Dxbase mailing list
>Home: http://mailman.qth.net/mailman/listinfo/dxbase
>Help: http://mailman.qth.net/mmfaq.htm
>Post: mailto:Dxbase at mailman.qth.net
>>
______________________________________________________________
Dxbase mailing list
Home: http://mailman.qth.net/mailman/listinfo/dxbase
Help: http://mailman.qth.net/mmfaq.htm
Post: mailto:Dxbase at mailman.qth.net