I'm attempting to import an ADIF written from ACLOG (logger written by N3FJP for Windows). In all of my records that have a "Y" in the QSL_SENT field, CQRLOG defaults to "B" for BURO. Also in the QSL_RCVD field, a "Y" defaults to "Q" whatever that means (I couldn't find it in the documentation-help). While I appreciate the extra flexibility built into this field by CQRLOG, it would help if it would at least recognize the more basic approach of other logging programs when importing. Can anyone help me with this? Or maybe tell me a way around it without having to go in and manually change each record.
I did search the forum and bug list for this problem but didn't find this specific one. Another operator told me he had exactly the same thing happen to him when migrating to CQRLOG but he went in and changed each one. 73, W4XR
Tue, 2012-12-11 01:43
#1
Importing ADIF from another log - QSL_Sent defaulting to "B"
Hello Glenn,
I'm not sure if I understand what you mean. You can fix QSL_S field values very quickly. Please open QSO list window, go to Filter menu and choose SQL console. Into the console window please type this:
update cqrlog set qsl_s = 'B' where qsl_s='Y'
In this SQL query, the old QSL_S value is after the where and new value is after the set command.
Description what every symbol in the field means is in the QSL menu in QSO list window e.g. B means Buro, MD manager direct, CE confirm by email etc.
73 Petr, OK2CQR
--
http://HamQTH.com/ok2cqr
https://ok2cqr.com
Hi Petr, Thanks very much for your reply. I know you're very busy so I appreciate you taking time to answer. I didn't do a very good job of describing my problem. I was hoping that I could specify a default of "D" (for direct) so that when I import a huge log file from another program, all of the QSL-Sent fields (with a "Y" in the ADIF) would load as "D" and not "B". If that's not possible then of course I will do the SQL mass change after I import the ADIF. Does this make sense? It's a fairly common problem over here because almost no one uses bureau (BURO) for sending out QSL's. 73, Glenn
Hi Glenn,
thnank you for suggestion, I'll add it to my todo list, good idea. Here is buro mostly used to send QSL cards.
You can fix it very quickly after the import. As I wrote in post before, go to QSO list window, click to Filter menu and choose SQL console. The SQL query will look like this:
update cqrlog set qsl_s = 'D' where qsl_s='B'
and click to to green arrow in the toolbar. It will change all QSL_S values from B to D. This is probably the fastest solution.
The slowest solution works with filter. You can select only QSO with QSL_S as B, select them all by clickling to the icon on the toolbar at QSO list window, hit F4 and with group edit function change all to D.
73 Petr, OK2CQR
--
http://HamQTH.com/ok2cqr
https://ok2cqr.com
Thank you Petr for your resonse and suggestion. 73, Glenn