Tool to create CSV files for sota database

Hi,

I want so share some tool with you that I wrote to make it easier to type my paper sota logs into the computer and creating a CSV file.

It is a command line application that works fine on linux and mac os and requires python3 and python3-requests to run.

You can find it here: GitHub - asdil12/sotareport: Tool for submitting SOTA (Summits on the Air) radio connection logs to the SOTAdata database.

Using it looks like this:

./sotareport.py output.csv
######################################################################
Enter station info:
     Your Callsign: HB3/DO3IC
       Your Summit: HB/AI-013
      Found Summit: Furgglenfirst (1952m), Appenzell Innerrhoden, Switzerland
   Date (DD/MM/YY): 26/06/20
######################################################################
Adding log to 'output.csv' - Press CTRL+C to edit previous QSOs or exit
Enter QSO #1:
 Time (HHMM - UTC): 1215
          Callsign: HB9EAJ/P
  Freq (21MHz/80m): 29MHz
  Mode (CW/SSB/FM): 
        S2S Summit: HB/SO-003
      Found Summit: Röti (1395m), Solothurn, Switzerland
          Distance: 144km
           Comment: 
######################################################################
Enter QSO #2:
 Time (HHMM - UTC): 1220
          Callsign: HB9GUX/p
  Freq (21MHz/80m): 28MHz
  Mode (CW/SSB/FM): SSB
        S2S Summit: HB/GR-294
      Found Summit: Chrüz (2196m), Graubünden, Switzerland
          Distance: 41km
           Comment: 
######################################################################
Enter QSO #3:
 Time (HHMM - UTC): 
Error: Invalid time format - use HHMM or HH:MM 24h UTC
 Time (HHMM - UTC): 1221
          Callsign: EA2DT
  Freq (21MHz/80m): 28MHz
  Mode (CW/SSB/FM): SSB
        S2S Summit: 
           Comment: 
######################################################################
Enter QSO #4:
 Time (HHMM - UTC): 1223
          Callsign: DB7MM
  Freq (21MHz/80m): 28MHz
  Mode (CW/SSB/FM): SSB
        S2S Summit: 
           Comment: 
######################################################################
Available Commands:
E <num> : Edit QSO <num>
C       : Continue entering logs
S       : Save and exit
cmd> s
3 Likes

Since the newsota data is up and running I just upload my ADIF. Never touched CSV agn. In the earlier days of course you had to upload a CSV.

1 Like