Wrong station_callsign

[nolith]

Hello, I'm running CLoudLog v2.5.2 and I was testing the QSL label printing feature. Very good stuff!

I was surprised that my QSO from IU5BON/IA5, correctly reported in the label printing page, showed up as IU5BON in the final PDF.

Digging through the code I found that we are using TABLE_HRD_CONTACTS_V01.COL_STATION_CALLSIGN to populate the PDF and searching the DB showed up some unexpected data in my CloudLog.

select TABLE_HRD_CONTACTS_V01.COL_CALL, TABLE_HRD_CONTACTS_V01.COL_STATION_CALLSIGN, station_profile.station_callsign 
from TABLE_HRD_CONTACTS_V01 
join station_profile ON station_profile.station_id = TABLE_HRD_CONTACTS_V01.station_id 
where COL_STATION_CALLSIGN != station_callsign;

+--------------+----------------------+------------------+
| COL_CALL     | COL_STATION_CALLSIGN | station_callsign |
+--------------+----------------------+------------------+
| IW6OOK       | IU5BON               | IU5BON/IA5       |
| IU5NAY       | IU5BON               | IU5BON/IA5       |
| IK0BDO/5     | IU5BON               | IU5BON/IA5       |
| I5EKX        | IU5BON               | IU5BON/IA5       |
| IU5LBQ       | IU5BON               | IU5BON/IA5       |
| IW5BNY       | IU5BON               | IU5BON/IA5       |
| IW0DGQ       | IU5BON               | IU5BON/IA5       |
| IW0DGQ       | IU5BON               | IU5BON/IA5       |
| IZ0HSR       | IU5BON               | IU5BON/IA5       |
| IZ0HSR       | IU5BON               | IU5BON/IA5       |
| IW0DGQ       | IU5BON               | IU5BON/IA5       |
| IK0BDO/5     | IU5BON               | IU5BON/IA5       |
| IZ1YUX       | IU5BON               | IU5BON/IA5       |
| I5IIL        | IU5BON               | IU5BON/IA5       |
| IW5BNG       | IU5BON               | IU5BON/IA5       |
| IK0BDO/5     | IU5BON               | IU5BON/IA5       |
| IZ5TEP       | IU5BON               | IU5BON/IA5       |
| G0BON        | IU5BON               | IU5BON/IA5       |
| IU3GKJ/P/QRP | IU5BON               | IU5BON/IA5       |
| IK0BDO/5     | IU5BON               | IU5BON/IA5       |
| IZ5DKI       | IU5BON               | IU5BON/IA5       |
| IV3GVY       | IU5BON               | IU5BON/IA5       |
| IK4IDF       | IU5BON               | IU5BON/IA5       |
| HB9EFJ       | IU5BON               | IU5BON/IA5       |
| IK2WZQ       | IU5BON               | IU5BON/IA5       |
| IU8ANF       | IU5BON               | IU5BON/IA5       |
| IK1TNU       | IU5BON               | IU5BON/IA5       |
| EC5CSW       | IU5BON               | IU5BON/IA5       |
| G0VWP        | IU5BON               | IU5BON/IA5       |
| EA2DT        | IU5BON               | IU5BON/IA5       |
| IK0BDO/5     | IU5BON               | IU5BON/IA5       |
| IU5LBQ       | IU5BON               | IU5BON/IA5       |
| EA5JN        | IU5BON               | IU5BON/IA5       |
| IW5BNG       | IU5BON               | IU5BON/IA5       |
| IW5BNY       | IU5BON               | IU5BON/IA5       |
| IZ0PAP       | IU5BON               | IU5BON/IA5       |
| SV3SFK       | IU5BON               | IU5BON/IA5       |
| F4GTB        | IU5BON               | IU5BON/IA5       |
| DG3DAF       | IU5BON               | IU5BON/IA5       |
| SP6RCK       | IU5BON               | IU5BON/IA5       |
| EC3A         | IU5BON               | IU5BON/IA5       |
| M0TTQ        | IU5BON               | IU5BON/IA5       |
| IZ8IBC       | IU5BON               | IU5BON/IA5       |
| SV3RPQ       | IU5BON               | IU5BON/IA5       |
| GM4VYQ/P     | IU5BON               | IU5BON/IA5       |
| IA5GPN       | IU5BON               | IU5BON/IA5       |
| IA5GPN       | IU5BON               | IU5BON/IA5       |
| IK0BDO/5     | IU5BON               | IU5BON/IA5       |
| IK0BDO/5     | IU5BON               | IU5BON/IA5       |
| IZ5PHM/MM    | IU5BON               | IU5BON/IA5       |
| IK0BDO/5     | IU5BON               | IU5BON/IA5       |
| IA5GPN       | IU5BON               | IU5BON/IA5       |
| IK5JRZ/MM    | IU5BON               | IU5BON/IA5       |
| IZ5PHM/MM    | IU5BON               | IU5BON/IA5       |
| IU1JFE       | IU5BON               | IU5BON/IA5       |
| IU1JFE       | IU5BON               | IU5BON/IA5       |
| IU1JFE       | IU5BON               | IU5BON/IA5       |
| IU1JFE       | IU5BON               | IU5BON/IA5       |
| IQ5FI/IA5    | IU5BON               | IU5BON/IA5       |
| IZ5PHM/IA5   | IU5BON               | IU5BON/IA5       |
| IK5JRZ/IA5   | IU5BON               | IU5BON/IA5       |
| IK5JRZ/IA5   | IU5BON               | IU5BON/IA5       |
| IQ5FI/IA5    | IU5BON               | IU5BON/IA5       |
| IZ5PHM/IA5   | IU5BON               | IU5BON/IA5       |
+--------------+----------------------+------------------+
64 rows in set (0.014 sec)

How is it possible that those records have a TABLE_HRD_CONTACTS_V01.COL_STATION_CALLSIGN that does not match the station_profile.station_callsign? I'm wondering if this is because of the ADIF import and CloudLog not overwriting the field when importing in a given station location.

Can I safely issue an SQL UPDATE to clear the discrepancy?

[magicbug]

Yes should be plenty safe enough to sql update

[nolith]

Thank you.

Fixed with the following SQL:

update TABLE_HRD_CONTACTS_V01
join station_profile ON station_profile.station_id = TABLE_HRD_CONTACTS_V01.station_id
set COL_STATION_CALLSIGN = station_callsign 
where COL_STATION_CALLSIGN != station_callsign;