[Dxbase] The Curious Case of the Missing QSOs

Sun Jan 23 22:35:54 EST 2005

Dennis,
The number of QSOs in your log is simple to see. Just scroll to the end of 
your log and click in the last QSO record you have entered. Now, look at 
the lower left hand corner of the log window where you see the phrase 
"record" and a number. The number you see is how many QSOs are in your 
database.
As we have said many times on the reflector and in the help file, the ref# 
is not of any interest to a user and it is not the number of QSOs in your 
log. It is purely a reference number so that we can uniquely identify a 
particular QSO when we need to update an award or date field after you 
perform some operations.
Hope this helps,
Jack
----- Original Message ----- 
From: "Dennis McAlpine" <vze323tn at verizon.net>
To: "'Joseph Glockner'" <jglock2 at airmail.net>; <Dxbase at mailman.qth.net>
Sent: Sunday, January 23, 2005 10:27 PM
Subject: RE: [Dxbase] The Curious Case of the Missing QSOs
> Joe,
>> I'm afraid you have hit on the answer - the REF # is irrelevant and is
> not the number of QSOs. We have been trying to make something out of it
> that it is not. It would be nice to have a way to tell, even if just
> for purient interest alone, how many real QSOs are in one's log. But,
> maybe the answer is to put all of the QQSOs in LoTW and it will tell you
> the correct number.
>> 73,
>> Dennis, K2SX
>> -----Original Message-----
> From: Joseph Glockner [mailto:jglock2 at airmail.net]
> Sent: Sunday, January 23, 2005 8:22 PM
> To: Dxbase at mailman.qth.net
> Cc: Dennis McAlpine; 'FireBrick'
> Subject: Re: [Dxbase] The Curious Case of the Missing QSOs
>>> 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
>>>> ______________________________________________________________
> 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
>