Continuing the discussion from SOTAData3 (Part 3) - #102 by VK3ARR.
Previous discussions:
1 Like
I think you may find that the API Manuel uses doesnāt offer first activator but just activators. I remember specifically having to craft a SQL query with post processing by the C# DB app to get the 1st activator by looking at QSO times out of the oldest logs for the summit.
I can guarantee you that we donāt want to change the display because the MTās inboxes will be overflowing with people upset they have to share first activation with others after they were listed as first for a long time (20+ years) in some cases. 
As it stands we have both, one showing the true first and one showing all on the first day.
4 Likes
Continuing the discussion from SOTAData3 (Part 3):
I have just tried this and it wasnāt working, but figured it out so sharing in case it helps someone else.
The problem seemed to be leaving blank values for the mygrid and operator lines which come up by default when you create a new file. Deleting these lines (rather than just putting no value) fixes it.
2 Likes
I just typed the data into a text file and imported that.
i.e.
MYSOTA GM/SS-058
DATE 2023-09-05
1115 20M CW IN3CEL
18 OK1ZE
20 DJ5AV
21 HB9AGO
21 HB9BCB
22 F4WBN
3 Likes
I like the highlighting and colouring in FLE. It made it obvious when Iād missed the number out of someoneās callsign just now for example.
1 Like
Iāll push a fix for this later today if I get a chance. Part of the problem is no one sent me sample FLE files when I asked for them so I have been testing from my own handcrafted files and I donāt have any windows systems here to run it.
1 Like
I tested it with a bunch of FLE files, but I donāt use Windows eitherā¦ I enter my logs using vim. I guess we could have used some beta testers who use FLE on Windows 
2 Likes
I enter my logs using vim
There are dozens of us! Iāve also just been using a text editor (on my phone), and I use vim almost daily on my computers
(as a side note, just saw that you host the pnwsota website - thanks for maintaining it!)
3 Likes
Hello developers
I would like to come back to the maps with the qso that are not displayed. I noticed a systematic. All qso with a prefix like HB9/IK2LEY/P, DL/HB9EAJ/P F/M0RWX/P are not displayed.
see this example
LOG
MAP
These qso are mostly S2S.
I have noticed this many times.
If the codes come from QRZ.com it is likely that the codes with prefix do not exist in qrz.com.
Would it be possible to add in the algorithm a specific test for qso s2s. Just check if the qso is an S2S and use the summit coordinates instead of the callsign coordinates. Or another suggestion, in algorithm removed the prefix before testing the callsign.
Best 73
Christian F5MMP
1 Like
āAdd External Linkā button in āNew External Linkā popup on summit page is failing with 404 Not Found:
POST https://api-db2.sota.org.uk/summits/tags/ZL3/CB-753
Assume thatās to do with the new API address / structure?
There was a bug with certain summits and I pushed a fix for that earlier today. Might have fixed it already? If not, probably some other edge case thatās been missed.
Iām travelling over the next week so it may take some time to fix (or I may push a fix after drinking with customersā¦)
2 Likes
Iām currently getting a HTTP 500 error when I click āverify logā for a FLE file that Iāve uploaded. It looks like itās been loaded OK on screen, if I convert the file to CSV in FLE and upload then it verifies and submits fine.
Http failure response for https://api-db2.sota.org.uk/uploads/verify: 500 Internal Server Error
@VK3ARR Andrew, do you want me to send you some files to test?
Yes please, anryan at Gmail. I can see there are some messed up dates in what is submitted. Probably messed up by the FLI parser.
Same caveat as above on timeframe for fixing
2 Likes
This should now be fixed. Andy was able to point out it happened with callsigns with multiple separate numbers, which allowed me to work out these callsigns were being interpreted along with the time parameter as a date due to a combination of a faulty regular expression and FLEs tolerance of almost anything as a date separator.
1 Like
Any plan to actually add a text entry box like FLE? I think the use of FLE is just a unneeded detour if on can directly do it online?
1 Like
You can use any text editor. When we say āFLEā we mean the log format, not any specific software implementation.
We could have a text area for pasting in your FLE log, but itās safer and better for you to type it in to a text editor and save the file. If you need to edit the log later you can open the text file, edit, save, and upload again. If you are wanting to do this all in a web browser then I suggest using Google Docsā¦ it is a perfectly adequate text editor.
Hereās the start of this Saturdayās log. I typed it into Notepad++ on a Windows machine. You could use Windows Notepad or Wordpad or equivalent editors on a Mac. I saved the file as MM0FMF-SS287.FLE Then you use the Upload FLE option, click browse and click on the filename.
If Iām away and only have my Linux laptop Iād use emacs. I wouldnāt use vi/vim though
MYCALL MM0FMF/P
MYSOTA GM/SS-287
DATE 2023-09-16
1243 40M SSB M0JLA
44 G0FEX
46 MW0KAX
46 G0RQL
49 G7ADF G/SP-013 <S2S>
50 GW4TJC/P GW/NW-048 <S2S>
51 G4OBK
53 GW4VPX
53 GM0AXY
55 MI0RTY
55 MW0IDX
56 M0BKV
57 2E0FEH
58 GM4YMM
58 GW4BML
1300 2E0WGA
1301 G0GWY
02 GI4TAJ
02 2E0AGB
04 M0BOB
05 G4GMN
06 MW7TEW
1 Like
I am fully aware how this can be done with any text editor. Just saying the text entry field with some template lines might make it even faster.
73 Joe
2 Likes
This is now fixed.
1 Like
Hi Andrew,
the activator and chaser badges are sorted from OLD to NEW ā¦ is it possible to change that so that the newest awarded badge is shown on top?
73 Martin, OE5REO
3 Likes