Re: A Primer on DX Keeper?


Abie Alexander
 

Wow! What a comprehensive reply! I have all the information I need to transfer my log.

Many thanks, Dave!

73,

Abie/AB1F - VU2ABE

Mr. Abie Alexander
7919 Mandan Rd #103
Greenbelt, MD 20770-2828
USA

-----Original Message-----
From: DXLab@groups.io <DXLab@groups.io> On Behalf Of Dave AA6YQ
Sent: Sunday, August 23, 2020 03:23
To: ab1f@ymail.com
Cc: DXLab@groups.io
Subject: Re: [DXLab] A Primer on DX Keeper?

+ AA6YQ comments below

Apologies for not posting this query on the forum page. I am sending this direct only because this is a very basic question and the queries that you field are very high level.

+ Queries of all levels are welcome in the DXLab Discussion Group, Abie.


Here is my problem. I have a Paradox log (self-made) going back 33 years and containing 15,513 entries. I exported the log to Excel and using your ingenious ADIF converter program (the best!) I was able to upload the entire log to Winlog32. Everything worked fine.

+ The excellent Excel-to-ADIF conversion technique described here

<https://nam12.safelinks.protection.outlook.com/?url=https:%2F%2Fmembers.storm.ca%2F~ferch%2Fspreadsh.html&;amp;data=02%7C01%7C%7C457191e55d444b14193708d846e5d045%7C84df9e7fe9f640afb435aaaaaaaaaaaa%7C1%7C0%7C637337300133727886&amp;sdata=QwNGIxOhvZqDOicRifjLz1NshqVUkFEiFy6nJQSNqrY%3D&amp;reserved=0>

+ was developed by Rick VE3KI; it has helped many hams.


Then I realized that DX Keeper was far more versatile, and I would like to export the ADIF file from Excel to DX Keeper and use DX Keeper going forward.

I would like to keep track of Japanese JCC/JCG, Korean KDN, Russian RDA awards, and US counties. But maybe my error, I could not
find clear enough instructions on how these codes need to be included in the ADIF file.

Should I create additional fields for these codes (e.g. Ken # and JCC/JCG number, US State and US CTY, etc.) or could I include them all in the QTH field? If so, in what order?

There are over 15,500 entries so I do not want to mess up. Any help will be greatly appreciated.

+ The original ADIF specification was rather biased towards North
+ America: it provided STATE and CNTY fields for US states and
counties respectively, and a VE_PROV field for Canadian provinces. Rather than continue adding unique field names for the administrative subdivisions of countries around the world (JA_PREFECTURE, UA_OBLAST, F_DEPARTMENT, HL_PROVINCE), we instead generalized the STATE field to mean "primary administrative subdivision". The "codes" to be used for each country's primary administrative subdivisions are specified here:

<https://nam12.safelinks.protection.outlook.com/?url=http%3A%2F%2Fadif.org.uk%2F310%2FADIF_310.htm%23Primary_Administrative_Subdivision&;amp;data=02%7C01%7C%7C457191e55d444b14193708d846e5d045%7C84df9e7fe9f640afb435aaaaaaaaaaaa%7C1%7C0%7C637337300133727886&amp;sdata=cMNtKo3r1b%2F%2Fo0JelXiHlPTSF857%2Bihl9D3vaAjb7gg%3D&amp;reserved=0>

+ Thus <DXCC:3>339 <STATE:2>12 specifies the Chiba prefecture in Japan.

+ Similarly, we generalized the CNTY field to mean "secondary administrative subdivision":

<https://nam12.safelinks.protection.outlook.com/?url=http%3A%2F%2Fadif.org.uk%2F310%2FADIF_310.htm%23Secondary_Administrative_Subdivision&;amp;data=02%7C01%7C%7C457191e55d444b14193708d846e5d045%7C84df9e7fe9f640afb435aaaaaaaaaaaa%7C1%7C0%7C637337300133737879&amp;sdata=UiuV2%2Fp1LVuwY96ZJQTgr1jBZ1eQxqvYWuLZe33n%2BDc%3D&amp;reserved=0>

+ Thus <DXCC:3>137 <STATE:1>B <CNTY:3>B24 specifies Sueyoung Gu District in Busan Gwant'yeogsi Province in Korea.

+ Thus you should not employ user-defined fields to record location information for JARL city/gun awards or Korean District Awards.
If the proper codes are present in a Japanese or Korean QSO's STATE and CNTY items, DXKeeper's JARL and KDN progress reports will produce accurate results. For an overview, see

<https://nam12.safelinks.protection.outlook.com/?url=https%3A%2F%2Fwww.dxlabsuite.com%2Fdxkeeper%2FHelp%2FAwardInfo.htm&;amp;data=02%7C01%7C%7C457191e55d444b14193708d846e5d045%7C84df9e7fe9f640afb435aaaaaaaaaaaa%7C1%7C0%7C637337300133737879&amp;sdata=tyK2%2BvWNWZ9oCsVnEWAEEMe2P4gSLMXyzZLsN2%2FtJ0Y%3D&amp;reserved=0>

+ For details, see

<https://nam12.safelinks.protection.outlook.com/?url=https%3A%2F%2Fwww.dxlabsuite.com%2Fdxkeeper%2FHelp%2FProgress.htm%23AP%2520JARL%2520progress%2520reports&;amp;data=02%7C01%7C%7C457191e55d444b14193708d846e5d045%7C84df9e7fe9f640afb435aaaaaaaaaaaa%7C1%7C0%7C637337300133737879&amp;sdata=2IRFe9Hsyx0ndR6ZJUu45qRGGhyA5es6AYrMggNQr00%3D&amp;reserved=0>

+ and

<https://nam12.safelinks.protection.outlook.com/?url=https%3A%2F%2Fwww.dxlabsuite.com%2Fdxkeeper%2FHelp%2FProgress.htm%23AP%2520KDN&;amp;data=02%7C01%7C%7C457191e55d444b14193708d846e5d045%7C84df9e7fe9f640afb435aaaaaaaaaaaa%7C1%7C0%7C637337300133737879&amp;sdata=Hnnj%2FctJDOJDYRuNCA4kP36YhOXv%2FWg8A5TUuvtJ5pU%3D&amp;reserved=0>

+ and

<https://nam12.safelinks.protection.outlook.com/?url=https%3A%2F%2Fwww.dxlabsuite.com%2Fdxkeeper%2FHelp%2FProgress.htm%23AP%2520SRR%2520Russian%2520Oblast%2520reports&;amp;data=02%7C01%7C%7C457191e55d444b14193708d846e5d045%7C84df9e7fe9f640afb435aaaaaaaaaaaa%7C1%7C0%7C637337300133737879&amp;sdata=WMP5d0WXPxR4zGeod6JlYDmsHj0qU8b9VBABhdfgn9o%3D&amp;reserved=0>

73,

Dave, AA6YQ

Join DXLab@groups.io to automatically receive all group messages.