[Dxbase] The Curious Case of the Missing QSOs

Mon Jan 24 06:01:30 EST 2005

Dennis
One quick question.
In your DXBase log. Are all your qso's with the same call sign?
----- Original Message ----- 
From: "Dennis McAlpine" <vze323tn at verizon.net>
To: "'Joseph Glockner'" <jglock2 at airmail.net>; <Dxbase at mailman.qth.net>
Cc: "'FireBrick'" <w9ol at billnjudy.com>
Sent: Sunday, January 23, 2005 9: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
>>>>