profile info not shown if profile has nr. 0

4 posts / 0 new
Last post
HB9FSV
profile info not shown if profile has nr. 0

Hi all,
After using CQRLog for a year and a half I must say I'm very happy, thanks to everyone involved!
I use different profiles for my different rigs / QTHs. The profiles all have a unique number as identifier, and in the "view QSO" window the drop down list shows this number and also the description. This works, except for profile number zero: If I want to view an old QSO, the value remains empty.
As I have seen in the database structure https://www.cqrlog.com/help/sql_console.html, zero is the default value. So maybe it should be forbidden to the user to create a profile using 0 as profile number?
Thanks and vy 73
Martin HB9FSV

oh1kh
profile info not shown if profile has nr. 0

Hi Martin!

There has been a fix that prevents profile number zero usage. (user can not create it). It should be ok in version 2.5.2.

--
Saku
OH1KH

HB9FSV
Solution for updaters

Thank you Saku, this is a good solution for new users. If you update with an existing profile number 0 like me, the problem persists. Here is a way for updaters to solve the problem:

  1. Create a copy of the profile number zero in the settings, in this example nr. 3
  2. Go to Window -> QSO list, and there to Filter -> SQL Console
  3. Run SQL command update cqrlog_main set profile='3' WHERE profile = '0'(I have not tested this exact command, I used date filters instead, due to other inconsistencies in my log not related to CQRLog)

73 Martin HB9FSV

oh1kh
Solution for updaters

Thanks Martin!

That is good solution with SQL console.
Although user can not create profile nr 0 he will have it if he has previous qsos in log without any qth profiles and the he/she decides to start using qth profiles in same log.
That will result all previous qsos to have profile number 0 and new qsos will take profile numbers by selection.

Perhaps an average user feels more comfort to use cqrlog tools instead of sql console. Then it goes like:
1) create a copy of profile 0 (qsos worked before any profiles were used)
2) create filer (F12) that select all those qsos by start and end dates
3) QSO list/File/Group edit/Field=profile, Field=created new qth profile / Apply

At point 3 just notice that there is no "roll back". Therefore always make backup from whole log BEFORE using Group edit.
At point 3 check that Group edit says that edit will apply to FILTERED QSOS before pressing Apply.
At point 3 note that user can also select Field value as "empty". This will not restore profile back nr 0. Instead it sets profile nr to -1

--
Saku
OH1KH