¿ªÔÆÌåÓý

ctrl + shift + ? for shortcuts
© 2025 Groups.io

eXcel to DXKeeper


 

Greetings! New member here. k1oIq.

I'm thinking of getting involved with this programme to use in conjunction with eQSL. But first, I have an existing log...

Can DXKeeper import an existing QSL database from eXcel?

--ajo

Why do we wear clothes, Kim asked, when it feels so good to
have air all over you? To keep people from going crazy
looking at you , Anders said. --Guy Davenport


Michael Morgan
 

If you look at this page
there are notes towards the bottom on importing a tab delimited file which
can easily be made in excel.



Michael, AA5SH



From: dxlab@... [mailto:dxlab@...] On Behalf Of Ian
Scott
Sent: Thursday, September 10, 2009 9:36 AM
To: dxlab@...
Subject: [dxlab] eXcel to DXKeeper





Greetings! New member here. k1oIq.

I'm thinking of getting involved with this programme to use in conjunction
with eQSL. But first, I have an existing log...

Can DXKeeper import an existing QSL database from eXcel?

--ajo

Why do we wear clothes, Kim asked, when it feels so good to
have air all over you? To keep people from going crazy
looking at you , Anders said. --Guy Davenport


 

Yes, but you have to do a little work to convert your spreadsheet data to ADIF. The following is a good place to start and this is posted in the FAQ section of eQSL.cc under the general questions category.

Rich VE3IAY has provided a straightforward approach to generating ADIF from Microsoft Works 97, Lotus 123 v.5 and Microsoft Excel 2002 spreadsheets. It's likely that the same approach can be adapted to other spreadsheet programs or versions. See:

<>

A sample Excel spreadsheet is available from

Before attempting to use this approach be sure to have a good understanding of ADIF fromat.

A copy of the current ADIF standard specification is available at

Ian Scott wrote:
Greetings! New member here. k1oIq.

I'm thinking of getting involved with this programme to use in conjunction with eQSL. But first, I have an existing log...

Can DXKeeper import an existing QSL database from eXcel?

--ajo

Why do we wear clothes, Kim asked, when it feels so good to
have air all over you? To keep people from going crazy
looking at you , Anders said. --Guy Davenport





------------------------------------

Yahoo! Groups Links







 

AA6YQ comments below
--- In dxlab@..., Ian Scott <thole42@...> wrote:

Greetings! New member here. k1oIq.

Welcome!
I'm thinking of getting involved with this programme to use in conjunction with eQSL. But first, I have an existing log...

Can DXKeeper import an existing QSL database from eXcel?

DXKeeper cannot directly import an Excel spreadsheet, but it can import a comma-delimited file that conforms to a specific set of rules, as described in
<>

In general, you can produce generate this comma-delimited file from your Excel spreadsheet by adding a new worksheet and populating it with formulae that put the data in the required format. If you need help with this, please let me know.
73,

Dave, AA6YQ


 

It's no longer necessary to convert spreadsheet data to ADIF. DXKeeper can now directly import a comma-delimited file as long as it

- provides a header row that specifies the field order

- presents the data in ADIF-compatible formats

73,

Dave, AA6YQ

--- In dxlab@..., Rich - W3ZJ <rich@...> wrote:

Yes, but you have to do a little work to convert your spreadsheet data
to ADIF. The following is a good place to start and this is posted in
the FAQ section of eQSL.cc under the general questions category.

Rich VE3IAY has provided a straightforward approach to generating ADIF
from Microsoft Works 97, Lotus 123 v.5 and Microsoft Excel 2002
spreadsheets. It's likely that the same approach can be adapted to
other spreadsheet programs or versions. See:


<>

A sample Excel spreadsheet is available from

Before attempting to
use this approach be sure to have a good understanding of ADIF fromat.

A copy of the current ADIF standard specification is available at

Ian Scott wrote:
Greetings! New member here. k1oIq.

I'm thinking of getting involved with this programme to use in conjunction with eQSL. But first, I have an existing log...

Can DXKeeper import an existing QSL database from eXcel?

--ajo

Why do we wear clothes, Kim asked, when it feels so good to
have air all over you? To keep people from going crazy
looking at you , Anders said. --Guy Davenport





------------------------------------

Yahoo! Groups Links







 

Dave,

Thought I'd try importing as you describe below but from a tab-delimited text file (I didn't see any reference to a comma-delimited import on the linked web page).

The import seems to work . . . excepting this curiousity . . . I have a column titled MODE and all the rows under it are filled with CW. It ignores the column. If I change the title to mode (lower case), it works. Wonder why?

On a separate but related issue, Excel puts double quotes around the comment fields when I view the exported text file in Notepad. The double quotes then show up in DXKeeper's comment field. The comment fields are Excel formulas which concatenate several other fields. Does the concatenation operator trigger the double quotes?

Thanks.

Steve K8JQ

aa6yq wrote:

AA6YQ comments below
--- In dxlab@..., Ian Scott <thole42@...> wrote:

Greetings! New member here. k1oIq.


Welcome!
I'm thinking of getting involved with this programme to use in conjunction with eQSL. But first, I have an existing log...

Can DXKeeper import an existing QSL database from eXcel?


DXKeeper cannot directly import an Excel spreadsheet, but it can import a comma-delimited file that conforms to a specific set of rules, as described in
<>


In general, you can produce generate this comma-delimited file from your Excel spreadsheet by adding a new worksheet and populating it with formulae that put the data in the required format. If you need help with this, please let me know.
73,

Dave, AA6YQ



------------------------------------

Yahoo! Groups Links




--
Read The Patriot Post
hppt://PatriotPost.US/Subscribe/ Vetitas vos Liberabit


 

AA6YQ comments below
-----Original Message-----
From: dxlab@... [mailto:dxlab@...]On Behalf Of
Steve
Sent: Monday, September 14, 2009 7:15 PM
To: dxlab@...
Subject: Re: [dxlab] Re: eXcel to DXKeeper


Dave,

Thought I'd try importing as you describe below but from a tab-delimited
text file (I didn't see any reference to a comma-delimited import on the
linked web page).

The import seems to work . . . excepting this curiousity . . . I have a
column titled MODE and all the rows under it are filled with CW. It
ignores the column. If I change the title to mode (lower case), it
works. Wonder why?

I suspect that's a defect. Could you attach the tab-delimited file you
imported to an email message and send it to me at aa6yq@... so I
can see what's happening? Thanks...


On a separate but related issue, Excel puts double quotes around the
comment fields when I view the exported text file in Notepad. The double
quotes then show up in DXKeeper's comment field. The comment fields are
Excel formulas which concatenate several other fields. Does the
concatenation operator trigger the double quotes?

I just checked the & operator, and it doesn't seem to do that. How are
you doing the concatenation?

73,

Dave, AA6YQ