[Dxbase] Rookie needs some help
Gary AL9A
al9a at mtaonline.net
Sun May 20 18:44:06 EDT 2012
Cecil,
As you've apparently figured out now you need two different calls because
the contacts in your log were made with two different calls. If you upload
the whole log to LOTW using just K5DL none of the entries you painstakingly
entered into the log by hand for your old call will match in LOTW because
the call is wrong. Per your later message to Neal it appears that when you
purchased DXB you only provided your new call for the reg file and now it
will not let you enter a different call in the Opr Call field. Neal will
have to get you an updated reg file which you will then have to run to get
the other call into the registration file.
73,
Gary AL9A
----- Original Message -----
From: "chacuff" <chacuff at cableone.net>
To: "Fred Handscombe" <fredch at homeshack.freeserve.co.uk>; "Gary AL9A"
<al9a at mtaonline.net>; <Dxbase at mailman.qth.net>
Sent: May 20, 2012 10:08 AM
Subject: Re: [Dxbase] Rookie needs some help
> 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
>>
>
More information about the Dxbase
mailing list