Export the records in question to an ADIF file, Go into DXBASE and delete both records. Use notepad to edit the ADIF file and remove one. Then load the ADIF file back in using the non-dxbase input utility. The data base is unique indexed to prevent duplicates, of a Callsign at the Same Date and Time. Check for hidden character in call sign field. Also best seen in the ADIF file.Best WishesRichard K5SFлл Àí²é> Date: Sun, 23 Mar 2008 12:05:44 -0400> From: [EMAIL PROTECTED]> To: [email protected]> Subject: [Dxbase] Stripping duplicate contacts> > For some reason dxbase has allowed duplicate contacts to be added to the > database is there a way to delete the dupes and leave only one entry?> > Mike/aj9c> > ______________________________________________________________> Dxbase mailing list> Home: http://mailman.qth.net/mailman/listinfo/dxbase> Help: http://mailman.qth.net/mmfaq.htm> Post: mailto:[EMAIL PROTECTED] n7ws at k6mhe.com Sun Mar 23 11:48:11 2008 From: [EMAIL PROTECTED] (Wes N7WS) Date: Sun Mar 23 11:54:53 2008 Subject: [Dxbase] Stripping duplicate contacts In-Reply-To: <[EMAIL PROTECTED]> References: <[EMAIL PROTECTED]> Message-ID: <[EMAIL PROTECTED]>
Mike Kasrich wrote: > For some reason dxbase has allowed duplicate contacts to be added to > the database is there a way to delete the dupes and leave only one entry? > I have discovered that if you happen to have the Microsoft Office suite, with MS Access you can do interesting things to DXBase. Of course, when opening your log database in Access you will get some messages about not being able to change anything without converting the database, etc. But... (and as always BACK UP YOUR LOG)...if you have the log open in DXBase and Access at the same time, changes made to the database in Access are made simultaneously to the log, and vice versa. So you can sort the log (QSO-TAB) by columns that can't be sorted in DXB, do a "Find and Replace", and so on and so forth. I am by no means an Access expert (when I was employed, I had people to do this) but by playing around you can get the hang of it. BTW, a lot of things are represented by binary numbers in the database, "MODE", "CFM", "QSLS" for examples are handled that way. "BAND" is handled differently too, for example, BAND = 0 is two-meters, BAND = 2 is 10 meters, BAND = 10 is 160 ...but by comparing entries in the two programs you can sort it out. If something got corrupted in your database and "created" dupes, maybe you can group them by some criteria and delete them en mass. Maybe this will help. Regards, Wes ps. BACK UP YOUR LOG FIRST!!! From [EMAIL PROTECTED] Sun Mar 23 18:11:05 2008 From: [EMAIL PROTECTED] (Gary AL9A) Date: Sun Mar 23 18:17:34 2008 Subject: [Dxbase] DXB2007 QSL question In-Reply-To: <[EMAIL PROTECTED]> References: <[EMAIL PROTECTED]> Message-ID: <[EMAIL PROTECTED]> Gregg, Try the Selection Wizard to get the records you want. I have DXB2006, but I think the Wizard is pretty much the same for DXB2007. The thing is to adequately define what you want through the Wizard filters. You will need to run three iterations to get all your QSL labels because DXB stores Modes for USB, LSB and CW. As for manager labels, I'm not sure what happens with the Pending Address Labels. I think that will depend upon what you have in your data base as the QSL manager for a particular call sign. The Selection Wizard says it reads Log Records for QSO Labels, Address Labels and QSO Records. The Output Type choices are Reports, Labels, and ADIF file. I know the Labels selection sends QSL labels to the Pending QSL Labels file, but I'm not sure if it does the same for the Pending Address Labels file. Try a few runs of the Selection Wizard to see what you can do. If you currently have any Pending Address or QSL labels print them off and then clear the Pending Labels database before starting. That way if you make a mistake you can delete everything there and try again. Be sure to check the 'Test only - Don't save output' box until you think you have the Wizard filters working correctly. Assuming you only want labels for unconfirmed NEW ONES, not everything that is unconfirmed, try the following: Start the Selection Wizard. Set Output Type to Labels Check the Test only box In the Auto Detect New Ones area check Active Category = Countries Click the radio buttons for the Mode and Band choices you want Click on the QSO Filters button Check Valid DXCC Check Mode = USB or LSB or CW (you need to change this on each iteration for all the modes you want) Check Confirm = None Click OK to return to the main Selection Wizard screen Let 'er rip! If you get what looks like a reasonable number of records selected, uncheck the Test Only box and run it again. This will send the output to the Pending Labels database. Go there and look at the records that were selected. If everything is ok, go back to the Wizard and filter for a different mode. Those records will be added to the ones already there. If it looks like you have selected something you don't want delete all the pending labels and try adjusting more filters in the Wizard. If you get QSL records, but no corresponding address label, check for the missing addresses in the QSL Info window to see if an address exists. If not, you will need to add any info you can get from a QSL manager service, such as qrz.com, and then Save a manager map for the call sign. Then you will have to delete your Pending Labels and run the process again to get new labels with the manager routing info. Good luck. 73, Gary AL9A ----- Original Message ----- From: "W6IZT" <[EMAIL PROTECTED]> To: "DXBase" <[email protected]> Sent: March 22, 2008 5:45 AM Subject: [Dxbase] DXB2007 QSL question > This may be an obvious question, but I am stumped. > > How do I configure DXB2007 to print QSL and Manager labels for all > unconfirmed DXCC entities for all bands SSB + CW. > > Thanks in advance for your help > > Gregg > W6IZT > > > > ______________________________________________________________ > Dxbase mailing list > Home: http://mailman.qth.net/mailman/listinfo/dxbase > Help: http://mailman.qth.net/mmfaq.htm > Post: mailto:[email protected]
