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" <a...@mtaonline.net> To: <Dxbase@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" <chac...@cableone.net> > To: <Dxbase@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@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@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@mailman.qth.net This list hosted by: http://www.qsl.net Please help support this email list: http://www.qsl.net/donate.html
