Uploading FT8 contacts to LoTW from CQRLOG / 2017-08-24

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: 0

That's after trying most lotw related fields and values.