S2S CSV upload format

In reply to MM0FMF:

Google translate failed miserably when I tried to understand this post. Must be Glaswegian.

73 Richard G3CWI

In reply to G3CWI:
Hey whitā€™s the mattar whey ye, dae ye no ken the heed bummers Scots gibber?

Whereā€™s me Claymhor? Iā€™ll sort yeez oot!!

Jack(:>)
GM4COX

PS; Good one Richard - great memories - hi!

In reply to MM0FMF:

Just seen this about the new format (because I was effectively prompted to look).

I am going to have to think hard about how to deal with this in my SOTA Log Editor.

Stewart G0LGS

In reply to G0LGS:

Do 2 versions Stewart. You have a version that supports the current formats, so that is done. Do another editor for the new formats.

As I said, I had to make some changes to the old parsers to enable the new formats as well. I hope I havenā€™t broken any old compatibility with them. But if I have then Iā€™ll fix them so old files that used to work still work.

I have activator CSV working both in old and new formats. I have chaser CSV old format working and chaser new format almost working. It uploads chases and S2S QSOs but doesnā€™t correctly report any dupes. Something to fix tonight.

Andy
MM0FMF

In reply to VK3WAM:
Can a new form to be included in FAQ page?

Are some where explained step by step how to use Excel to make CSV for Activators? Iā€™m logging in to MixW software, and if are possible to export ADIF log to Excel file? and back to CSV? If somebody can share a link? Pleaseā€¦
I already activated more than 10 summits and have hundreds of QSOs but still not in SOTA database.

Thank you.

P.S. Sorry about my English.

In reply to MM0FMF:

So the format is

, call>,

Chaser:
V2,MM0FMF/P,14/04/2013,14:15,144MHZ,FM,2M0NCM/P,GM/SS-001,ā€œNeil on
Ben Moreā€

Activator:
V2,MM0FMF/P,GM/SS-002,14/04/2013,14:15,144MHZ,FM,2M0NCM/P, ā€œNeil at
homeā€

S2S:
V2,MM0FMF/P,GM/SS-002,14/04/2013,14:15,144MHZ,FM,2M0NCM/P,GM/SS-001,ā€œNeil&Meā€

Hi Andy,

Would it be possible to add the above summary to the FAQ page for sotadata.org.uk ? Otherwise I need to find this thread amongst many other threads.

Thank you for all the work you do for SOTA!

73, Bill W4ZV

In reply to W4ZV:

Itā€™s on the list Bill, along with the FAQs in general and fixing some typos that have been reported.

Andy
MM0FMF

In reply to MM0FMF:

In reply to W4ZV:

Itā€™s on the list Bill, along with the FAQs in general and fixing some
typos that have been reported.

Andy
MM0FMF

.
.
Any progress on the FAQs?..even if itā€™s just the log upload procedure and step by step instructions for self-spotting, that would go a long way. Other issues could be added later.

Elliott, K6EL
Troublemaker

In reply to K6ILM:
Does the example work for summit to summit upload? My uploads donā€™t seem to add the summit to summit information but all the other data seems to get added.

Thanks,
Kevin KJ5FA

In reply to KJ5FA:
Found my problem. I should have done a little more research and read the whole instruction about loading activator and chaser log.

Thanks,
Kevin
KJ5FA

sorry for resurrecting this!

I canā€™t get the S2S to work! see log below:

V2,M6VAR,G/SE-014,13/11/2016,1348,7MHz,SSB,G0RQL,,"G/SE-014"
V2,M6VAR,G/SE-014,13/11/2016,1348,7MHz,SSB,F5LKW,,"G/SE-014"
V2,M6VAR,G/SE-014,13/11/2016,1350,7MHz,SSB,G0GWY,,"G/SE-014"
V2,M6VAR,G/SE-014,13/11/2016,1351,7MHz,SSB,M0JLA,,"G/SE-014"
V2,M6VAR,G/SE-014,13/11/2016,1351,7MHz,SSB,G0DRM,,"G/SE-014"
V2,M6VAR,G/SE-014,13/11/2016,1351,7MHz,SSB,M0XOT,G/WB-012,"G/SE-014 Sun 13:36 M0XOT/P on G/WB-012 7.083 ssb"
V2,M6VAR,G/SE-014,13/11/2016,1353,7MHz,SSB,EA2CKX,,"G/SE-014"
V2,M6VAR,G/SE-014,13/11/2016,1353,7MHz,SSB,G4IAR,,"G/SE-014"
V2,M6VAR,G/SE-014,13/11/2016,1353,7MHz,SSB,EB2ZJU,,"G/SE-014"
V2,M6VAR,G/SE-014,13/11/2016,1402,7MHz,SSB,HB9BIN,DM/BW-308,"G/SE-014 Sun 14:07 DL/HB9BIN/P on DM/BW-308"

May be the posting from W4ZV below will answer your question.

W4ZVJun '13
In reply to MM0FMF:

So the format is , call>,

Chaser:
V2,MM0FMF/P,14/04/2013,14:15,144MHZ,FM,2M0NCM/P,GM/SS-001,ā€œNeil on
Ben Moreā€

Activator:
V2,MM0FMF/P,GM/SS-002,14/04/2013,14:15,144MHZ,FM,2M0NCM/P, ā€œNeil at
homeā€

S2S:
V2,MM0FMF/P,GM/SS-002,14/04/2013,14:15,144MHZ,FM,2M0NCM/P,GM/SS-001,ā€œNeil&Meā€

Hi Andy,

Would it be possible to add the above summary to the FAQ page for sotadata.org.uk ? Otherwise I need to find this thread amongst many other threads.

Thank you for all the work you do for SOTA!

73, Bill W4ZV

this seems the same with my log right? or Im not seeing something?

The answer could be Yes and No, hi: Delete the Quotation marks and try again (Import Chaser/S2S/SWL TSV/CSV)

The colon is missing in the time field.

Ed.

The colon is not necessaryā€¦it functions boths ways, fortunatelyā€¦

Ok, Thatā€™s the only obvious difference I can see between your examle from W4ZV and the file picture from Tasos - unless itā€™s something in the comment field that is messing things up perhaps.

Ed.

ok it did work! in two part uploads.
thanks all

I hope the below will add some clarity.

You create 1 file with all of your chase, activate and summit to summit entries. I sometimes batch up a couple of days of entries off several summits. The system doesnā€™t care.

Then run it through the ā€œUpload Activator CSV/TSV Fileā€ menu. This will pick out any activator entries (including the entries that are chases that are summit to summit - i.e. the ā€œotherā€ activator chasing you). If you only had activation records with no chaser or s2s entries then you can stop at this point.

Then run the EXACT SAME file through the ā€œUpload Chaser/S2S/SWL CSV/TSV Fileā€ menu. This will pick out the simple chaser entries and the summit to summit entries. Again, if you only had chaser entries then just run this second part.

In each case the entries which are not valid for each run through will be ignored. Only summit to summit entries will be processed through both runs.

I hope that helps?