Hello,
I think this part (database) of CQRLOG being the most "not so easily manageable" by everybody.
ISSUE 1:
I cannot upload new QSO's because evidently some database table has been marked as "already sent QSO" but I want to to force the application to re-send these QSO to remote servers, so how can I do it?
ISSUE 2:
I created a new log Nº3 and I made a single QSO and saved it there, then I attempted to upload it on LOTW web page but I get the following error:
Final Status: Success(0)
Signed ...
If you did not see any errors, you can send signed file to LoTW website by pressing Upload button
Uploading file ...
Size:
Error: 1
This is due the fact there is a minimum number of QSO's to be logged before we can upload on LOTW?
Many thanks for any eventual help.
Regards,
PY1ZRJ
Hi!
First you have to select qsos you want to reupload. You can do it via QSO list/filter/create or you can select qsos from QSO list by keeping ctrl key pressed and click with mouse left button (if there are just some qsos).
Then select QSO list/File/Group edit and choose what you want to change (eQSL sent, Lotw sent) and then for value select "N"
Error: 1 looks like LoTW error. Did you set right callsign and password at prferences? It must be done for new every log. All settings at preferences are log based. You can export settings from log #1 to log #3 in Database connection window using button Utils/Configuration.
LoTW upload creates adi-files and signed tq8-files to directory ~/.config/cqrlog/lotw Look at the directory and check that the adi file looks properly created (it is human readable with text editor).
Then go to LoTW web page and try to upload the corresponding tq8 file manually and see if it gives error there.
Any help from these?
--
Saku
OH1KH
Hello Saku!
For ISSUE 1 your instruction has resolved my needing, very nice!
For ISSUE 2 I have been able to upload the QSO to LOTW as soon as I contacted 2nd QSO.
Regarding settings, yes, I had imported the settings of previous log.
Best regards,
PY1ZRJ
Hi!
Ok , fine with issue #1
Issue 2 sounds weird. I just made a new log and added only one qso and uploaded to LoTW:
-------------
Starting export to adif ...
Export to the adif file completed.
File:
/home/saku/.config/cqrlog/lotw/2021-09-21_17-00-18.adi
Signing adif file ...
TQSL Version 2.5.8 [pkg-v2.5.8]
Varmistetaan käyttäen kutsumerkkiä OF1KH, DXCC-maata FINLAND
QSO_DATE: 20210921
TIME_ON: 1355
CALL: OH1KJ
MODE: SSB
BAND: 80M
FREQ: 3.7366
/home/saku/.config/cqrlog/lotw/2021-09-21_17-00-18.adi: kirjoitettiin 1 tietoa /home/saku/.config/cqrlog/lotw/2021-09-21_17-00-18.tq8:ään
/home/saku/.config/cqrlog/lotw/2021-09-21_17-00-18.tq8 on valmis sähköpostitse lähetettäväksi tai ladattavaksi palveluun.
Huomaa: TQSL olettaa että tämä tiedosto lähetetään LoTW:iin.
Näiden QSO-tietojen uudelleenlähettäminen aiheuttaa niiden raportoimisen aiemmin lähetettyinä.
Final Status: Success(0)
Signed ...
If you did not see any errors, you can send signed file to LoTW website by pressing Upload button
Uploading file ...
Size: 2144
Uploading was successful
-------------
And here is the only qso adif file:
[saku@hamtpad ~]$ cat /home/saku/.config/cqrlog/lotw/2021-09-21_17-00-18.adi
3.1.0
20210921 140018
ADIF export from CQRLOG for Linux version 2.5.2 (110)
Copyright (C) 2021 by Petr, OK2CQR and Martin, OK1RR
Internet: http://www.cqrlog.com
20210921
1355
OH1KJ
SSB
80M
3.7366
59
59
--
Saku
OH1KH
Very good Saku!
About LOTW may be it was caused by a temporary local issue.
All the best to you!
73's de PY1ZRJ
Hello,
I'm facing again the issue wherein all my new QSO's are most likely marked as UPLOADED on HamQTH, HRDLog and ClubLog but they aren't!
I'm using openSUSE Tumbleweed and recently it has updated MariaDB to the version:
marco@linux-turion64:~> mysql --version
MySQL Ver 15.1 Distrib 10.9.3-MariaDB, for Linux (x86_64) using EditLine wrapper
I'm "trying to hacker" the CQRLOG's database but I'm not aware of all its rules; I located the table upload_status and I thought it could be the "culprit" in order to reset the mask which is marking all the QSO as uploaded:
MariaDB [cqrlog002]> select * from upload_status ;
+----+---------+----------------+
| id | logname | id_log_changes |
+----+---------+----------------+
| 1 | HamQTH | 3 |
| 2 | ClubLog | 3 |
| 3 | HRDLog | 3 |
+----+---------+----------------+
But this is not working!
I've also tried the solution of Saku which has provided me before, to use the Group/Edit function, but this workaround is not what I need because I wish to upload the newer QSO on the remote log web-servers and they are 3: Hamqth, Hrdlog and Clublog.
Then so fare I'm stuck.
Thanks and regards!
PY1ZRJ
I don't know how and what's happen, but after several attempts of disabling/enabling remote logging and closing/opening the program CQRLOG, the remote logging process has been restarted by its own.
This issue happens every time I create a new log, then should be nice if the development team could be investigating and if possible would add a feature into CQRLOG which could permit to reset the QSO marked as updated value into the database.
In this way the operator would have the possibility to repeat the upload of his QSO's on the remote logging servers.
Thanks and regards, PY1ZRJ