[Dxbase] The Curious Case of the Missing QSOs

[Joseph Glockner]

Dennis and all:

After playing around with the 2005 logbook of my mdb file..
I have seen the following conclusions with regards to the REF#
column ...

(1) 1st scenario --If I make a new entry - it will pickup the
"next # up" in sequence in the Ref# column ... IF I "delete"
THAT entry and make a new entry -- the Ref # used in my previously
deleted entry is NOT REUSED -- but, I see the "next # up --
the next # up from the # used in my deleted entry ...

(2) 2nd scenario -- IF I "never had done the 1st scenario" --
and just simply made a NEW entry -- it will pickup the "next # up"
in the Ref # column ... Now - IF  I  "delete" this entry --

and here is the BIG difference ---

and NOW simply close out DXbase - and immediately RUN the Access
Maintainer program - which removes all of the deleted entries
(junk area) ----

and NOW bring DXbase back open and this time make a new entry
and the "next # up" in the Ref column will be the "next up
from the 'original entry' ...


So - bottom line -- the REF # column is only for DXbase
internal use -- and ---  to make sure that your REF #'s stay
one-up after each other --  if you make entries and delete
entries -- each time- if you use the access maintainer program
or some such compacting program - your ref#s will be in
sequence..

The above is ONLY to be FYI -- since Ref # column is not used
at all by the DXbase user .. simply do not try to make something
from it..

73 Joe wa6axe

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
>