I am using HRDLOG (with MariaDB) and noticed that fields are not set correctly for LOTW upload in case on the QO-100 QSO's
I create two triggers in the Database so that records are corrected.
With these triggers in place I can upload directly from HRd to LOTW and immediately saw confirmation coming in.
Please find them below for anybody that faces the same problem.
You need to set Satallite name in HRD QSO window to "QO-100" for LOTW but also it's the value those triggers look for so that other non QO-100 records do not get affected.
Make sure you backup your database before as this is provided as is and at your own risk.
CREATE DEFINER=`root`@`localhost` TRIGGER `table_hrd_contacts_v01_before_insert` BEFORE INSERT ON `table_hrd_contacts_v01` FOR EACH ROW BEGIN
IF (NEW.COL_SAT_NAME = 'QO-100') THEN
SET NEW.COL_BAND_RX = '3cm';
SET NEW.COL_BAND = '13cm';
SET NEW.COL_FREQ=0;
SET NEW.COL_FREQ_RX=0;
END IF;
END
CREATE DEFINER=`root`@`localhost` TRIGGER `table_hrd_contacts_v01_before_update` BEFORE UPDATE ON `table_hrd_contacts_v01` FOR EACH ROW BEGIN
IF (NEW.COL_SAT_NAME = 'QO-100') THEN
SET NEW.COL_BAND_RX = '3cm';
SET NEW.COL_BAND = '13cm';
SET NEW.COL_FREQ=0;
SET NEW.COL_FREQ_RX=0;
END IF;
END
Beyond that I am using this view to check the values if needed:
SELECT `COL_PRIMARY_KEY`, COL_SAT_NAME,COL_BAND,COL_BAND_RX,
`COL_CALL`, `COL_FREQ`, COL_FREQ_RX, `COL_MODE`,COL_PROP_MODE
`COL_SUBMODE` FROM `hrd_database01`.`table_hrd_contacts_v01` order by COL_PRIMARY_KEY DESC