New to CQRLOG and finding a few issues.
1. Import of ADIF file fails to import station QTH for the profile although the station LOC (e.g. grid) is being populated on import.
2. Some QSLS and QSLR fields are defaulting to 'B' although the import is set to 'v' in case of verified by the DXCC desk.
3. Is there a method for selecting multiple records for group edit such as click-shift rather than selecting records one by one?
4. When creating a filter the field for "My locator" defaults to Upper Case regardless of input. The filter works correctly if the query is edited for correct case in the SQL console (e.g. defaults CN87XS - fails, edited in console to CN87xs - succeeds). Imported ADIF data includes both cases for the My locator data.
I searched through previous posts and did not find specific solutions to these issues so my apologies if I've missed it. I am importing around 5,500 records from an ADIF export from DXKeeper into a clean unpopulated log.
Any help will be greatly appreciated.
Regards,
Tom KR5D
Hi Tom,
1. Import of ADIF file fails to import station QTH for the profile although the station LOC (e.g. grid) is being populated on import.
if you want to import ADIF with QTH profiles, you have to leave the list in the import window empty because it will overwrite what you have in the ADIF file.
2. Some QSLS and QSLR fields are defaulting to 'B' although the import is set to 'v' in case of verified by the DXCC desk.
Yes, because CQRLOG doesn't support verified DXCC. It's on my TODO list.
3. Is there a method for selecting multiple records for group edit such as click-shift rather than selecting records one by one?
Yes, you can hold Shift key and select records using up/down arrows.
4. When creating a filter the field for "My locator" defaults to Upper Case regardless of input. The filter works correctly if the query is edited for correct case in the SQL console (e.g. defaults CN87XS - fails, edited in console to CN87xs - succeeds). Imported ADIF data includes both cases for the My locator data.
That's a bug. I'll fix it. In the mean time, you can try to fix it using SQL console with these commands:
update cqrlog_main set my_loc = upper(my_loc)
update cqrlog_main set loc = upper(loc)
73 Petr, OK7AN
--
http://HamQTH.com/ok2cqr
https://ok2cqr.com
1. Import of ADIF file fails to import station QTH for the profile although the station LOC (e.g. grid) is being populated on import.
if you want to import ADIF with QTH profiles, you have to leave the list in the import window empty because it will overwrite what you have in the ADIF file.
Tom - hmm, must be missing something here. Starting with a new, clean, log and only default preferences settings the import runs cleanly. But still does not populate the QTH profile field when "view QSO" is selected? The few errors generated by the import process are related to unrecognized modes which is understandable.
Thanks,
Tom, KR5D
Hi Petr,
Getting a SQL error for the updates ?
SQL error:TMySQL57Connection : Error executing query: You have an error in your SQL syntax; check the manual that corresponds to your MariaDB server version for the right syntax to use near 'update cqrlog_main set my_loc = upper(my_loc)' at line 2
Thanks,
Tom KR5D
Hi Tom,
the queries should work but you have to enter them separately. At first
update cqrlog_main set my_loc = upper(my_loc)
and click to the green play button in top left corner, then
update cqrlog_main set loc = upper(loc)
and again click to the green button. The SQL console can't handle multiple SQL queries.
About the QTH profiles. I'm sorry, I probably didn't understand what you mean. QTH profiles are not create automatically, you have to create them by hand in Preferences->QTH profiles. Also you can select the default profile.
73 Petr, OK7AN
--
http://HamQTH.com/ok2cqr
https://ok2cqr.com
Hi Petr
I'm not sure if my problem relates to Tom's.
Basically I'm importing some QSOs in an ADIF file and I want the 'my_loc' field to be populated for each QSO, from the Locator value specified in the ADIF file. The Locator value specified in the ADIF file is the same as that defined in the QTH Profile, and when I enter a new observation the Profile value is being displayed in the my_loc field, but my_loc is blank for the QSOs I have imported.
Can my_loc be assigned when Importing records?
Chris
G3SQU