[Dxbase] The Curious Case of the Missing QSOs

Sun Jan 23 23:56:03 EST 2005

So the question remains...if you have 133,560 valid for DXCC contacts, 
and you think you have submitted them all, then why does LoTW report you 
have about 20,000 fewer. 
With that many 'missing' from the LoTW is should be fairly easy to pick 
at random Q's from you log and you should quickly find some which are 
not in the LoTW, since roughly 1 in 7 Q's in your log must not be in the 
LoTW. I would start by doing some checking and see if this is 
confirmed. If it is, and it would seem it must be the case, then can 
you see some common characteristic among the Q's which didn't get to the 
LoTW? Perhaps you had something set in the selection wizard which 
caused it to skip quite a few. If you could find such a reason then you 
could select just those and submit them. I doubt if you will be so 
lucky however!
Another thing you can do is go to the LoTW 'Your Account' and select 
'Your Activity'. In your case this could be a lot of entries, however 
for each entry if you click on 'Results' you can see how many Q's were 
submitted for each such submission. It will take some time, but you 
could add them up and see if they total roughly 133,520 or possibly 
20,000 fewer. 
I have been told that resubmitting Q's to the LoTW does no harm, Q's 
that are already in there are not replaced, since the replacement would 
be identical. And Q's that are not there are added properly. Since you 
already confirmed that the selection wizard selected 133,560 Q's, you 
could run it and 'resubmit' them. If after doing that you still have 
roughly 113,000 Q's in the LoTW sounds like the issue would have to be 
taken up with them.
I have resubmitted Q's where in error I had used the wrong CQ Zone, but 
everything else was identical. The effect was not to produce two 
entries, but just one with the zone corrected. Of course this re 
submittal was not on such a massive scale, but it would seem that the 
same principle would apply. I guess you could ask the LoTW before you 
flooded them?
Ron, N5IN
Dennis McAlpine wrote:
>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
>>>