Keyboard Shortcuts
ctrl + shift + ? :
Show all keyboard shortcuts
ctrl + g :
Navigate to a group
ctrl + shift + f :
Find
ctrl + / :
Quick actions
esc to dismiss
Likes
Search
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:Ian Scott wrote: Greetings! New member here. k1oIq. |
--- In dxlab@..., Ian Scott <thole42@...> wrote:AA6YQ comments below 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...Welcome! 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 73,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. 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
toggle quoted message
Show quoted text
- 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:
|
Dave,
toggle quoted message
Show quoted text
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: --- In dxlab@..., Ian Scott <thole42@...> wrote:AA6YQ comments below --
Read The Patriot Post hppt://PatriotPost.US/Subscribe/ Vetitas vos Liberabit |
-----Original Message-----AA6YQ comments below 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? imported to an email message and send it to me at aa6yq@... so II suspect that's a defect. Could you attach the tab-delimited file you 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? you doing the concatenation?I just checked the & operator, and it doesn't seem to do that. How are 73, Dave, AA6YQ |
to navigate to use esc to dismiss