[Dxbase] Rookie needs some help

Sun May 20 03:48:46 EDT 2012

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 