[Dxbase] Rookie needs some help

Sun May 20 10:35:05 EDT 2012

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 