+- Swisslog's Forum (https://www.swisslogforwindows.com/forum)
+-- Forum: Swisslog version 5.x (https://www.swisslogforwindows.com/forum/forumdisplay.php?fid=3)
+--- Forum: General discussion (https://www.swisslogforwindows.com/forum/forumdisplay.php?fid=4)
+--- Thread: Import QSO from SOTA site (/showthread.php?tid=1266)
Import QSO from SOTA site - OK5WA - 07-06-2025
Hello,
Can anyone help me with importing QSOs from SOTA csv format? I have tried to create my own field assignment table, however I don't have any luck with the SOTA reference field. Tried P_DIPL_15, no success. I can't see anything like SOTA offered.
I have entered quite a few QSO to SOTA database before getting me the Swisslog, some of them manually, hence I do not have any other format.
Anyone did that before?
Thanks,
Jiri OK5WA
RE: Import QSO from SOTA site - EA3GCV - 07-06-2025
Hi Jiri,
Swisslog implements a merge option in the Import QSO function to add info to existing QSOs but QSO date/time MUST BE EXACTLY THE SAME. Otherwise it won't work. I will study if I can implement a function in the future to handle the SOTA CSV file...
73
RE: Import QSO from SOTA site - OK5WA - 08-06-2025
(07-06-2025, 07:39 PM)EA3GCV Wrote: Hi Jiri,
Swisslog implements a merge option in the Import QSO function to add info to existing QSOs but QSO date/time MUST BE EXACTLY THE SAME. Otherwise it won't work. I will study if I can implement a function in the future to handle the SOTA CSV file...
73
Thanks Jordi. The Merge is fine. I tried to use the generic text file inport and succeeded in creating an assignment table for everything except the SOTA referece field. I don"t think a dedicated SOTA import format is necessary. If the SOTA ref field is advertised in the drop-down list of the QSO SWL fields it will work.
Jiri
RE: Import QSO from SOTA site - EA3GCV - 10-06-2025
Hi Jiri,
The merge function works well if date/time is EXACTLY the same (including seconds!) otherwise it will create another QSO! please check this. If the SOTA reference is included in the CSV file you have to assign this field to P_DIPL_15 where SOTA statistic is handled.
If you have issues, send me the following files (zipped) to support@swisslogforwindows.com to test:
- Your Swisslog database
- Your assignment table
- The SOTA CSV file
73