Swisslog's Forum
Export time and frequency in csv format - Printable Version

+- 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: Export time and frequency in csv format (/showthread.php?tid=1187)



Export time and frequency in csv format - F5RAB - 07-05-2024

Hello,

I wish to export my log in CSV, and I have 2 questions :


1) If QSO date : 12/03/2024 11:56:31

in ADIF export from Swisslog : date 20240312 time 115631,   it's OK
in CSV export from Swisslog :  date 12/03/2024  time11:56,   I need the seconds

How do I export time with seconds ?


2) If QSO frequency : 14.016 MHz

in ADIF export from Swisslog : frequency 14.016 in MHz,   it's OK
in CSV export from Swisslog :  frequency 14016 in kHz,   I need MHz

How do I export frequency in MHz ?


73 F5RAB Antoine


RE: Export time and frequency in csv format - EA3GCV - 09-05-2024

Hi Antoine,

You need to edit the Query you are using to export to CSV then double click in the QSOTIME field and change format to hh:mmConfuseds. For MHZ, add the MHZ field from the QSO field. You can see an example if you go to View / Logbook view (selection) then select the query "All fields (slow)". Edit this query with the editor.

73