[Dx4win] Exporting SOTA references

[John Shaw]

Here is what I do.

When I log a sota contact I put the sota reference in the QSO notes field.

I have made a report format called sota that has Date, Time, Band, Mode, Callsign and QSO notes fields only.

So I use whatever filter is practical to select the QSO's I want to export then I bring up the logbook window and select the sota report I have made, then right mouse on that window and select write to file as csv.  Now I have a csv that I can add my call and v2 fields or make changes necessary keeping the csv format before uploading the resulting file to the sota database.  I use Google Sheets for making the changes and download the file as csv which is perfect to upload to the sota database.

A couple of other things I do is change the Band field in DX4win to MHz in the preferences as that is what sota database wants.

 Also I have made a group for sota chases and sota activations.  When exporting the QSO's with a filter on I do a multiple QSO operations, set group number to the relevant group so I know I have exported them.

Also If the export is an activation I do a LoTW export while the filter is on and I apply the right QTH details to those QSO's when uploading those to LoTW since they are from a different QTH location.  I make a unique station location in the LoTW TQSL for each sota summit I operate from so I can do this.

John ZL1BYZ

-----Original Message-----
From: dx4win-bounces at mailman.qth.net [mailto:dx4win-bounces at mailman.qth.net] On Behalf Of Ricardo Navarrete
Sent: Sunday, 10 November 2019 9:44 p.m.
To: DX4WIN Reflector <Dx4win at mailman.qth.net>
Subject: [Dx4win] Exporting SOTA references

Hello all

I'm trying to export all my sota QSO with its references but I can't

Any idea??

Thanks

--
EA4ZK Ricardo Navarrete
ricardoea4zk at gmail.com

*CWops : 1070*



*POR FAVOR, SI VAS A REENVIAR ESTE CORREO, TEN EN CUENTA LOS SIGUIENTES
PUNTOS:1.- Borra la dirección e-mail del remitente así como cualquier otra dirección e-mail que aparezca en el cuerpo del mensaje.2.- Protege frente a terceros a todos los destinatarios de tus mensajes colocando sus direcciones en la línea de CCO (Con Copia Oculta).* *Combatir el spam es tarea de todos.* *Gracias por tu colaboración.* ______________________________________________________________
DX4WIN mailing list
Home: http://mailman.qth.net/mailman/listinfo/dx4win
Help: http://mailman.qth.net/mmfaq.htm
Post: mailto:DX4WIN at mailman.qth.net

This list hosted by: http://www.qsl.net
Please help support this email list: http://www.qsl.net/donate.html