Importing Log into DXKeeper


Abie Alexander
 

Hi,

 

I’m having a hard time importing my old log into DXKeeper. Tried many times without success. Finally reworked the Excel and converted to ADI. It would not accept.

 

Then attempted to upload the same file as a tab delimited *.txt file. Got the following error message:

 

Illegal - too many fields in record:"

 

These are the fields in my log that I am trying to upload. What am I doing wrong?

 

 

 

Here is a sample record from the log.

 

<QSO_date:8>20000909    <Time_On:4>0154   <Time_Off:4>0156      <Freq:6>21.195    <Band:2>15  <Mode:3>SSB <Tx_Pwr:2>50      <Call:6>JG1PED    <RST_sent:2>59    <RST_rcvd:2>59      <Name:4>TONY      <QTH:8>YOKOHAMA   <State:2>11 <Cnty:4>1101      <Comment:0> <QSL_sent:1>X     <QSL_rcvd:1>-      <Station_Callsign:6>VU2ABE    <eor>

 

There are 15,513 entries. So manual entry is out of the question. I am re-starting the hobby after a 16-year gap and want to begin with DXKeeper in place.

 

Any help would be greatly appreciated! Thanks!

 

73,

 

Abie/AB1F – VU2ABE

 


Dave AA6YQ
 

+ AA6YQ comments below

I'm having a hard time importing my old log into DXKeeper. Tried many times without success. Finally reworked the Excel and
converted to ADI. It would not accept.

+ Is your "old log" in Excel or in ADIF format?

Then attempted to upload the same file as a tab delimited *.txt file. Got the following error message:

"Illegal - too many fields in record:"

These are the fields in my log that I am trying to upload. What am I doing wrong?

Here is a sample record from the log.

<QSO_date:8>20000909 <Time_On:4>0154 <Time_Off:4>0156 <Freq:6>21.195 <Band:2>15 <Mode:3>SSB <Tx_Pwr:2>50
<Call:6>JG1PED <RST_sent:2>59 <RST_rcvd:2>59 <Name:4>TONY <QTH:8>YOKOHAMA <State:2>11 <Cnty:4>1101
<Comment:0> <QSL_sent:1>X <QSL_rcvd:1>- <Station_Callsign:6>VU2ABE <eor>

+ When I direct DXKeeper to import that record, the result is

"Illegal - imported frequency 21.195 doesn't match imported band 15"

+ That's because <Band:2>15 is not a valid ADIF field. The QSO is imported into DXKeeper, but with its "tx band" item empty, and
the "tx band" label flashing in red font (meaning "either select a valid band, or delete this QSO).

As you can see from the "Band enumeration" in the ADIF specification

<http://adif.org.uk/310/ADIF_310.htm#Band_Enumeration>

+ the correct specification for 15 meters is

<Band:3>15m

+ Correcting the band field enables DXKeeper to import the record without error. However,

<QSL_sent:1>X

+ and

<QSL_rcvd:1>-

+ are invalid. As shown in the ADIF specification

<http://adif.org.uk/310/ADIF_310.htm#QSLSent_Enumeration>

X is not a valid choice for QSL_sent, and hyphen is not a valid choice for QSL_rcvd. Unlike Band, which DXKeeper considers critical,
neither QSL_sent nor QSL_rcvd are considered critical, so they are simply ignored. Typically, one corrects problems like this in the
ADIF file "en masse" with a text editor (after making a backup copy of your original file). For example, you would change all
instances of

<QSL_sent:1>X

+ to whichever of the valid QSL_sent choices describe what "X" meant in your previous logging application:

<http://adif.org.uk/310/ADIF_310.htm#QSLSent_Enumeration>

+ Similarly, you'd change all instances of

<QSL_rcvd:1>-

+ to the appropriate choice from among these candidates:

<http://adif.org.uk/310/ADIF_310.htm#QSLRcvd_Enumeration>

+ For context, I suggest that you review these two articles:

<https://www.dxlabsuite.com/dxlabwiki/QSOImport>

<https://www.dxlabsuite.com/dxlabwiki/SwitchingToDXKeeper>

73,

Dave, AA6YQ


Abie Alexander
 

Thanks a million, Dave!

73,

Abie/AB1F - VU2ABE

-----Original Message-----
From: DXLab@groups.io <DXLab@groups.io> On Behalf Of Dave AA6YQ
Sent: Saturday, September 5, 2020 10:34
To: DXLab@groups.io
Subject: Re: [DXLab] Importing Log into DXKeeper

+ AA6YQ comments below

I'm having a hard time importing my old log into DXKeeper. Tried many times without success. Finally reworked the Excel and converted to ADI. It would not accept.

+ Is your "old log" in Excel or in ADIF format?

Then attempted to upload the same file as a tab delimited *.txt file. Got the following error message:

"Illegal - too many fields in record:"

These are the fields in my log that I am trying to upload. What am I doing wrong?

Here is a sample record from the log.

<QSO_date:8>20000909 <Time_On:4>0154 <Time_Off:4>0156 <Freq:6>21.195 <Band:2>15 <Mode:3>SSB <Tx_Pwr:2>50
<Call:6>JG1PED <RST_sent:2>59 <RST_rcvd:2>59 <Name:4>TONY <QTH:8>YOKOHAMA <State:2>11 <Cnty:4>1101
<Comment:0> <QSL_sent:1>X <QSL_rcvd:1>- <Station_Callsign:6>VU2ABE <eor>

+ When I direct DXKeeper to import that record, the result is

"Illegal - imported frequency 21.195 doesn't match imported band 15"

+ That's because <Band:2>15 is not a valid ADIF field. The QSO is
+ imported into DXKeeper, but with its "tx band" item empty, and
the "tx band" label flashing in red font (meaning "either select a valid band, or delete this QSO).

As you can see from the "Band enumeration" in the ADIF specification

<https://eur04.safelinks.protection.outlook.com/?url=http%3A%2F%2Fadif.org.uk%2F310%2FADIF_310.htm%23Band_Enumeration&;data=02%7C01%7C%7Ce94135d10e9448578f6608d851592341%7C84df9e7fe9f640afb435aaaaaaaaaaaa%7C1%7C0%7C637348790565553927&amp;sdata=Up6o0MOSUyA%2BT6l2bMnfLZ3wlVQJawFVF8gXZy3o6cU%3D&amp;reserved=0>

+ the correct specification for 15 meters is

<Band:3>15m

+ Correcting the band field enables DXKeeper to import the record
+ without error. However,

<QSL_sent:1>X

+ and

<QSL_rcvd:1>-

+ are invalid. As shown in the ADIF specification

<https://eur04.safelinks.protection.outlook.com/?url=http%3A%2F%2Fadif.org.uk%2F310%2FADIF_310.htm%23QSLSent_Enumeration&;data=02%7C01%7C%7Ce94135d10e9448578f6608d851592341%7C84df9e7fe9f640afb435aaaaaaaaaaaa%7C1%7C0%7C637348790565553927&amp;sdata=Fzzq%2B4kOjjP7xjiUl8WByd6zuyRa8fFMgP0Yb6PXhz4%3D&amp;reserved=0>

X is not a valid choice for QSL_sent, and hyphen is not a valid choice for QSL_rcvd. Unlike Band, which DXKeeper considers critical, neither QSL_sent nor QSL_rcvd are considered critical, so they are simply ignored. Typically, one corrects problems like this in the ADIF file "en masse" with a text editor (after making a backup copy of your original file). For example, you would change all instances of

<QSL_sent:1>X

+ to whichever of the valid QSL_sent choices describe what "X" meant in your previous logging application:

<https://eur04.safelinks.protection.outlook.com/?url=http%3A%2F%2Fadif.org.uk%2F310%2FADIF_310.htm%23QSLSent_Enumeration&;data=02%7C01%7C%7Ce94135d10e9448578f6608d851592341%7C84df9e7fe9f640afb435aaaaaaaaaaaa%7C1%7C0%7C637348790565553927&amp;sdata=Fzzq%2B4kOjjP7xjiUl8WByd6zuyRa8fFMgP0Yb6PXhz4%3D&amp;reserved=0>

+ Similarly, you'd change all instances of

<QSL_rcvd:1>-

+ to the appropriate choice from among these candidates:

<https://eur04.safelinks.protection.outlook.com/?url=http%3A%2F%2Fadif.org.uk%2F310%2FADIF_310.htm%23QSLRcvd_Enumeration&;data=02%7C01%7C%7Ce94135d10e9448578f6608d851592341%7C84df9e7fe9f640afb435aaaaaaaaaaaa%7C1%7C0%7C637348790565553927&amp;sdata=ttdSuN6z9J1T3XuwDu93JuHqA8fYT%2FENPY9XbMM0d74%3D&amp;reserved=0>

+ For context, I suggest that you review these two articles:

<https://eur04.safelinks.protection.outlook.com/?url=https%3A%2F%2Fwww.dxlabsuite.com%2Fdxlabwiki%2FQSOImport&;data=02%7C01%7C%7Ce94135d10e9448578f6608d851592341%7C84df9e7fe9f640afb435aaaaaaaaaaaa%7C1%7C0%7C637348790565553927&amp;sdata=8E6CRSIZ%2Fy1IjABiZqKQI1a8yPoyTCkvHZRY%2Fa7E0q0%3D&amp;reserved=0>

<https://eur04.safelinks.protection.outlook.com/?url=https%3A%2F%2Fwww.dxlabsuite.com%2Fdxlabwiki%2FSwitchingToDXKeeper&;data=02%7C01%7C%7Ce94135d10e9448578f6608d851592341%7C84df9e7fe9f640afb435aaaaaaaaaaaa%7C1%7C0%7C637348790565553927&amp;sdata=64RcF7qaGdR1AA3ZpQKBG%2BArYyppsTMClcTLrBI2L70%3D&amp;reserved=0>

73,

Dave, AA6YQ


Dave AA6YQ
 

* more AA6YQ comments below

Thanks a million, Dave!

* Are you now able to import your ADIF file?

* Incidentally, the "Illegal - too many fields in record" error message is only displayed when DXKeeper is importing a tab-delimited
file, not an ADIF file.

73,

Dave, AA6YQ


Joe Subich, W4TV
 

+ are invalid. As shown in the ADIF specification

<http://adif.org.uk/310/ADIF_310.htm#QSLSent_Enumeration>
Although not applicable in this discussion, ADIF 3.1.1 has
approved and released on 2 September:
<https://adif.org/311/ADIF_311_annotated.htm>

These changes from the previous version may necessitate application code or data changes:
Addition of the FST4 submode to the MFSK mode in the Mode and Submode Enumerations.
Addition of the 5m and 8m bands to the Band Enumeration.
Addition of ARRL-10-GHZ and WW-DIGI to the Contest-ID Enumeration.

73,

... Joe, W4TV


On 2020-09-05 1:03 AM, Dave AA6YQ wrote:
+ AA6YQ comments below
I'm having a hard time importing my old log into DXKeeper. Tried many times without success. Finally reworked the Excel and
converted to ADI. It would not accept.
+ Is your "old log" in Excel or in ADIF format?
Then attempted to upload the same file as a tab delimited *.txt file. Got the following error message:
"Illegal - too many fields in record:"
These are the fields in my log that I am trying to upload. What am I doing wrong?
Here is a sample record from the log.
<QSO_date:8>20000909 <Time_On:4>0154 <Time_Off:4>0156 <Freq:6>21.195 <Band:2>15 <Mode:3>SSB <Tx_Pwr:2>50
<Call:6>JG1PED <RST_sent:2>59 <RST_rcvd:2>59 <Name:4>TONY <QTH:8>YOKOHAMA <State:2>11 <Cnty:4>1101
<Comment:0> <QSL_sent:1>X <QSL_rcvd:1>- <Station_Callsign:6>VU2ABE <eor>
+ When I direct DXKeeper to import that record, the result is
"Illegal - imported frequency 21.195 doesn't match imported band 15"
+ That's because <Band:2>15 is not a valid ADIF field. The QSO is imported into DXKeeper, but with its "tx band" item empty, and
the "tx band" label flashing in red font (meaning "either select a valid band, or delete this QSO).
As you can see from the "Band enumeration" in the ADIF specification
<http://adif.org.uk/310/ADIF_310.htm#Band_Enumeration>
+ the correct specification for 15 meters is
<Band:3>15m
+ Correcting the band field enables DXKeeper to import the record without error. However,
<QSL_sent:1>X
+ and
<QSL_rcvd:1>-
+ are invalid. As shown in the ADIF specification
<http://adif.org.uk/310/ADIF_310.htm#QSLSent_Enumeration>
X is not a valid choice for QSL_sent, and hyphen is not a valid choice for QSL_rcvd. Unlike Band, which DXKeeper considers critical,
neither QSL_sent nor QSL_rcvd are considered critical, so they are simply ignored. Typically, one corrects problems like this in the
ADIF file "en masse" with a text editor (after making a backup copy of your original file). For example, you would change all
instances of
<QSL_sent:1>X
+ to whichever of the valid QSL_sent choices describe what "X" meant in your previous logging application:
<http://adif.org.uk/310/ADIF_310.htm#QSLSent_Enumeration>
+ Similarly, you'd change all instances of
<QSL_rcvd:1>-
+ to the appropriate choice from among these candidates:
<http://adif.org.uk/310/ADIF_310.htm#QSLRcvd_Enumeration>
+ For context, I suggest that you review these two articles:
<https://www.dxlabsuite.com/dxlabwiki/QSOImport>
<https://www.dxlabsuite.com/dxlabwiki/SwitchingToDXKeeper>
73,
Dave, AA6YQ