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
