Import errors from adif imported from QRZ.com

3 posts / 0 new
Last post
kc2jav
Import errors from adif imported from QRZ.com

I am encountering errors when attempting to import records from qrz.com:

while running >cqrlog debug=2 I get the following when trying to import two records:

select count(*) from (select distinct dxcc_id.dxcc_ref from dxcc_id left join cqrlog_main on dxcc_id.adif = cqrlog_main.adif WHERE cqrlog_main.adif<>0 and (dxcc_ref NOT LIKE '%*') AND ((qsl_r = 'Q') OR (lotw_qslr = 'L') OR (eqsl_qsl_rcvd='E'))) as foo

SELECT * FROM profiles WHERE visible > 0 ORDER BY nr

SELECT * FROM profiles WHERE nr = 1

510691867N70cm70cmWB8BFSOH, Warren73 - Nice to meet you on the repeater neighbor!NAUnited States2291beefus@fioptics.comNN443.8443.8EM79ugN039 16.017W084 17.518NNFMLovelandOH, HamiltonUnited States4EM79UG588N039 17.157W084 17.101Robert D SolimenoOHJack E Giehl20200514YNN2020051420200514LovelandOHKC2JAV195719575
510694177N70cm70cmAD8DMOH, Hamilton73 & Tnx for nice conversationNAUnited States2291ad8dm@outlook.comNN443.8443.8EM79ugN039 16.469W084 17.879NNFMLovelandOH, HamiltonUnited States4EM79UG588N039 17.157W084 17.101Robert D SolimenoOHJohn Cadwallader20200514YNN2020051420200514LovelandOHKC2JAV195919595
It takes about 0 minutes and 0 seconds 53 milliseconds
select * from view_cqrlog_main_by_qsodate LIMIT 500 OFFSET 0

select * from view_cqrlog_main_by_qsodate LIMIT 500 OFFSET 0

LoadForm: frmMain
SELECT COUNT(*) FROM cqrlog_main

select count(*) from (select distinct adif from cqrlog_main where adif <> 0 and (adif not in (2,8,19,23,25,26,28,30,39,42,44,55,57,58,59,67,68,81,85,93,101,102,113,115,119,127,128,134,139,151,154,155,164,178,183,184,186,193,193,194,196,198,200,208,210,218,220,226,228,229,231,243,244,255,258,261,264,267,268,271,307,488,493))) as foo

select count(*) from (select distinct dxcc_id.dxcc_ref from dxcc_id left join cqrlog_main on dxcc_id.adif = cqrlog_main.adif WHERE cqrlog_main.adif<>0 and (dxcc_ref NOT LIKE '%*') AND ((qsl_r = 'Q') OR (lotw_qslr = 'L') OR (eqsl_qsl_rcvd='E'))) as foo

SELECT COUNT(*) FROM cqrlog_main

select count(*) from (select distinct adif from cqrlog_main where adif <> 0 and (adif not in (2,8,19,23,25,26,28,30,39,42,44,55,57,58,59,67,68,81,85,93,101,102,113,115,119,127,128,134,139,151,154,155,164,178,183,184,186,193,193,194,196,198,200,208,210,218,220,226,228,229,231,243,244,255,258,261,264,267,268,271,307,488,493))) as foo

select count(*) from (select distinct dxcc_id.dxcc_ref from dxcc_id left join cqrlog_main on dxcc_id.adif = cqrlog_main.adif WHERE cqrlog_main.adif<>0 and (dxcc_ref NOT LIKE '%*') AND ((qsl_r = 'Q') OR (lotw_qslr = 'L') OR (eqsl_qsl_rcvd='E'))) as foo

*****
Contents of error log:

ADIF export from CQRLOG for Linux version 2.4.0 (001)
Copyright (C) 2020 by Petr, OK7AN and Martin, OK1RR
Internet: http://www.cqrlog.com

ERROR QSOs FROM ADIF IMPORT
2.2.1
CQRLOG
2.4.0 (001)

20200514 1957 1957 WB8BFS 443.8 FM 5 Jack E Giehl Loveland EM79ug
ERROR: Wrong frequency:443.8

20200514 1959 1959 AD8DM 443.8 FM 5 John Cadwallader Loveland EM79ug
ERROR: Wrong frequency:443.8

*****
Note: The frequency listed in the above records is indeed correct, not sure why the import fails.

The importing adif ... window shows 2 errors and 0 records imported.

Bob KC2JAV

oh1kh
Import errors from adif imported from QRZ.com

HI Bob!

I really do not understand what is the stuff "Nice to meet you on the repeater neighbor!....." looks like it has bleed from some other process to this dump.

How ever I made few tests and found out a bug from cqrlog.

There is a setup on preferences/Bands/Frequencies where you can define the start and end of band and different mode limits within the band.

Then there is a subroutine called GetBandFromFreq that should return band in meters when you give frequency.
At the moment preferences/Bands/Frequencies set of 70cm band ends at 440MHz. But even when you change it to 450MHz this does not help as the subroutine GetBandFromFreq does not look at this definition, but has a hard coded band limits (there: 430..440: band := '70CM'; ).

That is why you are getting errors. I think!

This must be fixed to use the table user can adjust in preferences.

Thanks for your report !

--
Saku
OH1KH

W1MM
W1MM's picture
Just want to say thanks for

Just want to say thanks for this post. I couldn't find my local qso backup after reloading the OS on my primary station computer. One thing I did know is that I always mirrored the adif at qrz and lotw. Had 1557 qso showing at qrz but when I tried to import I got something like 343 errors. When I found the error adi files they all said wrong frequency for 80 & 40? Then I found the band limits were wrong for USA. When I edited them to 3.5-4.0 for 80m and 7.0-7.3 for 40m, import went smooth. Removed duplicates, et voi la! 1557 qso imported. Breathing a sigh of relief right about now.

Mark
W1MM

73,
Mark, W1MM