When are lotw_qsls and lotw_qslsdate fields populated?

10 posts / 0 new
Last post
EA4GRG
When are lotw_qsls and lotw_qslsdate fields populated?

Hi all.

I usually use the upload to LoTW functionality to send the QSO which have never been uploaded to LoTW logbook and works fine. But I've just noted that lotw_qsls and lotw_qslsdate are not populated when you do this action.
The same functionality in eQSL upload populates their eqsl_qsl_sent and eqsl_qsl_sdate fields but in LoTW does nothing.

What's the scenario when lotw_qsls and lotw_qslsdate are populated?

Thanks. 73.

oh1kh
When are lotw_qsls and lotw_qslsdate fields populated?

Hi!

Lately there has been problems with lotw. Mainly downloads that fails. I think this is because of heavy use of lotw now when corvir-19 forces all to stay home. And what a Ham can do then? Keep qsos and update them to lotw.

Perhaps this is also related to not having response from lotw within timeout. (That is just a guess)

In file fLoTWExport.pas there is a procedure TfrmLoTWExport.btnUploadClick around line #95 that does the "upload" button job.
There at around line #180 database is updated with "lotw_qsls =Y" and "lotw_qslsdate = date" if the session with lotw has ended OK.

--
Saku
OH1KH

EA4GRG
Hi, thanks for the reply.

Hi, thanks for the reply.

I believed that CQRLOG LoTW export only links with TQSL binaries to generate .adi and .tq8 files to upload them (or one) to LoTW web manually later, isn't it? So I thought that lotw_qsls and lotw_qslsdate fiels are populated by CQRLOG without communicate with LoTW.

Maybe I'm wrong.

Thanks.

oh1kh
Hi, thanks for the reply.

Hi!
Just check the code I stated.
If connection finishes OK then database change is done.
This happens when you push "upload" button after successfull "export&sign"

--
Saku
OH1KH

EA4GRG
Hi again.

Hi again.

Sorry but I don't understand why I'd push "upload" button after "export&sign" when it should be on the contrary. Anyway I try again in both ways upload all QSOs and only which have never been upload and those fields are not populated nor updated.

Next the way I run:

- In QSO List:
-> button "Upload data to LoTW" (or menu QSL -> LoTW -> Export -> "Upload QSOs to LoTW web page")

- In "Export for QSO" dialog window:
-> tab "Upload to LoTW"
-> "Export only QSOs which have never been uploaded" (tried with "Export all QSOs" option too)
-> tqsl command line arguments: /usr/bin/tqsl -d -l "MyLocation" %f -x
-> push "Export & sign"
-> TQSL application opens and shows up the dialog box for certificate password
-> I always obtain an error with an invalid amateur call (a special italian SWL id in the form I1-12345) but I push "Ignore" to ignore it and continue to sign up the book
-> everything's OK and I see both .adi and .tq8 files in ~/.config/cqrlog/lotw/
-> close "Export for LoTW" dialog
-> I noted that QSO List refresh but lotw_qsls and lotw_qslsdate still the same
-> the rest of the operation is upload the .tq8 in LoTW web page, wait and I see the results.

I've just noted that ... could the invalid amateur call error avoid that commits in CQRLOG database?

Thank you very much again for your help.

Regards. 73.

oh1kh
Hi again.

The Way I do it:

Window -> qso list -> QSL -> lotw -> Export -> Upload qsos to lotw web page

Export to lotw window:

select: "export only qsos which have never been uploaded"
command line arg: /usr/bin/tqsl -d -l "Pori" %f -x

Pressing: export&sign

---------------------------------Text follows:--------------------------------------------------

Starting export to adif ...
Export to the adif file completed.
File:
/home/saku/.config/cqrlog/lotw/2020-04-02_14-45-55.adi
Signing adif file ...
TQSL Version 2.5.1 [pkg-v2.5.1]
Varmistetaan käyttäen kutsumerkkiä OH1KH, DXCC-maata FINLAND

/home/saku/.config/cqrlog/lotw/2020-04-02_14-45-55.adi: kirjoitettiin 12 tietoa /home/saku/.config/cqrlog/lotw/2020-04-02_14-45-55.tq8:ään
/home/saku/.config/cqrlog/lotw/2020-04-02_14-45-55.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ä.
Lopullinen tila: Onnistui (0)
Final Status: Success (0)
Signed ...

If you did not see any errors, you can send signed file to LoTW website by pressing Upload button

---------------------------------------------------------------------

Pressing: UPLOLOAD (as adviced in monitored text)

------------------------more text to monitor after UPLOAD pressed----------------

Uploading file ...

Size: 4010
Uploading was successful

-----------------------------------------------------------------------------------------

That's it.
Difference is that I do not have password in certificate so all goes through fast and easy.

--
Saku
OH1KH

EA4GRG
In my case "Upload" button

In my case "Upload" button are always disabled. This is the report I get (I've translated some messages from spanish):

Starting export to adif ...
Export to the adif file completed.
File:
/home/victor/.config/cqrlog/lotw/2020-04-02_22-25-05.adi
Signing adif file ...
TQSL Version 2.5.1 [unknown]
Signing using call ids EA4GRG, Entity DXCC SPAIN

Invalid amateur CALL (I1-21171) in line 2228
QSO_DATE: 20180809
TIME_ON: 2301
CALL: I1-21171
MODE: FT8
BAND: 40M
FREQ: 7.0747
FREQ_RX: 0

Invalid amateur CALL (I1-21171) in line 2480
QSO_DATE: 20180811
TIME_ON: 1322
CALL: I1-21171
MODE: FT8
BAND: 20M
FREQ: 14.0743
FREQ_RX: 0

Invalid amateur CALL (R9A-2530) in line 3151
QSO_DATE: 20180813
TIME_ON: 2216
CALL: R9A-2530
MODE: FT8
BAND: 40M
FREQ: 7.0743
FREQ_RX: 0

Invalid amateur CALL (I1-21171) in line 4105
QSO_DATE: 20190224
TIME_ON: 2057
CALL: I1-21171
MODE: FT8
BAND: 30M
FREQ: 10.1372
FREQ_RX: 0

/home/victor/.config/cqrlog/lotw/2020-04-02_22-25-05.adi: 514 QSO are uploaded yet before
/home/victor/.config/cqrlog/lotw/2020-04-02_22-25-05.adi: wrote 1 records to /home/victor/.config/cqrlog/lotw/2020-04-02_22-25-05.tq8
/home/victor/.config/cqrlog/lotw/2020-04-02_22-25-05.tq8 is ready to send by email or uploaded.
Remark: TQSL assumes that this file is uploading to LoTW
Uploading again these QSO informing to you that they have been uploaded before.
Final Status: Some QSOs suppressed (9)

oh1kh
In my case "Upload" button

Hi!

You should use filter to make those error calls as "uploaded to lotw".

First make full backup of your log.
Then
Window -> qso list -> Filter -> Create

There I think you can find all swl calls using search criteria the "minus" "-" (just one char: - )
Put that to "callsign" and check "include" press OK

You should see only all swl calls now in qso list.
(if that fails you can filter every error calls as full, one by one, and repeat group edit for each one separately)

If that is so select
File -> Group edit

Group edit window opens, there for
"field" select: "loTW QSL sent"
"value" select "Y"

Then press "apply" once.
If you have now qso list colums selected so that you see "lotw_qsls" they have chaged to "Y"
Close group edit from "cancel" button.
Disable filter pressing "Shift+F12" keys.

Now you can again do lotw upload for qsos that have never been uploaded.
This time there should be no errors and when there are no errors the upload button can be used.

--
Saku
OH1KH

EA4GRG
Hi!

Hi!

Yes! Now it works perfectly! Nice!

I've filtered the discordants QSOs, marked to Y, ... Now I can see the "Upload" button enabled and I've seen the LoTW QSOs in order.

I'm very happy with that! Thank you very very much.

Regards, 73.

k8wdx
k8wdx's picture
I just had to make a file

I just had to make a file manually and upload them again, the auto function did not work, I waited several days still nothing, made the file sent in manually all went through right away, did a group edit to show uploaded, then did download and all show up, so perhaps there is a problem with CQRlog LOTW upload function, will try again after some new QSO's,

EA4GRG, I would suggest go to LOTW site, figure out which was your last qso, then filter log by date, then export adif file to desktop open TQSL use the "sign and upload automatically function and load them that way, then when you are sure they went through, filter log again to show these qso's and group edit "LOTW S" then you 3can do your download, not sure about eqsl, as I don't really use this function, but the process would be the same. this will work until CQRlog is working again. GDX Tom...

Tom K8WDX