HRDLog & QO-100 & LOTW

I am using HRDLog for all my contacts and had some issues with uploading contacts on QO-100 / Oscar 100 / Es’hail-2 to LOTW.

HRDLog has an issue with high freqencies and different TX/RX bands.

I created to triggers on the MariaDB to correct those records on insert and update.

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