[Dxbase] Rookie needs some help

Sun May 20 14:08:29 EDT 2012

What impact does it have on LOTW's search for matching QSO's if all log 
entries show my new call as the operator.  If that forces LOTW to search for 
contacts that were actually made with the WB5VCE call using the K5DL call it 
will bust.  But if the LOTW certificate sets the call sign for the search 
that operator field in DXbase wouldn't matter.

Just not sure how all this works yet.

Cecil
K5DL
----- Original Message ----- 
From: "Fred Handscombe" <fredch57 at emirates.net.ae>
To: "Gary AL9A" <al9a at mtaonline.net>; <Dxbase at mailman.qth.net>; 
<chacuff at cableone.net>
Sent: Sunday, May 20, 2012 9:35 AM
Subject: Re: [Dxbase] Rookie needs some help

> Gary, Cecil
>
> That sounds a lot of work!
>
> I am assuming you know the date you changed your callsign and didn't make 
> QSOs on the same date with both calls?
>
> 1 - Back up your log (that I agree with!)
>
> 2 Export the date range for your first call to an ADIF file (Use the 
> "selection wizard", you may need to practice as it seems to work 
> counter-intuitively! Does "<" mean BEFORE or AFTER the given date?)
>
> 3 "Sign" that ADIF file with your LOTW key for your old call and upload to 
> LOTW
>
> 4 Export the date range for your new call to another ADIF file
>
> 5 "Sign" that ADIF file with your LOTW key for your new call and upload to 
> LOTW
>
> Optionally you could then use those 2 ADIF files to create TWO DXbase 
> logs, one for each call, using the "Non DXB import" routine
>
> 73 Fred
> A65BD - G4BWP
>
> ----- Original Message ----- 
> From: "Gary AL9A" <al9a at mtaonline.net>
> To: <Dxbase at mailman.qth.net>
> Sent: Sunday, May 20, 2012 11:48 AM
> Subject: Re: [Dxbase] Rookie needs some help
>
>
>> Cecil,
>>
>> I don't know if you need to break your data base up into two records or 
>> not.
>> First try working with the single data base and do some editing work to
>> straighten things out.
>>
>> 1. Make a back up of your current mdb file so in case something goes awry
>> you can start over again.
>>
>> 2. Now you need to reset the QSLS field back to its original setting for 
>> all
>> records in the log.  The QSLS field should now have all records set to
>> either LOTW or Both, meaning you've sent both a paper card and set the 
>> LOTW
>> flag.  You need to change all the LOTW settings back to where they were. 
>> Go
>> to the first record in the log and click on the QSLS field of that 
>> record.
>> Now click on Edit/Replace.  In the Replace window type "Both" in the 
>> "Find
>> what:" box and "Card" in the "Replace with:" box.  Now click on the 
>> "Replace
>> All" button.  DXB will now work its way down through the log to the last
>> record and change each instance of Both to Card, which removes the LOTW
>> part.  When that is done click on Cancel to close the window.  Again, 
>> from
>> the first record in the log, click on Edit/Replace and enter "LOTW" in 
>> the
>> "Find what:" box and "No" in the "Replace with:" box.  Click on the 
>> "Replace
>> All" button.  DXB will again go down through the log and change all the
>> records that were flagged as being sent to LOTW and change them back to 
>> No,
>> meaning nothing has been sent.  This has now cleared all the LOTW flags 
>> from
>> the QSLS field.
>>
>> 3. In the Opr Call field did you use both your old call, WB5VCE, and your
>> new call, K5DL, when entering the records?  If not and all the records 
>> have
>> an Op Call of K5DL you need to segregate which records belong to the old
>> call and which to the new call.  To do this you will need to know the 
>> date
>> you started using your new call.  All records prior to this date should 
>> have
>> the old call in the Opr Call field.  If you already have both calls in 
>> the
>> log skip to Step 5.  If you only have K5DL go to Step 4.
>>
>> 4. Go to the first record in the log and click on the Opr Call field. 
>> Now
>> click on Edit/Replace and the Replace window should say K5DL in the "Find
>> what:" box.  If not, enter K5DL here.  In the "Replace with:" box type
>> WB5VCE and click on "Replace All".  This will cause DXB to change all
>> entries in the Opr Call filed of the log to WB5VCE.  Now go down in the 
>> log
>> to the date you started using the new K5DL call.  On this record click in
>> the Opr Call field and Edit/Replace.  Fill in the boxes so that you 
>> replace
>> WB5VCE with K5DL and click Replace All again.  This sets all the records
>> from here down back to the correct call sign in use at that time.  Make 
>> note
>> of how many records have the old call and how many records are with the 
>> new
>> call.  Check the Record counter box at the bottom of the log.
>>
>> 5. With both old and new calls in the log you can now attempt to create 
>> two
>> different adif files for submission to LOTW.  Go to Tools/Selection 
>> Wizard
>> and set "Output Type" to "ADIF File" and click on the "Test only..." box.
>> Now click on the "QSO Filters" button.  Clear all the boxes in the record
>> filters section and then click on the boxes for "No LOTW Submitted" and 
>> "QSO
>> Call =".  In the "QSO Call =" box enter WB5VCE.  This will now select all
>> records for WB5VCE that have not been sent to LOTW.  Click on OK and then
>> Start on the Selection Wizard.  When asked create a adif file name and be
>> sure to click on NO when it asks to update your records.  When the Wizard
>> completes its Test only run exam the number of records it identified and
>> compare it with the record count from your log.  Does it seem correct? 
>> If
>> so clear the Test only box and run it again.  This time choose Yes to the
>> question about setting the LOTW flag.  Now do the same procedure again, 
>> but
>> this time create an adif file for the records where QSO Call = K5DL. 
>> Again
>> do a test run first and if it looks accurate create the adif file and say
>> Yes to changing the records in the log to LOTW.
>>
>> You now have two separate adif files to upload to LOTW.  One for your old
>> call the other for your new call.  If you keep all records in a single 
>> log
>> you will have to be sure you select the right call when creating future 
>> adif
>> files for upload to LOTW.  If you prefer to have two mdb files, one for 
>> each
>> call, create a new mdb file and import one of the adif files into the new
>> log.  Then go to the complete log and delete these records out so that 
>> you
>> have two distinct mdb files.  Good luck!
>>
>> 73,
>> Gary AL9A
>>
>>
>> ----- Original Message ----- 
>> From: "chacuff" <chacuff at cableone.net>
>> To: <Dxbase at mailman.qth.net>
>> Sent: May 19, 2012 8:34 PM
>> Subject: [Dxbase] Rookie needs some help
>>
>>
>>> Greetings,
>>>
>>> Pulling what hair I have left out...hoping you guys can help.
>>>
>>> I have made a rookie mistake I think.  Started with DXbase a couple of
>>> years
>>> ago.  In the beginning I entered a few QSO's just to see how things
>>> worked...ended up entering my entire paper log collection over time
>>> finishing up tonight. (with a year and a half gap in the middle of no 
>>> use)
>>> I'm crosseyed...
>>>
>>> I've not made any submissions to LOTW.  Do have an account setup with 
>>> both
>>> callsigns I've had.  (2 certificates)
>>>
>>> When I had DXbase create an ADIF file it was for my entire log since I 
>>> had
>>> not submitted to LOTW before.  The mistake is that all of my log is 
>>> under
>>> my
>>> current call in one database.  Looks like I should have created two
>>> databases one for each call.  When I try to have LOTW (TSQ?) convert the
>>> ADIF file for upload it flags quite a few log entries as having
>>> Certificate
>>> date out of range errors.  I am assuming I am trying to have it convert
>>> QSO's that are outside the certificate dates for the current call.  In
>>> generating the ADIF file I also had it flag the database that all QSO's
>>> have
>>> been uploaded to LOTW.  Not sure how to fix that....
>>>
>>> I guess what I am needing is a way to cut the database records for my
>>> first
>>> call sign and paste them into a database for that call sign which I have
>>> created within DXbase.  I really don't want to have to type all the QSO
>>> data
>>> for my earlier call sign again.  Were talking 1977 til 2006...several
>>> hundred records.
>>>
>>> Any help for the noob?
>>>
>>> TIA...
>>>
>>> Cecil
>>> K5DL (ex WB5VCE)
>>>
>>> ______________________________________________________________
>>> 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
>>>
>>> This list hosted by: http://www.qsl.net
>>> Please help support this email list: http://www.qsl.net/donate.html
>>
>> ______________________________________________________________
>> 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
>>
>> This list hosted by: http://www.qsl.net
>> Please help support this email list: http://www.qsl.net/donate.html
> 