Page 1 of 1

Import CSV into SOTA QSO database

Posted: 22 Nov 2014, 22:33
by VK2KTT
Hi all.
Just started to use Log40M.

I have contacts in the SOTA log database (in the UK) & would like to import or merge these CSV files (only CSV available) into my existing files in Log40M. Is this possible?? If not, What about a conversion program?.
Thanks
Paul
VK2KTT

Re: Import CSV into SOTA QSO database

Posted: 22 Nov 2014, 22:39
by G4POP
Do the QSO's that you will download from the SOTA website already exist in you Log4om database or are they new QSO's

Re: Import CSV into SOTA QSO database

Posted: 22 Nov 2014, 22:54
by VK2KTT
Thanks for the fast reply..
No these are new CSV contacts.
As I have just started to use Log40M, I have a few new contacts in Log40M & 1,800 on the soto database.. A bit to many to enter by hand.
Paul
VK2KTT

Re: Import CSV into SOTA QSO database

Posted: 22 Nov 2014, 23:06
by G4POP
Paul,
The facility in Log4om only merges a SOTA CSV with an existing QSO to update the SOTA ref for the contact.

We don't have a system for importing a CSV file of new QSO's

You need a CSV to ADIF converter and then import the ADIF file into Log4om

Try http://www.on6zq.be/w/index.php/SOTA/SOTA2ADIF

Re: Import CSV into SOTA QSO database

Posted: 22 Nov 2014, 23:15
by VK2KTT
Thanks terry
Will try this & give you a reply later.
May be a feature you could add later??
Paul
Vk2KTT

Re: Import CSV into SOTA QSO database

Posted: 23 Nov 2014, 10:58
by VK2KTT
Hi Terry.
I did try the conversion program.. it looked to work ok.. but left a lot of info out like date & country on Recent QSO tab.
And on Edit QSO all SOTA information was missing, The Band was missing as well as the comments.
Any clues Terry?
Paul
VK2KTT

Re: Import CSV into SOTA QSO database

Posted: 23 Nov 2014, 11:03
by G4POP
VK2KTT wrote:Hi Terry.
I did try the conversion program.. it looked to work ok.. but left a lot of info out like date & country on Recent QSO tab.
And on Edit QSO all SOTA information was missing, The Band was missing as well as the comments.
Any clues Terry?
Paul
VK2KTT

Thats the reason we did not include an import only a merge - missing data!

Please email me your SOTA download csv and I will see what can be done

Re: Import CSV into SOTA QSO database

Posted: 23 Nov 2014, 21:17
by IW3HMH
but, again, csv from SOTA aren't enough to rebuild basic informations for QSO...

Re: Import CSV into SOTA QSO database

Posted: 24 Nov 2014, 19:50
by G4POP
I manually converted Paul's SOTA.CSV file into an ADIF file and he was able to successfully import it into Log4om so I think he is happy! :D