-----------------------decode start---------------------------------
Header position:1 Schema number:2 Message type:5 logging data
|AD|BC|CB|DA|00|00|00|02|00|00|00|05|00|00|00|04|4A|54|44|58|00|00|00|00|00|25|85|C5|01|78|B1
| _| _| _| _| _| _| _| _| _| _| _| _| _| _| _| _| J| T| D| X| _| _| _| _| _| %| _| _| _| x| _
|B1|88|00|00|00|00|06|4F|48|31|41|42|43|00|00|00|04|61|62|31|32|00|00|00|00|08|97|F1|8C|00|00
| _| _| _| _| _| _| _| O| H| 1| A| B| C| _| _| _| _| a| b| 1| 2| _| _| _| _| _| _| _| _| _| _
|00|00|03|46|54|38|00|00|00|03|2D|31|35|00|00|00|03|2D|31|35|00|00|00|03|31|30|30|00|00|00|0B
| _| _| _| F| T| 8| _| _| _| _| -| 1| 5| _| _| _| _| -| 1| 5| _| _| _| _| 1| 0| 0| _| _| _| _
|0B|43|6F|6D|6D|65|6E|74|48|65|72|65|00|00|00|08|4E|61|6D|65|48|65|72|65|00|00|00|00|00|25|85
| _| C| o| m| m| e| n| t| H| e| r| e| _| _| _| _| N| a| m| e| H| e| r| e| _| _| _| _| _| %| _
|85|C5|01|78|B1|88|00|00|00|00|05|4F|48|31|4B|48|00|00|00|05|4F|48|31|4B|48|00|00|00|04|4B|50
| _| _| _| x| _| _| _| _| _| _| _| O| H| 1| K| H| _| _| _| _| O| H| 1| K| H| _| _| _| _| K| P
|50|30|31
| P| 0| 1
Qso Logging Id:JTDX
edtCall before started logging #5:
End Date :2020-08-15
End Time: 06:51
timespec: 0
Call decoded #5:OH1ABC edtCall:
NOT found - P29AS
SELECT * FROM view_cqrlog_main_by_qsodate WHERE callsign = 'OH1ABC' ORDER BY qsodate,time_on
LoadForm: frmNewQSO
SELECT id_cqrlog_main FROM cqrlog_main WHERE adif=224 AND band='80M' AND ((qsl_r='Q') OR (lotw_qslr='L')) AND mode='CW' LIMIT 1
SELECT id_cqrlog_main FROM cqrlog_main WHERE adif=224 AND band='80M' AND mode='CW' LIMIT 1
SELECT id_cqrlog_main FROM cqrlog_main WHERE adif=224 AND band='80M' LIMIT 1
SELECT id_cqrlog_main FROM cqrlog_main WHERE adif=224 LIMIT 1
select band,mode,qsl_r,lotw_qslr,eqsl_qsl_rcvd from cqrlog_main where adif=224 and ((qsl_r='Q') or (lotw_qslr = 'L') or (eqsl_qsl_rcvd='E')) group by band,mode,qsl_r,lotw_qslr,eqsl_qsl_rcvd
select band,mode from cqrlog_main where adif=224 group by band,mode
select * from cqrlog_common.qslmgr where (callsign = 'OH1ABC') and (fromDate <= '2020-08-15') order by fromDate
GetIOTAForDXCC
SELECT iota_nr,pref FROM cqrlog_common.iota_list WHERE dxcc_ref = 'OH' ORDER BY iota_nr
Call was not there already
9e18348f047911f1b8db35b9947255d0023aba0a
Tag: Value: 9e18348f047911f1b8db35b9947255d0023aba0a
Callsign not found
Grid :ab12
Qrg :144.17550
Band :2M
Mode :FT8
RSTs :-15
RSTr :-15
Pwr :100
Comments :CommentHere
Name :NameHere edtName :Bnnn
edtName before pressing save:NameHere
Start Date :2020-08-15
Start Time: 06:51
timespec: 0
Remote name: JTDX
Prop Mode :OH1KH
Prop Mode added!
WSJTX decode #5 logging: press save
Note:
insert into cqrlog_main (qsodate,time_on,time_off,callsign,freq,mode,rst_s,rst_r,name,qth,qsl_s,qsl_r,qsl_via,iota,pwr,itu,waz,loc,my_loc,county,award,remarks,adif,idcall,state,qso_dxcc,band,profile,cont,club_nr1,club_nr2,club_nr3,club_nr4,club_nr5, prop_mode, satellite, rxfreq, srx, stx,srx_string, stx_string, contestname, dok) values('2020-08-15','06:51','06:51','OH1ABC',144.1755,'FT8','-15','-15','NameHere','','','','','','100',18,15,'AB12','KP01tn','','','CommentHere',224,'OH1ABC','',0,'2M',-1,'EU','','','','','','','',null,'','','','','','')