[Dxbase] The Curious Case of the Missing QSOs

[FireBrick]

Interesting Ron.
I never did a sort on that.
Mine start at 5190 also.

Guess there are some data that is being stored somewhere that uses some of the resources.
I always knew the Ref# didn't relate to the amount of qso's. but never noticed the effect.



----- Original Message ----- 
From: "Ron Stordahl" <ron.stordahl at digikey.com>
To: "Dennis McAlpine" <vze323tn at verizon.net>
Cc: "'FireBrick'" <w9ol at billnjudy.com>; <Dxbase at mailman.qth.net>
Sent: Sunday, January 23, 2005 4:44 PM
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
>>
>
>