Differences between revisions 3 and 62 (spanning 59 versions)
Revision 3 as of 2009-05-20 23:43:29
Size: 1133
Editor: AA6YQ
Comment:
Revision 62 as of 2020-07-18 15:51:59
Size: 9268
Editor: AA6YQ
Comment:
Deletions are marked like this. Additions are marked like this.
Line 1: Line 1:
=== Importing QSOs === == Importing QSOs ==
Line 4: Line 4:

 1. On the '''Configuration''' window's '''Log''' tab, click the '''Backup''' button; this makes it easy to effectively ''undo'' an import operation if you decide you'd like to import with a different set of options enabled
Line 9: Line 11:
    a. uncheck all boxes except the '''Record import errors in error file''' box, which should be checked     a. uncheck all boxes except

       * the '''Record import errors in error file''' box, which should be checked

       * the '''Check duplicates on import''' box, which should be unchecked to maintain import performance ''unless'' there is any possibility that file you'll be importing contains duplicate QSOs, or contains QSOs already present in the current log
Line 13: Line 19:
 1. click the '''Start''' button in the window's lower-left corner; a standard Windows file selector window name ''ADIF Import'' will appear  1. If the QSOs being imported will require mass modification to fill in missing information or correct erroneous information
Line 15: Line 21:
 1. use the ''ADIF Import'' window to select the ADIF file you wish to import; when you click it's '''Open''' button, DXKeeper will import the contents of the selected file into your log; if errors are encountered during this process, DXKeeper will display a file describing these errors when the import process has completed.     a. review the '''Substitution options''' and '''Replacement options''' panels to see if the modification can be accomplished during the import operation with settings in these panels

    a. if the modification can't be accomplished during the import operation

       i. click the '''Clear Select''' button at the bottom of the '''Import QSOs''' tab

       i. check the '''Set Select in imported QSOs to Y''' box in the tab's upper-right corner

 1. click the '''Start''' button in the window's lower-left corner; a standard Windows file selector window name '''ADIF Import''' will appear

 1. use the '''ADIF Import''' window to select the ADIF file you wish to import; when you click it's '''Open''' button, DXKeeper will import the contents of the selected file into your log; if errors are encountered during this process, DXKeeper will display a file describing these errors when the import process has completed.

 1. if you checked the '''Set Select in imported QSOs to Y''' box in step 4.b above, then on the Main window's '''Log QSOs''' panel, click the '''Filter''' panel's '''Sel''' button; the '''Log Page Display''' will filtered to contain only the QSOs you imported, making it easy to [[QSOModifying|make modifications that apply to each of them]]

Specific instructions for importing QSOs exported by [[http://n1mm.hamdocs.com/tiki-index.php|N1MM]] are [[ImportN1MM|here]].

DXKeeper can also [[http://www.dxlabsuite.com/dxkeeper/Help/Import.htm#Importing%20tab-delimited%20files|import QSOs from a tab-delimited file]], which can be created from a spreadsheet application.

An imported record that does not specify both a '''Callsign''' and a '''QSO Begin''' date and time will be reported as ''illegal'', and rejected. All other imported records will result in the creation of a logged QSO; if the logged QSO contains [[https://www.dxlabsuite.com/dxkeeper/Help/LogIntegrity.htm|fatal or non-fatal errors]], the errors will be reported, and the QSO will be considered ''broken''.

There are three primary issues when importing an ADIF log exported by another
logging application:

 * recovering each QSO's DXCC entity

 * importing QSOs made from different locations

 * synchronizing with the ARRL's [[http://www.arrl.org/lotw/|Logbook of the World (LotW)]]
Line 18: Line 51:
=== Recovering each QSO's DXCC entity ===

The '''ARRL''' defines a unique, immutable '''Entity Code''' for each DXCC entity in
[[http://www.arrl.org/files/file/DXCC/dxcclist.txt]]

The [[http://www.dxlabsuite.com/ADIF.htm|ADIF specification]] provides a tag named '''DXCC''' to convey each QSO's '''Entity Code'''. If your ADIF file
specifies a '''DXCC''' tag for each QSO, then DXKeeper will accurately recover the DXCC entity you logged with each of your QSOs with no additional action required on your part.

Unfortunately, some logging applications do not include the DXCC tag in exported ADIF files. When DXKeeper imports an ADIF record that doesn't specify an Entity Code, it determines the QSO's DXCC entity by analyzing the callsign -- using ''today's'' callsign-to-entity rules. If you logged a QSO with KA1DX back in 1952, and your logging application exports this QSO without the Entity Code for Minami Torishima (which in ADIF would be '''<DXCC:3>177'''), then DXKeeper will assign the imported QSO's DXCC entity to be the continental US (Entity Code 291). To automate the correction of such QSO's, Joe W4TV created a set of '''Fix''' scripts that inspect each QSO in DXKeeper's log, apply the callsign-to-entity rules ''in force as of the date of the QSO'', and if appropriate modify the QSO's DXCC entity, CQ zone, ITU zone, Continent, and IOTA tag. You'll find these scripts in DXKeeper's '''Scripts''' sub-folder:

 * FIX_EU.txt
 * FIX_USSR.txt
 * FIX_KH.txt
 * FIX_MISC.txt

To run a script, click the button labeled '''~''' in the '''Filter''' panel at the bottom of the '''Main''' window's '''Log QSOs''' tab; this will cause a '''Scripts''' button to
appear. Click the Scripts button, and use the resulting '''Run Script''' window to navigate to DXKeeper's Scripts sub-folder and select the Fix script you wish to run.

If you select a script that potentially modifies your QSOs (as all Fix scripts do), you'll be given the opportunity to make a log backup before running the
script; agreeing to create such backups is a good idea. After a script runs, DXKeeper will display a report that summarizes the changes made. More
information about Scripts can be found in [[http://www.dxlabsuite.com/dxkeeper/Help/Scripts.htm]], or by clicking one of DXKeeper's '''Help''' buttons and navigating to the '''Filtering, Modifying, and Reporting with Scripts''' topic in the '''Logging and Managing QSOs''' section.

=== Importing QSOs made from Multiple Locations ===

 1. [[http://www.dxlabsuite.com/dxkeeper/Help/MultipleQTHs.htm|Define a My QTH]] for each location from which you have operated

 1. to Import an ADIF file containing QSOs all made from the same location with the same ''Station Callsign'',

   a. on the Main window's '''Import QSOs''' tab,

     i. in the '''Replacement options''' panel, check the box to the left of '''Station Callsign''', and specify the appropriate Station Callsign in the textbox to the right of of '''Station Callsign'''

     i. in the '''Substitution options''' panel, check the box to the left of '''Substitute for missing QTH identifiers''', and use the selector to the right to choose the appropriate ''my QTH ID''

   a. proceed with the Import procedure described above

 1. after all ADIF files have been imported, on the Main window's '''Import QSOs''' tab,

   a. in the '''Replacement options''' panel, check the box to the left of '''Station Callsign'''

   a. in the '''Substitution options''' panel, check the box to the left of '''Substitute for missing QTH identifiers'''

=== Importing Fields not Supported by DXKeeper ===

DXKeeper can record more than 100 items with each QSO, but not every field defined in [[http://www.adif.org.uk/304/ADIF_304.htm|ADIF]] is included. DXKeeper does provide 8 [[http://www.dxlabsuite.com/dxkeeper/Help/Configuration.htm#User Items tab|user-defined items]] that you can employ as you wish. If you enable a user-defined item's '''ADIF''' setting, then when importing an ADIF file, any field whose name matches that user-defined item's '''Caption''' will be imported into that user-defined field. For example, you could setup user-defined item #1 with a '''Caption''' of {{{SOTA_REF}}} and enable its '''ADIF''' setting on the Configuration window's '''User Items''' tab. Then the information in {{{SOTA_REF}}} fields within an ADIF file being imported would be placed in each QSO's user-defined item #1, which would be labeled '''SOTA_REF'''. When subsequently exporting an ADIF file from such QSOs, the information in user-defined item #1 would be exported in a {{{SOTA_REF}}} field.

=== Synchronizing with LotW ===

Increasingly, logging applications are tracking ''LotW status'' independently of ''hardcopy QSL card status'' for each QSO. ADIF was slow to define a standard way to do this, so many logging applications defined "private" tags for this purpose. DXKeeper can read the private LotW status tags exported by [[http://www.logger32.net|Logger32]] and [[http://www.dx4win.com|DX4WIN]], but there's an alternative: direct DXKeeper to review '''all''' of the QSOs you've uploaded to LotW and '''all''' of the QSLs that LotW has generated in your account, and to then update your logged QSOs to reflect the status information reported by LotW. Step-by-step directions for doing this are provided in [[QSOsAlreadyUploadedLotW|Handling QSOs already uploaded to LotW]]; before doing this, you must first [[ConfigureLotW|Configure DXKeeper for Interaction with LotW]].
Line 21: Line 103:
[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 23: Line 105:
["Logging"] [[ADIFModesSubmodes|Importing and Exporting ADIF Modes and Submodes]]
Line 25: Line 107:
[:GettingStarted:Getting Started with DXLab] [[SwitchingToDXKeeper|Switching to DXKeeper from Another Logging Application]]

[[Logging]]

[[GettingStarted|Getting Started with DXLab]]

Importing QSOs

To import QSOs from an ADIF file,

  1. On the Configuration window's Log tab, click the Backup button; this makes it easy to effectively undo an import operation if you decide you'd like to import with a different set of options enabled

  2. Select the Main window's Import QSOs tab

  3. in the Options panel,

    1. uncheck all boxes except
      • the Record import errors in error file box, which should be checked

      • the Check duplicates on import box, which should be unchecked to maintain import performance unless there is any possibility that file you'll be importing contains duplicate QSOs, or contains QSOs already present in the current log

    2. set the ADIF style options panel to Import standard ADIF unless your ADIF file was generated by one of the applications listed in this panel, in which case you should select that application

  4. If the QSOs being imported will require mass modification to fill in missing information or correct erroneous information
    1. review the Substitution options and Replacement options panels to see if the modification can be accomplished during the import operation with settings in these panels

    2. if the modification can't be accomplished during the import operation
      1. click the Clear Select button at the bottom of the Import QSOs tab

      2. check the Set Select in imported QSOs to Y box in the tab's upper-right corner

  5. click the Start button in the window's lower-left corner; a standard Windows file selector window name ADIF Import will appear

  6. use the ADIF Import window to select the ADIF file you wish to import; when you click it's Open button, DXKeeper will import the contents of the selected file into your log; if errors are encountered during this process, DXKeeper will display a file describing these errors when the import process has completed.

  7. if you checked the Set Select in imported QSOs to Y box in step 4.b above, then on the Main window's Log QSOs panel, click the Filter panel's Sel button; the Log Page Display will filtered to contain only the QSOs you imported, making it easy to make modifications that apply to each of them

Specific instructions for importing QSOs exported by N1MM are here.

DXKeeper can also import QSOs from a tab-delimited file, which can be created from a spreadsheet application.

An imported record that does not specify both a Callsign and a QSO Begin date and time will be reported as illegal, and rejected. All other imported records will result in the creation of a logged QSO; if the logged QSO contains fatal or non-fatal errors, the errors will be reported, and the QSO will be considered broken.

There are three primary issues when importing an ADIF log exported by another logging application:

  • recovering each QSO's DXCC entity
  • importing QSOs made from different locations
  • synchronizing with the ARRL's Logbook of the World (LotW)

Recovering each QSO's DXCC entity

The ARRL defines a unique, immutable Entity Code for each DXCC entity in http://www.arrl.org/files/file/DXCC/dxcclist.txt

The ADIF specification provides a tag named DXCC to convey each QSO's Entity Code. If your ADIF file specifies a DXCC tag for each QSO, then DXKeeper will accurately recover the DXCC entity you logged with each of your QSOs with no additional action required on your part.

Unfortunately, some logging applications do not include the DXCC tag in exported ADIF files. When DXKeeper imports an ADIF record that doesn't specify an Entity Code, it determines the QSO's DXCC entity by analyzing the callsign -- using today's callsign-to-entity rules. If you logged a QSO with KA1DX back in 1952, and your logging application exports this QSO without the Entity Code for Minami Torishima (which in ADIF would be <DXCC:3>177), then DXKeeper will assign the imported QSO's DXCC entity to be the continental US (Entity Code 291). To automate the correction of such QSO's, Joe W4TV created a set of Fix scripts that inspect each QSO in DXKeeper's log, apply the callsign-to-entity rules in force as of the date of the QSO, and if appropriate modify the QSO's DXCC entity, CQ zone, ITU zone, Continent, and IOTA tag. You'll find these scripts in DXKeeper's Scripts sub-folder:

  • FIX_EU.txt
  • FIX_USSR.txt
  • FIX_KH.txt
  • FIX_MISC.txt

To run a script, click the button labeled ~ in the Filter panel at the bottom of the Main window's Log QSOs tab; this will cause a Scripts button to appear. Click the Scripts button, and use the resulting Run Script window to navigate to DXKeeper's Scripts sub-folder and select the Fix script you wish to run.

If you select a script that potentially modifies your QSOs (as all Fix scripts do), you'll be given the opportunity to make a log backup before running the script; agreeing to create such backups is a good idea. After a script runs, DXKeeper will display a report that summarizes the changes made. More information about Scripts can be found in http://www.dxlabsuite.com/dxkeeper/Help/Scripts.htm, or by clicking one of DXKeeper's Help buttons and navigating to the Filtering, Modifying, and Reporting with Scripts topic in the Logging and Managing QSOs section.

Importing QSOs made from Multiple Locations

  1. Define a My QTH for each location from which you have operated

  2. to Import an ADIF file containing QSOs all made from the same location with the same Station Callsign,

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

      1. in the Replacement options panel, check the box to the left of Station Callsign, and specify the appropriate Station Callsign in the textbox to the right of of Station Callsign

      2. in the Substitution options panel, check the box to the left of Substitute for missing QTH identifiers, and use the selector to the right to choose the appropriate my QTH ID

    2. proceed with the Import procedure described above
  3. after all ADIF files have been imported, on the Main window's Import QSOs tab,

    1. in the Replacement options panel, check the box to the left of Station Callsign

    2. in the Substitution options panel, check the box to the left of Substitute for missing QTH identifiers

Importing Fields not Supported by DXKeeper

DXKeeper can record more than 100 items with each QSO, but not every field defined in ADIF is included. DXKeeper does provide 8 user-defined items that you can employ as you wish. If you enable a user-defined item's ADIF setting, then when importing an ADIF file, any field whose name matches that user-defined item's Caption will be imported into that user-defined field. For example, you could setup user-defined item #1 with a Caption of SOTA_REF and enable its ADIF setting on the Configuration window's User Items tab. Then the information in SOTA_REF fields within an ADIF file being imported would be placed in each QSO's user-defined item #1, which would be labeled SOTA_REF. When subsequently exporting an ADIF file from such QSOs, the information in user-defined item #1 would be exported in a SOTA_REF field.

Synchronizing with LotW

Increasingly, logging applications are tracking LotW status independently of hardcopy QSL card status for each QSO. ADIF was slow to define a standard way to do this, so many logging applications defined "private" tags for this purpose. DXKeeper can read the private LotW status tags exported by Logger32 and DX4WIN, but there's an alternative: direct DXKeeper to review all of the QSOs you've uploaded to LotW and all of the QSLs that LotW has generated in your account, and to then update your logged QSOs to reflect the status information reported by LotW. Step-by-step directions for doing this are provided in Handling QSOs already uploaded to LotW; before doing this, you must first Configure DXKeeper for Interaction with LotW.


Post a question or suggestion on the DXLab Discussion Group

Importing and Exporting ADIF Modes and Submodes

Switching to DXKeeper from Another Logging Application

Logging

Getting Started with DXLab

QSOImport (last edited 2020-07-18 15:51:59 by AA6YQ)