[Dxbase] LoTW flag in QSLs Suggestion and Question

Wed Jan 4 09:47:49 EST 2006

UPDATE
Joe, Wa6AXE, took my database and corrected the LoTW entries using Access
97. 
Prior to sending the dB off to Joe I tried using the Search and Replace
utility in the Edit menu. I clicked a record above the data to be searched
then opened the search/replace dialogue. I used the search key (LoTW) and
replace string of (None). DXb would return nothing, just a Beep alert.
Tried every conventional which way to Sunday to no avail. I consider myself
quite computer literate and a medium to advanced Excel user but no way could
I make the conventional search and replace that I was used to work. That's
when I sent a copy of the dB off to Joe.
This morning I thought I would try again to correct the erroneous Mgr$$
entries that started to appear a week ago following the mysterious 60m
entries I posted earlier. Using the same method - clicking above the
records to be searched - entered (Mgr$$) as search and (Bureau) as replace
and it worked. Go figure.
Now what I did do last evening was run the database repair utility. There
was no feedback to even indicate the utility had completed so no idea what
if anything was repaired. I guess it is possible there was some corruption
somewhere that prevented the Search and Replace utility to work properly,
not sure. (NOTE TO JACK: Some feedback here or a log file would be
helpful.)
Anyway DXb2006 is now back to hopefully smooth sailing for 2006 :-)
Thanks to all who assisted with suggestions and to Joe for the massage with
his Access97.
Paul VE3SY
> -----Original Message-----
> From: FireBrick [mailto:w9ol at billnjudy.com] 
> Sent: Tuesday, January 03, 2006 7:15 PM
> To: Paul Cassel
> Subject: Re: [Dxbase] LoTW flag in QSLs Suggestion and Question
>>> 708 867 4731
> just got back in here.
> will be home all evening....
>>> ----- Original Message ----- 
> From: "Paul Cassel" <paul at ve3sy.com>
> To: "'FireBrick'" <w9ol at billnjudy.com>
> Sent: Tuesday, January 03, 2006 3:57 PM
> Subject: RE: [Dxbase] LoTW flag in QSLs Suggestion and Question
>>> > Well Bill I would love to call you and let you walk me 
> through this. As I
> > said I have tried everything and short of one record at a 
> time unable 
> > to make progress.
> > 
> > Joe WA6AXE said the only fix is to use Access 97. My 
> oldest version 
> > of Access is 2000 with the newer jet engine.
> > 
> > If you want to pass on your phone nbr be glad to give u a call.
> > 
> > 73
> > Paul
> > 
> >> -----Original Message-----
> >> From: FireBrick [mailto:w9ol at billnjudy.com]
> >> Sent: Tuesday, January 03, 2006 2:43 PM
> >> To: Paul Cassel; 'DxBase Reflector'
> >> Subject: Re: [Dxbase] LoTW flag in QSLs Suggestion and Question
> >> 
> >> 
> >> It works as I described in the QSLS column also.
> >> I just tried it.
> >> I do not understand what you mean by highlighting all
> >> records. You do not need to highlight them.
> >> 
> >> I start at the top and did them one by one.
> >> 
> >> 
> >> I just went and marked the last for qsos as sent by LoTW.
> >> I moved the cursor above the first qso in that column.
> >> I did the Replace and this time even selected 'all'
> >> It went down the column and changed the said qsls from 
> LoTW to None.
> >> 
> >> I don't know why it doesn't work for you.
> >> 
> >> 
> >> ----- Original Message -----
> >> From: "Paul Cassel" <paul at ve3sy.com>
> >> To: "'FireBrick'" <w9ol at billnjudy.com>; "'DxBase Reflector'" 
> >> <Dxbase at mailman.qth.net>
> >> Sent: Tuesday, January 03, 2006 1:30 PM
> >> Subject: RE: [Dxbase] LoTW flag in QSLs Suggestion and Question
> >> 
> >> 
> >> It's NOT the CONFIRM column I am faced with fixing, it is the
> >> QSLs field
> >> 
> >> I have tried your method already however the Edit/Replace
> >> only works when a single record is selected. I am unable to 
> >> make it work when highlighting all records in the QSLs colum. 
> >> (This is the column with a pull down choice)
> >> 
> >> Paul
> >> 
> >> 
> >> 
> >> > -----Original Message-----
> >> > From: FireBrick [mailto:w9ol at billnjudy.com]
> >> > Sent: Tuesday, January 03, 2006 2:26 PM
> >> > To: Paul Cassel; 'DxBase Reflector'
> >> > Subject: Re: [Dxbase] LoTW flag in QSLs Suggestion and Question
> >> > 
> >> > 
> >> > Put the cursor in one of the entries ABOVE, the qso's 
> that may have 
> >> > the wrong confirmed data.
> >> > That would be in the column with the heading CFM (there are 
> >> > options, Card, LoTW, and Both)
> >> > 
> >> > Then select the Edit>Replace menu item, and enter LoTW into the 
> >> > Find window and None
> >> > window)
> >> > click on Find, and if you want to make the change, click on 
> >> > replace.
> >> > 
> >> > I just tried it again. both settings, and it most 
> certainly worked 
> >> > for me...
> >> > 
> >> > I wouldn't use the Replace all unless your sure that all the 
> >> > following qso's were NOT qsled via LoTW.
> >> > 
> >> > ----- Original Message -----
> >> > From: "Paul Cassel" <paul at ve3sy.com>
> >> > To: "'FireBrick'" <w9ol at billnjudy.com>; "'DxBase Reflector'"
> >> > <Dxbase at mailman.qth.net>
> >> > Sent: Tuesday, January 03, 2006 1:12 PM
> >> > Subject: RE: [Dxbase] LoTW flag in QSLs Suggestion and Question
> >> > 
> >> > 
> >> > There must be another secret you are not mentioning on using the 
> >> > Edit Replace feature under the Edit menu item. All I get when 
> >> > searching for Both or LoTW is "beep"
> >> > 
> >> > Paul
> >> > 
> >> > > -----Original Message-----
> >> > > From: FireBrick [mailto:w9ol at billnjudy.com]
> >> > > Sent: Tuesday, January 03, 2006 1:48 PM
> >> > > To: Paul Cassel; 'DxBase Reflector'
> >> > > Subject: Re: [Dxbase] LoTW flag in QSLs Suggestion and Question
> >> > >
> >> > >
> >> > > Good Question
> >> > > I did an experiment and used Edit>Replace to find Lotw and 
> >> > > replace with NO. That worked, Then I tried Find Both 
> and replace 
> >> > > with Card
> >> > >
> >> > > I think if you do the Both first, and then repeat with the
> >> > LoTW that
> >> > > should fix up your log.
> >> > >
> >> > >
> >> > > ----- Original Message -----
> >> > > From: "Paul Cassel" <paul at ve3sy.com>
> >> > > To: "'DxBase Reflector'" <Dxbase at mailman.qth.net>
> >> > > Sent: Tuesday, January 03, 2006 12:33 PM
> >> > > Subject: [Dxbase] LoTW flag in QSLs Suggestion and Question
> >> > >
> >> > >
> >> > > > This is a Suggestion as well as a Question.
> >> > > >
> >> > > > When creating an ADIF output from DXb, the user is 
> asked a long 
> >> > > > question about flagging the log entries about to be
> >> > exported to set
> >> > > > LoTW in the QSLs field. It is very easy on occasion to
> >> > > accidentally
> >> > > > accept the default of YES. This results in all entries
> >> > > being exported
> >> > > > having the QSLs field flagged with LOTW or BOTH depending on 
> >> > > > QSL status.
> >> > > >
> >> > > > For those users who do not use the LoTW this is an
> >> > > annoyance and I am
> >> > > > suggesting that a "[ ]Do Not Show This Message Again" box
> >> > > be added to
> >> > > > this Dialogue box as well as offer this choice in
> >> General Options
> >> > > > somewhere in the User Profile.
> >> > > >
> >> > > > So now that I have done this in error enough times to
> >> have really
> >> > > > messed up my QSLs fields, how can one remove or change
> >> > the LoTW or
> >> > > > BOTH status messages to just NONE or CARD for the
> >> > effected entries?
> >> > > >
> >> > > > Thanks
> >> > > > Paul VE3SY
> >> > > >
> >> > > > 
> ______________________________________________________________
> >> > > > 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
> >> > > >
> >> > >
> >> > >
> >> > 
> >> > 
> >> > 
> >> 
> >> 
> >> 
> > 
> >
>