SOTAdata CSV export to ADIF conversion?

Old Reflector
1

Can anyone post step-by-step instructions to convert a SOTAdata exported CSV log into ADIF format?

Thanks & 73,
Barry N1EU

2

In reply to N1EU:

Barry,

It would be pretty easy to write a program to do that. The program would read a line out of the CSV log file, parse out the individual fields, then concatenate them into a string with the ADIF field tags inserted. That string would get written to the output file as a line of text. Loop and repeat. The ADIF specifications are here:

http://www.adif.org/

73,

Eric KU6J

===========================================
Free SOTA Spot Monitor Software:
http://www.ku6j.com

3

In reply to KU6J:

I’m sure Alain F6ENO has a program that does ADIF>SOTA and vice versa.

Andy
EA3/MM0FMF

4

In reply to N1EU:

Peter ON4UP teached me this:

ADIF -----> SOTA csv

To convert ADIF logfiles to a CSV-file ( ready to upload in SOTA databse)

First you have to install 2 programs:

ADIF Editor (http://www.adif-editor.be) by ON5AI
ADI2SOTA (http://www.sota-france.fr/img/tele/ADI2SOTA_V4_3.zip )

Convertion:

  1. save your log as ADIF-file (e.g. on9cbq_on013.adi)

  2. open ADIF-file in ADIF-editor

    in Fieldname — > enter “COMMENT”
    in Fielddata — > enter “SOTA ON/ON-013 (full SOTA-Ref)
    ( verify “space” between SOTA and SOTA-Ref)
    ADD Field ----> press ENTER

    save file as ----> e.g. on9cbq_on013modif.adi

  3. open modified ADIF- log (e.g. on9cbq_on013modif.adi)
    in ADI2SOTA

  4. you can see your log !

  5. save your log as CSV-File ( e.g. on9cbq_on013.csv)

  6. enter your activator callsign ending with “/P”,( e.g. OK/ON9CBQ/P)

  7. now you are ready to upload the CSV-File to SOTA database

acc. this the upload is very easy!
73 de Franz ON9CBQ

5

In reply to ON9CBQ:

To convert ADIF logfiles to a CSV-file

Again, if anyone can post step-by-step instructions to convert a SOTAdata exported CSV log into ADIF format, I’d greatly appreciate it. (bringing qso data from SOTAdata to LOTW)

73,
Barry N1EU

6

In reply to N1EU:

Sri Barry…
I misunderstood your demand…

73 de Franz ON9CBQ

7

In reply to ON9CBQ:
Hi Barry

You can not do it automaticly because you do not have the RST in CSV… but:

  1. Step: Change CSV to Excel (with the importfilter),
  2. Step: ad the missing RST-sent and RST-rcved
  3. Step: make a TXT-File or a new CSV(EXCEL can do both).
  4. Step: Import the TXT or the CSV-File with RST in a Log-Program (UCXLog or may be Swisslog for windows, both are freeware)
  5. Step: Export the ADIF from the logprogram to the LotW.
    Good Luck!
    73 de HB9BIN, George (Lotw-User)
8

In reply to N1EU:
The CSV2ADI program written by F6ENO will do the job for you. If you do a search on this reflector you will find it there.
73 de Ken - GM0AXY

9

In reply to N1EU:

Hi Barry,

I have solution only for linux/perl

http://wiki.ham.fi/Adifmerg

73, Jaakko OH7BF/F5VGL

10

In reply to GM0AXY:

In reply to N1EU:
The CSV2ADI program written by F6ENO will do the job for you.

Thanks. I’ve downloaded it but there seems to be zero instructions.

I can probably manage to do it in Excel (thanks George).

73,
Barry N1EU

11

In reply to N1EU:

Barry,

I’m using LM (LM contestsoftware) which has its routes in contesting (I’m also a contest adjudicator and with LM I can convert any odd logfile into a correct form). Select “DXpedition”, chose the date & band and start entering the calls only (call enter, call enter, …). In a second step change the time of each QSO. For the first QSO you have to enter all 4 digits (e.g. 1944) and then the last digit for the next QSO (e.g. 5 for the QSO at 1945). As a last step change all 599 RST to the actual RST. Save the file and export as ADIF.
Then go to - 404 - File Not Found - and import your ADIF. I usually enter the SOTA reference and my call used manually and the target pointing to my PC (On my PC I create a subfolder for each hill I activate and store the log, pictures, GPS-track, maps, notes, …).
Next upload the cvs log to the SOTA database and finally take the ADIF and import it to your “normal” logbook and LotW/eQSL.

HTH es 73 de Dominik, HB9CZF

12

In reply to N1EU:
Barry,
Stuart’s G0LGS, SOTA CSV editor does that for you. Import csv and export adif.
I use it all the time.
You’ll find it if you google “g0lgs csv SOTA”.
I’d put the link here but I’m not in front of my pc right now and can’t seem to get this phone to paste it for me!
Pete
Sent from aye aye phone.

13

In reply to G4ISJ:

Stuart’s G0LGS, SOTA CSV editor does that for you.

Thanks Pete - I’ve been using that for logging and didn’t realize it had that capability. Definitely the easiest solution.

73,
Barry N1EU

14

In reply to N1EU:
Barry,
also if you add the signal report in the comments field like, S559 R579, it exports these as RST in ADIF. That’s how I get all my portable log entries into HRD.

15

In reply to G4ISJ:

I’m finding that the export to ADIF function does not work. Even if I select ADIF format, it still saves as CSV.

Is there some trick to make the ADIF export work or is it just not implemented?

Thanks & 73,
Barry N1EU

16

In reply to N1EU:
Barry,
I stumbled across this which was on the reflector previously. I used it once when I used a different call on a SOTA and the trustee wanted the log uploaded to LoTW.
http://f6eno.pagesperso-orange.fr/telechargement/CSV2ADI.exe

73,
Nick/K1MAZ

17

In reply to K1MAZ:
Thanks Nick. See Post by GM0AXY on 6th November 2012 at 17:59 in this thread. Do you have brief instructions on how to use it?

KE5AKL just uploaded a Windows SOTA2ADI Utility to the Files section of the NASOTA Yahoo Group. It is fully documented and it seems to work well.

73,
Barry N1EU

18

In reply to N1EU:
Download the program and RUN it (double-click the CSV2ADI.exe)
Click “Charger CSV” = Load CSV-file i.e. locate the CSV-fil;e you wish to convert and click on it.
Save as type … Fiechier ADIF (*.adi) i.e. Provide a filename and location for the resulting ADIF-file.
That is all there is to it; except click QUITTER = EXIT (Quit) to close the program at the end.
GL and 73 de Ken

19

In reply to GM0AXY:
Thanks Ken - armed with those simple instructions, it seems to work well.

73,
Barry N1EU

20

In reply to N1EU:

In reply to G4ISJ:

I’m finding that the export to ADIF function does not work. Even if I
select ADIF format, it still saves as CSV.

Is there some trick to make the ADIF export work or is it just not
implemented?

Thanks & 73,
Barry N1EU

Yes,
the trick is to make sure you add the .adif extension to the file name!
Otherwise it defaults to csv even though you picked adif from the save as dialogue.

Pete