2017-08-24 Uploading FT8 contacts to LoTW from CQRLOG 2 years ago
Other people from my radioclub were reporting they uploaded FT8 contacts to LoTW so I wanted to try this too. I uploaded earlier contacts as 'DATA' (and got some confirmations) but FT8 is the correct mode so I wanted to re-upload them. After my earlier experiences uploading FT8 contacts to eQSL I expected some database work to be able to upload those contacts again. Finding the right field to set to the right value was a bit of work since I expected the approach to be similar but it wasn't. In the end:$ mysql -S /home/koos/.config/cqrlog/database/sock cqrlog002 mysql> update cqrlog_main set lotw_qsls = '' where mode='FT8'; Query OK, 77 rows affected (0.01 sec) Rows matched: 78 Changed: 77 Warnings: 0That's after trying most lotw related fields and values.