Differences between revisions 7 and 29 (spanning 22 versions)
Revision 7 as of 2009-08-19 01:09:36
Size: 3025
Editor: AA6YQ
Comment:
Revision 29 as of 2019-03-29 21:53:21
Size: 2867
Editor: AA6YQ
Comment:
Deletions are marked like this. Additions are marked like this.
Line 1: Line 1:
=== Removing Duplicate QSOs from the Currently Open Log === == Removing Duplicate QSOs from the Currently Open Log ==

This procedure checks each QSO in your log to see whether any other QSO in your log that exactly matches its '''Callsign''', '''Band''', '''Mode''', and '''QSO Begin Date and Time''' (to the second), and makes it easy to delete any duplicates that are discovered.
Line 5: Line 7:
 1. on the '''Main''' window's '''Log QSOs''' tab, click the '''Filter''' panel's '''X''' button (to ensure that all of your QSOs are present in the '''Log Page Display''')  1. on the '''Main''' window's '''Log QSOs''' tab,
Line 7: Line 9:
 1. on the '''Main''' window's '''Export''' tab,    a. click the '''Filter''' panel's '''X''' button (to ensure that all of your QSOs are present in the '''Log Page Display''')
Line 9: Line 11:
  a. set the '''Options''' panel to '''Export standard ADIF'''    a. click the '''Adv''' command button to display the '''Advanced Filters, Sorts, and Modifiers''' window (the '''Adv''' command button is located above the '''Log Page Display''', not in the '''Sort''' panel)
Line 11: Line 13:
  a. check the '''export QTH definitions''' box
 
  a. click the '''Start''' button, and specify a file into which your log's QSOs will be saved (where you save this file is not important -- just remember the pathname so you can import it in step 5 below
 1. in the '''Advanced Filters, Sorts, and Modifiers''' window's '''Duplicates''' panel, click the '''Filter''' button; since this operation will clear the [[http://www.dxlabsuite.com/dxkeeper/Help/Items.htm#select|Select item]] in every logged QSO and then set the [[http://www.dxlabsuite.com/dxkeeper/Help/Items.htm#select|Select item]] to {{{Y}}} in each duplicate QSO, you will be prompted to confirm that you wish to proceed.
Line 15: Line 15:
 1. on the '''Config''' window's '''Log''' tab in the '''Log file''' panel, specify the name of a non-existent log file for DXKeeper to create -- ideally in the same folder in which your current log file resides -- and then click the '''Create''' button  1. if you don't care about choosing which of a pair of identical QSOs to delete, then on the '''Main''' window's '''Log QSOs''' tab, depress the '''CTRL''' key while clicking the '''Delete''' button
Line 17: Line 17:
  * for instance, if your current log resides in C:\Program Files\DXLab Suite\DXKeeper\Logs\AA6YQ.mdb then create a new log file whose pathname is C:\Program Files\DXLab Suite\DXKeeper\Logs\AA6YQ_no_duplicates.mdb  1. if you'd prefer to select which of a pair of identical QSOs to delete, possibly moving information (e.g. from ''Name'' or ''Address'' items) from one QSO to the other before deleting a duplicate, then
Line 19: Line 19:
 1. on the '''Main''' window's '''Import''' tab   a.  on the Main window's '''Log QSOs''' tab,
Line 21: Line 21:
  a. in the '''ADIF style options''' panel, select '''standard ADIF'''      * click the Filter panel's '''X''' button to remove all Log Page Display filtering
Line 23: Line 23:
  a. in the '''Duplicate checking''' panel, check the '''check duplicates on import''' box, and set the '''range''' to +/- 0 minutes so that only exact duplicates are removed (unless you have duplicates whose times don't match exacty, in which case set the range appropriately)
 
  a. uncheck all other boxes
     * set the '''Sort''' panel to '''UTC'''
Line 27: Line 25:
  a. click the '''Start''' button, and select the ADIF file you exported in step 3c; each imported QSO is checked against each QSO in your log before importing it, so this step might take awhile if your log contains a lot of QSOs (but its much faster than deleting the duplicates by hand)   a. if the ''APP_DXKEEPER_SELECT'' item is not visible in the Log Page Display, [[LogPageDisplayConfiguration| add a column for this item]]
Line 29: Line 27:
 1. Carefully inspect the QSOs in the '''Log Page Display''' to verify that the duplicates have been eliminated; if you're satisfied, then   a. review the QSOs in the Log Page Display, setting or clearing the [[http://www.dxlabsuite.com/dxkeeper/Help/Items.htm#select|Select items]] of those QSOs you do or don't wish to have deleted; double-clicking a QSO to filter the Log Page Display to show only QSOs with that same callsign can be helpful when performing this review.
Line 31: Line 29:
  a. on the '''Config''' window's '''Log''' tab, click the '''Log file''' panel's '''Open''' button, and open your original log file (the one that contains duplicate, which in our example is C:\Program Files\DXLab Suite\DXKeeper\Logs\AA6YQ.mdb )   a. on the Main window's '''Log QSOs''' tab,
Line 33: Line 31:
  a. terminate DXKeeper      * click the Filter panel's '''Sel''' button, and verify that the QSOs now visible in the Log Page Display are the ones you wish to delete
Line 35: Line 33:
  a. using Windows Explorer, navigate to the folder containing your original log file and the new de-duplicated log file, and      * depress the '''CTRL''' key while clicking the '''Delete''' button
Line 37: Line 35:
     * rename your original log file to include the words ''contains_duplicates''' (for example, rename AA6YQ.mdb to AA6YQ_contains_duplicates.mdb)
Line 39: Line 36:
     * rename the log file you created in step 4 to the name of your original log file (for example, rename AA6YQ_no_duplicates.mdb to AA6YQ.mdb)
Line 42: Line 38:
[http://groups.yahoo.com/group/dxlab/post Post a question or suggestion on the DXLab reflector] [[DXLabDiscussionGroup|Post a question or suggestion on the DXLab Discussion Group]]
Line 44: Line 40:
["Logging"] [[Logging]]
Line 46: Line 42:
[:GettingStarted:Getting Started with DXLab] [[GettingStarted|Getting Started with DXLab]]

Removing Duplicate QSOs from the Currently Open Log

This procedure checks each QSO in your log to see whether any other QSO in your log that exactly matches its Callsign, Band, Mode, and QSO Begin Date and Time (to the second), and makes it easy to delete any duplicates that are discovered.

  1. on the Config window's Log tab, click the Log panel's Backup button (to make a backup copy of your log in case you don't like the results of this procedure)

  2. on the Main window's Log QSOs tab,

    1. click the Filter panel's X button (to ensure that all of your QSOs are present in the Log Page Display)

    2. click the Adv command button to display the Advanced Filters, Sorts, and Modifiers window (the Adv command button is located above the Log Page Display, not in the Sort panel)

  3. in the Advanced Filters, Sorts, and Modifiers window's Duplicates panel, click the Filter button; since this operation will clear the Select item in every logged QSO and then set the Select item to Y in each duplicate QSO, you will be prompted to confirm that you wish to proceed.

  4. if you don't care about choosing which of a pair of identical QSOs to delete, then on the Main window's Log QSOs tab, depress the CTRL key while clicking the Delete button

  5. if you'd prefer to select which of a pair of identical QSOs to delete, possibly moving information (e.g. from Name or Address items) from one QSO to the other before deleting a duplicate, then

    1. on the Main window's Log QSOs tab,

      • click the Filter panel's X button to remove all Log Page Display filtering

      • set the Sort panel to UTC

    2. if the APP_DXKEEPER_SELECT item is not visible in the Log Page Display, add a column for this item

    3. review the QSOs in the Log Page Display, setting or clearing the Select items of those QSOs you do or don't wish to have deleted; double-clicking a QSO to filter the Log Page Display to show only QSOs with that same callsign can be helpful when performing this review.

    4. on the Main window's Log QSOs tab,

      • click the Filter panel's Sel button, and verify that the QSOs now visible in the Log Page Display are the ones you wish to delete

      • depress the CTRL key while clicking the Delete button


Post a question or suggestion on the DXLab Discussion Group

Logging

Getting Started with DXLab

RemovingDuplicates (last edited 2019-03-29 21:53:21 by AA6YQ)